Attendance Certificates for Students with 100% Attendance

You may wish to generate attendance certificates for only students who have 100% present attendance and no Late marks. To enable you to select this student group, you need to first set up these students as a custom group created from a custom report.

Creating the Custom Report

The first step you need to take is to build a custom report containing your students with 100% attendance. Follow these steps:

• Go to School > Custom Report Writer
• Click the green Create new report button.
• Add a Title to your report and leave the Report Focus on Students. 
  
  
• Set the date range for the students you want to include, then click Next.
• Skip through the setup until you get to Step 6 (adding filters)
• Click the Select filter drop-down and choose Lesson Attendance (Present)
• Click Set parameters
  
  
• On the Edit Filter slide-over, set the date range between which the students need to have been 100% present (this filters out students who did not have perfect attendance between those dates).
  
• For the filter condition, make sure to keep 'Statistic Greater than or Equal to' (this is the default), and enter the Filter Value as 100.
• Click Save.
  
  
• Next, add another filter, 
• Click Skip setup wizard
• On the next page, click Save & View Report

You now see a report showing you all of the students who have 100% present attendance between the date ranges you specified.

Creating the Custom Group

Now that you have the relevant students listed in a Custom Report, you can use the custom report to add your students to a custom group. To do this, follow these steps:

• While viewing your report, tick the top tickbox to select all of the students.
• Click the green Bulk Action button
• Select Add to Custom Group
  
• On the slide-over, go to the Add to New Group section.
• Give your group a name and add From and Until dates - make sure these dates cover the attendance period you want to include in your certificates, so if you want attendance certificates for the whole academic year, make sure these dates reflect this.
• Click Add x Members to finish creating your group.
• 

Select the Date Range you wish to collect the attendance for. In this example, the list of students will show all those with 100% Attendance from the start of the Academic Year to the Present Day.

Make sure to keep 'Statistic Greater than or Equal to' (this is the default), and enter the Filter Value as 100.

Next, you'll need to add another membership criteria to filter out late marks. Click into the Setup tab again to add another criterion.

Click the dropdown bar under the Automatic Membership Criteria section and select Lesson Attendance (Late), then click the green Add Membership Criterion button.

Change the Date Range to the range you want to collect the attendance for. Change the filter in the Filter Condition section to 'Numerator (Raw Number) Less than or Equal to', and keep the Filter Value as 0.

Your Setup tab should look like the screenshot below.

Using the Custom Group for your Attendance Certificates

Follow this article: Print Attendance Certificates for groups or individual students You'll be able to select your custom group when selecting students.