How to omit blank cells when calculating weighted averages
Hi Tom,
Row 2 has the percentage the assignment was worth out of 100%, so row 2 (for
this specific assignment) has 30%, 25%, and 45%.
Then row 5 has the score the student received for the assignment, in this
case, blank, 85, and 68.
Thank you so much!!
Suzy
"TomPl" wrote:
Suzy,
If a child gets a grade of .80 on a 5 credit assignment that counts for 4.00
points (.80 X 5).
If a child gets a grade of .90 on a 3 credit assignment that counts for 2.70
points (.90 X 3).
Therefore the weighted average grade for that child is total points (4.00 +
2.70) divided by total credits (5 + 3) or 6.7 รท 8 = .8375 (you might round
that to .84).
Actually, I may have misunderstood your question. I assumed that row 2 has
the number of credits for the assignment and that row 5 has an individual
student's grade for that assignment. If that is not true, please do describe
what is in rows 2 and 5 of your example.
It is always about communication!
Tom
|