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

{"sheet":"表一","index":0,"n_rows":12,"n_cols":40,"rows_kept":12,"merged":[[0,0,0,39],[1,37,1,38],[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,39],[12,0,12,39]],"flags":["formulas_cached_only"]}
["  整体教学活动安排及时间分配"]
[{"$nulls":37},"表一"]
["学  年","学  期","教 学 进 行 周 次",{"$nulls":25},"理\n论\n教\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","G","D","R","M","B","F","—"]
["一",1,null,null,"R","M","M","M","←","―","―","―","―",13,"周","―","―","―","―","―","→","K","F","F","F","F","F","F",13,1,{"$nulls":5},0.5,3.5,null,6,24]
[null,2,"J","―","―","―","―",13,"周","―","―","―","―","―","―","→","L","S","S","S","S","K","F","F","F","F","F","F",14,1,"（1）",1,4,{"$nulls":5},6,26]
["二",3,"←","―","―","―","―",15,"周","―","―","―","―","―","―","―","→","S","S","S","S","K","F","F","F","F","F","F",15,1,null,null,4,{"$nulls":5},6,26]
[null,4,"J","―","―","―","―",14,"周","―","―","―","―","―","―","→","S","S","S","S","S","K","F","F","F","F","F","F",14,1,"（1）",null,5,{"$nulls":5},6,26]
["三",5,"←","―","―",8,"周","―","→","→","S","S","S","S","K","D","D","D","D","D","D","D","F","F","F","F","F","F",8,1,null,null,4,null,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":13},18,null,null,1,null,19]
[{"$nulls":25},"总  计",null,null,64,5,"（2）",1,17,5,25,0.5,3.5,2,30,147]
["注：1.三年总周数147周，其中：在校117周。假期30周。   2.社会实践共3周，主要安排在假期进行。"]

{"sheet":"表二","index":1,"n_rows":27,"n_cols":17,"rows_kept":27,"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,25,0],[6,1,17,1],[18,1,18,3],[19,1,24,1],[25,1,25,3],[26,0,26,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,12]
["公      共      基       础       课","必       修        课","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,"B",12,96,24,30,30,24]
[null,null,"300011105","军事理论",2,36,"A",36,null,36]
[null,null,"300011107","大学生职业发展与就业指导（理论）",2,36,"A",20,16,{"$nulls":4},36]
[null,null,"300011108","心理健康教育",2,32,"A",32,null,null,32]
[null,null,"300011110","创新创业基础",2,32,"B",16,16,16]
[null,null,"300011212","劳动教育",1,16,"B",8,8,8,8]
[null,null,"300011213","美育基础知识",1.5,24,"A",24,{"$nulls":3},24]
[{"$nulls":3},"四史教育（党史、新中国史、改革开放史、社会主义发展史）",2,32,"A",{"$nulls":6},32]
[{"$nulls":3},"安全教育与6S管理",2,32,"B",32,{"$nulls":3},16,16]
[null,"小    计",null,null,28.5,532,null,null,168,{"v":9.23076923076923,"d":"9"},{"v":7.5,"d":"8"},{"v":7.6,"d":"8"},{"v":4.421052631578948,"d":"4"},{"v":6.666666666666667,"d":"7"}]
[null,"限       选       课","300011106","中华优秀传统文化（含闽南文化）",1.5,24,"A",24,{"$nulls":4},24]
[null,null,"300011209","信息技术",3,48,"A",48,null,48]
[null,null,"300011111","英语（含专业英语）",8,128,"A",128,null,64,64]
[null,null,"300011116","应用数学",4.5,72,"A",72,null,36,36]
[{"$nulls":3},"应用写作与合同法        ",1.5,24,"A",24,{"$nulls":4},24]
[{"$nulls":3},"礼仪与职业素养",1.5,24,"A",24,{"$nulls":5},24]
[null,"小    计",null,null,20,320,{"$nulls":3},{"v":11.384615384615385,"d":"11"},{"v":5.2631578947368425,"d":"5"},0,3,2]
["合    计",{"$nulls":3},48.5,852,null,null,168,{"v":20.615384615384613,"d":"21"},12,{"v":7.6,"d":"8"},{"v":7.421052631578948,"d":"7"},{"v":8.666666666666668,"d":"9"}]

{"sheet":"续表二","index":2,"n_rows":29,"n_cols":17,"rows_kept":29,"merged":[[0,15,0,16],[1,0,4,0],[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,24,0],[5,1,13,1],[14,1,14,3],[15,1,19,1],[20,1,20,3],[21,1,23,1],[24,1,24,3],[25,0,25,3],[26,0,27,1],[27,2,27,3],[28,0,28,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,12]
["专      业     课","专      业     基     础      课","351321101","管理学基础",2,32,"A","32",null,"4*前8"]
[null,null,"351321104","旅游政策与法规",3,48,"A","48",null,"4*12"]
[null,null,"351321102","经济学基础",2,32,"A",32,null,null,"4*8"]
[null,null,"351321103","旅游学基础",2,32,"A","32",null,null,"4*8"]
[null,null,"351321106","导游基础知识",3,48,"A",48,null,null,"4*后12"]
[null,null,"351321107","旅游地理",3,48,"A",48,{"$nulls":3},"4*前12"]
[null,null,"351321105","导游服务能力",3,48,"B","40",8,{"$nulls":3},"4*前12"]
[null,null,"351321108","导游情境英语",2,32,"B","24",8,{"$nulls":3},"4*前8"]
[null,null,"351321110","研学课程设计与实施",3,48,"A","48",{"$nulls":5},"8*6"]
[null,"                     小    计",null,null,23,368,null,232,16,{"v":6.153846153846154,"d":"6"},8,3,{"v":6.153846153846154,"d":"6"},6]
[null,"专     业     核      心      课","351331201","景区服务与管理",3,48,"A",48,{"$nulls":3},"3*16"]
[null,null,"351331202","餐饮服务与管理",3,48,"A",48,{"$nulls":3},"3*16"]
[null,null,"351331103","旅行社经营管理",3,48,"A",48,{"$nulls":3},"3*16"]
[null,null,"351331204","导游业务",3,48,"B ",42,6,null,null,"3*16"]
[null,null,"351331205","前厅与客房服务",3,48,"A",48,{"$nulls":4},"4*12"]
[null,"                      小    计",null,null,15,240,null,234,6,0,0,13,3,0]
[null,"专     业     拓     展      课","351341201","市场营销实务",2,32,"A",32,{"$nulls":5},"4*前8"]
[null,null,"350141202","旅游消费行为分析","2",32,"B ",24,8,{"$nulls":3},"4*前8"]
[]
[null,"                      小    计",null,null,4,64,null,56,8,0,0,0,{"v":2.4615384615384617,"d":"2"},{"v":3.5555555555555554,"d":"4"}]
["                             合    计",{"$nulls":3},42,672,null,536,30,{"v":6.153846153846154,"d":"6"},8,16,11,{"v":9.555555555555555,"d":"10"}]
["公共选修课",null,"见表三","至少选修3学分",3,48,null,48]
[null,null,"               小    计",null,3,48,null,48]
["总    计",{"$nulls":3},87.5,1572,null,1374,198,23,23,24,20,23]

{"sheet":"表三","index":3,"n_rows":21,"n_cols":16,"rows_kept":21,"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,19,0],[6,15,20,15],[20,0,20,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,19,19,19,12]
["公共选修课","300062101","智能制造概论",1.5,24,null,24,{"$nulls":8},"4-5     学期    开课    至少    选修    3.0     学分"]
[null,"300062102","计算机组装与维护",1.5,24,null,24]
[null,"310521201","印刷概论",1.5,24,null,24]
[null,"300062128","健康教育",1.5,24,null,24]
[null,"300062129","法律法规",1.5,24,null,24]
[null,"300062132","大学语文",1.5,24,null,24]
[null,"300011121","演讲与口才",1.5,24,null,24]
[null,null,"习近平新时代中国特色社会主义思想",1.5,24,null,24]
[null,null,"英语拓展课",1.5,24,null,24]
[null,null,"信息前沿",1.5,24,null,24]
[{"$nulls":3},1.5,24,null,24]
[]
[]
[]
["合    计",null,null,3,48,null,48]

{"sheet":"表四","index":4,"n_rows":18,"n_cols":16,"rows_kept":18,"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,16,0],[17,0,17,2],[19,0,19,15],[20,0,20,15],[21,0,21,15],[22,0,22,15]],"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,null,4,4,5,4]
[null,"300071304","校外顶岗实习",37.5,25,650,"C",650,{"$nulls":4},7,18]
{"$rows_empty":9}
["合        计",null,null,65,45.5,1178,null,1178,3.5,5,3,6,3,18]

{"sheet":"表五","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,0,0,8],[3,0,11,0],[12,0,13,0],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8]],"flags":["formulas_cached_only"]}
["实习实训教学安排表"]
[{"$nulls":8},"表五"]
["实践教学类型","开设学期","周数","所属课程或职业岗位","实践形式","实践项目","学时数","学分数","实践地点"]
["校内综合实训",2,2,"电子商务软件课程实训","任务训练模式","1.网店与产品设计训练\n2.网店客服训练\n3.网店运营训练",48,3,"电子商务软件实训室"]
[null,2,2,"市场调研实训","任务训练模式","1.调研方案与问卷设计训练\n2.调研实施与抽样调查\n3.数据分析与检验\n4.调研结果与汇报",48,3,"校内外实训室"]
[null,3,2,"市场营销软件课程实训","任务训练模式","1.市场调研训练\n2.网络销售经营训练\n3.团队汇报训练",48,3,"市场营销软件实训室"]
[null,3,2,"企业沙盘软件课程实训","任务训练模式","1.组建模拟企业训练 \n2.构建模拟企业运行市场环境\n3.熟悉模拟企业沙盘运行规则\n4.第一年经营训练与规划经营战略\n5.第二到第六年经营训练",48,3,"企业沙盘软件实训室"]
[null,4,1,"职业资格证书培训","任务训练模式","茶艺师培训：1.茶叶茶具识别与质量鉴定  2.茶具的使用 3.各类茶叶冲泡技巧训练",24,1.5,"茶艺实训室"]
[null,4,1,"吉马酒文化实训","任务训练模式","1.酒水品类识别  2.酒水质量品鉴 3.酒具的使用与酒水调至训练",24,1.5,"吉马酒文化学院"]
[null,4,3,"导游才艺技能实训","项目训练模型","1.旅游景点解说模拟实训\n2才艺展示实训\n3.导游礼仪展示实训\n4.导游形体实训",72,4.5,"导游才艺实训室"]
[null,5,3,"新媒体营销实训","项目训练模型","1.微信(朋友圈\\公众号)推广实训\n2  H5推广实训\n3.抖音等直播视频推广实训\n4.微博推广实训                                          5.携程、拼多多店铺推广实训",72,4.5,"校内外实训室"]
[null,5,1,"ERP实训","项目训练模型","1.总账管理训练\n2.供应链管理训练\n3.采购管理训练\n4.销售管理训练\n5.收付管理训练\n6.仓库管理训练\n7.核算管理训练\n8.工资管理训练\n9.资产管理训练\n10.现金管理训练\n11.报表管理训练",24,1.5,"ERP实训室"]
["校外顶岗实习",5,7,"顶岗实习","顶岗工作或毕业论文","本专业相关岗位实习",182,10.5,"校外相关企业"]
[null,"6",18,"顶岗实习","顶岗工作或毕业论文","本专业相关岗位实习",468,27,"校外相关企业"]
["合  计",null,42,{"$nulls":3},1058,63]
["注：①、实践环节，校内综合实训每周按24学时计算，校外跟岗实习每周按34学时计算，校外顶岗实习每周按26学时计算。每周折合1.5学分；"]
["    ②、校内实训的实践形式主要以课程技能训练模式进行；"]
["    ③、跟岗实习实践形式主要是本专业校内代理记账业务仿真实训；"]
["    ④、顶岗实习实践形式主要是本专业相关岗位实习。"]

{"sheet":"表六","index":6,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[0,0,0,4],[2,0,2,1],[3,0,7,0],[8,0,10,0],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[22,0,22,1],[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,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1]],"flags":["formulas_cached_only"]}
["学时、学分分配比例"]
[{"$nulls":4},"表六"]
["1.理论课教学环节"]
["纵     向      结     构","类  别","学  时","占理论课总学时百分比","理实学分"]
[null,"公共基础课",852,{"v":0.5419847328244275,"d":"54.2%"},53.5]
[null,"专业课",672,{"v":0.42748091603053434,"d":"42.7%"},41.5]
[null,"公选课",48,{"v":0.030534351145038167,"d":"3.1%"},3]
[null,"合计",1572,{"v":1,"d":"100.0%"},98]
["横     向     结     构","必修课",1140,{"v":0.7251908396946565,"d":"72.5%"},71]
[null,"限选课、拓展课、公选课",432,{"v":0.2748091603053435,"d":"27.5%"},27]
[null,"合计",1572,{"v":1,"d":"100.0%"},98]
[]
[]
["2.实践课教学环节"]
["类  别",null,"周数","学  时","占实践课总学时百分比"]
["专项技能训练",null,3.5,120,{"v":0.0872093023255814,"d":"8.7%"}]
["校内综合实训",null,17,408,{"v":0.29651162790697677,"d":"29.7%"}]
["校外顶岗实习",null,25,650,{"v":0.47238372093023256,"d":"47.2%"}]
["课内实践学时",null,"—",198,{"v":0.1438953488372093,"d":"14.4%"}]
["合计",null,45.5,1376,{"v":1,"d":"100.0%"}]
[]
[]
["3.理论课与实践课之比"]
["类  别",null,"周数","学  时","占全部课程总学时百分比"]
["理论课",null,64,1374,{"v":0.49963636363636366,"d":"50.0%"}]
["实践课",null,45.5,1376,{"v":0.5003636363636363,"d":"50.0%"}]
["合计",null,109.5,2750,{"v":1,"d":"100.0%"}]
["理论课与实践课比例",null,"100：100"]
[]
[]
["4.公共基础课、选修课占总学时之比"]
["类  别",null,"周数","学  时","占全部课程总学时百分比"]
["理论课与实践课总学时",null,"—",2750,"—"]
["公共基础课总学时",null,"—",852,{"v":0.3098181818181818,"d":"31.0%"}]
["限选课、拓展课、公选课总学时",null,"—",432,{"v":0.1570909090909091,"d":"15.7%"}]

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