Objective

Create a complete system to manage student information, marks, attendance and performance.

Worksheets

  1. Student_Data
  2. Marks
  3. Attendance
  4. Result
  5. Student_Dashboard

Key Features

  • Student ID
  • Student Name
  • Class
  • Section
  • Subject
  • Marks
  • Attendance %
  • Total Marks
  • Percentage
  • Grade
  • Pass/Fail

Important Formulas

Total Marks

=SUM(C2:G2)

Percentage

=H2/500*100

Grade

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

Result

=IF(I2>=40,”Pass”,”Fail”)

Practice

Create a dashboard showing:

  • Total Students
  • Average Marks
  • Highest Marks
  • Pass %
  • Class-wise performance
  • Grade-wise distribution
PreviousNext