Exam Session Study Plan Google Sheets 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…

Google Docs