E10 - Construct: Magic squares method

Modified on Thu, 14 Aug at 12:54 AM

Info This document follows on from the document E10 - Timetable Construction Preparation Checklist.
It is very important that this document has been referred to prior to beginning to construct a timetable. 
There are two methods to add classes onto the Master grid. These are:
  1. Magic squares method
  2. Add classes method


A major consideration when choosing which option to use is by how the lines were generated.
  1. If lines were not created cohesively, then the Magic squares method may be used.
  2. If the lines were created cohesively, (either using multi-year datasets or ‘timetabling around’), then the second method (Add classes) will be used.
Info E10 advises that lines should be generated cohesively wherever possible. This can be discussed with a Timetable Specialist if required, as generating good cohesive lines goes a long way in achieving a successful timetable. 

Magic squares method
The Magic squares method will try to find a way to bring together each year level's independently generated lines in the Master grid. It will clear any previously assigned staffing (except where classes are hard coded to teachers) to look for a successful staffing and timetabling solution.
It is used when lines have not been generated in multi-year datasets or by using the 'Timetable around' feature. 

Add classes method
As the lines were generated cohesively across multiple year levels, the classes are able to be confidently staffed and timetabled onto the grid with no clashes (barring part timers). This methods involves adding each year level’s classes, bit by bit, onto the Master grid, and analysing at each step. It retains all staffing previously put in place.

Notes This document will outline the general process of building a timetable in the Master Grid using the 'Magic squares' method. The second method is outlined here: E10 - Construct: Add classes method 

Magic squares method


Step/ActionNotes
CTRL+Q
Ensure you have achieved the champagne bottle before starting (Grid > Check everything or CTRL+Q)
Also check:
  1. Teacher part timer requirements have been updated
  2. Class data does not contain any old information in TeacherPref or RoomPref fields
  3. Class data contains the required spreads for all classes
  4. Subject rooms correctly reflects the rooming options and preferences for each subject.
Master grid
  1. Go to Grid > Master Grid F11 (You may like to ‘Favourite’ this screen, as you will be viewing this screen a lot!)
  2. Ensure ‘Best timetable’ is highlighted in blue.
Magic squares
  1. Click the Construct button on the action bar.
  2. Go to the Magic Squares tab.
  3. Select Yrs 9-12.
  4. Change the ‘Periods per typical line’ and ‘Number of typical lines’ to match your senior classes.
  5. Click Apply magic squares.


Analyse results
  1. Look at all the timetables that have been produced and each of their their scores. The grids with the lowest penalty scores display first and are usually the best ones.
Staff classes
  1. Select a preferred grid and go Staffing > Staffing tab > Go.
    E10 will assign staff, within your Subject teacher sets, and shuffle classes around to find a solution.
You may perform this action with several different grids to compare results and find the best one.




Analyse results
  1. Click on the Score to see the results.
    Turn on 'Classes with fallback teachers' to see if any fallback teachers were assigned and decide if this is ok to proceed with.


Select a grid
  1. Select the best grid to proceed with and select Keep.
Assign periods
  1. Go to Construct > Periods > Assign to remove the hash symbols and see the grid codes along the top.

Improve
  1. Go to Improve > Improve tab > Start. Let it run for a few minutes, or until there is no more improvement in the score being shown.
    *Refer to the link at the bottom of the document on solving clashes if clashes remain.

Click on the small arrow in the pop up box to see the changes E10 is attempting.


Add remaining classes
  1. Go to Construct > Classes > select the + symbol > Add
  2. Enter 8 into the Selection field
  3. Add. 
Improve
  1. Improve to fix any clashes and optimise. 

Add remaining classes
  1. Repeat the above two steps for each additional year level in the file, adding and Improving at each step.
Other tools
There are some further options on how classes can be added to the grid, apart from by year level. As the timetable develops, and if problems are occurring, it may be best to switch tactics in the order of adding classes.
  1. If you have classes of a particular faculty that are often hard to timetable, consider adding these classes at an early stage by selecting ‘Classes of faculty’ and entering the exact Faculty name into the Selection field.



  2. Class codes: Particular classes can be added, eg 7SCIA. Asterisks serve as wildcards.
    Eg add all 7SCI classes by entering 7SCI*, or *SCI* to add any year level with a course code of SCI.



  3. Year-long classes: Sometimes adding the year-long classes first can be helpful.



  4. Only classes with Double periods: May be used if school wants to first add the classes requiring doubles to identify if there are any issues with classes getting their double requests.



Setting flexible part timer days off

At some point as the timetable develops, we need to set the part timer days off. When exactly to do this is a tricky point, as each file and part timer requirements are different. Keep in mind – once a teacher’s part time days off are set, E10 timetables their classes around the day/s off. E10 does not attempt to move the day off if it would better suit the timetable as the timetable continues to shuffle around the grid. Therefore, we do not want to set part timer days off too early.

Staffing > Part-timers > Set days off

  1. ‘Only where forced’: This will assign only teachers where there are no options as to which day they have off. When using this option, repeat this as new year levels are added. Improve to solve any resulting clashes.
  2. ‘Only where there are few choices’ or ‘Only where the teacher is partially on the grid’: This will assign only teachers where their timetable is developing. When using this option, repeat this as new year levels are added. Improve to solve any resulting clashes.
  3. ‘All part-timer days off’: If all classes are on the grid, then this can be used. Improve to solve any resulting clashes.
Info It is possible to set the part timer days off, but, as the timetable build proceeds, later clear the set days off, then set them again as the grid further develops. 

Health Check

Check the Health Check summary screen regularly throughout the construction process.


The Summary page provides a very helpful at-a-glance listing of issues, and each issue may be clicked on to further examine the details. In particular, check:
  1. Clashes > Teachers
  2. Teachers > Busy days
  3. Classes > Spreads (There is a balance between getting a clash free timetable and having the classes receive the spread they wanted.)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article