{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet2","index":0,"n_rows":50,"n_cols":19,"rows_kept":50,"merged":[[0,0,0,18],[1,0,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,2,18],[3,0,9,1],[3,18,9,18],[8,2,8,8],[10,0,15,1],[10,18,15,18],[11,2,11,17],[12,2,15,9],[12,10,15,17],[16,0,20,1],[16,18,20,18],[21,0,23,1],[21,18,23,18],[24,0,25,1],[24,18,25,18],[26,0,37,0],[26,1,27,1],[26,18,27,18],[27,2,27,17],[28,1,37,1],[28,18,37,18],[38,0,43,1],[38,18,43,18],[45,0,45,1]]}
["2022版车辆工程专业推荐课表"]
["课程\n性质",null,"第1学期",null,"第2学期",null,"第3学期",null,"第4学期",null,"第5学期",null,"第6学期",null,"第7学期",null,"第8学期",null,"合计"]
[null,null,"课程名称","学分","课程名称","学分","课程名称","学分","课程名称","学分","课程名称","学分","课程名称","学分","课程名称","学分","课程名称","学分"]
["通识\n必修",null,"思想道德与法治",2.5,"中国近现代史纲要",2.5,"毛泽东思想和中国特色社会主义理论体系概论",2.5,"马克思主义基本原理",3,"大学生就业与创业指导",1,{"$nulls":6},31]
[null,null,"形势与政策（1）",0,"形势与政策（2）",0,"形势与政策（3）",0,"形势与政策（4）",0,"形势与政策（5）",0,"形势与政策（6）",0,"形势与政策（7）",0,"形势与政策（8）",2]
[null,null,"大学生心理健康教育",2,null,null,"习近平新时代中国特色社会主义思想概论",2.5,"马克思主义理论与实践",2]
[null,null,"大学计算机(程序设计)",2]
[null,null,"大学英语(一)",2,"大学英语(二)",2]
[null,null,"*党史、新中国史、改革开放史、社会主义发展史（任选1门）",{"$nulls":6},1]
[null,null,"体育",1,"体育",1,"体育",1,"体育",1]
["通识\n选修",null,"创业基础",2,"中华民族共同体概论",1,"中文写作实训",0.5,{"$nulls":10},10]
[null,null,"逻辑与批判性思维训练（1学分，每学期均开设）"]
[null,null,"      模块1：创业基础，2学分：\n      模块2：领军人才素质教育；\n      模块3：中国东盟历史文化与社会发展；\n      模块4：海洋知识与可持续发展；\n      模块5：广西少数民族文化与现代发展\n      模块6：公共艺术课程模块",{"$nulls":7},"注：领军、创新创业模块至少应各修1门课程，公共艺术课程模块至少修读2学分，其余东盟、民族、海洋模块至少选择其中2个模块修读，理工农医类学生修读人文社科类课程不少于2学分，文科类学生修读自然科学类课程不少于2学分。《创业基础》《中文写作实训》《逻辑与批判性思维》《中华民族共同体概论》及公共艺术课程模块为每生必修。其中《创业基础》属于创业模块，《中文写作实训》《逻辑与批判性思维训练》属于领军模块，《中华民族共同体概论》属于民族模块。线下课程修读学分须≥5学分。 "]
[]
[]
[]
["学门\n核心",null,"高等数学A（上）",5,"高等数学A（下）",5,"概率论与数理统计（理）",{"v":3,"d":"3.0"},"计算方法",2,{"$nulls":8},27.5]
[{"$nulls":4},"线性代数",2.5,"大学物理I(下)",{"v":2,"d":"2.0"}]
[{"$nulls":4},"大学物理I(上)",4]
[{"$nulls":4},"大学物理实验",2]
[{"$nulls":4},"普通化学",2]
["学类\n核心",null,"机械制图（一）",3.5,"机械制图（二）",2.5,"理论力学",4,"材料力学",3.5,"机械设计",3,{"$nulls":6},{"$f":"SUM(D22:D24)+SUM(F22:F24)+SUM(H22:H24)+SUM(J22:J24)+SUM(L22:L24)+SUM(N22:N24)+SUM(P22:P24)","v":26}]
[{"$nulls":6},"材料科学与工程基础",2.5,"电工电子学",{"v":4,"d":"4.0"}]
[{"$nulls":8},"机械原理",{"v":3,"d":"3.0"}]
["专业\n核心",{"$nulls":7},"汽车构造",{"v":3,"d":"3.0"},"汽车理论",3,"汽车设计",3,{"$nulls":4},{"$f":"SUM(D25:D26)+SUM(F25:F26)+SUM(H25:H26)+SUM(J25:J26)+SUM(L25:L26)+SUM(N25:N26)+SUM(P25:P26)","v":{"v":14,"d":"14.0"}}]
[{"$nulls":10},"汽车电子技术",2,"汽车制造工艺学",3]
["专业选修","英语选修模块",{"$nulls":4},"大学英语（三）或高级英语（一）",2,"大学英语（四）或高级英语（二）",2,{"$nulls":8},0]
[null,null,"若未达免修条件，则需继续修读大学英语（三）或高级英语（一）、大学英语（四）或高级英语（二）"]
[null,"专业选修模块","※车辆工程专业导论",1,{"$nulls":4},"※传热学和流体力学",2,"※控制工程基础",2,"汽车振动与噪声",2,"智能汽车与自动驾驶",2,null,null,22]
[{"$nulls":8},"※互换性与技术测量",2,"※工程管理与技术经济学",1,"车辆有限元方法",2,"汽车优化设计",2]
[{"$nulls":10},"※汽车试验学",2,"汽车仿真分析",2,"汽车车身结构与设计",1]
[{"$nulls":10},"汽车液压传动",2,"新能源汽车技术",2,"汽车节能与环境保护技术",1]
[{"$nulls":14},"传感器与诊断技术",2]
[{"$nulls":14},"车用动力电池技术",1]
[{"$nulls":14},"专业英语",1]
[{"$nulls":14},"汽车人机工程学",2]
[{"$nulls":14},"汽车智能控制技术",1]
[{"$nulls":14},"汽车文化",1]
["集中\n实践\n必修",null,"安全教育与军事训练",0,"工程训练",2,null,null,"机械原理课程设计",1,"机械设计课程设计",2,"文献检索",0.5,"创新创业实践",2,"毕业设计(论文)",10,{"$f":"SUM(R39:R44,P39:P44,N39:N44,L39:L44,J39:J44,F39:F44,D39:D44,H39:H44)","v":31.5}]
[{"$nulls":8},"汽车拆装实习",2,"导师制课程",2,"专业实习",1,"汽车制造工艺学课程设计",2]
[{"$nulls":10},"劳动",0,"汽车设计实习",1,"普通话测试 ",0]
[{"$nulls":12},"汽车设计课程设计",2]
[{"$nulls":12},"车辆工程综合实验",3]
[{"$nulls":12},"汽车制造工艺学实习",1]
[{"$nulls":3},{"$f":"SUM(D39:D44,D29:D38,D25:D26,D22:D24,D17:D21,D10:D11,D4:D8)+1+2","v":24},null,{"$f":"SUM(F39:F44,F29:F38,F22:F24,F17:F21,F4:F8)+1","v":25.5},null,{"$f":"SUM(H39:H44,H22:H24,H17:H21,H4:H8)+4+1","v":21.5},null,{"$f":"SUM(J39:J44,J29:J38,J25:J26,J22:J24,J17:J21,J4:J10)-1","v":28.5},null,{"$f":"SUM(L39:L44,L29:L31,L25:L26,L22:L24,L4:L10)+2","v":20},null,{"$f":"SUM(N39:N44,N25:N26,)+6","v":20.5},null,{"$f":"SUM(P39:P44)+6","v":10},null,{"$f":"SUM(R39:R44,R4:R10)","v":12},{"$f":"SUM(D45:R45)","v":162}]
["备注："]
[null,null,"1. 除了带※号限制选修课外，其他选修课的开课情况由各专业决定"]
[null,null,"2. 表中列课程的开课时间为正修开课时间"]
[null,null,"3.导师制课程：第5学期开设，第7学期给成绩"]
[null,null,"4.第2学期结束时通识选修课至少要修够2学分，第4学期结束时通识选修课至少要修够4学分，第6学期结束时通识选修课至少要修够6学分"]