{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["专业课程设置一览表（四年制理工）","专业教学计划表（四年制理工）","专业课程设置一览表（四年制文史）","专业教学计划表（四年制文史）","Sheet1"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"专业课程设置一览表（四年制理工）","index":0,"n_rows":95,"n_cols":9,"rows_kept":95,"merged":[[0,0,0,5],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[13,0,13,1],[23,0,23,1],[29,0,29,1],[32,0,32,1],[39,0,39,1],[44,0,44,1],[45,0,45,1],[52,0,52,1],[53,0,53,1],[57,0,57,1],[63,0,63,1],[64,0,64,1],[69,0,69,1],[71,0,71,1],[77,0,77,1],[78,0,78,1],[79,6,86,6],[88,0,88,1],[93,0,93,1],[94,0,94,1]],"flags":["formulas_cached_only"]}
["                          （理工类）专业课程设置一览表"]
["课程代码","课程名称","英文名称","学分","考核方式","开课学期","说明"]
[{"$nulls":3},{"v":180,"d":"180.0"},null,null,"总学分不得突破！"]
["一、必修课"]
["1.通识教育课程",null,null,{"v":33,"d":"33.0"},null,null,"不可调整"]
["（1）思想政治类",null,null,{"v":14,"d":"14.0"}]
["MY010011B","思想道德修养与法律基础","Ideological Moral Cultivation and Law Basic",2.5,"考试",null,"不可调整（只能选择授课学期）"]
["MY010021B","中国近现代史纲要","Outline of modern Chinese history",2.5,"考试",null,"不可调整（只能选择授课学期）",null," "]
["MY020011B","马克思主义基本原理概论","The Basically Principle of Marxism",3,"考试",null,"不可调整（只能选择授课学期）"]
["MY020021B","毛泽东思想和中国特色社会主义理论体系概论","The introduction of Maoism and socialism system with Chinese characteristics",4,"考试",null,"不可调整（只能选择授课学期）"]
["MY010031B","形势与政策","Situation And Policy ",2,"考试","第1-8学期","不可调整（只能选择授课学期），最终确定2学分"]
[]
[]
["（2）大学英语类（基础模块）",null,null,{"v":12,"d":"12.0"},null,null,"不可调整"]
["WY020011B","大学英语读写译1","College English Reading, Writing and Translating Course 1",2,"考试","第1学期","不可调整（只能选择授课学期）"]
["WY020101B","大学英语视听说（自主学习）1","College English Viewing, Listening and speaking Course 1",2,"考试","第1学期","不可调整（只能选择授课学期）"]
["WY020021B","大学英语读写译2","College English Reading, Writing and Translating Course 2",2,"考试","第2学期","不可调整（只能选择授课学期）"]
["WY020201B","大学英语视听说（自主学习）2","College English Viewing, Listening and speaking Course 2",2,"考试","第2学期","不可调整（只能选择授课学期）"]
["WY010031B","大学英语读写译3","College English Reading,Writing and Translating Course 3",2,"考试","第3学期","不可调整（只能选择授课学期）"]
["WY010301B","大学英语视听说（自主学习）3","College English Viewing, Listening and speaking Course 3",2,"考试","第3学期","不可调整（只能选择授课学期）"]
[]
[]
[]
["（3）大学体育类",null,null,{"v":4,"d":"4.0"},null,null,"不可调整（只能选择授课学期）"]
["TY010011B","大学体育1","PEclass1",1,"考试",null,"不可调整（只能选择授课学期）"]
["TY020021B","大学体育2","PEclass2",1,"考试",null,"不可调整（只能选择授课学期）"]
["TY030031B","大学体育3","PEclass3",1,"考试",null,"不可调整（只能选择授课学期）"]
["TY040041B","大学体育4","PEclass4",1,"考试",null,"不可调整（只能选择授课学期）"]
[]
["（4）计算机语言类",null,null,{"v":3,"d":"3.0"},null,null,"凡参加计算机二级考试学生必须修读1门课程"]
[null,"各专业任选1门（电信学院可自定）",null,3,null,null,"见计算机类课程清单（共4门）"]
[]
["2.素质拓展与创新",null,null,{"v":9,"d":"9.0"},null,null,"不可调整"]
["CC010015B","创业基础","Entrepreneurial Basics ",{"v":2,"d":"2.0"},"考查",null,"不可调整（只能选择授课学期）"]
["CC010025B","大学生职业生涯规划与就业指导","Career Planning and Empolyment Guidance of University Students ",{"v":2,"d":"2.0"},"考查",null,"不可调整（只能选择授课学期）"]
["GG040035B","大学生心理健康教育","College Students Mental Health Education ",{"v":2,"d":"2.0"},"考查",null,"不可调整（只能选择授课学期）"]
["JW010015B","安全教育","Safety Education ",{"v":1,"d":"1.0"},"考查","第2学期","不可调整（只能选择授课学期）"]
["JW010035B","军事理论","Military Theory",{"v":2,"d":"2.0"},"考查","第1学期","不可调整（只能选择授课学期）"]
[]
["3.大类学科专业基础课程"]
[]
[]
[]
[]
["4.专业与专业方向课程"]
["（1）专业核心课程",{"$nulls":5},"依据专业类国标、专业规范确定专业核心课程（含专业导论课）。开设双语课程（必修课）1门以上，并注明“双语”"]
[]
[]
[]
[]
[]
[]
["（2）专业方向课程",{"$nulls":5},"按方向模块分别设置；新工科专业（土木工程、电子信息等）必设，其他专业可自定"]
["专业方向1：（4-8个学分）"]
[]
[]
[]
["专业方向2：（4-8个学分）"]
[]
[]
["……"]
[]
[]
["5.实践教学课程",null,null,{"v":45,"d":"45.0"},null,null,"≥45（原则上要求≥25%）"]
["（1）基础实践类"]
["MY020031B","思想政治教育实践课","Practical Course of Ideological and Political Education \n",{"v":2,"d":"2.0"},"考查",null,"不可调整（只能选择授课学期）"]
["JW010025B","军事训练与国防教育","Military Training and National Defense Education ",{"v":2,"d":"2.0"},"考查","第1学期","不可调整（只能选择授课学期）"]
[]
[]
["（2）专业实践类"]
[]
["（3）综合实践类"]
[null,"毕业论文（设计）*",null,{"v":12,"d":"12.0"}]
[]
[]
["毕业论文（设计）*含毕业实习，16周，12学分。"]
[]
["二、选修课"]
["1.通识教育课程",null,null,{"v":11,"d":"11.0"},null,null,"不可调整"]
[null,"徽派建筑文化类课程",null,{"v":1,"d":"1.0"},null,null,"公选课学分≥11，其中，\n1）第二外语必选1门（德、法、俄、日）\n2）徽州文化与徽派建筑课程各专业必选1门以上\n3）人文社科类课程《大学语文》（1.0学分）和《阅读与写作》（1.0学分）必须选修1门\n4）其他3类课程至少各选1门以上\n5）学校提供清单，由学生在线自选\n6）满足上述条件后，可选在线课程作为补充"]
[null,"第二外语",null,{"v":2,"d":"2.0"}]
[null,"人文社科类",null,"（不需填写）"]
[null,"经济管理类",null,"（不需填写）"]
[null,"理工科技类",null,"（不需填写）"]
[null,"艺术体育类",null,"（不需填写）"]
[null,"大学语文/阅读与写作",null,{"v":1,"d":"1.0"}]
[]
[]
["2.专业课程（需分专业方向设置）",{"$nulls":5},"不少于专业与专业方向课程学分的20%，各专业自定，所提供选择的选修课总学分不少于专业选修课总学分要求的1.2倍。"]
[]
[]
[]
[]
["4.大学生社会实践与课外创新创业（第二课堂）",null,null,{"v":5,"d":"5.0"},null,null,"包括学科竞赛、社会实践、创新教育、学科拓展等（由团委审核，不计入总学分，学生毕业必备条件），各学院制定实施细则"]
["5.体质健康测试",null,null,0.5,null,null,"不计入总学分，学生毕业必备条件"]

{"sheet":"专业教学计划表（四年制理工）","index":1,"n_rows":98,"n_cols":19,"rows_kept":98,"merged":[[0,1,0,17],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,7],[1,8,1,15],[4,0,4,17],[5,0,5,1],[6,0,6,1],[13,0,13,1],[21,0,21,1],[27,0,27,1],[30,0,30,1],[37,0,37,1],[42,0,42,1],[43,0,43,1],[53,0,53,1],[54,0,54,1],[61,0,61,1],[70,0,70,1],[71,0,71,1],[72,18,81,18],[77,0,77,1],[79,0,79,1],[85,0,85,1],[86,0,86,1],[86,2,86,3],[86,4,86,5],[86,6,86,7],[86,8,86,9],[86,10,86,11],[86,12,86,13],[86,14,86,15],[86,16,86,17],[87,18,96,18],[97,0,97,1]],"flags":["formulas_cached_only"]}
[null,"                          专业教学计划表"]
["课程编码","课程名称","学分","考核方式","学时分配",{"$nulls":3},"各学期计划周学时",{"$nulls":9},"说明"]
[{"$nulls":4},"总学时","讲课","实验","实践",1,2,3,4,5,6,7,8,9,10]
[]
["一、必修课"]
["1.通识教育课程"]
["（1）思想政治类"]
["MY010011B","思想道德修养与法律基础",2.5,"考试",40,40,0,0]
["MY010021B","中国近现代史纲要",2.5,"考试",40,40,0,0]
["MY020011B","马克思主义基本原理概论",3,"考试",48,48,0,0]
["MY020021B","毛泽东思想和中国特色社会主义理论体系概论",4,"考试",64,64,0,0]
["MY010031B","形势与政策",2,"考试",64,64,0,0]
[]
["（2）大学英语类（基础模块）"]
["WY020011B","大学英语读写译1",2,"考试",32,32,0,0,"2*16"]
["WY020101B","大学英语视听说（自主学习）1",2,"考试",32,32,0,0,"2*16"]
["WY020021B","大学英语读写译2",2,"考试",32,32,0,0,null,"2*16"]
["WY020201B","大学英语视听说（自主学习）2",2,"考试",32,32,0,0,null,"2*16"]
["WY010031B","大学英语读写译3",2,"考试",32,32,0,0,null,null,"2*16"]
["WY010301B","大学英语视听说（自主学习）3",2,"考试",32,32,0,0,null,null,"2*16"]
[]
["（3）大学体育类"]
["TY010011B","大学体育1",1,"考试",32,32,0,0,"2*16"]
["TY020021B","大学体育2",1,"考试",32,32,0,0,null,"2*16"]
["TY030031B","大学体育3",1,"考试",32,32,0,0,null,null,"2*16"]
["TY040041B","大学体育4",1,"考试",32,32,0,0,{"$nulls":3},"2*16"]
[]
["（4）计算机语言类"]
[null,"各专业任选1门"]
[]
["2.素质拓展与创新"]
["CC010015B","创业基础",2,"考查",32,28,4]
["CC010025B","大学生职业生涯规划与就业指导",2,"考查",32,24,8]
["GG040035B","大学生心理健康教育",2,"考查",32,20,12]
["JW010015B","安全教育",1,"考查",30,30,0,null,null,"3*10"]
["JW010035B","军事理论",2,"考查",32,32,0,null,"3*11"]
[]
["3.大类学科专业基础课程"]
[]
[]
[]
[]
["4.专业与专业方向课程"]
["（1）专业核心课程"]
{"$rows_empty":9}
["（2）专业方向课程"]
["专业方向1："]
[]
[]
[]
[]
[]
[]
["专业方向2："]
[]
[]
[]
[]
[]
[]
["……"]
[]
["5.实践教学课程"]
["（1）基础实践类"]
["MY020031B","思想政治教育实践课",{"v":2,"d":"2.0"},"考查",40,0,0,40,{"$nulls":10},"思想政治教育实践课：土木学院、环能学院、电信学院、艺术学院、公管学院第3学期；建规学院、经管学院、材化学院、数理学院、外语学院、机电学院第4学期\n"]
["JW010025B","军事训练与国防教育",{"v":2,"d":"2.0"},"考查",60,0,0,60,"30*2"]
[]
[]
[]
["（2）专业实践类"]
[]
["（3）综合实践类"]
[null,"毕业论文（设计）*"]
[]
[]
["毕业论文（设计）*含毕业实习，16周，12学分。"]
[]
["二、选修课"]
["1.通识教育课程"]
[null,"徽派建筑文化类课程",{"$nulls":16},"公选课学分≥11，其中，\n1）第二外语必选1门（德、法、俄、日）\n2）徽州文化与徽派建筑课程各专业必选1门以上\n3）人文社科类课程《大学语文》（1.0学分）和《阅读与写作》（1.0学分）必须选修1门\n4）其他3类课程至少各选1门以上\n5）学校提供清单，由学生在线自选\n6）满足上述条件后，可选在线课程作为补充"]
[null,"第二外语"]
[null,"人文社科类"]
[null,"经济管理类"]
[null,"理工科技类"]
[null,"艺术体育类"]
[null,"大学语文/阅读与写作",{"v":1,"d":"1.0"},"考查"]
[]
[]
[]
["2.专业课程"]

{"sheet":"专业课程设置一览表（四年制文史）","index":2,"n_rows":136,"n_cols":9,"rows_kept":136,"merged":[[0,0,0,5],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[13,0,13,1],[20,0,20,1],[26,0,26,1],[29,0,29,1],[36,0,36,1],[43,0,43,1],[66,0,66,1],[67,0,67,1],[75,0,75,1],[82,0,82,1],[87,0,87,1],[88,0,88,1],[89,6,96,6],[98,0,98,1],[134,0,134,1],[135,0,135,1]],"flags":["formulas_cached_only"]}
["                          （英语）专业课程设置一览表"]
["课程代码","课程名称","英文名称","学分","考核方式","开课学期","说明"]
[{"$nulls":3},{"v":170,"d":"170.0"},null,null,"总学分不得突破！"]
["一、必修课"]
["1.通识教育课程",null,null,{"v":33,"d":"33.0"},null,null,"不可调整"]
["（1）思想政治类",null,null,{"v":14,"d":"14.0"}]
["MY010011B","思想道德修养与法律基础","Ideological Moral Cultivation and Law Basic",2.5,"考试","第2学期","不可调整（只能选择授课学期）"]
["MY020011B","中国近现代史纲要","Outline of modern Chinese history",2.5,"考试","第1学期","不可调整（只能选择授课学期）",null," "]
["MY030011B","马克思主义基本原理概论","The Basically Principle of Marxism",3,"考试","第4学期","不可调整（只能选择授课学期）"]
["MY040011B","毛泽东思想和中国特色社会主义理论体系概论","The introduction of Maoism and socialism system with Chinese characteristics",4,"考试","第3学期","不可调整（只能选择授课学期）"]
["MY040011B","形势与政策","Situation And Policy ",2,"考试","第1-8学期","不可调整（只能选择授课学期），最终确定2学分"]
[]
[]
["（2）第二外语类（基础模块）",null,null,{"v":12,"d":"12.0"},null,null,"不可调整"]
["WY030011B","第二外语（德语）A1","The Second Foreign Language A1 (German)",4,"考试","第5学期"]
["WY030021B","第二外语（德语）A2","The Second Foreign Language A2 (German)",4,"考试","第6学期"]
["WY030031B","第二外语（德语）A3","The Second Foreign Language A3 (German)",4,"考试","第7学期"]
[]
[]
[]
["（3）大学体育类",null,null,{"v":4,"d":"4.0"},null,null,"不可调整（只能选择授课学期）"]
["TY010011B","大学体育1","PEclass1",1,"考试","第1学期","不可调整（只能选择授课学期）"]
["TY020021B","大学体育2","PEclass2",1,"考试","第2学期","不可调整（只能选择授课学期）"]
["TY030031B","大学体育3","PEclass3",1,"考试","第3学期","不可调整（只能选择授课学期）"]
["TY040041B","大学体育4","PEclass4",1,"考试","第4学期","不可调整（只能选择授课学期）"]
[]
["（4）计算机语言类",null,null,{"v":3,"d":"3.0"},null,null,"凡参加计算机二级考试学生必须修读1门课程"]
["XW010021B","程序设计基础—VB语言程序设计","Basic Programming Design--VB ",3,"考试","第3学期","见计算机类课程清单（共4门）"]
[]
["2.素质拓展与创新",null,null,{"v":9,"d":"9.0"},null,null,"不可调整"]
["CC010015B","创业基础","Entrepreneurial Basics ",{"v":2,"d":"2.0"},"考查","第2学期","不可调整（只能选择授课学期）"]
["CC010025B","大学生职业生涯规划与就业指导","Career Planning and Empolyment Guidance of University Students ",{"v":2,"d":"2.0"},"考查","第3学期","不可调整（只能选择授课学期）"]
["GG040035B","大学生心理健康教育","College Students Mental Health Education ",{"v":2,"d":"2.0"},"考查","第1学期","不可调整（只能选择授课学期）"]
["JW010015B","安全教育","Safety Education ",{"v":1,"d":"1.0"},"考查","第2学期","不可调整（只能选择授课学期）"]
["JW010035B","军事理论","Military Theory",{"v":2,"d":"2.0"},"考查","第1学期","不可调整（只能选择授课学期）"]
[]
["3.大类学科专业基础课程",null,null,{"v":17,"d":"17.0"}]
["WY030012B","综合英语A1","Comprhensive English A1",4,"考试","第1学期"]
["WY030022B","综合英语A2","Comprhensive English A2",4,"考试","第2学期"]
["WY030032B","综合英语A3","Comprhensive English A3",4,"考试","第3学期"]
["WY030042B","综合英语A4","Comprhensive English A4",4,"考试","第4学期"]
["WY030052B","英语语音","English Pronunciation",1,"考查","第1学期"]
[]
["4.专业与专业方向课程",null,null,42.5]
["WY030013B","英语交际1","English Communication 1",{"v":2,"d":"2.0"},"考查","第1学期"]
["WY030023B","英语交际2","English Communication 2",{"v":2,"d":"2.0"},"考查","第2学期"]
["WY030033B","英语听力1","English Listening 1",{"v":1,"d":"1.0"},"考查","第1学期"]
["WY030043B","英语听力2","English Listening 2",{"v":1,"d":"1.0"},"考查","第2学期"]
["WY030053B","英语听力3","English Listening 3",{"v":1,"d":"1.0"},"考查","第3学期"]
["WY030063B","英语听力4","English Listening 4",{"v":1,"d":"1.0"},"考试","第4学期"]
["WY030073B","英语基础写作","    English Writing Basics",{"v":2,"d":"2.0"},"考查","第2学期"]
["WY030083B","英语演讲","English Speech",{"v":1,"d":"1.0"},"考查","第3学期"]
["WY030093B","英语辩论","English Debate",1,"考查","第4学期"]
["WY030103B","高级英语A1","Advanced English 1",4,"考试","第5学期"]
["WY030113B","高级英语A2","Advanced English 2",4,"考试","第6学期"]
["WY030123B","高级英语A3","Advanced English 3",4,"考试","第7学期"]
["WY030133B","英语笔译","English Written Translation",2.5,"考试","第5学期"]
["WY030143B","英语口译","English Interpretation",2,"考查","第7学期"]
["WY030153B","语言学概论","An Introduction to linguistics",2,"考试","第5学期"]
["WY030163B","英语史","English History",2,"考查","第2学期"]
["WY030173B","英语文学史","English Literature History",3,"考试","第5学期"]
["WY030183B","英语文学导论","An Introduction to English Literature",2,"考试","第6学期"]
["WY030193B","跨文化交际A","Cross-cultural Communication A",2,"考查","第3学期"]
["WY030203B","英语高级写作","Advanced English Writing",2,"考试","第5学期"]
["WY030213B","学术论文写作","English Thesis Writing",1,"考查","第7学期"]
[]
["5.实践教学课程",null,null,{"v":32,"d":"32.0"},null,null,"≥42.5（原则上要求≥25%）"]
["（1）基础实践类"]
["MY020031B","思想政治教育实践课","Practical Course of Ideological and Political Education \n",{"v":2,"d":"2.0"},"考查","第4学期","不可调整（只能选择授课学期）"]
["JW010025B","军事训练与国防教育","Military Training and National Defense Education ",{"v":2,"d":"2.0"},"考查","第1学期","不可调整（只能选择授课学期）"]
["WY030014B","英语朗读集训","English Recitation Training",{"v":2,"d":"2.0"},"考查","第1学期"]
["WY030024B","英语演讲集训","English Speech Training",{"v":1,"d":"1.0"},"考查","第2学期"]
["WY030034B","英语辩论集训","English Debate Training",{"v":1,"d":"1.0"},"考查","第4学期"]
["WY030044B","英语写作集训","Englisn Writing Training",{"v":2,"d":"2.0"},"考查","第3学期"]
[]
["（2）专业实践类"]
["WY030054B","外贸实务集训","International Trade Training",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030064B","英美文学欣赏1","        English Literature Reading 1",{"v":2,"d":"2.0"},"考查","第2学期"]
["WY030074B","英美文学欣赏2","English Literature Reading 2",{"v":2,"d":"2.0"},"考查","第3学期"]
["WY030084B","翻译实践1","Translation Practice 1",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030094B","翻译实践2","Translation Practice 2",{"v":2,"d":"2.0"},"考查","第7学期"]
[]
["（3）综合实践类"]
["WY030104B","毕业论文（英语）","Graduation Thesis (English)",{"v":12,"d":"12.0"},"考查","第8学期"]
["WY030114B","毕业实习（英语）","Graduation Trial (English)",0,"考查","第8学期"]
["毕业论文（设计）*含毕业实习，16周，12学分。"]
[]
["二、选修课"]
["1.通识教育课程",null,null,{"v":11,"d":"11.0"},null,null,"不可调整"]
["GG040029X","徽州文化和建筑艺术",null,{"v":1,"d":"1.0"},"考查","第2学期","公选课学分≥11，其中，\n1）第二外语必选1门（德、法、俄、日）\n2）徽州文化与徽派建筑课程各专业必选1门以上\n3）人文社科类课程《大学语文》（1.0学分）和《阅读与写作》（1.0学分）必须选修1门\n4）其他3类课程至少各选1门以上\n5）学校提供清单，由学生在线自选\n6）满足上述条件后，可选在线课程作为补充"]
[null,"第二外语",null,{"v":2,"d":"2.0"}]
[null,"人文社科类",null,"（不需填写）"]
[null,"经济管理类",null,"（不需填写）"]
[null,"理工科技类",null,"（不需填写）"]
[null,"艺术体育类",null,"（不需填写）"]
["GG040019X","大学语文/阅读与写作",null,{"v":1,"d":"1.0"},"考查","第2学期"]
[]
[]
["2.专业课程（需分专业方向设置）",null,null,25.5,null,null,"不少于专业与专业方向课程学分的20%，各专业自定，所提供选择的选修课总学分不少于专业选修课总学分要求的1.2倍。"]
["WY030223X","西方文化入门","An Itroduction to Western Culture",{"v":2,"d":"2.0"},"考查","第3学期"]
["WY030233X","英语国家文化与社会","Society and Culture of English-speaking Countries",{"v":2,"d":"2.0"},"考查","第4学期"]
["WY030243X","《圣经》与西方文化","Bible and Western Culture",1.5,"考查","第7学期"]
["WY030253X","古希腊罗马神话","Ancient Greek and Roman Mythology",1.5,"考查","第4学期"]
["WY030263X","英语诗歌","English Poetry",1.5,"考查","第5学期"]
["WY030273X","英语短篇小说","English Short Stories",1.5,"考查","第5学期"]
["WY030283X","中国文化概述","A Brief Introduction to Chinese Culture",1.5,"考查","第2学期"]
["WY030293X","英语语法","English Grammar",{"v":2,"d":"2.0"},"考查","第2学期"]
["WY030303X","英语文体学","English Stylistics",1.5,"考查","第6学期"]
["WY030313X","英语修辞学","English Rhetoric",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030323X","英语词汇学","English Lexicology",1.5,"考查","第3学期"]
["WY030333X","二语习得","The Second language Acquisition",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030343X","计算机辅助翻译","Computer-assisted Translation",1.5,"考查","第6学期"]
["WY030353X","英美报刊选读","Selected Reading from Western Press",1.5,"考查","第4学期"]
["WY030363X","科技文献阅读","Science and Technology Literature Reading",1.5,"考查","第6学期"]
["WY030373X","外贸英语函电与应用文","English Business Letter Writing",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030383X","国贸与实务1","International Trade and Practice 1",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030393X","国贸与实务2","International Trade and Practice 2",{"v":2,"d":"2.0"},"考试","第7学期"]
["WY030403X","跨境电商","International E-business",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030413X","国际商法","International Business Law",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030423X","西方经济学导论","An Introduction to Western Economics",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030433X","土木工程概论A","An Introduction to Civil Engineering A",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030443X","工程项目管理","Project Management",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030453X","国际工程管理概论B","An Introduction to International Project Management B",{"v":2,"d":"2.0"},"考查","第7学期"]
["WY030463X","工程招投标及合同管理","Projecting Bidding and Management",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030473X","工程建设法律法规","Project Construction Laws",{"v":2,"d":"2.0"},"考查","第7学期"]
["WY030483X","商务谈判","Business Talks",{"v":2,"d":"2.0"},"考查","第5学期"]
["WY030493X","教育心理学","Education Psychology",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030503X","英语教学法","English Teaching Methodology",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030513X","教育统计学","Education Statistics",{"v":2,"d":"2.0"},"考查","第6学期"]
["WY030523X","计算机辅助语言教学","Computer-assisted English Teaching",2,"考查","第7学期"]
["WY030533X","英语课程设计","English Course Design",{"v":2,"d":"2.0"},"考查","第7学期"]
["WY030543X","英语教学研究方法","English Teaching Research Methodology",{"v":2,"d":"2.0"},"考查","第7学期"]
[]
[]
["4.大学生社会实践与课外创新创业（第二课堂）",null,null,{"v":5,"d":"5.0"},null,null,"包括学科竞赛、社会实践、创新教育、学科拓展等（由团委审核，不计入总学分，学生毕业必备条件），各学院制定实施细则"]
["5.体质健康测试",null,null,0.5,null,null,"不计入总学分，学生毕业必备条件"]

{"sheet":"专业教学计划表（四年制文史）","index":3,"n_rows":131,"n_cols":19,"rows_kept":131,"merged":[[0,1,0,17],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,7],[1,8,1,15],[4,0,4,17],[5,0,5,1],[6,0,6,1],[13,0,13,1],[18,0,18,1],[24,0,24,1],[27,0,27,1],[34,0,34,1],[41,0,41,1],[64,0,64,1],[65,0,65,1],[66,18,81,18],[73,0,73,1],[80,0,80,1],[85,0,85,1],[86,0,86,1],[86,2,86,3],[86,4,86,5],[86,6,86,7],[86,8,86,9],[86,10,86,11],[86,12,86,13],[86,14,86,15],[86,16,86,17],[87,18,96,18],[97,0,97,1]],"flags":["formulas_cached_only"]}
[null,"                         （英语） 专业教学计划表"]
["课程编码","课程名称","学分","考核方式","学时分配",{"$nulls":3},"各学期计划周学时",{"$nulls":9},"说明"]
[{"$nulls":4},"总学时","讲课","实验","实践",1,2,3,4,5,6,7,8,9,10]
[]
["一、必修课"]
["1.通识教育课程"]
["（1）思想政治类"]
["MY010011B","思想道德修养与法律基础",2.5,"考试",40,40,0,0,null,"3*14"]
["MY020011B","中国近现代史纲要",2.5,"考试",40,40,0,0,"3*14"]
["MY030011B","马克思主义基本原理概论",3,"考试",48,48,0,0,{"$nulls":3},"3*16"]
["MY040011B","毛泽东思想和中国特色社会主义理论体系概论",4,"考试",64,64,0,0,null,null,"4*16"]
["MY050011B","形势与政策",2,"考试",64,64,0,0]
[]
["（2）第二外语类"]
["WY030011B","第二外语（德语）A1",4,"考试",64,64,0,0,{"$nulls":4},"4*16"]
["WY030021B","第二外语（德语）A2",4,"考试",64,64,0,0,{"$nulls":5},"4*16"]
["WY030031B","第二外语（德语）A3",4,"考试",64,64,0,0,{"$nulls":6},"4*16"]
[]
["（3）大学体育类"]
["TY010011B","大学体育1",1,"考试",32,32,0,0,"2*16"]
["TY020021B","大学体育2",1,"考试",32,32,0,0,null,"2*16"]
["TY030031B","大学体育3",1,"考试",32,32,0,0,null,null,"2*16"]
["TY040041B","大学体育4",1,"考试",32,32,0,0,{"$nulls":3},"2*16"]
[]
["（4）计算机语言类"]
["XW010021B","程序设计基础—VB语言程序设计",3,"考试",48,24,24,0,null,null,"6*8"]
[]
["2.素质拓展与创新"]
["CC010015B","创业基础",2,"考查",32,28,4,null,null,"2*14"]
["CC010025B","大学生职业生涯规划与就业指导",2,"考查",32,24,8,{"$nulls":3},"2*12"]
["GG040035B","大学生心理健康教育",2,"考查",32,20,12,null,"2*10"]
["JW010015B","安全教育",1,"考查",30,30,0,null,null,"3*10"]
["JW010035B","军事理论",2,"考查",32,32,0,null,"3*11"]
[]
["3.大类学科专业基础课程"]
["WY030012B","综合英语A1",4,"考试",64,64,0,0,"4*16"]
["WY030022B","综合英语A2",4,"考试",64,64,0,0,null,"4*16"]
["WY030032B","综合英语A3",4,"考试",64,64,0,0,null,null,"4*16"]
["WY030042B","综合英语A4",4,"考试",64,64,0,0,{"$nulls":3},"4*16"]
["WY030052B","英语语音",1,"考查",16,16,0,0,"2*8"]
[]
["4.专业与专业方向课程"]
["WY030013B","英语交际1",2,"考查",32,32,0,0,"2*16"]
["WY030023B","英语交际2",2,"考查",32,32,0,0,null,"2*16"]
["WY030033B","英语听力1",1,"考查",16,16,0,0,"1*16"]
["WY030043B","英语听力2",1,"考查",16,16,0,0,null,"1*16"]
["WY030053B","英语听力3",1,"考查",16,16,0,0,null,null,"1*16"]
["WY030063B","英语听力4",1,"考试",16,16,0,0,{"$nulls":3},"1*16"]
["WY030073B","英语基础写作",2,"考查",32,32,0,0,null,"2*16"]
["WY030083B","英语演讲",2,"考查",16,16,0,0,null,null,"2*8"]
["WY030093B","英语辩论",1,"考查",32,32,0,0,{"$nulls":3},"2*16"]
["WY030103B","高级英语A1",4,"考试",64,64,0,0,{"$nulls":4},"4*16"]
["WY030113B","高级英语A2",4,"考试",64,64,0,0,{"$nulls":5},"4*16"]
["WY030123B","高级英语A3",4,"考试",64,64,0,0,{"$nulls":6},"4*16"]
["WY030133B","英语笔译",2.5,"考试",40,40,0,0,{"$nulls":4},"4*10"]
["WY030143B","英语口译",2,"考查",32,32,0,0,{"$nulls":6},"2*16"]
["WY030153B","语言学概论",2,"考试",32,32,0,0,{"$nulls":4},"2*16"]
["WY030163B","英语史",2,"考查",32,32,0,0,null,"2*16"]
["WY030173B","英语文学史",3,"考试",48,48,0,0,{"$nulls":4},"4*12"]
["WY030183B","英语文学导论",2,"考试",32,32,0,0,{"$nulls":5},"2*16"]
["WY030193B","跨文化交际A",2,"考查",32,32,0,0,null,null,"2*16"]
["WY030203B","英语高级写作",2,"考试",32,32,0,0,{"$nulls":4},"2*16"]
["WY030213B","英语论文写作",1,null,16,16,0,0,{"$nulls":6},"2*8"]
[]
["5.实践教学课程"]
["（1）基础实践类"]
["MY020031B","思想政治教育实践课",{"v":2,"d":"2.0"},"考查",40,0,0,40,{"$nulls":3},"3*14",{"$nulls":6},"思想政治教育实践课：土木学院、环能学院、电信学院、艺术学院、公管学院第3学期；建规学院、经管学院、材化学院、数理学院、外语学院、机电学院第4学期\n"]
["JW010025B","军事训练与国防教育",{"v":2,"d":"2.0"},"考查",60,0,0,60,"30*2"]
["WY030014B","英语朗读集训",2,"考查",{"$nulls":4},"2周"]
["WY030024B","英语演讲集训",1,"考查",{"$nulls":5},"1周"]
["WY030034B","英语辩论集训",1,"考查",{"$nulls":7},"1周"]
["WY030044B","英语写作集训",2,"考查",{"$nulls":6},"2周"]
[]
["（2）专业实践类"]
["WY030054B","外贸实务集训",2,"考查",{"$nulls":9},"2周"]
["WY030064B","英美文学欣赏1",2,"考查",{"$nulls":5},"2周"]
["WY030074B","英美文学欣赏2",2,"考查",{"$nulls":6},"2周"]
["WY030084B","翻译实践1",2,"考查",{"$nulls":9},"2周"]
["WY030094B","翻译实践2",2,"考查",{"$nulls":10},"2周"]
[]
["（3）综合实践类"]
["WY030104B","毕业论文（英语）",12,"考查",{"$nulls":11},"16周"]
["WY030114B","毕业实习（英语）",0,"考查",{"$nulls":11},"2周"]
["毕业论文（设计）*含毕业实习，16周，12学分。"]
[]
["二、选修课"]
["1.通识教育课程"]
["GG040029X","徽州文化和建筑艺术",1,"考查",16,16,0,0,null,"2*8",{"$nulls":8},"公选课学分≥11，其中，\n1）第二外语必选1门（德、法、俄、日）\n2）徽州文化与徽派建筑课程各专业必选1门以上\n3）人文社科类课程《大学语文》（1.0学分）和《阅读与写作》（1.0学分）必须选修1门\n4）其他3类课程至少各选1门以上\n5）学校提供清单，由学生在线自选\n6）满足上述条件后，可选在线课程作为补充"]
[null,"第二外语"]
[null,"人文社科类"]
[null,"经济管理类"]
[null,"理工科技类"]
[null,"艺术体育类"]
["GG040019X","大学语文/阅读与写作",{"v":1,"d":"1.0"},"考查",16,16,0,0,null,"2*8"]
[]
[]
[]
["2.专业课程"]
["WY030223X","西方文化入门",2,"考查",32,32,0,0,null,null,"2*16"]
["WY030233X","英语国家文化与社会",2,"考查",32,32,0,0,{"$nulls":3},"2*16"]
["WY030243X","《圣经》与西方文化",1.5,"考查",24,24,0,0,{"$nulls":6},"2*12"]
["WY030253X","古希腊罗马神话",1.5,"考查",24,24,0,0,{"$nulls":3},"2*12"]
["WY030263X","英语诗歌",1.5,"考查",24,24,0,0,{"$nulls":4},"2*12"]
["WY030273X","英语短篇小说",1.5,"考查",24,24,0,0,{"$nulls":4},"2*12"]
["WY030283X","中国文化概述",1.5,"考查",24,24,0,0,null,"2*12"]
["WY030293X","英语语法",2,"考查",32,32,0,0,null,"2*16"]
["WY030303X","英语文体学",1.5,"考查",24,24,0,0,{"$nulls":5},"2*12"]
["WY030313X","英语修辞学",2,"考查",32,32,0,0,{"$nulls":4},"2*16"]
["WY030323X","英语词汇学",1.5,"考查",24,24,0,0,null,null,"2*12"]
["WY030333X","二语习得",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030343X","计算机辅助翻译",1.5,"考查",24,24,0,0,{"$nulls":5},"2*12"]
["WY030353X","英美报刊选读",1.5,"考查",24,24,0,0,{"$nulls":3},"2*12"]
["WY030363X","科技文献阅读",1.5,"考查",24,24,0,0,{"$nulls":5},"2*12"]
["WY030373X","外贸英语函电与应用文",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030383X","国贸与实务1",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030393X","国贸与实务2",2,"考试",32,32,0,0,{"$nulls":6},"2*16"]
["WY030403X","跨境电商",2,"考查",32,32,0,0,{"$nulls":4},"4*8"]
["WY030413X","国际商法",2,"考查",32,32,0,0,{"$nulls":4},"2*16"]
["WY030423X","西方经济学导论",2,"考查",32,32,0,0,{"$nulls":4},"2*16"]
["WY030433X","土木工程概论A",2,"考查",32,32,0,0,{"$nulls":4},"2*16"]
["WY030443X","工程项目管理",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030453X","国际工程管理概论B",2,"考查",32,32,0,0,{"$nulls":6},"2*16"]
["WY030463X","工程招投标及合同管理",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030473X","工程建设法律法规",2,"考查",32,32,0,0,{"$nulls":6},"2*16"]
["WY030483X","商务谈判",2,"考查",32,32,0,0,{"$nulls":4},"2*16"]
["WY030493X","教育心理学",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030503X","英语教学法",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030513X","教育统计学",2,"考查",32,32,0,0,{"$nulls":5},"2*16"]
["WY030523X","计算机辅助语言教学",2,"考查",32,32,0,0,{"$nulls":6},"4*8"]
["WY030533X","英语课程设计",2,"考查",32,32,0,0,{"$nulls":6},"4*8"]
["WY030543X","英语教学研究方法",2,"考查",32,32,0,0,{"$nulls":6},"4*8"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}