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

{"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,47,0],[41,1,47,1],[41,2,47,2],[41,12,47,12],[48,0,74,0],[48,1,53,1],[48,2,51,2],[48,12,51,12],[52,2,53,2],[52,12,53,12],[54,1,74,1],[54,2,74,2],[54,11,55,11],[54,12,74,12],[56,11,61,11],[62,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,84,0],[78,1,84,1],[78,2,84,2],[78,12,82,12],[83,12,84,12],[85,0,85,11],[86,0,94,0],[86,1,94,1],[86,2,86,4],[86,5,86,6],[86,7,86,9],[86,10,86,12],[87,2,87,4],[87,5,87,6],[87,7,87,9],[87,10,87,12],[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,0,95,12],[96,0,96,12]],"flags":["formulas_cached_only"]}
["附表1：      机械设计制造及其自动化专业课程设置与学分分布表"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["通识教育","必修","理论（含课内实践）","1BH07001","思想道德修养与法律基础",3,48,36,12,null,1,null,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,16,null,1]
[null,null,"实践环节","1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},4,null,2]
[null,"选修","理论（含课内实践）","第一模块","自然科学与信息技术",{"$nulls":5},"1--7","要求：第二模块选修2学分、第六模块选修2学分、第七模块选修2学分","至\n少\n选\n修\n8\n学\n分"]
[{"$nulls":3},"第二模块","经济管理"]
[{"$nulls":3},"第三模块","人文社科"]
[{"$nulls":3},"第四模块","创新创业"]
[{"$nulls":3},"第五模块","艺术与体育"]
[{"$nulls":3},"第六模块","跨文化沟通与交流"]
[{"$nulls":3},"第七模块","卓越工程师素质教育"]
["学科基础教育","必修","理论(含课内实践）","0BL01115","专业导论",0.5,8,8,null,null,1,null,70.5]
[{"$nulls":3},"1BL09001-2","高等数学A(1)(2)",11,176,176,null,null,"1--2"]
[{"$nulls":3},"1BL09007","线性代数A",3,48,48,null,null,2]
[{"$nulls":3},"1BL09010","概率论与数理统计B",2,32,32,null,null,3]
[{"$nulls":3},"1BL09012","复变函数与积分变换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,28,4,null,1]
[{"$nulls":3},"0BH01312","工程热力学",2,32,28,4,null,5]
[{"$nulls":3},"0BL01907-8","工程制图(1)(2)",5,80,80,null,null,"1--2"]
[{"$nulls":3},"0BL01903","理论力学",4,64,64,null,null,3]
[{"$nulls":3},"0BH01303","材料力学",4,64,58,6,null,4]
[{"$nulls":3},"0BH20032","电工技术基础",4,64,48,16,null,3]
[{"$nulls":3},"0BH20033","电子技术基础",4,64,48,16,null,4]
[{"$nulls":3},"0BH01903","互换性与技术测量",1.5,24,18,6,null,4]
[{"$nulls":3},"0BH01908","工程材料",2,32,26,6,null,5]
[{"$nulls":3},"0BH01909","机械原理",4,64,58,6,null,4]
[{"$nulls":3},"0BH01910","机械设计",4,64,58,6,null,5]
[{"$nulls":3},"0BH01126","计算机控制技术",2,32,26,6,null,5]
[{"$nulls":3},"0BH01109","机械控制工程",2.5,40,36,4,null,5]
[{"$nulls":3},"0BH01116","机械制造技术基础",4.5,72,64,8,null,6]
["附表1：     机械设计制造及其自动化专业课程设置与学分分布表（续1）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课学期","备注","学分要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["学科基础教育","必修","实践环节","1BS09001-2","物理实验A(1)(2) ",3.5,56,null,56,null,"2--3",null,18]
[{"$nulls":3},"1BS12007-8","金工实习(1)(2)",4,"4周",{"$nulls":3},"2--3"]
[{"$nulls":3},"1BS12005","电工电子实习A",2,"2周",{"$nulls":3},5]
[{"$nulls":3},"0BS01902","制图专用周",2,"2周",{"$nulls":3},3]
[{"$nulls":3},"0BS01903","机械原理课程设计",1,"1周",{"$nulls":3},4]
[{"$nulls":3},"0BS01904","机械设计课程设计",3,"3周",{"$nulls":3},5]
[{"$nulls":3},"0BS01104","机械制造技术基础课程设计",2.5,"2.5周",{"$nulls":3},6]
["专业教育","必修","理论(含课内实践）","0BH01102","智能检测技术",2,32,24,8,null,6,null,9]
[{"$nulls":3},"0BH01901","液压与气压传动",2.5,40,34,6,null,6]
[{"$nulls":3},"0BH01103","智能制造装备及自动化",2.5,40,34,6,null,7]
[{"$nulls":3},"0BH01105","制造过程信息化与网络化",2,32,24,null,8,6]
[null,null,"实践环节","0BS01106","生产实习",2,"2周",{"$nulls":3},6,null,10.5]
[{"$nulls":3},"0BS01112","毕业实习和设计",8.5,"17周",{"$nulls":3},8]
[null,"选修","理论（含课内实践）","0RH01134","计算机绘图",2,32,16,null,16,2,"基础类","至\n少\n选\n修\n12\n学\n分"]
[{"$nulls":3},"0RL01133","专业外语",2,32,32,null,null,5]
[{"$nulls":3},"0RH01136","有限元分析基础",1.5,24,16,null,8,5,"设计类"]
[{"$nulls":3},"0RH01137","产品建模与仿真",2,32,24,null,8,5]
[{"$nulls":3},"0RH01120","优化设计",1.5,24,20,null,4,6]
[{"$nulls":3},"0RH01130","机械创新设计",2,32,22,10,null,7]
[{"$nulls":3},"0RH01118","计算机辅助设计",2,32,26,null,6,7]
[{"$nulls":3},"0RH01119","机械系统设计学",2,32,26,6,null,7]
[{"$nulls":3},"0RH01135","材料成型技术",2,32,30,2,null,5,"智能制造类"]
[{"$nulls":3},"0RH01123","模具CAD/CAM",1.5,24,18,6,null,6]
[{"$nulls":3},"0RH01101","数控技术",2,32,26,6,null,6]
[{"$nulls":3},"0RL01101","绿色制造技术",1.5,24,24,null,null,6]
[{"$nulls":3},"0RL01140","网络制造技术基础",1.5,24,24,null,null,6]
[{"$nulls":3},"0RH01122","先进制造工艺技术",2,32,26,6,null,7]
[{"$nulls":3},"0RH01131","计算机辅助制造",2,32,24,null,8,7]
[{"$nulls":3},"0RL01139","数控编程",1.5,24,24,null,null,7]
[{"$nulls":3},"0RH01124","单片机应用技术",2,32,24,8,null,6,"智能控制类"]
[{"$nulls":3},"0RH01141","传感器及调理电路",1.5,24,20,4,null,6]
[{"$nulls":3},"0RL01103","工业机器人及应用技术",1.5,24,24,null,null,6]
[{"$nulls":3},"0RH01909","机电传动控制",2,32,26,6,null,7]
[{"$nulls":3},"0RH01138","虚拟仪器技术",1.5,24,14,null,10,7]
["附表1：     机械设计制造及其自动化专业课程设置与学分分布表（续2）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["专业教育","选修","实践","0RS01101","专业认知实践",0.5,8,null,8,null,1,null,3]
[{"$nulls":3},"0RS01901","自主创新实践1",1,"1周",{"$nulls":3},7,"见说明1"]
[{"$nulls":3},"0RS01902","自主创新实践2",1,"1周",{"$nulls":3},7,"见说明2"]
[{"$nulls":3},"0RS01106","机器人创新设计及实践",2,"2周",{"$nulls":3},6]
[{"$nulls":3},"0RS01107","数字化制造创新实践",2,"2周",{"$nulls":3},7]
[{"$nulls":3},"0RS01104","设计综合实践",3,"3周",{"$nulls":3},7,null,3]
[{"$nulls":3},"0RS01105","制造综合实践",3,"3周",{"$nulls":3},7]
["毕业总学分",{"$nulls":11},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年级"]
["【说明】1：参加数学、物理、外语等基础类学科竞赛；"]
["【说明】2：参加机械工程领域类、计算机信息类、管理类等学科竞赛；参加大学生科技创新计划项目、大学生科研训练计划深化项目、创新创业类活动等；参加开放实验等实践环节。"]

{"sheet":"附件3.2","index":1,"n_rows":113,"n_cols":11,"rows_kept":113,"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],[13,0,13,10],[14,0,14,1],[14,2,14,10],[15,0,15,10],[26,0,26,10],[27,0,27,1],[27,2,27,10],[28,0,28,10],[40,0,40,10],[41,0,41,1],[41,2,41,10],[42,0,42,10],[43,0,44,0],[43,1,44,1],[43,2,44,2],[43,3,44,3],[43,4,43,6],[43,7,44,7],[43,8,44,8],[43,9,44,9],[43,10,44,10],[45,0,45,10],[55,0,55,10],[56,0,56,1],[56,2,56,10],[57,0,57,10],[69,0,69,10],[70,0,70,1],[70,2,70,10],[71,0,71,10],[87,0,87,10],[88,0,88,1],[88,2,88,10],[89,0,89,10],[90,0,91,0],[90,1,91,1],[90,2,91,2],[90,3,91,3],[90,4,90,6],[90,7,91,7],[90,8,91,8],[90,9,91,9],[90,10,91,10],[92,0,92,10],[107,0,107,10],[108,0,108,1],[108,2,108,10],[109,0,109,10],[111,0,111,10],[112,0,112,1],[112,2,112,10]],"flags":["formulas_cached_only"]}
["附件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,"必修","学科理论","理学院"]
["0BH01146","工科化学",2,32,28,4,null,"必修","学科理论","机电学院"]
["0BL01907","工程制图(1)",3.5,56,56,null,null,"必修","学科理论","机电学院"]
["1BH11001","C语言程序设计B",3,48,32,null,16,"必修","通识理论","计算中心"]
["0BL01115","专业导论",0.5,8,8,null,null,"必修","学科理论","机电学院"]
["0RS01101","专业认知实践",0.5,8,null,8,null,"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修23学分，建议选修2学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第二学期"]
["1BH07002","马克思主义基本原理概论",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10007","大学体育(2)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL08002","大学英语(2)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL09002","高等数学A(2)",5,80,80,null,null,"必修","学科理论","理学院"]
["1BL09007","线性代数A",3,48,48,null,null,"必修","学科理论","理学院"]
["1BL09013","大学物理A(1)",3.5,52,52,null,null,"必修","学科理论","理学院"]
["0BL01908","工程制图(2)",1.5,24,24,null,null,"必修","学科理论","机电学院"]
["1BS12007","金工实习（1）",1,"1周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["1BS09001","物理实验A(1) ",2,30,null,30,null,"必修","学科实践","理学院"]
["0RH01134","计算机绘图",2,32,16,null,16,"选修","专业理论","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修24学分，建议选修2学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第三学期"]
["1BH16002","中国近现代史纲要",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10008","大学体育(3)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL08003","大学英语(3)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL09010","概率论与数理统计B",2,32,32,null,null,"必修","学科理论","理学院"]
["1BL09012","复变函数与积分变换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},"必修","学科实践","机电学院"]
["1BS12008","金工实习(2)",3,"3周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修29.5学分，建议选修2学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["附件2：      机械设计制造及其自动化专业分学期教学计划进程表（续1）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程\n类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第四学期"]
["1BH16003","毛泽东思想和中国特色社会主义理论体系概论",3,48,36,12,null,"必修","通识理论","马院"]
["1BL10009","大学体育(4)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL08004","大学英语(4)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["0BH01303","材料力学",4,64,58,6,null,"必修","学科理论","机电学院"]
["0BH20033","电子技术基础",4,64,48,16,null,"必修","学科理论","信控中心"]
["0BH01903","互换性与技术测量",1.5,24,18,6,null,"必修","学科理论","机电学院"]
["0BH01909","机械原理",4,64,58,6,null,"必修","学科理论","机电学院"]
["0BS01903","机械原理课程设计",1,"1周",{"$nulls":3},"必修","学科实践","机电学院"]
["1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},"必修","通识实践","马院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修24.5学分，建议选修2学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第五学期"]
["0BH01908","工程材料",2,32,26,6,null,"必修","学科理论","机电学院"]
["0BH01312","工程热力学",2,32,28,4,null,"必修","学科理论","机电学院"]
["0BH01910","机械设计",4,64,58,6,null,"必修","学科理论","机电学院"]
["0BH01126","计算机控制技术",2,32,26,6,null,"必修","学科理论","机电学院"]
["0BH01109","机械控制工程",2.5,40,36,4,null,"必修","学科理论","机电学院"]
["0BS01904","机械设计课程设计",3,"3周",{"$nulls":3},"必修","学科实践","机电学院"]
["1BS12005","电工电子实习A",2,"2周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["0RL01133","专业外语",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RH01135","材料成型技术",2,32,30,2,null,"选修","专业理论","机电学院","工程材料先修"]
["0RH01136","有限元分析基础",1.5,24,16,null,8,"选修","专业理论","机电学院"]
["0RH01137","产品建模与仿真",2,32,24,null,8,"选修","专业理论","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修17.5学分，建议选修4-6学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第六学期"]
["0BH01102","智能检测技术",2,32,24,8,null,"必修","专业理论","机电学院"]
["0BH01116","机械制造技术基础",4.5,72,64,8,null,"必修","学科理论","机电学院"]
["0BH01901","液压与气压传动",2.5,40,34,6,null,"必修","专业理论","机电学院"]
["0BS01104","机械制造技术基础课程设计",2.5,"2.5周",{"$nulls":3},"必修","学科实践","机电学院"]
["0BH01105","制造过程信息化与网络化",2,32,24,null,8,"必修","专业理论","机电学院"]
["0BS01106","生产实习",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0RH01101","数控技术",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RH01124","单片机应用技术",2,32,24,8,null,"选修","专业理论","机电学院"]
["0RH01120","优化设计",1.5,24,20,null,4,"选修","专业理论","机电学院"]
["0RH01123","模具CAD/CAM",1.5,24,18,6,null,"选修","专业理论","机电学院"]
["0RL01140","网络制造技术基础",1.5,24,24,null,null,"选修","专业理论","机电学院"]
["0RH01141","传感器及调理电路",1.5,24,20,4,null,"选修","专业理论","机电学院"]
["0RL01103","工业机器人及应用技术",1.5,24,24,null,null,"选修","专业理论","机电学院"]
["0RL01101","绿色制造技术",1.5,24,24,null,null,"选修","专业理论","机电学院"]
["0RS01106","机器人创新设计及实践",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修15.5学分，建议选修6-8学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["附件2：       机械设计制造及其自动化专业分学期教学计划进程表（续2）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程\n类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第七学期"]
["0BH01103","智能制造装备及自动化",2.5,40,34,6,null,"必修","专业理论","机电学院"]
["0RH01119","机械系统设计学",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RH01122","先进制造工艺技术",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RH01118","计算机辅助设计",2,32,26,null,6,"选修","专业理论","机电学院"]
["0RH01130","机械创新设计",2,32,22,10,null,"选修","专业理论","机电学院"]
["0RH01131","计算机辅助制造",2,32,24,null,8,"选修","专业理论","机电学院"]
["0RH01909","机电传动控制",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RH01138","虚拟仪器技术",1.5,24,14,null,10,"选修","专业理论","机电学院"]
["0RL01139","数控编程",1.5,24,24,null,null,"选修","专业理论","机电学院"]
["0RS01901","自主创新实践1",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01902","自主创新实践2",1,"1周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01107","数字化制造创新实践",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01104","设计综合实践",3,"3周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01105","制造综合实践",3,"3周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修2.5学分，建议选修8-12学分（包括通识理论选修课、专业理论选修课、实践选修）"]
["第八学期"]
["0BS01112","毕业实习和设计",8.5,"17周",null,"17周",null,"必修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",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]],"flags":["formulas_cached_only"]}
["附件3：            机械设计制造及其自动化专业学分分配表"]
["教育层次","理论（含课内实践）",null,"实践",null,"小计"]
[null,"必修","选修","必修","选修"]
["通识教育",35,"至少选修8学分",2,"-",45]
["学科基础教育",70.5,"-",18,"-",91]
["专业教育",9,"至少选修12学分",10.5,"至少选修6学分",35]
["第二课堂（素质教育专项）","第二课堂学分不计入学分绩点"]
["小计",114.5,"至少选修20学分",30.5,"至少选修6学分",171]
["总计",134.5,null,36.5,null,171]

{"sheet":"附件3.4","index":3,"n_rows":82,"n_cols":16,"rows_kept":82,"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,17,0],[18,0,44,0],[45,0,45,15],[46,0,47,0],[46,1,47,1],[46,2,47,2],[46,3,47,3],[46,4,46,15],[48,0,81,0]],"flags":["formulas_cached_only"]}
["附件4：         机械设计制造及其自动化专业毕业要求实现矩阵"]
["教育层次","课程名称","学分","课程类别","修读课程可实现毕业要求情况"]
[{"$nulls":4},"毕业要求1","毕业要求2","毕业要求3","毕业要求4","毕业要求5","毕业要求6","毕业要求7","毕业要求8","毕业要求9","毕业要求10","毕业要求11","毕业要求12"]
["通识教育","思想道德修养与法律基础",3,"必修",null,null,"√",null,null,"√",null,"√","√"]
[null,"马克思主义基本原理概论",3,"必修",null,null,"√",null,null,"√",null,"√","√"]
[null,"中国近现代史纲要",3,"必修",null,null,"√",null,null,"√",null,"√","√"]
[null,"毛泽东思想和中国特色社会主义理论体系概论",3,"必修",null,null,"√",null,null,"√",null,"√","√"]
[null,"大学体育(1)-(4)",4,"必修",{"$nulls":8},"√",null,null,"√"]
[null,"大学英语(1)-(4)",16,"必修",{"$nulls":8},"√","√"]
[null,"C语言程序设计B",3,"必修","√",null,"√",null,"√",{"$nulls":4},"√"]
[null,"思想政治理论课综合实践",2,"必修",{"$nulls":7},"√"]
[null,"自然科学与信息技术",2,"选修"]
[null,"经济管理",2,"选修"]
[null,"人文社科",2,"选修"]
[null,"创新创业",2,"选修"]
[null,"艺术与体育",2,"选修"]
[null,"跨文化沟通与交流",2,"选修"]
[null,"卓越工程师素质教育",2,"选修"]
["学科基础教育","专业导论",0.5,"必修",{"$nulls":11},"√"]
[null,"高等数学A(1)(2)",11,"必修","√","√"]
[null,"线性代数B",2,"必修","√","√"]
[null,"概率论与数理统计B",2,"必修","√","√"]
[null,"复变函数与积分变换B",2,"必修","√","√"]
[null,"大学物理A(1)(2)",6.5,"必修","√","√"]
[null,"工科化学",2,"必修",null,null,"√",{"$nulls":3},"√"]
[null,"工程热力学",2,"必修","√","√","√"]
[null,"工程制图(1)(2)",5,"必修","√","√","√"]
[null,"理论力学",4,"必修","√","√","√"]
[null,"材料力学",3,"必修","√","√","√"]
[null,"电工技术基础",4,"必修","√","√","√"]
[null,"电子技术基础",4,"必修","√","√","√"]
[null,"互换性与技术测量",1.5,"必修","√",null,null,"√"]
[null,"工程材料",2,"必修","√"]
[null,"机械原理",4,"必修","√","√","√","√"]
[null,"机械设计",4,"必修","√","√","√","√"]
[null,"计算机控制技术",2,"必修","√",null,"√"]
[null,"机械控制工程",2.5,"必修","√","√","√","√","√"]
[null,"机械制造技术基础",3,"必修","√","√","√","√"]
[null,"物理实验A",3.5,"必修",{"$nulls":3},"√",{"$nulls":5},"√"]
[null,"金工实习(1)(2)",4,"必修",{"$nulls":5},"√","√","√",{"$nulls":3},"√"]
[null,"电工电子实习",2,"必修",null,null,"√","√","√",{"$nulls":4},"√","√","√"]
[null,"制图专用周",2,"必修",null,"√","√",null,"√",{"$nulls":6},"√"]
[null,"机械原理课程设计",1,"必修",null,"√","√",null,"√",{"$nulls":3},"√","√","√"]
[null,"机械设计课程设计",3,"必修",null,"√","√",null,"√",{"$nulls":4},"√","√"]
[null,"机械制造技术基础课程设计",2.5,"必修",null,"√","√",{"$nulls":3},"√",{"$nulls":3},"√"]
["附件4：       机械设计制造及其自动化专业毕业要求实现矩阵（续）"]
["教育层次","课程名称","学分","课程类别","修读课程可实现毕业要求情况"]
[{"$nulls":4},"毕业要求1","毕业要求2","毕业要求3","毕业要求4","毕业要求5","毕业要求6","毕业要求7","毕业要求8","毕业要求9","毕业要求10","毕业要求11","毕业要求12"]
["专业教育","智能检测技术",2,"必修","√","√","√"]
[null,"液压与气压传动",2.5,"必修","√","√","√"]
[null,"智能制造装备及自动化",2.5,"必修","√"]
[null,"制造过程信息化与网络化",2,"必修","√","√","√"]
[null,"生产实习",1,"必修",{"$nulls":5},"√",null,"√"]
[null,"毕业实习和设计",8.5,"必修",null,null,"√","√",null,null,"√","√","√","√",null,"√"]
[null,"数控技术",2,"选修","√","√","√"]
[null,"单片机应用技术",2,"选修","√","√","√"]
[null,"机械系统设计学",2,"选修",null,"√","√","√"]
[null,"先进制造工艺技术",2,"选修","√"]
[null,"优化设计",1.5,"选修","√","√","√"]
[null,"模具CAD/CAM技术",1.5,"选修",{"$nulls":4},"√"]
[null,"计算机辅助设计",2,"选修",null,"√",null,null,"√"]
[null,"机械创新设计",2,"选修",null,null,"√"]
[null,"计算机辅助制造",2,"选修","√"]
[null,"机电传动控制",2,"选修",null,"√"]
[null,"专业外语",2,"选修",{"$nulls":5},"√",{"$nulls":3},"√",null,"√"]
[null,"计算机绘图",2,"选修",{"$nulls":4},"√"]
[null,"材料成型技术",2,"选修","√"]
[null,"有限元分析基础",1.5,"选修","√",null,"√",null,"√"]
[null,"产品建模与仿真",2,"选修",{"$nulls":4},"√"]
[null,"虚拟仪器技术",1.5,"选修",null,"√",null,null,"√"]
[null,"数控编程",1.5,"选修",{"$nulls":4},"√"]
[null,"网络制造技术基础",1.5,"选修","√",{"$nulls":3},"√"]
[null,"传感器及调理电路",1.5,"选修","√","√","√"]
[null,"工业机器人及应用技术",1.5,"选修",null,"√",{"$nulls":3},"√","√"]
[null,"绿色制造技术",1.5,"选修",null,null,"√",{"$nulls":8},"√"]
[null,"专业认知实践",0.5,"选修",{"$nulls":5},"√",{"$nulls":5},"√"]
[null,"自主创新实践1",1,"选修",{"$nulls":8},"√"]
[null,"自主创新实践2",1,"选修",{"$nulls":8},"√"]
[null,"机器人创新设计及实践",2,"选修",{"$nulls":8},"√"]
[null,"数字化制造创新实践",2,"选修",{"$nulls":8},"√"]
[null,"设计综合实践",3,"选修",null,"√",null,"√","√",null,"√",null,"√","√",null,"√"]
[null,"制造综合实践",3,"选修",null,"√",null,"√","√",null,"√",null,"√",null,null,"√"]