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

{"sheet":"xx专业","index":0,"n_rows":100,"n_cols":24,"rows_kept":100,"merged":[[0,0,0,23],[1,0,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,1,11],[1,12,1,22],[1,23,3,23],[2,8,3,8],[2,9,3,9],[2,10,2,11],[2,12,2,14],[2,15,2,17],[2,18,2,20],[2,21,2,22],[4,0,59,0],[4,1,53,1],[4,2,17,2],[18,2,25,2],[26,2,33,2],[34,2,41,2],[42,2,48,2],[49,2,53,2],[54,1,54,5],[55,1,58,1],[55,12,58,23],[59,1,59,5],[60,0,66,0],[60,1,62,2],[63,1,65,2],[66,1,66,5],[67,0,90,0],[67,1,77,2],[77,3,77,5],[78,1,90,2],[90,3,90,5],[91,0,97,0],[91,1,91,2],[92,1,95,2],[96,1,96,2],[97,1,97,5],[98,0,98,5],[99,0,99,23]]}
["2022级xx专业教学计划进程表"]
["课程\n类别",null,null,"序号","课程\n代码","课程名称","课程性质","学分","计划学时数",{"$nulls":3},"学期",{"$nulls":10},"开课单位"]
[{"$nulls":8},"合计","理论教学","实践教学",null,"第一学年",null,null,"第二学年",null,null,"第三学年",null,null,"第四学年"]
[{"$nulls":10},"实验","其它实践",1,2,3,4,5,6,7,8,9,10,11]
["通识课程平台","通识必修课程模块","思政类",1,"GE6275","马克思主义基本原理概论","必修",2.5,40,40,{"$nulls":5},2.5,{"$nulls":7},"马克思学院"]
[{"$nulls":3},2,"GE6288","毛泽东思想和中国特色社会主义理论体系概论","必修",4,64,64,{"$nulls":6},4,{"$nulls":6},"马克思学院"]
[{"$nulls":3},3,"GE6273","中国近现代史纲要","必修",2.5,40,40,{"$nulls":3},2.5,{"$nulls":9},"马克思学院"]
[{"$nulls":3},4,"GE6267","思想道德与法治","必修",2.5,40,40,null,null,2.5,{"$nulls":10},"马克思学院"]
[{"$nulls":3},5,"GE6225","马克思主义中国化进程与青年学生使命担当","必修",1,24,24,null,null,1,{"$nulls":10},"马克思学院"]
[{"$nulls":3},6,"GE6175","形势与政策Ⅰ","必修",0.25,8,8,null,null,0.25,{"$nulls":10},"马克思学院"]
[{"$nulls":3},7,"GE6176","形势与政策Ⅱ","必修",0.25,8,8,{"$nulls":3},0.25,{"$nulls":9},"马克思学院"]
[{"$nulls":3},8,"GE6177","形势与政策Ⅲ","必修",0.25,8,8,{"$nulls":5},0.25,{"$nulls":7},"马克思学院"]
[{"$nulls":3},9,"GE6178","形势与政策Ⅳ","必修",0.25,8,8,{"$nulls":6},0.25,{"$nulls":6},"马克思学院"]
[{"$nulls":3},10,"GE6179","形势与政策Ⅴ","必修",0.25,8,8,{"$nulls":8},0.25,{"$nulls":4},"马克思学院"]
[{"$nulls":3},11,"GE6180","形势与政策Ⅵ","必修",0.25,8,8,{"$nulls":9},0.25,{"$nulls":3},"马克思学院"]
[{"$nulls":3},12,"GE6181","形势与政策Ⅶ","必修",0.25,8,8,{"$nulls":11},0.25,null,"马克思学院"]
[{"$nulls":3},13,"GE6182","形势与政策Ⅷ","必修",0.25,8,8,{"$nulls":12},0.25,"马克思学院"]
[{"$nulls":3},14,"GE6296","思政实践","必修",2.5,40,null,null,40,{"$nulls":4},2.5,{"$nulls":6},"马克思学院"]
[null,null,"素质类",15,"GE6240","程序设计基础","必修",3,48,32,16,null,3,{"$nulls":10},"计算机学院"]
[{"$nulls":3},16,"GE6154","沟通与演讲（《沟通与演讲》或《文献检索与论文写作》二选一）","必修",2,32,32,{"$nulls":3},2,{"$nulls":9},"马克思学院"]
[{"$nulls":3},17,"GE6222","文献检索与论文写作（《沟通与演讲》或《文献检索与论文写作》二选一）","必修",2,32,32,{"$nulls":9},2,{"$nulls":3},"马克思学院"]
[{"$nulls":3},18,"GE6023","大学生心理健康教育（计算机、商管、国教院安排在第一学期，信工、数媒、外国语安排在第二学期，自行填写学分至开设学期）","必修",2,32,26,null,6,{"$nulls":11},"马克思学院"]
[{"$nulls":3},19,"GE6197","大学生就业指导","必修",1,16,16,{"$nulls":8},1,{"$nulls":4},"基础教学院"]
[{"$nulls":3},20,"GE6272","劳动教育","必修",0.5,10,8,null,2,0.5,{"$nulls":10},"基础教学院"]
[{"$nulls":3},21,"GE6293","实验室安全教育","必修",0,2,2,null,null,"√",{"$nulls":10},"实验实训中心"]
[{"$nulls":3},22,"GE6294","社会实践","必修",1,26,4,null,22,null,1,{"$nulls":9},"校团委"]
[null,null,"外语类",23,"GE6220","大学英语Ⅰ","必修",3,48,48,null,null,3,{"$nulls":10},"外国语学院"]
[{"$nulls":3},24,"GE6229","大学英语Ⅱ","必修",3,48,48,{"$nulls":3},3,{"$nulls":9},"外国语学院"]
[{"$nulls":3},25,"GE6231","大学英语Ⅲ","必修",3,48,48,{"$nulls":5},3,{"$nulls":7},"外国语学院"]
[{"$nulls":3},26,"GE6233","大学英语Ⅳ","必修",3,48,48,{"$nulls":6},3,{"$nulls":6},"外国语学院"]
[{"$nulls":3},27,"GE6221","大学英语Ⅰ（艺术类）","必修",3,48,48,null,null,3,{"$nulls":10},"外国语学院"]
[{"$nulls":3},28,"GE6230","大学英语Ⅱ（艺术类）","必修",3,48,48,{"$nulls":3},3,{"$nulls":9},"外国语学院"]
[{"$nulls":3},29,"GE6232","大学英语Ⅲ（艺术类）","必修",3,48,48,{"$nulls":5},3,{"$nulls":7},"外国语学院"]
[{"$nulls":3},30,"GE6234","大学英语Ⅳ（艺术类）","必修",3,48,48,{"$nulls":6},3,{"$nulls":6},"外国语学院"]
[null,null,"理工类",31,"GE6173","高等数学Ⅰ（理工类）","必修",6,96,96,null,null,6,{"$nulls":10},"基础教学院"]
[{"$nulls":3},32,"GE6045","高等数学Ⅱ（理工类）","必修",4,64,64,{"$nulls":3},4,{"$nulls":9},"基础教学院"]
[{"$nulls":3},33,"GE6042","高等数学Ⅰ（经管类）","必修",4,64,64,null,null,4,{"$nulls":10},"基础教学院"]
[{"$nulls":3},34,"GE6043","高等数学Ⅱ（经管类）","必修",4,64,64,{"$nulls":3},4,{"$nulls":9},"基础教学院"]
[{"$nulls":3},35,"GE6001","线性代数","必修",3,48,48,{"$nulls":5},3,{"$nulls":7},"基础教学院"]
[{"$nulls":3},36,"GE6009","概率论与数理统计","必修",3,48,48,{"$nulls":6},3,{"$nulls":6},"基础教学院"]
[{"$nulls":3},37,"GE6246","大学物理","必修",4,64,64,{"$nulls":3},4,{"$nulls":9},"基础教学院"]
[{"$nulls":3},38,"GE6292","大学物理实验","必修",1,24,null,24,{"$nulls":4},1,{"$nulls":7},"基础教学院"]
[null,null,"军事体育类",39,"GE6219","军事理论（计算机、商管、国教院安排在第二学期，信工、数媒、外国语安排在第一学期，自行填写学分至开设学期）","必修",2,36,36,{"$nulls":13},"基础教学院"]
[{"$nulls":3},40,"GE6187","体育Ⅰ","必修",1,36,null,null,36,1,{"$nulls":10},"基础教学院"]
[{"$nulls":3},41,"GE6188","体育Ⅱ","必修",1,36,null,null,36,null,1,{"$nulls":9},"基础教学院"]
[{"$nulls":3},42,"GE6189","体育Ⅲ","必修",0.5,18,null,null,18,{"$nulls":3},0.5,{"$nulls":7},"基础教学院"]
[{"$nulls":3},43,"GE6190","体育Ⅳ","必修",0.5,18,null,null,18,{"$nulls":4},0.5,{"$nulls":6},"基础教学院"]
[{"$nulls":3},44,"GE6191","体育Ⅴ","必修",0.5,18,null,null,18,{"$nulls":6},0.5,{"$nulls":4},"基础教学院"]
[{"$nulls":3},45,"GE6192","体育Ⅵ","必修",0.5,18,null,null,18,{"$nulls":7},0.5,{"$nulls":3},"基础教学院"]
[null,null,"创新创业类",46,"GE6247","创新、创造与改变","必修",2,32,14,null,18,2,{"$nulls":10},"思沃学院"]
[{"$nulls":3},47,"GE6248","思维创新与开发","必修",2,32,16,null,16,null,2,{"$nulls":9},"思沃学院"]
[{"$nulls":3},48,"GE6249","创业者的成长之路","必修",2,32,24,null,8,{"$nulls":3},2,{"$nulls":7},"思沃学院"]
[{"$nulls":3},49,"GE6290","从非商业计划到商业计划","必修",2,32,16,null,16,{"$nulls":4},2,{"$nulls":6},"思沃学院"]
[{"$nulls":3},50,"GE6295","创新创业及素质教育实践","必修",1,{"$nulls":15},"专业所在学院"]
[null,"通识必修学分/学时小计及学分要求",{"$nulls":5},{"$f":"SUM(H5:H54)","v":96.5},{"$f":"SUM(J55:L55)","v":1674},{"$f":"SUM(J5:J54)","v":1362},{"$f":"SUM(K5:K54)","v":40},{"$f":"SUM(L5:L54)","v":272},{"$f":"SUM(M5:M54)","v":26.25},{"$f":"SUM(N5:N54)","v":26.75},null,15.25,18.25,null,1.75,2.75,null,0.25,0.25]
[null,"通识选修课程模块","自然与科技类",1,null,"详见通识选修课程库",null,2,{"$nulls":4},"最低学分要求8学分，自然与科技类、人文社科类、艺术类、创新创业类四类课程每类至少修2学分。"]
[null,null,"人文社科类",2,null,"详见通识选修课程库",null,2]
[null,null,"艺术类",3,null,"详见通识选修课程库",null,2]
[null,null,"创新创业类",4,null,"详见通识选修课程库",null,2]
[null,"通识选修学分/学时小计及学分要求",{"$nulls":5},8,128,128]
["学科及专业基础课程平台","学科基础课程模块",null,"1",null,null,"必修"]
[{"$nulls":3},"2",null,null,"必修"]
[{"$nulls":3},"3",null,null,"必修"]
[null,"专业基础课程模块",null,"4",null,null,"必修"]
[{"$nulls":3},"5",null,null,"必修"]
[{"$nulls":3},"6",null,null,"必修"]
[null,"学科及专业基础必修学分/学时小计及学分要求",{"$nulls":5},{"$f":"SUM(H61:H66)","v":0},{"$f":"SUM(J67:L67)","v":0},{"$f":"SUM(J61:J66)","v":0},{"$f":"SUM(K61:K66)","v":0},{"$f":"SUM(L61:L66)","v":0},{"$f":"SUM(M61:M66)","v":0},0,0,0,0,0,0,0,0,0,0]
["专业课程平台"," 专业必修课程模块",null,1,null,"专业导引与职涯规划","必修"]
[{"$nulls":3},2,null,null,"必修"]
[{"$nulls":3},3,null,null,"必修"]
[{"$nulls":3},5,null,null,"必修"]
[{"$nulls":3},6,null,null,"必修"]
[{"$nulls":3},7,null,null,"必修"]
[{"$nulls":3},8,null,null,"必修"]
[{"$nulls":3},9,null,null,"必修"]
[{"$nulls":3},10,null,null,"必修"]
[{"$nulls":3},11,null,null,"必修"]
[{"$nulls":3},"专业必修学分/学时小计及学分要求",{"$nulls":3},{"$f":"SUM(H68:H77)","v":0},{"$f":"SUM(I68:I77)","v":0},{"$f":"SUM(J68:J77)","v":0},{"$f":"SUM(K68:K77)","v":0},{"$f":"SUM(L68:L77)","v":0},{"$f":"SUM(M68:M77)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"专业选修课程模块",null,1,null,null,"选修",2,32,8,null,24,{"$nulls":3},2]
[{"$nulls":3},2,null,null,"选修",2,32,16,null,16,{"$nulls":3},2]
[{"$nulls":3},3,null,null,"选修",2,32,16,16,{"$nulls":4},2]
[{"$nulls":3},4,null,null,"选修",2,32,24,null,8,{"$nulls":3},2]
[{"$nulls":3},5,null,null,"选修"]
[{"$nulls":3},6,null,null,"选修"]
[{"$nulls":3},7,null,null,"选修"]
[{"$nulls":3},8,null,null,"选修"]
[{"$nulls":3},9,null,null,"选修"]
[{"$nulls":3},10,null,null,"选修"]
[{"$nulls":3},11,null,null,"选修"]
[{"$nulls":3},12,null,null,"选修"]
[{"$nulls":3},"专业选修学分/学时小计及学分要求",{"$nulls":3},2,{"$f":"ROUND(($H$91/SUM($H$79:$H$90))*SUM(I79:I90),0)","v":32},{"$f":"ROUND(($H$91/SUM($H$79:$H$90))*SUM(J79:J90),0)","v":16},{"$f":"ROUND(($H$91/SUM($H$79:$H$90))*SUM(K79:K90),0)","v":4},{"$f":"ROUND(($H$91/SUM($H$79:$H$90))*SUM(L79:L90),0)","v":12},{"$nulls":3},2]
["集中实践环节","军训类",null,1,null,"军事技能","必修",2,{"$nulls":4},"2周",{"$nulls":10},"学工部"]
[null,"专业实践类",null,2,null,"基本能力实训","必修",4,{"$nulls":6},"4周",{"$nulls":8},"专业所在学院"]
[{"$nulls":3},3,null,"专业能力实训","必修",4,{"$nulls":9},"4周",{"$nulls":5},"专业所在学院"]
[{"$nulls":3},4,null,"综合能力实训","必修",4,{"$nulls":12},"4周",null,null,"专业所在学院"]
[{"$nulls":3},5,null,"项目实训","必修",8,{"$nulls":13},"8周（语言类专业为4周）",null,"专业所在学院"]
[null,"毕业\n设计类",null,6,null,"毕业设计（论文）","必修",6,{"$nulls":14},"12周（计算机类专业为14周）","专业所在学院"]
[null,"集中实践必修学分/学时小计及学分要求",{"$nulls":5},{"$f":"SUM(H92:H97)","v":28},{"$nulls":4},2,null,4,null,null,4,null,null,4,8,6]
["学分/学时总计",{"$nulls":6},{"$f":"H55+H60+H67+H78+H91+H98","v":134.5},{"$f":"I98+I91+I78+I67+I60+I55","v":1834},{"$f":"J98+J91+J78+J67+J60+J55","v":1506},{"$f":"K98+K91+K78+K67+K60+K55","v":44},{"$f":"L98+L91+L78+L67+L60+L55","v":284},{"$f":"M55+M60+M67+M78+M91+M98","v":28.25},26.75,4,17.25,18.25,4,1.75,2.75,4,8.25,6.25]
["备注：\n1、《大学生心理健康》和《军事理论》需要自行填写学分至开设学期。\n2、通识必修课各专业按照需要选择，如《大学英语》艺术类与非艺术类、数学课和物理课等，不需要开设的课程删去，并调整课程序号。\n3、《沟通与演讲》或《文献检索与论文写作》二选一，不开设的课程删去，并调整课程序号。\n4、通识选修课需要填写学分至开设学期。\n"]

{"sheet":"统计","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"merged":[[0,0,2,0],[0,1,0,7],[0,8,0,10],[0,11,2,11],[0,12,2,12],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,9,1,10],[4,0,4,12],[5,0,7,0],[5,1,5,7],[5,8,5,10],[5,11,7,11],[5,12,7,12],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,9,6,10],[9,0,9,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[15,0,15,12],[16,0,16,12]]}
["课程类别","必修课： 学分",{"$nulls":6},"选修课： 学分",null,null,"实践学分","总学分"]
[null,"通识必修课",null,"学科及专业基础课",null,"专业课",null,"集中实践环节","通识选修课","专业选修课"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","理论","实践"]
["学分",{"$f":"(B9-46)/16","v":82.25},{"$f":"(C9-100)/16+1","v":14.25},{"$f":"D9/16","v":{"v":0,"d":"0.0"}},{"$f":"E9/16","v":{"v":0,"d":"0.0"}},{"$f":"F9/16","v":{"v":0,"d":"0.0"}},{"$f":"G9/16","v":{"v":0,"d":"0.0"}},{"$f":"SUM(xx专业!H92:H97)","v":{"v":28,"d":"28.0"}},{"$f":"I9/16","v":{"v":8,"d":"8.0"}},{"$f":"J9/16","v":{"v":1,"d":"1.0"}},{"$f":"K9/16","v":{"v":1,"d":"1.0"}},"每个类别实践学分之和",{"$f":"xx专业!H99","v":134.5}]
["实践教学环节学分所占比例： %（注：实践学分/总学分）"]
["课程类别","必修课",{"$nulls":6},"选修课",null,null,"课内学时","总学时"]
[null,"通识必修课",null,"学科及专业基础课",null,"专业课",null,"集中实践环节","通识选修课","专业选修课"]
[null,"理论","实践","理论","实践","理论","实践","实践","理论","理论","实践"]
["学时",{"$f":"xx专业!J55","v":1362},{"$f":"(xx专业!K55+xx专业!L55)","v":312},{"$f":"xx专业!J67","v":0},{"$f":"(xx专业!K67+xx专业!L67)","v":0},{"$f":"xx专业!J78","v":0},{"$f":"(xx专业!K78+xx专业!L78)","v":0},"28周（根据实际填写）",128,{"$f":"xx专业!J91","v":16},{"$f":"xx专业!K91+xx专业!L91","v":16},{"$f":"SUM(B9:G9)+SUM(I9:K9)","v":1834},{"$f":"L9&\"学时\"&\"+\"&H9","v":"1834学时+28周（根据实际填写）"}]
[{"$f":"\"实践教学环节学时所占比例：\"&ROUND((C9+E9+G9+K9+LEFT(H9,2)*20)/(SUM(B9:G9)+SUM(I9:K9)+LEFT(H9,2)*20)*100,2)&\"%\"","v":"实践教学环节学时所占比例：37.09%"}]
["注："]
["1．集中性实践教学环节每周折算20学时。"]
["2．实践教学环节学时所占比例=各类课程实践学时之和/总学时。"]
["3．课内总学时不含集中实践环节学时。"]
["4．创新创业及素质教育学时只计算创新创业课程的学时，创新创业及素质教育实践学分不折算学时。"]
["5．专业选修课理论（实践）学时=（专业选修课最低要求学分/计划中列出的专业选修课学分之和）×专业选修课理论（实践）学时之和。"]
["6．通识选修课的学时=通识选修课的学分要求×16，全部计入理论学时。"]