{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["大类学科专业基础","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"大类学科专业基础","index":0,"n_rows":97,"n_cols":14,"rows_kept":97,"merged":[[0,0,0,13],[2,1,31,1],[32,1,50,1],[51,1,59,1],[60,1,96,1]],"flags":["formulas_cached_only"]}
["附件2：安徽建筑大学大类学科专业基础课程一览表"]
["序号","课程模块","新代码","旧代码","课程名称","学分","总学时","讲课","实验","实践","考核方式","开课学院","建议开课学期","建议开课专业"]
[1,"土木建筑类","TM020443B","A02044","土力学与基础工程",{"v":4,"d":"4.0"},64,56,8,0,"考试","土木学院",5,"土木类专业"]
[2,null,"TM020022B","A02002","土力学与地基基础","2.0","32",32,0,0,"考查","土木学院",5,"非土木类专业"]
[3,null,"TM050012B","A05001","理论力学A","4.5","72",72,0,0,"考试","土木学院","2、3","土木类、机械类"]
[4,null,"TM050042B","A05004","结构力学","5.5","88",88,0,0,"考试","土木学院",4,"土木工程 、道桥、交通、地下等专业"]
[5,null,"TM050072B","A05007","工程力学B","3.5","56",52,4,0,"考试","土木学院","2、3","土木、道桥、交通、地下空间等专业"]
[6,null,"TM050062B","A05006","工程力学A2","3.0","48",48,0,0,"考试","土木学院","3、4","工业设计、环境工程、工程管理等专业"]
[7,null,"TM050052B","A05005","工程力学A1","5.0","80",72,8,0,"考试","土木学院","2、3","安全工程、勘查技术与工程、地质工程等专业"]
[8,null,"TM050092B","A05010","建筑力学1",{"v":3,"d":"3.0"},48,48,0,0,"考试","土木学院","2、3","勘查、地质、给排水、过控、环能等专业"]
[9,null,"TM050102B","A05011","建筑力学2",2.5,40,40,0,0,"考试","土木学院","3、4","建筑学、城乡规划专业"]
[10,null,"TM030142B","A03014","工程测量学B",{"v":2,"d":"2.0"},32,24,8,null,"考查","土木学院","2、3、4","非测绘类工程相关专业"]
[11,null,"TM030212B","A03021","工程测量学实习B",{"v":2,"d":"2.0"},0,0,0,"2周","考查","土木学院","2、3、4","非测绘类工程相关专业"]
[12,null,"TM030222B","A03022","工程测量学实习C",{"v":1,"d":"1.0"},0,0,0,"1周","考查","土木学院","2、3、4","非测绘类工程相关专业"]
[13,null,"TM030122B","A03012","误差理论与测量平差基础B",{"v":2,"d":"2.0"},32,0,0,0,"考查","土木学院",4,"地理信息"]
[14,null,"TM030062B","A03006","控制测量学B",1.5,24,0,0,0,"考查","土木学院",4,"地理信息"]
[15,null,"TM030082B","A03008","地籍测量与土地管理",{"v":2,"d":"2.0"},32,0,0,0,"考查","土木学院","6、7","测绘工程、地理信息、土地管理"]
[16,null,"JG011012X","B01101","房屋建筑学",{"v":3,"d":"3.0"},48,0,0,0,"考试","建筑与规划学院",1,"工程管理专升本"]
[17,null,"JG011012X","B01101","房屋建筑学",{"v":3,"d":"3.0"},48,0,0,0,"考试","建筑与规划学院",3,"造价、土木、安全、资产、房地产、工程"]
[18,null,"JG011012X","B01101","房屋建筑学",{"v":3,"d":"3.0"},48,0,0,0,"考试","建筑与规划学院",4,"声学、物理"]
[19,null,"JG011022X","B01102","课程设计（房屋建筑学）",{"v":1,"d":"1.0"},{"$nulls":3},"1周","考查","建筑与规划学院",1,"工程管理专升本"]
[20,null,"JG011022X","B01102","课程设计（房屋建筑学）",{"v":1,"d":"1.0"},{"$nulls":3},"1周","考查","建筑与规划学院",3,"造价、土木、安全、资产、房地产、工程"]
[21,null,"JG011022X","B01102","课程设计（房屋建筑学）",{"v":1,"d":"1.0"},{"$nulls":3},"1周","考查","建筑与规划学院",4,"声学、物理"]
[22,null,"JG011032X","B01103","建筑概论",{"v":2,"d":"2.0"},32,0,0,0,"考查","建筑与规划学院",2,"环能、给排水、电气、会计、声学、财务"]
[23,null,"JG011052X","B01105","建筑设计与原理",{"v":4,"d":"4.0"},64,0,0,0,"考查","建筑与规划学院",3,"声学（设计课）"]
[24,null,"JG041012X","B04101","建筑设计与原理B",{"v":3,"d":"3.0"},48,0,0,0,"考查","建筑与规划学院",3,"环境设计、环境设计（中外合作）（设计课）"]
[25,null,"JG011042X","B01104","建筑构造B",{"v":2,"d":"2.0"},32,0,0,0,"考试","建筑与规划学院",3,"环境设计、环境设计（中外合作该专业考核方式为考查）"]
[26,null,"JG011062X","B01106","中国建筑史B ",1.5,24,0,0,0,"考查","建筑与规划学院",4,"土木"]
[27,null,"JG029012X",null,"城市规划概论",1.5,24,24,0,0,"考查","建筑与规划学院",5,"测绘工程、地理信息、工程管理、土地资源、城市管理"]
[28,null,"JG029022X",null,"乡村规划概论",1.5,24,24,0,0,"考查","建筑与规划学院",6,"土地资源、地理信息、测绘工程"]
[29,null,"JG029032X",null,"城市设计概论B",{"v":2,"d":"2.0"},32,32,0,0,"考查","建筑与规划学院",6,"环境设计、城市管理"]
[30,null,"JG031012X","B03101","景观规划设计原理",{"v":2,"d":"2.0"},32,0,0,0,"考查","建筑与规划学院",7,"环境设计专业、环境设计专业（中外合作班）"]
[31,"环境能源类","HN021213B","C02100","建筑设备A",{"v":4,"d":"4.0"},64,64,0,0,"考试","环能学院","2、4","建筑学"]
[32,null,"HN021013X","C02101","建筑设备B",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",3,"工程管理，土木，造价"]
[33,null,"HN021703X","C02170","建筑设备C",1.5,24,24,0,0,"考查","环能学院",3,"测绘"]
[34,null,"HN020053B","C02005","建筑环境学",{"v":2,"d":"2.0"},32,32,0,0,"考试","环能学院","2、4","应用物理"]
[35,null,"HN010612B","C01030","流体力学B",{"v":4,"d":"4.0"},64,64,0,0,"考试","环能学院","2、4","土木"]
[36,null,"HN020113B","C02011","通风工程",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院","2、4","过控"]
[37,null,"HN010622B","C01031","流体力学C",{"v":2,"d":"2.0"},32,32,0,0,"考试","环能学院","2、4","道桥，安全"]
[38,null,"HN020123X","C02012","建筑设备自动化",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院","2、4","过控"]
[39,null,"HN061011B","C06101","自然地理学B",{"v":2,"d":"2.0"},32,32,0,0,"考试","环能学院",4,"环境，土管，测绘，规划"]
[40,null,"HN050621B","C05062","计量地理学C",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",5,"环境，土管"]
[41,null,"HN061021X","C06102","旅游开发与规划",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",2,"土管"]
[42,null,"HN060071X","C06007","区域分析与规划",{"v":3,"d":"3.0"},48,48,0,0,"考试","环能学院",5,"土管"]
[43,null,"HN050111B","C05011","地理信息系统A",{"v":4,"d":"4.0"},64,48,16,0,"考试","环能学院",5,"测绘"]
[44,null,"HN050901B","C05090","地理信息系统B",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",5,"环境，土管，规划，给排水"]
[45,null,"HN050131B","C05013","遥感基础与图象处理A",{"v":3,"d":"3.0"},48,36,12,0,"考试","环能学院",3,"测绘"]
[46,null,"HN050101X","C05010","遥感基础与图像处理B",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",3,"环境，土管，规划"]
[47,null,"HN061001B","C06100","地图学A",{"v":2,"d":"2.0"},32,32,0,0,"考试","环能学院",3,"测绘，土管"]
[48,null,"HN033012X","C04101","环境与生态概论",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院","2、4","土地资源、环境设计（中外合作）、环境设计"]
[49,null,"HN010352B","C01035","城乡给水排水规划",{"v":2,"d":"2.0"},32,32,0,0,"考查","环能学院",5,"规划，建筑"]
[50,"材料化学类","TM050022B","A05002","材料力学A","5.5","88",80,8,0,"考试","土木学院","3、4","土木、道桥、交通、地下空间等专业"]
[51,null,"TM050032B","A05003","材料力学B","5.0","80",72,8,0,"考试","土木学院","3、4","机械类专业"]
[52,null,"CH030022B","F03006","工程化学基础",{"v":2,"d":"2.0"},32,{"$nulls":3},"考试","材化学院"]
[53,null,"CH030012B","F03005","普通化学",{"v":3,"d":"3.0"},48,{"$nulls":3},"考试","材化学院"]
[54,null,"CH030062B","F03003","物理化学C",{"v":3,"d":"3.0"},48,42,6,null,"考试","材化学院"]
[55,null,"CH030102B","F03002","有机化学C",{"v":2,"d":"2.0"},32,32,0,null,"考试","材化学院"]
[56,null,"CH030112B","F03001","无机及分析化学A",{"v":5,"d":"5.0"},80,60,20,null,"考试","材化学院"]
[57,null,"CH010022B","F01324","土木工程材料B",1.5,24,{"$nulls":3},"考查","材化学院"]
[58,null,"CH010012B","F01001","土木工程材料A","2.5","40",24,16,null,"考查","材化学院"]
[59,"机械电子类","JD010582B","J01037","机械设计基础",{"v":4,"d":"4.0"},64,56,8,null,"考试","机电学院",4,"面向非机械类各专业"]
[60,null,"JD080012B","J07001","画法几何与建筑制图AⅠ",{"v":3,"d":"3.0"},48,48,null,null,"考试","机电学院",1,"土木工程"]
[61,null,"JD080022B","J07002","画法几何与建筑制图AⅡ",{"v":3,"d":"3.0"},48,40,8,null,"考试","机电学院",2,"土木工程"]
[62,null,"JD080032B","J07003","画法几何与建筑制图B",{"v":5,"d":"5.0"},80,68,12,null,"考试","机电学院",1,"地下工程"]
[63,null,"JD080042B","J07004","画法几何与建筑制图C",{"v":3,"d":"3.0"},48,40,8,null,"考试","机电学院","1、2","道桥、交通、测绘、地质、勘查、电子信息、通信、计算机、网络、应用物理、声学、环境工程、地理信息、工程造价、房地产、工程管理、环境设计（中外合作）、环境设计"]
[64,null,"JD080052B","J07005","画法几何与机械制图AⅠ",{"v":3,"d":"3.0"},48,48,null,null,"考试","机电学院",1,"机械、过控、机械电子、建筑环境与能源、金属材料"]
[65,null,"JD080062B","J07006","画法几何与机械制图AⅡ",{"v":3,"d":"3.0"},48,40,8,null,"考试","机电学院",2,"机械、过控、机械电子"]
[66,null,"JD080072B","J07007","画法几何与机械制图B",{"v":4,"d":"4.0"},64,56,8,null,"考试","机电学院","1、2","能源与动力、自动化、工业设计、测控、给排水、电气、生态、安全"]
[67,null,"JD080102B","J07010","建筑阴影透视",{"v":2,"d":"2.0"},32,32,null,null,"考试","机电学院",2,"环境设计专业、环境设计专业（中外合作班）"]
[68,null,"JD080112B","J07011","课程设计（机械零件测绘））",{"v":1,"d":"1.0"},{"$nulls":3},"1周","考查","机电学院",2,"机械、过控"]
[69,null,"JD025012B","J08001","电工电子技术A",4.5,72,60,12,null,"考试","机电学院",4,"材化学院、数理学院、机电学院"]
[70,null,"JD025022B","J08002","电工电子技术B",3.5,56,48,8,null,"考试","机电学院",3,"材化学院、数理学院、土木学院、机电学院"]
[71,null,"JD025032B","J08003","电工技术",2.5,40,32,8,null,"考试","机电学院",3,"材化学院、数理学院、土木学院、机电学院"]
[72,null,"JD025042B","J08004","电子技术",{"v":4,"d":"4.0"},64,52,12,null,"考试","机电学院",4,"材化学院、数理学院、土木学院、机电学院"]
[73,null,"JD100012B","J08005","电子实习A",{"v":2,"d":"2.0"},{"$nulls":3},"2周","考查","机电学院",4,"电气工程及其自动化、自动化、机械电子工程、测控技术与仪器、过程装备与控制工程"]
[74,null,"JD100022B","J08006","电子实习B",{"v":1,"d":"1.0"},{"$nulls":3},"1周","考查","机电学院",5,"给排水、声学、工业设计、机械设计制造及其自动化、环境生态工程、给排水科学与工程、建筑环境与能源应用工程、能源与动力工程、应用化学、化学工程与工艺、无机非金属材料工程"]
[75,null,"JD090012B","J09001","金工实习A",{"v":4,"d":"4.0"},120,null,null,120,"考查","机电学院","2、3","第二学期：机械设计制造及其自动化；\n第三学期：机械电子工程、过程准备与控制工程。"]
[76,null,"JD090022B","J09002","金工实习B",{"v":2,"d":"2.0"},60,0,0,60,"考查","机电学院",2,"给排水科学与工程、建筑环境与能源应用工程、环境工程、能源与动力工程、电子信息工程、计算机科学与技术、通信工程、建筑电气与智能化、物联网工程、无机非金属材料工程、高分子材料与工程"]
[77,null,"JD090022B","J09002","金工实习B",{"v":2,"d":"2.0"},60,0,0,60,"考查","机电学院",3,"工业设计、电气工程及其自动化、自动化、测控技术与仪器、环境生态工程、网络工程、应用化学、化学工程与工艺、金属材料工程、声学。"]
[78,null,"JD010012B","J01050","热工基础",2,32,26,6,0,"考试","机电学院",2,"第二学期：机械设计制造及其自动化；机械电子工程"]
[79,null,"JD070012B","J10001","智能制造导论（双语）",1.5,24,24,0,0,"考查","机电学院",1,"第1学期：机械电子工程."]
[80,null,"JD060122B","J06012","过控专业导论",0.5,8,8,0,0,"考查","机电学院",1,"过程装备与控制工程、给排水、、环境生态工程、建筑环境与能源应用工程、能源与动力工程、应用化学、化学工程与工艺"]
[81,null,"JD060022B","J06002","工程流体力学A",{"v":2,"d":"2.0"},32,32,0,32,"考试","机电学院",5,"过程装备与控制工程、机械设计及其自动化、机电一体化、给排水、、环境生态工程、建筑环境与能源应用工程、能源与动力工程、"]
[82,null,"JD060262B","J01099","工程流体力学B",{"v":1,"d":"1.0"},16,16,0,16,"考查","机电学院",5,"过程装备与控制工程、机械设计及其自动化、机电一体化、给排水、、环境生态工程、建筑环境与能源应用工程、能源与动力工程、"]
[83,null,"JD040012B","J05001","测控专业导论",1.5,24,24,0,24,"考查","机电学院",1,"测控技术与仪器、机械设计及其自动化、机电一体化"]
[84,null,"JD040052B","J05005","工程光学",{"v":3,"d":"3.0"},48,48,0,0,"考试","机电学院",6,"测控技术与仪器、机械设计及其自动化、机电一体化"]
[85,null,"JD040072B","J05007","传感器原理",2.5,40,32,8,0,"考试","机电学院",5,"测控技术与仪器、机械设计及其自动化、机电一体化"]
[86,null,"JD050012B ","J04007","设计素描",4.5,72,72,0,0,"考查","机电学院",1,"工业设计、产品设计类"]
[87,null,"JD050022B","J04010","设计色彩",{"v":3,"d":"3.0"},48,48,0,0,"考查","机电学院",2,"工业设计、产品设计类"]
[88,null,"JD050032B","J04011","工业设计史",{"v":2,"d":"2.0"},32,32,0,0,"考试","机电学院",1,"工业设计、产品设计类"]
[89,null,"JD050042B","J04001","构成艺术基础",{"v":3,"d":"3.0"},48,48,0,0,"考查","机电学院",4,"工业设计、产品设计类"]
[90,null,"JD020012B","J02001","电路原理A",{"v":5,"d":"5.0"},80,68,12,null,"考试","机电学院",3,"电气、自动化、测控等专业"]
[91,null,"JD020022B","J02002","电路原理B",3.5,56,48,8,null,"考试","机电学院",5,"声学等专业"]
[92,null,"JD020032B","J02003","模拟电子技术",{"v":4,"d":"4.0"},64,56,8,null,"考试","机电学院",4,"电气、自动化、测控等专业"]
[93,null,"JD020042B","J02004","数字电子技术",3.5,56,48,8,null,"考试","机电学院",4,"电气、自动化、测控等专业"]
[94,null,"JD030022B","J03002","自动控制原理A",4.5,72,64,8,null,"考试","机电学院",5,"自动化等专业"]
[95,null,"JD030032B","J03003","自动控制原理B",{"v":4,"d":"4.0"},64,56,8,null,"考试","机电学院",5,"电气、测控等专业"]

{"sheet":"Sheet3","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"merged":[[10,11,11,11]],"flags":["formulas_cached_only"]}
["序号","课程代码","课程名称","学分","总学时","讲课","实验","实践","考核方式","开课学院","建议开课学期","建议开课专业"]
[1,"A05003","材料力学B","5.0","80",72,8,0,"考试","土木学院","第3/4学期","机械类专业"]
[2,"A05002","材料力学A","5.5","88",80,8,0,"考试","土木学院","第3/4学期","土木、道桥、交通、地下空间等专业"]
[3,"A02044","土力学与基础工程",4,64,58,6,null,"考试","土木学院",5,"土木类专业"]
[4,"A02002","土力学与地基基础","2.0","32",{"$nulls":3},"考查","土木学院",5,"非土木类专业"]
[5,"A05001","理论力学A","4.5","72",72,0,0,"考试","土木学院","第2/3学期","土木工程 、道桥、交通、地下等专业"]
[6,"A05004","结构力学","5.5","88",88,0,0,"考试","土木学院","第4学期","土木、道桥、交通、地下空间等专业"]
[7,"A05007","工程力学B","3.5","56",52,4,0,"考试","土木学院","第2/3学期","工业设计、环境工程、工程管理等专业"]
[8,"A05006","工程力学A2","3.0","48",48,0,0,"考试","土木学院","第3/4学期","安全工程、勘查技术与工程、地质工程等专业"]
[9,"A05005","工程力学A1","5.0","80",72,8,0,"考试","土木学院","第2/3学期","勘查、地质、给排水、过控、环能等专业"]
[10,"A05010","建筑力学1",3,48,48,0,0,"考试","土木学院","第2/3学期","建筑学、城乡规划专业"]
[11,"A05011","建筑力学2",2.5,40,40,0,0,"考试","土木学院","第3/4学期"]
[12,"A03014","工程测量学B",2,32,24,8,null,"考查","土木学院","第2/3/4学期","非测绘类工程相关专业"]
[13,"A03021","工程测量学实习B",2,{"$nulls":3},"2周","考查","土木学院","第2/3/4学期，理论课结束后","非测绘类工程相关专业"]
[14,"A03022","工程测量学实习C",1,{"$nulls":3},"1周","考查","土木学院","第2/3/4学期，理论课结束后","19培养方案中取消"]
[15,"A03012","误差理论与测量平差基础B",2,32,{"$nulls":3},"考查","土木学院","第4学期","地理信息"]
[16,"A03006","控制测量学B",1.5,24,{"$nulls":3},"考查","土木学院","第4学期","地理信息"]
[17,"A03008","地籍测量与土地管理",3,32,{"$nulls":3},"考查","土木学院","第6/7学期","测绘工程、地理信息、土地管理"]