Guides › Learning

Track your progress towards a qualification

A simple tracker of modules, deadlines and grades for a course, with a weekly summary of what's due and how you're doing.

LearningIntermediate30 minGoogle SheetsGoogle CalendarAI assistant
Open the interactive guideBrowse all guides

When to use it

Weekly, through your course

Step by step

  1. Get your course details

    Collect the course handbook or module list with assignment deadlines and how each is weighted.

  2. Build the tracker with AI

    Paste the details into your AI assistant with this prompt.

    Prompt to copyTurn this course information into a tracker table I can paste into Google Sheets. Columns: Module, Assessment, Type (essay, exam, project), Weighting %, Due date, Status (Not started / In progress / Submitted / Marked), Grade, Notes. Sort by due date. Then list all deadlines as calendar entries in the format: [Due date] - [Module]: [Assessment]. Here's the course info: [paste]
  3. Add deadlines to your calendar

    Paste the tracker into Google Sheets and add each deadline to Google Calendar, with a reminder two weeks before.

  4. Do a weekly check-in

    Each week, update the Status column and paste the sheet into your AI assistant, asking: 'What's due in the next 3 weeks, what should I start now, and what's my average grade so far?'

What you get

Next 3 weeks: Module 2 Essay (30%) due 29 Nov, status In progress. Module 3 Quiz (10%) due 6 Dec, Not started: start this week. Average so far: 64% across 3 marked pieces.

Tips

More Learning guides