
I built this student-records application with Flask, Peewee, and SQLite. It has student, teacher, and administrator accounts. Its pages for records, grades, and announcements vary by role. Jinja2, Layui, and jQuery provide the pages.
Student pages
Students sign in to a personal homepage and can view their profile, portrait, and grades. Records include student number, name, class, date of birth, and enrollment date. The grade page covers regular assessments, midterms, and finals, with ECharts for visualization.
Before grades are entered, the page has an empty state. Once records exist, it shows the chart.
Class management
Teachers can view their class list, edit records, and enter grades. For roster export, pandas prepares the columns and openpyxl writes the workbook. The endpoint returns the file data with a download filename.
Grade overview and editing have their own pages: a table for reviewing the class and an editor for changing an individual record.
Accounts, announcements, and permissions
Administrators maintain student and teacher accounts and publish announcements. Login uses JWT, menus vary by role, and editing and deletion endpoints check the relevant role. Teachers and administrators can edit student details; adding and deleting students are administrator operations.
The system also includes portrait upload and a calendar using chinesecalendar for holiday information. Announcements are published in the administration interface and displayed to users.
Code organization
I separated page routes into app, JSON endpoints into api, tables into database, and operations such as export, grades, and menus into service. Templates and static files have their own directories. A record edit moves from the page to an endpoint, then through a service function to the database update.






