用EXCEL制作成绩单及成绩分析

Using Excel to Make Score Sheet and Score Analysis

文中给出了一个用Excel制作的成绩单模板,有了此模板,用户只需填入期末、平时成绩和学分等参数,即可得到各考生总评分、积分和全体考生期末考试成绩分布图、平均分、根方差等。

This article presents a model hoard of score sheetby using Excel. When users have this model hoard, they can get every student＇s total score, accumulated score, final examination score analysis diagram, average marks and standard variance of all the students who graph for final examination by filling some parameters into model board, such as final marks, normal score credit end so on.