This spreadsheet is for any teacher that needs a department timetable. Colour coding, capacity and loading calculations, and lesson numbers are all tracked automatically. It counts lessons by set, year group and subjects within a department and has space for 15 members of staff. Instructions and an example are included. The other two files in the download are example images and can be deleted.
It is easy to:
1) generate individual timetables for staff accounting for TLR, ppa, mentoring, NQT and other types of non-teaching lessons (see image)
2) adjust timetables mid-year as staffing changes
3) see any missed classes or double-staffed classes
4) adjust patterns through the use of colour.
Hopefully very easy to use - I created it and have found it invaluable as a Head of Department. All suggestions for improvements are very welcome. I also have another version that tracks rooms and can add more staff spaces if requested.
It is easy to:
1) generate individual timetables for staff accounting for TLR, ppa, mentoring, NQT and other types of non-teaching lessons (see image)
2) adjust timetables mid-year as staffing changes
3) see any missed classes or double-staffed classes
4) adjust patterns through the use of colour.
Hopefully very easy to use - I created it and have found it invaluable as a Head of Department. All suggestions for improvements are very welcome. I also have another version that tracks rooms and can add more staff spaces if requested.
Something went wrong, please try again later.
this has been really useful just wish it would do a 2 week timetable
Does not work. Scroll down menu doesn't select any classes. Waste of time.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.50