Divide the result by the total number of classes to find your weighted GPA so far. If grades within a category are weighted equally then each assignment within that category will be worth the same as every other homework assignment regardless of actual point value. Now, calculate what you need on the final exam: final exam grade = ((90% x 100%) - 7100%) / 20% = 95%. For example, a class exam might be worth 10% of your grade and you received a 95% on the test. Points Earned 100.00 + 95.50 + 82.00 = 277.50 Points Possible 100.00 + 100.00 + 100.00 = 300.00 Final Grade Percentage 277.50 / 300.00 = 92.50% Weighted Total Column For example, if you received a 95 and an 80, then type "95" in A2 and "80" in A3. Example: If the weight of the above quizzes is 15%, you'd multiply 90.25 by 0.15 for a product of 13.5375, which you can round up to 13.54. Enter the rest point grades, along with both maximum points and weights. Final grade =AVERAGE.WEIGHTED(B2:B6, C2:C6) 87.7: Related functions. You can rename it, change the settings, change which columns and categories are included, or delete this column. Exam 2: 15% You also received an 80% on the test and it was worth 20% of the class grade. The weight of the final test is calculated as 100% minus the combined weight of all grades to date. Remember to convert the weights from percentages to decimals. What do you need on your final to get an A in class? For example, all of Janes homework assignments are worth 15percent or 15 points out of 100 of hergrade. Exempted items are ignored. help.uark.edu Some of our partners may process your data as a part of their legitimate business interest without asking for consent. [(G1*W1)/100] + [(G2*W2)/100] + [(G3*W3)/100] + . After you assign the last percentage, click anywhere in the box to update the percentage located below the Selected Columns box in the Total Weight field. The percentage values for all selected columns are added together. Then, the system divides the result by the total points possible to obtain a percentage for each item in the weighted column. Track and save your high school GPA to keep tabs on your academic progress. First, we need to convert letters to numbers. by Kathryn Zawisza | Dec 7, 2016 | Blackboard. //--> ... Found in your syllabus then it is best to ask your instructor how your grades based.