----- ------ ----- ------ ----- ---- ----- ------ ---- T1 Wr Test 1 T2 Wr Test 2 T3 Wr T3 T Ave T Ave2 Rank ----- ------ ----- ------ ----- ---- ----- ------ ---- 0.5 98.5 5.5 86.3 5 94.0 92.9 93.2 1 5.5 83.8 5 87.5 2.5 97.0 89.4 91.3 2 6 82.4 5 87.5 2.5 97.0 89.0 91.0 3 2 94.1 8 80.0 8 90.5 88.2 88.8 4 3.5 89.7 13 67.5 1.5 98.2 85.1 88.4 5 4 88.2 11 72.5 7 91.7 84.1 86.0 6 8.5 75.0 8 80.0 10 88.1 81.0 82.8 7 4 88.2 16.5 58.8 9.5 88.7 78.6 81.1 8 2.5 92.6 22.5 43.8 9 89.3 75.2 78.7 9 8 76.5 17 57.5 20 76.2 70.1 71.6 10 11.5 66.2 22 45.0 14 83.3 64.8 69.5 11 (13) 5.5 83.8 24 40.0 20 76.2 66.7 69.1 12 10.5 69.1 15.5 61.3 23.5 72.0 67.5 68.6 13 (11) 12.5 63.2 27 32.5 28 66.7 54.1 57.3 14 8.5 75.0 26 35.0 42 50.0 53.3 52.5 15 18.5 45.6 27.5 31.3 38 54.8 43.9 46.6 16 26.5 22.1 39 2.5 68 19.0 14.5 15.7 17 26 23.5 39 2.5 71.5 14.9 13.6 13.9 18 29.5 13.2 40 0.0 75 10.7 8.0 8.7 19 34 0.0 40 0.0 77 8.3 2.8 4.2 20 ----- ------ ----- ------ ----- ---- ----- ------ ---- T1 Wr Test 1 T2 Wr Test 2 T3 Wr T3 T Ave T Ave2 Rank ----- ------ ----- ------ ----- ---- ----- ------ ---- T Ave is the average T1 + T2 + T3 of T1, T2, and T3 T Ave = ---------------- 3 T Ave 2 is the average of T1, T2, T3 and T1 + T2 + T3 + T3 T3 (the last T Ave 2 = ----------------------- exam has double 4 weight in the average) This is only showing the 3 test scores. The homework and projects scores are NOT shown and are not yet entered into the Excel gradebook.