This report gets sent out once the Course Selection week has ended for students, it’s sent out the day after that closes.
...
Run these queries for these terms by going to: Reporting Tools → Query → Query Viewer
UW_RS_SCH_HIST_CAP_SB | Upcoming term ex. 1235 for spring CEM |
UW_RS_SCH_HIST_PCS_SB | Upcoming term ex. 1235 for spring CEM |
UW_RS_SCH_HIST_ENRL_SB | Previous like term ex 1225 for spring CEM – only have to enter it into the top term prompt in the query – this Query pulls double duty for the Historical Data report, and it needs the three prompts. |
...
Remove all transfer credit courses (1XX, ect., but not ENGL 108X) After running the queries to excel, you can sort by the catalog number and remove any with an X – Except that ONE ENGL 108X course... which is annoying. Also remove the “OFF” “EXCHANGE” courses from the results of UW_RS_SCH_HIST_ENRL_SB.
Change the UW_RS_SCH_HIST_CAP_SB term name to “Current Enrollment Cap” and delete the top row.
Change the UW_RS_SCH_HIST_PCS_SB term name to “Current PCS enrollment” and delete the top row.
Change the UW_RS_SCH_HIST_ENRL_SB term name to “Actual Enrollment last Spring” or whatever term you are working on and remove the “Cap Enrl” from it and “Location”, which is what the cap was set to – not the actual number of students enrolled and delete the top row.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
From: To: Cc: Subject: Date: Attachments:
Good morning Undergraduate Scheduling Reps,
Since Course Selection for the Winter 2023 term has ended, we’ve run some select CEM (Course Enrollment Management) reports that you may use to assist with winter scheduling decisions. They are also saved hereon the UW Scheduling Reps team Channel.
As always, we appreciate all the great work you do. Thank you and have a wonderful week!
All the best, The Scheduling Office Team Office Team Elysia, Tanya, and Libby Office of the Registrar 519-888-4567, ext. 49983 |