How to Make a School Timetable Without Clashes: A Step-by-Step Method

Collect the facts before you draw a single grid

A timetable fails when it is started with half the facts. Before you open a blank sheet, collect everything in one place. You need the number of working days, the number of periods per day, the length of each period, and the timing of assembly, lunch and short breaks.

Then list every class and section, and the subjects each one studies per week. A Class 8 section may need 6 periods of English, 6 of Maths, 5 of Science and so on. If the total does not match the periods available, fix that first. No clever trick will make 42 periods of subjects fit into 40 slots.

Also note any rule that affects placement. Some schools keep Class 1 and 2 free of afternoon periods. Some keep games in the last period for all classes. Write these as fixed rules on the first page of your working sheet, so you do not break them by accident at the end.

• Working days: Monday to Saturday or Monday to Friday
• Periods per day and length of each period
• Assembly, lunch and break timings
• Subjects and weekly periods for each class
• Teacher names, subjects and classes they can teach
• Shared rooms such as labs, computer room, library and playground

Fix the weekly period count for each subject

Make a simple table with classes down the side and subjects across the top. Write the weekly periods in each cell. Add up each row. The row total must equal the periods available in the week, for example 6 days times 8 periods is 48.

Check your board or state rules for minimum hours for languages and core subjects. Do not guess these numbers. Once the table is signed off by the principal, treat it as fixed. Changing it in the middle of the work is the biggest cause of rework.

Give each teacher a clear limit

Decide the maximum periods per teacher per week and per day. Many schools keep around 30 to 36 periods a week, but this depends on your school and rules. Mark which teachers also handle a class teacher role, exam duty or a co-curricular activity, because they need a lighter load.

Write each teacher's limit next to their name. If Mrs Sharma teaches Maths to four sections of Class 9 and 10 with 7 periods each, that is already 28 periods. Seeing the number early stops you from loading her with Class 7 as well.

Do the same for part-time and visiting teachers. If the music teacher comes only on Tuesday, Thursday and Saturday, all music periods for every section must fit in those three days. Counting this early shows whether you need to ask her for another day.

Place the hard subjects and shared rooms first

Start with what is hardest to move. Lab periods, computer periods, games and music or art that share one room or one teacher go in first. If two sections need the computer lab, they cannot both have it in period 3 on Tuesday.

After that, place the main academic subjects. Spread Maths and Science across the week, and try to keep them out of the last period on hot afternoons. Put languages in different slots across sections so one language teacher is not needed in two places.

Keep a few periods in the middle of the week deliberately light. A free period for each teacher is not wasted time. It is when copies are checked, parents are met and substitutes are covered.

Use a worked example to check for clashes

Take Class 6 A and Class 6 B. Both have 5 periods of Science per week, taught by one teacher. That teacher has 10 Science periods for these two sections alone. If you put Science in period 2 on Monday for 6 A, then 6 B must have Science at a different time on Monday.

A quick test is to build a teacher view as well as a class view. Draw a grid for each teacher with days and periods. When you place a period in a class grid, tick it in the teacher grid at once. A double tick means a clash.

Repeat this test for rooms. If Class 9 A and 9 B both have Physics practical on Thursday period 4, and you have one lab, one of them must move. Keep a third grid for the lab and fill it the same way. Now count the load. Suppose the school has 8 sections of Classes 6 to 8, each needing 5 Science periods. That is 40 Science periods a week. With 3 Science teachers at 30 periods each there is room, but if one teacher is on leave for a month, the other two cannot absorb 14 extra periods each without a plan.

Run a final check before you publish

Before printing, read the timetable like a student and like a teacher. Does any class have the same subject three times in a row? Does any teacher have 7 periods without a break? Is the lab used by two classes together? Is the last period of Saturday full of difficult subjects?

Give the draft to two senior teachers for 24 hours. They will find things you cannot see after days of staring at it. Fix, then freeze the version and put a date and a version number on it.

• No teacher appears twice in the same period
• No room is used by two classes at once
• Every subject has its exact weekly count
• No teacher crosses the daily or weekly limit
• Every class has a teacher in every period
• Break and lunch are the same for all sections that need them

Plan for substitutes from day one

Teachers fall sick and go on training. If you plan substitutes only on the morning, the day starts in a rush. Keep a list of free periods for every teacher, taken from the final timetable. When someone is absent, pick from teachers who are free in that period and have the lowest load that week.

Keep a simple register of who took whose period. This is fair to staff and also gives you a record when someone asks why a teacher has extra duty.

Common mistakes and how to avoid them

The most common mistake is building the timetable class by class and checking teachers at the end. Check teachers as you go. The second mistake is ignoring part-time teachers who come only on certain days. Write their available days at the top of their grid before you begin.

The third mistake is forgetting that exam weeks, sports days and annual day change the routine. Keep a plain list of special weeks and decide the temporary routine in advance, so nobody has to invent one at 8 in the morning.

One more habit helps. Keep a master copy and a change log. When the principal asks for a swap in July, note the date, the periods changed and the reason. After three or four swaps, you will see which part of the design is weak and can improve it next year.

• Building the timetable class by class and checking teachers last
• Ignoring the days part-time teachers are available
• Putting all heavy subjects in the first three periods
• Giving one teacher 7 periods in a row
• Forgetting lab and ground bookings
• Changing the weekly period table after work has begun

Where software can help

If you work in Excel, keep one sheet for class grids and one for teacher grids, and use conditional formatting to colour duplicate names in a period. That alone catches many clashes. Cometstep has a school timetable with clash warnings, an auto-generate option that respects teacher limits, and import of an existing routine from Excel or CSV.