School Grading Portal
A comprehensive web application built with Flask for G6-12 school environment, managing grades, attendance, awards, and report cards.
Project Overview
This fully functional school grading portal was designed for a G6-12 school environment, catering to middle and high school students, teachers, and administrators. The system supports multi-role authentication (admin, teacher, student) and focuses on security, usability, and data integration.
The application integrates with Google Sheets for grade management and uses PostgreSQL database with secure password encryption (Fernet and Werkzeug). It follows a traditional web architecture with server-side rendering, some AJAX for dynamic updates, and includes features like bulk import/export, role-based access control, and Excel-based report card generation.
Key Features
Multi-role Authentication
Secure access for admins, teachers, and students with role-based dashboards and permissions.
Grade Management
Integration with Google Sheets for seamless grade tracking across quarters and school years.
Attendance System
Track tardies and absences by quarter with integration into reports and dashboards.
Awards System
Record and track student awards like Honor Roll by quarter with batch assignment capabilities.
Report Card Generation
Generate Excel-based report cards for individual students, grades, or the entire school.
Statistical Dashboards
Visual analytics for admins and teachers to track performance metrics and identify trends.
Technical Stack
- •Backend: Flask with server-side rendering and AJAX for dynamic updates
- •Database: PostgreSQL with secure connections and password encryption
- •Security: Password hashing with Fernet and Werkzeug, role-based access control
- •External Integration: Google Sheets API for grade management
- •Frontend: HTML, CSS, JavaScript with templates for a clean interface
Portal Screenshots
Key interfaces from the School Grading Portal application.
Click on any image to view it larger with detailed description
Login Form
Admin Dashboard
Admin Dashboard with Display Settings
Grades Page (Quarterly Performance Trends)
Teacher Management
Student Management
Attendance Page
Awards Page
Subject Management
Data Management Settings
Report Generation Page
Student Dashboard
