{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["学年编制表","课堂教学安排","实践教学安排","素质教育安排"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"学年编制表","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[20,0,27,7],[7,0,8,0],[2,5,4,5],[9,0,10,0],[2,6,4,6],[2,0,2,1],[2,4,4,4],[5,0,6,0],[3,0,3,1],[4,0,4,1],[2,2,4,2],[2,3,4,3],[12,0,17,1],[12,2,13,2],[12,3,13,3],[12,4,12,5],[12,6,13,6],[12,7,13,7],[16,4,16,5],[17,4,17,5]],"flags":["formulas_cached_only"]}
["                        专业"]
["学年编制表"]
["       项目",null,"总周数","课堂教学","实践教学","毕业实践","考试","入学教育"]
["学",{"$nulls":6},"军    训"]
["  年    学期",{"$nulls":6},"毕业教育"]
["一",1,18,15,0,0,1,2]
[null,2,19,18,0,0,1]
["二",3,19,18,0,0,1]
[null,4,19,18,0,0,1]
["三",5,19,18,0,0,1]
[null,6,18,16,0,0,null,2]
["合计",null,112,103,0,0,5,4]
["课时与学分统计",null,null,"总计","课堂教学",null,"实践教学","素质教育"]
[{"$nulls":4},"理论课时","实践课时"]
[null,null,"课时",268,0,0,60,208]
[null,null,"％",1,0,0,0.22388059701492538,0.7761194029850746]
[null,null,"学分",29,2,null,2,25]
[null,null,"％",1,0.06896551724137931,null,0.06896551724137931,0.8620689655172413]
[]
[]
["说明：  1.每个学期的教学总周数固定不变；\n        2. 考试、入学毕业教育安排基本不变；\n        3．实践教学、毕业实践教学安排由实践教学安排表确定；\n        4．课堂教学由表中的总周数减去课堂教学以外的各项之和确定；\n        5．数据由各教学安排表提供；\n        6．课时与学分统计部分的课时总计应不超过2650课时\n"]

{"sheet":"课堂教学安排","index":1,"n_rows":66,"n_cols":21,"rows_kept":66,"cut":false,"hidden":false,"merged":[[29,20,29,21],[30,20,30,21],[24,20,24,21],[25,20,25,21],[26,20,26,21],[27,20,27,21],[28,20,28,21],[0,0,0,17],[1,0,1,17],[53,11,54,11],[53,4,54,4],[53,5,54,5],[53,6,54,6],[53,7,54,7],[51,8,52,8],[51,9,52,9],[53,15,54,15],[65,0,74,17],[62,0,62,17],[53,17,54,17],[57,15,58,15],[57,8,58,8],[57,9,58,9],[57,10,58,10],[53,8,54,8],[53,9,54,9],[53,10,54,10],[51,10,52,10],[51,11,52,11],[51,12,52,12],[51,14,52,14],[51,13,52,13],[2,17,4,17],[5,1,23,1],[2,8,4,8],[2,9,2,14],[3,6,4,6],[2,5,2,7],[2,2,4,2],[2,4,4,4],[2,15,4,15],[3,7,4,7],[24,1,33,1],[34,1,50,1],[51,6,52,6],[61,0,61,17],[51,1,59,1],[55,6,56,6],[57,6,58,6],[51,7,52,7],[55,7,56,7],[57,7,58,7],[2,0,4,0],[2,1,4,1],[2,3,4,3],[3,5,4,5],[51,0,52,0],[55,0,56,0],[57,0,58,0],[51,5,52,5],[55,5,56,5],[57,5,58,5],[51,4,52,4],[55,4,56,4],[57,4,58,4],[53,0,54,0],[51,17,52,17],[55,8,56,8],[55,9,56,9],[55,10,56,10],[55,11,56,11],[55,12,56,12],[55,13,56,13],[55,14,56,14],[55,15,56,15],[53,16,54,16],[53,12,54,12],[53,13,54,13],[53,14,54,14],[2,16,4,16],[51,15,52,15],[51,16,52,16],[57,11,58,11],[57,16,58,16],[57,17,58,17],[55,16,56,16],[55,17,56,17],[57,12,58,12],[57,13,58,13],[57,14,58,14],[17,18,21,25],[15,18,15,24],[9,18,12,24],[13,18,13,24],[14,18,14,24],[16,18,16,24],[5,18,5,24],[6,18,6,24],[7,18,7,24],[8,18,8,24]],"flags":["formulas_cached_only"]}
["                            专业"]
["课堂教学安排表"]
["序号","类别","课程代码","课程名称","学分","课时",null,null,"考核性质","按学期分配周课时数",{"$nulls":5},"开课周数","调整课时","备注"]
[{"$nulls":5},"总课时","理论课时","实践课时",null,1,2,3,4,5,6]
[{"$nulls":9},15,18,18,18,18,16]
[1,"公共必修课","G1040001","思想道德修养",0,0,0,{"$nulls":11},"    思想道德修养：24课时，开设在第一或第二学期，考查课。"]
[2,null,"G1040002","法律基础",0,0,0,{"$nulls":11},"    法律基础：24课时，开设在第一或第二学期，考查课。"]
[3,null,"G1040003","思想政治理论",0,0,0,{"$nulls":11},"    思想政治理论（理论部分）：48课时，开设在第二或第三学期，考查课。"]
[4,null,"G1040004","军事理论",0,0,0,{"$nulls":11},"    军事理论：24课时，开设在第二或第三学期，考查课。"]
[5,null,"G1010001","实用英语一",0,0,0,{"$nulls":11},"    实用英语总计180学时，分四个学期上课，原则上课时分配为：60+60+30+30。其中第一、第四学期为考试，第二、第三学期为考查。"]
[6,null,"G1010002","实用英语二",0,0,0]
[7,null,"G1010003","实用英语三",0,0,0]
[8,null,"G1010004","实用英语四",0,0,0]
[9,null,"G1020001","体育与健康一",1,0,0,{"$nulls":11},"    体育与健康一：课时根据实际开课周确定(≤30)，学分固定为1。"]
[10,null,"G1020002","体育与健康二",1,0,0,{"$nulls":11},"    体育与健康二：课时根据实际开课周确定(≤36)，学分固定为1。"]
[11,null,"G1020003","计算机基础",0,0,0,{"$nulls":11},"    计算机基础：56课时，开设在第一或第二学期，考试课"]
[12,null,"G1020004","应用文写作",0,0,0,{"$nulls":11},"    应用文写作：32课时，开设在第三或第四学期，考查课。"]
[13,null,"G1020005","基础高等数学（48）",0,0,0,{"$nulls":11},"    高等数学分为3种类型：基础高等数学（48）48课时，可开设于第一或第二学期，为考试课，建议经管类专业选择；应用高等数学（72）72课时，可开设于第一或第二学期，为考试课，建议工科类专业选择；线性高等数学（72）72课时，可开设于第一或第二学期，为考试课，建议工科类专业选择。其中应用高等数学（72）和线性高等数学（72）也可以分两个学期开设，第一学期开设基础高等数学（48）考试课，第二学期开设应用数学（24）或线性代数（24）考查课。"]
[14,null,"G1020006","应用高等数学（72）",0,0,0]
[15,null,"G1020007","线性高等数学（72）",0,0,0]
[16,null,"G1020008","线性代数（24）",0,0,0]
[17,null,"G1020009","应用数学（24）",0,0,0]
[18,null,null,null,0,0,0]
[null,null,null,"小计",2,0,0,0,null,0,0,0,0,0,0]
[19,"专业基础必修课",null,null,0,0,0,{"$nulls":12},"学期","考试课门数"]
[20,null,null,null,0,0,0,{"$nulls":12},"第1学期",0]
[21,null,null,null,0,0,0,{"$nulls":12},"第2学期",0]
[22,null,null,null,0,0,0,{"$nulls":12},"第3学期",0]
[23,null,null,null,0,0,0,{"$nulls":12},"第4学期",0]
[24,null,null,null,0,0,0,{"$nulls":12},"第5学期",0]
[25,null,null,null,0,0,0,{"$nulls":12},"第6学期",0]
[26,null,null,null,0,0,0]
[27,null,null,null,0,0,0]
[null,null,null,"小计",0,0,0,0,null,0,0,0,0,0,0]
[25,"专业必修课",null,null,0,0,0]
[26,null,null,null,0,0,0]
[27,null,null,null,0,0,0]
[28,null,null,null,0,0,0]
[29,null,null,null,0,0,0]
[30,null,null,null,0,0,0]
[31,null,null,null,0,0,0]
[32,null,null,null,0,0,0]
[33,null,null,null,0,0,0]
[34,null,null,null,0,0,0]
[35,null,null,null,0,0,0]
[36,null,null,null,0,0,0]
[37,null,null,null,0,0,0]
[38,null,null,null,0,0,0]
[39,null,null,null,0,0,0]
[40,null,null,null,0,0,0]
[null,null,null,"小计",0,0,0,0,null,0,0,0,0,0,0]
[41,"专业选修课",null,null,0,0,0]
[]
[42,null,null,null,0,0,0]
[]
[43,null,null,null,0,0,0]
[]
[44,null,null,null,0,0,0]
[]
[null,null,null,"小计",0,0,0,0,null,0,0,0,0,0,0]
[null,null,null,"合计",2,0,0,0,null,0,0,0,0,0,0]
["注： 1.考试课在考核性质栏中标明对应的学期数字，考查课不进行标注"]
["     2.专业核心课用“★”表示，不多于6门课"]
[]
[]
["说明：\n    1.每学期课堂教学周由学年编制表确定；\n    2. 开课周数不得大于每学期课堂教学周数；\n    3.如果“开课周数”栏无数据，总课时=课堂教学周*周课时+调整课时；否则，总课时=开课周*周课时+调整课时（减少课时以负数表示，如：-3），计划编制时，尽量在“调整课时”栏中填写负数；\n    4. 理论与实践一体化课程的实践课时需要填写，但不得大于总课时的50％；\n    5．理论课时＝总课时－实践课时；\n    6．原则上，每学期的考试课为3-4门，其余为考查课。\n"]

{"sheet":"实践教学安排","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,11],[0,0,0,11],[28,0,30,11],[2,5,2,10],[2,11,3,11],[2,0,3,0],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,1,3,1]],"flags":["formulas_cached_only"]}
["                            专业"]
["实践教学安排表"]
["序号","课程代码","课程名称","学分","课时","按学期分配周数",{"$nulls":5},"备注"]
[{"$nulls":5},1,2,3,4,5,6]
[1,null,"专业导入与国防教育",2,60,2]
[2,null,null,0,0]
[3,null,null,0,0]
[4,null,null,0,0]
[5,null,null,0,0]
[6,null,null,0,0]
[7,null,null,0,0]
[8,null,null,0,0]
[9,null,null,0,0]
[10,null,null,0,0]
[11,null,null,0,0]
[12,null,null,0,0]
[13,null,null,0,0]
[14,null,null,0,0]
[15,null,null,0,0]
[16,null,null,0,0]
[17,null,null,0,0]
[18,null,null,0,0]
[19,null,null,0,0]
[20,null,null,0,0]
[21,null,null,0,0]
[null,null,"合计",2,60,2,0,0,0,0,0]
[]
[]
["说明：\n1．实践教学以周为单位安排教学；\n2. 毕业实践项目课程名称中必须含有“毕业”字样。如：毕业顶岗实习、毕业设计等。"]

{"sheet":"素质教育安排","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,6],[0,0,0,6],[1,0,1,6],[14,6,16,6],[23,5,24,5],[23,6,24,6],[14,5,17,5],[14,0,17,0],[14,2,16,2],[14,3,17,3],[14,4,17,4],[23,4,24,4],[18,6,20,6],[21,0,22,0],[21,3,22,3],[21,4,22,4],[21,5,22,5],[18,0,20,0],[18,3,20,3],[18,4,20,4],[26,0,26,1],[23,0,24,0],[23,2,24,2],[23,3,24,3],[25,0,25,1],[2,0,3,0],[2,1,3,1],[7,0,12,0],[13,0,13,1],[4,0,6,0],[4,2,6,2],[4,3,6,3],[4,4,6,4],[2,2,3,2],[2,3,2,4],[7,6,11,6],[2,5,3,5],[2,6,3,6],[4,5,6,5],[4,6,6,6]],"flags":["formulas_cached_only"]}
["                               专业"]
["素质教育安排表"]
["类别","项目名称","摘要","最低学分",null,"参考课时","备注"]
[null,null,null,"学分","性质"]
["养成教育","学习习惯养成","每学期1学分",5,"必修"]
[null,"行为习惯养成"]
[null,"职业道德养成"]
["素质教育课","政治理论","2014-02-03",1,"必修",16,"讲座     自主学习"]
[null,"心理健康教育","1、2",2,"必修",32]
[null,"职业生涯设计",2,1,"必修",16]
[null,"形势与政策","1、2、3、4",1,"必修",16]
[null,"就业指导",4,1,"必修",22]
[null,"体育活动","3、4",2,"必修",42,"分项选修"]
["小计",null,null,13,null,144]
["公共选修课","人文社科类","第2－4学期",4,"选修",64,"MOOC 面授"]
[null,"自然科学类"]
[null,"艺术类"]
[null,"自学课程"]
["证书","外语等级证书",null,3,"选修"]
[null,"办公自动化证书"]
[null,"职业资格证书"]
["核心能力","心理素质拓展","第1、2学期",2,"选修"]
[null,"职业素质拓展","第1、2学期"]
["社会实践","社会实践","第1、2学期",2,"选修"]
[null,"社会服务"]
["小计",null,null,12,null,64]
["合计",null,null,25,null,208]
[]
["    说明：职业资格证书由专业确定"]