Clash Checking a Draft Timetable: Slot Keys, COUNTIFS & Double Bookings
This lesson is part of the course
In this lesson
You build a slot key for every lesson, count how many lessons each teacher and each room has in the same slot with COUNTIFS, and count the lessons that have any clash – without counting a double clash twice.
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