{"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":52,"n_cols":17,"rows_kept":52,"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,24,0],[4,1,21,1],[4,2,9,2],[10,2,13,2],[14,2,19,2],[20,2,21,2],[22,1,22,5],[23,3,23,5],[23,11,23,16],[24,1,24,5],[25,0,30,2],[30,3,30,5],[31,0,46,0],[31,1,38,2],[38,3,38,5],[39,1,45,2],[46,1,46,5],[47,0,50,0],[47,1,47,2],[48,1,49,2],[50,1,50,5],[51,0,51,5]]}
["2021级《XXXX》专升本专业教学计划进程表"]
["课程\n类别",null,null,"序号","课程\n代码","课程名称","学分","计划学时数",{"$nulls":3},"第一学年",null,null,"第二学年",null,"开课单位"]
[{"$nulls":7},"合计","理论教学","实践教学"]
[{"$nulls":9},"实验","其它实践",1,2,3,4,5]
["通识课程平台","通识必修课程模块","思政类",1,"GE6224","马克思主义基本原理概论",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","形势与政策V",0.25,8,8,null,null,0.25,{"$nulls":4},"基础教学院"]
[{"$nulls":3},4,"GE6180","形势与政策VI",0.25,8,8,{"$nulls":3},0.25,{"$nulls":3},"基础教学院"]
[{"$nulls":3},5,"GE6181","形势与政策VII",0.25,8,8,{"$nulls":5},0.25,null,"基础教学院"]
[{"$nulls":3},6,"GE6182","形势与政策VIII",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,"GE6173","高等数学Ⅰ（理工类）",6,96,96,null,null,6,{"$nulls":4},"基础教学院"]
[{"$nulls":3},12,"GE6045","高等数学Ⅱ（理工类）",4,64,64,{"$nulls":3},4,{"$nulls":3},"基础教学院"]
[{"$nulls":3},13,"GE6042","高等数学Ⅰ（经济类）",4,64,64,null,null,4,{"$nulls":4},"基础教学院"]
[{"$nulls":3},14,"GE6043","高等数学Ⅱ（经济类）",4,64,64,{"$nulls":3},4,{"$nulls":3},"基础教学院"]
[{"$nulls":3},15,"GE6001","线性代数",3,48,48,null,null,3,{"$nulls":4},"基础教学院"]
[{"$nulls":3},16,"GE6009","概率论与数理统计",3,48,48,{"$nulls":3},3,{"$nulls":3},"基础教学院"]
[null,null,"军事体育类",17,"GE6191","体育Ⅴ",0.5,16,null,null,16,0.5,{"$nulls":4},"基础教学院"]
[{"$nulls":3},18,"GE6192","体育Ⅵ",0.5,16,null,null,16,null,0.5,{"$nulls":3},"基础教学院"]
[null,"通识必修学分(学时)小计",{"$nulls":4},{"$f":"SUM(G5:G22)","v":44},{"$f":"SUM(H5:H22)","v":736},{"$f":"SUM(I5:I22)","v":688},null,{"$f":"SUM(K5:K22)","v":48},{"$f":"SUM(L5:L22)","v":22.75},{"$f":"SUM(M5:M22)","v":20.75},null,{"$f":"SUM(O5:O22)","v":0.25},{"$f":"SUM(P5:P22)","v":0.25}]
[null,"通识选修课程模块","创新创业类","详见通识选修课程库",null,null,2,32,32,null,null,"最低学分要求为2学分。"]
[null,"通识选修学分（学时）要求",{"$nulls":4},2,32,32]
["学科基础\n课程平台",null,null,1]
[{"$nulls":3},2]
[{"$nulls":3},3]
[{"$nulls":3},4]
[{"$nulls":3},5]
[{"$nulls":3},"学科基础必修学分(学时)小计",null,null,{"$f":"SUM(G26:G30)","v":0},0,0,0,0,{"$f":"SUM(L26:L30)","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(G32:G38)","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":"G47/SUM(G40:G46)*SUM(H40:H46)","v":32},{"$f":"G47/SUM(G40:G46)*SUM(I40:I46)","v":24},{"$f":"G47/SUM(G40:G46)*SUM(J40:J46)","v":0},{"$f":"G47/SUM(G40:G46)*SUM(K40:K46)","v":8},2]
["集中实践（必修）","专业实践类",null,1,null,"综合实践Ⅲ(项目实践)",4,{"$nulls":6},4,null,null,"专业所在学院"]
[null,"毕业\n设计类",null,2,null,"毕业实习",4,{"$nulls":7},4,null,"专业所在学院"]
[{"$nulls":3},3,null,"毕业设计（论文）",8,{"$nulls":8},8,"专业所在学院"]
[null,"集中实践必修学分(学时)小计",{"$nulls":4},{"$f":"SUM(G48:G50)","v":16},{"$nulls":4},2,{"$f":"SUM(M48:M50)","v":0},{"$f":"SUM(N48:N50)","v":4},{"$f":"SUM(O48:O50)","v":4},{"$f":"SUM(P48:P50)","v":8}]
["学分（学时）总计",{"$nulls":5},{"$f":"G23+G25+G31+G39+G47+G51","v":64},800,744,0,56,26.75,20.75,4,4.25,8.25]

{"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":"必修课：58学分"},{"$nulls":6},{"$f":"\"选修课：\"&SUM(I4:L4)&\"学分\"","v":"选修课：4学分"},{"$nulls":3},"实践学分合计","总学分"]
[null,"通识必修",null,"学科基础必修",null,"专业必修",null,"集中实践","专业选修",null,"通识选修"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","实践","理论","实践"]
["学分",{"$f":"B9/16-4","v":39},{"$f":"C9/16","v":3},{"$f":"D9/16","v":0},0,0,0,16,{"v":1.5,"d":"2"},{"v":0.5,"d":"1"},2,0,{"$f":"C4+E4+G4+H4+J4+L4","v":{"v":19.5,"d":"20"}},{"$f":"xx专业!G52","v":64}]
[{"$f":"\"实践教学环节学分所占比例：\"&ROUND(M4/N4*100,2)&\"%\"","v":"实践教学环节学分所占比例：30.47%"}]
["课程类别",{"$f":"\"必修课：\"&SUM(B9:H9)&\"学时\"","v":"必修课：736学时"},{"$nulls":6},{"$f":"\"选修课：\"&SUM(I9:L9)&\"学时\"","v":"选修课：64学时"},{"$nulls":3},"实践学时合计","总学时"]
[null,"通识必修",null,"学科基础必修",null,"专业必修",null,"集中实践","专业选修",null,"通识选修"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","实践","理论","实践"]
["学时",{"$f":"xx专业!I23","v":688},{"$f":"(xx专业!J23+xx专业!K23)","v":48},{"$f":"xx专业!I31","v":0},{"$f":"(xx专业!J31+xx专业!K31)","v":0},{"$f":"xx专业!I39","v":0},{"$f":"(xx专业!J39+xx专业!K39)","v":0},{"$f":"H4&\"周\"","v":"16周"},{"$f":"xx专业!I47","v":24},{"$f":"(xx专业!J47+xx专业!K47)","v":8},{"$f":"xx专业!I25","v":32},0,{"$f":"C9+E9+G9+J9+L9&\"+\"&H9","v":"56+16周"},{"$f":"SUM(B9:G9)+SUM(I9:L9)&\"+\"&H9","v":"800+16周"}]
[{"$f":"\"实践教学环节学时所占比例：\"&ROUND((C9+E9+G9+J9+L9+H4*16)/((SUM(B9:G9)+SUM(I9:L9)+H4*16))*100,2)&\"%\"","v":"实践教学环节学时所占比例：29.55%"}]
["注："]
["1.集中性实践教学环节每周折算 16 学时、计 1 学分;"]
["2. 实践教学环节学时所占比例=各类课程实践学时之和/总学时;"]
["3. 专业选修理论（实践）学时=（专业选修课最低要求学分/计划中列出的专业选修课学分之和）´专业选修课理论（实践）学时之和。"]
["4. 通识选修的学时=通识选修课的学分要求´16，全部列入理论学时。"]