Every deadline, every grade, one spreadsheet.
Type your assignments once; days left, late flags, each class's grade weighted the way its syllabus says, and your GPA all work themselves out.
Google Sheets · Excel .xlsx · Blank + filled example
Language
Instant download. Permanent link in your account.
Instant download. Permanent link in your account. Yours forever, no subscription.
You do the work. It does the maths.
Everything on the right is a formula you never have to touch, in Google Sheets and in Excel alike.
You type
- Your classes and their weights
- Each assignment and its due date
- Your scores
It works out
- Days left and late flags
- Each class grade, weighted
- Your GPA
- The next fourteen days
Open any tab. These are the real ones.
Tap a tab, then the picture to read every figure full size.
Dashboard
The Dashboard tab.
The dashboard: the week ahead, what is late, every class grade and your GPA.
Assignments
Everything due, in one list.
Class, assignment, type, due date, status and score. Days left and late flags fill themselves.
This Week
Seven days of due dates.
Seven day columns of everything due, coloured by class.
Grades
Weighted the way the syllabus says.
Each class weighted by its own categories, with the letter grade, points and your credit-weighted GPA.
A plain spreadsheet, and this one.
On the left, the plain assignment list most people keep. On the right, the Dashboard tab. Drag the line.
Google Sheets or Excel. You do not have to choose.
The download carries both: the Sheets copy link and the native .xlsx. Every formula is chosen to work identically in the two, and we test the round trip on every build.
Your first five minutes.
-
1
Buy it once.
$29, no subscription. Your order email and your account both carry the download, permanently.
-
2
Copy it into your Drive.
One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.
-
3
Start in the example.
The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.
№ · How the grade is worked out
An assignment tracker spreadsheet that weights every class the way its syllabus does
The Assignment Tracker is for students with several classes, each graded its own way. At the start of term, add your classes on Classes, up to ten, with the code, teacher, credits, room or link, and the weights from each syllabus for homework, quizzes, exams, projects, papers, labs and participation, adding to 100. Then copy every deadline onto Assignments: class, title, type and due date.
Grades that are fair from the first quiz
Type the score and what it was out of when work comes back. Each class’s grade counts only the kinds of work that have a score so far, so one early quiz does not stand in for a whole term. The grade scale on Settings turns the percentage into a letter and GPA points, A from 93 for 4.0 down to F, and your GPA is weighted by credits. If your school uses a different scale, change the letters and cut-offs and every grade follows.
Nothing slips past its date
Anything past its due date and not marked Done, Submitted or Graded shows as Late on Assignments, This Week and the Dashboard. Set how many days counts as due soon, and check This Week on Sunday night: seven columns of everything due, coloured by class.
The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, plus the same workbook as blank and example Excel files.
Planning on a tablet or on paper instead? Find your planner in 60 seconds.
The questions we actually get
How is each class's grade weighted?
By the weights you copy from its syllabus onto Classes, for homework, quizzes, exams, projects, papers, labs and participation, adding to 100. Only the kinds of work with a score so far count, so the grade is fair from the first result.
My school uses a different grading scale. Can I change it?
Yes. Edit the letters, the cut-off percentages and the GPA points on Settings. It starts on A from 93 (4.0), A- from 90 (3.7) and so on down to F, and every grade follows your changes.
Is the GPA weighted by credits?
Yes. Each class's points are weighted by the credits you give it on Classes.
How many classes does it hold?
Ten per term. For a new term, make a fresh copy and set the new term dates on Settings.
When does an assignment show as late?
When its due date has passed and it is not marked Done, Submitted or Graded. It shows on Assignments, This Week and the Dashboard.
Does it work in Excel?
Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable.
Is there a year printed in it?
No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year.
The term, under control.
Deadlines and grades, in Google Sheets and Excel, no subscription, no year baked in.
Get the tracker · $29Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.
Be the first to say something.
Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.
Instant download.
Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.
One-time purchase.
No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.
Quiet, secure checkout.
Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.