Student Record Management System with Role-Based Access

Managing student records by hand — grades, attendance, who's allowed to see or edit what — doesn't scale past a handful of students, and most schools need at least a basic separation between what admins, teachers, and students can each do.

I built a role-based student management system in Streamlit, backed by SQLite. Three roles — Admin, Teacher, and Student — get different views and permissions: admins have full control, teachers can manage student records, and students see a read-only view of their own performance. Password hashing is used for stored credentials, and bulk data entry is handled through Excel upload rather than requiring one-by-one manual entry.

• Python and Streamlit for the application
• SQLite for data storage
• Pandas and openpyxl for bulk Excel import/export
• Plotly for the analytics dashboard

• Role-based authentication and access control (Admin / Teacher / Student)
• Full CRUD on student records, scoped by role
• An analytics dashboard: total/passed/failed student counts and interactive charts
• Bulk student import via Excel upload, with a provided template
• Hashed password storage for user accounts

I designed and built the full application solo: the database schema, the role-based access logic, the CRUD flows, the bulk Excel import, and the analytics dashboard.

View source on GitHub