assignment tracker template

Grade & Assignment Tracker for Google Sheets

In short: A Google Sheets (and Excel) assignment tracker with weighted grade calculation, a GPA calculator, colour-coded deadlines and an optional one-click script that emails you 24 hours before each due date.

Grade & Assignment Tracker for Google Sheets: preview of the template with sample data

What you'll be able to do

  • See every deadline sorted by urgency
  • Know exactly what score you need on the final
  • Get an email reminder before anything is due

What's included

  • Assignment tracker with conditional formatting
  • Weighted grade calculator per course
  • Semester + cumulative GPA calculator (4.0 scale)
  • "What do I need on the final?" calculator
  • 24-hour deadline email reminders (Google Apps Script)
  • Excel version (without email reminders)

Who this assignment tracker template is for

  • STEM, business and data-minded students
  • Anyone who prefers spreadsheets to Notion
  • Parents tracking a high schooler’s assignments

How it works

  1. Buy securely; checkout handles cards, Apple Pay, Google Pay and PayPal.
  2. Open the receipt email and click Duplicate (Notion) or Make a copy (Sheets), or download the PDF.
  3. Follow the 5-minute setup guide included in the template.

Questions about the assignment tracker template

Is the email reminder safe?

The script runs in your own Google account, only reads this spreadsheet and only emails you. Google will ask you to authorise it once.

Does it support weighted and unweighted GPA?

Yes. Add a bonus per course (e.g. honors/AP +0.5 or +1.0, set by you to match your school’s policy), or leave it at 0 for unweighted.

Can I change the grade scale?

Yes. Every letter cut-off and GPA value lives on one Grade scale tab, and all calculations use it.

Can I get a refund?

Yes. If it isn't right for you, email hello@metacogstudy.com within 14 days.

You might also like

The Metacog Study Memo — One study system, one template, one idea from learning science, every Tuesday morning. 5-minute read.

Get the Student Starter Pack (GPA calculator + semester planner) free. No spam, unsubscribe anytime.