{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["需求表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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"}

{"sheet":"需求表","index":0,"n_rows":121,"n_cols":10,"rows_kept":121,"cut":false,"hidden":false,"merged":[[112,1,120,1],[112,2,113,2],[114,2,115,2],[116,2,117,2],[116,3,117,3],[118,2,120,2],[119,3,120,3],[102,6,103,6],[106,2,109,2],[106,3,107,3],[106,6,107,6],[110,2,111,2],[96,1,111,1],[97,2,101,2],[97,3,100,3],[102,2,105,2],[102,3,103,3],[82,3,83,3],[84,3,85,3],[86,2,91,2],[86,6,89,6],[92,2,95,2],[92,6,95,6],[47,2,51,2],[47,6,50,6],[52,1,95,1],[52,2,63,2],[52,6,55,6],[59,3,63,3],[59,6,62,6],[64,2,67,2],[64,6,67,6],[68,2,71,2],[68,6,71,6],[72,2,81,2],[72,6,75,6],[77,3,81,3],[77,6,80,6],[82,2,85,2],[34,3,37,3],[34,6,37,6],[38,2,46,2],[38,6,41,6],[43,3,46,3],[43,6,46,6],[1,0,120,0],[1,1,12,1],[1,2,6,2],[1,6,4,6],[7,2,12,2],[7,6,10,6],[13,1,28,1],[13,2,18,2],[13,6,16,6],[19,2,28,2],[19,6,22,6],[25,3,28,3],[25,6,28,6],[29,1,51,1],[29,2,37,2],[29,6,32,6]]}
["系统","一级模块","二级模块","三级模块","四级模块","前置条件","说明","优先级","原型图","备注"]
["在线学习平台","题库管理","题库分类","查询",null,"1、登录【管理员、教研员】账号","对题库分类进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、当题目分类设置为该分类时，该分类不可删除；","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"导入",null,"1、登录【管理员、教研员】账号","对题库分类进行批量导入\n要求：\n1、支持下载【导入模板Excel文件】\n2、支持可选择的更新已有数据","P1"]
[null,null,null,"导出",null,"1、登录【管理员、教研员】账号","对题库分类进行批量导出\n要求：\n1、默认批量导出当前页数据\n2、可选择数据进行批量导出","P1"]
[null,null,"题目管理","查询",null,"1、登录【管理员、教研员】账号","对题库题库进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"导入",null,"1、登录【管理员、教研员】账号","对题库题库进行批量导入\n要求：\n1、支持下载【导入模板Excel文件】\n2、支持可选择的更新已有数据\n3、导入仅限选择题、客观题","P1"]
[null,null,null,"导出",null,"1、登录【管理员、教研员】账号","对题库题库进行批量导出\n要求：\n1、默认批量导出当前页数据\n2、可选择数据进行批量导出","P1"]
[null,"课程管理","课程分类","查询",null,"1、登录【管理员、教研员】账号","对课程分类进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、当课程分类设置为该分类时，该分类不可删除；","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"导入",null,"1、登录【管理员、教研员】账号","对课程分类进行批量导入\n要求：\n1、支持下载【导入模板Excel文件】\n2、支持可选择的更新已有数据","P1"]
[null,null,null,"导出",null,"1、登录【管理员、教研员】账号","对课程分类进行批量导出\n要求：\n1、默认批量导出当前页数据\n2、可选择数据进行批量导出","P1"]
[null,null,"课程管理","查询",null,"1、登录【管理员、教研员】账号","对课程信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、当课程分类设置为该分类时，该分类不可删除；","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"导入",null,"1、登录【管理员、教研员】账号","对课程信息进行批量导入\n要求：\n1、支持下载【导入模板Excel文件】\n2、支持可选择的更新已有数据","P1"]
[null,null,null,"导出",null,"1、登录【管理员、教研员】账号","对课程信息进行批量导出\n要求：\n1、默认批量导出当前页数据\n2、可选择数据进行批量导出","P1"]
[null,null,null,"评论","查询","1、登录【管理员、教研员】账号","对课程的评论进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】","P3"]
[{"$nulls":4},"新增","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"修改","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"删除","1、登录【管理员、教研员】账号",null,"P3"]
[null,"教材管理","教材管理","查询",null,"1、登录【管理员、教研员】账号","对教材信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"下载",null,"1、登录【管理员、教研员】账号","支持将教材数据下载到本地","P1"]
[null,null,null,"评论","查询","1、登录【管理员、教研员】账号","对教材的评论进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】","P3"]
[{"$nulls":4},"新增","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"修改","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"删除","1、登录【管理员、教研员】账号",null,"P3"]
[null,null,"视频管理","查询",null,"1、登录【管理员、教研员】账号","对视频数据进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持在线观看视频","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"下载",null,"1、登录【管理员、教研员】账号","支持将视频数据下载到本地","P1"]
[null,null,null,"评论","查询","1、登录【管理员、教研员】账号","对视频的评论进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】","P3"]
[{"$nulls":4},"新增","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"修改","1、登录【管理员、教研员】账号",null,"P3"]
[{"$nulls":4},"删除","1、登录【管理员、教研员】账号",null,"P3"]
[null,null,"课件管理","查询",null,"1、登录【管理员、教研员】账号","对课件数据进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持在线预览课件","P1"]
[null,null,null,"新增",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员、教研员】账号",null,"P1"]
[null,null,null,"下载",null,"1、登录【管理员、教研员】账号","支持将课件数据下载到本地","P1"]
[null,"系统管理","用户管理","查询",null,"1、登录【管理员】账号","对用户信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除\n4、用户身份有：管理员、教研员、教师、学生","P2"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"评分",null,"1、登录【管理员】账号","对该用户进行系统评分","P2"]
[null,null,null,"资格",null,"1、登录【管理员】账号","对该用户进行资格授权","P2"]
[null,null,null,"风评",null,"1、登录【管理员】账号","其他用户对该用户的评价","P2"]
[null,null,null,"证书","查询","1、登录【管理员】账号","对用户拥有证书进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P2"]
[{"$nulls":4},"新增","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"修改","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"删除","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"下载","1、登录【管理员】账号","支持将证书文件下载到本地","P2"]
[null,null,"角色管理","查询",null,"1、登录【管理员】账号","对角色信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P1"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P1"]
[null,null,"专业管理","查询",null,"1、登录【管理员】账号","对专业信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P1"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P1"]
[null,null,"班级管理","查询",null,"1、登录【管理员】账号","对班级信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P1"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P1"]
[null,null,null,"评分",null,"1、登录【管理员】账号","对该班级进行系统评分","P1"]
[null,null,null,"证书","查询","1、登录【管理员】账号","对班级拥有证书进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P2"]
[{"$nulls":4},"新增","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"修改","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"删除","1、登录【管理员】账号",null,"P2"]
[{"$nulls":4},"下载","1、登录【管理员】账号","支持将证书文件下载到本地","P2"]
[null,null,"课程管理","排课管理","一键排课","1、登录【管理员】账号","根据教师，班级，时间自动排课","P1"]
[{"$nulls":4},"手动排课","1、登录【管理员】账号","根据教师，班级，时间手动排课","P1"]
[null,null,null,"课程管理","课程进度","1、登录【管理员】账号","查看该课程当前进行进度","P1"]
[{"$nulls":4},"课程评论","1、登录【管理员】账号","查看该课程当前评论","P1"]
[null,null,"证书管理","查询",null,"1、登录【管理员】账号","对证书信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P2"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P2"]
[null,null,null,"下载",null,"1、登录【管理员】账号","支持将证书文件下载到本地","P2"]
[null,null,null,"证书颁发",null,"1、登录【管理员】账号","步骤：\n1、选择认证考试题目\n2、考试认证考试\n3、批改考试考卷\n4、颁发对应证书","P2"]
[null,null,"公告管理","查询",null,"1、登录【管理员】账号","对公告信息进行维护管理\n要求：\n1、查询要求分页查询；\n2、删除支持【单个删除】与【批量删除】\n3、支持逻辑删除","P3"]
[null,null,null,"新增",null,"1、登录【管理员】账号",null,"P3"]
[null,null,null,"修改",null,"1、登录【管理员】账号",null,"P3"]
[null,null,null,"删除",null,"1、登录【管理员】账号",null,"P3"]
[null,"教师课程班级管理","学生管理","学生评价",null,"1、登录【教师】账号","对学生信息进行管理\n要求：\n1、支持对学生进行评价和评分","P1"]
[null,null,"考勤管理","考勤管理","查询","1、登录【教师】账号","查询当前课程已发布的考勤","P2"]
[{"$nulls":4},"发布新考勤","1、登录【教师】账号","发布新考勤：日期、课时、开始时间到截至时间","P2"]
[{"$nulls":4},"修改考勤","1、登录【教师】账号","修改考勤内容","P2"]
[{"$nulls":4},"关闭考勤","1、登录【教师】账号","关闭考勤","P2"]
[null,null,null,"考勤统计",null,"1、登录【教师】账号","用图表的形式展示考勤相关数据：\n1、班级出勤率和缺勤率\n2、学生的缺勤次数","P2"]
[null,null,"作业管理","发布作业","题库选题","1、登录【教师】账号","发布作业：\n1、作业：日期、课时、开始时间到截至时间\n2、作业内容可选：题库选题和手动录题\n3、手动录题支持跳转到题库管理新增题目","P1"]
[{"$nulls":4},"手动录题","1、登录【教师】账号",null,"P1"]
[null,null,null,"批改作业","手动批改主观题","1、登录【教师】账号","要求：\n1、批改每个作业的主观题，并给出分数","P1"]
[null,null,null,"作业统计",null,"1、登录【教师】账号","用图表的形式展示作业相关数据：\n1、班级作业完成率和分数占比\n2、学生的分数统计","P1"]
[null,null,"考试管理","发布试卷","题库选题","1、登录【教师】账号","发布考试：\n1、考试：日期、课时、开始时间到截至时间\n2、考试内容可选：题库选题和手动录题\n3、手动录题支持跳转到题库管理新增题目","P1"]
[{"$nulls":4},"手动录题","1、登录【教师】账号",null,"P1"]
[null,null,null,"批改试卷","手动批改主观题","1、登录【教师】账号","要求：\n1、批改每个作业的主观题，并给出分数","P1"]
[null,null,null,"统计考试结果",null,"1、登录【教师】账号","用图表的形式展示考试相关数据：\n1、班级考试完成率和分数占比\n2、学生的分数统计","P1"]
[null,null,"反馈","课程评论","查询","1、登录【教师】账号","查看学生对课程的评价","P3"]
[null,null,null,"课程反馈","新增","1、登录【教师】账号","提交对课程内容的反馈","P3"]
[null,"学生课程管理","作业管理","查看作业","查询作业","1、登录【学生】账号","要求：\n1、查询课程对应的作业和作业内容","P1"]
[null,null,null,"提交作业","提交","1、登录【学生】账号","要求：\n1、支持学生在线作答\n2、支持提交作业后对答案进行批改，得出分数","P1"]
[null,null,"考试管理","查看考卷","查询考试","1、登录【学生】账号","要求：\n1、查询课程对应的考试和考试内容","P1"]
[null,null,null,"提交考卷","提交","1、登录【学生】账号","要求：\n1、支持学生在线作答\n2、支持提交考试后对答案进行批改，得出分数","P1"]
[null,null,"考勤管理","确认考勤","查询","1、登录【学生】账号","查询课程当前发布的考勤","P2"]
[{"$nulls":4},"确认","1、登录【学生】账号","确认考勤","P2"]
[null,null,"反馈","课程评论",null,"1、登录【学生】账号","支持学生对课程进行评价，给老师留言功能，反馈给老师的","P3"]
[null,null,null,"课程反馈","评价老师","1、登录【学生】账号","支持学生对老师进行评价，反馈给学校的","P3"]
[{"$nulls":4},"评价课程","1、登录【学生】账号","支持学生对课程内容进行评价，反馈给学校的","P3"]