How to calculate attendance percentage (with a worked example)

Bridge team ·

Attendance percentage is one number, but it decides whether a student can sit an exam. Here is how to work it out by hand, and how to answer the question parents ask next: “how many days does my child need?”

The formula

Attendance percentage = days present ÷ working days × 100

Count only the days the school was open for that student’s class. Holidays and Sundays are not working days, so they are not in either number.

A worked example

A class has had 120 working days so far. A student was present on 84 of them.

84 ÷ 120 × 100 = 70%

If your school’s cut-off is 75%, this student is below it.

How many days to reach the cut-off

Every day the student attends adds one to both numbers: days present and working days. So you cannot just add the missing days. Use this instead:

Days needed = (required % × working days − 100 × days present) ÷ (100 − required %)

For the example: (75 × 120 − 100 × 84) ÷ (100 − 75) = 600 ÷ 25 = 24 days.

Check it: 84 + 24 = 108 days present out of 120 + 24 = 144 working days, which is exactly 75%. The student must attend the next 24 school days without a miss.

Things that change the answer

  • Late arrivals. Most schools count a late arrival as present. Decide once and apply it to everyone.
  • Excused absences. Some schools leave medical leave out of the count. If yours does, remove those days from the working days for that student.
  • The cut-off itself. Many boards ask for 75%. Use the rule your board and school follow.

A percentage on its own does not help a parent. “Attend the next 24 days” does.

You can skip the arithmetic with the attendance percentage calculator.

Keep reading

Set up your school in an afternoon.

30-day trial. No card needed. Import students from a spreadsheet.

Start 30-day trial