| Kathy Ellsworth | ||||||||||||||
| Spring,2003 English | ||||||||||||||
| HW1 | HW2 | HW3 | HW4 | HW5 | AveHW | Quiz 1 | Quiz 2 | Quiz 3 | AveQuiz | Final | HW | Quiz | Final | |
| 0.3 | 0.45 | 0.25 | Grade | |||||||||||
| Adams, Catherine | 89 | 87 | 65 | 70 | 96 | =AVERAGE(B7:F7) | 72 | 73 | 86 | =AVERAGE(H7:J7) | 89 | 81.4 | 77 | =SUM(L7*$L$6)+(M7*$M$6)+(N7*$N$6) |
| Black, Frank | 75 | 62 | 78 | 82 | 83 | =AVERAGE(B8:F8) | 80 | 95 | 98 | =AVERAGE(H8:J8) | 95 | 76 | 91 | =SUM(L8*$L$6)+(M8*$M$6)+(N8*$N$6) |
| Doe, Jane | 89 | 95 | 95 | 96 | 98 | =AVERAGE(B9:F9) | 98 | 98 | 98 | =AVERAGE(H9:J9) | 96 | 94.6 | 98 | =SUM(L9*$L$6)+(M9*$M$6)+(N9*$N$6) |
| Smith, Joe | 62 | 78 | 89 | 75 | 80 | =AVERAGE(B10:F10) | 82 | 64 | 82 | =AVERAGE(H10:J10) | 72 | 76.8 | 76 | =SUM(L10*$L$6)+(M10*$M$6)+(N10*$N$6) |
| Werth, Tom | 52 | 63 | 67 | 83 | 82 | =AVERAGE(B11:F11) | 75 | 72 | 87 | =AVERAGE(H11:J11) | 68 | 69.4 | 78 | =SUM(L11*$L$6)+(M11*$M$6)+(N11*$N$6) |