{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["教学计划进程","实践周","专业教育选修课"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"教学计划进程","index":0,"n_rows":40,"n_cols":18,"rows_kept":40,"merged":[[0,1,0,14],[0,15,0,17],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,1,17],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,2,19,4],[20,2,20,4],[21,4,24,4],[25,3,25,4],[26,3,26,4],[27,2,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,0,39,4]],"flags":["formulas_cached_only"]}
["表1                      ","车辆工程专业指导性教学计划进程"]
["课\n程\n类\n别","课\n程\n性\n质","课\n程\n代\n码","课\n程\n名\n称",null,"学\n分","总\n学\n时","讲\n课\n学\n时","实\n验\n学\n时","上机学时","各学期平均周学时分配"]
[{"$nulls":10},1,2,3,4,5,6,7,8]
["基础教育","必修课","09000375 09000376 09000377 09000378","大学英语Ⅰ、Ⅱ（普通班，G）\n\n大学英语口语Ⅰ、Ⅱ（普通班，G）\n",null,12,192,192,null,null,6,6]
["基础教育","必修课","12000025","计算机基础A",null,3,48,24,null,24,3]
["基础教育","必修课","12000075","C语言程序设计A",null,3,48,32,null,16,null,3]
["基础教育","必修课","07000149  07000150","微积分A（Ⅰ、Ⅱ）",null,11,176,176,null,null,6,5]
["基础教育","必修课","07000176","线性代数",null,3,48,48,{"$nulls":4},3]
["基础教育","必修课","07000051","概率与数理统计",null,3,48,48,{"$nulls":5},3]
["基础教育","必修课","07000032  07000033","大学物理（Ⅰ、Ⅱ）",null,8,128,128,{"$nulls":3},4,4]
["基础教育","必修课","07000169  07000170","物理实验B（Ⅰ、Ⅱ）",null,3,48,4,44,null,"",null,1.5,1.5]
["基础教育","必修课","07000027","大学化学C",null,2,32,32,{"$nulls":4},2]
["基础教育","必修课","09000417","思想道德修养与法律基础",null,2,32,32,null,null,2]
[null,"必修课","09000488","知识产权法基础",null,1,16,16,null,null,1]
["基础教育","必修课","09000489","毛泽东思想、邓小平理论及“三个代表”重要思想",null,4,64,48,16,null,null,4]
["基础教育","必修课","09000008","大学生心理素质发展",null,1,16,16,{"$nulls":3},1]
["基础教育","必修课","09000191","马克思主义基本原理",null,3,48,48,{"$nulls":4},3]
["基础教育","必修课","09000490","中国近现代史纲要",null,3,48,32,16,{"$nulls":4},3]
["基础教育","必修课","99000001  99000002  99000003  99000004","体育（I～Ⅳ）",null,4,128,128,null,null,2,2,2,2]
["基础教育","选修课","专项英语",null,null,4,64,64,{"$nulls":4},2,2]
["基础教育","选修课","通识教育选修课",null,null,8,128,null,128,{"$nulls":3},2,2,2,2]
["学科基础教育","必修课","03000145   03000146","机械制图（Ⅰ、Ⅱ）","机械设计基础课群（Ⅰ）",6.5,104,104,null,null,3.5,3]
["学科基础教育","必修课","03000154","几何规范学",null,2,32,26,6,{"$nulls":4},2]
["学科基础教育","必修课","03000143","机械原理",null,3.5,56,50,6,{"$nulls":5},3.5]
["学科基础教育","必修课","03000137","机械设计",null,4.5,72,66,6,{"$nulls":6},4.5]
["学科基础教育","必修课","07000060  07000061","工程力学A（Ⅰ、Ⅱ）",null,9,144,144,{"$nulls":4},4.5,4.5]
["学科基础教育","必修课","01200009  01200010","电工和电子技术A（Ⅰ、Ⅱ）",null,7,112,80,32,{"$nulls":4},3.5,3.5]
["学科基础教育","必修课","实验选修课",null,null,4,64,null,64,{"$nulls":5},2,2]
["专业教育","必修课","04000043","工程材料基础",null,2,32,26,6,{"$nulls":4},2]
["学科基础教育","必修课","03000182","流体力学B",null,2,32,28,4,{"$nulls":5},2]
["专业教育","必修课","03000144","机械振动",null,3,48,44,4,{"$nulls":5},3]
["专业教育","必修课","03000323","汽车构造",null,2,32,32,{"$nulls":6},2]
["专业教育","必修课","03110324","拆装与驾驶实习",null,3,48,null,48,{"$nulls":6},3]
["专业教育","必修课","03000083","车用内燃机",null,3,48,44,4,{"$nulls":6},3]
["专业教育","必修课","03000200\n03000201","汽车学（Ⅰ、Ⅱ）",null,7,112,104,8,{"$nulls":6},3,4]
["专业教育","必修课","03000325","汽车车身结构与设计",null,2,32,28,4,{"$nulls":6},2]
["专业教育","必修课","03000326","现代车辆试验技术",null,2,32,24,8,{"$nulls":7},2]
["专业教育","必修课","03110327","毕业设计（论文）",null,16,256,null,256,{"$nulls":8},16]
["专业教育","选修课",null,"专业教育选修课",null,18.5,296,296,null,null,1,{"$nulls":3},3,5.5,9]
["总计",{"$nulls":4},175,2864,2164,660,40,24.5,28,24,25.5,21,25,15,16]

{"sheet":"实践周","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[0,1,0,4],[0,5,0,7],[11,0,11,2]],"flags":["formulas_cached_only"]}
["表2","实习周教学计划进程"]
["编号","项   目","内   容","学分","学期","周数","周次","场所"]
["09000211","人文社会实践","社会调查、研讨",1,2,1,19,"校内外"]
[98000001,"军事理论","军事理论教学",1,"2",2,"20,21","校内外"]
[98000002,"军事训练","军事实践训练",1.5,"3",3,"暑假","校内外"]
["03000133","机械CAD（Ⅰ）","计算机辅助绘图",1,4,1,19,"本院"]
["01200251","电子实习","典型电子产品装调工艺",1,4,1,20,"校内"]
["03000043","文献检索","专业文献检索方法",1,4,1,21,"校内"]
["03000322","制造技术基础训练","机械制造、材料成型工艺训练、机械加工工艺训练、现代加工技术及特种加工训练、综合实验及创新训练等",4,5,4,"1-3                1周分散","工程训练中心"]
["03000139","机械设计课群(I)综合设计","机械功能设计、运动分析、结构设计等综合训练",4,6,4,"19-21","本院"]
["03110348","生产实习","生产实习（第一周工艺课）",4,7,4,"1-4","校外"]
["合计",null,null,18.5]

{"sheet":"专业教育选修课","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"merged":[[0,1,0,7]],"flags":["formulas_cached_only"]}
["表3","专业教育选修课"]
["课程编号","课程名称","学分","学时","学期","课程编号","课程名称","学分","学时","学期"]
["03000310  03000311","车辆工程系列讲座（Ⅰ、Ⅱ）","1\n1","16\n16","1,7","03000079","车辆悬架技术",2,32,6]
["03000204","热工基础",2,32,5,"03000080","车辆制动技术",1.5,24,7]
["03000136","机械加工基础",2,32,5,"03000202","汽车运用工程",1.5,24,7]
["03000329","热加工基础",2,32,5,"03000076","车辆检测与维修",1.5,24,7]
["03000247","现代设计方法",2,32,5,"03000073","车辆仿真技术",1.5,24,7]
["03000270","自动控制理论基础B",2,32,6,"03000228","微小型军用机器人技术",1.5,24,7]
["03000090","单片机原理与应用",2,32,6,"03000070","车辆电传动",1.5,24,7]
["03000078","车辆人机工程学",1.5,24,6,"03000069","车辆传动",1.5,24,7]
["03000203","汽车造型",1.5,24,6,"03000068","车辆安全性",1.5,24,7]
["03000081","车辆专业外语",1.5,24,6,"03000328","车辆电子学基础",3,48,7]
["03000198","汽车空气动力学",1.5,24,6,"03000253","液压与液力传动",3,48,7]