{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["xx专业","统计"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"xx专业","index":0,"n_rows":50,"n_cols":17,"rows_kept":50,"merged":[[0,0,0,16],[1,0,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,1,10],[1,11,2,13],[1,14,2,15],[1,16,2,16],[2,7,3,7],[2,8,3,8],[2,9,2,10],[4,0,21,0],[4,1,18,1],[4,2,9,2],[10,2,13,2],[14,2,16,2],[17,2,18,2],[19,1,19,5],[20,3,20,5],[20,11,20,16],[21,1,21,5],[22,0,27,0],[22,1,23,2],[24,1,26,2],[27,1,27,5],[28,0,43,0],[28,1,35,2],[35,3,35,5],[36,1,42,2],[43,1,43,5],[44,0,47,0],[44,1,44,2],[45,1,46,2],[47,1,47,5],[48,0,48,5],[49,0,49,16]]}
["2022级《XXXX》专升本专业教学计划进程表"]
["课程\n类别",null,null,"序号","课程\n代码","课程名称","学分","计划学时数",{"$nulls":3},"第一学年",null,null,"第二学年",null,"开课单位"]
[{"$nulls":7},"合计","理论教学","实践教学"]
[{"$nulls":9},"实验","其它实践",1,2,3,4,5]
["通识课程平台","通识必修课程模块","思政类",1,"GE6279","马克思主义基本原理",3,48,40,null,8,3,{"$nulls":4},"马克思主义学院"]
[{"$nulls":3},2,"GE6185","中国近现代史纲要",3,48,40,null,8,null,3,{"$nulls":3},"马克思主义学院"]
[{"$nulls":3},3,"GE6179","形势与政策Ⅴ",0.25,8,8,null,null,0.25,{"$nulls":4},"马克思主义学院"]
[{"$nulls":3},4,"GE6180","形势与政策Ⅵ",0.25,8,8,{"$nulls":3},0.25,{"$nulls":3},"马克思主义学院"]
[{"$nulls":3},5,"GE6181","形势与政策Ⅶ",0.25,8,8,{"$nulls":5},0.25,null,"马克思主义学院"]
[{"$nulls":3},6,"GE6182","形势与政策Ⅷ",0.25,8,8,{"$nulls":6},0.25,"马克思主义学院"]
[null,null,"外语类",7,"GE6231","大学英语Ⅲ",3,48,48,null,null,3,{"$nulls":4},"外国语学院"]
[{"$nulls":3},8,"GE6233","大学英语Ⅳ",3,48,48,{"$nulls":3},3,{"$nulls":3},"外国语学院"]
[{"$nulls":3},9,"GE6232","大学英语Ⅲ（艺术类）",3,48,48,null,null,3,{"$nulls":4},"外国语学院"]
[{"$nulls":3},10,"GE6234","大学英语Ⅳ（艺术类）",3,48,48,{"$nulls":3},3,{"$nulls":3},"外国语学院"]
[null,null,"理工类",11,"GE6297","高等数学",4,64,64,null,null,4,{"$nulls":4},"基础教学院"]
[{"$nulls":3},12,"GE6278","线性代数",2,32,32,{"$nulls":3},2,{"$nulls":3},"基础教学院"]
[{"$nulls":3},13,"GE6298","概率论",2,32,32,{"$nulls":3},2,{"$nulls":3},"基础教学院"]
[null,null,"军事体育类",14,"GE6191","体育Ⅴ",0.5,16,null,null,16,0.5,{"$nulls":4},"基础教学院"]
[{"$nulls":3},15,"GE6192","体育Ⅵ",0.5,16,null,null,16,null,0.5,{"$nulls":3},"基础教学院"]
[null,"通识必修学分(学时)小计",{"$nulls":4},{"$f":"SUM(G5:G19)","v":28},{"$f":"SUM(H5:H19)","v":480},{"$f":"SUM(I5:I19)","v":432},null,{"$f":"SUM(K5:K19)","v":48},{"$f":"SUM(L5:L19)","v":13.75},{"$f":"SUM(M5:M19)","v":13.75},null,{"$f":"SUM(O5:O19)","v":0.25},{"$f":"SUM(P5:P19)","v":0.25}]
[null,"通识选修课程模块","创新创业类或艺术类","详见通识选修课程库",null,null,2,32,32,null,null,"最低学分要求为2学分。"]
[null,"通识选修学分（学时）要求",{"$nulls":4},2,32,32]
["学科及专业基础课程平台","学科基础课程模块",null,1]
[{"$nulls":3},2]
[null,"专业基础课程模块",null,3]
[{"$nulls":3},4]
[{"$nulls":3},5]
[null,"学科及专业基础学分/学时小计",{"$nulls":4},{"$f":"SUM(G23:G27)","v":0},0,0,0,0,{"$f":"SUM(L23:L27)","v":0},0,0,0,0]
["专业课程平台","专业必修课程模块",null,1]
[{"$nulls":3},2]
[{"$nulls":3},3]
[{"$nulls":3},4]
[{"$nulls":3},5]
[{"$nulls":3},6]
[{"$nulls":3},7]
[{"$nulls":3},"专业必修学分(学时)小计",null,null,{"$f":"SUM(G29:G35)","v":0},0,0,0,0,0,0,0,0,0]
[null,"专业选修课程模块",null,1,null,"XXXX",2,32,32,null,null,2]
[{"$nulls":3},2,null,"XXXXX",2,32,16,null,16,2]
[{"$nulls":3},3]
[{"$nulls":3},4]
[{"$nulls":3},5]
[{"$nulls":3},6]
[{"$nulls":3},7]
[null,"专业选修学分(学时)小计",{"$nulls":4},2,{"$f":"G44/SUM(G37:G43)*SUM(H37:H43)","v":32},{"$f":"G44/SUM(G37:G43)*SUM(I37:I43)","v":24},{"$f":"G44/SUM(G37:G43)*SUM(J37:J43)","v":0},{"$f":"G44/SUM(G37:G43)*SUM(K37:K43)","v":8},2]
["集中实践（必修）","专业实践类",null,1,null,"综合能力实训",4,{"$nulls":6},"4周",null,null,"专业所在学院"]
[null,"毕业\n设计类",null,2,null,"项目实训",10,{"$nulls":7},"10周（语言类专业为4周）",null,"专业所在学院"]
[{"$nulls":3},3,null,"毕业设计（论文）",8,{"$nulls":8},"12周","专业所在学院"]
[null,"集中实践必修学分(学时)小计",{"$nulls":4},{"$f":"SUM(G45:G47)","v":22},{"$nulls":6},4,10,8]
["学分（学时）总计",{"$nulls":5},{"$f":"G20+G22+G28+G36+G44+G48","v":54},544,488,0,56,15.75,13.75,4,10.25,8.25]
["备注：\n1、专业可自行选择在第一学期开设《大学英语Ⅲ》或第二学期开设《大学英语Ⅳ》课程，也可以根据专业需要不开设；\n2、各专业根据实际需要自行决定数学类课程的开设。"]

{"sheet":"统计","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,0,2,0],[0,1,0,7],[0,8,0,11],[0,12,2,12],[0,13,2,13],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,8,1,9],[1,10,1,11],[4,0,4,13],[5,0,7,0],[5,1,5,7],[5,8,5,11],[5,12,7,12],[5,13,7,13],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,8,6,9],[6,10,6,11],[9,0,9,13],[10,0,10,13],[11,0,11,13],[12,0,12,13],[13,0,13,13],[14,0,14,13]]}
["课程类别",{"$f":"\"必修课：\"&SUM(B4:H4)&\"学分\"","v":"必修课：50学分"},{"$nulls":6},{"$f":"\"选修课：\"&SUM(I4:L4)&\"学分\"","v":"选修课：4学分"},{"$nulls":3},"实践学分合计","总学分"]
[null,"通识必修",null,"学科基础必修",null,"专业必修",null,"集中实践","专业选修",null,"通识选修"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","实践","理论","实践"]
["学分",{"$f":"B9/16-1","v":26},{"$f":"C9/16-1","v":2},{"$f":"D9/16","v":0},0,0,0,22,{"v":1.5,"d":"2"},{"v":0.5,"d":"1"},2,0,{"$f":"C4+E4+G4+H4+J4+L4","v":{"v":24.5,"d":"25"}},{"$f":"xx专业!G49","v":54}]
[{"$f":"\"实践教学环节学分所占比例：\"&ROUND(M4/N4*100,2)&\"%\"","v":"实践教学环节学分所占比例：45.37%"}]
["课程类别",{"$f":"\"必修课：\"&SUM(B9:H9)&\"学时\"","v":"必修课：480学时"},{"$nulls":6},{"$f":"\"选修课：\"&SUM(I9:L9)&\"学时\"","v":"选修课：64学时"},{"$nulls":3},"实践学时合计","总学时"]
[null,"通识必修",null,"学科基础必修",null,"专业必修",null,"集中实践","专业选修",null,"通识选修"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","实践","理论","实践"]
["学时",{"$f":"xx专业!I20","v":432},{"$f":"(xx专业!J20+xx专业!K20)","v":48},{"$f":"xx专业!I28","v":0},{"$f":"(xx专业!J28+xx专业!K28)","v":0},{"$f":"xx专业!I36","v":0},{"$f":"(xx专业!J36+xx专业!K36)","v":0},"26周",{"$f":"xx专业!I44","v":24},{"$f":"(xx专业!J44+xx专业!K44)","v":8},{"$f":"xx专业!I22","v":32},0,{"$f":"C9+E9+G9+J9+L9&\"+\"&H9","v":"56+26周"},{"$f":"SUM(B9:G9)+SUM(I9:L9)&\"+\"&H9","v":"544+26周"}]
[{"$f":"\"实践教学环节学时所占比例：\"&ROUND((C9+E9+G9+J9+L9+LEFT(H9,2)*20)/((SUM(B9:G9)+SUM(I9:L9)+LEFT(H9,2)*20))*100,2)&\"%\"","v":"实践教学环节学时所占比例：54.14%"}]
["注："]
["1.集中性实践教学环节每周折算 20 学时;"]
["2. 实践教学环节学时所占比例=各类课程实践学时之和/总学时;"]
["3. 专业选修理论（实践）学时=（专业选修课最低要求学分/计划中列出的专业选修课学分之和）´专业选修课理论（实践）学时之和。"]
["4. 通识选修的学时=通识选修课的学分要求´16，全部列入理论学时。"]