{"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":96,"n_cols":13,"rows_kept":96,"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,36,0],[18,1,36,1],[18,2,31,2],[18,12,31,12],[32,2,36,2],[32,12,36,12],[37,0,37,12],[38,0,39,0],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[38,5,39,5],[38,6,38,9],[38,10,39,10],[38,11,39,11],[38,12,39,12],[40,0,75,0],[40,1,58,1],[40,2,50,2],[40,12,50,12],[51,2,58,2],[51,12,58,12],[59,1,75,1],[59,2,75,2],[59,12,75,12],[76,0,76,12],[77,0,78,0],[77,1,78,1],[77,2,78,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,77,9],[77,10,78,10],[77,11,78,11],[77,12,78,12],[79,0,85,0],[79,1,85,1],[79,2,85,2],[79,12,85,12],[86,0,86,11],[87,0,95,0],[87,1,95,1],[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,2,95,4],[95,5,95,6],[95,7,95,9],[95,10,95,12]]}
["附表1：                工业工程专业课程设置与学分分布表"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\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},"1BH11006","VB程序设计",3,48,32,null,16,1]
[null,null,"实践环节","1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},4,null,2]
[null,"选修","理论（含课内实践）","第一模块","自然科学与信息技术",{"$nulls":5},"1--7",null,"至\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:F32)","v":46.5}]
[{"$nulls":3},"1BL09008","线性代数B",2,32,32,null,null,2]
[{"$nulls":3},"1BL09010","概率论与数理统计B",2,32,32,null,null,3]
[{"$nulls":3},"1BL09015","大学物理B",4,64,64,null,null,2]
[{"$nulls":3},"0BH20034","电工电子技术",3.5,56,44,12,null,3]
[{"$nulls":3},"0BL01001","工程制图",4,64,56,null,8,1]
[{"$nulls":3},"0BH01903","互换性与技术测量",1.5,24,18,6,null,4]
[{"$nulls":3},"0BH01414","机械设计基础",3.5,56,50,6,null,4]
[{"$nulls":3},"0BH01510","机械制造技术基础",3,48,42,6,null,5]
[{"$nulls":3},"0BH01904","工程力学",3.5,56,52,4,null,3]
[{"$nulls":3},"0BL05006","管理学",3,48,48,null,null,5]
[{"$nulls":3},"0BL05020","经济学",3,48,48,null,null,5]
[{"$nulls":3},"0BL06001","管理信息系统",2,32,32,null,null,5]
[{"$nulls":3},"0BL01201","工业工程导论",0.5,8,8,null,null,1]
[null,null,"实践环节","1BS09003","物理实验B",2,32,null,32,null,2,null,{"$f":"SUM(F33:F37)","v":9}]
[{"$nulls":3},"1BS12002","金工实习",2,"2周",{"$nulls":3},1]
[{"$nulls":3},"1BS12006","电工电子实习B",1,"1周",{"$nulls":3},3]
[{"$nulls":3},"0BS01217","机械设计基础课程设计",2,"2周",{"$nulls":3},4]
[{"$nulls":3},"0BS01213","管理信息系统课程设计",2,"2周",{"$nulls":3},5]
["附表1：                工业工程专业课程设置与学分分布表（续1）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["专业教育","必修","理论环节","0BH01209","管理统计学",3,48,40,null,8,4,null,{"$f":"SUM(F41:F51)","v":29}]
[{"$nulls":3},"0BH01201","运筹学",3,48,40,null,8,3]
[{"$nulls":3},"0BL01233","工程经济学",2,32,32,null,null,6]
[{"$nulls":3},"0BL01202","系统工程",3,48,44,4,null,3]
[{"$nulls":3},"0BL01223","系统仿真",2.5,40,16,null,24,6]
[{"$nulls":3},"0BH01211","工业工程基础",3,48,40,8,null,2]
[{"$nulls":3},"0BH01214","人因工程",3,48,38,10,null,4]
[{"$nulls":3},"0BH01218","物流工程",3,48,44,4,null,5]
[{"$nulls":3},"0BL01230","生产管理",3,48,48,null,null,6]
[{"$nulls":3},"0BH01219","质量管理",3,48,40,8,null,5]
[{"$nulls":3},"0BL01302","文献检索与论文写作",0.5,8,8,null,null,7]
[null,null,"实践环节","0BS01202","系统仿真综合实践",2,"2周",{"$nulls":3},6,null,{"$f":"SUM(F52:F59)","v":22.5}]
[{"$nulls":3},"0BS01218","生产/服务系统优化综合实践",2,"2周",{"$nulls":3},7]
[{"$nulls":3},"0BS01215","工作研究与生产线平衡综合实验",2,"2周",{"$nulls":3},6]
[{"$nulls":3},"0BS01210","人因工程课程设计",2,"2周",{"$nulls":3},5]
[{"$nulls":3},"0BS01211","ERP沙盘综合实验",2,"2周",{"$nulls":3},7]
[{"$nulls":3},"0BS01219","企业设施规划综合课程设计",2,"2周",{"$nulls":3},6]
[{"$nulls":3},"0BS01216","毕业设计",8.5,"17周",{"$nulls":3},8]
[{"$nulls":3},"0BS01205","专业实习",2,"2周",{"$nulls":3},6]
[null,"选修","理论（含课内实践）","0BH01908","工程材料",2,32,26,6,null,3,null,"至\n少\n选\n修\n12\n学\n分"]
[{"$nulls":3},"0RL05005","会计基础",2,32,32,null,null,5]
[{"$nulls":3},"0RH01232","数字建模（Pro/Engineer)",2,32,16,null,16,4]
[{"$nulls":3},"0RL01225","安全工程",2,32,32,null,null,5]
[{"$nulls":3},"0RH01201","人机工程仿真（Jack）",2,32,16,null,16,6]
[{"$nulls":3},"0RL01221","工业设计",2,32,32,null,null,6]
[{"$nulls":3},"0RL01201","项目管理",2,32,24,8,null,6]
[{"$nulls":3},"0RH01224","数据库技术",2,32,16,null,16,4]
[{"$nulls":3},"0RH01220","程序设计专题",2,32,16,null,16,6]
[{"$nulls":3},"0RL01401","专业英语",2,32,32,null,null,7]
[{"$nulls":3},"0RL01202","创新思维",2,32,32,null,null,3]
[{"$nulls":3},"0RL01203","企业管理案例分析",2,32,32,null,null,7]
[{"$nulls":3},"0RL05013","人力资源管理",1.5,24,24,null,null,7]
[{"$nulls":3},"0RL05030","市场营销",1.5,24,24,null,null,7]
[{"$nulls":3},"0RH01203","智能算法与应用",2,32,32,null,null,6]
[{"$nulls":3},"0RL01208","工程心理学",2,32,32,null,null,6]
[{"$nulls":3},"0RL01207","精益生产",2,32,32,null,null,6]
["附表1：                工业工程专业课程设置与学分分布表（续2）"]
["教育层次","课程类别","课程性质","课程编码","课程名称","学分","学时数",{"$nulls":3},"修课\n学期","备注","学分\n要求"]
[{"$nulls":6},"总学时","理论","实验/实践","上机"]
["专业教育","选修","实践环节","0RS01203","ERP软件综合实验",2,"2周",{"$nulls":3},7,null,"至\n少\n选\n修\n6\n学\n分"]
[{"$nulls":3},"0RS01205","信息系统开发综合实践",2,"2周",{"$nulls":3},7]
[{"$nulls":3},"0RS01202","管理统计学课程设计",2,"2周",{"$nulls":3},4]
[{"$nulls":3},"0RS01206","系统工程课程设计",2,"2周",{"$nulls":3},3]
[{"$nulls":3},"0RS01207","运筹学课程设计",2,"2周",{"$nulls":3},3]
[{"$nulls":3},"0RS01208","质量管理课程设计",2,"2周",{"$nulls":3},5]
[{"$nulls":3},"0RS01406","自主创新创业实践",2,"2周",{"$nulls":3},7,"参考培养方案 （八.对培养方案的必要说明）"]
["毕业总学分",{"$nulls":11},{"$f":"SUM(M4,M11,M19,M33,M41,M52)+8+12+6","v":170}]
["第二课堂","必修","教育环节",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":109,"n_cols":11,"rows_kept":109,"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],[23,0,23,10],[24,0,24,1],[24,2,24,10],[25,0,25,10],[39,0,39,10],[40,0,40,1],[40,2,40,10],[41,0,41,10],[42,0,43,0],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,42,6],[42,7,43,7],[42,8,43,8],[42,9,43,9],[42,10,43,10],[44,0,44,10],[57,0,57,10],[58,0,58,1],[58,2,58,10],[59,0,59,10],[71,0,71,10],[72,0,72,1],[72,2,72,10],[73,0,73,10],[81,0,81,10],[82,0,83,0],[82,1,83,1],[82,2,83,2],[82,3,83,3],[82,4,82,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[91,0,91,10],[92,0,92,1],[92,2,92,10],[93,0,93,10],[104,0,104,10],[105,0,105,1],[105,2,105,10],[106,0,106,10],[108,0,108,1],[108,2,108,10]]}
["附表2：              工业工程专业分学期教学计划进程表"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第一学期"]
["1BH07001","思想道德修养与法律基础",3,48,36,12,null,"必修","通识理论","马院"]
["1BL08001","大学英语(1)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL10006","大学体育(1)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL09001","高等数学A(1)",6,96,96,null,null,"必修","学科理论","理学院"]
["0BL01001","工程制图",4,64,56,null,8,"必修","学科理论","机电学院"]
["0BL01201","工业工程导论",0.5,8,8,null,null,"必修","学科理论","机电学院"]
["1BH11006","VB程序设计",3,48,32,null,16,"必修","通识理论","计算中心"]
["1BS12002","金工实习",2,"2周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修23.5学分，建议至少选修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,"必修","学科理论","理学院"]
["1BL09008","线性代数B",2,32,32,null,null,"必修","学科理论","理学院"]
["1BL09015","大学物理B",4,64,64,null,null,"必修","学科理论","理学院"]
["1BS09003","物理实验B",2,32,null,32,null,"必修","学科实践","理学院"]
["0BH01211","工业工程基础",3,48,40,8,null,"必修","专业理论","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修24学分，建议至少选修2学分（包括通识理论选修、专业理论选修、实践选修）"]
["第三学期"]
["1BH16002","中国近现代史纲要",3,48,36,12,null,"必修","通识理论","马院"]
["1BL08003","大学英语(3)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL10008","大学体育(3)",1,32,32,null,null,"必修","通识理论","体育部"]
["1BL09010","概率论与数理统计B",2,32,32,null,null,"必修","学科理论","理学院"]
["0BH20034","电工电子技术",3.5,56,44,12,null,"必修","学科理论","信控中心"]
["1BS12006","电工电子实习B",1,"1周",{"$nulls":3},"必修","学科实践","机电实习中心"]
["0BH01904","工程力学",3.5,56,52,4,null,"必修","学科理论","机电学院"]
["0BH01201","运筹学",3,48,40,null,8,"必修","专业理论","机电学院"]
["0BL01202","系统工程",3,48,44,4,null,"必修","专业理论","机电学院"]
["0BH01908","工程材料",2,32,26,6,null,"选修","专业理论","机电学院"]
["0RL01202","创新思维",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RS01207","运筹学课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01206","系统工程课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修24学分，建议至少选修2学分（包括通识理论选修、专业理论选修、实践选修）"]
["附表2              工业工程专业分学期教学计划进程表（续1）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["第四学期"]
["1BH16003","毛泽东思想和中国特色社会主义理论体系概论",3,48,36,12,null,"必修","通识理论","马院"]
["1BL08004","大学英语(4)",4,64,56,8,null,"必修","通识理论","外国语学院"]
["1BL10009","大学体育(4)",1,32,32,null,null,"必修","通识理论","体育部"]
["0BH01903","互换性与技术测量",1.5,24,18,6,null,"必修","学科理论","机电学院"]
["0BH01414","机械设计基础",3.5,56,50,6,null,"必修","学科理论","机电学院"]
["0BS01217","机械设计基础课程设计",2,"2周",{"$nulls":3},"必修","学科实践","机电学院"]
["0BH01209","管理统计学",3,48,40,null,8,"必修","专业理论","机电学院"]
["1BS07002","思想政治理论课综合实践",2,"2周",{"$nulls":3},"必修","通识实践","马院"]
["0BH01214","人因工程",3,48,38,10,null,"必修","专业理论","机电学院"]
["0RH01224","数据库技术",2,32,16,null,16,"选修","专业理论","机电学院"]
["0RH01232","数字建模（Pro/Engineer)",2,32,16,null,16,"选修","专业理论","机电学院"]
["0RS01202","管理统计学课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修23学分，建议至少选修2学分（包括通识理论选修、专业理论选修、实践选修）"]
["第五学期"]
["0BS01210","人因工程课程设计",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0BL05006","管理学",3,48,48,null,null,"必修","学科理论","经管学院"]
["0BL05020","经济学",3,48,48,null,null,"必修","学科理论","经管学院"]
["0BH01510","机械制造技术基础",3,48,42,6,null,"必修","学科理论","机电学院"]
["0BL06001","管理信息系统",2,32,32,null,null,"必修","学科理论","机电学院"]
["0BS01213","管理信息系统课程设计",2,"2周",{"$nulls":3},"必修","学科实践","机电学院"]
["0BH01219","质量管理",3,48,40,8,null,"必修","专业理论","机电学院"]
["0BH01218","物流工程",3,48,44,4,null,"必修","专业理论","机电学院"]
["0RL01225","安全工程",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RL05005","会计基础",2,32,32,null,null,"选修","专业理论","经管学院"]
["0RS01208","质量管理课程设计",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修21学分，建议至少选修4学分（包括通识理论选修、专业理论选修、实践选修）"]
["第六学期"]
["0BL01223","系统仿真",2.5,40,16,null,24,"必修","专业理论","机电学院"]
["0BL01230","生产管理",3,48,48,null,null,"必修","专业理论","机电学院"]
["0BL01233","工程经济学",2,32,32,null,null,"必修","专业理论","机电学院"]
["0BS01202","系统仿真综合实践",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0BS01205","专业实习",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0BS01219","企业设施规划综合课程设计",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0BS01215","工作研究与生产线平衡综合实验",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["附表2              工业工程专业分学期教学计划进程表（续2）"]
["课程编码","课程名称","学分","总学时","学时分配",null,null,"课程类别","课程性质","开课单位","备注"]
[{"$nulls":4},"理论","实验/实践","上机"]
["0RL01201","项目管理",2,32,24,8,null,"选修","专业理论","机电学院"]
["0RH01201","人机工程仿真（Jack）",2,32,16,null,16,"选修","专业理论","机电学院"]
["0RH01220","程序设计专题",2,32,16,null,16,"选修","专业理论","机电学院"]
["0RL01207","精益生产",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RH01203","智能算法与应用",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RL01208","工程心理学",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RL01221","工业设计",2,32,32,null,null,"选修","专业理论","机电学院"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修15.5学分，建议至少选修8学分（包括通识理论选修、专业理论选修、实践选修）"]
["第七学期"]
["0BL01302","文献检索与论文写作",0.5,8,8,null,null,"必修","专业理论","机电学院"]
["0BS01218","生产/服务系统优化综合实践",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0BS01211","ERP沙盘综合实验",2,"2周",{"$nulls":3},"必修","专业实践","机电学院"]
["0RL05030","市场营销",1.5,24,24,null,null,"选修","专业理论","经管学院"]
["0RL05013","人力资源管理",1.5,24,24,null,null,"选修","专业理论","经管学院"]
["0RL01401","专业英语",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RL01203","企业管理案例分析",2,32,32,null,null,"选修","专业理论","机电学院"]
["0RS01205","信息系统开发综合实践",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01203","ERP软件综合实验",2,"2周",{"$nulls":3},"选修","专业实践","机电学院"]
["0RS01406","自主创新创业实践",2,"2周",{"$nulls":3},"选修","专业实践","机电学院","参考培养方案 （八.对培养方案的必要说明）"]
["完成相应的第二课堂素质教育要求"]
["学分小计",null,"必修4.5学分，建议至少选修6学分（包括通识理论选修、专业理论选修、实践选修）"]
["第八学期"]
["0BS01216","毕业设计",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":"35+8+2+0","v":45}]
["学科基础教育",46.5,"-",9,"-",{"$f":"46.5+0+9+0","v":55.5}]
["专业教育",29,"至少选修12学分",22.5,"至少选修6学分",{"$f":"29+12+22.5+6","v":69.5}]
["第二课堂\n（素质教育专项）","第二课堂学分不计入学分绩点"]
["小计",{"$f":"SUM(B4:B6)","v":110.5},"至少选修20学分",{"$f":"SUM(D4:D6)","v":33.5},"至少选修6学分",170]
["总计",130.5,null,39.5,null,{"$f":"SUM(B9:E9)","v":170}]

{"sheet":"附件3.4","index":3,"n_rows":76,"n_cols":16,"rows_kept":76,"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,10,0],[11,0,29,0],[30,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,51,0],[52,0,75,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,"中国近现代史纲要",3,"必修",{"$nulls":5},"√"]
[null,"毛泽东思想和中国特色社会主义理论体系概论",3,"必修",{"$nulls":5},"√"]
[null,"大学体育(1)-(4)",4,"必修",{"$nulls":11},"√"]
[null,"大学英语(1)-(4)",16,"必修",{"$nulls":9},"√",null,"√"]
[null,"VB程序设计",3,"必修",{"$nulls":4},"√"]
[null,"思想政治理论课综合实践",2,"必修",{"$nulls":7},"√","√","√"]
["学科基础教育","高等数学A(1)(2)",11,"必修","√"]
[null,"线性代数B",2,"必修","√"]
[null,"概率论与数理统计B",2,"必修","√"]
[null,"大学物理B",4,"必修","√"]
[null,"电工电子技术",3.5,"必修","√"]
[null,"工程制图",4,"必修","√",{"$nulls":3},"√"]
[null,"互换性与技术测量",1.5,"必修","√"]
[null,"机械设计基础",3.5,"必修","√"]
[null,"机械制造技术基础",3,"必修","√",{"$nulls":5},"√"]
[null,"工程力学",3.5,"必修","√"]
[null,"管理学",3,"必修","√"]
[null,"经济学",3,"必修","√"]
[null,"管理信息系统",2,"必修","√"]
[null,"工业工程导论",0.5,"必修","√",{"$nulls":6},"√"]
[null,"物理实验B",2,"必修",null,"√","√","√"]
[null,"金工实习",2,"必修",null,null,"√","√"]
[null,"电工电子实习B",1,"必修",null,"√","√","√",{"$nulls":4},"√"]
[null,"机械设计基础课程设计",2,"必修",null,"√","√","√",{"$nulls":4},"√"]
[null,"管理信息系统课程设计",2,"必修",null,"√","√","√",{"$nulls":4},"√"]
["专业教育（必修）","管理统计学",3,"必修","√"]
[null,"运筹学",3,"必修","√"]
[null,"工程经济学",2,"必修","√"]
[null,"系统工程",3,"必修","√"]
[null,"系统仿真",2.5,"必修","√",{"$nulls":3},"√"]
[null,"工业工程基础",3,"必修","√",{"$nulls":4},"√","√"]
[null,"人因工程",3,"必修","√",{"$nulls":4},"√","√"]
[null,"物流工程",3,"必修","√"]
[null,"生产管理",3,"必修","√",{"$nulls":4},"√","√"]
[null,"质量管理",3,"必修","√"]
["附表4：                  工业工程专业毕业要求实现矩阵（续）"]
["教育层次","课程名称","学分","课程性质","修读课程可实现毕业要求情况"]
[{"$nulls":4},"毕业要求1","毕业要求2","毕业要求3","毕业要求4","毕业要求5","毕业要求6","毕业要求7","毕业要求8","毕业要求9","毕业要求10","毕业要求11","毕业要求12"]
["专业教育（必修）","文献检索与论文写作",0.5,"必修",{"$nulls":4},"√",{"$nulls":4},"√"]
[null,"生产/服务系统优化综合实践",2,"必修",null,"√","√","√",{"$nulls":4},"√","√","√"]
[null,"排队系统建模与仿真综合实践",2,"必修",null,"√","√","√",{"$nulls":4},"√","√","√"]
[null,"工作研究与生产线平衡综合实验",2,"必修",null,"√","√","√",{"$nulls":4},"√","√","√"]
[null,"人因工程综合课程设计",2,"必修",null,"√","√","√",{"$nulls":4},"√"]
[null,"ERP沙盘综合实验",2,"必修",null,"√","√","√",{"$nulls":4},"√","√","√"]
[null,"企业设施规划综合课程设计",2,"必修",null,"√","√","√",{"$nulls":4},"√"]
[null,"毕业设计",8.5,"必修",null,"√","√","√",{"$nulls":4},"√","√",null,"√"]
[null,"专业实习",2,"必修",null,"√",{"$nulls":5},"√","√","√"]
["专业教育（选修）","工程材料",2,"选修","√"]
[null,"会计基础",2,"选修",null,null,"√",null,null,"√"]
[null,"数字建模（Pro/Engineer)",2,"选修",{"$nulls":4},"√"]
[null,"安全工程",2,"选修","√",{"$nulls":3},"√","√","√"]
[null,"人机工程仿真（Jack）",2,"选修",null,null,"√"]
[null,"工业设计",2,"选修",null,null,"√",{"$nulls":4},"√"]
[null,"项目管理",2,"选修",null,null,"√",{"$nulls":4},"√",null,null,"√"]
[null,"数据库技术",2,"选修",{"$nulls":4},"√"]
[null,"程序设计专题",2,"选修",{"$nulls":3},"√"]
[null,"专业英语",2,"选修",{"$nulls":4},"√",{"$nulls":4},"√",null,"√"]
[null,"创新思维",2,"选修",null,null,"√",null,null,"√",{"$nulls":5},"√"]
[null,"企业管理案例分析",2,"选修",null,"√",{"$nulls":9},"√"]
[null,"人力资源管理",1.5,"选修",{"$nulls":6},"√"]
[null,"市场营销",1.5,"选修",null,null,"√",{"$nulls":5},"√","√"]
[null,"智能算法与应用",2,"选修",{"$nulls":3},"√"]
[null,"工程心理学",2,"选修",{"$nulls":5},"√","√","√","√","√","√"]
[null,"精益生产",2,"选修",{"$nulls":4},"√",null,"√","√"]
[null,"ERP软件综合实验",2,"选修",{"$nulls":4},"√",{"$nulls":3},"√","√",null,"√"]
[null,"信息系统开发综合实践",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]
[null,"管理统计学课程设计",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]
[null,"系统工程课程设计",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]
[null,"运筹学课程设计",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]
[null,"质量管理课程设计",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]
[null,"自主创新创业实践",2,"选修",null,"√",null,"√",{"$nulls":4},"√","√",null,"√"]