{"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":44,"n_cols":18,"rows_kept":44,"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,2,18,4],[19,2,19,4],[20,4,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,2,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,3,39,4],[40,3,40,4],[41,3,41,4],[42,2,42,4],[43,0,43,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大学英语口语Ⅰ、Ⅱ(普通班，G)",null,12,192,192,null,null,6,6]
["基础教育","必修课",12000065,"计算机基础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]
["基础教育","必修课","09000417","思想道德修养与法律基础            ",null,2,32,32,null,null,2]
["基础教育","必修课","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,128,{"$nulls":3},2,2,2,2]
["学科基础教育","必修课","03000110  03000111","工程制图B（Ⅰ、Ⅱ）","机械设计基础课群（Ⅱ）",4,64,64,null,null,2,2]
["学科基础教育","必修课","03000138","机械设计基础",null,5.5,88,80,8,{"$nulls":4},5.5]
["学科基础教育","必修课","07000062","工程力学C",null,4,64,64,{"$nulls":4},4]
["学科基础教育","必修课","01200009  01200010","电工和电子技术A(Ⅰ、Ⅱ)",null,7,112,80,32,{"$nulls":4},3.5,3.5]
["基础教育","必修课","08000148","运筹学A",null,4,64,64,{"$nulls":4},4]
["学科基础教育","必修课","03000232","系统工程学",null,2,32,32,{"$nulls":6},2]
["学科基础教育","必修课","03000099","工程经济与管理 ",null,2,32,32,{"$nulls":7},2]
["学科基础教育","必修课","03000269","自动控制理论基础A ",null,3,48,48,{"$nulls":7},3]
["学科基础教育","选修课","实验选修课",null,null,4,64,null,64,{"$nulls":5},2,2]
["专业教育","必修课","03000194","汽车构造与原理",null,3.5,56,52,4,{"$nulls":5},3.5]
["专业教育","必修课","03000378","道路工程 ",null,2,32,32,{"$nulls":6},2]
["专业教育","必修课","03000373","交通信息技术基础 ",null,3,48,42,6,{"$nulls":5},3]
["专业教育","必修课","03000168","交通工程学 ",null,3,48,46,2,{"$nulls":6},3]
["专业教育","必修课","03000202","汽车运用工程",null,3,48,42,6,{"$nulls":6},3]
["专业教育","必修课","03000264","智能运输系统  ",null,2,32,30,2,{"$nulls":6},2]
["专业教育","必修课","03000374","交通港站枢纽",null,2,32,28,4,{"$nulls":6},2]
["专业教育","必修课","03000173","交通枢纽实习",null,1,16,null,16,{"$nulls":6},1]
["专业教育","必修课","03000291","城市交通调查及交通控制设计 ",null,2,32,null,32,{"$nulls":7},2]
["专业教育","必修课","03000027","交通运输规划与设计",null,2,32,28,4,{"$nulls":7},2]
["专业教育","必修课","03000169","交通管理与控制 ",null,2,32,30,2,{"$nulls":7},2]
["专业教育","必修课","03000375","汽车检测与诊断实习",null,2,32,null,32,{"$nulls":7},2]
["专业教育","必修课","03410379","毕业设计（论文）",null,16,256,null,256,{"$nulls":8},16]
["专业教育","选修课","专业教育选修课",null,null,20,320,320,null,null,1,{"$nulls":3},6,6,7]
["总计",{"$nulls":4},175,2864,2278,546,40,23,29,25.5,22.5,24,24,15,16]

{"sheet":"实践周","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[0,1,0,4],[0,5,0,7]],"flags":["formulas_cached_only"]}
["表2","实践周教学计划进程"]
["编号","项   目","内   容","学分","学期","周数","周次","场所"]
["09000211","人文社会实践","社会调查、研讨",1,2,1,19,"校内外"]
[98000001,"军事理论","军事理论教学",1,"2",2,"20、21","校内外"]
[98000002,"军事训练","军事实践训练",1.5,"3",3,"暑假","校内外"]
["03000304","机械设计课群（II）综合设计","机械设计课群综合设计",2,4,2,"19-20","本院"]
["01200251","电子实习","典型电子产品装调工艺",1,4,1,21,"校内"]
["03000322","制造技术基础训练","机械制造、材料成型工艺训练、机械加工工艺训练、现代加工技术及特种加工训练、综合实验及创新训练等",4,5,4,"1-3,1周分散","工程训练中心"]
["03000377","测量实习","道路测量与地理信息实习",2,6,2,"19-21","校内"]
["03000290","道路交通调查及道路工程设计","道路交通调查、道路线形及构造物设计",2,6,2,"19-21","校内外"]
["03000195","驾驶实习","汽车驾驶",1,7,1,"1-3","本校、驾校联合"]
["03000016","交通工程实习  ","交通工程专业毕业综合实习",2,7,2,"1-3","校外"]
[null,"合计",null,17.5]

{"sheet":"专业教育选修课","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"merged":[[0,1,0,7]],"flags":["formulas_cached_only"]}
["表3","专业教育选修课"]
["课程编号","课程名称","学分","学时","学期","课程编号","课程名称","学分","学时","学期"]
["03000043","文献检索",1,16,5,"03000199","汽车维修工程",2,32,6]
["03000157","计算机网络与通讯",2,32,5,"03000268","专业外语",2,32,6]
["03000220","数据库系统应用B",2,32,5,"03000316  03000317  ","交通运输工程系列讲座（Ⅰ、Ⅱ）","1\n1","16\n16","1，6"]
["03000193","企业管理概论",2,32,5,"03000249","现代物流工程",2,32,7]
["03000087","城市公共交通",2,32,5,"03000382","交通运输工效学",2,32,7]
["03000030","交通运输学",3,48,6,"03000162","交通安全及项目评价",2,32,7]
["03000090","单片机原理与应用",2,32,6,"03000023","交通运输标准与法规",1.5,24,7]
["03000288","测量学及地理信息系统",2,32,6,"03000085","车载信息与导航系统",1.5,24,7]
["03000163","交通电子应用技术",2,32,6,"03000097","高速公路与现代交通管理",1.5,24,7]
["03000234","现场总线技术",2,32,6,"03000318","汽车电器与电子设备",1.5,24,7]
["03000278","交通流概论",2,32,6,"03000174","交通信息采集与处理",1.5,24,7]