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)