12pts 10pts 14pts 16pts 18pts ---- ----- ----- ----- ----- ----- ----- ---- Code Quiz1 Quiz2 Quiz3 Quiz4 Quiz5 Total Ave ---- ----- ----- ----- ----- ----- ----- ---- VSBK 12 10 14 15 18 494 98.8 WUJZ 12 9.5 14 15.5 16.5 484 96.8 WBYJ 12 10 14 15.5 15 480 96 NTBP 12 10 14 13.5 17 479 95.8 MHQQ 12 9.5 13 15 17 476 95.2 GHVV 12 9.5 14 12 17 464 92.8 PZXF 11 9.5 13 11.5 18 451 90.2 SZGN 12 9 12.5 15 14 451 90.2 CZRA 11 10 14 9 14.5 428 85.6 OCCU 11 10 11 9 17 421 84.2 HBHJ 12 9.5 12.5 11 12 420 84 HYZK 11 7.5 14 8 15 400 80 HEEQ 12 9 13 9 10 395 79 KKSI 12 9 8 13 12 395 79 RFEP 12 8 12 10 9 378 75.6 CLXG 9 6 12 14 9 358 71.6 UJHX 12 9 13 12 0 358 71.6 TQLC 10 10 12 13.5 0 353 70.6 OSXV 9 7.5 13 5.5 13 349 69.8 AOXL 11 10 11 0 13.5 345 69 RNNM 10 4 7 0 0 173 34.6 ---- ----- ----- ----- ----- ----- ----- ---- Code Quiz1 Quiz2 Quiz3 Quiz4 Quiz5 Total Ave ---- ----- ----- ----- ----- ----- ----- ---- 12pts 10pts 14pts 16pts 18pts ---- ----- ---- ----- Q3Wr Total Ave CodeR ---- ----- ---- ----- 0 494 98.8 VSBK 0 484 96.8 WUJZ 0 480 96 WBYJ 0 479 95.8 NTBP 1 476 95.2 MHQQ 0 464 92.8 GHVV 1 451 90.2 PZXF 1.5 451 90.2 SZGN 0 428 85.6 CZRA 3 421 84.2 OCCU 1.5 420 84 HBHJ 0 400 80 HYZK 1 395 79 HEEQ 6 395 79 KKSI 2 378 75.6 RFEP 2 358 71.6 CLXG 1 358 71.6 UJHX 2 353 70.6 TQLC 1 349 69.8 OSXV 3 345 69 AOXL 7 173 34.6 RNNM ---- ----- ---- ----- Q3Wr Total Ave CodeR ---- ----- ---- ----- ---------------------------------------------------------------------- Function quizTotalAdjusted(q1, q2, q3, q4, q5) As Integer t = q1 / 12 * 100 + q2 / 10 * 100 + q3 / 14 * 100 + -- -- -- q4 / 16 * 100 + q5 / 18 * 100 -- -- quizTotalAdjusted = t End Function ----------------------------------------------------------------------