Grade Reports

The purpose of the document is to explain the features of the Grade Reports query.

Grade Reports
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • Select individual final grade reports by your school, college, department, or special population. Grade reports can be viewed and printed for any past term.

What answers can I find?

Reports available in this query:

  • For a particular semester, what grades did students in my program get?
  • Do they belong to any student groups?
  • What are their GPAs?
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:


Sample Report:
Grade Report-Single



There are three reports in this query.
"Grade Reports - Single" delivers a single student's grades report per page.

"Grade Reports - Multiple" delivers as many students per page as will fit depending on the lenght of each students course list. This is often only two students per page.

"Grade Report - Pivot" and "Grade Report - Pivot by Student Group" deliver a more compact version for better look at the group (cohort) of students selected at the start. Pivots also export to excel easily.

In addition there is a "Grading System" page that is a direct copy of the explanation of the grading codes used on the reports.

A Note About Names
Enrolled students who have changed their name in ISIS will find that their grade reports will reflect their current name for past terms prior to the name change.

Data views used:

  • Retention Student
  • Retention Plan
  • Retention Stdnt Group
  • Retention Semester History
  • Retention Course History
  • Stdnt Plan Multiterm

Search either the InfoAccess Data View page or the Enterprise Performance Management (EPM) Data Warehouse page for data definitions to the data views used in the Query Library.

Keywords:graduate, enrolled, current student, school, college, department, special population, grade reports, student group, GPA, grades Query Data Library   Doc ID:41671
Owner:Harriet A.Group:Query Library
Created:2014-07-07 15:43 CDTUpdated:2014-07-29 15:59 CDT
Sites:Query Library
Feedback:  0   0