You teach one or more subjects to one or more classes, and you want to know at any moment where you are in the syllabus, whether you are on your plan or behind it, and which lessons need a catch-up period before time runs short. The lesson plan and coverage tracker is built to answer that at a glance.
The problem
The plan usually sits on paper or in a preparation notebook, while what actually happened sits in memory. When a period is lost to an activity, a holiday or an exam, the effect shows up late, and with several classes you have no single number telling you the truth. You need an orderly table where you write the plan once and update it after each lesson.
How the sheet solves it, step by step
- In Settings you enter today's date and the grace days before a lesson counts as late.
- In Subjects you give each subject and class a short code, a subject name and a class.
- In Lessons you type each subject's units and lessons yourself, with planned periods and a planned date.
- After each lesson you enter the periods taught and the date, pick a status from a list (not started, in progress, done) and add a short prep note.
- The sheet works out counted and remaining periods and writes "late against plan" next to anything unfinished whose date has passed.
- Open Subjects for coverage and status per subject and class, and Summary for the overall picture.
The sheet carries no official curriculum. Units, lessons and period counts are all your own entries.
What each sheet does
Settings holds two cells: today's date and the grace days. All lateness alerts read from them. Type =TODAY() to keep the date current.
Subjects is a table with one row per subject and class. It shows the number of lessons, lessons marked done, planned and counted periods, coverage percentage, late lessons and late periods, then a status. Late rows turn red.
Lessons is the day-to-day log: one row per lesson with the status picked from a list. Counted periods are the lower of taught and planned, so coverage never passes 100% even if you took an extra period; extras appear separately in the Summary. If you mark a lesson done but the taught periods are fewer than planned, the sheet flags it for review.
Summary gathers the overall percentage, the number of late lessons, periods and subjects, and two tables: lessons by status and subjects by status.
The benefits
You see a real coverage figure per subject, catch delays when they happen, and keep prep notes next to each lesson.
Why it matters
Small delays accumulate: one lesson that slips a week pushes everything after it. Regular tracking turns an adjustment to the plan into a calm decision instead of a race.
A quick example from the sample sheet
The numbers below come from the sample sheet, not real statistics, and today's date in it is 2026-11-01. It has six subject and class rows and 23 lessons. Planned periods total 57 and counted periods 30, so overall coverage is about 52.6%. In the science review lesson two periods were taught instead of one, so one is counted and the extra one shows in the Summary.
Arabic for class 1/A is at 50% (6 of 12 periods) with two lessons behind plan: the short story was due 2026-10-18 with one period left, and composition was due 2026-10-25 and has not started. Maths for class 2/B is at about 42.9% (9 of 21) with two lessons behind plan, so the two subjects hold eight late periods and both show "behind plan". Science for 1/A is at 90% and on track, computing for 2/B is complete at 100%, and science for 3/C has not started because its first lesson date has not arrived.
The online version
Open the page and the sheet opens on the example. Edit any cell and watch the results change, add a lesson with a simple form instead of hunting for the last row, and import your own .xlsx file or export your work. Your data stays in your browser on your device.
Who it suits
It suits a teacher with several classes who wants a clear view of the plan. If you want the timetable itself, try the class timetable sheet; for homework follow-up, the homework and behavior tracker. This sheet covers the plan and coverage only.
In short
Write your plan once, update it after each lesson, and let the sheet tell you where you stand. Then clear the sample numbers and enter your own.