| 用EXCEL制作成绩单及成绩分析 |
| |
| 引用本文： | 楼建华,赵珂. 用EXCEL制作成绩单及成绩分析[J]. 兵团教育学院学报, 2006, 16(4): 60-62 |
| |
| 作者姓名： | 楼建华 赵珂 |
| |
| 作者单位： | 石河子大学信息科学与技术学院,新疆,石河子市,832003 |
| |
| 摘 要： | 文中给出了一个用Excel制作的成绩单模板,有了此模板,用户只需填入期末、平时成绩和学分等参数,即可得到各考生总评分、积分和全体考生期末考试成绩分布图、平均分、根方差等。
|
| 关 键 词： | Excel 成绩单 试卷 统计 分析 |
| 文章编号： | 1009-1548（2006）04-0060-03 |
| 收稿时间： | 2006 |
Using Excel to Make Score Sheet and Score Analysis |
| |
| LOU Jian-hua,ZHAO Ke. Using Excel to Make Score Sheet and Score Analysis[J]. Journal of Bingtuan Education Institute, 2006, 16(4): 60-62 |
| |
| Authors: | LOU Jian-hua ZHAO Ke |
| |
| Affiliation: | Department of Mathematics, Shihezi University, Shihezi 832003, China |
| |
| Abstract: | This article presents a model board of score sheetby using Excel.When users have this model board,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 and so on. |
| |
| Keywords: | Excel score sheet examination paper statistics analysis |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
