Is there a way to extract percentage attendance rates?
Use the Attendance Rates Report to extract 'Percentage By Student' or 'Percentage by Subject' reports.
Alternative option
Navigate to Student Admin > Attendance > Listings & Reports and run the ‘Rollcall History’ report. This report displays the days the student was present and days they are absent.
If you export these results to a spreadsheet, it’s possible to manipulate the data using a program like Microsoft Excel (using ‘SUMS’ to calculate the percentage per student and/or per year level).
Below are a couple of formulae examples:
Days Present… =COUNTIF (E3:N3, “P”)
Percentage… =Q5/100
We do not usually make suggestions on how to manipulate data in spreadsheets; neither do we assist with using Microsoft Excel.