Finding the percentage of your students who are absent

Some local authorities are requesting figures for the percentage of your students who are absent due to the impact of Covid-19.

We don't have a field that will automatically calculate the percentage for you, but it's easy to get the numbers out to calculate this. In this article, we'll show you how to create a custom report to help enable you to calculate this figure.

 

Step 1 - Find your number of students enrolled

Go to Students > Enrolment > Statistics, and change the dates in the filter to the date range you need to report on. You'll be able to see how many students were enrolled in your school during that time.

In my example, there are 695 students.

Screenshot_2021-03-09_at_10.19.16.png

 

Step 2 - Find the number of students with specific marks

Go to School > Custom Report Writer and click to create a new report about Students.

For the date range, choose the date rang you want to report on students for. For example, if you select 'last term' it will include any students who were enrolled last term. 

Screenshot_2021-03-09_at_10.27.30.png

 

In the next step, you can add the Attendance (Specific Marks) column. You can either:

  • Add a separate column for each attendance mark you want to track
  • Add the column once to track all the codes you want to report on together

Screenshot_2021-03-09_at_10.37.20.png

 

In the slide over, be sure to change the Format to Numerator and the Summary Row Formula to Sum.

Screenshot_2021-03-09_at_10.39.35.png

 

Add a filter for the same specific marks.

Screenshot_2021-03-09_at_10.46.17.png

 

In the slide over, be sure to change the Filter Value to 1.

Screenshot_2021-03-09_at_10.47.09.png

 

Then click to Save and View Report. It will show you only students who have been marked with one of these codes during the date range you chose. The summary row tells you the number of students that are included.

In my example, there are 28 students.

Screenshot_2021-03-09_at_10.54.44.png

 

Step 3 - Calculate your percentage

To find the percentage, divide your enrolment number by the custom report number.

28 รท 695 = 0.04

0.04 x 100 = 4% of students had one of these marks during the date range. 

Was this article helpful?
0 out of 1 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.