{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["版权及说明","原始数据及分析","报告"],"not_rendered":{"charts":1,"external_links":1,"defined_names":2,"comments":12},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"版权及说明","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,2,1,6],[4,0,4,1],[5,0,7,8],[8,0,10,8],[11,0,12,8]],"flags":["formulas_cached_only"]}
[]
[null,null,"试卷成绩分析系统"]
[]
[]
["使用说明："]
["1、程序由3张工作表组成，第一张为“使用说明”；第二张“原始数据及分析”用于录入成绩；第三张“报告”用于打印。点击左下角彩色标签可在三者之间作出选择。"]
[]
[]
["2、第二张工作表：“原始数据及分析”，录入后的数据均显示为红色，其他颜色单元格的内容不可修改。姓名可不填。没有数值的单元格一定保持空白！"]
[]
[]
["3、“报告”页，需要填入专业名称、年级、班级、教师姓名，其它数据及表格均自动生成，直接在“报告”页打印即可。"]

{"sheet":"原始数据及分析","index":1,"n_rows":259,"n_cols":19,"rows_kept":259,"merged":[[0,0,3,0],[0,1,1,1],[5,16,8,16],[26,16,26,18],[36,16,36,18],[42,16,44,16],[42,17,44,17],[42,18,44,18],[45,16,46,16],[45,17,46,18],[47,16,48,16],[47,17,48,17],[47,18,48,18]],"flags":["formulas_cached_only"]}
["序  号","     满分   姓名","题1","题2","题3","题4","题5","题6","题7","题8","题9","题10","题11","题12","总分"]
[null,null,30,10,20,10,15,15,{"$nulls":6},100,null,"试题数：",6]
[null,"平均分：",17.77777777777778,1.8888888888888888,9.333333333333334,4.944444444444445,7.222222222222222,6.777777777777778,"－","－","－","－","－","－",47.94444444444444,null,"学生数：",18]
[null,"方差：",75.12418300653596,7.398692810457516,25.41176470588235,10.761437908496733,21.124183006535947,13.006535947712417,"－","－","－","－","－","－",248.64379084967325]
[1,"李玉婷",15,0,5,3,12,10,{"$nulls":6},45]
[2,null,21,0,12,1,2,5,{"$nulls":6},41,null,"总分：","平均分：",{"v":47.94444444444444,"d":"47.94"}]
[3,null,25,0,13,2,4,6,{"$nulls":6},50,null,null,"标准差：",15.768442879678172]
[4,null,0,0,5,0,5,9,{"$nulls":6},19,null,null,"方差：",248.64379084967325]
[5,null,23,1,14,3,1,9,{"$nulls":6},51,null,null,"信度：",0.4624301767759744]
[6,null,5,0,12,4,2,2,{"$nulls":6},25]
[7,null,23,0,0,0,4,0,{"$nulls":6},27]
[8,null,28,1,6,6,13,7,{"$nulls":6},61,null,null,"区分度：","难度："]
[9,null,27,2,13,6,8,9,{"$nulls":6},65,null,"第1题：",0.6528213445616308,0.5925925925925927]
[10,null,15,3,14,10,9,9,{"$nulls":6},60,null,"第2题：",0.7212382756625644,0.18888888888888888]
[11,null,6,0,11,8,0,0,{"$nulls":6},25,null,"第3题：",0.2437140386404029,0.4666666666666667]
[12,null,23,5,10,8,11,3,{"$nulls":6},60,null,"第4题：",0.4923333875378274,0.49444444444444446]
[13,null,30,6,2,5,13,6,{"$nulls":6},62,null,"第5题：",0.7225547159589777,0.4814814814814815]
[14,null,14,1,13,9,7,8,{"$nulls":6},52,null,"第6题：",0.5500619846246945,0.45185185185185184]
[15,null,25,2,0,1,11,12,{"$nulls":6},51,null,"第7题：","－","－"]
[16,null,10,3,9,8,8,8,{"$nulls":6},46,null,"第8题：","－","－"]
[17,null,18,10,14,8,15,12,{"$nulls":6},77,null,"第9题：","－","－"]
[18,null,12,0,15,7,5,7,{"$nulls":6},46,null,"第10题：","－","－"]
["",{"$nulls":13},"",null,"第11题：","－","－"]
["",{"$nulls":13},"",null,"第12题：","－","－"]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},"",null,"频数："]
["",{"$nulls":13},"",null,"分段点","数量","区间"]
["",{"$nulls":13},"",null,39.9,4,"0～39"]
["",{"$nulls":13},"",null,59.9,8,"40～59"]
["",{"$nulls":13},"",null,69.9,5,"60～69"]
["",{"$nulls":13},"",null,79.9,1,"70～79"]
["",{"$nulls":13},"",null,89.9,0,"80～89"]
["",{"$nulls":13},"",null,100,0,"90～100"]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},"",null,"正态分布检验（矩法）"]
["",{"$nulls":13},"",null,null,"偏度","峰度"]
["",{"$nulls":13},"",null,"系数",-0.33488054754237795,-0.4138456337564329]
["",{"$nulls":13},"",null,"标准误",0.5362778990061086,1.0377950826345115]
["",{"$nulls":13},"",null,"u值",0.6244533816571909,0.3987739397510522]
["",{"$nulls":13},"",null,"概率值",0.5323305892926016,0.6900602065185013]
["",{"$nulls":13},"",null,"与正态分布相比是否有显著性差异","无","无"]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},"",null,"是否正态分布","是"]
["",{"$nulls":13},""]
["",{"$nulls":13},"",null,"分布形态","正常","正常"]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]
["",{"$nulls":13},""]

{"sheet":"报告","index":2,"n_rows":43,"n_cols":13,"rows_kept":43,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,1,3,3],[4,1,4,2],[4,3,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,14],[5,1,5,4],[11,1,11,3],[12,4,12,5],[12,7,12,8],[12,9,12,10],[13,2,13,6],[13,8,13,9],[13,10,13,11],[22,7,22,13],[23,0,40,14],[42,7,42,14]],"flags":["formulas_cached_only"]}
["哈尔滨石油学院试卷分析报告"]
["课程：                   20   -20   学年第   学期期末考试"]
["任课教师：       所属部门：         开课学院：         开课班级：           院长： "]
[null,"一、 试卷分析"]
[null,"  1. 信度分析：",null,"信度系数(克伦巴赫α系数)：",{"$nulls":4},{"v":0.4624301767759744,"d":"0.462"},null,"评价：",null,"可信"]
[null,"  2. 区分度和难度分析"]
[null,null,"第1题","第2题","第3题","第4题","第5题","第6题","第7题","第8题","第9题","第10题","第11题"]
[null,"区分度",{"v":0.6528213445616308,"d":"0.65"},{"v":0.7212382756625644,"d":"0.72"},{"v":0.2437140386404029,"d":"0.24"},{"v":0.4923333875378274,"d":"0.49"},{"v":0.7225547159589777,"d":"0.72"},{"v":0.5500619846246945,"d":"0.55"},"－","－","－","－","－"]
[null,"评价","非常好","非常好","尚好","非常好","非常好","非常好","－","－","－","－","－"]
[null,"难度",{"v":0.5925925925925927,"d":"0.59"},{"v":0.18888888888888888,"d":"0.19"},{"v":0.4666666666666667,"d":"0.47"},{"v":0.49444444444444446,"d":"0.49"},{"v":0.4814814814814815,"d":"0.48"},{"v":0.45185185185185184,"d":"0.45"},"－","－","－","－","－"]
[null,"评价","最难","最难","最难","最难","最难","最难","－","－","－","－","－"]
[null,"二、成绩分析"]
[null,null,"1. 平均分：",null,{"v":47.94444444444444,"d":"47.94"},null,null,"2. 标准差：",null,{"v":15.768442879678172,"d":"15.77"}]
[null,null,"3. 成绩分布直方图",{"$nulls":5},"学生数：",null,18]
{"$rows_empty":8}
[null,null,"4. 试卷分析及改进意见："]
["    一、试卷分析。总体来看，学生都能发挥出自己的实际水平，合格率都在96%以上，优秀率在10%左右。\n    1.填空重点考察前三章中XXX的基本概念，学生答题情况基本较好。说明学生对该部分客观知识掌握较扎实。  \n    2.此次计算题的考试，除了一贯有的口算、递等式计算以外，最要的是多了学生自主编题、用不同方法计算的题型，通过本次测验，我认识到学生的计算习惯真的要好好培养。 \n    3.对于应用题，培养学生利用XX知识解决XX问题的能力很关键。自己读懂题意，分析题意在现在来看是一种不可或缺的能力，很多学生因为缺少这种能力而在自己明明会做的题上失了分。    \n    二、改进意见。从试卷的方向来看，我认为今后在教学中可以从以下几个方面来改进：  \n    1.教材是我们的教学之本，在教学中，我们既要以教材为本，扎扎实实地渗透教材的重点、难点，不忽视有些自己以为无关紧要的知识；又要在教材的基础上，紧密联系生活，让学生多了解生活中的XX，用XX解决生活的问题。而且在教学上要有意识地与XX接轨。 \n    2.教学中要重在凸现学生的学习过程，培养学生的分析能力。在平时的教学中，作为教师应尽可能地为学生提供学习材料，创造自主学习的机会。尤其是在应用题的教学中，要让学生的思维得到充分的展示，让他们自己来分析题目，设计解题的策略。 \n    3.多做多练，切实培养和提高学生的计算能力。要学生说题目的算理，也许不一定会错，但有时他们是凭自己的直觉做题，不讲道理，不想原因。这点可以从试卷上很清晰地反映出来。学生排除计算干扰的本领。\n    4.关注生活，培养实践能力加强教学内容和学生生活的联系，让数学从生活中来，到生活中去是数学课程改革的重要内容。多做一些与生活有关联的题目，把学生的学习真正引向生活、引向社会，从而有效地培养学生解决问题的能力。 \n    5.关注过程，引导探究创新。XX教学不仅要使学生获得基础知识和基本技能，而且要着力引导学生进行自主探索，培养自觉发现新知、发现规律的能力。这样既能使学生对知识有深层次的理解，又能让学生在探索的过程中学会探索的科学方法。让学生的学习不仅知其然，还知其所以然。  "]
{"$rows_empty":18}
[{"$nulls":7},"年   月   日"]