Excel + Google Sheets template

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 for students carrying several classes at once, who want to see what a deadline actually costs before they miss it. 2 you type into, 7 that fill themselves in and 3 you set once. $7.78 once, no subscription.

  • Assignments One row per assignment: class, title, due date, weight, status and mark. Room for 500.
  • Class Timetable When each class actually meets, across the week.
  • Today What is due now, pulled from the assignment list.

Filed under productivity & planning.

Get it on Etsy → See what's inside $7.78 on Etsy · one-timeCurrently 40% off
Tested before release Never password locked One payment Free updates
[ demo loop placeholder: 20–30s screen recording: entering data, dashboard recalculating ]

Type into the highlighted cells, watch every number update itself.

Sound familiar?

Before
Deadlines living in six different places.
No idea what mark you need on the final to hit the grade you want.
Finding out a 5% assignment was actually worth 20%.
After
Every assignment with its class, weight and due date, in one list.
A weighted grade that updates as marks come in, so the final number is never a surprise.
A semester view that shows which week is about to become a problem.
1.0 · The workbook

What's inside, tab by tab

You only ever type in the highlighted input cells, everything else fills itself in.

You type here Calculates itself Set once, never again Reference
Tab 1Start HereSet once, never again

A one page setup guide inside the workbook. Enter your basics once, five minutes, done.

Tab 2AssignmentsYou type here

One row per assignment: class, title, due date, weight, status and mark. Room for 500.

Tab 3Semester SetupSet once, never again

Your classes, their credit and the weighting scheme. Up to 12 classes and 60 weight rows.

Tab 4Class TimetableYou type here

When each class actually meets, across the week.

Tab 5TodayCalculates itself

What is due now, pulled from the assignment list.

Tab 6GradesCalculates itself

Weighted grade per class, calculated from the marks and weights already held in the assignment list.

Tab 7SemesterCalculates itself

The whole term at a glance, class by class.

Tab 8Monthly CalendarCalculates itself

The month laid out with assignments on their due dates.

Tab 9KanbanCalculates itself

Assignments as columns by status: not started, in progress, submitted.

Tab 10GanttCalculates itself

Start and due dates drawn as bars, so overlapping work is visible.

Tab 11FilterCalculates itself

A filtered view for slicing by class, status or week.

Tab 12Settings & ListsSet once, never again

Classes, statuses and grading bands. Change them once and the whole workbook follows.

Built like software, priced like a spreadsheet

Auto-calculating formulas

Enter your data; totals, flags and the dashboard update instantly.

Zero formula errors

Checked cell by cell before release. Find one and you get a fix plus a refund.

Locked formulas, highlighted inputs

Formula cells are protected. You can only type where typing is safe.

Excel AND Google Sheets

Both versions in every purchase. No converting, no broken references.

Printable summaries

Clean report pages for your records, your accountant, or your next meeting.

Instant download

Delivered by Etsy the moment you pay. Free updates to this template forever.

2.0 · Getting started

How it works

2.1
Buy on Etsy

Secure checkout through Etsy, no account needed here.

2.2
Download instantly

The Excel file and the Google Sheets link arrive immediately.

2.3
Make a copy, start typing

Type into the highlighted cells, every formula updates itself.

3.0 · Before you buy

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 built natively, not converted: every formula, highlight and protection works the same.

Is this a one-time purchase?

Yes. $7.78 once. You keep the files forever and get free updates to this template.

What’s the refund policy?

Digital downloads on Etsy are generally final, but if the template doesn’t work as described and we can’t fix it for you, you get your money back. Just email support@elecart.us.

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.

$7.78, once, 40% off. Yours forever, with free updates.

Get it on Etsy →
Tested before release Never password locked One payment Free updates

Also in Productivity

Student Assignment Tracker
$7.78 · one-time · 40% off
Get it on Etsy →