sheetsmith

Templates › Personal goals

Student Grade & Assignment Tracker

Made for students at school, college or university.

Keep track of your modules, every assignment's deadline and hand in status, the marks you get back, and your running average. The summary carries a chart that redraws itself as you type.

Tabs
3
Columns
16
Fill themselves in
17

£7one payment, yours to keep

  • Opens in Excel, Google Sheets and Numbers
  • Delivered straight away
  • No macros, nothing to install
  • Change it free before you buy

Payment is handled by Stripe. Your card details go to them and never to us. Sales are final, which is why every tab, column and calculation is shown on this page first.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic.
The summary page, every figure calculated from the tables
The chart, drawn from the totals in the table beside it
What is inside: the tabs, the columns and what fills itself in
Where you type, and the shaded columns that work themselves out
The guide sheet that opens first and explains the file
Everything included in the download

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 100 rows.

Modules

One row per module you are taking, with its credits. Averages fill in as marks come back. Room for 20 rows.

ColumnTypeWorked out as
Moduletext
Codetext
Creditsnumber
Weight MarkedpercentIF(ISBLANK([module]), "", SUMIFS([Assignments!weight], [Assignments!module], [module], [Assignments!mark], "<>"))
Average So FarpercentIF(ISBLANK([module]), "", IFERROR(SUMIFS([Assignments!weighted], [Assignments!module], [module]) / SUMIFS([Assignments!weight], [Assignments!module], [module], [Assignments!mark], "<>"), ""))
Credit PointsnumberIF(OR(ISBLANK([module]), ISBLANK([credits])), "", IFERROR([credits] * [module_average], ""))

Assignments

One row per piece of assessed work. Set the status as you go and enter the mark when it comes back. Room for 80 rows.

ColumnTypeWorked out as
Assignmenttext
Modulechoice (from Modules › module)
Worthpercent
Deadlinedate
Statuschoice (list)
Markpercent
Days LeftnumberIF(OR(ISBLANK([deadline]), [status]="Handed in", [status]="Marked"), "", [deadline] - TODAY())
DuetextIF(ISBLANK([deadline]), "", IF(OR([status]="Handed in", [status]="Marked"), "Done", IF([deadline] < TODAY(), "Overdue", IF([deadline] - TODAY() <= 7, "Due this week", "Upcoming"))))
Outstanding DeadlinedateIF(OR(ISBLANK([deadline]), [status]="Handed in", [status]="Marked"), "", [deadline])
Weighted MarkpercentIF(OR(ISBLANK([mark]), ISBLANK([weight])), "", ROUND([mark] * [weight], 4))

Summary

What is due soon and how your grades are going.

MeasureWorked out as
Due in the next 7 daysCOUNTIF([Assignments!due_flag], "Due this week")
OverdueCOUNTIF([Assignments!due_flag], "Overdue")
Earliest outstanding deadlineIF(COUNT([Assignments!pending_deadline]) = 0, "", MIN([Assignments!pending_deadline]))
Still to hand inCOUNTIF([Assignments!status], "Not started") + COUNTIF([Assignments!status], "In progress")
Handed in, awaiting markCOUNTIF([Assignments!status], "Handed in")
Average mark so farIFERROR(AVERAGE([Assignments!mark]), 0)
Weighted average so farIFERROR(SUM([Assignments!weighted]) / SUMIFS([Assignments!weight], [Assignments!mark], "<>"), 0)
Credit weighted averageIFERROR(SUM([Modules!credit_points]) / SUMIFS([Modules!credits], [Modules!marked_weight], ">0"), 0)
Highest markIFERROR(MAX([Assignments!mark]), 0)
Total creditsSUM([Modules!credits])