Covering Absent Teachers: Lessons to Cover, Shortfalls, Supply Cost & a Fair Rota
This lesson is part of the course
In this lesson
You count the lessons to cover in each period, find the periods where there are more lessons than free teachers, price the supply teachers needed for the day and pick the fairest internal cover with MINIFS and XLOOKUP.
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