{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Sheet1","Sheet2","招聘计划","确定课程","遴选计划"],"not_rendered":{"external_links":1,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":95,"n_cols":7,"rows_kept":95,"merged":[[1,0,1,6],[3,0,7,0],[3,1,7,1],[3,2,7,2],[8,0,19,0],[8,1,19,1],[8,2,19,2],[20,0,24,0],[20,1,24,1],[20,2,24,2],[25,0,31,0],[25,1,31,1],[25,2,31,2],[32,0,36,0],[32,1,36,1],[32,2,36,2],[37,0,42,0],[37,1,42,1],[37,2,42,2],[37,6,41,6],[38,5,39,5],[43,0,47,0],[43,1,47,1],[43,2,47,2],[48,0,54,0],[48,1,54,1],[48,2,54,2],[48,6,50,6],[55,0,59,0],[55,1,59,1],[55,2,59,2],[55,5,56,5],[55,6,56,6],[57,5,58,5],[57,6,58,6],[60,0,67,0],[60,1,67,1],[60,2,67,2],[60,6,63,6],[64,5,66,5],[64,6,66,6],[68,0,71,0],[68,1,71,1],[68,2,71,2],[68,5,69,5],[68,6,69,6],[72,0,77,0],[72,1,77,1],[72,2,77,2],[72,6,75,6],[78,0,81,0],[78,1,81,1],[78,2,81,2],[78,6,79,6],[79,5,80,5],[82,0,88,0],[82,1,88,1],[82,2,88,2],[82,5,83,5],[84,5,87,5],[89,0,93,0],[89,1,93,1],[89,2,93,2],[94,0,94,1]],"flags":["formulas_cached_only"]}
["附件"]
["鹰潭应用工程学校拟设置专业及所需专任教师计划表             （按30个班级1500学生计算）"]
["序号","专业名称","班级个数","课程设置","周课时（节）","所需教师数（人）","备注"]
[1,"三校生高考班","5个班","语文",6,3,"其中招研究生1名"]
[{"$nulls":3},"数学",6,3,"其中招研究生1名"]
[{"$nulls":3},"英语",6,3,"其中招研究生1名"]
[{"$nulls":3},"计算机",6,3,"其中招研究生1名"]
[{"$nulls":3},"合计",24,12]
[2,"学前教育","5个班","语文",2,1]
[{"$nulls":3},"普通话",4,2]
[{"$nulls":3},"书法",2,1]
[{"$nulls":3},"幼师英语",2,1]
[{"$nulls":3},"基本乐理",2,1]
[{"$nulls":3},"视唱练耳基础",2,1]
[{"$nulls":3},"钢琴",2,1]
[{"$nulls":3},"舞蹈",2,1]
[{"$nulls":3},"绘画基础",2,1]
[{"$nulls":3},"学前儿童卫生与保健",2,1]
[{"$nulls":3},"幼儿心理学",4,2]
[{"$nulls":3},"合计",26,13]
[3,"计算机平面设计","4个班（其中眼镜方向2个班）","美术（素描课）",4,1,"其中招研究生1名"]
[{"$nulls":3},"Photoshop CS5",6,2]
[{"$nulls":3},"CAD",4,1]
[{"$nulls":3},"平面广告创意与制作",4,1]
[{"$nulls":3},"合计",18,5]
[4,"城市轨道交通运营管理","4个班","语文",2,1]
[{"$nulls":3},"礼仪",2,1]
[{"$nulls":3},"普通话",4,1]
[{"$nulls":3},"客运服务心理",6,2]
[{"$nulls":3},"美术",2,1]
[{"$nulls":3},"城市轨道交通概论",6,2]
[{"$nulls":3},"合计",22,8]
[5,"数控技术运用（其中眼镜方向1个班）","2个班（其中眼镜方向1个班）","机械基础",6,1]
[{"$nulls":3},"机械制图及CAD",6,1]
[{"$nulls":3},"金工实训",6,2,"分组进行"]
[{"$nulls":3},"公差与测量",4,1]
[{"$nulls":3},"合计",22,5]
[6,"汽车运用与维修","2个班","机械制图及CAD",4,null,"其中招研究生1名"]
[{"$nulls":3},"汽车电工电子基础",4,1]
[{"$nulls":3},"汽车文化",2]
[{"$nulls":3},"机械基础",4,1]
[{"$nulls":3},"综合实训",6,3]
[{"$nulls":3},"合计",20,5]
[7,"电子商务","1个班","电子商务概论",4,1,"其中招研究生1名"]
[{"$nulls":3},"美术",2,null,"班级兼课"]
[{"$nulls":3},"Coreldraw",6,1]
[{"$nulls":3},"Photoshop CS5",6,null,"班级兼课"]
[{"$nulls":3},"合计",18,2]
[8,"航空服务","1个班","语文",2,null,"班级兼课"]
[{"$nulls":3},"礼仪",2]
[{"$nulls":3},"美术",2]
[{"$nulls":3},"普通话",4,1]
[{"$nulls":3},"民航概论",6,1]
[{"$nulls":3},"民航旅客运输",6,1]
[{"$nulls":3},"合计",22,3]
[9,"会计","1个班","基础会计",6,1]
[{"$nulls":3},"财经法规与会计职业道德",4]
[{"$nulls":3},"会计技能",4,1]
[{"$nulls":3},"会计电算化（用友）",6]
[{"$nulls":3},"合计",20,2]
[10,"旅游服务与管理","1个班","美术",2,null,"班级兼课"]
[{"$nulls":3},"语文",2]
[{"$nulls":3},"礼仪",2]
[{"$nulls":3},"普通话",4]
[{"$nulls":3},"旅游概论",4,1]
[{"$nulls":3},"导游业务",4]
[{"$nulls":3},"酒店服务",4]
[{"$nulls":3},"合计",22,1]
[11,"民间传统工艺（雕刻）","1个班","艺术概论",2,1]
[{"$nulls":3},"美术",2]
[{"$nulls":3},"综合实训",18,2,"分组进行"]
[{"$nulls":3},"合计",22,3]
[12,"金属压力加工（铜加工）","1个班","技能成就梦想",2,null,"班级兼课"]
[{"$nulls":3},"机械制图及CAD",6]
[{"$nulls":3},"电工知识及安全用电",4]
[{"$nulls":3},"机械基础",4]
[{"$nulls":3},"金属学基础",6,1,"其中招研究生1名"]
[{"$nulls":3},"合计",22,1]
[13,"眼视光","1个班","眼视光概论",8,1,"其中招研究生1名"]
[{"$nulls":3},"角膜接触镜验配技术",4,1]
[{"$nulls":3},"验光技术",3]
[{"$nulls":3},"合计",15,2]
[14,"商务日语","1个班","精读",6,1]
[{"$nulls":3},"语法",6]
[{"$nulls":3},"日常会话",4,1]
[{"$nulls":3},"商务会话",4]
[{"$nulls":3},"听力训练",2]
[{"$nulls":3},"模拟场景会话",1]
[{"$nulls":3},"合计",23,2]
[null,"公共科目",null,"德育",2,4]
[{"$nulls":3},"体育",2,4,"其中招研究生1名"]
[{"$nulls":3},"音乐",2,4,"其中招研究生1名"]
[{"$nulls":3},"计算机基础",4,7]
[{"$nulls":3},"合计",10,19]
["合计",null,"30个班",null,null,"83人","共招研究生11人"]

{"sheet":"Sheet2","index":1,"n_rows":78,"n_cols":6,"rows_kept":78,"merged":[[0,0,0,5],[2,2,5,2],[6,1,10,1],[6,4,10,4],[10,2,13,2],[14,2,23,2],[23,1,26,1],[23,4,26,4],[27,2,30,2],[30,4,31,4],[31,2,34,2],[34,1,38,1],[34,4,38,4],[38,2,41,2],[41,1,43,1],[41,4,43,4],[43,2,45,2],[44,4,45,4],[46,2,47,2],[48,2,51,2],[48,4,49,4],[50,4,51,4],[52,4,54,4],[54,2,57,2],[58,1,60,1],[58,4,60,4],[61,2,63,2],[61,4,62,4],[63,1,64,1],[64,2,65,2],[66,2,67,2],[68,2,73,2],[68,4,69,4],[70,4,73,4],[74,2,76,2],[75,4,76,4]],"flags":["formulas_cached_only"]}
["各课程教师配置情况表（1500学生、30个班级）"]
["序号","课程名称","所属专业","周课时（节）","教师数","备注"]
[1,"德育","公共科目",2,4]
[2,"计算机基础",null,4,7]
[3,"体育",null,2,4]
[4,"音乐",null,2,4]
[5,"语文","学前教育5",2,5]
[null,null,"城市轨道交通运营管理4",2]
[null,null,"航空服务1",2]
[null,null,"旅游服务与管理1",2]
[null,null,"三校生高考班5",6]
[10,"数学",null,6,3]
[11,"计算机",null,6,3]
[12,"英语",null,6,3]
[13,"幼师英语","学前教育5",2,1]
[14,"幼儿心理学",null,4,2]
[15,"舞蹈",null,2,1]
[16,"学前儿童卫生与保健",null,2,1]
[17,"视唱练耳基础",null,2,1]
[18,"书法",null,2,1]
[19,"基本乐理",null,2,1]
[20,"绘画基础",null,2,1]
[21,"钢琴",null,2,1]
[22,"普通话",null,4,4]
[null,null,"城市轨道交通运营管理4",4]
[null,null,"航空服务1",4]
[null,null,"旅游服务与管理1",4]
[26,"CAD","计算机平面设计2（其中眼镜方向2个班）",4,1]
[27,"美术（素描课）",null,4,1]
[28,"平面广告创意与制作",null,4,1]
[29,"Photoshop CS5",null,6,2]
[30,"Photoshop CS5","电子商务1",6]
[31,"Coreldraw",null,6,1]
[32,"电子商务概论",null,4,1]
[33,"美术",null,2,2]
[null,null,"民间传统工艺1",2]
[null,null,"航空服务1",2]
[null,null,"旅游服务与管理1",2]
[null,null,"城市轨道交通运营管理4",2]
[38,"城市轨道交通概论",null,6,2]
[39,"客运服务心理",null,6,2]
[40,"礼仪",null,2,1]
[null,null,"航空服务1",2]
[null,null,"旅游服务与管理1",2]
[43,"导游业务",null,4,1]
[44,"旅游概论",null,4]
[45,"金工实训","数控技术运用2（其中眼镜方向1个班）",6,2]
[46,"公差与测量",null,4,1]
[47,"财经法规与会计职业道德","会计1",4,1]
[48,"基础会计",null,6]
[49,"会计电算化（用友）",null,6,1]
[50,"会计技能",null,4]
[51,"机械基础","数控技术运用2（其中眼镜方向1个班）",6,1]
[52,"机械基础","汽车运用与维修2",4]
[53,"电工知识及安全用电","金属压力加工1",4]
[54,"技能成就梦想",null,2]
[55,"金属学基础",null,6,1]
[56,"机械基础",null,4]
[57,"机械制图及CAD","数控技术运用2（其中眼镜方向1个班）",6,1]
[null,null,"汽车运用与维修2",4]
[null,null,"金属压力加工1",6]
[60,"汽车电工电子基础","汽车运用与维修",4,1]
[61,"汽车文化",null,2]
[62,"综合实训",null,6,3]
[null,null,"民间传统工艺",18,2]
[64,"艺术概论",null,2,1]
[65,"民航概论","航空服务",6,1]
[66,"民航旅客运输",null,6,1]
[67,"精读","商务日语",6,1]
[68,"语法",null,6]
[69,"模拟场景会话",null,1,1]
[70,"日常会话",null,4]
[71,"商务会话",null,4]
[72,"听力训练",null,2]
[73,"眼视光概论","眼视光",8,1]
[74,"角膜接触镜验配技术",null,4,1]
[75,"验光技术",null,3]
[null,"合计",null,null,83]

{"sheet":"招聘计划","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[0,0,0,7],[2,0,13,0],[14,0,15,0],[16,0,19,0],[20,0,21,0]],"flags":["formulas_cached_only"]}
["应用工程学校课程设置及所需专任教师计划表"]
["学部","序号","招聘岗位","招聘人数","专业或相近专业","学历(学位)要求","其他要求","备注"]
["思想政治和综合基础学部42人",1,"高中语文专任教师",4," 汉语言文学，汉语言相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","具有高中语文教师资格证","其中研究生1名"]
[null,2,"高中数学专任教师",4,"基础数学，应用数学，数学与应用数学相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","具有高中数学教师资格证","其中研究生1名"]
[null,3,"高中英语专任教师",4,"英语语言文学，英语相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","具有高中英语教师资格证","其中研究生1名"]
[null,4,"计算机应用技术专任教师",9,"计算机科学与技术相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","要求有一项专业技能特长","其中研究生1名"]
[null,5,"体育专任教师",2,"体育学，体育教育相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","选修篮球专业，国家一级、二级动员优先","身高1.80米以上，其中研究生1名"]
[null,6,"思想政治专任教师",2,"思想政治教育相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
[null,7,"音乐专任教师",5,"音乐学相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","具有钢琴考级证书或擅长乐器演奏优先","其中研究生1名"]
[null,8,"舞蹈专任教师",2,"舞蹈学相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
[null,9,"美术专任教师",3,"美术学相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下",null,"其中研究生1名"]
[null,10,"心理健康专任教师",2,"心理健康教育相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
[null,11,"学前教育专任教师",2,"学前教育相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
[null,12,"普通话及礼仪专任教师",3,"播音与主持人艺术相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
["信息技术学部5人",13,"平面设计专业专任教师",4,"计算机科学与技术类相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","精通PS、Coreldraw、AE等软件，精通广告制作","其中眼镜制造方向2人，有3年以上眼镜制造经验，学历适当放宽"]
[null,14,"电子商务专任教师",1,"电子商务相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","具有电子商务实操技能","其中研究生1名"]
["加工制造学部15人",15,"机电一体化专任教师",6,"机电一体化类、电气工程及自动化类相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","精通机械制图及CAD等软件，掌握数控机床实践操作技能","其中眼镜制造方向2人，有3年以上眼镜制造经验，学历适当放宽。其中研究生1名"]
[null,16,"金属加工专任教师",5,"金属材料工程相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","掌握金属材料加工技能","其中研究生1名"]
[null,17,"工艺美术专任教师",2,"工艺美术相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","木雕方向，有木雕技能优先"]
[null,18,"汽车运用与维修专任教师",2,"汽车维修工程相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下","掌握汽车维修实践技能","其中研究生1名"]
["现代服务学部4人",19,"城市轨道交通专任教师",2,"城市轨道交通相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
[null,20,"航空服务专任教师",2,"航空服务相关专业","全日制统招本科（含）以上学历、学位（含2020届毕业生），35周岁以下"]
["眼镜学部2人",21,"眼视光专任教师",2,"眼视光技术，眼视光学，眼科学相关专业","全日制统招专科（含）以上学历、学位（含2020届毕业生），35周岁以下","掌握眼视光实践技能","其中研究生1名"]
["农学部 1人",22,"现代农业",1,"现代农业相关专业","全日制统招专科（含）以上学历、学位（含2020届毕业生），35周岁以下",null,"其中研究生1名"]
["合计",null,null,69]
["备注：如果各专业中招聘的研究生不能到位，则将指标用于招聘符合条件的本科毕业生。"]

{"sheet":"确定课程","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"merged":[[0,0,0,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,14],[4,0,17,0],[7,2,8,2],[12,2,13,2],[18,0,22,0],[21,2,22,2],[23,0,34,0],[27,2,29,2],[30,2,31,2],[33,2,34,2],[35,0,38,0],[35,2,38,2],[39,0,41,0],[39,2,41,2]],"flags":["formulas_cached_only"]}
["应用工程学校课程设置及所需专任教师计划表（按30个班级1500学生计算）"]
["学部","课程设置","需配备教师数","周课时总数（节）","班级课时数"]
[{"$nulls":4},"三校生高考班6个","学前教育4个班","计算机平面设计4个班（其中眼镜方向2个班）","城市轨道交通运营管理4个班","数控技术运用4个班（其中眼镜方向2个班）","汽车运用与维修2个班","航空服务1个班","民间传统工艺（雕刻）1","金属压力加工（铜加工）1个班","眼视光2个班","电子商务1个班"]
[null,"合计",69,900,180,120,120,120,120,60,30,30,30,60,30]
["综合基础学部（42人）","语文",4,54,36,8,null,8,null,null,2]
[null,"数学",4,36,36]
[null,"英语",4,44,36,8]
[null,"计算机",9,36,36]
[null,"计算机基础（公共科目）",null,72,null,null,24,16,8,4,4,null,2,8,6]
[null,"体育（公共科目）",2,60,12,8,8,8,8,4,2,2,2,4,2]
[null,"德育（公共科目）",2,60,12,8,8,8,8,4,2,2,2,4,2]
[null,"音乐（公共科目）",5,58,12,16,8,null,8,4,null,2,2,4,2]
[null,"美术",3,32,null,null,16,8,null,null,2,4,null,null,2]
[null,"书法",null,8,null,8]
[null,"普通话及礼仪",3,44,null,16,null,24,null,null,4]
[null,"舞蹈",2,24,null,24]
[null,"学前教育",2,8,null,8]
[null,"心理健康教育",2,26,null,16,null,8,null,null,2]
["信息技术学部（5人）","Photoshop CS5",2,30,null,null,24,{"$nulls":7},6]
[null,"AFTER",1,16,null,null,16]
[null,"平面广告创意与制作",1,16,null,null,16]
[null,"电子商务概论",1,4,{"$nulls":10},4]
[null,"Coreldraw",null,6,{"$nulls":10},6]
["加工制造学部（15人）","机械基础",3,36,{"$nulls":4},24,8,null,null,4]
[null,"机械制图及CAD",3,38,{"$nulls":4},24,8,null,null,6]
[null,"金工实训",2,24,{"$nulls":4},24]
[null,"公差与测量",1,8,{"$nulls":4},8]
[null,"技能成就梦想",2,14,{"$nulls":4},8,4,null,null,2]
[null,"电工知识及安全用电",null,4,{"$nulls":8},4]
[null,"金属学基础",null,6,{"$nulls":8},6]
[null,"汽车电工电子基础",1,8,{"$nulls":5},8]
[null,"汽车文化",null,4,{"$nulls":5},4]
[null,"综合实训",1,12,{"$nulls":5},12]
[null,"艺术概论",2,2,{"$nulls":7},2]
[null,"综合实训",null,18,{"$nulls":7},18]
["现代服务学部（4人）","城市轨道交通概论",4,24,{"$nulls":3},24]
[null,"客运服务心理",null,16,{"$nulls":3},16]
[null,"民航概论",null,6,{"$nulls":6},6]
[null,"民航旅客运输",null,6,{"$nulls":6},6]
["眼镜学部（2人）","角膜接触镜验配技术",2,12,{"$nulls":9},12]
[null,"眼视光概论",null,16,{"$nulls":9},16]
[null,"验光技术",null,12,{"$nulls":9},12]
["农学部1人","现代农业",1]

{"sheet":"遴选计划","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"merged":[[1,0,1,7],[3,0,13,0],[14,0,16,0]],"flags":["formulas_cached_only"]}
["附件1"]
["2020年鹰潭应用工程学校面向社会公开遴选教师岗位表"]
["学部","序号","招聘岗位","招聘人数","专业方向","遴选条件","其他条件","备注"]
["思想政治和综合基础学部17人",1,"高中语文专任教师",2," 汉语言文学，汉语言专业","具有副高及以上职称，45周岁以下；","具有高中语文及以上教师资格证"]
[null,2,"高中数学专任教师",2,"基础数学，应用数学，数学与应用数学专业","具有副高及以上职称，45周岁以下；","具有高中数学及以上教师资格证"]
[null,3,"高中英语专任教师",2,"英语语言文学，英语专业","具有副高及以上职称，45周岁以下；","具有高中英语及以上教师资格证"]
[null,4,"计算机应用技术专任教师",4,"计算机科学与技术专业","具有副高及以上职称，45周岁以下；","具有高中计算机及以上教师资格证"]
[null,5,"体育专任教师",1,"体育学，体育教育专业","具有副高及以上职称，45周岁以下；","具有高中体育及以上教师资格证"]
[null,6,"思想政治专任教师",1,"思想政治教育专业","具有副高及以上职称，45周岁以下；","具有高中思想政治及以上教师资格证"]
[null,7,"音乐专任教师",1,"音乐学专业","具有副高及以上职称，45周岁以下；","具有高中音乐及以上教师资格证"]
[null,8,"美术专任教师",1,"美术学专业","具有副高及以上职称，45周岁以下；","具有高中美术及以上教师资格证"]
[null,9,"心理健康专任教师",1,"心理健康教育专业","具有副高及以上职称，45周岁以下；","具有高中心理健康及以上教师资格证"]
[null,10,"学前教育专任教师",1,"学前教育专业","具有副高及以上职称，45周岁以下；","具有高中学前教育及以上教师资格证"]
[null,11,"普通话及礼仪专任教师",1,"播音与主持人艺术专业","具有副高及以上职称，45周岁以下；"]
["加工制造学部5人",12,"机电一体化专任教师",2,"机电一体化类、电气工程及自动化类专业","具有副高及以上职称，45周岁以下；"]
[null,13,"金属加工专任教师",2,"金属材料工程专业","具有中级职称，本科及以上学历，45周岁以下；"]
[null,14,"汽车运用与维修专任教师",1,"汽车维修工程专业","具有中级职称，本科及以上学历，45周岁以下；"]
["现代服务学部2人",15,"旅游管理专任教师",2,"旅游管理专业","具有副高及以上职称，45周岁以下1人；具有中级职称，本科及以上学历，45周岁以下1人；"]
["眼镜学部1人",16,"眼视光专任教师",1,"眼视光技术，眼视光学，眼科学专业","具有中级职称，本科及以上学历，45周岁以下；"]
["合计",null,null,25]