Teacher Loads: Allocations, Part-Time Allowances & Over-Timetabled Staff
This lesson is part of the course
In this lesson
You total each teacher's timetabled periods from a long allocation list with SUMIFS, set part-time allowances from FTE, calculate who is over or under their allowance and flag the over-loaded teachers with a rule.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Curriculum Model: Classes per Year Group, Teacher Periods & Staff Needed Locked
- Elective Requests: Which Courses Run, How Many Groups & Who Must Choose Again Locked
- Teacher Loads: Allocations, Part-Time Allowances & Over-Timetabled Staff Locked
- Room Utilisation: Frequency, Occupancy & the Rooms You Really Need Locked
- Clash Checking a Draft Timetable: Slot Keys, COUNTIFS & Double Bookings Locked
- Covering Absent Teachers: Lessons to Cover, Shortfalls, Supply Cost & a Fair Rota Locked
- Staff Deployment Metrics: Contact Ratio, Average Class Size & Pupil–Teacher Ratio Locked
- Capstone: Next Year's Staffing Plan – Classes, Periods, FTE Gaps & a Chart Locked