Student Assignment Tracker
Know your grade before the results come out.
For students carrying several classes at once, who want to see what a deadline actually costs before they miss it.
Student Assignment Tracker is a 12-tab Excel and Google Sheets workbook. 2 you type into, 7 calculated from those and 3 you set once. No macros, so it opens without a security warning.
- Today What is due now, pulled from the assignment list.
- Grades Weighted grade per class, calculated from the marks and weights already held in the assignment list.
- Semester The whole term at a glance, class by class.
Filed under productivity & planning.
11 of the 12 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Today | Calculated for you | What is due now, pulled from the assignment list. |
| Tab 3Grades | Calculated for you | Weighted grade per class, calculated from the marks and weights already held in the assignment list. |
| Tab 4Semester | Calculated for you | The whole term at a glance, class by class. |
| Tab 5Assignments | You type here | One row per assignment: class, title, due date, weight, status and mark. Room for 500. |
| Tab 6Semester Setup | Set once, never again | Your classes, their credit and the weighting scheme. Up to 12 classes and 60 weight rows. |
| Tab 7Class Timetable | You type here | When each class actually meets, across the week. |
| Tab 8Monthly Calendar | Calculated for you | The month laid out with assignments on their due dates. |
| Tab 9Kanban | Calculated for you | Assignments as columns by status: not started, in progress, submitted. |
| Tab 10Gantt | Calculated for you | Start and due dates drawn as bars, so overlapping work is visible. |
| Tab 11Filter | Calculated for you | A filtered view for slicing by class, status or week. |
| Tab 12Settings & Lists | Set once, never again | Classes, statuses and grading bands. Change them once and the whole workbook follows. |
Want one quick number first? The free grade calculator shows what you need on the final for every letter grade at once. It runs in your browser, no sign-up.
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
It does not connect to Canvas, import your syllabus, remind you or email you. You type your assignments in, and it works out what each one is worth.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
Know your grade before the results come out.
$2.69, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →
