Course Waitlist Report

This article covers how to run and interpret the Course Waitlist report on the Course Enrollments dashboard.

What does this report show?

The Course Waitlist report shows a summary of courses with students on the waitlist, dropped, enrolled and percentage enrolled to capacity. Report can be filtered by college, department and term. The department values in the filter are cascaded from the college. The report is available in pivot and graph format. By selecting the View By drop down, the user can switch between the Pivot Table and Graph. The user can navigate to the class detail information by clicking on Class Number. Also, the user can identify the person id of the students who are in the Waiting Student Count.

Accessing the Report

1. Log in to the campus portal and access TitanInsights.

2. Click Shared folders to access dashboards/reports.

QuickSight home page

3. Click on the Student folder.

dashboard folders

4. Select Course Enrollment.

course enrollment folder

5. Select the Course Enrollment dashboard.

course enrollment dashboard link

6. Then click on the Course Waitlist tab.

Course Waitlist tab

Report Overview

When you access the report, your personal filters/settings for the dashboard/report appear. If you have not set up your personal filters, the system defaults will automatically populate.

Course Waitlist report

Report Filters

The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.

1. Click on the Controls section to expand the filters.

controls section with filters

2. Make your selections for each filter as necessary.

Report filters

Filter Descriptions

Filter
Description
View By Choose to view the data as a pivot table or as a graph (chart).
Term The specific semester/session for which you want to view data.
College The college(s) you want to include on the report.
Department The department(s) you want to include in the report. The values in the Department column are filtered based on the College value, so when you choose a College, you will only see Departments that are in that College.

Reading the Chart (Graph)

The Course Waitlist graph shows each course section with waitlisted students broken down by the percentage of students that are dropped, enrolled, or still on the waitlist.

Note that the graph will show a maximum of 50 course sections. To view all of the course sections that match your filters, view the Pivot Table.

Course Waitlist Graph

Hover your mouse over each portion of each bar to see the specific percentage.

Reading the Pivot Table

The Course Waitlist pivot table shows each course section with waitlisted students along with the enrollment capacity, waitlisted student count, dropped student count, enrolled student count, and percentage enrolled to capacity.

Course Waitlist Table Results
Column Descriptions
Column
Description
Academic Organization The name of the college or academic group.
Course Desc The name of the course.
Catalog Number The course code from the course catalog.
Class Number (Drill Down) The class schedule number assigned to the course section. Drill Down denotes that you can drill down to detail for the class 
Class The course and section code from the class schedule.
Section The section of the course.
Enrollment Capacity The number of enrolled students that the course section can support.
Waiting Student Count The total number of students currently waitlisted for the course section.
Dropped Student Count The total number of students who have dropped the course section.
Enrolled Student Count The total number of students currently enrolled in the course section.
Percentage Enrolled to Capacity The enrolled student count divided by the enrollment capacity determines what percentage of the enrollment capacity has been reached.

Additional Detail

You can view Class Detail or Waitlist Detail for each course section.

1. Click on a Class Number in the table to view additional detail.

Waitlist Summary Table Results

2. Select Class Detail or Waitlist Detail.

Access Enrollment By Academic Group Detail

3. The Class Detail will open in the same browser tab/window. You can now review the details for the selected course section.

Note that you will need to use the horizontal scroll bar below the table to view all of the available data.

Class Detail
Available Columns
Column Description
Term Desc The specific semester or session.
Institution Description The name of the educational institution (CSU Fullerton).
Academic Group Description The name of the college/academic group or subgroup.
Academic Career Description Indicates whether the course is part of an undergraduate or post baccalaureate program.
Subject Description The name of the subject area for the course.
Course Description The name of the course.
Course Code Course ID
Course Offer Number Course Offer Number
Catalog Number The catalog number of the course.
Class Number The class schedule number assigned to the course section.
Class The course code from the course catalog.
Section The section of the course.
Primary Instructor Person Name The full name of the instructor assigned to the course section.
Session Code The session code of the course.
Session Description The type of academic session.
SSR Component Description This identifies the SSR component of a course: Discussion, Lecture, Seminar, etc.
Enrollment Status Description The current enrollment status of the course (Open, Closed).
Class Status Description The status of the class (Active, Stop Further Enrollment, Tentative Section or Cancelled Section).
Class Type Descr The type of class (Enrollment Section, Non-Enrollment Section).
Associated Class The associated class offerings are linked to make a single course offering.
Waitlist Daemon Description The long description for the Waitlist DAEMON.
Automatic Enrollment Waitlist This Auto Enrolls Student from the Waitlist.
Consent Type Required The code indicating the Department or Instructor Consent.
Consent Description This is the long Description for the Consent.
Enrollment Capacity The enrollment capacity of the Class
Waitlist Capacity The waitlist capacity of the Class
Minimum Enrollment Number The number of seats between students during the final exam.
Enrollment Total The total number of students enrolled as part of the reserve capacity sequence
Total Wait List The waitlist total.
Campus Description This is the long description that identifies a campus.
Instruction Mode Description This is the long description for the mode of instruction.
Class Start Date The Class Start Date.
Class End Date The Class End Date.
Start Time The Class Start Time.
End Time The Class End Time.
Room The facility or room used for the class.
Cancel Class Date Class Cancelled Date
Primary Instructional Section The primary instructional section number
Holiday Schedule Description This is the long description of the holiday schedule for a given session
Level The catalog Number Level. For e.g. 100 level, 200 level, etc.

4. The Waitlist Detail will open in the same browser tab/window. You can now review the specific students who are on the waitlist for the course section.

Note that you will need to use the horizontal scroll bar below the table to view all of the available data.

waitlist detail
Available Columns
Column
Column Description
Term The specific semester or session.
Academic Organization Desc The name of the college/academic group or sub group.
Academic Organization The name of the college/academic group or sub group.
Course Desc The name of the course.
Catalog Number The catalog number of the course.
Class Number The class schedule number assigned to the course section.
Primary Instructional Section
Enrollment Status Indicates whether the student has been enrolled in the class or is still waiting to be enrolled.
Person ID The Campus-Wide ID (CWID) of the student.
Student Enrollment Count

5. To return to the main report, click on the double left arrow button until you see the Course Waitlist tab.

scroll through report tabs

6. Click on the Course Waitlist tab to return to it.

return to waitlist summary

Need More Help?

For technical assistance with TitanInsights, please contact the IT Help Desk at [email protected] or 657-278-7777.

For questions about getting access to TitanInsights or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.