Link to University of Wisconsin-Madison home page


Repository for Administrative Data and Reports

Undergraduate Cumulative GPA Ranking by Academic Plan IDE

Last Updated

A ranked list of students, based on their cumulative GPA. The user may define a number of filters to reduce the ranked population to one of interest.

Report URL
Data Cookbook URL (requires authorization)
Data Domain(s)
Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
Data View Information
Update Schedule
Data refreshes weekday mornings.
Responsible Office
Office of the Registrar
Important Notes

Student GPAs in this workbook come from an operational data source and are not necessarily finalized. For instance, a cumulative GPA accessed at the beginning of a term is likely the cumulative GPA for the student through the end of the prior term. Additionally, GPAs are adjusted in the data source as grades become available, so a student's GPA may not be finalized until after the end of the term.

Including academic plan information introduces multiple rows for students if the user does not define a specific academic plan(s). Selecting 'No' in 'Include academic plan information?' will hide academic plan and academic plan type from the results and allow for a more accurate ranking with one student per row.


Name Functional Definition Data Domains
Academic Level

Indicates whether a student is an undergraduate, graduate or professional, or special student. For undergraduates, students are freshman, sophomore, junior, or senior based on accumulated credits, not the duration of time at the University.

University of Wisconsin - Madison
Academic Plan

An area of study--such as a major, minor, or certificate--that is within an academic career.

Academic Planning, Student Record
Academic Plan Group

A code assigned by UW-Madison for a major. The major may be offered across multiple degree levels and/or by multiple school or colleges.

Academic Planning, Student Record
Campus ID

This is simply a unique student identifier (10 digits). It may occasionally change at the student's request. It is not the same as ID in the Student Information System (SIS) or ID in the Human Resources System (HRS).

Student Record
Cumulative GPA

The grade point average for all courses completed for an A-F grade at UW-Madison within a career; cumulative grade points divided by cumulative credits taken for GPA.

Academic Planning, Student Record
Full-Time/Part-Time Student Status

Full-time/part-time student status is based on credit load and varies by course of study. Undergraduate and special students are full-time if they are enrolled in 12 or more credits; part-time if they are enrolled in fewer than 12 credits. Most master's and research doctorate students are full-time if they are enrolled in 8 or more credits; part-time if they are enrolled in fewer than 8 credits.

University of Wisconsin - Madison
Plan Type (Academic Structure)

A code indicating the type of academic plan, related to to the degree or credential awarded to students who complete it.
CAP = Capstone
CRT = Certificate
MAJ = Major
MIN = Minor (Graduate School or Education)
TCH = Educator Certification
NON = Non-degree
HON = Honors
SP = Specialization
PRP = Pre College Program

Academic Planning, Student Record
Student Name

Student's preferred name (Last, First, Middle). Prior to the fall of 2014 it shows the primary/legal name.

Academic Planning, Student Record
Student Rank An ordered list of students from highest GPA to lowest GPA. Student Record

A period of instruction: Fall, Spring, or Summer.

University of Wisconsin - Madison