School Management System – MS Excel File

School Management System – MS Excel Files

I have tried to construct and cover every financial aspect related to academy, and I am sure you will get help from it.

In this group of excel files, you will find.

1. Staff Management

2. Student Database Management

3. School Fee Collection

4. Staff Salary management

5. Student Fee Card Management

6. Profit and Loss Account Sheet

7. School Examination and Result System

Staff Management – MS Excel Files

Staff Salary – MS Excel Sheet

Staff Member Database

In this sheet, we will input data about staff, i.e.

• ID No
• Employee Name
• Designation
• Joining Date
• Basic Pay
• Deduction
• Allowance
• Net Salary

We will now give the name of staff member data table (Range).  In this case Staff Data table is named as Staff Detail.

Salary Record

Salary Record entries will work the same as Student Fee collection Record works. select the table range and give it the name.

Salary Slip

This is the last sheet of Salary File, in which we will print the salary payable. we will pick the value from Salary Record sheet (not Staff database)

The highlighted value is Employee’s ID that will fetch the employee’s information. you can also change total working days. For example, an employee came in our school in the mid of the month, then you need to change total working days 30 to 15 or any other value according to requirement. Always Print 2 copies, one for employee and other for your hard record.

Student Database Management – MS Excel Sheet

This is the first sheet that is very important for the rest of evaluation and calculation. You cannot calculate anything unless the completion of this sheet.

In this first sheet you will find the following important headings

• Admission No.
• Student Name
• Guardian
• Class
• Fee
• Contact
• Gender
• DOB (Date of Birth)
• Admission Date

Student DB

Student Database Sheet is named as “Student DB”. Select all the table range of your student database list and give it name

While typing fee value, it is possible that you type wrong value, (i.e., to type 1400, you have typed 14000 mistakenly) to avoid this we need to create fee rules so that if we type class value, its fee value automatically written in next column with the help of vlookup formula.

Student Fee column will work with “vlookup” formula. School fee column value is fetched with vlookup formula from another sheet (Rules.xml)

Rules Sheet

In this sheet we will manage all the rules they might be used in other function of other sheets. In the following figure you see only one table of Class fee rules from Play Group (PG) to 10th standard. In this sheet, there are only two columns (Class Name and Fee). 

Student Fee Collection System – MS Excel Sheet

Fee collection sheet is very simple to use. fee entry will be done with only single input of Admission No (Student ID). 

“vlookup” formula has been inserted and when you will enter the admission number of concern student, his fee entry will be made automatically. In above picture, ADM18-14 input fetched its related information from Student Database Sheet. See Below

Staff Salary – MS Excel Sheet

We will manage three sheets in this File, as seen below.

Staff Member Database

In this sheet, we will input data about staff, i.e.

• ID No
• Employee Name
• Designation
• Joining Date
• Basic Pay
• Deduction
• Allowance
• Net Salary 

Salary Record

Salary Record entries will work the same as Student Fee collection Record works. select the table range and give it the name.

Salary Slip

This is the last sheet of Salary File, in which we will print the salary payable. we will pick the value from Salary Record sheet (not Staff database)

The highlighted value is Employee’s ID that will fetch the employee’s information. you can also change total working days. For example, an employee came in our school in the mid of the month, then you need to change total working days 30 to 15 or any other value according to requirement. Always Print 2 copies, one for employee and other for your hard record.

Academy Fee Card – MS Excel Sheet

The following is the snapshot of inner side of academy fee card of a student.

On inner side of this card, there are two side, one has fee schedule of whole of the year and other side describes student detail (Name, Class, Guardian, and fee value)

You can change it according to requirements.

Right side of this card-based students’ properties. All the items are fetched with student ID No with vlookup formula (As shown below).

Changing Student ID will change the whole of the information about the student. No need to change all items one by one, just change student ID to get its data.

PL Account – MS Excel Sheet

PL Account have two Main Side. that will display all the information about school cash flow.

1. Revenue Side (that contains all those entries which involve CASH IN)

2. Expense Side (that contains all those entries which involve in CASH OUT)

School Examination Result System – MS Excel Files

 School Examination Result System – www.clickmetolearn.com

In last post we have built a successful academy management system, and Now we are going to introduce School Examination Result System totally built in MS Excel.

In this case the following three sheet will work to present a complete result of a student. Dont mint the data on one sheet because when you get students in thousand then it may relate difficulties for you.

Grades Sheet

Remarks according to grades are determined here. Whole table shows range name as “Grade”

Marks Sheet

In this sheet we have input marks of the class students. Students’ attributes are fetched with the help of vlookup formula from Student Database sheet based on Student ID No (Admission No.)

Next step is to enter the marks of the students so Create the same separate file with marks sheet and give that sheet to concern teacher to add marks.

Subject Marks Sheet

Every Subject File sheet is Password Protected sheet so that Teacher cannot change anything in Student code, Name, Fathers Name and class (See below). This protection allows Teacher only to add/change students marks

Collect all the sheets from all teachers and fetch their marks to main sheet.

Fetched Data from Subject Files

You need to review total marks of every subject written on the top of every subject column, see below

Results Sheet

Now jump to third sheet. Complete Result sheet is ready to print the result of a student. Just change the Admission No. to fetch another result of other student. Give a PRINT command to print the result sheet.

Done, Enjoy the complete Academy Examination System. If you want to add more feature in this sheet, please write us because we work for you.

Thank you!

School Management System Download Free | Ms Excel 365