Producing historical data reports
...
Run the following Query to Excel for the past three like terms: UW_RS_SCH_HIST_ENRL_SB – All three terms in one query (doesn’t matter the order)
...
Delete the top row
Highlight the new top row and go to data tab to turn on filters
Delete blank row if there is one (sometimes there is and sometimes there isn’t)
Select everything by selecting top left corner triangle, double click in between the 2 rows to resize the rows (then it’s all on one page)
Go to location the Location column filter: select the exchange courses only and then delete them (If asked if other Off courses should be removed – no as they are still courses)
Column and Row order should already come in sorted correctly – doesn’t affect results even if it isn’t
...
Select only the data, then go the Insert tab, select pivot table, ensure “yes to new worksheet” is selected, then just click ok
In the Pivot Tale Table Fields, as seen below click and drag the options to the boxes except with the exception noted in step C:Note that you the information box below.
| Info |
|---|
You do not drag over “Values”, it will appear once the Sum of Enrollment and Sum of Cap Total are dragged down |
...
After Pivot Table is created:
...
Once it’s checked send to UTC Staff (University Timetabling Committee) – you can find a list of UTC members on the UTC Teams page, go to manage team and a list should come up.all undergrad and graduate scheduling reps.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
From: To: |
...
Cc: |
...
|
...
Subject: Date: Attachments: |
...
.xlsx
Good morning |
...
scheduling reps! The Spring 2023 scheduling cycle begins next week with the Prior Term Copy run, here is the historical information for prior like terms |
...
so |
...
you can |
...
prepare for the upcoming cycle. It's also posted on the UW Scheduling Reps teams channel here: (insert direct link from Teams to the doc) Thank you!
The Scheduling Office 519-888-4567, ext. |
...
49983 |