MarkStream — Exam Portal

Flask + SQLite exam portal with Admin and Teacher logins. Admin creates subjects (name, class, year) and assigns a teacher; an Excel file named yr_cse_subject_class.xlsx is created. Teachers enter mid marks into that Excel via the web UI.

Setup

python -m venv .venv
.venv\Scripts\activate   # Windows
pip install -r requirements.txt
python app.py

Open http://127.0.0.1:5000

Default logins

• Admin: username admin, password admin
• Teacher: username teacher, password teacher

Flow

1. Admin — Login → Create Subject (subject name, class, year, assign teacher) → Excel file is created under excels/.
2. Teacher — Login → See assigned subjects → Enter Marks (Roll No, Name, Mid Marks) → Data is written to the Excel file. Can also download the Excel.

Tech

• Backend: Flask, SQLite
• Excel: openpyxl
• Templates: Bootstrap 5, Tailwind (CDN)