{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data","Data_rel","分值表","难度区分度","信度分析","效度分析","说明","设计功能"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["样本号","选择题","填空","名词解释题","简答题","论述题","医案分析题","总分"]
[20150323001,29,7,6,10,7,8,67]
[20150323003,39,9,8,9,8,2,75]
[20150323005,35,8,9,10,9,2,73]
[20150323007,33,5,8,10,10,3,69]
[20150323009,64,6,6,8,10,5,69]
[20150323011,32,5,8,10,8,2,65]
[20150323013,36,8,9,10,10,8,81]
[20150323015,36,5,6,8,10,9,74]
[20150323017,35,4,8,8,7,3,65]
[20150323019,38,6,6,10,10,4,74]
[20150323021,40,10,8,8,7,10,83]
[20150323023,28,6,10,10,10,2,66]
[20150323025,42,8,9,10,10,10,89]
[20150323027,28,7,6,6,4,0,51]
[20150323029,41,9,9,10,10,9,88]
[20150323031,43,10,9,10,10,9,91]
[20150323033,38,7,9,9,10,9,82]
[20150323035,37,7,9,9,10,9,81]
[20150323037,41,9,10,10,10,2,82]
[20150323039,37,3,8,8,4,2,62]
[20150323041,36,10,8,9,10,3,76]
[20150323043,23,5,7,10,8,9,62]
[20150323045,38,10,9,10,10,10,87]
[20150323047,41,10,9,10,10,7,87]
[20150323049,32,7,9,8,6,5,67]
[20150323051,43,9,9,10,2,8,86]
[20150323053,35,7,8,9,9,2,70]
[20150323055,36,6,8,10,10,9,79]
[20150323057]
[20150323059,34,6,8,10,7,9,74]
[20150323061,38,6,7,10,7,9,77]
[20150323063,32,3,7,6,2,0,50]
[20150323065,29,4,7,8,6,8,62]
[20150323067,45,10,9,10,10,9,93]
[20150323069,27,5,6,10,8,7,63]
[20150323071,25,5,4,9,5,7,55]
[20150323073,28,6,6,9,4,2,55]
[20150323075,28,6,3,10,10,9,66]
[20150323077,37,8,10,10,7,9,81]
[20150323079,28,5,8,8,6,8,63]
[20150323083,31,5,6,9,5,8,64]
[20150323085,40,8,8,10,10,2,78]
[20150323087,39,8,9,10,9,2,77]

{"sheet":"Data_rel","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["样本号","选择题","填空","名词解释题","简答题","论述题","总分"]
[20150323001,29,7,6,10,7,67,126]
[20150323003,39,9,8,9,8,75,148]
[20150323005,35,8,9,10,9,73,144]
[20150323007,33,5,8,10,10,69,135]
[20150323009,64,6,6,8,10,69,163]
[20150323011,32,5,8,10,8,65,128]
[20150323013,36,8,9,10,10,81,154]
[20150323015,36,5,6,8,10,74,139]
[20150323017,35,4,8,8,7,65,127]
[20150323019,38,6,6,10,10,74,144]
[20150323021,40,10,8,8,7,83,156]
[20150323023,28,6,10,10,10,66,130]
[20150323025,42,8,9,10,10,89,168]
[20150323027,28,7,6,6,4,51,102]
[20150323029,41,9,9,10,10,88,167]
[20150323031,43,10,9,10,10,91,173]
[20150323033,38,7,9,9,10,82,155]
[20150323035,37,7,9,9,10,81,153]
[20150323037,41,9,10,10,10,82,162]
[20150323039,37,3,8,8,4,62,122]
[20150323041,36,10,8,9,10,76,149]
[20150323043,23,5,7,10,8,62,115]
[20150323045,38,10,9,10,10,87,164]
[20150323047,41,10,9,10,10,87,167]
[20150323049,32,7,9,8,6,67,129]
[20150323051,43,9,9,10,2,86,159]
[20150323053,35,7,8,9,9,70,138]
[20150323055,36,6,8,10,10,79,149]
[20150323057,null,null,null,null,null,null,0]
[20150323059,34,6,8,10,7,74,139]
[20150323061,38,6,7,10,7,77,145]
[20150323063,32,3,7,6,2,50,100]
[20150323065,29,4,7,8,6,62,116]
[20150323067,45,10,9,10,10,93,177]
[20150323069,27,5,6,10,8,63,119]
[20150323071,25,5,4,9,5,55,103]
[20150323073,28,6,6,9,4,55,108]
[20150323075,28,6,3,10,10,66,123]
[20150323077,37,8,10,10,7,81,153]
[20150323079,28,5,8,8,6,63,118]
[20150323083,31,5,6,9,5,64,120]
[20150323085,40,8,8,10,10,78,154]
[20150323087,39,8,9,10,9,77,152]
[null,49.162020905923285,4.0278745644599301,2.4297328687572608,1.1614401858304317,5.7311265969802516,121.26422764227667]

{"sheet":"分值表","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[null,"选择题","填空","名词解释题","简答题","论述题","医案分析题","总分"]
["满分值*",50,10,10,10,10,10,100]
[]
["考试科目*","伤寒论"]
[]
[]
["使用说明：","1.请在灰色单元格中填写各题型分值，即如果学生全部答对，该题的得分"]
[null,"2.请在录完[Data]表数据后再填写本表，对[Data]表首行的修改会导致本表分值全部清空"]
[null,"3.[Data]表中必须录入试卷总分"]
[null,"4.[考试科目]为必填"]

{"sheet":"难度区分度","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["项目","平均分","标准差","难度值","难度说明","区分度值","区分效果"]
["选择题",35.639999389648438,7.0100002288818359,0.70999997854232788,{"$f":"IF(D2>=0.75,\"容易\",IF(D2>=0.6,\"中档\",\"难\"))","v":"中档"},0.64999997615814209,{"$f":"IF(F2>=0.4,\"非常好\",IF(F2>=0.3,\"较好\",IF(F2>=0.2,\"一般\",\"较差\")))","v":"非常好"}]
["填空",6.8600001335144043,2.0099999904632568,0.68999999761581421,"中档",1.0099999904632568,"非常好"]
["名词解释题",7.7600002288818359,1.559999942779541,0.77999997138977051,"容易",0.75,"非常好"]
["简答题",9.2399997711181641,1.0800000429153442,0.92000001668930054,"容易",0.47999998927116394,"非常好"]
["论述题",7.9800000190734863,2.3900001049041748,0.80000001192092896,"容易",1.1200000047683716,"非常好"]
["医案分析题",5.9499998092651367,3.309999942779541,0.5899999737739563,"难",1.5299999713897705,"非常好"]
["总分",72.830001831054688,11.010000228881836,0.73000001907348633,"中档",0.55000001192092896,"非常好"]

{"sheet":"信度分析","index":4,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Cronbach's Alpha","删除[选择题]后的\r\nCronbach's Alpha值","删除[填空]后的\r\nCronbach's Alpha值","删除[名词解释题]后的\r\nCronbach's Alpha值","删除[简答题]后的\r\nCronbach's Alpha值","删除[论述题]后的\r\nCronbach's Alpha值","删除[医案分析题]后的\r\nCronbach's Alpha值"]
[0.93400000000000005,0.9,0.93600000000000005,0.94,0.93899999999999995,0.93700000000000006,0.94899999999999995]

{"sheet":"效度分析","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"选择题","填空","名词解释题","简答题","论述题","医案分析题","总分"]
["选择题",1]
["填空",0.28199999999999997,1]
["名词解释题",1.2999999999999999E-2,0.41499999999999998,1]
["简答题",-0.04,0.254,0.442,1]
["论述题",0.19700000000000001,0.17799999999999999,0.17799999999999999,0.45300000000000001,1]
["医案分析题",0.18099999999999999,0.309,9.0999999999999998E-2,0.29499999999999998,0.23300000000000001,1]
["总分",0.47399999999999998,0.70699999999999996,0.53800000000000003,0.52500000000000002,0.41699999999999998,0.65700000000000003,1]

{"sheet":"说明","index":6,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,0,23,10],[24,0,24,10],[13,0,13,9],[14,0,14,9],[25,0,26,10]]}
["难度评价表"]
["取值范围","难度"]
["0.75-1.00","容易"]
["0.60-0.74","中档"]
["0.00-0.59","难"]
[]
["区分度评价表"]
["取值范围","区分度"]
[">0.4","好"]
["0.3-0.39","较好"]
["0.2-0.29","一般"]
["<0.19","较差"]
[]
["　　难度是指试题的难易程度，是评价试卷的一个非常重要的一个指标。一个题目，如果大部分考生都能答对，那么这个题目的难度就小；如果大部分考生都不能答对，那么这个题目的难度就大。"]
["　　区分度是指试卷题目对考生心理特征的区分能力。区分度高的试题能将不同水平的考生区分开来，水平高的考生得高分，水平低的考生得低分。区分度高的试卷，优秀、一般、差三个层次的学生都有一定比例，如果某一分数区间学生相对集中，高分太多或不及格太多的试卷，区分度则低。"]
[]
["效度评价表"]
["取值范围","效度"]
[">0.7","好"]
["0.4-0.7","较好"]
["0-0.4","一般/较差"]
[]
[]
["　　效度分析主要考察各题型得分与试卷总分的相关系数。总成绩能反映学生对本课程的总体掌握水平，一般来说，总成绩高则各题型分数也比较高，二者呈线性正相关关系较合理。若出现某题与总分相关度很低，甚至负相关，则有可能是该题太难、或太简单、或区分度太低，甚至可能是答案错误。一般来说，相关系数大于0.7则效度很好，系数介于0.4-0.7之间，则效度较好，如小于0.4，则效度较差。"]
["　　信度Cronbach Alpha值是反映试卷的题目得分一致性程度的统计量, 表示考试的可靠性, 取值范围为0 ～ 1, 其值越大, 信度越高。如果内在信度系数在0.8以上，则可以认为试卷有较高的内在一致性。\n　　【删除[题目N]后的Cronbach Alpha值】是指删除某题后（即剔除该题对总分的影响）, 余下的部分占总成绩方差的百分比。如果删除该题后整份试卷的信度显著增加，则说明该题目的存在拉低了试卷的总信度，影响了试卷质量，该题目可能可能存在问题。可根据学生答题情况，进一步对试卷进行检查，找到明确原因，为今后的命题提供参考。"]
[]
[]
["信度评价表"]
["Cronbach's a","内部一致性"]
["0.9 ≤ α","非常好"]
["0.8 ≤ α < 0.9","好"]
["0.7 ≤ α < 0.8","可接受"]
["0.6 ≤ α < 0.7","需较大修订"]
["0.5 ≤ α < 0.6","不合格"]
["α < 0.5","无效试卷"]
[]
[]
["Cronbach's a","Internal consistency"]
["0.9 ≤ α","Excellent"]
["0.8 ≤ α < 0.9","Good"]
["0.7 ≤ α < 0.8","Acceptable"]
["0.6 ≤ α < 0.7","Questionable"]
["0.5 ≤ α < 0.6","Poor"]
["α < 0.5","Unacceptable"]

{"sheet":"设计功能","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["版本","功能"]
["1.0.0","主界面"]
["1.0.0","格式检查"]
["1.0.0","信度分析"]
["1.0.0","生成Word文件"]
["1.0.0","效度分析"]
["1.0.0","行标题数量与数据数量应一致"]
["1.0.0","处理前空值设为0"]
["1.0.0","如数据有问题，禁止分析"]
["1.0.0","优化报告说明文字"]