In last post we have build a successful school 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 reate 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.
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). This protection allows Teacher only to add/change students marks
Note: How to Lock and Unlock cell during protection
Collect all the sheets from all teachers and fetch their marks to main sheet.
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 an other result of other student. Give a PRINT command to print the result sheet.
Done, Enjoy the complete School Examination System. but if you dont have MS Office then you can djownload Legal Copy from official website of Microsoft. If you want to add more feature in this sheet, please write us because we work for you.