班级成绩统计分析表

2011级2班考试成绩汇总表,,,,,,,,,,,

课程名称,,语文,,,,数学,,,,,

学号,姓名,期中,期末,总评,排名,期中,期末,总评,排名,总分,总分排名

2011052001,张1,75,86,81.6,37,75,94,86.4,4,168,26

2011052002,张2,100,94,96.4,1,55,86,73.6,47,170,22

2011052003,张3,55,95,79,46,82,88,85.6,6,164.6,33

2011052004,张4,83,93,89,15,73,83,79,33,168,26

2011052005,张5,86,86,86,28,84,86,85.2,8,171.2,15

2011052006,张6,95,84,88.4,17,78,95,88.2,1,176.6,3

2011052007,张7,86,92,89.6,12,80,86,83.6,16,173.2,9

2011052008,张8,73,95,86.2,25,94,73,81.4,27,167.6,31

2011052009,张9,74,93,85.4,31,83,74,77.6,36,163,34

2011052010,张10,85,94,90.4,7,72,85,79.8,29,170.2,20

2011052011,张11,84,97,91.8,3,78,84,81.6,25,173.4,7

2011052012,张12,88,82,84.4,32,81,88,85.2,10,169.6,25

2011052013,张13,97,85,89.8,11,73,97,87.4,3,177.2,2

2011052014,张14,88,85,86.2,25,77,88,83.6,16,169.8,23

2011052015,张15,85,86,85.6,30,85,85,85,12,170.6,19

2011052016,张16,66,88,79.2,45,80,54,64.4,54,143.6,52

2011052017,张17,85,84,84.4,32,81,85,83.4,20,167.8,30

2011052018,张18,77,84,81.2,38,84,77,79.8,29,161,35

2011052019,张19,91,85,87.4,20,75,91,84.6,13,172,13

2011052020,张20,85,94,90.4,7,77,85,81.8,23,172.2,11

2011052021,张21,94,83,87.4,20,67,94,83.2,21,170.6,18

2011052022,张22,73,97,87.4,20,73,73,73,50,160.4,39

2011052023,张23,95,84,88.4,17,64,95,82.6,22,171,17

2011052024,张24,74,95,86.6,24,74,74,74,44,160.6,38

2011052025,张25,77,86,82.4,36,75,77,76.2,41,158.6,40

2011052026,张26,86,94,90.8,5,64,86,77.2,38,168,26

2011052027,张27,88,82,84.4,32,70,88,80.8,28,165.2,32

2011052028,张28,73,80,77.2,50,75,73,73.8,45,151,50

2011052029,张29,77,81,79.4,43,70,77,74.2,42,153.6,46

2011052030,张30,74,80,77.6,48,73,74,73.6,47,151.2,48

2011052031,张31,85,84,84.4,32,64,85,76.6,39,161,35

2011052032,张32,55,80,70,57,84,55,66.6,52,136.6,53

2011052033,张33,55,81,70.6,56,73,55,62.2,55,132.8,55

2011052034,张34,86,77,80.6,42,62,86,76.4,40,157,42

2011052035,张35,85,78,80.8,41,67,85,77.8,35,158.6,40

2011052036,张36,52,86,72.4,52,68,52,58.4,58,130.8,57

2011052037,张37,44,83,67.4,58,70,44,54.4,59,121.8,59

2011052038,张38,84,75,78.6,47,68,84,77.6,36,156.2,44

2011052039,张39,52,85,71.8,53,77,52,62,56,133.8,54

2011052040,张40,53,84,71.6,54,72,53,60.6,57,132.2,56

2011052041,张41,94,86,89.2,14,75,94,86.4,4,175.6,5

2011052042,张42,88,85,86.2,25,77,88,83.6,16,169.8,23

2011052043,张43,77,84,81.2,38,84,77,79.8,29,161,35

2011052044,张44,88,95,92.2,2,82,88,85.6,6,177.8,1

2011052045,张45,86,94,90.8,5,81,86,84,15,174.8,6

2011052046,张46,86,92,89.6,12,80,86,83.6,16,173.2,9

2011052047,张47,84,97,91.8,3,78,84,81.6,25,173.4,7

2011052048,张48,85,94,90.4,7,77,85,81.8,23,172.2,11

2011052049,张49,83,93,89,15,73,83,79,33,168,26

2011052050,张50,86,86,86,28,84,86,85.2,8,171.2,15

2011052051,张51,95,84,88.4,17,78,95,88.2,1,176.6,3

2011052052,张52,91,85,87.4,20,75,91,84.6,13,172,13

2011052053,张53,55,67,62.2,59,84,55,66.6,52,128.8,58

2011052054,张54,77,81,79.4,43,70,77,74.2,42,153.6,46

2011052055,张55,74,80,77.6,48,73,74,73.6,47,151.2,48

2011052056,张56,73,80,77.2,50,75,73,73.8,45,151,50

2011052057,张57,56,82,71.6,54,81,88,85.2,10,156.8,43

2011052058,张58,85,94,90.4,7,72,85,79.8,29,170.2,20

2011052059,张59,78,83,81,40,65,78,72.8,51,153.8,45

,,,,,,,,,,,,

,,语文,,,,数学,,,,,

,,期中,期末,总评,排名,期中,期末,总评,排名,总分,总分排名

平均分,,79.00,86.42,83.45,,75.27,79.98,78.10,,161.55,

考试人数,,59,59,59,,59,59,59,,,

及格人数,,50,59,59,,58,51,57,,,

不及格人数,,9,0,0,,1,8,2,,,

最高分,,100,97,96.4,,94,97,88.2,,,

最低分,,44,67,62.2,,