A closer look


Rotation and Allowance

This picture of the Demo School timetable should make some concepts clearer.

1. This week is greyed out because it is set to 'inactive' in the 'Term dates' tab.

2. Lunch break - this is set in 'Teaching times'.

3. Ella has two lessons at the same time only 3 weeks apart. This is OK because the default Rotation is set to 3, but closer than that is not allowed.

4. In the 'Pupils' tab Dave's rotation is set to '1' (in effect, off). This overrides the default rotation so he can come at the same time on consecutive weeks.

5. Brian also has consecutive lessons because these times are set under 'Rules', again overriding the default.

6. These two lessons clash slightly but only by 5 minutes - this is set under 'Allowance'.

7. Carly has the day off today - also set under 'Rules'.


Importing pupil data

If you have a list of pupils in a spreadsheet or in a csv file you can paste the data directly into the pupil list. The data columns (fields) should be in the order: christian name, surname, form, and lesson length. Here's a view of a typical Excel list showing the copied area:

Then click in the import area, paste (Ctrl V) and click Import. There is a reason for this awkward two-step method to do with browser security (the website can't import directly from the clipboard).

Opening a CSV file in Excel

Open a new blank document and go the 'Data' tab. There you should see a 'From Text/CSV' option. Find the CSV file (by default it will be in your Downloads folder). Then load the data. It comes in as a table with menu headers. If you don't want this right-click in the table and select 'Table>Convert to Range'.
This is also a way to see your timetable sorted by pupil rather than by time.