EduManage
Intelligent, Bilingual School Management System
Demo Credentials
Admin
admin@demo.com
123456
Teacher
teacher1@demo.com
123456
Student
student21@demo.com
123456
Parent
parent11@demo.com
123456
Project Overview
EduManage is an AI-powered, fully bilingual school management platform built for educational institutions of all levels — from primary schools to colleges. Administrators can configure custom classes, sections, and subjects to fit any curriculum. The system provides four dedicated portals — Admin, Teacher, Student, and Parent — each with role-specific dashboards, granular permissions, and localized features. Every interface, AI-generated output, and PDF document supports seamless English and Bengali switching.
Technology Stack
Frontend
Backend & Database
AI & Integrations
Infrastructure
User Portals & Roles
Administrator
Full control over school operations — student/teacher CRUD, exam management, fee collection, payroll, notices, and AI-powered risk monitoring.
- Bird's-eye dashboard with enrollment counts, attendance rates, fee collection totals, and at-risk alerts
- Complete student lifecycle management — create, edit, transfer, mark as left, and reinstate
- Teacher profiles with designations, salary structures, attendance tracking, and leave approval
- Exam creation with configurable max marks, session ordering, and term grouping
- Bulk marks entry for entire class sections in a single view
- Computed results with national grading scale (A+ through F) and GPA calculation
- Notice publishing with category tags, PDF attachments, and email distribution
- Internal messaging across in-app, email, and SMS channels
- At-risk student dashboard with AI-generated parent notification drafts
Teacher
Streamlined portal for classroom operations — attendance, grading, report review, and student well-being monitoring.
- Personal dashboard showing assigned classes, pending tasks, and recent notices
- Daily student attendance marking for each assigned class section
- Exam marks entry interface with bulk-scoring for all students in a subject
- AI progress report review — read, edit, and approve before parent delivery
- At-risk student alerts with detailed academic and attendance breakdowns
- Personal weekly class routine and attendance history
- Leave request submission with type selection and date range
Student
Personal academic hub — track attendance, view results, download documents, and chat with an AI assistant.
- Quick-glance dashboard with attendance rate, latest GPA, fee status, and notices
- Attendance history with present/absent/late breakdowns per month
- Exam results with subject-wise marks, letter grades, and cumulative GPA
- PDF downloads for result cards and exam admit cards
- Fee status overview — paid, pending, and overdue amounts with online payment initiation
- AI chatbot for natural-language queries about attendance, fees, exams, and notices
Parent
Multi-child monitoring portal — track all children's academics, fees, and communications from one dashboard.
- Unified dashboard with quick stats for every linked child
- Detailed child profiles with academic progress and attendance trends
- Fee status per child with payment initiation
- Internal message inbox for admin and teacher communications
- AI chatbot with child-selector — switch between children to query any data
AI-Powered Features
Quick Performance Insights
Automatic — when results are viewedGenerates a concise 2-3 sentence observation about a student's trajectory — comparing current marks against previous exams, factoring in attendance patterns and fee status. Displayed instantly on the results page in both English and Bengali, with a text-to-speech button for accessibility.
Output: Bilingual natural-language summary (< 60 words)
Formal Progress Reports
Manual — admin or teacher initiates per student per examProduces structured, formal narratives suitable for official report cards. Each report synthesizes academic performance, attendance records, and behavioral observations into a polished bilingual document. Reports follow a draft-review-approve pipeline before embedding into PDF report cards.
Output: Formal bilingual narrative with teacher-editable draft
Conversational AI Assistant
Student or parent asks a questionA bilingual chatbot that understands natural-language questions in both English and Bengali. It resolves student identity from the verified session (never from client input), queries the database for real-time answers, and rephrases raw data into conversational responses. Rate-limited to 20 messages per account per hour with persistent chat history.
Supported Queries:
Risk Alert Drafting
Manual — for WATCH or AT_RISK studentsWhen a student is flagged as at-risk, the system drafts a warm, supportive notification message for parents — never alarming, always constructive. Admin or teacher can edit the AI-generated text, approve it, and send via in-app notification or email.
Output: Bilingual parent notification in a caring tone
Automated Risk Scoring
Automated — nightly cron jobA weighted algorithm runs nightly at 3:00 AM UTC via Vercel cron, evaluating every active student across three dimensions. Attendance contributes 40% (comparing recent vs. baseline trends), academic marks contribute 35% (analyzing exam trajectories and subject-level declines), and fee payment status contributes 25% (counting consecutive unpaid cycles). Students are classified as SAFE (0-24), WATCH (25-54), or AT_RISK (55+).
Risk Classification:
No intervention needed
Early monitoring recommended
Parent alert + intervention required
Database Architecture
22 models organized across 7 domains
User & Authentication
Core identity and role management — each user account maps to one of four roles with dedicated profile tables linked via foreign keys.
Academics
Curriculum structure — classes contain sections, subjects are assigned to teachers, exams define assessment events, and marks record student performance.
Attendance & HR
Daily attendance tracking for both students and teachers, plus a complete payroll system with salary configuration, monthly payments, and a leave approval workflow.
Communication
School-wide notice publishing with read-receipt tracking, and an internal messaging system with per-recipient delivery status across multiple channels.
Financial
Fee definitions (monthly, exam, admission) and individual payment records with online payment support and receipt generation.
AI & Analytics
Storage for AI-generated content — performance insights, nightly risk assessments, parent notification drafts, and chatbot conversation history.
Scheduling
Weekly timetable management mapping periods, subjects, teachers, and rooms to each class section.
Security & Authentication
Session Management
JWT tokens signed with HS256 (jose library), stored in httpOnly cookies with sameSite: lax and secure flag in production. 7-day session duration.
Password Security
bcryptjs hashing with 10 salt rounds — never stored in plaintext.
Route Protection
Custom middleware intercepts every request, validates the JWT, and enforces role-based route access before the request reaches any page or API.
API Security
Every server-side route validates both authentication and authorization. Helper functions like requireAdmin() and requireAdminOrTeacher() gate access at the function level.
AI Security
The chat assistant resolves the student's identity exclusively from the verified JWT session — it never trusts IDs sent from the client, preventing unauthorized data access.
Rate Limiting
Chat assistant enforces 20 messages per account per hour to prevent abuse and manage OpenAI API costs.
Input Validation
Zod schemas validate every form input and API payload on both client and server, rejecting malformed data before it reaches the database.
PDF Document Generation
Result Card
Institution branding, student info, subject-wise marks and grades, GPA, and AI-generated insight
Admit Card
Institution details, student photo, exam schedule, and roll number
Payment Receipt
Fee payment amount, method, transaction reference, and date
Teacher Payslip
Basic salary, allowances, bonus, deductions, and net pay breakdown
Deployment & Infrastructure
platform
Vercel (serverless functions)
database
Supabase PostgreSQL (managed)
storage
OVH Object Storage — S3-compatible, EU-West-Paris region
cron
Nightly risk scoring at 3:00 AM UTC
Resend (transactional) + Nodemailer (SMTP fallback)
ai
OpenAI GPT-4o-mini (model configurable via environment variable)