How to build an exam revision tracker in Excel with spaced repetition

Set up a simple Excel revision tracker that lists your topics, dates and spaced repetition reviews. You will also learn how to schedule sessions from your learning outcomes and log past papers. It suits students revising for school or IB exams and needs only a spreadsheet app and your syllabus.

How I schedule + track my EXAM REVISION (+ free template), by Alicia Wong on YouTube. 17 min 54 s.

10 chapters. Tap a step to jump to it.Chapters from the creator
Video length
17 min 54 s
Time to do it
30 minutes
Difficulty
Easy
Steps
8

What you need

Steps

  1. Open Excel or Google Sheets and create a new blank spreadsheet. Save it with a clear name like Exam Revision Tracker so you can find it later.

  2. Add column headers across the top: Topic, Learning Outcome, Date Covered, Review 1, Review 2, Review 3 and Confidence. Keep the layout simple so it stays easy to read.

  3. List every topic or learning outcome from your syllabus down the first column. Break large topics into smaller chunks so each row is one revision session.

  4. Fill in the exam date and work backwards. Set your first review for the day you cover the topic, then space the next reviews a few days, a week and a few weeks later.

  5. Enter the spaced repetition dates in the Review 1, 2 and 3 columns. Adjust the gaps so the last review lands before the exam.

  6. Add a Confidence column and rate each topic from 1 to 5 after a session. Use low scores to decide which topics get extra reviews.

  7. Create a second sheet for past papers. Add columns for paper, date done, score and topics to revisit, then log each paper as you complete it.

  8. Check the tracker each morning and do the sessions due that day. Tick off or colour each row once its review is done.

Tips and common mistakes

Keep each row to one small topic so a review session fits in 20 to 30 minutes.

Do not push reviews back when you feel behind. Move them forward only if you have genuinely covered the topic.

Colour rows by confidence so weak topics stand out at a glance.

Duplicate the template for each subject instead of cramming everything into one sheet.

Questions

Can I use Google Sheets instead of Excel?

Yes. The same columns and formulas work in Google Sheets, and you can share the file with study partners.

How far apart should the spaced repetition reviews be?

A common pattern is a few days after first learning, then about a week, then two to three weeks later. Adjust the gaps so the final review falls before your exam.

What if I run out of time before the exam?

Prioritise rows with low confidence scores and topics that appear often in past papers. Drop the extra reviews for topics you already know well.

This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.

More in School & Learning

See all