New Dashboard: Courses | Waitlists and Duplicate Registrations

The Campus Data Warehouse now includes a new Courses | Waitlists and Duplicate Registrations dashboard. This visualization helps campus users understand waitlist activity, enrollment capacity, and potential duplicate registrations across course sections to assist with assessing demand for course scheduling and planning.

Access the dashboard through: 

Shared folders > Courses > Courses (Non-Census) > Waitlists and Duplicate Registrations

What the dashboard provides - 

Using Academic Class and Class Enrollment data, the dashboard answers four key questions:

  1. Which courses have enabled waitlists, and how many are there?
    View the number of enrollment sections with waitlists enabled.

  2. How does the waitlist compare with enrollment capacity?
    Review enrollment capacity, waitlist activity, total enrollment, and the waitlist-to-enrollment-capacity ratio for each course.

  3. How many students have registered across Enrolled and Waiting statuses?
    For courses with waitlists, compare the number of unduplicated students with the total number of registrations across both Enrolled and Waiting student enrollment statuses.

  4. How many students and registrations are in Waiting status?
    Review unduplicated students waiting for a course and the total number of waiting registrations by course.

The dashboard also includes summary measures related to unduplicated enrolled and waiting students, students enrolled in multiple sections, and students registered on multiple section waitlists within the same course.

Highlights - 

The dashboard includes: 

  • A breakdown of enrollment sections by waitlist status.
  • Course-level waitlist and enrollment-capacity comparisons.
  • Total enrolled students and waiting students.
  • Total enrolled and waiting registrations.
  • Unduplicated student counts.
  • Identification of students enrolled in multiple sections or registered on multiple waitlists for the same course.
  • Filters for Term, Session, Academic Group, Academic Organization, Subject Description, and Academic Course Name.
  • Ability to navigate to the Class Meeting Timeblocks or Class Schedule to see meetings and section-level information about a given course.

Campus Data Warehouse dashboard titled “Courses | Waitlists and Duplicate Registrations,” showing waitlist-enabled course sections, waitlist-to-enrollment capacity percentages, and course-level enrollment and waitlist metrics for 2027 Spring.


Important scope note - 

This dashboard includes only course class sections where at least one student is enrolled. Non-enrollment sections and cancelled sections are excluded. The analysis focuses on enrollment sections because automatic enrollment into non-enrollment sections is handled through a separate process.

Interpreting waitlist counts

Students may register for multiple section waitlists within the same course and may be enrolled in one section of a course but on a waitlist for another section of the course. As a result, aggregate waitlist registration counts may be higher than the number of unique students waiting for the course.

When reviewing the dashboard, distinguish between:

  • Total registrations: every enrollment or waitlist registration record.
  • Unduplicated students: each student counted once within the applicable course and status.

This distinction is especially important when evaluating duplicate registrations and estimating actual student demand.

Optimize request -  

GC0129744 - Campus Data Warehouse: visualization on duplicate course registrations

Visualization only. 

Using Class Enrollment, create a visual that addresses the following questions:

1. How many and which courses have enabled Waitlists? (Academic Class)

2. What is the ratio between Enrollment Capacity and Waitlist Capacity? (Academic Class)

3. For those courses with Waitlists, how many unique students have registered across Student Enrollment Status Enrolled and Waiting by Course? How many total registrations by Course? (Class Enrollment)

4. For those courses with Waitlists, how many unique students have registered for Student Enrollment Status of  Waiting by Course? How many total registrations by Course? (Class Enrollment)

Note these should be enrollment sections as auto-enroll into non-enrollment sections is expected from a different process. 

Clarification note needed for dashboard and/or glossary indicating students can register to multiple section waitlists in a course thus inflating the aggregate waitlist count. 

Depending on the results and policy changes, we may need to modify other models but that is beyond the scope of this ticket.