# School Management System with All Modules | Fees, Exams, Timetable, Attendance & Hall Tickets

https://www.youtube.com/watch?v=3QXU5ycMA00

[00:00] Welcome back.
[00:01] In this video, I am going to show you a complete school management system that is built by using the Google Sheets as a database and Google Web App Script.
[00:11] Within this school management system, we have added almost every module what a school is needed like the admission management, the student management, the classes and section management, parents management, assets management, stock and inventory management, subject management, teachers management, attendance related module, PTM section, and also the exam related modules, the fee collection modules, the help desk system, and the complaint management system.
[00:36] And also in this system, we have the multiple roles like the admin, the clerk, the teacher, the supervisor, the student, and the parent.
[00:44] So, let me explain you how this will work exactly.
[00:48] So, first of all, right now I am logged in as a admin, and this is a dashboard where I can take the overview of the complete system.
[00:54] And you can see we have added the quick action buttons on almost on each KPI cards.
[00:59] Like if you click on
[01:01] this add student, you will be redirected to student management.
[01:03] And if you want to see the outstanding balance, you will be redirected to the fee collection section.
[01:05] And everything is pressable, you will be redirected to the particular section.
[01:11] So, this is a dashboard where we can take the overview of the complete system.
[01:13] And that is our admission section.
[01:15] If we want to make a new registration for the student, we just simply click on this new registration, fill the applicant information, the applying for the class that will be in the drop down and searchable drop down, and how you can add more classes.
[01:17] You just simply go to your classes and section, and simply click on this add class, simply enter your class name, section, academic year, grade level, class code, curriculum and capacity information, location, and staff.
[01:19] And the notice that class name plus section plus academic year must be unique.
[01:21] Inactive classes are hidden from new admission, but historical data remains.
[01:23] Okay.
[01:25] So, this is a thing where you can manage your classes and section.
[01:27] Now, let's back to the admission section and
[02:01] here you will see you just enter your grade, your admission type, your academic year, your parents and guardian information, the contact and address, and also the registration fee and notes, and simply hit the save registration.
[02:13] So, once you hit the save registration, the data will be saved here.
[02:15] And if you want to search a particular data, you just simply use this search feature.
[02:21] And if you want to apply the filters, you just simply apply the filters here directly.
[02:24] Okay?
[02:24] So, if you want to clear the filters, you just simply click on this clear.
[02:29] And there is a status column where you can see different status.
[02:33] Right now, this application status is rejected.
[02:35] And if you want to visualize the view reason, you just simply click on this here.
[02:40] So, you will see the rejection reason.
[02:41] And if you want to enroll the student to a class, you just simply click on this enroll to class, select a class from the drop-down, roll number, admission number, login password, admission date, and entry point, mid-session, start of session, etc.
[02:56] And if they want to require a transport, you just simply press this icon.
[03:00] So, you will just enter the
[03:02] transport road.
[03:05] This creates the student records, login credentials, and monthly fee dues.
[03:07] The admission fee, if any, is recorded in the fee collection.
[03:09] Okay?
[03:11] So, if you want to simply confirm the admission, you just simply click on this icon and that admission is added by your clerk or supervisor.
[03:18] So, you just simply enter the admission fee, their profile details, their address, and simply click on this confirm admission.
[03:25] So, once you confirm the admission, that that admission will be considered as confirmed.
[03:31] Okay?
[03:33] Now, let's move to the student section.
[03:35] And in the student section, you can manage your students.
[03:36] If you want to add a new student, you just simply add here directly as well.
[03:40] Like the identity and academic information you need to fill, select a class from the drop-down, make the status active, inactive, transferred, passed out, suspended, etc.
[03:48] And if their personal information, their contact and address, their family information, others information, and also the transport required yes or no.
[03:56] If yes, you can simply enter the transport route.
[03:59] And if no, you just simply leave
[04:03] it as it is.
[04:03] There's a medical notes, identity and citizenship, and also the languages and curriculum, and safeguarding and pickup.
[04:09] And that is their health and safety.
[04:11] And you just simply select multiple options from here.
[04:15] And you can also make the note restriction.
[04:16] That is the allergies and also the insurance provider, insurance policy expiry, the house and identity, and every information what you need for your admission number is unique.
[04:26] Aadhaar if provided is unique.
[04:28] Roll number must be unique within the class for the chosen status.
[04:30] Okay?
[04:32] You understand them?
[04:34] And within this section, we have added some extra accessibilities.
[04:36] Like in the action column, you just simply see the fees icon.
[04:39] When you click on this fees icon, now here you can see the monthly fee dues.
[04:46] So, this is the monthly fee dues, total paid, outstanding due, late fees, discounts, receipts, and everything.
[04:52] And that is your past history.
[04:54] And same like that, if you want to check their attendance report, just simply click on this attendance report icon, and you will be see total five records is
[05:04] available.
[05:06] Five is present, zero is absent and late, and leave, and attendance as well.
[05:07] So, that is their past history as well.
[05:09] And if you want to apply the custom date filters, you can also apply them.
[05:11] And the same thing is that if you want to see their exam result, you just simply click on this here.
[05:13] And now, the exam will be appeared in the drop down.
[05:15] And how you can add more exams, I will explain you when we will discuss about the exam related modules.
[05:17] And if you want to make a print for A4, you just simply click on this here.
[05:19] So, once you click on this here, that result will be print out here.
[05:22] And you just simply select an other exam term, so you will be see that particular result as well.
[05:23] And there is a linked parents.
[05:25] So, when you click on this, you can easily able to see the linked pairs.
[05:27] Right now, the mother one and the father one is linked out to this particular parents.
[05:30] Okay?
[05:32] Understand them.
[05:33] And if you want to edit or delete, you can simply utilize them.
[05:36] And that is our filters.
[05:38] You just simply apply directly from here.
[05:40] And that is our classes and section you already know.
[05:43] And in the
[06:04] action columns, we have added our timetables accessibilities.
[06:06] We just simply click on this here and we can easily visualize them what is the timetable for this class today.
[06:12] So, you can see there is a period one English and there is a period two science and that is the mathematics and etc. many more.
[06:20] Okay?
[06:20] And if you want to add a class, you just simply add a class.
[06:24] And if you want to make email PDF, you just simply enter the email where you want to send these classes report and simply hit the send icon.
[06:31] So, that is our parent management section.
[06:33] Simply, if you want to add a parent, you just simply enter the information.
[06:37] And the thing is that if you add the student and when the student when you add the parents related information, that will be automatically come here.
[06:45] So, you don't need to make the extra parents anymore.
[06:47] Okay?
[06:49] So, if you want to add parents manually, you can simply add them later as well.
[06:51] Okay?
[06:54] You understand them?
[06:55] And that is the thing.
[06:57] In the action column, we have added the link children feature.
[06:59] So, right now there is currently linked uh children is two.
[07:01] And if you want to unlink them, you can
[07:05] Simply unlink them as well.
[07:07] And if you want to remove primary, you can simply remove that.
[07:09] And if you want to add one more student to this particular parent, you just simply click on this link student.
[07:15] So, once you click on this link student, as of now you can able to see here the student link successfully.
[07:19] I am just reviewing this web application what features have in this we added.
[07:23] And the application is tested by more than 100 peoples.
[07:27] So, there is no error if you utilize them for adding, edit, or delete data.
[07:31] Okay?
[07:34] So, everything is functional and tested by many peoples.
[07:36] So, that is their fee records.
[07:38] And you can see when I simply click on this fee records in my parents management, I simply check it here, the student one, the student three, and the student five.
[07:45] And right now, the total paid is this, the outstanding balance is this, and also the late fees is this.
[07:49] Okay, you understand them?
[07:51] Same, you can simply edit or delete the data.
[07:53] And that is our asset section where you can simply add the asset for your schools, like the asset tag, if if if it is blank, that will be automatically generated.
[08:03] The asset name, the category, the location,
[08:05] purchase date, etc.
[08:07] You can simply make it here.
[08:10] And also, if there is any maintenance for this particular assets,
[08:11] you just simply add the records here to keep the history.
[08:13] Like you can easily able to see here, there is a maintenance for leather football,
[08:17] and if you want to add any maintenance, if you have any expenses, you just simply add it here.
[08:24] Okay, understand them?
[08:25] And that is our stock and inventory feature.
[08:28] If you want to add a item, you just simply add enter the item name, category, units, units in pieces, box, pack, liter, kg, meter, dozen, etc.
[08:34] Current stock, reorder level, reorder quantity, the unit cost, and that will be automatically utilized.
[08:40] Okay?
[08:43] So, once the quantity is sold, that will be deducted from your stock.
[08:45] And if it is returned, that will be automatically restored.
[08:46] And if you want to stock in, you just simply enter the quantity, reason, reference number, notes, etc.
[08:53] And if you want to make the stock out, you just simply here.
[08:57] And also, we have the quick accessibilities, the stock in, the issue, and the adjust.
[08:59] So, you don't need to use these features from here.
[09:04] And if you want to check out
[09:05] the history, you just simply click on this here.
[09:07] And right now, you can able to see the A4 printing paper, and right now, the stock in is 100, and the stock out is 95, and issues issued to class A, and etc. by the admin.
[09:19] Okay, that is our subject section, what your school subjects have, and what is their maximum marks, that will be utilized in our exam modules.
[09:25] And what is their passing marks, and also you can apply the conditions.
[09:29] So, when you simply click on this add subject, right now, you need to enter the subject name, the subject code, the class, and the theory, and also the maximum marks, and the passing passing pass marks, okay?
[09:41] So, they notice that subject code plus plus class must be unique.
[09:44] Same code can exist in different classes in active subjects are hidden from new exams, but historical data will be remain same.
[09:54] And that is our teachers management where you can see the teachers and how the teachers will come whenever you create a new teacher in your users and staff, that will be automatically comes here.
[10:03] Okay, so once comes it here, you just simply click on this manage, and right
[10:07] now you can able to see here current assignment for this teacher is the class A mathematics and the class 1B mathematics.
[10:13] And if you want to select a particular class, and then you just simply add the subjects here.
[10:19] Right now, the English and assigned class teacher home room of this class, and click on this add one subject.
[10:23] So, when you when you click on this add new subject as of now, you can easily able to see here it's adding out successfully, and now this teacher has three current assignments as well.
[10:32] Understand, the data will be updated real-time, and the best part for this school management system, you will not face any loading time here.
[10:41] So, when you move from one section to another section, it gives you the super smooth experience.
[10:47] So, you never face that it will be utilized by using the Google Sheets or App Script.
[10:51] You feel like this is a professional level software.
[10:53] So, we have designed this system like that.
[10:54] Okay, you understand them?
[10:56] Yes, you understand them.
[10:58] And the best part for this school management system is that it is completely free for hosting because you are using the Google the Google Sheets Google product the Google Sheets, okay?
[11:07] Now, this is the time table.
[11:09] You just simply select a class and then the academic year, and then the full year.
[11:13] And now you will be easily able to see here the complete time table for this particular class.
[11:17] And if you want to take a print, you just simply take a print from here.
[11:20] And if you want to make a period setup, you just simply add a period and etc. you can do it here, edit, delete, and everything.
[11:26] And that is our main module, the attendance module.
[11:30] You just simply select a class from the drop down and the date will be automatically selected for today.
[11:34] And if you want to search a student, you just simply add it here.
[11:38] There is a present, absent, late, half day.
[11:40] If you want to apply the filters, you can use them.
[11:42] And also, if you want to present mark all, if you want to make all absent, you just simply click on this yes mark all.
[11:48] And if you want to copy the yesterday attendance, just simply click on this here and click on this yes copy.
[11:56] So, yesterday, we have one student present.
[11:58] The student two is absent and the student three is present.
[12:00] And if you want to add any remarks, you just simply add it here.
[12:04] And you can also see the last 7-day for this student.
[12:06] The green
[12:08] indicates it's present and the absent indicates it's blue uh red and also the late indicates it's yellow and the half day indicates the blue.
[12:17] And also, the leave indicates the purple.
[12:19] Okay, so you will see here directly as well.
[12:21] And also, you just simply click on the save attendance, so that attendance will be saved to our database.
[12:27] What is our database?
[12:29] The Google Sheets is our database.
[12:31] Understand them?
[12:33] Now, this is our substitutes.
[12:35] And if you want to add new allocation, just simply add a teacher absent teacher like now you can easily able to see a teacher one.
[12:39] That is the date that is the description.
[12:41] You just simply add it here uh like you want to see and click on this load periods.
[12:45] So, when I click on this load periods, as of now, you can able to see here that is the period one for the mathematics.
[12:50] And if you want to allocate to the another student teacher, you just simply do it here and click on this save allocation.
[12:58] So, in this way, you can assign the teacher.
[13:00] So, this is the error right now.
[13:01] That teacher is also absent.
[13:03] So, you can do it here if you add your real data.
[13:05] So, that is our school notices.
[13:07] If you want to post a notice, just simply add the title,
[13:08] description, announcement, notice date, audience.
[13:11] What is your audience type?
[13:13] Students, teachers, parents, staff.
[13:14] So, that post notice will be appeared on their dashboard only.
[13:19] And if you make it all, that will be appeared in all user roles dashboard.
[13:23] Okay? So, if you want to make active or inactive, you can also them.
[13:25] Okay, so that is our PTA, which is the parent-teacher meetings.
[13:27] And if you want to create a slot, you just simply select a teacher from the drop-down and you can simply select date, the start time, the end time, the duration, the class, and also the maximum bookings the available, the notes, etc.
[13:42] You can do it from here.
[13:42] And that is our calendar for our school.
[13:44] We can easily visualize them that on the 20th date we have nothing even and if there any event or leave, we can directly see it here.
[13:53] And that is available in all user roles.
[13:53] This is our lesson planning where you can see the lesson planning.
[13:57] And that is the admin mode.
[13:59] Admin can only able to read and delete plans.
[14:02] But only teachers can create and edit them.
[14:04] Okay, so this access is only for the teacher.
[14:06] And that is our teaching logbook.
[14:08] That is also
[14:10] managed by the teacher because this is the data what a teacher managed.
[14:14] Okay, you can simply delete them.
[14:17] Okay, so in this way you can date, class subject, the topic, the homework, the status, and the teacher, etc.
[14:21] And that is our the exam modules, what is the most important.
[14:25] If you want to add exam, you just simply the exam name, exam code, exam type, the class, the academic year, the start date, the end date, maximum marks per subject, and also the terms and assessment, and also the grading and schedule advanced, etc.
[14:38] Exam start as draft.
[14:40] You use the publish action on the road to publish.
[14:42] Once published, marks become visible to student, parents, and teachers.
[14:46] Edits are locked.
[14:48] Okay, so you can see.
[14:51] So in the action column, that is our exam.
[14:54] And if you want to make the marks entry, just simply click on this here.
[14:57] And right now you just simply select a subject.
[14:59] And once you select a subject, you will see the complete student list for this teacher.
[15:03] So if you want to add, that is the absent student.
[15:06] And if you want to add the marks here, the 77, so you can see the grade is
[15:10] automatically calculated.
[15:13] And you can simply submit them if you are a teacher.
[15:15] And you can also moderate them if you made changes.
[15:18] And you can lock them and your admin can publish them.
[15:20] So teacher cannot able to publish them.
[15:22] Teacher can see the save draft, the submit, the moderate, the lock feature.
[15:26] But publish can only admin can do.
[15:29] Okay, understand them?
[15:32] Yes, you understand them.
[15:32] So this is our exam modules.
[15:34] In the exam modules, if you want to check out the toppers, like now I want to check the top five toppers.
[15:40] Okay, so this is a class 1A, that is the section and three students available.
[15:44] So this is the top one with the 82% and this is the student two with 76% and that is the 30.7% so in this way.
[15:51] And there is also a feature for grade distribution.
[15:53] You can also check out them from the quick access.
[15:56] Okay, you understand them?
[15:58] That is the grade distribution system as well.
[16:00] A plus grade at that level and also you can matter them.
[16:03] You can edit them, delete them, etc.
[16:07] And if you want to print the mark sheet and send to the teacher, you just simply click on this here and print A4 size paper as well for
[16:13] this class mark sheet for the complete students.
[16:15] Okay?
[16:17] And if you want to edit the data, you can simply edit them and delete them as well.
[16:19] Understand?
[16:21] Now this is a results mark entry.
[16:23] Same like that we have given the quick access it's here and that is the hall tickets.
[16:27] I just simply select a class and now you can simply generate all and that will be a weird in your students dashboard and your parents dashboard so they can easily download them and after the downloading they can print them and take it in your examination hall.
[16:41] And that is our discipline section where you can report the incident, pick a student and you can also able to see that is the student available in the drop down.
[16:49] Incident date, the type misbehavior, the severity status and also the parent notified yes or no, description, action taken, action taken and remarks.
[16:58] And also in the action column, we have added the student discipline history.
[17:00] You just simply click on this here and you will grab the complete student history available in our database.
[17:05] And if you want to notify to the parents, you just simply click on this here and mark them enable.
[17:10] And if you don't want to notify
[17:14] to the parent, you can simply disable them from here.
[17:18] And if you want to edit or delete you can simply use them.
[17:20] This is the video I am recording right now continuously.
[17:24] There is no edits or cuts because I want to show you the system performance is working very great without any lagging or without any taking time.
[17:30] So it's instantly.
[17:32] So you can utilize them in your schools very easily.
[17:34] So that is your conduct section where you can add the evaluations.
[17:38] You simply click on this here, select a student evaluation period and also you can fill out the information and etc.
[17:44] And that is our activity sections where you can record the activity for a student if they have taken any enrollment in in your schools projects.
[17:53] So this is our most important module for the regarding to the finance.
[17:58] This is a fee collection and if you want to record a payment just simply click on this record payment.
[18:04] If the fees is a single student fee, just simply make it here, select a student and then you can see I just simply select a student and there is no active fees available.
[18:13] I make the student demo two.
[18:13] Okay, this is
[18:15] the second student.
[18:17] I just simply see and that is the fees which is not submitted to the school.
[18:20] Okay, that is pending.
[18:22] So just simply select it here and right now you can select the payment mode online, check, UPI card and etc.
[18:28] And that is the auto compute.
[18:31] Amount due and payment status are calculated server side from fee plus late fee minus discount versus amount paid.
[18:37] You can override the status above.
[18:40] Okay, so if you want if a parents want to pay for their children, just simply select it here and all the parents will be appeared in the drop down.
[18:47] I just simply select it here the father one and now you can see their children's is loading.
[18:51] So once the children is loading, you can see that is the fee items the monthly.
[18:56] Okay, the tuition fee and if they second one they want to transport fee and the third one they want to pay for the admission.
[19:01] So right now the total remaining due is 7300 and you just simply select a payment mode, transaction ID, remarks and save three payments.
[19:08] Okay, you understand them?
[19:10] Yes, you understand them and there is a feature how much they have paid, how much late fees, and how much disc and
[19:16] etc. So, this is our fee module.
[19:19] And that is our daily accounts.
[19:20] If you want to add a new entry, you just simply add it here.
[19:25] A category, amount, payment mode, party name, payment etc.
[19:27] Everything you can do it here.
[19:29] Okay, and that is our fee structure.
[19:31] You can define the fee, admission fee, annual fee, exam fee, transport fee, tuition fee, and also everything you can make it here.
[19:38] And in the fee collection system you can simply print the fee payment receipt as well.
[19:42] And also if you want to simply send the email, you just simply click on this email receipt.
[19:48] And also there is a feature refund if you want to refund the payment as well.
[19:52] So, there's we can add the fee items, the fee categories, how much we have we need to take them for this particular category.
[19:58] And that is our help desk system, which is available in that uh parents or the students module.
[20:04] You simply raise a ticket, pick a student from the drop down, and also subject description, priority, status, assigned to, and etc.
[20:13] And that is our complaint section where you can file a complaint.
[20:15] And that is accessible from the teacher
[20:17] side. Teacher can make the complaints
[20:19] for the student. And that is the
[20:21] document. You can see that is the other
[20:23] copy student one. And if you want to
[20:25] approve them, you just simply click on
[20:27] this verify icon and that's it. And that
[20:29] documents will be approved and as
[20:31] verified. And that is our users and
[20:33] staff section. If you want to add a more
[20:36] user and staff section, you can do it
[20:37] here. And there is a one quick access
[20:40] more feature. This is a teacher. If I
[20:42] want to check out the today's to today's
[20:44] schedule for this teacher, you just
[20:45] simply click on this icon. And right now
[20:47] you can able to see here that are the
[20:49] today lectures for this teacher. And if
[20:51] you want to check out the teaching
[20:53] assignments, you can also check out them
[20:55] from your users and staff section
[20:57] quickly. Okay, you understand them? And
[20:59] if you want to check out the recent
[21:01] logbook, you can also check out them
[21:03] last 30 days, last 7 days, last 60 days,
[21:06] 90 days, etc. You can track it from
[21:08] here. And also that is my account
[21:10] section where you can update your
[21:11] profile information. And this is the
[21:13] setting section
[21:15] where you can make the school settings
[21:16] like the school name, the short name,
[21:19] the logo URLs, the school email, contact
[21:21] number, the website, the address, the
[21:24] admin name, the admin email, the current
[21:26] academic year, the current symbol, the
[21:28] time zone, etc. And also the academic
[21:30] year's date as well.
[21:32] That is the theme and colors. You can
[21:34] customize the complete dashboard as per
[21:36] your own preferred colors. Just simply
[21:38] apply the colors and the complete
[21:40] dashboard will be changed to your color
[21:42] schemes. And you can make your colors as
[21:44] per your need. And that is our about app
[21:46] section where you can easily able to see
[21:48] here what admin can do in the system
[21:50] because right now the video is already
[21:51] too much long. So I there is a about app
[21:54] section where you can check out them
[21:56] what admin can do, what a supervisor can
[21:58] do, what a clerk can do in the system,
[22:01] and also what a teacher can do, what a
[22:03] student can do, what a parent can do in
[22:06] your school management system.
[22:08] And if you want to connect this
[22:10] particular school management system to
[22:12] your custom domain, just simply go to
[22:14] the YouTube and go to my channel. And
[22:16] here a search icon, just simply enter
[22:18] here the custom domain. So we you will
[22:20] find these two videos, how to use a
[22:22] custom domain with Google Apps Script
[22:24] and how to connect your Google web app
[22:26] to a domain. It's easy using the
[22:28] blogger. So you can watch this video to
[22:30] make this with to make the integrations
[22:32] with your custom domain. So we thank you
[22:34] very much. Hope you like this system. We
[22:36] have put a lot of efforts to build this
[22:38] complete system. And we aim to provide
[22:40] more complete solutions in near future.
[22:42] Thank you very much.