The following example will demonstrate how to use Excels SUMPRODUCT and SUM functions to calculate a weighted average. How would I be able to calculate my overall average grade or grade point average for these courses. Find the sum of all weights.
Total Grade Points Total Number of Classes GPA Here is Julies report card for this semester.
First multiple the grade received by the weight of the assignment. A basic GPA is calculated by converting every letter grade to a grade point number and then finding the average. Then add each of the calculated values from step 1 together. Determine your grade from each class.