You have exams coming and you want to know one thing: am I on track, and what do I study next? Lists of subjects do not answer that. This free Excel planner turns your lessons, exam dates and self-test scores into a plain answer for each subject.
The problem it solves
Most revision plans fail in the same way: they are built once, they never reflect what you have really finished, and you find out you are behind when the exam is a few days away. The planner works the other way round. It starts from what is left, divides it by the days remaining and tells you whether the pace you can keep is enough.
What is inside
- Settings: today's date (it updates itself and you can type another date to test), how many lessons you can study per day, and the score below which a lesson counts as weak.
- Subjects: the name of each subject and its exam date, up to 15 subjects.
- Lessons: each lesson with its subject (chosen from a list), status (not started, studied, revised), a self-test score out of 10 and the date you last studied it. The sheet shows the days left to the exam and a "needs revision" column. It holds up to 500 lessons.
- Dashboard: for each subject, total lessons, how many are studied and revised, percentage done, average score, weak lessons, lessons needed per day and a status. Under it sits a list of your ten weakest lessons.
A worked example
The numbers below are sample data. The sample assumes you can study 3 lessons a day and that a score below 6 is weak.
- Mathematics, exam in 5 days: 17 lessons, only 1 studied (5.9% done). 16 lessons remain, and 16 divided by 5 days is 3.2 lessons a day, above your 3, so the status is late.
- Social studies, exam in 5 days: 13 lessons, 2 studied (15.4%). 11 remain, which is 2.2 a day. That is below 3 but above 70% of it (2.1), so the status is watch out.
- Arabic, exam in 12 days: 6 lessons, 5 studied (83.3%), average score 6.25. On track, though one lesson scores below 6.
- English: 5 lessons, 3 studied (60%), average 6.0. One lesson was entered as 12 out of 10, so the sheet shows a warning and leaves that score out of the average.
- Religion: the exam date has passed, so the subject shows "exam over".
The weakest lesson list starts with Heat (3 out of 10), then Spelling and English Unit 2 Grammar (4 each).
Why these features matter
- A pace, not just a count. "16 lessons left" means little; "3.2 per day against your 3" tells you to act today.
- Your own scores decide what is weak. The list is built from your self-tests, not from a guess.
- A safety net for forgetting. A lesson you studied but did not revise, with the exam inside a week, is flagged.
- Errors do not spoil the average. Only scores from 0 to 10 are counted.
- It works in Excel 2016 and later, Google Sheets and LibreOffice, is free and needs no sign-up.
Using the online version
The template page (in Arabic) opens directly on this example. Edit the white input cells in the page, for instance mark a lesson as studied or change its score, and the grey calculated cells and the status of each subject update immediately. You can import your own .xlsx file made from this template, export your work to .xlsx, or download the original Excel file. Your data stays in your browser and is not sent to the server. If you only need a day-by-day timetable, our study schedule maker is a separate tool. The list of templates is at /templates.
Common mistakes, and when a sheet stops being enough
- Writing a score out of 100 instead of 10: only 0 to 10 is counted.
- Never updating "last studied": the revision warning depends on it.
- Entering a subject name that is not in the Subjects sheet: the lesson is flagged and is not counted.
This planner depends on your own rating of how you did. If you want the textbook turned into tests, with weak points found from your results and a plan that changes as results build up, that is what Bayango is for.
FAQ
How does it decide that a lesson needs revision? Either its score is below the threshold you set, or you studied it, did not revise it, and the exam is within 7 days.
What does "lessons needed per day" mean? The lessons you have not started in that subject, divided by the days left to its exam. If it is more than you can manage, the subject is "late"; above 70% of it, "watch out".
Can I change today's date? Yes. Type another date in the Settings sheet to see how the plan looks on a different day.