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
PreviousNext