A course selection system. There are 4 types of users in the system: students, teachers, college administrators, and system administrators.
一个选课系统。系统中存在 4 类用户:学生、教师、学院管理员、系统管理员。
Time: 2021 Spring Semester
- The system mainly uses the
Django
, and also useslayui
for front-end design. 系统主要使用了Django
框架,另外使用了layui
用于前端设计。 - The database uses
Django models
based onSQLite3
. 数据库使用了基于SQLite3
的Django 模型
。
- For all users 所有用户
- user query 用户查询
- personal basic information query 个人基本信息查询
- sending and receiving messages 收发留言
- course information query and browsing 课程信息查询与浏览
- For students 学生
- grades query 成绩查询
- course selection results query 选课结果查询
- downloading courseware 下载课件
- restriction testing of prerequisite courses 先修课限制检测 (implemented by topological sorting 通过拓扑排序实现)
- course selection 选课
- selected course query 已选课程查询
- For teachers 教师
- submiting course introductions 提交课程介绍
- uploading courseware 上传课件 (implemented by
jquery
通过jquery
实现) - setting prerequisites restrictions 设置先修课限制
- updating and modifying course information 更新修改课程信息
- generating a list of students who have been selected for a course 生成选课中签学生名单
- entering course grades 录入课程成绩
- generating grade statistics 生成成绩统计表
- For college administrators 学院管理员
- additions, deletions and modifications of teachers in this college 本学院教师的增删改
- additions, deletions and modifications of students in this college 本学院学生的增删改
- additions, deletions and modifications of courses in this college 本学院课程的增删改
- additions, deletions, modifications and query of course selections in this college 本学院选课的增删改查
- additions, deletions, modifications and query of grades in this college 本学院成绩的增删改查
- drawing lots of course selection 选课抽签
- generating a list of students who have been selected for a course 生成选课中签学生名单
- For system administrators 系统管理员
- additions, deletions and modifications of teachers 教师的增删改
- additions, deletions and modifications of students 学生的增删改
- additions, deletions and modifications of courses 课程的增删改
- additions, deletions, modifications and query of course selections 选课的增删改查
- additions, deletions, modifications and query of grades 成绩的增删改查
- generating a school-wide course selection chart 生成全校选课统计图 (implemented by
Highcharts
通过Highcharts
实现)