Skip to content
Assignment Tracker cover: a sample sheet with still open, hours still to do and due in 7 days and a stacked chart, beside the Dashboard and Assignments tabs

Assignment Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Assignment Tracker is a workbook for students who juggle several courses at once. The Assignments tab holds one task per row with its course, due date, estimated hours and status, from Not started through to Graded. A Days left figure ticks toward the deadline until work is handed in, and late rows appear in red. Up on the Dashboard you see how many tasks are still open, the hours left to do, what falls due within seven days and how each course is progressing.

Enter every assignment as soon as the teacher sets it, including the small ones, because the Dashboard only counts what is logged. Estimate hours honestly and check the totals on Sunday to plan the week. If you rename a course, update the Course dropdown and the course names on the Dashboard, or that course's counts will show zero.

Useful for

  • Planning a week of homework across five courses
  • Spotting overdue work before a parent-teacher meeting
  • Estimating study hours before midterms

What's included

  • 3 tabs: Dashboard, Assignments, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Assignments: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Assignments tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track overdue homework in a spreadsheet?

Enter each due date on the Assignments tab and leave the status as Not started or In progress. Days left goes negative after the deadline slips by, and that row is shaded red. Mark the task Submitted or Graded and it no longer counts as late.

How do I count how much work is left?

The Hours still to do card adds the estimated hours for every task that is Not started or In progress. The breakdown by course splits each course into handed-in and open work, so you can see which class needs more time.

Where do I put a seventh course on the Assignments tab?

Type the course name into the Course dropdown on the Assignments tab through the validation list. Then add the name to the Dashboard course table, and its totals will show. New assignments then count toward that course.

  • #grade-tracker
  • #assignment-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More grade tracker templates

See all 8

Also in Careers

All careers templates
Get this template

Preparing your template…