Once I have added up the total points scored, and the total possible points, it’s time to divide these to get a final score. The formula is simple here again. All I need is:
I need to use the two numbers I’ve just calculated in the last step to determine the percentage. So, I plug them in to get:
I hit enter and I get a score. It is worth checking to make sure the score is formatted in the percentage format, or I’ll end up with a .80 in the box. I also have to check my decimal points, or I end up with a 80.0000000000000 or something like that.
Now I use the formula again to calculate the percentage score for all the tests and I’m ready to calculate a final, weighted grade.