You build the timetable for a school with several classes and teachers, and before you pin it up you want to be sure that no teacher is in two classes at the same moment, that no class has two teachers in the same period, and that each teacher gets the agreed number of periods, no more and no less. The free class timetable sheet answers those questions from one record you type: the periods. The template and its page are in Arabic.
The problem it solves
A timetable is a puzzle. You put the maths teacher in the first class on Sunday morning, forget, and put them in another class at the same Sunday period. You edit one period and create a duplicate cell you cannot spot because the grid is long. In the end the teachers notice the clash before the office does, or it shows up in the first week of term. Then there is the weekly quota: one teacher has two extra periods, another is short, and nobody has an exact number that adds up each teacher's periods from the grid. Checking by eye costs hours.
How it works, step by step
- In Settings you write the school name, the number of school days and the number of periods per day.
- In Teachers you give each teacher a code, a name, a subject and a weekly quota.
- In Classes you write each class code and name.
- In Periods you write each period as one row, choosing the day, period, class and teacher from ready lists, so you do not mistype a code.
- The sheet writes a status beside each row and colors a clash red.
- You open Teachers, Classes and Summary for the counts, then the class and teacher grids to print.
What each sheet does
- Teachers: each teacher's recorded periods against their quota, the difference, the status (over quota, under quota or complete) and their clashing periods.
- Classes: occupied and empty slots per class. Empty slots = school days x periods per day - occupied, and a duplicated period counts once.
- Periods: the main record. Beside each row sit the teacher's name, the teacher clash, the class clash and the row status.
- Class grid and teacher grid: pick a code and a weekly grid of days and periods appears, ready to print and pin up.
- Summary: clean and clashing periods, teachers over and under quota, and the periods in each day with their clashes.
Why it matters
A clash costs nothing on paper; it shows up in the classroom, when students wait for a teacher who is elsewhere or two teachers walk in together. The earlier you find it, the cheaper the fix: move one period before printing instead of redoing the week. And counting the quota exactly gives you a clear conversation with teachers: this is your quota and this is what we recorded for you.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not from real statistics. It has three classes, six teachers and 60 periods, with four periods filled on each of five days. The sample puts the maths teacher in both "First year A" and "First year B" on Sunday, first period, so the sheet writes "teacher clash" on both rows. On Tuesday, third period, "First year A" carries two periods at once, Arabic and art, so it writes "class clash" on both.
In Teachers, the maths teacher shows 13 periods against a quota of 12, so "over quota", and the English teacher shows 12 against 10, also over. The others are complete or under. In Classes, First year A has ten empty slots, First year B ten and Second year A eleven, so the Summary shows 31 empty slots. You know what to fix before you print.
The online version
The same timetable works online: it opens on the ready example, you change any cell and see the result at once, add a period from a form instead of typing into the grid, and import or export an .xlsx file. Your data stays in your browser and is not sent anywhere. Try it from the template page.
Who it suits
- The timetable coordinator of a small or mid-size school who wants to check the timetable before pinning it up.
- A principal who wants to see who is over or under their quota.
- A learning center or nursery with classes and teachers that needs a tidy timetable.
The sheet does not assign or arrange periods for you; it checks and counts what you wrote. For attendance there is the student attendance sheet, and for tests the exam schedule sheet.