{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,0,0,6],[1,0,1,1],[2,0,4,0],[2,5,4,5],[2,6,4,6],[5,0,7,0],[5,5,7,5],[5,6,7,6],[6,8,16,14],[8,0,10,0],[8,5,10,5],[8,6,10,6],[11,0,13,0],[11,5,13,5],[11,6,13,6],[14,0,16,0],[14,5,16,5],[14,6,16,6],[17,0,19,0],[17,5,19,5],[17,6,19,6],[20,0,20,1],[21,0,21,1],[22,0,22,1],[22,2,22,6]]}
["课程目标达成情况数据表计算工具"]
["考核方式",null,"课程目标1","课程目标2","课程目标3","总分","考核i占总成绩比例"]
["示例","分数分配Hij","H11=30","H12=30","H13=40","100=H11+H2+H13","Mi"]
[null,"目标j学生平均成绩Fij","F11=25","F12=21","F13=30"]
[null,"目标j考核i占比Aij","A11=H11/总分*Mi","A12=H12/总分*Mi","A13=H13/总分*Mi"]
["过程考核方式1","分数分配H",30,30,40,{"$f":"C6+D6+E6","v":100},{"v":0.1,"d":"10%"}]
[null,"学生平均成绩F",25,21,30,{"$nulls":3},"填表说明：\n   （1）课程目标1达成度=(F11项班级学生平均成绩/H11*A11+F21项班级学生平均成绩/H21*A21+┄+Fn1项班级学生平均成绩/Hn1*An1)/∑Ai1，  类似可计算课程目标2达成度, 课程目标3达成度，…\n   （2）课程目标达成度=课程目标1达成度*∑Ai1+课程目标2达成度*∑Ai2+课程目标3达成度*∑Ai3+…\n   （3）表中绿底单元格内容，根据课程大纲等相关材料中各考核方式在总成绩所占比重以及各种考核方式对应的目标，确定具体的分值 \n   （4）表中黄底单元格内容，为各考核方式对应各目标学生的平均成绩；其他白底单元格中数据参考编辑公式自动生成"]
[null,"占比A%",{"$f":"C6/F6*G6","v":{"v":0.03,"d":"3.0%"}},{"$f":"D6/F6*G6","v":{"v":0.03,"d":"3.0%"}},{"$f":"E6/F6*G6","v":{"v":0.04000000000000001,"d":"4.0%"}}]
["过程考核方式2","分数分配H",20,30,50,{"$f":"C9+D9+E9","v":100},{"v":0.2,"d":"20%"}]
[null,"学生平均成绩F",15,25,40]
[null,"占比A%",{"$f":"C9/F9*G9","v":{"v":0.04000000000000001,"d":"4.0%"}},{"$f":"D9/F9*G9","v":{"v":0.06,"d":"6.0%"}},{"$f":"E9/F9*G9","v":{"v":0.1,"d":"10.0%"}}]
["过程考核方式3","分数分配H",40,30,30,{"$f":"C12+D12+E12","v":100},{"v":0.1,"d":"10%"}]
[null,"学生平均成绩F",30,25,25]
[null,"占比A%",{"$f":"C12/F12*G12","v":{"v":0.04000000000000001,"d":"4.0%"}},{"$f":"D12/F12*G12","v":{"v":0.03,"d":"3.0%"}},{"$f":"E12/F12*G12","v":{"v":0.03,"d":"3.0%"}}]
["读书笔记","分数分配H",70,15,15,{"$f":"C15+D15+E15","v":100},{"v":0.1,"d":"10%"}]
[null,"学生平均成绩F",70,10,10]
[null,"占比A%",{"$f":"C15/F15*G15","v":{"v":0.06999999999999999,"d":"7.0%"}},{"$f":"D15/F15*G15","v":{"v":0.015,"d":"1.5%"}},{"$f":"E15/F15*G15","v":{"v":0.015,"d":"1.5%"}}]
["期末考试","分数分配H",50,30,20,{"$f":"C18+D18+E18","v":100},{"v":0.5,"d":"50%"}]
[null,"学生平均成绩F",30,28,12]
[null,"占比A%",{"$f":"C18/F18*G18","v":{"v":0.25,"d":"25.0%"}},{"$f":"D18/F18*G18","v":{"v":0.15,"d":"15.0%"}},{"$f":"E18/F18*G18","v":{"v":0.1,"d":"10.0%"}}]
["各课程目标权重",null,{"$f":"C8+C11+C14+C17+C20","v":{"v":0.43,"d":"43.0%"}},{"$f":"D8+D11+D14+D17+D20","v":{"v":0.28500000000000003,"d":"28.5%"}},{"$f":"E8+E11+E14+E17+E20","v":{"v":0.28500000000000003,"d":"28.5%"}},null,{"$f":"G6+G9+G12+G15+G18","v":{"v":1,"d":"100%"}}]
["各课程目标达成情况",null,{"$f":"(C7/C6*C8+C10/C9*C11+C13/C12*C14+C16/C15*C17+C19/C18*C20)/C21","v":{"v":0.7093023255813955,"d":"0.71"}},{"$f":"(D7/D6*D8+D10/D9*D11+D13/D12*D14+D16/D15*D17+D19/D18*D20)/D21","v":{"v":0.863157894736842,"d":"0.86"}},{"$f":"(E7/E6*E8+E10/E9*E11+E13/E12*E14+E16/E15*E17+E19/E18*E20)/E21","v":{"v":0.7192982456140351,"d":"0.72"}}]
["课程目标达成情况",null,{"$f":"C22*C21+D22*D21+E22*E21","v":0.756}]