成绩统计分析表（全自动）.xlsx

成绩统计分析表Report card序号学号姓名语文数学英语物理化学生物总分班级排名备注学科最高分最低分平均分不及格人数及格人数及格率120150121张三1121061058888495481语文1123984.40 2880%220150122李四98464259507537010数学1154682.50 3770%320150123王五391131189571865222英语1184271.00 4660%420150124小天53115517342894237物理954674.20 3770%520150125小丽9650795586494158化学913069.20 3770%620150126小孟11258528191694635生物924975.40 2880%720150127小蕊10573609279915003820150128小美9488684672824506920150129小爱75975972307240591020150130小云607976818392471411201501310111220150132011132015013301114201501340111520150135011162015013601117201501370111820150138011192015013901120201501400112120150141011