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/AK...
(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