Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Tip

Complete an ITicket to obtain access to Entrinsik Informer Reporting Tool if you are not already an Informer user. 

Statement

Informer is used at Valpo to retrieve and explore data from Colleague. These instructions walk users through running the "DEGREE_PLAN_TERMS Future Term Courses Planned by Students in Self Service - DEPT" report. This report lists the classes students have planned to take. It is very useful to Department Chairs as they make decisions about which classes to schedule each semester.  

Step-by-step Guide 

Table of Contents
minLevel2
maxLevel6
outlinefalse
styledefault
typelist
printabletrue

Run the Informer Report

1. Navigate to the Informer Login Page

2. Enter Valpo Username and PasswordImage Removed

...

3. Reports Listing page appears. A list of the reports the user has been granted access to will appear.Image Removed

...

4. This report may be quickly found by typing 'planned' in the Reports Listing field.Image Removed

...

5. Click on the yellow star to save the report as a favorite (Report will now appear in "My Favorites" filter). Image Removed

...

6. To launch the report, click on the Launch icon next the report.Image Removed

...

7. Enter the first letter or first few letters of the department for which you want to run the report (e.g., cba for College of Business, M for Math dept., ENGL for English dept.).

...

Export Results to Excel

10. To export results to excel, click on Export Results

Warning
title

Protect Student Data

Please remember student data should be used for University purposes only. It is not to be shared or stored outside the University.

11. A menu of options will appear. The most commonly used option is Excel Comma-Separated Values (.csv)Image Removed

...

12. Select Excel Comma-Separated Values (.csv). Output options appear. Make sure the following selections are made:Image Removed

...

13. Click on Export

14. The report will download automatically. Double click to open.Image Removed

...

15. Highlight the entire Excel Spreadsheet by clicking in left corner next to the A.Image Removed

...

16. Next, from the Home tab on the Excel menu bar, click on the drop down menu on Format and select AutoFit Column Width. This will ensure every column of data easily appears.

...

3. The Create Pivot Table box will appear in a new tab. The following selections will appear: Image Removed

...

4. Click OK

5. You may now select PivotTable Fields to sort the data. This is done by dragging the data fields to the appropriate areas.

For this report, we recommend the following selections (Course Name, Planned Term, Student ID) in the areas pictured below:

You may include Last Name, but might not get a complete count if you have any students with the same last name

Image Modified  Image Modified

6. The Pivot Table (Sheet 1) will now list the courses, the planned semesters, and how many students plan to take the courses in each semester.

Image RemovedImage Added

Want to know more about Pivot Tables? Try this LinkedIn Learn course

...