School Management System

School Management System — Full-Stack Web Application

This project is a complete school management platform built to digitize and streamline all core school operations. It supports academic, administrative, and communication workflows for students, teachers, and administrators.

Project Purpose

The goal is to minimize manual paperwork, enable transparent record tracking, and provide real-time management of academic and administrative processes.

Main Features

• Student Management: Add, update, and manage student profiles, academic info, and images.
• Teacher Management: Manage faculty profiles, subject assignments, and permissions.
• Subject & Exam Management: Create/import subjects, schedule exams, input/edit marks, calculate GPA/grades.
• Marksheet & Reports: Auto-generate PDF marksheets, downloadable/printable report cards, academic performance records.
• Attendance & Promotion: Record attendance, filter by class/date, analyze trends, promote students based on performance.
• Notice Board: Post notices with PDF attachments, preview/download files, simple notice management.
• Gallery & Event Management: Create events, upload media, approve/publish student submissions.
• Authentication & Security: JWT login, role-based access control, file validation, route protection.
• Bulk Import: Excel-based bulk student and subject import.
• Google Sheets Integration: Sync data

Tech Stack

• Frontend: React, Vite, Tailwind CSS, Zustand, Framer Motion, Shadcn UI
• Backend: Node.js with Express
• Database: PostgreSQL managed with Prisma ORM
• Authentication: JWT-based authentication with protected routes and role-based logic
• File Handling: Multer for file uploads; Google Drive API for cloud storage
• PDF Reports: Puppeteer for server-side PDF rendering and formatting
• Excel Handling: xlsx library for importing bulk data such as subjects and students

System Architecture

Modular RESTful API, scalable deployment, external service integration, client-server separation, secure authentication, type-safe data modeling.

What I Learned

• Built a full-stack application from scratch with production-level features
• Learned how to integrate external APIs like Google Drive for real-time file hosting
• Implemented complex role-based access controls for secure feature isolation
• Created dynamic and printable PDF reports using headless browsers
• Optimized database schemas for performance and clarity using Prisma ORM
• Handled real-world problems such as bulk data import, file validation, and asynchronous processes