How to make a spaced repetition revision timetable in Google Sheets

Build a revision timetable that schedules each topic several times before your exam instead of once. It suits students revising for school, college or university exams. You need a list of your topics, your exam dates and a free Google account for the template.

How to Make the PERFECT Revision Timetable with Spaced Repetition, by Zain Asif on YouTube. 11 min 52 s.

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

What you need

Steps

  1. Write down every topic you need to cover for each subject. Break big topics into smaller chunks so each one fits a single study session.

  2. Note your exam dates and count the weeks left. This sets the outer limit for your timetable.

  3. Open the Google Sheets template and choose File, then Make a copy. Save it to your own Drive so you can edit it.

  4. Enter each topic in its own row. Add the date you first study it and the dates for each repeat.

  5. Space the repeats out. Study a topic, then revisit it after a few days, then after a week or two, then closer to the exam.

  6. Fill every week of the timetable so each topic appears several times before its exam date. Check no day is overloaded.

  7. Decide what you do at each repeat. Use the first pass to learn the topic, later passes for active recall and past paper questions.

  8. Block out fixed study slots in your calendar and treat them like appointments. Tick off each session as you finish it.

Tips and common mistakes

Keep each study session short and focused so you actually complete it.

Do active recall, such as blank-page testing, instead of just rereading notes on repeat visits.

Leave one catch-up day each week for sessions you miss.

Update the timetable when a topic takes longer than planned rather than dropping it.

Questions

How many times should I repeat each topic?

Aim for at least three spaced reviews before the exam, with the gaps getting longer each time. Adjust the number to how much time you have left.

Do I need the Google Sheets template?

No. Any spreadsheet or paper planner works. The template just saves you setting up the columns and dates.

What if I fall behind schedule?

Move missed topics to your catch-up day and keep the later repeats in place. Dropping repeats defeats the point of spacing.

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