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