No More Expensive Software! Create a School Management System in Google Sheets (Apps Script)

🔗 Explore the LIVE DEMO here: Price ₹1999 https://script.google.com/macros/s/AKfycby3XAHuA8RWQ3xT7X-_ECv2rh0o2hH96CBogmZWcXc12mtiOMGP1sMyP9tPl-5snoOR/exec (Admin Username: admin, Password: admin | Teacher Username: teacher1, Password: Pass@123) 🚀 Discover a comprehensive School Management System Web Application built entirely with Google Sheets as the backend and powered by Google Apps Script! This video provides a full walkthrough of its features, demonstrating how you can efficiently manage school operations. Demo Credentials (also available via the live demo link): Admin Login: Username: admin Password: admin Teacher Login: Username: teacher1 Password: Pass@123 Key Features Demonstrated: 🔐 Secure User Login: Role-based access for Admins and Teachers. 📝 Student Admission Module: Easy new student registration (Admission No., Name, Class, DOB, Gender, Contact, Address). Data stored directly in Google Sheets. 👨‍🎓 View Students: Filter and view student details by class. 💰 Fee Management: Submit student fees against their Admission Number. Student Name & Class auto-populate. Record Fee Month and Amount. 📊 Fee Payment History: Track fee payments for individual students by Admission Number. 🏆 Results Management: Enter Student Marks: Input marks for various subjects (Bangla, English, Math, Science shown) per term/exam. View Results: Search and view individual student results by Admission Number. Download PDF Report Card: Generate and download academic report cards. 👥 Staff Management: Add and manage staff profiles (Staff ID, Name, Designation, Qualification, Contact, Email, Address). ⚙️ Backend (Google Sheets): Separate sheets for Login, Admission, Students, Staff, Fees, Results, Classes, and Subjects acting as a robust database. 🚪 Logout Functionality Technology Stack: Frontend: HTML, CSS, JavaScript (for the web application interface) Backend & Logic: Google Apps Script Database: Google Sheets Timestamps: 0:00 - Introduction & Google Sheets Database Overview 0:35 - Login Sheet (Database) 0:57 - Admission Sheet (Database) 1:02 - Students Sheet (Database) 1:07 - Staff Sheet (Database) 1:12 - Fees Sheet (Database) 1:16 - Results Sheet (Database) 1:20 - Classes & Subjects Sheets (Database) 1:33 - Web Application Login (Admin Demo) 2:03 - Admin Dashboard: New Admission Form 2:27 - Admin: View Students 2:37 - Admin: Fee Submission 2:44 - Admin: Fee Payment History 2:47 - Admin: View Results (Before entering marks) 2:56 - Admin: Enter Student Marks 3:01 - Admin: Staff Management 3:17 - Demo: Adding a New Student Admission 4:00 - Verifying Admission Data in Google Sheet 4:11 - Demo: Viewing Students by Class 4:27 - Demo: Submitting Student Fees 5:15 - Verifying Fee Data in Google Sheet 5:35 - Demo: Viewing Fee Payment History 5:56 - Demo: Entering Student Marks for Multiple Subjects 6:55 - Verifying Result Data in Google Sheet 7:04 - Demo: Viewing Student Results & Downloading PDF Report Card 7:50 - Demo: Adding New Staff (Staff Management) 8:19 - Verifying Staff Data in Google Sheet 8:21 - Teacher Login Demo 9:34 - Teacher Dashboard Overview (Limited Access: View Students, View Results, Enter Results) ✨ Interested in this School Management Web Application or need a custom solution for your institution? Feel free to reach out! WhatsApp/Contact: [Your WhatsApp Number/Email] Channel: [Your Channel Name/Link] 👍 If you found this video helpful, please like, share, and subscribe for more Google Apps Script projects! #SchoolManagementSystem #GoogleAppsScript #GoogleSheets #WebApp #EducationTechnology #SchoolERP #Automation #HappyToHelpYou #ApexSchool