Department Timetable planner

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.


Save for later
  • TES-Timetable-fixed-rooms.xlsx
  • Instructions.jpg
  • Lesson-numbers.jpg

About this resource


Created: Jan 2, 2017

Updated: Feb 22, 2018


xlsx, 51 KB



jpg, 97 KB



jpg, 44 KB


Report a problem