Purpose
This The Course Review Tool, CRT report is used to track key course metrics (# of courses, enrollment in courses, billing units, etc.) by the term and waitlist summary of the current term.
Steps:
- Log in to the Power BI report:
- Select the 'SPS Enrollment' App
- Click on the 'Course Review Tool' CRT report
Please Note:
There are four report pages in the CRT report.
(1) All Sections - Complete list of courses offered in a term
(2) Course Summary - Number of courses offered by the Academic Departments and their start date and the Subterm code
(3) Waitlist Summary - Waitlist Headcount by Course, Program, and School.
(4) Waitlist Management -
...
Waitlist page to Manage the Waitlist.
4. Select a Term to view the Courses from the 'All Sections' report page report:
5. Select the Filters to narrow down your search
Description of the above report filters:
(1) Department Name: Name of the course offering Academic Department
(2) Enrollment Range - There are three filter options (1) Enrollment less than 10 and greater than 0 (2) Enrollment is zero (3) Enrollment is more than 10
(3) Academic Credits - The actual credits the students took
(4) Billing Credits - The credits billed to the students
(5) Course Begin Date - The class begin date
(6) Course Enrollment Status - There are three filter options (1) Full - F (2) Blocked - B (3) Open - O
(7) Method of Instructions - There are multiple filter options: In-Person, Online Only, Hybrid, etc.
(8) Subterm Code - An alphabetical letter is used to identify the courses, for example, A, B, C, K, L, M, N, O, X, etc
CRT Report Demo:
