{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["样例","说明","注意事项及示例"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"样例","index":0,"n_rows":13,"n_cols":81,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,16]]}
["time","seq1","pro","county","school","grade","class","name","address","学科总成绩","年级排名","语文成绩","数学成绩","英语成绩","物理成绩","历史成绩","studentID","sex","formID","Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10","Q11","Q12","Q13","Q14","Q15","Q16","Q17","Q18","Q19","Q20","Q21","Q22","Q23","Q24","Q25","Q26","Q27","Q28","Q29","Q30","Q31","Q32","Q33","Q34","Q35","Q36","Q37","Q38","Q39","Q40","Q41","Q42","Q43","Q44","Q45","Q46","Q47","Q48","Q49","Q50","Q51","Q52","Q53","Q54","Q55","Q56","HELP1","HELP2","TIME1","TIME2","PATH1","PATH2"]
[20160810,1,"北京","海淀区","北京六中",7,"01","毛良剑","市区",{"$nulls":7},"670001","F",6,"A","B","E","E","B","D","C","C","B","B","E","C","A","D","A","A","C","C","A","C","B","D","B","C","D","B","A","D","C","D","C","D","C","B","B","C","B","A","B","C","D","D","D","C","B","B","C","D","B","D","A","A","C","A","A","D",0,3,78,62,"A/B/A","B"]
[20160810,2,"山东省","德州市","德州市第一中学",7,"01","闫安安","县镇",{"$nulls":7},"670002","M",6,"D","A","D","C","B","E","E","A","D","A","C","D","E","E","C","C","C","C","D","C","B","D","B","C","D","B","A","C","C","D","C","B","C","B","D","A","D","B","B","C","A","B","D","C","B","B","C","D","D","D","B","A","C","A","A","D",1,0,54,76,"C/D","D/D/C/A"]
[{"$nulls":8},"各选项的具体范围为：\n1.市区是指家庭住址在省所辖某市内，包括划入市内各区的城郊村镇。\n2.县镇是指家庭住址在市所辖的县城及县城所辖的乡镇上。\n3.农村是指家庭住址在乡镇所辖的未划入城镇的村庄、农场、林场等区域。"]
[]
["注意：","F为女性"]
[null,"M为男性。"]
[null,"Pro为省"]
[null,"county为市或区"]
[null,"address为家庭住址。市区、县镇、农村、"]
[null,"总分成绩和排名"]
[null,"学科成绩：根据考生考试科目动态生成，列名为“科目名称”+“成绩”，若该科目考生不需填的成绩，则显示大写字母“O”。"]
[null,"1.保存格式：用EXCEL文件格式电子表格保存；\n2.标黄为网报提供给汇总工具的字段；\n3.一个考生只有一条记录，该考生所有参加的科目的作答情况依次在一行中显示出来； \n  1）应考未考（缺考）：作答用“#”标识；答题时间用大写字母“O”标识；求助次数用大写字母“O”标识；答案修改记录用大写字母“O”标识；\n  2）应考漏答未答：用大写字母“O”标识；答题时间按实际试题停留时间累积，若根本未浏览过该题，答题时间为0；求助次数按实际求助次数累计，答案修改则不记录；\n  3）不应考：不填入任何数据；\n  4）科目排列按课程代码排序；\n4.HELP1、HELP2、……：英文阅读理解、完型填空等题型求助次数记录；\n5.TIME1、TIME2、……：答题时长记录，与试题对应，单位为秒。累计答题时长。\n6.PATH1、PATH2......：每道题目的答案修改的记录（如果第一次只浏览了题目，并没有作答，则不记录，只对答案的选择和修改进行记录），若考生对某一道题目的答案修改过程为，一开始选择了A，然后又选择了C，然后又选择了A，记录为A/C/A（用箭头也可以）。\n\n\n\n\n"]

{"sheet":"说明","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,8,0]]}
[null,"表头标题","中文含义","输入内容","编码要求","格式要求"]
["这部分信息由网报系统提供。（学生进入高考，只填写相应的试卷编码以及题目作答反应。）","time","测试时间","当天测试学能量表的年月日","“YYYYMMDD”日期格式----同一批次考试时间相同","无空格，居中对齐，字号10，宋体。"]
[null,"seq1","大序","总体考生序号","学生人数编号1,2,3,4,…,N","无空格，居中对齐，字号11，宋体。"]
[null,"school","就读学校名称","就读学校名称","学校中文全称，例朝凤小学","无空格，居中对齐，字号12，宋体。"]
[null,"grade","年级","年级编号","年级编号为数字，1,2,3,4,5….如有缺失，输入“O”（大写O)","无空格，居中对齐，字号13，宋体。"]
[null,"class","班级","班级编号","班级编号为数字，例七年级1班，71,如有缺失，输入“O”（大写O)","无空格，居中对齐，字号14，宋体。"]
[null,"name","姓名","考生姓名","输入考生姓名,如有缺失，输入“O”（大写O)","无空格，居中对齐，字号15，宋体。"]
[null,"studentID","考生准考证号","考生准考证号","如有缺失，输入“O”（大写O)","无空格，居中对齐，字号16，宋体。"]
[null,"sex","性别","考生性别编号","男性为M,女性为F,如有缺失，输入“O”（大写O)","无空格，居中对齐，字号17，宋体。"]
[null,"formID","试卷编号","考生试卷编号（对应题库里的试卷名称）","如有缺失，输入“O”（大写O)","无空格，居中对齐，字号22，宋体。"]
[null,"Q1","试卷题目","考生在各个题目上的作答","输入选项答案，A,B,C,D····，如有缺失，输入“O”（大写O)","无空格，居中对齐，字号23，宋体。"]
[null,"HELP1","求助次数","个别英文题型（阅读理解、完型填空等）求助次数","一篇文章一个统计数据，编号从1开始，顺序往后编写即可,默认为0次","无空格，居中对齐，字号24，宋体。"]
[null,"TIME1","每题答题时长","每题答题时长计时","和Q1对应起来，单位是秒","无空格，居中对齐，字号25，宋体。"]
[null,"PAHT1","每题答题修改记录","每题答题修改记录","和Q1对应起来,如有缺失，输入“O”（大写O)","无空格，居中对齐，字号26，宋体。"]
[]
[null,null,"用csv格式电子表格保存。"]

{"sheet":"注意事项及示例","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,2],[12,0,12,10],[13,0,13,11]]}
["注意：","内容","错误示例1","错误示例2","正确示例"]
[1,"seq1,grade,class的填写均用阿拉伯数字，请检查不要出现字符等其他不统一格式(除了缺失编码“O”除外）。","8",null,8]
[2,"单元格中不要出现空格","    A",null,"A"]
[3,"用大写\"O\"表示缺失，不要用小写o以及数字0","o",0,"O"]
[]
["准考证号：","不设上限，由网报系统决定"]
["年级：2位","1年级为01，以此类推。"]
["班级：2位","1班为01，以此类推。目前网报没有收集这个信息，导入机考时默认值为缺失值O"]
[]
[]
[]
[]
["本数据格式既用于学能量表也用于非认知量表，区别在于不同的测验的formID不同（formID为试卷名称）和作答不同（学能测验选项是A,B,C,D；非认知问卷的选项是A,B,C,D,E）"]
[]
[]
[]
[]
[]
[null,"保存格式：用csv格式电子表格保存。"]