Graduate and Professional Cum GPA Ranking by Major

The purpose of the document is to explain the features of the Graduate and Professional Cum GPA Ranking by Major query.

Graduate and Professional Cum GPA Ranking by Major
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • Ranking of graduate and professional students by descending cum GPA. You may select a percentile of students to rank.

What answers can I find?

Reports available in this query:

  • Who are the top 10% (or other percentage) of graduate students in my program?
  • How many students are in this percentile?
  • What are their names, IDs, and emails?
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:


Sample Report:
Student Ranking within the Major



This query is set to deliver graduate students only. You need to select the Term first. Select from the other criteria as you wish. Only student with a GPA based on credits earned at this university will be displayed.

After processing, the query will display the "Student ranking within the Major" page.

You may export the table to Excel for your departmental use.

Data views used:


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, top 10%, program, percentile, GPA Query Data Library   Doc ID:41673
Owner:Harriet A.Group:Query Library
Created:2014-07-07 15:59 CDTUpdated:2014-07-29 15:59 CDT
Sites:Query Library
Feedback:  0   0