{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["教学活动时间安排表","课程设置、教学进程计划及课时（学分）分配表","实践教学活动安排 (2)","课程类别和结构比例"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"教学活动时间安排表","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[0,0,0,11],[1,0,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,1,10],[1,11,2,11],[3,0,4,0],[3,11,4,11],[5,0,6,0],[5,11,6,11],[7,0,8,0],[7,11,8,11],[9,9,9,10],[11,0,11,11]],"flags":["formulas_cached_only"]}
["附件1：专科教学活动时间安排表"]
["　　　项\n　　　　　　\n　　　　目\n学\n　　　　\n　　　期",null,"授课","考试","军事训练\n军事理论\n生产劳动\n入学教育","专业实习\n教育实习\n课程设计\n项目设计\n综合实训","顶岗实习","毕业教育\n社会实践","机动","假期",null,"总计"]
[{"$nulls":9},"　寒","暑"]
["一",1,15,2,3,{"$nulls":4},6,null,52]
[null,2,16,2,null,2,{"$nulls":4},6]
["二",3,16,2,null,2,{"$nulls":3},6,null,52]
[null,4,17,2,null,1,{"$nulls":4},6]
["三",5,9,2,null,9,{"$nulls":3},6,null,52]
[null,6,null,"　",null,null,18,2,null,null,6]
["合计",null,73,10,3,"　",18,2,0,36,null,156]
[]
["注：1、各专业根据实际情况自行调整1-4学期理论授课周数和实践周数\n2、第5学期授课周数可根据专业特点适当调整，但理论授课周数不能少于8周"]

{"sheet":"课程设置、教学进程计划及课时（学分）分配表","index":1,"n_rows":73,"n_cols":25,"rows_kept":73,"merged":[[0,0,0,24],[2,0,7,0],[2,1,7,1],[2,2,7,2],[2,3,7,3],[2,4,7,4],[2,5,2,10],[2,11,2,12],[2,13,2,23],[2,24,7,24],[3,5,7,5],[3,6,3,9],[3,10,7,10],[3,11,7,11],[3,12,7,12],[3,13,3,16],[3,17,3,20],[3,21,3,23],[4,6,7,6],[4,7,7,7],[4,8,7,8],[4,9,7,9],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[8,0,35,0],[30,13,30,14],[36,0,50,0],[51,0,57,0],[58,0,68,0],[69,0,69,2],[70,0,70,2],[70,13,70,14],[70,15,70,16],[70,17,70,18],[70,19,70,20],[70,21,70,22],[71,0,71,2],[71,13,71,14],[71,15,71,16],[71,17,71,18],[71,19,71,20],[71,21,71,22],[72,0,72,2],[72,13,72,14],[72,15,72,16],[72,17,72,18],[72,19,72,20],[72,21,72,22]],"flags":["formulas_cached_only"]}
["附件2：课程设置、教学进程计划及课时（学分）分配表"]
[]
["模块内容","课程编号","课　　程　　名　　称","课\n程\n属\n性","学\n\n\n\n分","教学时数",{"$nulls":5},"考核",null,"按学期分配教学周学时",{"$nulls":10},"开课\n及管\n理单\n位"]
[{"$nulls":5},"合计","课　内\n",{"$nulls":3},"实\n训","考\n试\n学\n期","考\n查\n学\n期","第一\n学年",{"$nulls":3},"第二\n学年",{"$nulls":3},"第三\n学年"]
[{"$nulls":6},"小计","一体化","理论","课内实践",{"$nulls":3},"一",null,"二",null,"一",null,"二",null,"一",null,"二"]
[{"$nulls":13},"15周",null,"18周",null,"18周",null,"18周",null,"18周",null,"18周"]
[{"$nulls":13},"理论","实践","理论","实践","理论","实践","理论","实践","理论","实践","实践"]
[{"$nulls":13},15,0,16,2,16,2,17,1,9,9,18]
["基本素质与能力","100001","军训（含军事理论教育）","BX",{"v":2,"d":"2.0"},12,12,null,12,{"$nulls":3},1,"12/期",{"$nulls":10},"教务处"]
[null,"100002","大学生安全教育","BX",0.5,8,{"$nulls":4},8,null,1,"8/期",{"$nulls":10},"教务处"]
[null,"100006","大学生健康教育(含心理健康教育）","BX",0.5,8,8,null,8,{"$nulls":3},1,"8/期",{"$nulls":10},"学生处"]
[null,"100208","形势政策1","B",0.5,8,6,null,6,null,2,null,"1","6/期","2/期",{"$nulls":9},"马院"]
[null,"100213","中国共产党历史","B",1.5,28,28,null,28,{"$nulls":3},"1",2,{"$nulls":10},"马院"]
[null,"100216","思想道德与法治","B",{"v":3,"d":"3.0"},45,33,null,33,null,12,null,1,3,{"$nulls":10},"马院"]
[null,"100003","大学生职业生涯发展与就业指导1","BX",0.5,10,10,null,10,{"$nulls":3},"2",null,null,"10/期",{"$nulls":8},"招生就业处"]
[null,"100209","形势政策2","B",0.5,8,6,null,6,null,2,null,"2",null,null,"6/期","2/期",{"$nulls":7},"马院"]
[null,"100214","毛泽东思想和中国特色社会主义理论体系概论　","B",{"v":2,"d":"2.0"},32,32,null,32,{"$nulls":3},2,null,null,2,{"$nulls":8},"马院"]
[null,"100215","习近平新时代中国特色社会主义思想概论","B",{"v":3,"d":"3.0"},48,36,null,36,null,12,null,3,{"$nulls":4},3,{"$nulls":6},"马院"]
[null,"100004","大学生职业生涯发展与就业指导2","BX",0.5,14,14,null,14,{"$nulls":3},"3",{"$nulls":4},"14/期",{"$nulls":6},"招生就业处"]
[null,"100210","形势政策3","B",0.5,8,6,null,6,null,2,null,"3",{"$nulls":4},"6/期","2/期",{"$nulls":5},"马院"]
[null,"100005","大学生职业生涯发展与就业指导","BX",0.5,10,10,null,10,{"$nulls":3},"4",{"$nulls":6},"10/期",{"$nulls":4},"招生就业处"]
[null,"100207","筑梦中国","B",{"v":1,"d":"1.0"},12,12,null,12,{"$nulls":3},"4",{"$nulls":6},"12/期",{"$nulls":4},"马院"]
[null,"100211","形势政策","B",0.5,8,6,null,6,null,2,null,"4",{"$nulls":6},"6/期","2/期",{"$nulls":3},"马院"]
[null,"100501","体育Ⅰ","B",{"v":1,"d":"1.0"},30,30,null,4,26,null,null,"1",null,2,{"$nulls":9},"教务处"]
[null,"100502","体育Ⅱ","B",{"v":1,"d":"1.0"},32,32,null,4,28,null,null,"2",{"$nulls":3},2,{"$nulls":7},"教务处"]
[null,"100503","体育活动","＊",null,"56",{"$nulls":4},"56",{"$nulls":13},"教务处"]
[null,"100101","高等数学","B",3.5,60,60,null,60,null,null,1,null,4,{"$nulls":10},"教务处"]
[null,"100102","应用数学","B",{"v":2,"d":"2.0"},32,32,null,32,null,null,2,{"$nulls":3},2,{"$nulls":8},"教务处"]
[null,"100301","大学英语Ⅰ","B",3.5,60,60,null,60,null,null,1,null,4,{"$nulls":10},"航空旅游学院"]
[null,"100302","大学英语Ⅱ","B",{"v":4,"d":"4.0"},64,64,null,64,null,null,2,{"$nulls":3},4,{"$nulls":8},"航空旅游学院"]
[null,"100403","信息技术","B",{"v":3,"d":"3.0"},56,56,56,{"$nulls":3},1,null,4,{"$nulls":10},"教务处"]
[null,"100801","劳动教育1","B",{"v":1,"d":"1.0"},16,4,null,4,null,12,null,1,"4/期",{"$nulls":10},"机械工程学院"]
[null,"100802","劳动教育2","B",{"v":1,"d":"1.0"},16,4,null,4,null,12,null,2,null,null,"4/期",{"$nulls":8},"机械工程学院"]
[null,"100803","劳动教育3","B",{"v":1,"d":"1.0"},16,4,null,4,null,12,null,3,{"$nulls":4},"4/期",{"$nulls":6},"机械工程学院"]
[null,"100804","劳动教育","B",{"v":1,"d":"1.0"},16,4,null,4,null,12,null,4,{"$nulls":6},"4/期",{"$nulls":4},"机械工程学院"]
[null,null,"小计",null,39,657,569,56,459,54,88]
["专业基本能力",101820,"机械制图","B",6.5,105,105,null,30,75,null,1,null,7,{"$nulls":10},"机械工程学院"]
[null,101822,"电工电子技术","B",4,64,64,null,32,32,null,2,{"$nulls":3},4,{"$nulls":8},"机械工程学院"]
[null,101013,"机械CAD绘图","B",4,64,64,64,{"$nulls":4},2,null,null,4,{"$nulls":8},"机械工程学院"]
[null,101005,"零件检测与质量分析","B",4,64,64,null,54,10,null,null,3,{"$nulls":4},4,{"$nulls":6},"机械工程学院"]
[null,101804,"传感器与检测技术","B",4,64,64,null,32,32,null,2,{"$nulls":3},4,{"$nulls":8},"机械工程学院"]
[null,101825,"液压及气压传动","B",2,32,32,null,16,16,null,null,2,null,null,2,{"$nulls":8},"机械工程学院"]
[null,101805,"机械设计基础","B",4,64,64,null,32,32,null,3,{"$nulls":5},4,{"$nulls":6},"机械工程学院"]
[null,101806,"新能源发电与控制技术","B",6,96,96,null,48,48,null,3,{"$nulls":5},6,{"$nulls":6},"机械工程学院"]
[null,101114,"零件三维建模","B",6,96,96,96,{"$nulls":4},3,{"$nulls":4},6,{"$nulls":6},"机械工程学院"]
[null,101807,"电气控制与PLC","B",4.5,80,80,null,32,48,null,3,{"$nulls":5},5,{"$nulls":6},"机械工程学院"]
[null,101808,"机械设备维修","B",4,68,68,null,34,34,null,null,4,{"$nulls":6},4,{"$nulls":4},"机械工程学院"]
[null,101809,"风力发电机组机械装配","B",6.5,119,119,null,51,68,null,4,{"$nulls":7},7,{"$nulls":4},"机械工程学院"]
[null,101810,"新能源汽车技术","B",6,102,102,null,51,51,null,4,{"$nulls":7},6,{"$nulls":4},"机械工程学院"]
[null,101811,"太阳能光伏发电系统工程","B",6.5,119,119,null,51,68,null,4,{"$nulls":7},7,{"$nulls":4},"机械工程学院"]
[null,null,"小计",null,{"v":68,"d":"68.0"},1137,1137,160,463,514,0]
["专业综合能力","101006","专业认识","B",0.5,10,{"$nulls":4},10,null,1,{"$nulls":11},"机械工程学院"]
[null,"101007","机器拆装","B",0.5,10,{"$nulls":4},10,null,1,{"$nulls":11},"机械工程学院"]
[null,"101008","金工实习","B",2.5,40,{"$nulls":4},40,null,2,{"$nulls":3},20,{"$nulls":7},"机械工程学院"]
[null,"101812","机械零件课程设计","B",2.5,40,{"$nulls":4},40,null,3,{"$nulls":5},20,{"$nulls":5},"机械工程学院"]
[null,"101813","设备维修实训","B",{"v":1,"d":"1.0"},20,{"$nulls":4},20,null,4,{"$nulls":7},20,{"$nulls":3},"机械工程学院"]
[null,"100601","顶岗实习","B",{"v":9,"d":"9.0"},432,{"$nulls":4},432,null,6,{"$nulls":10},24,"机械工程学院"]
[null,null,"小计",null,{"v":16,"d":"16.0"},552,{"$nulls":4},552]
["创新创业能力","101010","应用文写作","J",0.5,8,8,null,8,{"$nulls":3},3,{"$nulls":11},"机械工程学院"]
[null,"101011","新技术新工艺","J",0.5,8,8,null,8,{"$nulls":3},4,{"$nulls":11},"机械工程学院"]
[null,"101814","能源经济与节能技术","B",{"v":3,"d":"3.0"},54,54,null,54,{"$nulls":3},5,{"$nulls":8},6,null,null,"机械工程学院"]
[null,"100703","创业基础","B",{"v":1,"d":"1.0"},16,16,null,16,{"$nulls":3},3,{"$nulls":4},"16/期",{"$nulls":6},"创业学院"]
[null,"100704","大学生创业指导","B",{"v":1,"d":"1.0"},16,16,null,8,8,null,null,4,{"$nulls":6},"16/期",{"$nulls":4},"创业学院"]
[null,"101018","加工与测量","B",4.5,72,null,72,{"$nulls":3},5,{"$nulls":9},8,null,null,"机械工程学院"]
[null,"101815","新能源汽车动力电池技术","B",{"v":3,"d":"3.0"},54,54,null,54,null,null,5,{"$nulls":9},6,null,null,"机械工程学院"]
[null,"101009","企业管理与市场营销","J",0.5,8,8,null,8,{"$nulls":3},4,{"$nulls":11},"机械工程学院"]
[null,"101823","新能源产品创新实训","B",{"v":2,"d":"2.0"},80,{"$nulls":4},80,null,5,{"$nulls":9},20,null,"机械工程学院"]
[null,"101824","毕业设计","B",2.5,100,{"$nulls":4},100,null,5,{"$nulls":9},20,null,"机械工程学院"]
[null,null,"小计",null,18.5,416,164,72,156,8,180]
["合计",{"$nulls":3},141.5,2762,1870,288,1078,576,820]
["周学时总数",{"$nulls":12},25,null,26,null,26,null,25,null,20,null,24]
["学期课程门数",{"$nulls":12},14,null,12,null,12,null,12,null,5,null,1]
["学期考试/考查门数",{"$nulls":10},16,38,"4/10",null,"4/8",null,"3/9",null,"3/9",null,"2/3",null,"0/1"]

{"sheet":"实践教学活动安排 (2)","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"merged":[[0,0,0,9],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,1,8],[3,0,5,0],[3,3,5,3],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,7,5,7],[3,8,5,8],[3,9,5,9],[6,0,8,0],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,6,8,6],[6,7,8,7],[6,8,8,8],[6,9,8,9],[9,0,11,0],[9,3,11,3],[9,4,11,4],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[12,0,14,0],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,6,14,6],[12,7,14,7],[12,8,14,8],[12,9,14,9],[15,0,17,0],[15,3,17,3],[15,4,17,4],[15,5,17,5],[15,6,17,6],[15,7,17,7],[15,8,17,8],[15,9,17,9],[18,0,20,0],[18,3,20,3],[18,4,20,4],[18,5,20,5],[18,6,20,6],[18,7,20,7],[18,8,20,8],[18,9,20,9],[21,0,23,0],[21,3,23,3],[21,4,23,4],[21,5,23,5],[21,6,23,6],[21,7,23,7],[21,8,23,8],[21,9,23,9],[24,0,26,0],[24,3,26,3],[24,4,26,4],[24,5,26,5],[24,6,26,6],[24,7,26,7],[24,8,26,8],[24,9,26,9]],"flags":["formulas_cached_only"]}
["附件3：实践教学活动安排表"]
["课程(项目)模块","工作领域分析",null,"教学项目（课程）","最终绩效目标","学时","时间安排",null,null,"地点"]
[{"$nulls":6},"学期","周数","考证"]
["基本技能","工作任务分析","专业认识","专业认识\n机器拆装","    了解机械基本知识及机器组成原理\n    了解机构的基本组成结构",20,1,1,null,"实训室"]
[null,"技术能力分析","掌握机器组成及结构"]
[null,"职业素质","高度责任心与团队协作精神"]
["专业技能","工作任务分析","机加设备使用","金工实习","    掌握零件常用加工方法及工具的使用",40,2,2,null,"工程训练中心"]
[null,"技术能力分析","掌握车、钳、铣、焊设备使用"]
[null,"职业素质","高度责任心与团队协作精神"]
["专业技能","工作任务分析","设计二级减速器","机械零件课程设计","    通过设计二级减速器，使学生掌握一般传动装置的设计方法、步骤，进一步巩固对已学知识的学习和应用。",40,3,2,null,"教室"]
[null,"技术能力分析","掌握传动装置的设计方法、步骤、技巧等"]
[null,"职业素质","严谨细致的工作作风，培养分析问题和解决问题的能力"]
["专业技能","工作任务分析","设备维修","维修电工实训","    通过简单电气元器件的维修,掌握典型设备的维修基本方法、步骤。",20,4,1,null,"实训室"]
[null,"技术能力分析","常用电气设备故障诊断与维修"]
[null,"职业素质","严谨细致的工作作风，高度责任心与团队协作精神"]
["创新技能","工作任务分析","新能源产品创新设计","新能源产品创新实训","    通过简单新能源产品的创新设计,掌握典型的产品设计能力。",80,5,4,null,"实训室"]
[null,"技术能力分析","掌握新产品设计的思路和步骤"]
[null,"职业素质","严谨细致的工作作风，高度责任心与团队协作精神"]
["综合技能（能力）","工作任务分析","专业实践","毕业设计","    学生通过毕业综合实训全面掌握本专业的理论知识、实际要求，提高绘图能力、设计能力，增强运用专业知识分析、解决生产实际问题的能力。",100,5,5,null,"教室"]
[null,"技术能力分析","专业技能综合实践"]
[null,"职业素质","高度责任心与团\n队协作精神"]
["劳动技能","工作任务分析","劳动","生产劳动","提高学生的劳动意识和素养，培养学生工匠精神",16,2,8,null,"校内"]
[null,"技术能力分析","劳动技能综合实践"]
[null,"职业\n素质","提高学生的劳动意识和素养培养学生工匠精神"]
["综合技能（能力）","工作任务分析","专业实践","顶岗实践","    完成从学生到职业人的转变",432,6,18,null,"企业"]
[null,"技术能力分析","专业技能综合实践"]
[null,"职业素质","高度责任心与团队协作精神"]

{"sheet":"课程类别和结构比例","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,0,0,4],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,2,6],[8,0,8,1],[8,2,8,6]],"flags":["formulas_cached_only"]}
["附件4：课程类别和结构比例"]
["课程模块","总学时数","理论学时数","实践学时数",null,null,"百分比"]
[{"$nulls":3},"实践总学时数","课内实践","课外实践"]
["基本素质与能力",657,"459+56*1/2=487",170,"54+56*1/2=82",88,{"v":0.23787110789283128,"d":"23.79%"}]
["专业基本技能",1137,"463+160*1/2=543",594,"514+160*1/2=594",0,{"v":0.4116582186821144,"d":"41.17%"}]
["专业综合技能",552,0,552,0,552,{"v":0.1998551774076756,"d":"19.99%"}]
["创新创业能力",416,"156+72*1/2=192",224,"8+72*1/2=44",180,{"v":0.15061549601737872,"d":"15.06%"}]
["合计",2762,1218,1540,756,820,{"v":1,"d":"100.00%"}]
["理论教学学时与实践教学学时的比例",null,"4:5"]