Students and parents
Assignment Tracker Spreadsheet
Assignment tracker spreadsheet for students: every assignment for every class in one list, with the days left to each due date worked out for you. The dashboard shows what is due next, what is overdue and your grade in each class.
C$8CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- Assignments tab: class, assignment, type (homework, reading, quiz, test, essay, project, lab, presentation, exam), due date, priority (high, medium, low), status (not started, in progress, done, turned in, missing), points earned, points possible and notes
- Days left worked out for every unfinished assignment. Rows turn amber when an assignment is due soon (you choose how many days), red when it is overdue and green when it is finished
- Grades tab: for each class, the number of assignments, finished, still to do, overdue, points earned and possible, grade % and a letter grade from a scale you can edit (add plus and minus grades if your school uses them)
- Dashboard: assignments, finished, still to do, due soon, overdue, finished % and overall points %, your next 12 assignments due with overdue work first, grades and open work by class, and two charts (grade % by class, still to do by class)
- Settings: your name, the term, up to 12 classes with teachers, assignment types, statuses and the grade scale
- Room for 12 classes and 500 assignments
What you get
- XLSXAssignment-Tracker.xlsx (blank)
- XLSXAssignment-Tracker-with-Sample-Data.xlsx (a made-up example: 6 classes and 30 assignments in a fall term)
- PDFQuick-start guide (PDF)
Good for
High school and college students who want every class, due date and grade in one place, and parents helping a student stay on top of schoolwork.
Please note
- Grades here are points earned out of points possible. If your teacher weights categories (tests 50%, homework 20% and so on), your official grade can be different: check your school's grade portal
- An organizing tool. It is not connected to or endorsed by any school or learning platform
- For your own personal use; please don't resell or share the files
Disclaimer
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
