Automatically calculate your grade in any course. Simply replace the content below with your own.

<aside> 👇 Want to track another course? Click on the ••• button (at the top right of the table), then click on Duplicate.

Your raw score is the grade you got without any late penalty. The final grade calculates your late penalty. You can hide the late penalty column after ensuring the amount is correct. If your late submission is excused, check the "Excused" box and your late penalty will be ignored. ✨ The sum of the grades under the Weighted grade column is your grade in this course.

</aside>

PHILOSOPHY

How it works 🔎

Our formulas are based on a library called math.js, but are set up to work without any development skills.

Days Late

This formula calculates the number of days between the due date and the submission date. In case of an excused late submission, correct the submission date or delete the formula and transform this column into a simple number.

dateBetween(prop("Due Date"), prop("Submission Date"), "days") * -1

Final Grade

This formula takes late penalties into account. It also takes into account any excused late submission.

prop("Raw Score") - prop("Days Late") * prop("Late Penalty") * 100 * toNumber(not prop("Excused"))

Weighted Grade

This formula takes into account the weight per assignment. The sum is your grade in this course.

prop("Final Score") * prop("Weight")

⚠️ Note: If you change any of the properties of the table, you will need to adjust the formulas above accordingly.