{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["表一","表二","续表二","表三","表四","表五","表六","表七"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"表一","index":0,"n_rows":13,"n_cols":39,"rows_kept":13,"merged":[[0,0,0,38],[1,36,1,37],[2,0,3,0],[2,1,3,1],[2,2,2,27],[4,0,5,0],[6,0,7,0],[8,0,9,0],[10,25,10,27],[11,0,11,38],[12,0,12,38]],"flags":["formulas_cached_only"]}
["  整体教学活动安排及时间分配"]
[{"$nulls":36},"表一"]
["学  年","学  期","教 学 进 行 周 次",{"$nulls":25},"理\n论\n教\n学","考  试","社  会  实  践","劳动教育","校内实训","顶岗\n实\n习","入\n学\n教\n育","军\n事\n训\n练","毕\n业\n教\n育","假  期","合  计"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,"←→","K","J","L","S","D","R","M","B","F","—"]
["一",1,null,null,"R","M","M","M","←","―","―","―","―",12,"周","―","―","―","―","→","S","K","F","F","F","F","F","F",12,1,null,null,1,null,0.5,3.5,null,6,24]
[null,2,"←","―","―","―","―",15,"周","―","―","―","―","―","―","―","―","→","S","S","S","K","F","F","F","F","F","F",15,1,null,null,3,{"$nulls":4},6,26]
["二",3,"J","←","―","―","―",13,"周","―","―","―","―","―","―","→","L","S","S","S","S","K","F","F","F","F","F","F",13,1,1,1,4,{"$nulls":4},6,26]
[null,4,"J","←","―","―","―",13,"周","―","―","―","―","―","―","→","S","S","S","S","S","K","F","F","F","F","F","F",13,1,1,null,5,{"$nulls":4},6,26]
["三",5,"←","―","―","―",9,"周","―","―","→","S","S","S","S","K","D","D","D","D","D","D","F","F","F","F","F","F",9,1,null,null,4,7,{"$nulls":3},6,26]
[null,6,"D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","B",{"$nulls":12},18,null,null,1,null,19]
[{"$nulls":25},"总  计",null,null,62,5,2,1,17,25,0.5,3.5,1,30,147]
["注：1.三年总周数147周，其中：在校117周，假期30周。  2.社会实践共3周，主要安排在假期进行。"]
["    "]

{"sheet":"表二","index":1,"n_rows":26,"n_cols":17,"rows_kept":26,"merged":[[0,0,0,16],[2,0,5,0],[2,1,5,1],[2,2,5,2],[2,3,5,3],[2,4,5,4],[2,5,5,5],[2,6,2,8],[2,9,2,14],[2,15,5,15],[2,16,5,16],[3,6,5,6],[3,7,5,7],[3,8,5,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[6,0,24,0],[6,1,17,1],[18,1,18,3],[19,1,23,1],[24,1,24,3],[25,0,25,3]],"flags":["formulas_cached_only"]}
["   教 学 计 划 进 程 表"]
[{"$nulls":15},"表二"]
["课程\n类别","课程\n性质","课程代号","课程名称","学\n分    数","学\n时     数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":6},"分类  代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":9},1,2,3,4,5,6]
[{"$nulls":9},13,19,19,19,13]
["公      共      基       础       课","必       修        课","300011101","思想道德修养与法律基础",3,48,"B",32,16,24,24]
[null,null,"300011102","毛泽东思想和中国特色社会主义理论体系概论",4,64,"B",48,16,null,null,32,32]
[null,null,"300011103","形势与政策",1,72,"A",72,null,12,12,12,12,12,12]
[null,null,"300011304","体育",6,108,null,12,96,24,30,30,24]
[null,null,"300011105","军事理论",2,36,"A",36,null,"军训中安排"]
[null,null,"300011107","大学生职业发展与就业指导",2,36,"A",20,16,{"$nulls":4},36]
[null,null,"300011108","心理健康教育",2,32,"A",32,null,32]
[null,null,"300011110","创新创业基础",2,32,"B",16,16,null,32]
[null,null,"300011212","劳动教育",1,16,"B",8,8,8,8]
[null,null,"300011213","美育基础知识",1.5,24,"A",24,{"$nulls":4},24]
[{"$nulls":3},"四史教育（党史、新中国史、改革开放史、社会主义发展史）",2,32,"A",32,{"$nulls":5},32]
[{"$nulls":3},"安全教育与6S管理",2,32,"B",16,16,null,null,16,16]
[null,"小    计",null,null,28.5,532,null,348,184,{"v":5.230769230769231,"d":"5"},{"v":5.578947368421052,"d":"6"},{"v":4.7368421052631575,"d":"5"},{"v":5.684210526315789,"d":"6"},{"v":6.153846153846154,"d":"6"}]
[null,"限       选       课","300011106","中华优秀传统文化（含闽南文化）",1.5,24,"A",24,{"$nulls":4},24]
[null,null,"300011209","信息技术",3,48,"A",48,null,null,48]
[null,null,"300011111","英语",8,128,"A",128,null,64,64]
[{"$nulls":3},"应用写作与合同法        ",1.5,24,"A",24,{"$nulls":4},24]
[{"$nulls":3},"礼仪与职业素养",1.5,24,"A",24,{"$nulls":5},24]
[null,"小    计",null,null,15.5,248,null,248,0,{"v":4.923076923076923,"d":"5"},{"v":5.894736842105263,"d":"6"},0,{"v":2.526315789473684,"d":"3"},{"v":1.8461538461538463,"d":"2"}]
["合    计",{"$nulls":3},44,780,null,596,184,{"v":10.153846153846153,"d":"10"},{"v":11.473684210526315,"d":"11"},{"v":4.7368421052631575,"d":"5"},{"v":8.210526315789473,"d":"8"},8]

{"sheet":"续表二","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"merged":[[0,15,0,16],[1,0,4,0],[1,0,4,0],[1,1,4,1],[1,1,4,1],[1,2,4,2],[1,3,4,3],[1,4,4,4],[1,5,4,5],[1,6,1,8],[1,9,1,14],[1,15,3,15],[1,16,3,16],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[5,0,26,0],[5,1,13,1],[14,1,14,3],[14,1,14,3],[15,1,21,1],[22,1,22,3],[23,1,25,1],[26,1,26,3],[27,0,27,3],[28,0,29,1],[29,2,29,3],[30,0,30,3]],"flags":["formulas_cached_only"]}
[{"$nulls":15},"续表二"]
["课程\n类别","课程\n性质","课程代号","课程名称","学\n分        数","学\n时       数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":6},"分类    代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":9},1,2,3,4,5,6]
[{"$nulls":9},13,19,19,19,13]
["专      业     课","专      业     基     础      课","360221101","播音主持艺术概论",2,36,"A",36,null,36]
[null,null,"360221102","现代汉语",2,32,"A",32,null,32]
[null,null,"360221103","表演基础",2,32,"A",32,null,null,32]
[null,null,"360221204","广播电视新闻写作",4,64,"A",64,{"$nulls":3},64]
[null,null,"360221105","声乐与钢琴弹奏",4,64,"B",48,16,null,null,64]
[null,null,"360221206","影视化妆与着装",2,36,"A",36,{"$nulls":3},36]
[null,null,"360221207","摄影摄像与直播技术",3,48,"A",48,{"$nulls":3},32]
[null,null,"360221109","新闻学概论",2,32,"A",32,null,null,32]
[null,null,"360221110","广播电视基础",2,32,"A",32,{"$nulls":3},32]
[null,"                     小    计",null,null,23,376,null,360,16,{"v":5.230769230769231,"d":"5"},{"v":3.3684210526315788,"d":"3"},12,0,0]
[null,"专     业     核      心      课","360231201","语音与发音",3,48,"A",48,null,48]
[null,null,"360231102","播音创作基础",3,48,"A",48,{"$nulls":4},48]
[null,null,"360231203","即兴口语表达",3,48,"A",48,null,null,48]
[null,null,"360231105","文艺作品演播",3,48,"A",48,{"$nulls":5},48]
[null,null,"360231106","音频节目播音与主持",2,32,"A",32,{"$nulls":3},32]
[null,null,"360231207","视频节目播音与主持",2,32,"A",32,{"$nulls":4},32]
[null,null,"360231108","采访与现场报道",3,48,"A",48,{"$nulls":5},32]
[null,"                      小    计",null,null,19,304,null,304,0,{"v":3.6923076923076925,"d":"4"},{"v":2.526315789473684,"d":"3"},{"v":1.6842105263157894,"d":"2"},{"v":4.2105263157894735,"d":"4"},{"v":6.153846153846154,"d":"6"}]
[null,"专业    拓展课","360241201","活动策划与组织",2,32,"A",32,{"$nulls":4},32]
[null,null,"360241202","音频视频剪辑",2,32,"B",28,4,{"$nulls":4},32]
[]
[null,"                      小    计",null,null,4,64,null,60,4,{"$nulls":3},2,3]
["                             合    计",{"$nulls":3},46,744,null,724,20,{"v":8.923076923076923,"d":"9"},{"v":5.894736842105263,"d":"6"},{"v":13.68421052631579,"d":"14"},{"v":6.2105263157894735,"d":"6"},{"v":9.153846153846153,"d":"9"}]
["公共选修课",null,"见表三","至少选修3学分",3,48,null,48]
[null,null,"               小    计",null,3,48,null,48,{"$nulls":4},2,2]
["总    计",{"$nulls":3},93,1572,null,1368,204,{"v":19.076923076923077,"d":"19"},{"v":17.36842105263158,"d":"17"},{"v":18.421052631578945,"d":"18"},{"v":16.421052631578945,"d":"16"},{"v":19.153846153846153,"d":"19"}]

{"sheet":"表三","index":3,"n_rows":15,"n_cols":16,"rows_kept":15,"merged":[[0,0,0,15],[2,0,5,0],[2,1,5,1],[2,2,5,2],[2,3,5,3],[2,4,5,4],[2,5,2,7],[2,8,2,13],[2,14,5,14],[2,15,5,15],[3,5,5,5],[3,6,5,6],[3,7,5,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[6,0,13,0],[6,15,14,15],[14,0,14,2]],"flags":["formulas_cached_only"]}
["公共选修课教学计划表"]
[{"$nulls":14},"表三"]
["课程\n类别","课程代号","课程名称","学\n分    数","学\n时   数","课程类型",null,null,"各学期学时分配",{"$nulls":5},"考核方式","备注"]
[{"$nulls":5},"分类  代号","理论\n学时","实践\n学时","一",null,"二",null,"三"]
[{"$nulls":8},1,2,3,4,5,6]
[{"$nulls":8},13,15,14,13,9]
["公共选修课","300062145","活动主持",1.5,24,null,24,{"$nulls":4},24,{"$nulls":3},"4-5   学期    开课    至少    选修    3.0     学分"]
[null,"300062117","影视鉴赏",1.5,24,null,24,{"$nulls":4},24]
[null,"300062118","短视频编辑与制作",1.5,24,null,24,{"$nulls":4},24]
[null,"300062119","硬笔书法",1.5,24,null,24,{"$nulls":4},24]
[null,"300062147","美学基础",1.5,24,null,24,{"$nulls":5},24]
[null,"300062133","体育舞蹈",1.5,24,null,24,{"$nulls":5},24]
[null,"300062134","瑜伽",1.5,24,null,24,{"$nulls":5},24]
[null,"300062146","电商技术",1.5,24,null,24,{"$nulls":5},24]
["合    计",null,null,3,48,null,48]

{"sheet":"表四","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"merged":[[0,0,0,15],[1,14,1,15],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,2,13],[2,14,4,14],[2,15,4,15],[3,8,3,9],[3,10,3,11],[3,12,3,13],[5,0,15,0],[16,0,16,2]],"flags":["formulas_cached_only"]}
["实践教学环节安排表"]
[{"$nulls":14},"表四"]
["实践教学\n环节类别","实践教学\n环节编号","实践教学环节名称","学分","教学周数","课时数","分类代号","实践学时","执行学期",{"$nulls":5},"考核方式","备注"]
[{"$nulls":8},"一",null,"二",null,"三"]
[{"$nulls":8},1,2,3,4,5,6]
["集         中          实          践         教          学         环         节","300071301","军事技能",2,3.5,120,"C",120,"军训中安排"]
[null,"300071302","校内综合实训",25.5,17,408,"C",408,1,3,4,5,4]
[null,"300071304","校外顶岗实习",37.5,25,650,"C",650,{"$nulls":4},7,18]
{"$rows_empty":8}
["合        计",null,null,65,45.5,1178,null,1178]

{"sheet":"表五","index":5,"n_rows":24,"n_cols":9,"rows_kept":24,"merged":[[0,0,0,8],[3,0,16,0],[17,0,18,0],[21,0,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8]],"flags":["formulas_cached_only"]}
["实习实训教学安排表"]
[{"$nulls":8},"表五"]
["实践教学类型","开设学期","周数","所属课程或职业岗位","实践形式","实践项目","学时数","学分数","实践地点"]
["校内综合实训",1,1,"语音发声","课程技能训练","普通话语音发声实训",24,1.5,"校内实训室"]
[null,2,1,"形体","课程技能训练","形体实训",24,1.5,"校内实训室"]
[null,2,1,"朗诵","课程技能训练","朗诵实训",24,1.5,"校内实训室"]
[null,2,1,"即兴口语表达","课程技能训练","演讲实训",24,1.5,"校内实训室"]
[null,3,2,"琴法与歌曲伴奏","课程技能训练","琴法与歌曲伴奏实训",48,3,"校内实训室"]
[null,3,1,"影视着装与化妆","课程技能训练","着装与化妆实训",24,1.5,"校内实训室"]
[null,3,1,"广播节目播音主持","课程技能训练","广播节目播音主持实训",24,1.5,"校内实训室"]
[null,4,2,"摄影摄像","课程技能训练","摄影摄像实训",48,3,"校内实训室"]
[null,4,1,"电视节目播音主持","课程技能训练","电视节目播音主持实训",24,1.5,"校内实训室"]
[null,4,2,"校园活动主持与播音","课程技能训练","校园活动主持与播音实训",48,3,"校内实训室"]
[null,5,1,"解说","课程技能训练","解说实训",24,1.5,"校内实训室"]
[null,5,1,"现场报道","课程技能训练","现场报道实训",24,1.5,"校内实训室"]
[null,5,1,"采访","课程技能训练","采访实训",24,1.5,"校内实训室"]
[null,5,1,"手机直播","课程技能训练","手机直播实训",24,1.5,"校内实训室"]
["校外顶岗实习",5,7,"顶岗实习","顶岗工作","语言表达与传播实训",182,10.5,"影视传媒公司、文化传播公司、庆典公司、从事语言表达的教学单位"]
[null,"6",18,"顶岗实习","顶岗工作或毕业论文","群众文艺活动主持实训，群体活动策划与组织实训",468,27,"影视传媒公司、文化传播公司、庆典公司、从事语言表达的教学单位"]
["合  计",null,42,{"$nulls":3},1058,63]
[]
["注：①、实践环节，校内综合实训每周按24学时计算，校外顶岗实习每周按26学时计算。每周折合1.5学分；"]
["    ②、校内实训的实践形式主要进行课程技能训练；"]
["    ③、顶岗实习实践形式主要是本专业相关岗位顶岗工作。"]

{"sheet":"表六","index":6,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[0,0,0,4],[2,0,2,4],[3,0,7,0],[8,0,10,0],[13,0,13,4],[14,0,14,1],[15,0,15,1],[16,0,16,1],[18,0,18,1],[19,0,19,1],[22,0,22,4],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[27,2,27,4],[30,0,30,4],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1]],"flags":["formulas_cached_only"]}
["学时、学分分配比例"]
[{"$nulls":4},"表六"]
["1.  理论课教学环节"]
["纵     向    结     构","类别","学时","占理论课总学时百分比","理实学分"]
[null,"公共基础课",780,{"v":0.4961832061068702,"d":"49.6%"},44.5]
[null,"专业课",744,{"v":0.4732824427480916,"d":"47.3%"},46]
[null,"公选课",48,{"v":0.030534351145038167,"d":"3.1%"},3]
[null,"合计",1572,{"v":1,"d":"100.0%"},93.5]
["横     向    结     构","必修课",1212,{"v":0.7709923664122137,"d":"77.1%"},70.5]
[null,"限选课、拓展课、公选课",360,{"v":0.22900763358778625,"d":"22.9%"},23]
[null,"合计",1572,{"v":1,"d":"100.0%"},93.5]
[]
[]
["2.  实践课教学环节"]
["类别",null,"周数","学时","占实践课总学时百分比"]
["校内实训",null,17,408,{"v":0.2952243125904486,"d":"29.5%"}]
["校外实习",null,25,650,{"v":0.4703328509406657,"d":"47.0%"}]
["军训",null,null,120,{"v":0.08683068017366136,"d":"8.7%"}]
["课内实践",null,"—",204,{"v":0.1476121562952243,"d":"14.8%"}]
["合计",null,42,1382,{"v":0.9999999999999999,"d":"100.0%"}]
[]
[]
["3.  理论课与实践课之比"]
["类别",null,"周数","学时","占全部课程总学时百分比"]
["理论课",null,56,1368,{"v":0.4974545454545454,"d":"49.7%"}]
["实践课",null,56,1382,{"v":0.5025454545454545,"d":"50.3%"}]
["合计",null,112,2750,{"v":1,"d":"100.0%"}]
["理论课与实践课比例",null,"1:  1"]
[]
[]
["4.  公共基础课、选修课占总学时之比"]
["类别",null,"周数","学时","占全部课程总学时百分比"]
["理论课与实践课总学时",null,"—",2750,"—"]
["公共基础课总学时",null,"—",780,{"v":0.28363636363636363,"d":"28.4%"}]
["限选课、拓展课、公选课总学时",null,"—",360,{"v":0.13090909090909092,"d":"13.1%"}]

{"sheet":"表七","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,0,6],[2,1,2,3],[3,0,5,0],[3,1,5,1],[3,4,5,4],[6,0,8,0],[6,1,8,1],[9,0,12,0],[9,1,12,1],[13,0,13,2]],"flags":["formulas_cached_only"]}
["教学过程学分构成表"]
[{"$nulls":6},"表七"]
["序号","教学活动项目",null,null,"周数","学分数","学分计算标准"]
["一","理论       教学",1,"公共基础课",62,44,"16-18学时1学分"]
[null,null,2,"专业课",null,46,"16-18学时1学分"]
[null,null,3,"选修课",null,3,"16-18学时1学分"]
["二","实践     教学",4,"军事技能训练",3.5,2,"教育部文件规定"]
[null,null,5,"校内实训",17,25.5,"每周1.5学分"]
[null,null,6,"顶岗实习",25,37.5,"每周1.5学分"]
["三","其它       环节",7,"执勤、劳动教育",1,1,"每周1学分"]
[null,null,8,"入学教育",0.5,0.5,"每周1学分"]
[null,null,9,"毕业教育与毕业答辩",1,1,"每周1学分"]
[null,null,10,"社会实践",2,2,"每周1学分"]
["合计",null,null,"10项",112,162.5]