{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["附件3.1","附件3.2","附件3.3","附件3.4"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"附件3.1","index":0,"n_rows":97,"n_cols":13,"rows_kept":97,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,1,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[3,0,17,0],[3,1,10,1],[3,2,9,2],[3,12,9,12],[11,1,17,1],[11,2,17,2],[11,10,17,10],[11,11,17,11],[11,12,17,12],[18,0,37,0],[18,1,37,1],[18,2,37,2],[18,12,37,12],[38,0,38,12],[39,0,40,0],[39,1,40,1],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,39,9],[39,10,40,10],[39,11,40,11],[39,12,40,12],[41,0,48,0],[41,1,48,1],[41,2,48,2],[41,12,48,12],[49,0,74,0],[49,1,56,1],[49,2,53,2],[49,12,53,12],[54,2,56,2],[54,12,56,12],[57,1,74,1],[57,2,74,2],[57,11,59,11],[57,12,74,12],[60,11,64,11],[65,11,69,11],[70,11,74,11],[75,0,75,12],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,6,76,9],[76,10,77,10],[76,11,77,11],[76,12,77,12],[78,0,86,0],[78,1,86,1],[78,2,86,2],[78,12,86,12],[87,0,87,11],[88,0,96,0],[88,1,96,1],[88,2,88,4],[88,5,88,6],[88,7,88,9],[88,10,88,12],[89,2,89,4],[89,5,89,6],[89,7,89,9],[89,10,89,12],[90,2,90,4],[90,5,90,6],[90,7,90,9],[90,10,90,12],[91,2,91,4],[91,5,91,6],[91,7,91,9],[91,10,91,12],[92,2,92,4],[92,5,92,6],[92,7,92,9],[92,10,92,12],[93,2,93,4],[93,5,93,6],[93,7,93,9],[93,10,93,12],[94,2,94,4],[94,5,94,6],[94,7,94,9],[94,10,94,12],[95,2,95,4],[95,5,95,6],[95,7,95,9],[95,10,95,12],[96,2,96,4],[96,5,96,6],[96,7,96,9],[96,10,96,12]]}
["附表1：               车辆工程专业课程设置与学分分布表"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["通识教育","必修","理论（含课内实践）","1BH07001","思想道德修养与法律基础",3,48,36,12,null,1,null,{"$f":"SUM(F4:F10)","v":35}]
[{"$nulls":3},"1BH07002","马克思主义基本原理概论",3,48,36,12,null,2]
[{"$nulls":3},"1BH16002","中国近现代史纲要",3,48,36,12,null,3]
[{"$nulls":3},"1BH16003","毛泽东思想和中国特色社会主义理论体系概论",3,48,36,12,null,4]
[{"$nulls":3},"1BL10006-9","大学体育(1)-(4)",4,128,128,null,null,"1--4"]
[{"$nulls":3},"1BL08001-4","大学英语(1)-(4)",16,256,224,32,null,"1--4"]
[{"$nulls":3},"1BH11001","C语言程序设计B",3,48,32,null,16,2]
[null,null,"实践环节","1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},4,null,2]
[null,"选修","理论（含课内实践）","第一模块","自然科学与信息技术",{"$nulls":5},"1--7","建议选修不少于4学分的经济管理、人文社科类课程；不少于2学分的创新创业课程；不少于2学分的跨文化沟通与交流课程","至\n少\n选\n修\n8\n学\n分"]
[{"$nulls":3},"第二模块","经济管理"]
[{"$nulls":3},"第三模块","人文社科"]
[{"$nulls":3},"第四模块","创新创业"]
[{"$nulls":3},"第五模块","艺术与体育"]
[{"$nulls":3},"第六模块","跨文化沟通与交流"]
[{"$nulls":3},"第七模块","卓越工程师素质教育"]
["学科基础教育","必修","理论(含课内实践）","1BL09001-2","高等数学A(1)(2)",11,176,176,null,null,"1--2",null,{"$f":"SUM(F19:F38)","v":67}]
[{"$nulls":3},"1BL09008","线性代数B",2,32,32,null,null,2]
[{"$nulls":3},"1BL09010","概率论与数理统计B",2,32,32,null,null,3]
[{"$nulls":3},"1BL09013-14","大学物理A(1)(2)",6.5,104,104,null,null,"2--3"]
[{"$nulls":3},"0BH01146","工科化学",2,32,{"$f":"G23-I23","v":28},4,null,1]
[{"$nulls":3},"0BL01301","汽车概论",1,16,16,null,null,1]
[{"$nulls":3},"0BL01907-8","工程制图(1)(2)",5,80,80,null,null,"1--2"]
[{"$nulls":3},"0BL01903","理论力学",4,64,64,null,null,3]
[{"$nulls":3},"0BH01502","材料力学",3,48,44,4,null,4]
[{"$nulls":3},"0BH20032","电工技术基础",4,64,48,16,null,3]
[{"$nulls":3},"0BH20033","电子技术基础",4,64,{"$f":"G29-I29","v":48},16,null,4]
[{"$nulls":3},"0BH01903","互换性与技术测量",1.5,24,20,4,null,4]
[{"$nulls":3},"0BH01905","工程材料与热处理",2,32,26,6,null,5]
[{"$nulls":3},"0BH01511","机械原理",3.5,56,50,6,null,4]
[{"$nulls":3},"0BH01910","机械设计",4,64,58,6,null,5]
[{"$nulls":3},"0BH01109","机械控制工程",2.5,40,36,4,null,5]
[{"$nulls":3},"0BH01510","机械制造技术基础",3,48,42,6,null,6]
[{"$nulls":3},"0BH01312","工程热力学",2,32,28,4,null,5]
[{"$nulls":3},"0BH01304","单片机应用技术",2,32,26,6,null,5]
[{"$nulls":3},"0BH01301","液压与液力传动",2,32,28,4,null,6]
["附表1：               车辆工程专业课程设置与学分分布表（续1）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["学科基础教育","必修","实践环节","1BS09001-2","物理实验A(1)(2)",3.5,56,null,56,null,"2--3",null,{"$f":"SUM(F42:F49)","v":16.5}]
[{"$nulls":3},"1BS12003","金工实习",3,"3周",{"$nulls":3},2]
[{"$nulls":3},"0BS01301","专业认知实践",1,"1周",{"$nulls":3},1,"分散"]
[{"$nulls":3},"0BS01902","制图专用周",2,"2周",{"$nulls":3},3]
[{"$nulls":3},"0BS01903","机械原理课程设计",1,"1周",{"$nulls":3},4]
[{"$nulls":3},"1BS12005","电工电子实习A",2,"2周",{"$nulls":3},5]
[{"$nulls":3},"0BS01203","机械设计课程设计",2,"2周",{"$nulls":3},5]
[{"$nulls":3},"0BS01305","汽车生产实习",2,"2周",{"$nulls":3},6]
["专业教育","必修","理论(含课内实践）","0B01314","汽车构造",4,64,{"$f":"G50-I50","v":58},6,null,5,null,{"$f":"SUM(F50:F54)","v":13}]
[{"$nulls":3},"0BH01319","汽车理论",3,48,48,null,null,6]
[{"$nulls":3},"0BL01317","汽车设计",3,48,48,null,null,7]
[{"$nulls":3},"0BH01306","汽车电子学",2.5,40,34,6,null,6]
[{"$nulls":3},"0BL01302","文献检索与论文写作",0.5,8,8,null,null,7]
[null,null,"实践环节","0BS01315","汽车结构拆装综合实验",1,"1周",{"$nulls":3},5,"分散",{"$f":"SUM(F55:F57)","v":11.5}]
[{"$nulls":3},"0BS01313","汽车设计课程设计",2,"2周",{"$nulls":3},7,"集中"]
[{"$nulls":3},"0BS01302","毕业设计",8.5,"17周",{"$nulls":3},8]
[null,"选修","理论（含课内实践）","0RL01305","发动机原理",2,32,{"$f":"G58-I58","v":32},null,null,5,null,"至\n少\n选\n修\n12\n学\n分"]
[{"$nulls":3},"0BH01306","汽车工程测试基础",2.5,40,32,8,null,6]
[{"$nulls":3},"0RL01329","车辆专业英语",1.5,24,24,null,null,6]
[{"$nulls":3},"0RL01307","汽车车身设计",2,32,{"$f":"G61-I61","v":32},null,null,6,"汽车设计与制造课程群"]
[{"$nulls":3},"0RH01324","汽车CAD/CAM",2,32,{"$f":"G62-J62","v":24},null,8,6]
[{"$nulls":3},"0RL01306","汽车制造工艺学",2,32,28,4,null,7]
[{"$nulls":3},"0RH01308","有限元基础及其应用",2,32,20,null,12,7]
[{"$nulls":3},"0RH01301","汽车系统动力学与仿真",2,32,{"$f":"G65-J65","v":24},null,8,7]
[{"$nulls":3},"0RL01301","汽车车身电控技术",2,32,{"$f":"G66-I66","v":32},null,null,6,"汽车电子与电动汽车课程群"]
[{"$nulls":3},"0RL01302","汽车车载网络技术",2,32,32,null,null,7]
[{"$nulls":3},"0RH01336","新能源汽车技术",2,32,32,null,null,7]
[{"$nulls":3},"0RL01303","电动汽车电驱动技术",2,32,{"$f":"G69-I69","v":32},null,null,6]
[{"$nulls":3},"0RL01304","电动汽车动力电池技术 ",2,32,32,null,null,7]
[{"$nulls":3},"0RH01307","汽车运用工程",2,32,28,4,null,6,"汽车检测与服务课程群"]
[{"$nulls":3},"0RH01302","汽车营销与保险",2,32,26,6,null,6]
[{"$nulls":3},"0RH01303","汽车检测与故障诊断",2,32,26,6,null,6]
[{"$nulls":3},"0RH01304","汽车维修工程",2,32,{"$f":"G74-I74","v":28},4,null,7]
[{"$nulls":3},"0RH01330","汽车电器",1.5,24,{"$f":"G75-I75","v":20},4,null,7]
["附表1：               车辆工程专业课程设置与学分分布表（续2）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["专业教育","选修","实践","0RS01312","学科竞赛",2,"2周",{"$nulls":3},"4--6","方程式赛车、节能车","至\n少\n选\n修\n6\n学\n分"]
[{"$nulls":3},"0RS01301","现代工程软件实训",2,"2周",{"$nulls":3},"2--6","分散"]
[{"$nulls":3},"0RS01302","汽车产品实物制作",2,"2周",{"$nulls":3},"3--6","分散"]
[{"$nulls":3},"0RS01303","汽车制造工艺课程设计",2,"2周",{"$nulls":3},7,"分散"]
[{"$nulls":3},"0RS01308","汽车服务工程课程设计",2,"2周",{"$nulls":3},7,"分散"]
[{"$nulls":3},"0RS01304","汽车电子控制开放实验",1,"1周",{"$nulls":3},6,"分散"]
[{"$nulls":3},"0RS01309","新能源汽车技术实训",1,"1周",{"$nulls":3},7,"分散"]
[{"$nulls":3},"0RS01310","汽车检测与诊断模拟实训",1,"1周",{"$nulls":3},7,"分散"]
[{"$nulls":3},"0RS01313","车险理赔估损模拟实训",1,"1周",{"$nulls":3},7,"分散"]
["毕业总学分",{"$nulls":11},{"$f":"SUM(M4:M11,8,M19:M57,12,6)","v":171}]
["第二课堂","必修","教育环节",null,null,"素质教育学分",null,"学时数",null,null,"修课年级"]
[null,null,"军事理论",null,null,2,null,32,null,null,"1年级"]
[null,null,"军训",null,null,2,null,"2周",null,null,"1年级"]
[null,null,"大学生心理健康",null,null,2,null,32,null,null,"1年级"]
[null,null,"大学生职业规划",null,null,1,null,24,null,null,"1年级"]
[null,null,"大学生安全知识教育",null,null,1,null,20,null,null,"1年级"]
[null,null,"形势与政策课",null,null,2,null,32,null,null,"2年级"]
[null,null,"体质健康达标测试",null,null,1,null,28,null,null,"1-4年级"]
[null,null,"就业创业指导",null,null,1,null,20,null,null,"4年级"]

{"sheet":"附件3.2","index":1,"n_rows":114,"n_cols":11,"rows_kept":114,"merged":[[0,0,0,10],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[3,0,3,10],[12,0,12,10],[13,0,13,1],[13,2,13,10],[14,0,14,10],[25,0,25,10],[26,0,26,1],[26,2,26,10],[27,0,27,10],[37,0,37,10],[38,0,38,1],[38,2,38,10],[39,0,39,10],[40,0,41,0],[40,1,41,1],[40,2,41,2],[40,3,41,3],[40,4,40,6],[40,7,41,7],[40,8,41,8],[40,9,41,9],[40,10,41,10],[42,0,42,10],[52,0,52,10],[53,0,53,1],[53,2,53,10],[54,0,54,10],[65,0,65,10],[66,0,66,1],[66,2,66,10],[67,0,67,10],[77,0,77,10],[78,0,79,0],[78,1,79,1],[78,2,79,2],[78,3,79,3],[78,4,78,6],[78,7,79,7],[78,8,79,8],[78,9,79,9],[78,10,79,10],[89,0,89,10],[90,0,90,1],[90,2,90,10],[91,0,91,10],[108,0,108,10],[109,0,109,1],[109,2,109,10],[110,0,110,10],[112,0,112,10],[113,0,113,1],[113,2,113,10]]}
["附表2：               车辆工程专业分学期教学计划进程表"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程\n类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第一学期"]
["1BH07001","思想道德修养与法律基础",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10006","大学体育(1)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL08001","大学英语(1)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL09001","高等数学A(1)",6,96,96,null,null,"必修","学科理论","理学院"]
["0BL01907","工程制图(1)",3.5,56,{"$f":"D9-F9","v":56},null,null,"必修","学科理论","机电学院"]
["0BH01146","工科化学",2,32,28,4,null,"必修","学科理论","机电学院"]
["0BL01301","汽车概论",1,16,16,null,null,"必修","学科理论","机电学院"]
["0BS01301","专业认知实践",1,"1周",{"$nulls":3},"必修","学科实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修21.5学分，建议选修2-4学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第二学期"]
["1BH07002","马克思主义基本原理概论",3,48,{"$f":"D16-F16","v":36},12,null,"必修","通识理论","马院"]
["1BL10007","大学体育(2)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL08002","大学英语(2)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BH11001","C语言程序设计B",3,48,{"$f":"D19-G19","v":32},null,16,"必修","通识理论","计算中心"]
["1BL09002","高等数学A(2)",5,80,80,null,null,"必修","学科理论","理学院"]
["1BL09008","线性代数B",2,32,{"$f":"D21-F21","v":32},null,null,"必修","学科理论","理学院"]
["1BL09013","大学物理A(1)",3.5,52,52,null,null,"必修","学科理论","理学院"]
["0BL01908","工程制图(2)",1.5,24,24,null,null,"必修","学科理论","机电学院"]
["1BS09001","物理实验A(1)",2,30,null,30,null,"必修","学科实践","理学院"]
["1BS12003","金工实习",3,"3周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修28学分，建议选修2-4学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第三学期"]
["1BH16002","中国近现代史纲要",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10008","大学体育(3)",1,32,{"$f":"D30-F30","v":32},null,null,"必修","通识理论","体育部"]
["1BL08003","大学英语(3)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL09010","概率论与数理统计B",2,32,32,null,null,"必修","学科理论","理学院"]
["1BL09014","大学物理A(2)",3,52,52,null,null,"必修","学科理论","理学院"]
["0BL01903","理论力学",4,64,64,null,null,"必修","学科理论","机电学院"]
["0BH20032","电工技术基础",4,64,48,16,null,"必修","学科理论","信控中心"]
["1BS09002","物理实验A(2)",1.5,26,null,26,null,"必修","学科实践","理学院"]
["0BS01902","制图专用周",2,"2周",{"$nulls":3},"必修","学科实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修24.5学分，建议选修2-4学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["附表2：               车辆工程专业分学期教学计划进程表（续1）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程\n类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第四学期"]
["1BH16003","毛泽东思想和中国特色社会主义理论体系概论",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10009","大学体育(4)",1,32,{"$f":"D45-F45","v":32},null,null,"必修","通识理论","体育部"]
["1BL08004","大学英语(4)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["0BH01502","材料力学",3,48,44,4,null,"必修","学科理论","机电学院"]
["0BH20033","电子技术基础",4,64,48,16,null,"必修","学科理论","信控中心"]
["0BH01903","互换性与技术测量",1.5,24,20,4,null,"必修","学科理论","机电学院"]
["0BH01511","机械原理",3.5,56,50,6,null,"必修","学科理论","机电学院"]
["1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},"必修","通识实践","马院"]
["0BS01903","机械原理课程设计",1,"1周",{"$nulls":3},"必修","学科实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修23学分，建议选修4学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第五学期"]
["0BH01905","工程材料与热处理",2,32,{"$f":"D56-F56","v":26},6,null,"必修","学科理论","机电学院"]
["0BH01910","机械设计",4,64,58,6,null,"必修","学科理论","机电学院"]
["0BH01109","机械控制工程",2.5,40,36,4,null,"必修","学科理论","机电学院"]
["0BH01312","工程热力学",2,32,28,4,null,"必修","学科理论","机电学院"]
["0BH01304","单片机应用技术",2,32,{"$f":"D60-F60","v":26},6,null,"必修","学科理论","机电学院"]
["0B01314","汽车构造",4,64,58,6,null,"必修","专业理论","机电学院"]
["0RL01305","发动机原理",2,32,32,null,null,"选修","专业理论","机电学院"]
["1BS12005","电工电子实习A",2,"2周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["0BS01904","机械设计课程设计",2,"2周",{"$nulls":3},"必修","学科实践","机电学院"]
["0BS01315","汽车结构拆装综合实验",1,"1周",{"$nulls":3},"必修","专业实践","机电学院","分散"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修21.5学分，建议选修4-6学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第六学期"]
["0BH01510","机械制造技术基础",3,48,42,6,null,"必修","学科理论","机电学院"]
["0BH01301","液压与液力传动",2,32,{"$f":"D70-F70","v":28},4,null,"必修","学科理论","机电学院"]
["0BH01319","汽车理论",3,48,48,null,null,"必修","专业理论","机电学院"]
["0BH01306","汽车电子学",2.5,40,34,6,null,"必修","专业理论","机电学院"]
["0BH01302","汽车工程测试基础",2.5,40,{"$f":"D73-F73","v":32},8,null,"选修","专业理论","机电学院"]
["0RL01329","车辆专业英语",1.5,24,24,null,null,"选修","专业理论","机电学院"]
["0RL01307","汽车车身设计",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RH01324","汽车CAD/CAM",2,32,{"$f":"D76-G76","v":24},null,8,"选修","专业理论","机电学院"]
["0RL01301","汽车车身电控技术",2,32,{"$f":"D77-F77","v":32},null,null,"选修","专业理论","机电学院"]
["附表2：               车辆工程专业分学期教学计划进程表（续2）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程\n类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["0RL01303","电动汽车电驱动技术",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RH01307","汽车运用工程",2,32,28,4,null,"选修","专业理论","机电学院"]
["0RH01302","汽车营销与保险",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RH01303","汽车检测与故障诊断",2,32,{"$f":"D84-F84","v":26},6,null,"选修","专业理论","机电学院"]
["0RS01304","汽车电子控制开放实验",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["0BS01305","汽车生产实习",2,"2周",{"$nulls":3},"必修","学科实践","机电学院"]
["0RS01301","现代工程软件实训",2,"2周",{"$nulls":3},"选修","专业实践","机电学院","分散"]
["0RS01302","汽车产品实物制作",2,"2周",{"$nulls":3},"选修","专业实践","机电学院","分散"]
["0RS01312","学科竞赛",2,"2周",{"$nulls":3},"选修","专业实践","机电学院","分散"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修12.5学分，建议选修8学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第七学期"]
["0BL01302","文献检索与论文写作",0.5,8,8,null,null,"必修","专业理论","机电学院"]
["0BL01317","汽车设计",3,48,{"$f":"D94-F94","v":48},null,null,"必修","专业理论","机电学院"]
["0RL01306","汽车制造工艺学",2,32,28,4,null,"选修","专业理论","机电学院"]
["0RH01308","有限元基础及其应用",2,32,20,null,12,"选修","专业理论","机电学院"]
["0RH01301","汽车系统动力学与仿真",2,32,{"$f":"D97-G97","v":24},null,8,"选修","专业理论","机电学院"]
["0RL01302","汽车车载网络技术",2,32,{"$f":"D98-F98","v":32},null,null,"选修","专业理论","机电学院"]
["0RH01336","新能源汽车技术",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RL01304","电动汽车动力电池技术",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RH01304","汽车维修工程",2,32,28,4,null,"选修","专业理论","机电学院"]
["0RH01330","汽车电器",1.5,24,20,4,null,"选修","专业理论","机电学院"]
["0BS01313","汽车设计课程设计",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0RS01303","汽车制造工艺课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01308","汽车服务工程课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01309","新能源汽车技术实训",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01310","汽车检测与诊断模拟实训",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01313","车险理赔估损模拟实训",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修5.5学分，建议选修8学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第八学期"]
["0BS01302","毕业设计",8.5,"17周",{"$nulls":3},"必修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修8.5学分，建议选修0学分（包括通识理论选修课、专业理论选修课、实践选修）"]

{"sheet":"附件3.3","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[0,0,0,5],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,2,5],[6,1,6,5],[8,1,8,2],[8,3,8,4]]}
["附表3：                 车辆工程专业学分分配表"]
["教育层次","理论（含课内实践）",null,"实践",null,"合计"]
[null,"必修","选修","必修","选修"]
["通识教育",35,"至少选修8学分",2,"-",{"$f":"SUM(B4,8,D4)","v":45}]
["学科基础教育",67,"-",16.5,"-",{"$f":"SUM(B5,D5)","v":83.5}]
["专业教育",13,"至少选修12学分",11.5,"至少选修6学分",{"$f":"SUM(B6,12,D6,6)","v":42.5}]
["第二课堂\n（素质教育专项）","第二课堂学分不计入学分绩点"]
["小计",{"$f":"SUM(B4:B6)","v":115},"至少选修20学分",{"$f":"SUM(D4:D6)","v":30},"至少选修6学分",171]
["总计",{"$f":"SUM(B8,20)","v":135},null,{"$f":"SUM(D8,6)","v":36},null,{"$f":"SUM(F4:F6)","v":171}]

{"sheet":"附件3.4","index":3,"n_rows":81,"n_cols":16,"rows_kept":81,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,15],[3,0,14,0],[15,0,39,0],[40,0,40,15],[41,0,42,0],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,41,15],[43,0,45,0],[46,0,80,0]]}
["附表4：                  车辆工程专业毕业要求实现矩阵"]
["教育层次","课程名称","学分","课程类别","修读课程可实现毕业要求情况"]
[{"$nulls":4},"毕业要求1","毕业要求2","毕业要求3","毕业要求4","毕业要求5","毕业要求6","毕业要求7","毕业要求8","毕业要求9","毕业要求10","毕业要求11","毕业要求12"]
["通识教育","思想道德修养与法律基础",3,"必修",{"$nulls":5},"√",null,"√","√"]
[null,"马克思主义基本原理概论",3,"必修",{"$nulls":5},"√",null,null,"√"]
[null,"中国近现代史纲要",3,"必修",{"$nulls":5},"√",null,null,"√"]
[null,"毛泽东思想和中国特色社会主义理论体系概论",3,"必修",{"$nulls":5},"√",null,null,"√"]
[null,"大学体育(1)-(4)",4,"必修",{"$nulls":8},"√"]
[null,"大学英语(1)-(4)",16,"必修",{"$nulls":9},"√"]
[null,"C语言程序设计B",3,"必修","√",null,null,"√","√"]
[null,"思想政治理论课综合实践",2,"必修",{"$nulls":5},"√",null,"√","√"]
[null,"经济管理",2,"选修",{"$nulls":10},"√"]
[null,"人文社科",2,"选修",{"$nulls":5},"√",null,"√"]
[null,"创新创业",2,"选修",{"$nulls":6},"√","√","√"]
[null,"跨文化沟通与交流",2,"选修",{"$nulls":9},"√"]
["学科基础教育","高等数学A(1)(2)",11,"必修","√"]
[null,"线性代数B",2,"必修","√"]
[null,"概率论与数理统计B",2,"必修","√"]
[null,"大学物理A(1)(2)",6.5,"必修","√"]
[null,"工科化学",2,"必修","√"]
[null,"汽车概论",1.5,"必修","√",null,"√"]
[null,"工程制图(1)(2)",5,"必修","√",null,"√",null,"√"]
[null,"理论力学",4,"必修","√",null,"√"]
[null,"材料力学",3,"必修","√",null,"√"]
[null,"电工技术基础",4,"必修","√",null,"√"]
[null,"电子技术基础",4,"必修","√",null,"√"]
[null,"互换性与技术测量",1.5,"必修","√",null,"√"]
[null,"工程材料与热处理",2,"必修","√",null,"√"]
[null,"机械原理",3.5,"必修","√",null,"√"]
[null,"机械设计",4,"必修","√",null,"√"]
[null,"机械控制工程",2.5,"必修","√",null,null,"√"]
[null,"机械制造技术基础",3,"必修","√"]
[null,"工程热力学",2,"必修","√"]
[null,"单片机应用技术",2,"必修","√",null,null,"√"]
[null,"液压与液力传动",2,"必修","√"]
[null,"物理实验A(1)(2)",3.5,"必修","√"]
[null,"金工实习",3,"必修","√"]
[null,"专业认知实践",1,"必修","√",{"$nulls":5},"√"]
[null,"制图专用周",2,"必修","√",null,"√",null,"√"]
[null,"机械原理课程设计",1,"必修","√","√","√",null,"√"]
["附表4：                  车辆工程专业毕业要求实现矩阵（续）"]
["教育层次","课程名称","学分","课程类别","修读课程可实现毕业要求情况"]
[{"$nulls":4},"毕业要求1","毕业要求2","毕业要求3","毕业要求4","毕业要求5","毕业要求6","毕业要求7","毕业要求8","毕业要求9","毕业要求10","毕业要求11","毕业要求12"]
["学科基础教育","电工电子实习A",2,"必修","√","√"]
[null,"机械设计课程设计",2,"必修","√","√","√"]
[null,"汽车生产实习",2,"必修","√",{"$nulls":8},"√"]
["专业教育","汽车构造",4,"必修","√"]
[null,"汽车理论",3,"必修","√",null,null,"√"]
[null,"汽车设计",3,"必修","√",null,"√"]
[null,"汽车电子学",3,"必修","√"]
[null,"文献检索与论文写作",0.5,"必修","√","√","√","√","√",null,null,"√",null,"√",null,"√"]
[null,"汽车结构拆装综合实验",1,"必修","√","√"]
[null,"汽车设计课程设计",2,"必修","√","√","√","√",{"$nulls":5},"√",null,"√"]
[null,"毕业设计",8.5,"必修","√","√","√","√",{"$nulls":5},"√",null,"√"]
[null,"发动机原理",2,"选修","√",{"$nulls":8},"√"]
[null,"车辆专业英语",1.5,"选修","√",{"$nulls":8},"√"]
[null,"汽车工程测试基础",2,"选修","√",null,"√","√","√"]
[null,"汽车制造工艺学",2,"必修","√",null,"√"]
[null,"汽车检测与故障诊断",2,"必修","√",null,"√",null,"√"]
[null,"新能源汽车技术",2,"必修","√"]
[null,"汽车车身设计",2,"选修","√",null,"√"]
[null,"汽车CAD/CAM",2,"选修","√",null,"√",null,"√"]
[null,"有限元基础及其应用",2,"选修","√",null,"√","√","√"]
[null,"汽车系统动力学与仿真",2,"选修","√",null,null,"√","√"]
[null,"汽车车身电控技术",2,"选修","√"]
[null,"汽车车载网络技术",2,"选修","√"]
[null,"电动汽车电驱动技术",2,"选修","√",{"$nulls":5},"√"]
[null,"电动汽车动力电池技术 ",2,"选修","√",{"$nulls":5},"√"]
[null,"汽车运用工程",2,"选修","√"]
[null,"汽车营销与保险",2,"选修","√"]
[null,"汽车维修工程",2,"选修","√"]
[null,"汽车电器",1.5,"选修","√"]
[null,"学科竞赛",2,"选修","√","√","√","√","√",null,null,"√",null,"√","√"]
[null,"现代工程软件实训",2,"选修","√","√","√","√","√"]
[null,"汽车产品实物制作",2,"选修","√","√","√","√","√"]
[null,"汽车制造工艺课程设计",2,"选修","√","√","√",null,"√"]
[null,"汽车服务工程课程设计",2,"选修","√","√","√",null,"√"]
[null,"汽车电子控制开放实验",1,"选修","√","√","√",null,"√"]
[null,"新能源汽车技术实训",1,"选修","√","√",{"$nulls":4},"√"]
[null,"汽车检测与诊断模拟实训",1,"选修","√",{"$nulls":3},"√"]
[null,"车险理赔估损模拟实训",1,"选修","√",{"$nulls":3},"√"]