This is the process that we use to determine which sections are for an actual group of students vs which ones are simply meant to not be in conflict. It takes a few days to complete this whole process, and is very manual.
First the Timetabler - Determining reserve order should be finished.
Second the Timetabler - Reserve download procedure should be done.
Determining which reserves are driving enrollment
In Quest
Run this query to Excel: UW_RS_SCH_RSRV_CHK_FOR_CC_SB
Enter in term and term start date
1st year Engineering do not worry about it as they enroll their own students. If only one section you do not need to worry about it. If every section is fully reserved with same reserve, or partially reserved with same reserve do not worry about it. If there’s multiple sections and none have a reserve, do not worry about it.
You are concerned with reserves that are driving where the students go.
Highlight the ones that matter on the spreadsheet.
In Timetabler
Run a My View under “Course Combinations with notes” sort it by Course ID, using the courses that were highlighted from the spreadsheet where the reserves are driving where a student group should go, in the filter bar at the bottom of the my view enter in each course, if there are courses that come up in a combination (not all will) you select the courses – batch edit and change them from “to spread things out” to “For Actual group of Students” move on to the next course from your spreadsheet.
Once you are done with the spreadsheet, you can get rid of it – you will never see it again.
Make sure all the Program and Levels are the same in the Course Combinations. To do this you have click on each course combination. Also ensure that there are no section numbers entered in the course combinations at this stage.
The next step is going through the Course Combinations and sort it by the Student Count, ones with 1 you do not need to worry about and leave the “Default Academic Block Type” as is. You now must go through all the combinations with a student count higher than 1 and determine if it should stay as the student count number and be changed to “For Actual group of Students” or be changed to 1 and the “Default Academic Block Type” then should not be changed if it is staying as 1.
Once all the reserves have been brought in and you have determined that it is for an actual group of students.
This next part will take a few days to complete.
In My Views → Course Combination → Course Combinations with Notes
Sort by department ID and Course Combination, filter out the “to spread things out” Academic block type ID and only work on the “For Actual Group of students” combinations.
Double click on the first one under course combination requests
Right click on the top course and select “open viewer” on General Information on new window double click on Level which opens up another window (we will call it “level window”, we will get to that)
Then click on Course Characteristics (this is where ONE reserve gets added, or if there is no reserve or one does not apply chose “Space” under “Characteristic”.
Then in the Level window [Program: subject] find “Alternative Course Request-Course Characteristics”
Add above reserve or space (do not repeat them – you will get an error if you do though) in the “From” column and under “To” write RESALL rank is 100 and check Allow Partial Move.
Once all reserves are added for the courses in the course combination put the marker on the course combination window and move on to the next.
NCC’s (No Course Combinations)
Once all assigned -> check for courses with multiple sections and put them in an academic block.
Have a second instance of Timetabler open and logged in as another user (super?) so that you can see if they are already fully forced or not.
Run My View: Course -> Course without combinations without student…
Only care about the “No Course Combinations” ones sort by that. Do not bother with courses that are fully forced (typically Engineering First year) this is the reason that you have a second timetabler window open. Open course from My View and then double click on Department -> Click on Academic Blocks -> Add new under it and under “ID” it should be called: “NCC Course” put block size as 1 and the Type is “to spread things out”. Under components attach the components of the course that need the academic block.
MULTIPLE SCREEN SHOTS
Why do we need NCC’s?
There is nothing in the system that will not allow for a lecture and tutorial to be scheduled at the same time. We create them so they do not schedule in conflict. Therefore, we do not care about fully forced courses as they already should be conflict free. Could have two instances of Timetabler open and check one while create in other.
Disable Components:
Under Components sort by section (081) select all and batch edit – check the “Disable for Assigning” and “Disable for Academic Block Builder” – We do not do this anymore as the CEL sections should be viable options, also sometimes they are the only option.
For Off Campus -> Secondary Files -> then Course Characteristics
-> Off Check the “Disable for Assigning” and
-> “Disable for Academic Block Builder”
Not all “Off” campuses should be disabled, there are some PHARM courses that are “Off Canada” and local so they should remain active, you must go through them – ones abroad or in Italy – disable those.
Finally Take a back up for the TimeTabler database call it “Before running ABB”
System Administration -> Backup right click “Add New…” name it appropriately and click back up. That is it.
Check the settings and make sure they look like this:
The logic behind the settings can be found here.