Grade Calculator
A Max Westerman Project
Why this Grade Calculator?
There are many grade calculators out there on the internet, but none are as fully customizable as this one. Added bonus of no advertisements or pop-ups! Even if you don't know how to navigate spreadsheets, the layout should be self explanatory - read below for a short tutorial on how to work this calculator.
Automatically drops assignments
Calculates assignment grade for overall grade %
Toggles between point based and category based
Incredibly Customizable
On the top left there is the Weighing Table, where if you have a weighted course you will put in the weights for each category. This is also where you'll name your categories - they'll transfer around the sheet. If your course is not weighted, click the "Point based" checkbox below the Weighing table and the categories will disappear. Click the checkbox next to a category to strike it out, removing it from the grade calculation. This is especially useful for classes with labs.
Here is where you'll enter in your assignments. Put your assignments and their respective grades in the table for that category. If you have categories that automatically drop, for instance, the professor stating that 2 homeworks will be dropped, don't worry. The dropping will be automatically applied and will be highlighted in red and struck out.
This will calculate the grade you need on a specific assignment to get a specific grade in the class. For instance what grade do you need on your final for an A? Put the grade in the class you want, the category the assignment is in, and the point value of the assignment. It will automatically calculate the point value you need for the assignment and the % grade required on that assignment.
Common Mistakes
Don't edit the grey cells. They should be protected and will warn you when you touch them, but they include calculations and messing with them will break the calculator
Don't copy and paste. This may break some conditional formatting, but not the mathematical functionality of the calculator. If you do want to copy and paste, make sure to use command shift V or to paste it without formatting.
Don't drag the cells around. This will most likely cause the sheet to light up with reference errors. Don't worry, just hit command Z and it should be good.
Future Improvements
Add a youtube video detailing how to use all of the parts of the spreadsheet and some common pitfalls.
Add functionality to automatically replace a specific assignment with a secondary assignments grade given the secondary assignment has a higher grade. Commonly crops up as finals sometimes replace midterm grades.
Add a column for the date the assignment was due and plot the assignment scores over time.
May be very difficult but could instead of plotting assignment scores over time, plot actual grade over time
Add the ability to calculate required grade on assignment taking into account possible dropped assignments
Changelog
March 6, 2023
Added data validation which prevents the user from accidentally putting in non percentage values in certain cells
Sept 12, 2023
Added pink conditional formatting
Oct 23, 2023
Fixed a single cell error in GPA calculator
Added check boxes to check major GPA
Emphasized grade box