Missing a template? Request it →
Assignment Tracker, the Dashboard tab
№ · Spreadsheets · School

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.

Open it live, read‑only

Instant download. Permanent link in your account. Yours forever, no subscription.

The honest split

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

  1. Your classes and their weights
  2. Each assignment and its due date
  3. Your scores

It works out

  • Days left and late flags
  • Each class grade, weighted
  • Your GPA
  • The next fourteen days
Every tab, as it arrives

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.

Open the filled example, read-only
The difference, on one screen

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.

A plain spreadsheet The tracker
Both apps, one price

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.

Google Sheets
Blank and filled-example copies, one click into your Drive.
Excel .xlsx
Native files, not exports. Blank and filled example included.
Day one

Your first five minutes.

  1. 1

    Buy it once.

    $29, no subscription. Your order email and your account both carry the download, permanently.

  2. 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. 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.

Before you ask

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.

Assignment Tracker

The term, under control.

Deadlines and grades, in Google Sheets and Excel, no subscription, no year baked in.

Get the tracker · $29

Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.

№ · Reviews

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.

Read by a person before it goes up, usually within a day. Your email stays with us and never appears on the page.

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.