Follow the steps below to make a grade calculator in Google Sheets.
Open Google Sheets and create a new spreadsheet. Label the first row with the different grade categories and their weights. For example, "Homework (20%)", "Quizzes (30%)", "Midterm (25%)", "Final (25%)".
Below each category, input the scores achieved for each. Make sure each score is in the column under its respective category.
To calculate the weighted score for each category, you’ll use a formula. Assuming "Homework" scores start in B2, you can calculate the weighted score for Homework in a new cell with:
=B2*0.2
Adjust the cell reference and weight (0.2 for 20%) as necessary for your data.
After calculating the weighted score for each category, find an empty cell where you want to display the final grade. Use the SUM function to add up all the weighted scores. If your weighted scores are in cells C2, C3, C4, and C5, the formula will look like:
=SUM(C2:C5)
Here is a sample grade calculator you can copy and edit for yourself. Make sure to adjust the ranges and percentages according to your setup.
You can add more rows for each category if you have multiple scores per category and then sum those before multiplying by the category weight.
We hope that this article has helped you and given you a better understanding of how to make a grade calculator in Google Sheets. If you enjoyed this article, you might also like our articles on how to use SPARKLINE in Google Sheets to make a progress bar and how to use Autocrat with Google Sheets.
