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.
Remarks according to grades are determined here and range name is given as “Grade”
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.)
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.
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
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
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.
Download Refreshed File