{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["通识必修课设置建议方案","数学+物理类课程设置","部分归口学院（部门）开课设置"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"通识必修课设置建议方案","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[1,0,1,8],[3,0,6,0],[8,0,9,0],[11,0,12,0],[15,0,19,0],[15,8,19,8],[20,0,26,0],[27,0,31,0],[32,0,33,0],[34,0,37,0],[34,8,37,8]],"flags":["formulas_cached_only"]}
[]
["通识课程设置建议方案"]
["课程类别","课程名称","课程编号","学分","理论学分","实践学分","课程     属性","修读        学期","开设学期建议"]
["思想政治理论课","马克思主义基本原理概论","3015G0001",3,"2.5","0.5","必修","1或2","理工类专业第一学期开设，人文社科类专业第二学期开设"]
[null,"思想道德与法治","3015G0002",3,"2.5","0.5","必修","1或2","人文社科类专业第一学期开设，理工类专业第二学期开设"]
[null,"中国近现代史纲要","3015G0003",3,"2.5","0.5","必修","3或4","理工类专业第三学期开设，人文社科类专业第四学期开设"]
[null,"毛泽东思想和中国特色社会主义理论体系概论","3015G0004",5,"4.5","0.5","必修","3或4","人文社科类专业第三学期开设，理工类专业第四学期开设"]
["形势与政策课","形势与政策","3015G0005",2,"2",null,"必修","1—8","全校所有专业，均以讲座形式开设"]
["军事理论（技能）课","军事理论","1012G0001",2,"2",null,"必修","1","所有专业"]
[null,"军事技能","1012T0001",2,null,"2","必修","1","所有专业，实践教育平台中设置"]
["创新创业教育课","大学生创新创业素质教育","4007G0001",2,2,null,"必修","4或5","金融学院、商学院、教育科学学院、人文学院、外国语学院、艺术与设计学院、管理工程学院、数学与统计学院、体育学院第四学期开设，信息工程学院、环境工程学院、机电工程学院、物理与新能源学院、食品与生物工程学院、土木工程学院、材料与化学工程学院、电气与控制工程学院及各学院专接本、专升本专业的学生第五学期开设。"]
["就业指导课","大学生职业规划教育","1017G0001",0.5,"0.5",null,"必修","2","所有专业"]
[null,"大学生就业指导教育","1017G0002",0.5,"0.5",null,"必修","6","所有专业"]
["大学生心理健康教育课","大学生心理健康教育","1012G0002",2,"2",null,"必修","1或2","信息工程学院、电气与控制工程学院、教育科学学院、材料与化学工程学院、人文学院、数学与统计学院、物理与新能源学院、管理工程学院、商学院第一学期开设，金融学院、土木工程学院、机电工程学院、食品与生物工程学院、环境工程学院、外国语学院、艺术与设计学院、体育学院第二学期开设"]
["音乐素养课","音乐素养","3002G0001",2,2,null,"必修","3或4","所有专业"]
["体育课","大学体育(Ⅰ)","3003G0001",0.5,null,0.5,"必修","1","所有专业"]
[null,"大学体育(Ⅱ)","3003G0002","1",null,"1","必修","2"]
[null,"大学体育(Ⅲ)","3003G0003","1",null,"1","必修","3"]
[null,"大学体育(Ⅳ)","3003G0004","1",null,"1","必修","4"]
[null,"大学体育(Ⅴ)","3003G0005","0.5",null,"0.5","必修","5、6"]
["大学英语课","大学英语A(I)","3005G0001",3,2.5,0.5,1,"1","除艺术与设计学院、体育学院、音乐1、音乐2、旅管单、财管单及中俄合作办学各班级外的其他学生"]
[null,"大学英语A(Ⅱ)","3005G0002",3,2.5,0.5,2,"2","大学英语A(I)课程中未通过第一学期大学英语四级考试的学生"]
[null,"大学英语A(Ⅱ)-高级英语","3005G0003",3,2.5,0.5,2,"2","大学英语A(I)课程中通过第一学期大学英语四级考试的学生及实验班"]
[null,"大学英语B(I)","3005G0004",3,2.5,0.5,1,"1","艺术与设计学院、体育学院、音乐1、音乐2、旅管单、财管单"]
[null,"大学英语B(Ⅱ)","3005G0005",3,2.5,0.5,2,"2","艺术与设计学院、体育学院、音乐1、音乐2、旅管单、财管单"]
[null,"大学英语B(Ⅲ)","3005G0006",2,2,null,3,"3","艺术与设计学院、体育学院、音乐1、音乐2、旅管单、财管单"]
[null,"大学英语B(Ⅳ)","3005G0007",2,2,null,4,"4","艺术与设计学院、体育学院、音乐1、音乐2、旅管单、财管单"]
["计算机基础类\n（任选一门）","大学计算机","3009G0001",1,"1",null,"必修","1或2","金融学院、管理工程学院、人文学院、商学院、体育学院、教育科学学院第一学期开，艺术与设计第二学期开"]
[null,"Office高级应用","3009G0002",1.5,"1.5",null,"必修","1或2","教育科学学院第一学期开，金融学院、商学院、外国语学院第二学期开"]
[null,"信息技术及C程序设计","3009G0003",2,"2",null,"必修","1或2","电气与控制工程学院、物理与新能源学院、信息工程学院第一学期开；管理工程学院、环境工程学院、机电工程学院第二学期开"]
[null,"信息技术及Java程序设计","3009G0004",2,"2",null,"必修","1","材料与化学工程学院、机电工程学院（工设班）第一学期开"]
[null,"信息技术及Python程序设计","3009G0005",2,"2",null,"必修","2","土木工程学院、食品与生物工程学院、数学与统计学院第二学期开"]
["大学语文类\n（任选一门）","大学语文","3004G0001","2","2",null,"必修","1或2","环境工程学院、机电工程学院、食品与生物工程学院、土木工程学院、艺术与设计学院第一学期开；教育科学学院、金融学院、商学院、数学与统计学院、人文学院个别专业、外国语学院第二学期开"]
[null,"应用文写作与创意写作","3004G0002","2","2",null,"必修","1或2","电气与控制工程学院、机电工程学院个别专业、体育学院、土木工程学院、外国语学院、金融学院、商学院、强化学院第一学期开；信息工程学院、材料与化学工程学院、管理工程学院、物理与新能源学院、机电学院个别专业第二学期开"]
["“四史”系列              （任选一门）","党史","3015G1001",1,1,null,"必修","1或2","全校所有专业必修，任选一门。理工类专业第一学期开，人文社科类专业第二学期开。"]
[null,"新中国史","3015G1002",1,1,null,"必修","1或2"]
[null,"改革开放史","3015G1003",1,1,null,"必修","1或2"]
[null,"社会主义发展史","3015G1004",1,1,null,"必修","1或2"]

{"sheet":"数学+物理类课程设置","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,0,0,8],[2,0,11,0],[2,8,11,8],[12,0,18,0],[12,8,18,8]],"flags":["formulas_cached_only"]}
["数学类、物理类课程设置"]
["课程  类别","课程名称","课程编号","学分","理论学分","实践学分","课程   属性","修读   学期","备注"]
["数学类课","高等数学A(Ⅰ)","3007B0001",5,5,null,"必修",1,"课程教学大纲由开课学院提供，各专业依据需求自行选择相应组别"]
[null,"高等数学A(Ⅱ)","3007B0002",5,5,null,"必修",2]
[null,"高等数学B(Ⅰ)","3007B0003",4,4,null,"必修",1]
[null,"高等数学B(Ⅱ)","3007B0004",4,4,null,"必修",2]
[null,"高等数学C(Ⅰ)","3007B0005",3,3,null,"必修",1]
[null,"高等数学C(Ⅱ)","3007B0006",3,3,null,"必修",2]
[null,"线性代数A","3007B0007",3,3,null,"必修",3]
[null,"线性代数B","3007B0008",2,2,null,"必修",3]
[null,"概率统计A","3007B0009",3,3,null,"必修",4]
[null,"概率统计B","3007B0010",2,2,null,"必修",4]
["物理类课","大学物理A(Ⅰ)","3018B0001",3,3,null,"必修",2,"课程教学大纲由开课学院提供，各专业依据需求自行选择相应组别"]
[null,"大学物理A(Ⅱ)","3018B0002",3,3,null,"必修",3]
[null,"大学物理B(Ⅰ)","3018B0003",2,2,null,"必修",2]
[null,"大学物理B(Ⅱ)","3018B0004",2,2,null,"必修",3]
[null,"大学物理实验A(Ⅰ)","3018B0005",1,null,1,"必修",2]
[null,"大学物理实验A(Ⅱ)","3018B0006",1,null,1,"必修",3]
[null,"大学物理实验B","3018B0007",1,null,1,"必修",3]

{"sheet":"部分归口学院（部门）开课设置","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,7],[26,0,28,6]],"flags":["formulas_cached_only"]}
["部分归口学院（部门）开课设置"]
["课程名称","课程编号","学分","理论学分","实践学分","课程   属性","开课学院","备注"]
["实验室安全","1020P1001",1,"1",null,"选修","实训实验室与设备管理处","化学、生物等安全重点防范学科应作为必修课开设"]
["管理学概论","3014P1001",2,2,null,"选修","管理工程学院"]
["大学化学A","3008P1001",3,3,null,"选修","材料与化学工程学院"]
["大学化学B","3008P1002",2,2,null,"选修","材料与化学工程学院"]
["大学化学实验","3008P1003",0.5,null,0.5,"选修","材料与化学工程学院"]
["化工原理","3008P1004",3,3,null,"选修","材料与化学工程学院"]
["化工原理实验","3008P1005",1,null,1,"选修","材料与化学工程学院"]
["物理化学","3008P1006",2,2,null,"选修","材料与化学工程学院"]
["物理化学实验","3008P1007",0.5,null,0.5,"选修","材料与化学工程学院"]
["电气控制及PLC","3010P1001",2,2,null,"选修","机电工程学院"]
["电工学A","3010P1002",3,3,null,"选修","机电工程学院"]
["电工学B","3010P1003",2,2,null,"选修","机电工程学院"]
["机械基础","3010P1004",3,3,null,"选修","机电工程学院"]
["工程制图","3010P1005",2,2,null,"选修","机电工程学院"]
["金工实习","3010T1001",1,null,1,"选修","机电工程学院"]
["电子工艺实习","3010T1002",1,null,1,"选修","机电工程学院"]
["机械基础课程设计","3010T1003",1,null,1,"选修","机电工程学院"]
["心理学","3002P1001",2,2,null,"选修","教育科学学院"]
["教育学","3002P1002",2,2,null,"选修","教育科学学院"]
["经济学概论","3017P1001",2,2,null,"选修","金融学院"]
["复变函数与积分变换","3007P1001",2,2,null,"选修","数学与统计学院"]
["数论","3007P1002",2,2,null,"选修","数学与统计学院"]
["数学建模入门","3007P1003",2,2,null,"选修","数学与统计学院"]
["计算方法","3007P1004",2,2,null,"选修","数学与统计学院"]
["注：如果课程设置为必修课，则将课程属性位的“1”修改为“0”"]