grade sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mjreisbord - 18 Sep 2007 03:50 GMT

we created a spreadsheet for our kids grades, ie.

we show quiz 15%, homework 10% and tests 75%.

how do we average and weight the grade (and show the formulae) if there were
no homework grades.

thanks,

mark reisbord

Reply to this Message

Sebation - 18 Sep 2007 04:24 GMT

try:
=sumproduct({quiz,hoemwork,tests},{0.1,0.15,0.75})

Signature

HTH

Regards
Sebation.G
"mjreisbord" <mjreisbord@discussions.microsoft.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:7301E35A-278E-4EB6-A8A6-4E1600E1BBDB@microsoft.com...

> we created a spreadsheet for our kids grades, ie.
>
[quoted text clipped - 7 lines]
>
> mark reisbord

Reply to this Message

David Biddulph - 18 Sep 2007 07:50 GMT

If you are saying that you have no homework results but you want to maintain
the same relative weighting between quiz and tests, just divide your
original answer by 90%.

Signature

David Biddulph

> we created a spreadsheet for our kids grades, ie.
>
[quoted text clipped - 7 lines]
>
> mark reisbord

Reply to this Message