Track Grades in Google Sheets

This article will show you how to build a grade tracker in google sheets. The sum-product function in google sheets allows you to calculate your expected final grade.

This spreadsheet helps track grade progress in course assignments. It clarifies your performance in a particular course based on what’s already been graded.

The spreadsheet will take less than five minutes to make. It’s better than an online weighted calculator because it’s customized to my needs and I can return to it whenever I like.

First, make three columns: Assessment, Grade, and Weight. I have them assigned in B3, C3, and D3.

Then, fill in all the stuff you will be graded on throughout the semester underneath the assessments column. I take all of the information from the course syllabus. The inputs can be found in B4:B8 and C4:C8.

In an empty cell, input the formula — sumproduct(c4:c8; d4:d8).

The 0 in C11 is expected since no grades are presented

Finally, update the calculator as you make progress throughout the entire semester. The more grades get inputted, the more accurate the calculator will be.

In the example below, I would need to pull a 90 on the research paper to get an A. Anything below a 90 on the research paper would be below a 90 on the final grade and therefore result in a B.