School ERP System
Introduction
This project is a complete, production-ready School Enterprise Resource Planning (ERP) System built for managing all operations of a school from a single centralized web platform. Traditional school management through registers, manual attendance, and paper-based fee receipts is error-prone, slow, and hard to track.
The School ERP replaces all manual processes with a secure, role-based web application. It covers the full academic and administrative lifecycle — from student admission and class assignment to daily attendance, exam results, fee collection, timetable management, library records, transport tracking, staff payroll, and notice board announcements.
🏫 Designed for multi-role access (Admin, Teacher, Student, Parent) hosted on Hostinger with MySQL via phpMyAdmin.
Objectives
- Centralize all school data — students, staff, classes, and academics — in one platform.
- Provide role-based secure login for Admin, Teacher, Student, and Parent.
- Automate daily attendance marking and generate class-wise attendance reports.
- Manage fee collection, generate receipts, and track pending dues per student.
- Handle exam scheduling, marks entry, result calculation, and report card generation.
- Maintain class timetables and teacher schedules for all subjects.
- Manage library book inventory, issue, return, and fine tracking.
- Track school transport routes, vehicles, and student bus allocation.
- Manage staff records, attendance, leave requests, and salary processing.
- Publish notices, circulars, and announcements visible to all roles.
Key Features
Multi-Role Login
Separate dashboards for Admin, Teacher, Student, and Parent with role-based access control.
Student Management
Admission, profile, class assignment, TC generation, and complete academic history per student.
Attendance System
Daily class-wise attendance by teachers. Monthly reports and low-attendance alerts for parents.
Fee Management
Fee structure setup, online collection, receipt generation, and pending dues tracking per student.
Exam & Results
Exam scheduling, subject-wise marks entry, auto result calculation, and report card generation.
Timetable
Class and teacher-wise timetable management. Conflict detection for teacher schedule overlaps.
Library Module
Book inventory, issue and return tracking, overdue fine calculation, and search by author/title.
Transport Module
Route and vehicle management, student bus allocation, and driver records.
Staff Management
Staff records, attendance, leave management, duty roster, and monthly salary processing.
Notice Board
Admin publishes notices and circulars. Role-based visibility for teachers, students, and parents.
Parent Portal
Parents can view their child's attendance, results, fee status, and notices after login.
Admin Dashboard
School-wide stats: total students, fee collected, attendance %, upcoming exams at a glance.
Tools & Technologies
Frontend
- HTML5 & CSS3
- JavaScript (Vanilla)
- Responsive UI
Backend
- PHP — Server-side logic
- MySQL — Database
- phpMyAdmin — DB management
Design & Docs
- ERD — Entity Relationship Diagram
- DFD — Data Flow Diagram
- Use Case Diagrams
Environment
- Visual Studio Code
- XAMPP (Local Testing)
- Hostinger (Live Hosting)
System Design
The system follows a 3-tier architecture: Presentation Layer (HTML/CSS/JS), Business Logic Layer (PHP), and Data Layer (MySQL). Role-based session management ensures each user sees only their permitted modules.
Student Academic Flow
↓
Daily Attendance Marked → Exam Scheduled → Marks Entered → Result Published
↓
Report Card Generated → Parent Notified → Next Class Promotion / TC Issued
Role-Based Access Control
| Module | Admin | Teacher | Student | Parent |
|---|---|---|---|---|
| Dashboard | Full | Own | Own | Child |
| Student Management | Full | View | Own | Child |
| Attendance | Full | Mark+View | Own | Child |
| Fee Management | Full | None | Own | Child |
| Exam & Results | Full | Marks Entry | Own | Child |
| Timetable | Full | View | View | None |
| Library | Full | View | Own | None |
| Transport | Full | None | View | View |
| Staff Management | Full | Own | None | None |
| Notice Board | Full | View | View | View |
| Reports & Analytics | Full | Class-wise | None | None |
| Settings | Full | None | None | None |
Implementation Modules
| # | Module | Key Functions |
|---|---|---|
| 1 | Auth Module | Multi-role login, session management, bcrypt passwords, role-based redirects. |
| 2 | Student Module | Admission, profile, class assignment, document upload, TC generation, search. |
| 3 | Attendance Module | Daily class-wise marking by teachers, monthly summary, low-attendance alerts. |
| 4 | Fee Module | Fee structure setup per class, collection, receipt generation, pending dues tracker. |
| 5 | Exam Module | Exam scheduling, subject-wise marks entry, result calculation, grade assignment. |
| 6 | Result & Report Card | Auto-calculated results, pass/fail determination, printable report cards per student. |
| 7 | Timetable Module | Class-wise and teacher-wise timetable, period management, conflict detection. |
| 8 | Library Module | Book inventory, issue/return, overdue fine calculation, member tracking. |
| 9 | Transport Module | Routes, vehicles, driver records, student bus allocation, fare management. |
| 10 | Staff Module | Staff records, attendance, leave requests, duty roster, salary slip generation. |
| 11 | Notice Board | Admin creates notices with role-based visibility (All / Teachers / Students / Parents). |
| 12 | Parent Portal | View child's attendance, results, fee status, timetable, transport, and notices. |
| 13 | Reports Module | Attendance %, fee collection summary, class-wise results, student strength reports. |
| 14 | Settings Module | School profile, academic year, class/section setup, subject management. |
Results & Discussion
The School ERP System successfully automates and centralizes all academic and administrative operations of a school. Key outcomes achieved:
- Manual attendance registers eliminated — teachers mark attendance digitally in seconds.
- Fee collection errors reduced — automated receipts and dues tracking prevent missing payments.
- Exam result calculation time cut drastically — marks entered once, report cards auto-generated.
- Parents stay informed in real-time through the dedicated parent portal without phone calls.
- Library fines and overdue books tracked accurately — no manual register needed.
- Admin has full visibility into school operations through the centralized dashboard and reports.
Testing & Results
| Test Case | Result | Remarks |
|---|---|---|
| Multi-role Login & Session Management | ✓ Pass | All 4 roles redirect to correct dashboard |
| Student Admission & Class Assignment | ✓ Pass | Unique Roll No auto-generated |
| Daily Attendance Marking (Teacher) | ✓ Pass | Duplicate marking prevented correctly |
| Monthly Attendance Report | ✓ Pass | % calculated correctly per student |
| Fee Collection & Receipt Generation | ✓ Pass | Pending dues updated after payment |
| Exam Scheduling & Marks Entry | ✓ Pass | Subject-wise entry saved correctly |
| Result Calculation & Grade Assignment | ✓ Pass | Pass/Fail determined by grade rules |
| Report Card Generation (Print View) | ✓ Pass | Clean A4 print with all subjects |
| Timetable Conflict Detection | ✓ Pass | Same teacher double-booking blocked |
| Library Book Issue & Return | ✓ Pass | Fine auto-calculated on overdue return |
| Transport — Student Allocation | ✓ Pass | Route and vehicle linked correctly |
| Notice Board — Role-based Visibility | ✓ Pass | Student-only notices hidden from parents |
| Parent Portal — Child Data View | ✓ Pass | Only logged-in parent's child data shown |
| Data Persistence (phpMyAdmin / MySQL) | ✓ Pass | All records saved and retrievable correctly |
Limitations
- No SMS/Email Alerts: Attendance and fee reminders not sent automatically yet.
- No Online Fee Payment: Fee collected manually; no payment gateway integration.
- Single School: Does not support multi-branch school setup currently.
- No Mobile App: Browser-only; no dedicated Android/iOS app.
- No Biometric Integration: Attendance marked manually by teachers, not biometric.
- No AI/Analytics: No predictive analytics for student performance trends.
Future Scope
- SMS and WhatsApp alerts for attendance, fees, and exam results to parents.
- Online fee payment integration via Razorpay / PayU.
- Biometric attendance integration for students and staff.
- Mobile app (Android/iOS) for teachers and parents.
- AI-based student performance prediction and early warning system.
- Multi-branch support with centralized admin for school chains.
- Online exam / MCQ test module with auto-grading.
- CBSE/Board result integration and grade tracking.
Conclusion & Next Steps
The School ERP System successfully digitizes and automates the complete academic and administrative operations of a school. It eliminates manual registers, reduces human errors, and provides real-time visibility to all stakeholders — Admin, Teachers, Students, and Parents — through a secure, role-based web platform.
Hosted on Hostinger with MySQL as the persistent data store, the system is production-ready and accessible from any browser. Future enhancements — particularly SMS alerts, online fee payment, and a mobile app — will make it a fully self-sufficient school management solution.