School Exams Result System – MS Excel Files

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

In this case the following three sheet will work to present a complete result of a student.

Exam Sheets
Exam Sheets
Grades Sheet

Remarks according to grades are determined here and range name is given as “Grade”

Grades sheets
Grades sheets
Marks Sheet

In this sheet we has 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.)

Marks
Marks Sheet

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

Subject Marks Sheet
Subject Marks Sheet

Every Subject File sheet is Password Protected sheet so that Teacher can not change any thing in Student code, Name, Fathers Name and class (See below). Teacher is allowed only to add/change students marks

Subject Marks Sheet - Lock and Unlock cells
Subject Marks Sheet – Lock and Unlock cells

Note: How to Lock and Unlock cell during protection

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

Fetched Data from Subject Files
Fetched Data from Subject Files

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

Total Marks
Total Marks
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 an other result of other student. Give a PRINT command to print the result sheet.

Result Sheet
Student Final Examination Result Sheet
This examination fold is placed in main School Management System zip file.
Download Refreshed File