EXCEL函数作业学生作品-学生成绩数据表
学号姓名数学物理历史政治体育艺术2000101曹操89.0091.0095.0098.0082.0084.002000102刘备93.0088.0097.0095.0085.0078.002000103孙权82.0086.0083.0096.0086.0087.002000104关羽80.0088.0090.0089.0098.0077.002000105张飞52.0037.0045.5056.0099.0023.002000106赵云87.0088.0085.0084.0098.0081.002000107黄忠78.0067.0094.0092.0097.0083.002000108马超67.0078.0069.0056.0098.0078.002000109吕布34.0035.0045.0012.00100.0022.002000110貂禅67.0078.0090.0086.0065.00100.002000111许褚45.0043.0056.0048.0099.0056.002000112典韦34.0049.0053.0032.0099.0045.002000113张辽78.0081.0090.0081.0095.0087.002000114夏侯敦82.0081.0078.0067.0093.0045.002000115夏侯渊67.0073.0056.0061.0090.0076.002000116周泰45.0041.0055.0051.5094.0055.002000117徐盛78.0077.0065.0072.0080.0045.002000118诸葛亮90.0088.00100.00100.0056.0070.002000119司马懿70.0060.0099.0097.0067.0056.002000120周瑜89.0067.0098.0099.0082.0098.002000121庞统90.0097.0078.0088.0034.0061.002000122姜维87.0089.0091.0082.0091.0078.002000123徐庶92.0099.0091.0093.0071.0034.002000124郭嘉80.0082.0097.0094.0012.0088.002000125鲁肃87.0082.0096.0095.0034.0087.002000126刘禅23.0012.0028.00 6.0045.0034.002000127曹丕89.0083.0090.0092.0087.0082.002000128蒋干56.0061.0078.0079.0048.0080.002000129
孟获
34.0056.0033.0021.0086.0055.00
93.0099.00100.00100.00100.00100.0023.0012.0028.00 6.0012.0022.0070.52
70.93
76.74
73.19
78.31
67.07
平均分
学生各科情况一览表
各科情况
最高分最低分90.00
100.00 93.00
99.00
100.00
100.00
100.00
100
各科成绩情况表
No.1
No.1
No.1 No.1 No.1 No.1 No.1
0.00
10.00 20.00 30.00 40.00 50.00 60.00 70.00
80.00 90.00 数学
物理
历史
政治
体育
23.00
12.00
28.00
6.00
12.00
70.52
70.93
76.74
73.19
78.31
分数
科目
总分平均分分科意见No.1
539.0089.83全能生
536.0089.33全能生
520.0086.67全能生
522.0087.00全能生
312.5052.08体育特长生523.0087.17全能生
511.0085.17全能生
446.0074.33体育特长生248.0041.33体育特长生486.0081.00艺术特长生347.0057.83体育特长生312.0052.00体育特长生512.0085.33全能生
446.0074.33体育特长生423.0070.50体育特长生341.5056.92体育特长生417.0069.50需要重修
504.0084.00文科生
449.0074.83文科生
533.0088.83全能生
448.0074.67理科生
518.0086.33全能生
480.0080.00理科生
453.0075.50文科生
481.0080.17文科生
148.0024.67需要重修
523.0087.17全能生
402.0067.00需要重修
285.0047.50需要重修
539.0089.83
148.0024.67
436.7672.79
100.00
31
67.07
最高分
最低分
平均分
22.00
艺术