Student Course Grades IDE

Last Updated
08/12/2022
Description

A list of courses and grades for students based on user-defined criteria.

Report URL
https://tableau.wisconsin.edu/#/views/StudentCourseGradesIDE_0/StudentCourseGradesIDE
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/30428/versions/58550
Data Domain(s)
Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
InfoAccess
Data View Information
RETENTION_COURSE_HISTORY, RETENTION_PLAN_HISTORY, RETENTION_SEMESTER_HISTORY
Update Schedule
Data refreshes Monday mornings.
Responsible Office
Office of the Registrar
Important Notes

This IDE does not include information on study abroad students. The 'Include Academic Plans?' field toggles whether to include academic plan information in results. This field exists to minimize row duplication if desired by the end user. If 'No' is selected, warning text informing the user that academic plan information was not included in results appears in the academic plan field.

Definitions

Name Functional Definition Data Domains
Grade The grade the student received in the course. Academic Planning, Student Record
Course Credits Number of credits a student earns for successful completion of the course. Academic Planning, Student Record
Term Credits Total number of credits a student is enrolled in for the term. Academic Planning, Student Record
Career (Academic Structure)

A broad grouping of students related to their degree objectives and admitting office. Used for tuition charges, awarding financial aid, grading scales and other operational functions.

Academic Planning, Student Record
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
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
Catalog Number

A code associated with a course in the course catalog.

University of Wisconsin - Madison
Course Title

The official name of the course.

Academic Planning
Academic Plan

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

Academic Planning, Student Record
Plan Code (Academic)

A code representing an approved academic offering such as a major, minor, or certificate within an academic career and program.

Academic Planning, Student Record
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
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
School/College of Academic Plan

Indicates the school/college that has ownership of the academic plan.

Academic Planning, Student Record
Term

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

University of Wisconsin - Madison
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