Courses Completed to Satisfy Undergraduate Major Requirements

Last Updated
08/12/2022
Description

This visualization provides information about how and when undergraduates completed their Major Requirements. It provides data about course counts and Time to Degree for graduates since Summer 2013, according to Major Requirement and Sub-requirement, as well as data about when in their careers at UW-Madison students completed those courses and Requirements/Sub-requirements.

Report URL
https://tableau.wisconsin.edu/#/views/CoursesCompletedtoSatisfyUndergraduateMajorRequirements/HomePage?:iid=1
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/33606/versions/63068
Data Domain(s)
Academic Planning, Student Record
Access Restrictions
UW-Madison Employees (NetID Required)
Data Source Information
Badger Analytics, InfoAccess
Update Schedule
No Scheduled Updates
Responsible Office
AIM, College of Letters and Science
Important Notes

Because of current data availability, this visualization is limited to Degree Programs and Additional Majors granted by L&S and CALS.

Dashboards in this Workbook include coursework of graduates since Summer 2013 (including transfer students) and all course credit (including transfer, credit by exam, AP, and study abroad credit attached to courses in the student record). Coursework not taken at UW Madison may be excluded via the “Select Courses to Include” filter. In all workbooks except for “Majors Counting Courses,” filters are shared. Therefore, changing filters in one dashboard will automatically change the information shown in the other two dashboards.

Additionally, in those three dashboards enrollments for students completing past versions of the curriculum may be included or excluded via the “Major Catalog Year, Last Term” and “Req. Catalog Year, Last Term” filters. All versions of the Major/Requirement are included in “Majors for which Courses Satisfied Requirements.” When switching between Majors, these filters may need to be adjusted if particular Major/Requirement versions were excluded in the previous Major. When moving from a Major with Named Options to another Major, the 'Named Option' filter must be reset to the '----' (no option) value.

All offerings of active Crosslisted courses are listed throughout the visualization under a single offering (Subject and Catalog #), and enrollments in all of those offerings are combined. Offerings of inactive Crosslisted courses are not combined, and are represented by the Subject and Catalog # under which the student registered.

Data Source

Information about the courses students took and the Requirements those courses satisfied is taken from batch DARS (Degree Audit Reporting System) audits warehoused within the following Badger Analytics tables:

BASP_DARS_JOBQ_RUN.T0
BASP_DARS_JOBQ_REQ.T0
BASP_DARS_JOBQ_SUBREQ.T0
BASP_DARS_JOBQ_COURSE.T0

DARS batch audit data does not contain course cross-list information, and so Course ID and cross-list information is taken from the following InfoAccess views:

UW.COURSE_CURRENT
UW.COURSE_OFFERING

Information about student's degrees (such as Award Completion Term and Time to Degree) are taken from:

UW.RETENTION_AWARDS_MAIN
UW.RETENTION_AWARDS_PLAN
UW.RETENTION_AWARDS_SUBPLAN

Years Enrolled at UW-Madison (UGRD) is calculated using term-by-term information from:

UW.RETENTION_SEMESTER_HISTORY

Information about Major and Requirement versions is taken from the DARSP (DARS Production server) encoding tables:

RGDARS.DPROG
RGDARS.DPROG_REQ
RGDARS.REQ_MAIN

Definitions

Name Functional Definition Data Domains
Academic Award Completion Term

The academic term in which an academic award was granted.

Academic Planning, Student Record
Undergraduate Student An enrolled student who is pursuing a degree program that leads to a bachelor's degree. Student Record
Catalog Number

A code associated with a course in the course catalog.

University of Wisconsin - Madison
Subject

A grouping of courses, approved by faculty governance, within related academic areas.

University of Wisconsin - Madison
Academic Award School/College

School or college of the academic award. In general, each academic award is associated with a unique academic plan, and each academic plan is part of a unique academic program, and every academic program is associated with a unique school or college. "MSN"/"UW-Madison" is used when an academic award has no school or college associated with it (such as an individualized major or special graduate committee award) or for an additional major.

Academic Planning, Student Record
Academic Award Program Academic program associated to the academic award. Academic Planning, Student Record
UW-Madison Academic Calendar Year

The academic year as defined by the UW-Madison Faculty's Academic Calendar, governed by FPP (https://secfac.wisc.edu/academic-calendar/). A UW-Madison Academic Calendar Year consists of sequential Fall, Spring and Summer Terms.

Academic Planning
Catalog Year and Term

The UW-Madison Academic Calendar Year and Term that determines the version of the curriculum (and set of Degree Requirements) that applies to a student. A student’s Catalog Year and Term is determined by rules set by the School/College offering the degree program. Different Catalog Year and Terms may apply to different Degree Requirements, subject to School/College policy. For instance, the Catalog Year and Term for an undergraduate student’s General Education Requirements may be determined by matriculation to any institution of higher learning, whereas the Catalog Year and Term for Major Requirements may be determined by the declaration date of the Major.

Academic Planning
Degree Requirement

A curricular condition for completing a Degree. Requirements may be classified as General Education Requirements, Major Requirements, etc. according to their roles within the Degree.

Academic Planning
Degree Sub-requirement

A curricular condition for completing a Degree Requirement.

Academic Planning
Degree Requirement, Last Year and Term

The Last Catalog Year and Term in which a Degree Requirement applies.

Academic Planning
Years Enrolled at UW-Madison (UGRD)

The number of years an undergraduate student has been enrolled at UW-Madison as a degree seeking student. Two Fall/Spring terms comprise one year, with a Summer Term enrollments counted as being in the previous Spring Term. Unlike "Fall and Spring Term Count", this assigns a Year count to every term in which a student was enrolled.

Academic Planning
Time to Degree

Elapsed Calendar Time to Degree in years from academic career matriculation term start date to degree completion term conferral date. This is displayed to three decimal places.

Academic Planning, Student Record
Crosslisted Course

A course which is offered under multiple course subjects.

University of Wisconsin - Madison
Academic Award Plan Code Name of the plan code associated with the award. Academic Planning, Student Record