Creating the timetable followed the following steps in a more simplified way
Know the frequencies of each year group for classes
Make a master timetable (Year Groups corresponding to Departments, ie. Year 10 English)
Map out which teacher is teaching which class
Input the classes into the system (Skye does it manually by teacher) and mark down clashes (Room/Teacher/Class)
Resolve clashes
Test each class group (Ie. Year 8 Group 1, see if there are any missing periods/duplicated periods)
Resolve
See what can be better eg.
What classes can stay in the same room for two periods, could this be two periods where the teacher(s) not have a classroom?
Can the classes where teachers borrow classrooms be in the same classroom throughout all periods?
Can teacher changes be resolved?
Knowing the frequencies you can create an outline of what a timetable would look like. For example, knowing how many periods Year 7 have for English.
By knowing the frequencies you can start creating the master timetable or outline of what each year group is doing. For example, we can see here Monday Week 1 (Aqua standing for Week 1) that:
Year 7 does maths
Year 8 does English
Year 10 and 11 do their 4th option (WILD)
Year 12 and 13 do their
This then translate to department based master timetables that get copied and pasted to teacher timetables to find and replace classes.
For example, find replacing "7EN" to 07EN01 for Riley ANDERSEN
Teacher clashes are resolved by finding teachers that can help teach this subject and are free (Eg. Chemistry teachers for MYP Maths). Some clashes require the handover of tutor groups, in which we try our best that this happens.
As teacher timetables are manually entered, they are seperated with a slash.
Room clashes are found with a formula on a separate sheet. Before this, rooms were marked on teacher's timetables
09DT01 clashing with 11DT01 in TG02 (2022 initial)
B210 being used by LW (Lou WRIGHT) for 10AR01 marked down on the room owner's timetable
This allows one off periods (Once a week/Once a fortnight) to be inputted, especially when teachers share the same class. This cannot be done if we did class based timetables (Eg 7B @ F201 Music [Zoe BELL]) and that timetable systems that are free (like Prime Timetable) cannot do functions like these.
Nowadays, this master timetable view by year is done automatically
MYP Timetable being made by the class (4 House System 2020)
2024 YEARCLASS OVERVIEW
The only disadvantage is you cannot change a whole series of classes that are shared but this issue is not big from creating "CLASSBUILDER" to serach classes up.