{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["四生管理系统需求汇总","四生系统之研究生模块需求（科教原版）","四生系统之住培生模块需求（科教原版）","四生系统之实习生进修生模块需求（科教原版）","技能中心管理系统需求（科教原版）"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"四生管理系统需求汇总","index":0,"n_rows":79,"n_cols":5,"rows_kept":79,"merged":[[0,0,0,4],[2,0,42,0],[2,1,42,1],[2,2,10,2],[2,3,4,3],[2,4,4,4],[5,3,10,3],[5,4,10,4],[11,2,22,2],[23,2,30,2],[25,3,27,3],[29,3,30,3],[31,2,42,2],[32,3,36,3],[37,3,38,3],[39,3,40,3],[43,0,49,0],[43,1,49,1],[43,2,49,2],[50,0,78,0],[50,1,78,1],[50,2,78,2],[51,3,54,3],[51,4,54,4],[57,3,58,3],[57,4,58,4],[59,3,60,3],[59,4,60,4],[61,3,65,3],[61,4,65,4],[61,5,65,5],[69,3,71,3],[69,4,71,4]],"flags":["formulas_cached_only"]}
["科教科教学培训管理系统需求"]
["序号","系统名称","项目名称","模块","需求描述"]
[1,"科教科“四生”教学培训管理系统","研究生管理\n（以“科教原版”需求为准）","人员管理","1.管理员：管理员资料，一个总管理员账号，下设多个单独的子管理员账号\n2.导师：由管理员添加，区分内外院，设定师资角色身份;导师可上传个人信息，由管理员审核。\n3.学生：区分内外院学生，登记身份资料，各类培训与考核成绩档案管理"]
[]
[]
[{"$nulls":3},"培养过程管理","第一学期：1.学籍注册：研究生网上注册，学籍信息注册核对。2.网上选课：导师指导，网上选课，导师签字，上交备案。3.课程学习：专业学位（进入临床基地规培，规培时间33个月。科硕、专硕研究生院学习。导师开设专业课，并指导经典参考书作为自学教材。可对教师开放，与场地预约关联，由管理员审核。4.学术活动：上传参加学校和医院等各级组织的学术活动，可下载《研究生参加学术活动情况登记表》，讲座时及时登记。5.培养计划：在导师指导下，依据《全日制研究生培养手册》填写培养方案，一式三份交医院汇总后报研究生院。\n第二学期：1.课程成绩：提醒登录学校研究生管理系统查询，在本院系统上上传成绩。有不合格的可跟下一年级重修或申请补考并参加相应相关考试，不单独组织补考。提示学生需在研究生院管理系统选课方能录入成绩。提示考试安排留意任课教师通知和研究生院网站通知。2.课程学习：科学学位研究生在导师指导下按照培养计划参加学习和教学实践。专业学位研究生继续完成住院医师规范化培训轮科学习。3.开题准备：完成文献综述。做预实验或调查。做好开题前期的各项准备工作\n第三学期：1.课程成绩：提醒登录学校研究生管理系统查询，在本院系统上上传成绩。有不合格的可跟下一年级重修或申请补考并参加相应相关考试，不单独组织补考。提示学生需在研究生院管理系统选课方能录入成绩。提示考试安排留意任课教师通知和研究生院网站通知。2.提前攻博：导师推荐，符合条件的研究生可申请提前攻博（科学学位博士）。通过资格审核研究生按当年《博士研究生招生简章》报名3.开题准备：完成文献综述。做预实验或调查。做好开题前期的各项准备工作。\n第四学期：课题研究:上报在导师指导下进行研究进展，定期做好实验记录和分析.如改变研究计划，需重新开题。中期考核:课程成绩、开题报告、学术活动等情况院所系统审核后统一报送研究生院。中期考核合格的研究生，方有资格参加下一年度国家奖学金，学业奖学金一.二等奖，其他优秀研究生奖学金评学。\n第五学期：1.课题研究：在导师指导下继续论文研究，及时解决研究中遇到的问题。2.专业课考试：专业课试题由导师命题、阅卷。上报中期考核成绩，上传中期考核试卷。3.材料审核：课程成绩、开题报告、学术活动、发表论文等上交科教科审核后统一报送研究生院。培养材料审核不通过，不能答辩\n第六学期：1.学位论文：在导师指导下，按照《研究生学位论文基本要求与写作规范》要求完成学位论文，及时上传学位论文，送统计学检测、查重、盲审2.临床考核：专业硕士学位研究生参加住院医师规范化培训结业考核。规培结业考核等同于专业学位研究生临床能力综合考核。申请临床专业学位博士研究生参加临床考核，交临床考核材料到科教科，由科教科统一提交研究生院。3.论文预答辩：博士研究生初步完成学位论文课题研究工作后，及时撰写学位论文初稿，经导师审阅后，在正式答辩前前2个月进行学位论文预答辩（组织预答辩前必须提交预答辩申请）4.论文答辩：根据申请学位答辩名单，组织论文答辩委员会，进行论文答辩（上传答辩照片）5.学位评定：各学位评定分委会和校学位评定委员会根据答辩结果表决授学位决定（下载学位申报书）6学位授予：上传毕业证和学位证书PDF版和相关照片"]
[]
[]
[]
[]
[]
[null,null,"住院医师规范化培训管理系统\n（以“科教原版”需求为准）","人员管理","登记医院管理员，专业基地主任，教学主任，专业基地秘书，带教老师，住培医师（可表格导入基地、科室各级管理人员和住培学员的名单，也可逐个添加，老师上传师资培训证书，生成住培师资库）\n住培学员结业后上传结业考核成绩，规培证书留档）"]
[{"$nulls":3},"培训管理","学员报到,学员宿舍安排,学员轮转计划安排,学员轮转计划安排,学员补轮转安排,学员暂停管理,学员退培管理,审核管理,学员考试成绩,学员轮转登记手册打印,（生成个人PDF版轮科手册）医疗差错及事故记录,学员薪资记录,定期考核、年度考核"]
[{"$nulls":3},"出科管理","1.出科成绩导入学员姓名、培训科室、考核次数、考核分数。2.出科打印"]
[{"$nulls":3},"培训园地","学生培训：要求系统自带24种执医考操作视频和基本手术视频和各专业的考题，可以上传学习课件，自行学习，设置考核试题，自动记录考试成绩\n师资培训：可上传教师培训课件（视频或替他文件，考题）推送培训考试通知给老师，完成后可生成培训证书\n"]
[{"$nulls":3},"评价管理","对学员评价,对带教老师评价,对责任导师评价,对科室评价,对专业基地评价,对专业基地管理员评价,对医院管理员的评价,评价查询"]
[{"$nulls":3},"教学活动","添加入科教育,添加教学查房,添加病例讨论,添加小讲课,添加公共课程,添加技能培训,添加岗前培训,业务学习,科室主任大查房,教学活动查询,教学活动评价查询，（要求导入教学培训计划，实施时可点击实施的老师信息，时间，参加的同学，上传教学记录，可生成评价二维码推送给学生，"]
[{"$nulls":3},"查询管理","学员轮转计划查询,学员轮转科室安排表,轮转科室未报到学员表,审查查询,学员出勤情况查询,学员培训情况综合查询,科室工作监督,带教老师工作监督"]
[{"$nulls":3},"学术科研登记","学术科研登记审核"]
[{"$nulls":3},"推荐材料","申请推荐材料，查看推荐材料"]
[{"$nulls":3},"现场问卷调查","1.调查问卷设置。2.问卷填写。3.调查问卷统计分析。4.现场调查问卷查看"]
[{"$nulls":3},"学员薪酬绩效管理","1.休假(权重10%）:按医院规定休假的得100分，每超出应休天数1天的扣25分，不设下限2.出科理论考核（30%）:出科理论考核及格的得100分，考试分数大于90分此项加10分/次，85-90分之间加5分/次，不及格的扣20分/次3.出科技能考核（20%）:出科技能考核及格的得100分，考试分数大于90分此项加10分/次，85-90分之间加5分/次，不及格的扣20分/次4.出科综合考核（40%）:1.临床专业的：临床考核手册登记完成，考核占70%。2.形成性评价完成占30%。3.非临床专业完成考核手册登记，考核及格的得 100分，不及格不得分"]
[{"$nulls":3},"师资教学绩效管理","1.带教学员统计。2.教学活动统计。3.教学绩效考核。（要求可以统计老师教学活动的功能和老师带教的周数）"]
[null,null,"进修生管理\n（以“科教原版”需求为准）","学员资料","姓名，性别，单位，部门，职称，职务，学历，政治面貌，身份证号码，电话号码，住址，"]
[{"$nulls":3},"申请审批","进修科室，进修起止时间，学习性质，主要工作经历，科教科审批，接收科室审批，审批通过，生成录取通知书和带教通知书，申请调整审批"]
[{"$nulls":3},"轮科管理","按照申请科室，当月入科的为可入科，已审批未到时间为待入科，还有已入科，已出科等分类"]
[{"$nulls":4},"学习培训记录，参加的教学活动，或手工录入的学习内容"]
[{"$nulls":4},"出科考成绩，自我鉴定，带教老师意见，科室意见，科教科意见，推送评价表，可由科教科直接发起结束"]
[{"$nulls":3},"结业鉴定","审核学习完成，生成证书"]
[{"$nulls":3},"考勤请假","学员申请，带教审批，秘书审批，主任审批，科教科审批，对应到排班"]
[{"$nulls":4},"排班，支持excel导入"]
[null,null,"实习生管理\n（以“科教原版”需求为准）","学员资料","姓名，性别，院校，专业，学历，政治面貌，身份证号码，电话号码，住址，工作站账号，支持excel导入，导入姓名电话，学生各自登录注册，完善其他资料，允许后期修改资料，但修改后科教科有收到提醒"]
[{"$nulls":3},"轮科管理","按要求自定义排班，指定期限内对应科室方可操作该生信息"]
[{"$nulls":4},"按照轮科安排，分为已入科，可入科，待入科三类，（已出科只显示不可操作）当周只能拉入可入科人员，其余两类不可以拉入，可申请要求拉入，由科教科权限操作拉入科并确定日期，发送入科教育至学生，学生阅读点击已阅，并弹出带教老师资料（照片+简介）（拉入科时同时安排带教老师）"]
[{"$nulls":4},"学生入科，秘书拉入科室，安排带教老师，带教老师最多可以登记3个，但只有第一个计算工作量，主带教1个，副带教2个"]
[{"$nulls":4},"病历书写评分，mini-cex,dops，支持不同专业学生的个性化选择，生成二维码填写"]
[{"$nulls":4},"理论考试，技能考试（基础技能考核，病例考核），鉴定，支持不同专业学生的个性化选择，推送评价表"]
[{"$nulls":3},"考勤请假","学员申请，带教审批，秘书审批，主任审批，科教科审批，对应到排班"]
[{"$nulls":4},"排班，支持excel导入，复制"]
[{"$nulls":3},"奖惩登记","登记获奖记录，志愿者工作情况，集体活动工作人员等"]
[{"$nulls":4},"登记各样迟到早退，纪律差等内容，科室发起，科教科复核，反馈学生确认"]
[{"$nulls":3},"轮科档案","生成PDF"]
[{"$nulls":3},"结业鉴定","轮科对比，入科出科信息，奖惩信息，生成实习证明（证明+明细），可进行提前结束操作"]
[2,"技能中心管理系统","技能培训管理\n（以“科教原版”需求为准）","人员管理","1.管理员：管理员资料，一个总管理员账号，下设多个单独的子管理员账号\n2.教师：由管理员添加，区分内外院，设定师资角色身份;教师可上传个人信息，由管理员审核。\n3.学生：区分内外院学生，区分医生护士职位，登记身份资料，各类培训与考核成绩档案管理"]
[{"$nulls":3},"场地管理","详见“技能中心管理系统（科教原版）”"]
[{"$nulls":3},"物品管理","详见“技能中心管理系统（科教原版）”"]
[{"$nulls":3},"课程及考核过程管理","1.技能管理员申请开课，当中可能指定教师和学员，并且需要占用科室当地和控制人数\n2.通知指定的学员或教师开课信息（开课时间，结束时间，课程主题）\n3.学员报名，如果没有指定的学员可以自己主动报名参与考试\n4.教师报名，如果没有指定的教师可以自己主动报名参与考试\n5.学员签到\n6.教师签到\n7.教师评分，保存学员的分值档案\n具体详见“技能中心管理系统（科教原版）”“课程管理”"]
[{"$nulls":3},"分析系统","具体详见“技能中心管理系统（科教原版）”“课程管理”"]
[{"$nulls":3},"学员界面","具体详见“技能中心管理系统（科教原版）”“课程管理”"]
[{"$nulls":3},"教学界面","具体详见“技能中心管理系统（科教原版）”“课程管理”"]
[null,"共性需求","其他共性需求","带教老师","工号，职称，职务，学历，执业取得时间，教研组，教研室，科教科审核，审核通过的名单方可登记工作量"]
[{"$nulls":3},"培训","支持手工录入或EXCEL 导入，包括培训记录，会议参加记录"]
[]
[]
[]
[{"$nulls":3},"考核","登记录入，或可生成二维码供多人手机填报"]
[{"$nulls":3},"评优评先","登记录入，或可生成二维码供多人手机填报"]
[{"$nulls":3},"带教周数统计","自动按照入科带教师资安排统计，按周统计，"]
[]
[{"$nulls":3},"奖惩登记","各项参赛，活动奖励，教学科研论文发表情况，审核确定"]
[]
[{"$nulls":3},"理论授课","支持EXCEL导入，先建立活动计划，举办时点击举办，同时登记信息，课程名称，主持人，学历，职称，计划举办时间，实际举办时间，参加学员（现场动态二维码签到），活动内容登记（输入或PDF导入），照片上传，现场显示评价二维码，无填写的，课后自动推送"]
[]
[]
[]
[]
[{"$nulls":3},"科教科/教研室教学工作会议","支持EXCEL导入，课程名称，主持人，参加人员，举办时间，活动内容登记（输入或PDF导入），照片上传"]
[{"$nulls":3},"教学工作检查督导考核","登记录入，或可生成二维码供多人手机填报"]
[{"$nulls":3},"教学满意度调查","分类收集，统计，分析"]
[{"$nulls":3},"教学秘书","1.工号，职称，职务，学历，个人，教研组，教研室，科教科审核，审核通过的名单方可登记工作量\n2.个人，教研组，教研室，科教科审核，审核通过的名单方可登记工作量，\n3.登记录入，或可生成二维码供多人手机填报"]
[]
[]
[{"$nulls":3},"职能部门","新增，删除，部门，恢复初始密码"]
[{"$nulls":3},"教研室","新增，删除，教研室，教研组，设置教学管理人员岗位，恢复初始密码"]
[{"$nulls":4},"按照个性化需求，筛选统计出周期内，某人，某部门，的工作量或评分成绩等，生成报表"]
[{"$nulls":3},"评价表","质量评价表"]
[{"$nulls":3},"评分表","考试评分表"]
[{"$nulls":3},"调查表","各类满意度调查表"]
[{"$nulls":3},"收集表","信息收集"]

{"sheet":"四生系统之研究生模块需求（科教原版）","index":1,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[0,0,0,4],[2,0,52,0],[2,1,6,1],[3,2,4,2],[5,2,6,2],[7,1,52,1],[7,2,18,2],[7,3,8,3],[9,3,12,3],[13,3,16,3],[19,2,27,2],[19,3,22,3],[19,5,22,5],[23,3,24,3],[23,5,27,5],[25,3,27,3],[28,2,36,2],[28,3,31,3],[32,3,33,3],[32,5,33,5],[34,3,36,3],[37,2,40,2],[37,3,38,3],[39,3,40,3],[41,2,44,2],[42,3,43,3],[42,5,43,5],[45,2,52,2],[45,5,47,5],[46,3,47,3],[48,3,49,3],[48,5,49,5]],"flags":["formulas_cached_only"]}
["研究生院内轮转培训管理系统要求"]
["一级系统","二级系统","三级系统","四级系统","要求","备注"]
["研究生管理","人员管理","管理员",null,"管理员资料，一个总管理员账号，下设多个单独的子管理员账号"]
[null,null,"导师","院内","由管理员添加，设定师资角色身份；\n院内导师可上传个人信息，由管理员审核。"]
[{"$nulls":3},"院外","由管理员添加，设定师资角色身份；院外导师信息是否有端口自己输入个人资料"]
[null,null,"学生","院内","学生身份资料，各类培训与考核成绩档案管理"]
[{"$nulls":3},"院外","学生身份资料，各类培训与考核成绩档案管理"]
[null,"培养过程管理 ","第一学期","学籍注册","研究生网上注册"]
[{"$nulls":4},"学籍信息注册核对"]
[{"$nulls":3},"网上选课","1.导师指导"]
[{"$nulls":4},"2.网上选课"]
[{"$nulls":4},"3.导师签字"]
[{"$nulls":4},"4.上交备案"]
[{"$nulls":3},"课程学习","1.专业学位（进入临床基地规培，规培时间33个月"]
[{"$nulls":4},"2.科硕、专硕研究生院学习"]
[{"$nulls":4},"3.导师开设专业课，并指导经典参考书作为自学教材"]
[{"$nulls":4},"4.可对教师开放，与场地预约关联，由管理员审核"]
[{"$nulls":3},"学术活动","上传参加学校和医院等各级组织的学术活动，可下载《研究生参加学术活动情况登记表》，讲座时及时登记。"]
[{"$nulls":3},"培养计划","在导师指导下，依据《全日制研究生培养手册》填写培养方案，一式三份交医院汇总后报研究生院。","开学半年内完成"]
[null,null,"第二学期","课程成绩","1.提醒登录学校研究生管理系统查询，在本院系统上上传成绩","开学第一周"]
[{"$nulls":4},"2.有不合格的可跟下一年级重修或申请补考并参加相应相关考试，不单独组织补考"]
[{"$nulls":4},"3.提示学生需在研究生院管理系统选课方能录入成绩"]
[{"$nulls":4},"4.提示考试安排留意任课教师通知和研究生院网站通知"]
[{"$nulls":3},"课程学习","1.科学学位研究生在导师指导下按照培养计划参加学习和教学实践","全学期"]
[{"$nulls":4},"2.专业学位研究生继续完成住院医师规范化培训轮科学习"]
[{"$nulls":3},"开题准备","1.完成文献综述"]
[{"$nulls":4},"2.做预实验或调查"]
[{"$nulls":4},"3.做好开题前期的各项准备工作"]
[null,null,"第三学期","课程成绩","1.提醒登录学校研究生管理系统查询，在本院系统上上传成绩"]
[{"$nulls":4},"2.有不合格的可跟下一年级重修或申请补考并参加相应相关考试，不单独组织补考"]
[{"$nulls":4},"3.提示学生需在研究生院管理系统选课方能录入成绩"]
[{"$nulls":4},"4.提示考试安排留意任课教师通知和研究生院网站通知"]
[{"$nulls":3},"提前攻博","1.导师推荐，符合条件的研究生可申请提前攻博（科学学位博士）","11月底"]
[{"$nulls":4},"2.通过资格审核研究生按当年《博士研究生招生简章》报名"]
[{"$nulls":3},"课题开题","1.开题申请（下载表格，上传导师，科教科审核，研究生院签名审批表）开题申请的基本条件为完成综述和部分预实验"]
[{"$nulls":4},"2.在导师的指导下，研究生撰写开题报告"]
[{"$nulls":4},"3.通过开题答辩后一周内开题综述、开题报告与开题评议表PDF版上传系统。开题相关照片"]
[null,null,"第四学期","课题研究","1.上报在导师指导下进行研究进展，定期做好实验记录和分析"]
[{"$nulls":4},"2.如改变研究计划，需重新开题"]
[{"$nulls":3},"中期考核","1.课程成绩、开题报告、学术活动等情况院所系统审核后统一报送研究生院。"]
[{"$nulls":4},"2.中期考核合格的研究生，方有资格参加下一年度国家奖学金，学业奖学金一.二等奖，其他优秀研究生奖学金评学。"]
[null,null,"第五学期","课题研究","1.在导师指导下继续论文研究，及时解决研究中遇到的问题"]
[{"$nulls":3},"专业课考试","1.专业课试题由导师命题、阅卷。","11月"]
[{"$nulls":4},"2.上报中期考核成绩，上传中期考核试卷。"]
[{"$nulls":3},"材料审核","1.课程成绩、开题报告、学术活动、发表论文等上交科教科审核后统一报送研究生院。培养材料审核不通过，不能答辩","12月"]
[null,null,"第六学期","学位论文","在导师指导下，按照《研究生学位论文基本要求与写作规范》要求完成学位论文，及时上传学位论文，送统计学检测、查重、盲审","3月初"]
[{"$nulls":3},"临床考核","1.专业硕士学位研究生参加住院医师规范化培训结业考核。规培结业考核等同于专业学位研究生临床能力综合考核。"]
[{"$nulls":4},"2.申请临床专业学位博士研究生参加临床考核，交临床考核材料到科教科，由科教科统一提交研究生院"]
[{"$nulls":3},"论文预答辩","博士研究生初步完成学位论文课题研究工作后，及时撰写学位论文初稿，经导师审阅后，在正式答辩前前2个月进行学位论文预答辩","3月底"]
[{"$nulls":4},"（组织预答辩前必须提交预答辩申请）"]
[{"$nulls":3},"论文答辩","根据申请学位答辩名单，组织论文答辩委员会，进行论文答辩（上传答辩照片）","5月份"]
[{"$nulls":3},"学位评定","各学位评定分委会和校学位评定委员会根据答辩结果表决授学位决定（下载学位申报书）","6月中下旬"]
[{"$nulls":3},"学位授予","上传毕业证和学位证书PDF版和相关照片","6月底"]
[null,"评优工作",null,"评优申请","下载上传评优遴选表格"]

{"sheet":"四生系统之住培生模块需求（科教原版）","index":2,"n_rows":70,"n_cols":6,"rows_kept":70,"merged":[[0,0,0,4],[2,0,6,0],[2,1,7,1],[14,2,15,2],[28,5,31,5],[32,5,36,5],[41,5,42,5],[51,5,53,5],[57,5,59,5],[60,5,61,5]],"flags":["formulas_cached_only"]}
["住院医师规范化培训管理系统要求"]
["一级系统","二级系统","三级系统","四级系统","要求","备注"]
["住院医师规范化培训管理系统要求","人员管理","医院管理员","姓名、账号","可添加、查找、导出"]
[null,null,"专业基地主任","姓名、账号","可添加、查找、导出"]
[null,null,"教学主任","姓名、账号","可添加、查找、导出"]
[null,null,"专业基地秘书","姓名、账号","可添加、查找、导出"]
[null,null,"带教老师","姓名、账号","可添加、查找、导出"]
[null,null,"住培医师","姓名、账号","可添加、查找、导出"]
[null,"培训管理","学员报到","学员报到及带教老师安排/带教老师更换/审核管理/学员考勤","设置科室管理员医院管理员权限"]
[null,null,"学员宿舍安排","单个学员安排/批量学员安排","可添加、查找、导出"]
[null,null,"学员轮转计划安排","自动分配轮转/导入轮转安排/手工安排轮转"]
[null,null,"学员补轮转安排","添加补轮转（姓名、轮转科室、轮转时间）"]
[null,null,"学员暂停管理","添加暂停信息"]
[null,null,"学员退培管理","新增退培学员"]
[null,null,"审核管理","请假审核/出科审核/轮转手册审核/销假审核/结业审核/"]
[{"$nulls":3},"学员教学活动审核/证书审核/年度考核审核"]
[null,null,"学员考试成绩","出科/结业/定期考核/年度考核/各个科室/文件导入成绩/导出学员成绩"]
[null,null,"学员轮转登记手册打印","学员姓名、登录号、入培年限、培训专业"]
[null,null,"医疗差错及事故记录","学员姓名、登录号、入培年限、培训专业、处理日期、类别、处理意见"]
[null,null,"学员薪资记录","学员姓名、登录号、薪资类型、薪资金额、发放时间","可导入、导出薪酬记录"]
[null,null,"定期考核","学员姓名、培训科室、考核次数、考核平均分"]
[null,"出科管理","出科成绩导入","学员姓名、培训科室、考核次数、考核分数"]
[null,null,"出科打印",null,"学员和各级管理员均可打印轮科手册"]
[null,"360度评价","对学员评价"]
[null,null,"对带教老师评价"]
[null,null,"对责任导师评价"]
[null,null,"对科室评价"]
[null,null,"对专业基地评价"]
[null,null,"对专业基地管理员评价"]
[null,null,"对医院管理员的评价"]
[null,null,"评价查询"]
[null,"教学活动","添加入科教育"]
[null,null,"添加教学查房"]
[null,null,"添加病例讨论"]
[null,null,"添加小讲课"]
[null,null,"添加公共课程"]
[null,null,"添加技能培训"]
[null,null,"添加岗前培训"]
[null,null,"业务学习"]
[null,null,"科室主任大查房"]
[null,null,"教学活动查询"]
[null,null,"教学活动评价查询"]
[null,"查询管理","学员轮转计划查询"]
[null,null,"学员轮转科室安排表"]
[null,null,"轮转科室未报到学员表"]
[null,null,"审查查询"]
[null,null,"学员出勤情况查询"]
[null,null,"学员培训情况综合查询"]
[null,null,"科室工作监督"]
[null,null,"带教老师工作监督"]
[null,"学术科研登记","学术科研登记审核"]
[null,"即时消息管理","即时消息管理"]
[null,null,"即时消息列表"]
[null,"交流区","发言"]
[null,null,"查看交流记录"]
[null,"推荐材料","我要推荐"]
[null,null,"查看推荐材料"]
[null,"现场问卷调查","调查问卷设置"]
[null,null,"问卷填写"]
[null,null,"调查问卷统计分析"]
[null,null,"现场调查问卷查看"]
[null,"学员薪酬绩效管理","休假(权重10%）",null,"按医院规定休假的得100分，每超出应休天数1天的扣25分，不设下限"]
[null,null,"出科理论考核（30%）",null,"出科理论考核及格的得100分，考试分数大于90分此项加10分/次，85-90分之间加5分/次，不及格的扣20分/次"]
[null,null,"出科技能考核（20%）",null,"出科技能考核及格的得100分，考试分数大于90分此项加10分/次，85-90分之间加5分/次，不及格的扣20分/次"]
[null,null,"出科综合考核（40%）",null,"1.临床专业的：临床考核手册登记完成，考核占70%。2.形成性评价完成占30%。3.非临床专业完成考核手册登记，考核及格的得 100分，不及格不得分"]
[null,"师资教学绩效管理","带教学员统计"]
[null,null,"教学活动统计"]
[null,null,"教学绩效考核"]
[null,"培训园地","学员培训","要求系统自带24种执医考操作视频和基本手术视频和各专业的考题，可以上传学习课件，自行学习，设置考核试题，自动记录考试成绩"]
[null,null,"师资培训","可上传教师培训课件（视频或替他文件，考题）推送培训考试通知给老师，完成后可生成培训证书"]

{"sheet":"四生系统之实习生进修生模块需求（科教原版）","index":3,"n_rows":59,"n_cols":9,"rows_kept":59,"merged":[[0,0,0,8],[2,0,9,0],[4,1,6,1],[4,2,6,2],[8,1,9,1],[8,2,9,2],[10,0,20,0],[11,1,14,1],[11,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[21,0,31,0],[22,1,25,1],[22,2,25,2],[28,1,29,1],[28,2,29,2],[30,1,31,1],[30,2,31,2],[32,0,36,0],[32,1,36,1],[32,4,36,4],[32,5,36,5],[32,6,36,6],[32,7,36,7],[37,0,42,0],[40,1,42,1],[40,2,42,2],[43,0,44,0],[45,0,46,0],[48,0,51,0],[48,1,51,1],[52,0,54,0],[55,0,56,0],[57,0,58,0],[57,1,58,1]],"flags":["formulas_cached_only"]}
["教学管理系统要求"]
["一级系统",null,"二级系统","三级系统","要求","科教科","主任、秘书","老师","学员"]
["进修生管理",null,"学员资料",null,"姓名，性别，单位，部门，职称，职务，学历，政治面貌，身份证号码，电话号码，住址，","编辑、导入导出","查看","查看","查看"]
[null,null,"申请审批","审批","进修科室，进修起止时间，学习性质，主要工作经历，科教科审批，接收科室审批，审批通过，生成录取通知书和带教通知书，申请调整审批","编辑、审核","审核","查看","查看"]
[null,null,"轮科管理","入科","按照申请科室，当月入科的为可入科，已审批未到时间为待入科，还有已入科，已出科等分类","编辑、处理","处理","处理","查看"]
[{"$nulls":3},"过程","学习培训记录，参加的教学活动，或手工录入的学习内容","编辑","编辑","编辑","编辑"]
[{"$nulls":3},"出科","出科考成绩，自我鉴定，带教老师意见，科室意见，科教科意见，推送评价表，可由科教科直接发起结束","编辑","编辑","编辑","编辑"]
[null,null,"结业鉴定",null,"审核学习完成，生成证书","编辑","查看","查看","查看"]
[null,null,"考勤请假","请假","学员申请，带教审批，秘书审批，主任审批，科教科审批，对应到排班","编辑、审核","编辑、审核","编辑、审核","发起"]
[{"$nulls":3},"排班","排班，支持excel导入","编辑、审核","编辑、审核","编辑、审核","发起"]
["实习生管理",null,"学员资料",null,"姓名，性别，院校，专业，学历，政治面貌，身份证号码，电话号码，住址，工作站账号，支持excel导入，导入姓名电话，学生各自登录注册，完善其他资料，允许后期修改资料，但修改后科教科有收到提醒","编辑、导入导出","查看","查看","查看"]
[null,null,"轮科管理","轮科","按要求自定义排班，指定期限内对应科室方可操作该生信息","编辑、审核","编辑、审核","编辑","查看"]
[{"$nulls":3},"入科","按照轮科安排，分为已入科，可入科，待入科三类，（已出科只显示不可操作）当周只能拉入可入科人员，其余两类不可以拉入，可申请要求拉入，由科教科权限操作拉入科并确定日期，发送入科教育至学生，学生阅读点击已阅，并弹出带教老师资料（照片+简介）（拉入科时同时安排带教老师）\n学生入科，秘书拉入科室，安排带教老师，带教老师最多可以登记3个，但只有第一个计算工作量，主带教1个，副带教2个","编辑、处理","处理","查看","查看"]
[{"$nulls":3},"过程","病历书写评分，mini-cex,dops，支持不同专业学生的个性化选择，生成二维码填写","编辑","编辑","编辑","编辑"]
[{"$nulls":3},"出科","理论考试，技能考试（基础技能考核，病例考核），鉴定，支持不同专业学生的个性化选择，推送评价表","编辑、审核","编辑、审核","编辑","查看"]
[null,null,"考勤请假","请假","学员申请，带教审批，秘书审批，主任审批，科教科审批，对应到排班","编辑、审核","编辑、审核","编辑、审核","发起"]
[{"$nulls":3},"排班","排班，支持excel导入，复制","编辑、审核","编辑、审核","编辑、审核","发起"]
[null,null,"奖惩登记","奖励","登记获奖记录，志愿者工作情况，集体活动工作人员等","编辑、审核","编辑、审核","编辑、审核","发起"]
[{"$nulls":3},"惩罚","登记各样迟到早退，纪律差等内容，科室发起，科教科复核，反馈学生确认","编辑、审核","编辑、审核","编辑、审核","审核"]
[null,null,"轮科档案",null,"生成PDF"]
[null,null,"结业鉴定",null,"轮科对比，入科出科信息，奖惩信息，生成实习证明（证明+明细），可进行提前结束操作","编辑","查看","查看","查看"]
["师资管理",2,"带教老师","准入","工号，职称，职务，学历，执业取得时间，教研组，教研室，科教科审核，审核通过的名单方可登记工作量","编辑、导入导出","查看","查看","/"]
[null,null,"培训","个人","支持手工录入或EXCEL 导入","编辑、导入导出","编辑、审核","查看","/"]
[{"$nulls":3},"教研组","支持手工录入或EXCEL 导入","编辑、导入导出","编辑、审核","查看","/"]
[{"$nulls":3},"教研室","支持手工录入或EXCEL 导入","编辑、导入导出","编辑、审核","查看","/"]
[{"$nulls":3},"科教科","支持手工录入或EXCEL 导入，包括培训记录，会议参加记录","编辑、导入导出","编辑、审核","查看","/"]
[null,null,"考核",null,"登记录入，或可生成二维码供多人手机填报",{"$nulls":3},"/"]
[null,null,"评优评先",null,"登记录入，或可生成二维码供多人手机填报",{"$nulls":3},"/"]
[null,1,"带教周数统计","实习生","自动按照入科带教师资安排统计，按周统计，","编辑、导入导出","编辑、审核","查看","/"]
[{"$nulls":3},"进修生","自动按照入科带教师资安排统计，按周统计，","编辑、导入导出","编辑、审核","查看","/"]
[null,null,"奖惩登记","奖励","各项参赛，活动奖励，教学科研论文发表情况，审核确定","编辑、审核","编辑、审核","编辑、审核","/"]
[{"$nulls":3},"惩罚","教学差错，发起，审批，处理意见，确认","编辑、审核","编辑、审核","编辑、审核","/"]
["教学活动管理",7,"理论授课",null,"支持EXCEL导入，先建立活动计划，举办时点击举办，同时登记信息，课程名称，主持人，学历，职称，计划举办时间，实际举办时间，参加学员（现场动态二维码签到），活动内容登记（输入或PDF导入），照片上传，现场显示评价二维码，无填写的，课后自动推送","编辑、审核","编辑、审核","编辑","/"]
[null,null,"教学查房",{"$nulls":5},"/"]
[null,null,"教学病例讨论",{"$nulls":5},"/"]
[null,null,"操作技能带教",{"$nulls":5},"/"]
[null,null,"其他",{"$nulls":5},"/"]
["教研工作管理",null,"科教科/教研室教学工作会议",null,"支持EXCEL导入，课程名称，主持人，参加人员，举办时间，活动内容登记（输入或PDF导入），照片上传","编辑、审核","编辑、审核","查看","/"]
[null,null,"教学工作检查督导考核",null,"登记录入，或可生成二维码供多人手机填报","编辑、审核","编辑、审核","查看","/"]
[null,null,"教学满意度调查",null,"分类收集，统计，分析","编辑、审核","编辑、审核","查看","/"]
[null,6,"教学秘书","聘任","工号，职称，职务，学历，个人，教研组，教研室，科教科审核，审核通过的名单方可登记工作量","编辑、审核","编辑、审核","查看","/"]
[{"$nulls":3},"更换","个人，教研组，教研室，科教科审核，审核通过的名单方可登记工作量，","编辑、审核","编辑、审核","查看","/"]
[{"$nulls":3},"考核","登记录入，或可生成二维码供多人手机填报","编辑、审核","编辑、审核","查看","/"]
["部门管理",null,"职能部门",null,"新增，删除，部门，恢复初始密码","编辑、审核","查看","查看","/"]
[null,null,"教研室",null,"新增，删除，教研室，教研组，设置教学管理人员岗位，恢复初始密码","编辑、审核","查看","查看","/"]
["人员管理",null,"院外",null,"excel导入各类人员信息，自动辨别即将来院，在院，离院，离院后3个月不可操作，首次登陆绑定微信号，恢复初始密码","编辑、审核","查看","查看","/"]
[null,null,"院内",null,"直接与企业微信联通，可修改补充工号姓名以外的信息，直接验证跳转，不需要另外登录","编辑、审核","查看","查看","/"]
["统计分析",3,null,null,"按照个性化需求，筛选统计出周期内，某人，某部门，的工作量或评分成绩等，生成报表","导出","导出","导出","/"]
["模板维护",4,"评价表",null,"质量评价表","编辑、审核"]
[null,null,"评分表",null,"考试评分表","编辑、审核"]
[null,null,"调查表",null,"各类满意度调查表","编辑、审核"]
[null,null,"收集表",null,"信息收集","编辑、审核"]
["考试题库",null,"考试",null,"成绩直接关联到对应的科室","编辑、审核","编辑、审核","查看","查看"]
[null,null,"试卷",null,"可设置其他人员是否能查看，编辑","编辑、审核","编辑、审核"]
[null,null,"题库",null,"可设置其他人员是否能查看，编辑","编辑、审核","编辑、审核"]
["课程链接",null,"师资",null,"可给乐享链接","编辑、审核","编辑、审核","查看","查看"]
[null,null,"学员",null,"无工号，无法打开乐享，量应该不算很大，或可设课程时效性","编辑、审核","编辑、审核","查看","查看"]
["催办提醒",5,"提醒",null,"定时提醒，临时提醒，预约提醒","编辑、审核","编辑、审核","查看","查看"]
[null,null,"催办",null,"OA直接链接跳转，催办至指定日期或指定程度","编辑、审核","编辑、审核","查看","查看"]

{"sheet":"技能中心管理系统需求（科教原版）","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"merged":[[0,0,0,4],[2,0,9,0],[2,1,6,1],[3,2,4,2],[5,2,6,2],[8,1,9,1],[10,0,18,0],[11,1,14,1],[11,2,12,2],[11,4,14,4],[13,2,14,2],[19,0,23,0],[26,0,28,0],[29,0,31,0]],"flags":["formulas_cached_only"]}
["临床技能培训中心管理系统要求"]
["一级系统","二级系统","三级系统","四级系统","要求"]
["技能中心管理","人员管理","管理员",null,"管理员资料，一个总管理员账号，下设多个单独的子管理员账号"]
[null,null,"教师","院内","1.由管理员添加，设定师资角色身份；\n2.院内师资可上传个人技能培训记录备案，由管理员审核，只限当年，不能跨年受理。"]
[{"$nulls":3},"院外","由管理员添加，设定师资角色身份；"]
[null,null,"学员","院内","学员身份资料，各类培训成绩档案管理"]
[{"$nulls":3},"院外","学员身份资料，各类培训成绩档案管理"]
[null,"场地管理 ","场地使用",null,"对外开放预约，同一时段同一培训室不能同时预约"]
[null,"物品管理","模型",null,"1.预约培训室同时，填写模型使用情况；\n2.设定外借功能：借用申请，归还日期统一限制，未归还有明显标识\n3.维修登记：包括日期、资金、支付出处，支持上传附件功能（维修单或发票等）"]
[null,null,"耗材",null,"预约培训室同时，登记耗材使用量"]
["课程管理","开课申请",null,null,"1.可对教师开放，与场地预约关联，由管理员审核; \n2.预约课程信息可保留当年度的"]
[null,"预约","教师","院内","1.可关联微信，培训考核的信息能在微信推送公示；\n2.个人报名后，在培训考核前一天，有微信推送提醒功能；\n3.可以允许个人修改部分个人信息，如性别等基本信息，但科室禁止修改，只能管理员修改；\n4.“年龄”一栏能随着年限进行自动修正"]
[{"$nulls":3},"院外"]
[null,null,"学员","院内"]
[{"$nulls":3},"院外"]
[null,"在线签到",null,null,"可扫描二维码进行课程签到及签退工作"]
[null,"叫号系统",null,null,"考官可用手机在培训室叫号，投屏到候考室的大屏幕上"]
[null,"评分系统",null,null,"可平板或手机操作"]
[null,"成绩管理",null,null,"由管理员设置对外开放权限（分数、扣分点）"]
["分析系统","人员统计",null,null,"包含参考人员统计，成绩统计，人员科室分布等"]
[null,"场地",null,null,"使用率"]
[null,"物品",null,null,"模型使用统计，维修统计"]
[null,"培训项目",null,null,"可统计同一项目举办期数、参加人员数量、资金使用情况等"]
[null,"成绩管理分析"]
[]
[]
["学员界面","可接收培训课程提示"]
[null,"可查询已过培训课程报名情况"]
[null,"可查询个人成绩，扣分点"]
["教学界面","可接收培训课程提示"]
[null,"可查询个人培训考核记录情况"]
[null,"可上传个人技能培训记录备案","院外或院内；可上传附件和照片"]