{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet2"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet2","index":0,"n_rows":25,"n_cols":25,"rows_kept":25,"merged":[[0,0,0,24],[1,0,1,24],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,9],[2,10,2,16],[2,17,2,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[24,0,24,24]],"flags":["formulas_cached_only"]}
["武汉工商学院学生课程平时成绩记录表（2020-2021学年第二学期）"]
["开课单位：管理学院      课程名称：中级财务会计          学生班级：19会计本科3班           任课教师：BBB"]
["序号","学号","姓名","考勤得分（30分）",{"$nulls":6},"作业/实验得分（30分）",{"$nulls":6},"课堂表现（20分）",{"$nulls":3},"期中\n测验\n20分","其他\n加分\n5分","平时成\n绩总评","备注"]
[{"$nulls":3},"月\n日","月\n日","月\n日","月\n日","月\n日","月\n日","考勤\n总评","月\n日","月\n日","月\n日","月\n日","月\n日","月\n日","作业\n总评",1,2,3,"课堂\n总评"]
[1,17101001,"AA1",5,5,5,5,5,5,30,80,70,60,90,60,70,{"v":21.599999999999998,"d":"22"},-5,null,null,15,18,null,{"v":84.6,"d":"85"}]
[2,17101002,"AA2",5,0,5,5,5,5,25,60,70,75,90,75,70,{"v":22.2,"d":"22"},{"$nulls":3},20,17,5,{"v":89.2,"d":"89"},"课堂回答问题准确"]
[3,17101003,"AA3",5,5,0,5,5,5,25,75,70,90,90,90,70,{"v":24.9,"d":"25"},null,-5,null,15,12,null,{"v":76.9,"d":"77"}]
[4,17101004,"AA4",5,5,5,5,3,5,28,90,60,65,90,65,70,{"v":22.2,"d":"22"},{"$nulls":3},20,16,null,{"v":86.2,"d":"86"}]
[5,17101005,"AA5",5,5,5,5,5,5,30,65,75,75,90,75,70,{"v":22.8,"d":"23"},{"$nulls":3},20,16,null,{"v":88.8,"d":"89"}]
[6,17101006,"AA6",5,5,0,5,5,0,20,75,90,80,90,80,70,{"v":24.9,"d":"25"},{"$nulls":3},20,15,null,{"v":79.9,"d":"80"}]
[7,17101007,"AA7",5,5,5,5,5,5,30,80,65,80,90,80,70,{"v":23.7,"d":"24"},{"$nulls":3},20,16,null,{"v":89.7,"d":"90"}]
[8,17101008,"AA8",5,5,5,5,5,5,30,80,75,70,60,70,60,{"v":21.3,"d":"21"},{"$nulls":3},20,17,null,{"v":88.3,"d":"88"}]
[9,17101009,"AA9",5,5,5,4,5,5,29,70,80,90,75,90,75,{"v":24.3,"d":"24"},null,-5,null,15,14,null,{"v":82.3,"d":"82"}]
[10,17101010,"AA10",5,5,4,5,5,5,29,90,80,75,90,75,90,{"v":24.599999999999998,"d":"25"},{"$nulls":3},20,18,null,{"v":91.6,"d":"92"}]
[11,17101011,"AA11",5,5,5,5,5,5,30,75,70,55,65,55,65,{"v":19.2,"d":"19"},{"$nulls":3},20,13,null,{"v":82.2,"d":"82"}]
[12,17101012,"AA12",5,5,5,5,5,5,30,55,90,85,75,80,75,{"v":23.099999999999998,"d":"23"},{"$nulls":3},20,11,null,{"v":84.1,"d":"84"}]
[13,17101013,"AA13",5,4,5,0,5,5,24,65,75,85,80,80,80,{"v":23.099999999999998,"d":"23"},{"$nulls":3},20,20,5,{"v":92.1,"d":"92"},"课堂回答问题准确"]
[14,17101014,"AA14",5,5,5,5,5,5,30,75,55,85,80,80,80,{"v":22.5,"d":"23"},-5,null,null,15,18,null,{"v":85.5,"d":"86"}]
[15,17101015,"AA15",5,5,5,5,4,5,29,85,70,85,70,80,70,{"v":23.4,"d":"23"},{"$nulls":3},20,16,null,{"v":88.4,"d":"88"}]
[16,17101016,"AA16",5,5,5,5,5,5,30,85,70,85,90,80,90,{"v":24.599999999999998,"d":"25"},{"$nulls":3},20,19,null,{"v":93.6,"d":"94"}]
[17,17101017,"AA17",5,5,5,5,5,5,30,90,70,85,75,80,75,24,{"$nulls":3},20,20,5,99,"课堂回答问题准确"]
[18,17101018,"AA18",5,3,5,5,5,5,28,80,70,85,55,80,55,{"v":22.2,"d":"22"},null,null,-5,15,16,null,{"v":81.2,"d":"81"}]
[19,17101019,"AA19",5,5,5,5,3,5,28,80,70,85,90,80,70,{"v":24.3,"d":"24"},{"$nulls":3},20,18,null,{"v":90.3,"d":"90"}]
[20,17101020,"AA20",5,5,5,5,5,5,30,80,70,85,90,80,70,{"v":24.3,"d":"24"},{"$nulls":3},20,18,null,{"v":92.3,"d":"92"}]
["备注：\n1.本课程平时成绩由考勤得分、作业/实验得分、课堂表现得分、期中测验得分、其他加分五部分组成，占课程总评成绩的40%；\n2.考勤得分占平时成绩比例的30%，共计6次有效考勤，每次到勤得5分，请假得4分，迟到早退得3分，缺勤得0分；\n3.作业得分占平时成绩比例的30%，共计6次作业，6次作业的平均分乘以0.3为作业总评分；\n4.课堂表现占平时成绩比例的20%，采取负分制计，每生的初始得分均为20分，每次课堂违纪（睡觉、玩手机等行为）扣5分，扣完为止；\n5.期中测验占平时成绩比例的20%，按期中考核成绩如实计入；\n6.其他加分最高可加5分，以鼓励在课程学习过程中在某方面表现突出学生，加分后平时成绩超过100分的按100分计。\n重要说明：此表仅作为参考，各任课教师可根据此表，在教学大纲规定的考核形式和平时成绩比例要求下，自行设置课程平时成绩的构成和评定细则，但自行设置的成绩记录表均应能较全面地记录和反映学生课程的平时学习情况。此表应妥善保存，直接装订入试卷册中。"]