班级考试成绩分析模板.xls

班级考试成绩分析学学号号姓姓名名语语文文数数学学英英语语政政治治历历史史物物理理化化学学生生物物总总分分名名次次01030034aa5050706010010050507580809595580101030035lili60705050100100303075808010010056520303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303成成绩绩分分析析语语文文数数学学英英语语政政治治历历史史物物理理化化学学生生物物平均分55.0070.0055.00100.0040.0075.0080.0097.50最高分607060100507580100最低分50705010030758095及格率50.00%100.00%50.00%100.00%0.00%100.00%100.00%100.00%优秀率0.00%0.00%0.00%100.00%0.00%0.00%100.00%100.00%各各科科各各分分数数段段人人数数分分数数段段语语文文数数学学英英语语政政治治历历史史物物理理化化学学生生物物满满分分0002000190-9990-990000000180-8980-890000002070-7970-790200020060-6960-691010000050-5950-591010100040-4940-490000000030-3930-39000010003030以以下下00000000