1、学生考试成绩自动统计表使用说明:1、蓝色区是你要填的,其他你甭管,系统自动生成。2、表中留了100个学生的空,不够你可以在中间插入行,增加到你所需要的实际人数,多了可以删除或不管。3、成绩分析表的数据为统计数据,打印即可。考号 姓名语文数学英语政治历史物理化学个人总分 平均分 名次1家80901205534586.322有3656556020751.833我1001001009539598.8140#450#460#470#480#490#4100#4110#4120#4130#4140#4150#4160#4170#4180#4190#4200#4210#4220#4230#4240#425
2、0#4260#4270#4280#4290#4300#4310#4320#4330#4340#4350#4360#4370#4380#4390#4400#4410#4420#4430#4440#4450#4460#4470#4480#4490#4500#4510#4520#4530#4540#4550#4560#4570#4580#4590#4600#4610#4620#4630#4640#4650#4660#4670#4680#4690#4700#4710#4720#4730#4740#4750#4760#4770#4780#4790#4800#4810#4820#4830#4840#485
3、0#4860#4870#4880#4890#4900#4910#4920#4930#4940#4950#4960#4970#4980#4990#4学科语文数学英语政治历史物理化学实考人数3333#及格人数1223000及格率33.3366.6766.67100.00#总分216246275210000平均分72.0082.0091.6770.00#优生人数0021000优生率0.000.0066.6733.33#差生人数1110000差生率33.3333.3333.330.00#最高分10010012095000最低分36565555000140-1500000000130-139000000
4、0120-1290010000110-1190000000100-109111000090-99010100080-89100000070-79000000060-69000100050-59011100040-49000000030-3910000000-290000000_学学年年潘潘集集区区学学生生考考试试成成绩绩分分析析表表科科目目卷卷面面分分平平均均分分及及格格人人数数及及格格率率优优秀秀人人数数优优秀秀率率最最高高分分最最低低分分0至至2930至至3940至至4950至至5960至至6970至至7980至至8990至至99100至至109110至至119120至至129130至至1
5、39140至至150语语15015072721 11.7%1.7%0 00.0%10010036360 01 10 00 00 00 01 10 01 10 00 00 00 0数数15015082822 23.3%3.3%0 00.0%10010056560 00 00 01 10 00 00 01 11 10 00 00 00 0英英120120 91.791.72 23.3%3.3%2 23.3%12012055550 00 00 01 10 00 00 00 01 10 01 1政政808070703 35.0%5.0%1 11.7%959555550 00 00 01 11 10 00 01 1史史7070#0 00.0%0.0%0 00.0%0 00 00 00 00 00 00 00 0物物9090#0 00.0%0.0%0 00.0%0 00 00 00 00 00 00 00 00 00 0化化6060#0 00.0%0.0%0 00.0%0 00 00 00 00 00 00 0