1 min read

Exam Session Study Plan Google Sheets Template

Plan your next exam season with this handy study plan template.

Plan your next exam season with this handy study plan template.

Features

  • quick overview on time allocation per subject
  • 2 sessions/day time schedule
  • high visibility colour coding
  • weekly scheduler format with 6 learning days and 2 sessions per day
  • Buffer cell type (not counted in allocation)
  • Vacation/Work/etc. cell type (not counted in allocation)
  • Exam cell type (not counted in allocation)

Editing

  • Duplicate the template into your own Google Account, so that you can edit it
  • Change subjects
    • Change the title of the demo cell and counting cell to the name
    • Change the formula in the appropriate counting cell to use "subjectnamehere*" as a matching string
  • Add subject
    • Duplicate another subject's cells and apply procedure of change subject
    • Use the fill colour tool to change the colour if applicable
  • Add or remove weeks
    • Use copy-paste
  • Add session comment ("TASK GOES HERE")
    • use ctrl+enter to add a new line to a cell

The Template

Lernplan Template
Sheet1 Woche 1 (24.06.),1,2,3,4,5,6,DDCA,AnW,Ana1,PProg Slot 1,Urlaub,Urlaub,Urlaub,DDCA TASK GOES HERE,PProg TASK GOES HERE,1,1,1,1 Slot 2,Urlaub,Urlaub,Urlaub,AnW TASK GOES HERE,Ana1 TASK GOES HERE,Buffer Woche 2,1,2,3,4,5,6 Slot 1 Slot 2 Woche 3,1,2,3,4,5,6 Slot 1 Slot 2 Woche 4,1,2,3,4,5,6 S…