Track Grades in Google Sheets. This article will show you how to build… | by Daanish Bhatti | Medium
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. 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. 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
Explore this link on the map →