Sheet1
Page 1
q1 t1 q2 t2 % plus% current grade
DVN8IF 8 22 9 19 52.37179487 3 55.37179487 3
EDFW98 2 30 13 25 64.16666667 7 71.16666667 4
EVWQOJ 10 26 10 31 68.65384615 8 76.65384615 4
FA2HDQ 18 23 13 32 77.5 7 84.5 5
FRCASS 5 25 4 21 47.62820513 7 54.62820513 3
HMYWLX 8 35 11 27 72.43589744 9 81.43589744 4
KNZNDU 11 25 6 27 60.19230769 8 68.19230769 3
PC4DCQ 8 25 8 27 60.25641026 8 68.25641026 4
R899XZ 20 36 13 37 94.16666667 10 104.1666667 5
XYFVCF 14 38 13 23 79.16666667 8 87.16666667 5
0 0
max: 20 40 13 40
%= sum of: 1/6*(quiz/max)+1/3*(test/40)
Plus%:= successful test=3%, successful make up test=1%, Test>34 plus 2%, test>24 plus 1%
Grades: 2:40-54, 3;55-69 4:70-84