Objective

Build a complete school examination and result system.

Worksheets

1. Student_Master
2. Subject_Marks
3. Result
4. Grade_Summary
5. Result_Dashboard

Features

• Student ID
• Student Name
• Class
• Roll Number
• Subject Marks
• Total
• Percentage
• Grade
• Result

Formula

Total

=SUM(C2:H2)

Percentage

=I2/600*100

Grade

=IFS(J2>=90,”A+”,J2>=75,”A”,J2>=60,”B”,J2>=40,”C”,TRUE,”F”)

Dashboard

Include:

• Total Students
• Pass Students
• Fail Students
• Pass Percentage
• Highest Marks
• Subject-wise Average
• Grade Distribution