Скачать или смотреть Building a School Management System Using PERN Stack

Welcome to the official walkthrough of my School Management System, a comprehensive, full-stack application designed to streamline academic operations and reduce administrative workload for schools.

🧩 WHAT THIS SYSTEM DOES
This school ERP (Enterprise Resource Planning) solution digitizes and automates key school activities including:
✅ Student and teacher management
✅ Attendance tracking and promotion
✅ Subject and class organization
✅ Exam result entry with automatic GPA/grade calculation
✅ Marksheet PDF generation
✅ Event and notice publishing
✅ Public and private gallery uploads
✅ Google Drive integration for storing PDFs
✅ Role-based access for Admins, Teachers, and Students

💻 TECH STACK OVERVIEW
Frontend: React + Vite, Tailwind CSS, Framer Motion, Zustand
Backend: Node.js + Express
Database: PostgreSQL with Prisma ORM
Authentication: Secure JWT-based login with role protection
PDF Reports: Puppeteer
File Handling: Google Drive API for PDF storage, Local uploads for images
Excel Import: XLSX parsing for bulk data input

🚀 KEY FEATURES EXPLAINED

🎓 Student Management: Add/edit students, enroll in classes, manage attendance and promotion.

👨‍🏫 Teacher Dashboard: Manage subjects, student performance, and profile data.

📘 Subject Management: Assign to classes, link with teachers, and support Excel import.

🧪 Exam & Marks: Create exams, enter marks, auto GPA, export PDF reports.

📢 Notice Board: Post notices with attachments stored on Google Drive.

🎉 Event System: Create events, allow image uploads, review/approve galleries.

📅 Attendance Module: Daily or subject-wise tracking with class/date filters.

📥 Excel Bulk Import: Fast entry of subjects and students via Excel sheets.

🖼️ Gallery System: Filter by category or event, approve before publish.

🔐 Authentication: JWT-secured routes, role-based access, admin-only permissions.

🔧 BUILT ENTIRELY BY ME
I planned the user flow, designed the UI/UX, implemented the backend, integrated external services (Google Drive API, Puppeteer, etc.), and built a mobile-friendly frontend using modern React architecture.

📈 WHY THIS PROJECT MATTERS
This is not just a demo — it's a real-world scalable system meant to help schools eliminate manual processes and embrace digital transformation. It’s built with extensibility, security, and performance in mind.

📌 CHAPTERS
0:00 Intro
1:38 Dashboard Overview
4:03 Student Management
7:45 Teacher & Subject Management
12:00 Exams, Marks, & PDF Reports + Promotion
19:43 Attendance
20:34 Notice + Event System
23:20 Gallery & Image Approvals
26:28 Student Dashboard
30:48 Conclusion

🔗 USEFUL LINKS
🧪 Live : https://lbphs.gov.bd/


#SchoolManagementSystem #FullStackDeveloper #ReactJS #NodeJS #Prisma #PostgreSQL #TailwindCSS #Puppeteer #JWT #GoogleDriveAPI #PDFGenerator #EdTech #StudentManagement #SchoolERP #WebApp