学校学生成绩统计表excel模板

"学校学生成绩统计表

年度：第2学期班级五年级",,,,,,,,,,,

序号,姓名,第一次,第二次,第三次,第四次,第五次,第六次,第七次,第八次,总分,备注

1,,82.5,84,89,85,81,86.5,,,,

2,,69.0,59,72.5,75,66.5,79.5,,,,

3,,85.0,87.5,91,90,82.5,90.5,,,,

4,,87.0,86.5,89,81,74,83,,,,

5,,75.0,84.5,87,91,75.5,84,,,,

6,,81.0,80,83,81,65.5,87.5,,,,

7,,89.0,87.5,93,87,86,94,,,,

8,,89.0,88.5,89,92.5,87,88,,,,

9,,87.5,90,96,93,79.5,94.5,,,,

10,,89.0,90.5,89,88,87,86.5,,,,

11,,78.0,72.5,81.5,77,64,84,,,,

12,,45.0,39,53,54,37,54,,,,

13,,94.0,92,94,90.5,79,87,,,,

14,,55.0,55,58.5,53,47.5,57,,,,

15,,86.5,85,91,85,81,90,,,,

16,,23.0,25,22,29,15,29,,,,

17,,87.0,90,95,95,82.5,87.5,,,,

18,,87.5,86,88,91,82.5,87,,,,

19,,89.0,86.5,91,92,77.5,88.5,,,,

20,,71.5,78.5,78.5,74,65,78,,,,

21,,90.5,90,92,89.5,77.5,91,,,,

22,,88.0,85.5,91.5,88,74.5,88,,,,

23,,90.5,91.5,94,90,79,92,,,,

24,,90.0,87.5,95,86.5,77.5,89,,,,

25,,78.5,82,87,89,82,77.5,,,,

26,,86.0,87.5,87,82.5,81.5,84,,,,

27,,93.0,95,88.5,95.5,86.5,92,,,,

28,,85.0,86,92,79.5,74,77,,,,

29,,77.0,84.5,82,83,74.5,83.5,,,,

30,,80.5,87,81.5,77,65.5,80.5,,,,

31,,73.5,71.5,74.5,68,50,62.5,,,,

32,,86.0,85.5,93,86,80,86,,,,

33,,86.0,85,91.5,87,80,88.5,,,,

34,,77.5,63.5,69,70,53,65,,,,

35,,72.0,75.5,80,69,66.5,79.5,,,,

总分,,2804.5,2805.0,2929.5,2844.5,2517.5,2852.0,0.0,0.0,16753.0,

人均成绩,,80.13,80.14,83.7,81.27,71.93,81.49,#DIV/0!,#DIV/0!,,

及格率,,91.43%,88.57%,91.43%,91.43%,85.71%,91.43%,#DIV/0!,#DIV/0!,,

优秀率,,14.29%,20.00%,40.00%,28.57%,0.00%,20.00%,#DIV/0!,#DIV/0!,,

90分以上人数,,5,7,14,10,0,7,0,0,,

80-89分,,18,19,14,14,13,18,0,0,,

60-79分,,9.0,5.0,4.0,8