{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["表一 ","表二","续表二","表三","表四","表五","表六","表七"],"not_rendered":{"external_links":2,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"表一 ","index":0,"n_rows":12,"n_cols":40,"rows_kept":12,"merged":[[0,0,0,39],[1,37,1,38],[2,0,3,0],[2,1,3,1],[2,2,2,27],[4,0,5,0],[6,0,7,0],[8,0,9,0],[10,25,10,27],[11,0,11,39],[12,0,12,39]],"flags":["formulas_cached_only"]}
["  表1 汽车制造与试验技术专业整体教学活动安排及时间分配"]
[{"$nulls":37},"表一"]
["学  年","学  期","教 学 进 行 周 次",{"$nulls":25},"理\n论\n教\n学","考  试","社  会  实  践","劳动教育","校内实训","跟岗\n实\n习","顶岗\n实\n习","入\n学\n教\n育","军\n事\n训\n练","毕\n业\n教\n育","假  期","合  计"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,"←→","K","J","L","S","G","D","R","M","B","F","—"]
["一",1,null,null,"R","M","M","M","←","―","―","―","―",13,"周","―","―","―","―","―","→","K","F","F","F","F","F","F",13,1,{"$nulls":5},0.5,3.5,null,6,24]
[null,2,"J","←","―","―","―",14,"周","―","―","―","―","―","―","―","→","L","S","S","S","K","F","F","F","F","F","F",14,1,"（1）",1,3,{"$nulls":5},6,26]
["二",3,"←","―","―","―","―",13,"周","―","―","―","―","―","→","S","S","S","S","S","S","K","F","F","F","F","F","F",13,1,null,null,6,{"$nulls":5},6,26]
[null,4,"J","←","―","―","―",13,"周","―","―","―","―","―","―","→","S","S","S","S","S","K","F","F","F","F","F","F",13,1,"（1）",null,5,{"$nulls":5},6,26]
["三",5,"←","―","―","―","―",10,"周","―","―","→","S","S","K","D","D","D","D","D","D","D","F","F","F","F","F","F",10,1,null,null,2,null,7.5,{"$nulls":3},6,26]
[null,6,"D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","B",{"$nulls":13},17.5,null,null,1,null,19]
[{"$nulls":25},"总  计",null,null,63,5,"（2）",1,16,null,25,0.5,3.5,1,30,147]
["注：1.三年总周数147周，其中：在校117周。假期30周。   2.社会实践共2周，主要安排在假期进行。"]

{"sheet":"表二","index":1,"n_rows":27,"n_cols":17,"rows_kept":27,"merged":[[0,0,0,16],[2,0,5,0],[2,1,5,1],[2,2,5,2],[2,3,5,3],[2,4,5,4],[2,5,5,5],[2,6,2,8],[2,9,2,14],[2,15,5,15],[2,16,5,16],[3,6,5,6],[3,7,5,7],[3,8,5,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[6,0,25,0],[6,1,17,1],[18,1,18,3],[19,1,24,1],[25,1,25,3],[26,0,26,3]],"flags":["formulas_cached_only"]}
["表2 汽车制造与试验技术专业教学计划进程"]
[{"$nulls":15},"表二"]
["课程\n类别","课程\n性质","课程代号","课程名称","学\n分    数","学\n时     数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":6},"分类  代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":9},1,2,3,4,5,6]
[{"$nulls":9},13,19,19,19,13]
["公      共      基       础       课","必       修        课","300011101","思想道德修养与法律基础",3,48,"B",32,16,24,24]
[null,null,"300011102","毛泽东思想和中国特色社会主义理论体系概论",4,64,"B",48,16,null,null,32,32]
[null,null,"300011103","形势与政策",1,72,"A",72,null,8,8,8,8,8]
[null,null,"300011304","体育",6,108,"B",12,96,24,30,30,24]
[null,null,"300011105","军事理论",2,36,"A",36,null,"军训中安排"]
[null,null,"300011107","大学生职业发展与就业指导 ",2,36,"B",20,16,{"$nulls":4},36]
[null,null,"300011108","心理健康教育",2,32,"A",32,null,null,32]
[null,null,"300011110","创新创业基础",2,32,"B",16,16,16]
[null,null,"300011212","劳动教育",1,16,"B",8,8,8,8]
[null,null,"300011213","美育基础知识",1.5,24,"A",24,{"$nulls":3},24]
[{"$nulls":3},"四史教育（党史、新中国史、改革开放史、社会主义发展史）",2,32,"A",32,{"$nulls":5},32]
[{"$nulls":3},"安全教育与6S管理",2,32,"A",32,{"$nulls":3},16,16]
[null,"小    计",null,null,28.5,532," ",364,168]
[null,"限       选       课","300011106","中华优秀传统文化（含闽南文化）",1.5,24,"A",24,{"$nulls":4},24]
[null,null,"300011209","信息技术",3,48,"A",48," ",48]
[null,null,"300011111","英语（含专业英语）",8,128,"A",128,null,64,64]
[null,null,"300011116","应用数学",4.5,72,"A",72,null,36,36]
[{"$nulls":3},"应用写作与合同法        ",1.5,24,"A",24,{"$nulls":4},24]
[{"$nulls":3},"礼仪与职业素养",1.5,24,"A",24,{"$nulls":5},24]
[null,"小    计",null,null,20,320," ",320,0]
["合    计",{"$nulls":3},48.5,852,null,684,168]

{"sheet":"续表二","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"merged":[[0,15,0,16],[1,0,4,0],[1,0,4,0],[1,1,4,1],[1,1,4,1],[1,2,4,2],[1,3,4,3],[1,4,4,4],[1,5,4,5],[1,6,1,8],[1,9,1,14],[1,15,3,15],[1,16,3,16],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[5,0,26,0],[5,1,14,1],[15,1,15,3],[15,1,15,3],[16,1,21,1],[23,1,23,3],[24,1,25,1],[26,1,26,3],[27,0,27,3],[28,0,29,1],[28,4,28,14],[29,2,29,3],[30,0,30,3]],"flags":["formulas_cached_only"]}
[{"$nulls":15},"续表二"]
["课程\n类别","课程\n性质","课程代号","                                                 课程名称\n","学\n分    数","学\n时   数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":6},"分类  代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":9},1,2,3,4,5,6]
[{"$nulls":9},13,19,19,19,13]
["专         业         课","专       业      基      础      课","340121101","汽车文化",2,32,"A",32,null,"4*8"]
[null,null,"340121102","汽车机械基础",2,32,"A",32,null,null,"4*8"]
[null,null,"340121204","汽车机械制图",3,48,"A",48," ","4*12"]
[null,null,340231307,"汽车电工电子技术",3,48,"A",48," ",null,"4*12"]
[null,null,340331301,"汽车材料",2,32,"A",32," ",null,"4*8"]
[null,null,"340242203","二手车鉴定与评估",2,32,"A",32," ",null,null,"4*8"]
[null,null,"340121206","汽车使用与维护",3,48,"A",48," ",{"$nulls":3},"4*12"]
[null,null,"340242202","汽车车身修复技术",2,32,"A",32," ",{"$nulls":3},"4*8"]
[{"$nulls":3},"CAD考工",1,16,"A",null,16,null,"2*8"]
[]
[null,"小    计",null,null,20,320,null,304,16,6,9,3,6,0]
[null,"专      业      核      心      课","340231201","汽车构造",4,64,"B",56,8,null,null,"6*11"]
[null,null,"340231202","汽车发动机构造与维修",3,48,"B",40,8,null,null,"4*12"]
[null,null,"340231204","汽车电气设备构造与维修",3,48,"B",40,8,null,null,"4*12"]
[null,null,"340231303","汽车底盘构造与维修",3,48,"A",48," ",{"$nulls":3},"4*12"]
[null,null,"340231205","汽车底盘电控技术",3,48,"A",48," ",{"$nulls":3},"4*12"]
[null,null,"340231206","汽车检测与诊断",3,48,"A",48," ",{"$nulls":4},"6*8"]
[]
[null,"小    计",null,null,19,304,null,280,24,0,0,12,7,5]
[null,"专业       拓展课",340231010,"汽车美容与装饰",2,32,"A",32," ",{"$nulls":4},"4*8"]
[null,null,"340242204","汽车保险与理赔",2,32,"A",32," ",{"$nulls":4},"4*8"]
[null,"小    计",null,null,4,64,null,64,0,0,0,0,0,6]
["合    计",{"$nulls":3},43,688,null,648,40,6,9,15,13,11]
["公共选修课",null,"见表三",null,"至少选修3学分"]
[null,null,"小    计",null,3,48,null,48]
["总    计",{"$nulls":3},94.5,1588,null,1380,208]

{"sheet":"表三","index":3,"n_rows":21,"n_cols":16,"rows_kept":21,"merged":[[0,0,0,15],[2,0,5,0],[2,1,5,1],[2,2,5,2],[2,3,5,3],[2,4,5,4],[2,5,2,7],[2,8,2,13],[2,14,5,14],[2,15,5,15],[3,5,5,5],[3,6,5,6],[3,7,5,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[6,0,19,0],[6,15,20,15],[20,0,20,2]],"flags":["formulas_cached_only"]}
["表3 汽车制造与试验技术专业公共选修课教学计划"]
[{"$nulls":14},"表三"]
["课程\n类别","课程代号","课程名称","学\n分    数","学\n时   数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":5},"分类  代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":8},1,2,3,4,5,6]
[{"$nulls":8},13,19,19,19,13]
["公共选修课","300062101","智能制造概论",1.5,24,null,24,{"$nulls":4},"2*12"]
[null,"300062102","计算机组装与维护",1.5,24,null,24,{"$nulls":4},"2*12"]
[null,"310521201","印刷概论",1.5,24,null,24,{"$nulls":4},"2*12"]
[null,"300062128","健康教育",1.5,24,null,24,{"$nulls":4},"2*12"]
[null,"300062129","法律法规",1.5,24,null,24,{"$nulls":4},"2*12"]
[null,"300062132","大学语文",1.5,24,null,24,{"$nulls":5},"4*6"]
[null,"300011121","演讲与口才",1.5,24,null,24,{"$nulls":5},"4*6"]
[null,null,"习近平新时代中国特色社会主义思想",1.5,24,null,24,{"$nulls":5},"4*6"]
[null,null,"英语拓展课",1.5,24,null,24,{"$nulls":5},"4*6"]
[null,null,"信息前沿",1.5,24,null,24,{"$nulls":5},"4*6"]
[]
[]
[]
[]
["合    计",null,null,3,48,null,48]

{"sheet":"表四","index":4,"n_rows":18,"n_cols":16,"rows_kept":18,"merged":[[0,0,0,15],[1,14,1,15],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,2,13],[2,14,4,14],[2,15,4,15],[3,8,3,9],[3,10,3,11],[3,12,3,13],[5,0,16,0],[17,0,17,2],[19,0,19,15],[20,0,20,15],[21,0,21,15],[22,0,22,15]],"flags":["formulas_cached_only"]}
["表4 汽车制造与试验技术专业实践教学环节安排"]
[{"$nulls":14},"表四"]
["实践教学\n环节类别","实践教学\n环节编号","实践教学环节名称","学分","教学周数","课时数","分类代号","实践学时","执行学期",{"$nulls":5},"考核方式","备注"]
[{"$nulls":8},"一",null,"二",null,"三"]
[{"$nulls":8},1,2,3,4,5,6]
["集           中          实           践            教            学           环           节","300071301","专项技能（军事技能）训练",2,3.5,120,"C",120,"军训中安排"]
[null,"300071302","校内综合实训",24,16,384,"C",384,null,3,6,5,2]
[null,"300071304","校外顶岗实习",37.5,25,650,"C",650,{"$nulls":4},7.5,17.5]
{"$rows_empty":9}
["合        计",null,null,63.5,44.5,1154,null,1154]

{"sheet":"表五","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,0,0,8],[3,0,11,0],[12,0,13,0],[16,0,16,8],[17,0,17,8],[18,0,18,8]],"flags":["formulas_cached_only"]}
["表5 汽车制造与试验技术专业实习实训教学安排"]
[{"$nulls":8},"表五"]
["实践教学类型","开设学期","周数","所属课程或职业岗位","实践形式","实践项目","学时数","学分数","实践地点"]
["校内综合实训",2,2,"计算机制图实训","职业资格培训","1、汽车机械制图实训\n2、汽车零件测绘实训\n3、AutoCAD绘图员实训",48,3,"机房204"]
[null,2,1,"金工实训","课程技能训练","1、正确使用钳工设备、工具、量具\n2、掌握钳工操作方法",24,1.5,"金工实训室"]
[null,3,2,"汽车电器实训","课程技能训练","1、全车电路系统结构和工作原理及操作方法\n2、全车电路系统线路连接，分析各系统的工作过程\n3、全车电路系统故障诊断和排除",48,3,"汽车电器实训工位"]
[null,3,2,"发动机拆装实训","课程技能训练","1、汽车发动机结构原理分析实训\n2、汽车发动机拆装实训\n3、汽车发动机检测与维修实训",48,3,"发动机拆装实训工位"]
[null,3,2,"发动机电控实训","课程技能训练","1、发动机电控系统检测\n2、发动机电控系统排故",48,3,"发动机电控实训工位"]
[null,4,2,"汽车轮胎检测实训","课程技能训练","1、轮胎检查\n2、轮胎动平衡检测\n3、轮胎拆装",48,3,"汽车轮胎检测工位"]
[null,4,1,"汽车四轮定位实训","课程技能训练","1、前束的测量与调整\n2、最大转向角的检查与调整\n3、四轮定位仪的结构和工作原理及操作方法",24,1.5,"汽车四轮定位工位"]
[null,4,2,"汽车空调检测实训","课程技能训练","1、空调结构认知\n2、空调系统检修",48,3,"汽车空调检测实训工位"]
[null,5,2,"汽车检测综合实训","专业综合技能训练","汽车性能综合检测",48,3,"汽车检测工位"]
["校外顶岗实习",5,7.5,"顶岗实习","顶岗工作","本专业主要岗位实习",200,11.5,"校外相关企业"]
[null,6,17.5,"顶岗实习","顶岗工作","本专业主要岗位实习",450,26,"校外相关企业"]
["合  计",null,41,{"$nulls":3},1034,61.5]
[]
["注：①.校内综合实训，每周按24学时计算，每周折合1.5学分。实践形式包括课程技能训练、职业资格培训等。"]
["    ②.校外顶岗实习，每周按26学时计算，每周折合1.5学分。实践形式包括顶岗工作和毕业论文（设计）等。"]

{"sheet":"表六","index":6,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[0,0,0,4],[2,0,2,1],[3,0,7,0],[8,0,10,0],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[27,2,27,4],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1]],"flags":["formulas_cached_only"]}
["表6 汽车制造与试验技术专业学时、学分分配比例"]
[]
["1.理论课教学环节"]
["纵     向      结     构","类  别","学  时","占理论课总学时百分比","理实学分"]
[null,"公共基础课",852,{"v":0.5365239294710328,"d":"53.7%"},48.5]
[null,"专业课",688,{"v":0.4332493702770781,"d":"43.3%"},43]
[null,"公选课",48,{"v":0.030226700251889168,"d":"3.0%"},3]
[null,"合计",1588,{"v":1,"d":"100.0%"},94.5]
["横     向     结     构","必修课",1156,{"v":0.7279596977329975,"d":"72.8%"},67.5]
[null,"限选课、拓展课、公选课",432,{"v":0.27204030226700254,"d":"27.2%"},27]
[null,"合计",1588,{"v":1,"d":"100.0%"},94.5]
[]
[]
["2.实践课教学环节"]
["类  别",null,"周数","学  时","占实践课总学时百分比"]
["专项技能训练",null,3.5,120,{"v":0.08797653958944282,"d":"8.8%"}]
["校内综合实训",null,16,386,{"v":0.2829912023460411,"d":"28.3%"}]
["校外顶岗实习",null,25,650,{"v":0.47653958944281527,"d":"47.7%"}]
["课内实践学时",null,"—",208,{"v":0.15249266862170088,"d":"15.2%"}]
["合计",null,44.5,1364,{"v":1,"d":"100.0%"}]
[]
[]
["3.理论课与实践课之比"]
["类  别",null,"周数","学  时","占全部课程总学时百分比"]
["理论课",null,63,1380,{"v":0.5029154518950437,"d":"50.3%"}]
["实践课",null,44.5,1364,{"v":0.4970845481049563,"d":"49.7%"}]
["合计",null,107.5,2744,{"v":1,"d":"100.0%"}]
["理论课与实践课比例",null,1.1642228739002933]
[]
[]
["4.公共基础课、选修课占总学时之比"]
["类  别",null,"周数","学  时","占全部课程总学时百分比"]
["理论课与实践课总学时",null,"—",2744,"—"]
["公共基础课总学时",null,"—",852,{"v":0.3104956268221574,"d":"31.0%"}]
["限选课、拓展课、公选课总学时",null,"—",432,{"v":0.15743440233236153,"d":"15.7%"}]

{"sheet":"表七","index":7,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,0,0,7],[2,1,2,4],[3,0,5,0],[3,1,5,1],[3,3,3,4],[3,5,5,5],[4,3,4,4],[5,3,5,4],[6,0,8,0],[6,1,8,1],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,0,12,0],[9,1,12,1],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4]],"flags":["formulas_cached_only"]}
["表7 汽车制造与试验技术专业教学过程学分构成"]
[{"$nulls":7},"表七"]
["序号","教学活动项目",{"$nulls":3},"周数","学分数","学分计算标准"]
["一","理论    教学",1,"公共基础课",null,63,48.5,"16-18学时1学分"]
[null,null,2,"专业课",null,null,43,"16-18学时1学分"]
[null,null,3,"公共选修课",null,null,3,"16-18学时1学分"]
["二","实践   课程",6,"军事技能训练",null,3.5,2,"教育部文件规定"]
[null,null,4,"校内综合实训",null,16,24,"每周1.5学分"]
[null,null,5,"校外顶岗实习",null,25,37.5,"每周1.5学分"]
["三","其它       环节",7,"执勤、劳动教育",null,1,1,"每周1学分"]
[null,null,8,"入学教育",null,0.5,0.5,"每周1学分"]
[null,null,9,"毕业教育与毕业答辩",null,1,1,"每周1学分"]
[null,null,10,"社会实践",null,2,2,"每周1学分"]
["合计","—","—","共计10项",null,112,162.5]