Department Timetable planner

(no rating)(0)
author avatar

Created byampowell

in Whole school

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.

  • TES-Timetable-fixed-rooms.xlsx
  • Instructions.jpg
  • Lesson-numbers.jpg
Download Icon

Other

TES-Timetable-fixed-rooms

xlsx, 51 KB

Download Icon

Other

Instructions

jpg, 97 KB

Download Icon

Other

Lesson-numbers

jpg, 44 KB

About this resource
CreatedJan 2, 2017
UpdatedJan 24, 2017

By adding a School licence it allows you to share this resource with colleagues at your school. Without it, this resource is licensed for use only by you.

0 Reviews

0(no rating)
  • This resource hasn't been reviewed.