Tool Search: Day Count

This report determines the total number of days a student has been in attendance based on the minutes entered on the calendar and/or grade level. Attendance counts are reported in whole-day/half-day values or an exact calculation of attendance information. Absence days are counted per student, with the sum of absences reported within each schedule structure.

Day Count Report

Report Logic

A calculation option must be selected. Both options use the Student Day, Whole Day Absence, and Half Day Absence minutes fields entered on the Calendar Information tool.

Screenshot of the Calendar tool with callouts around Student, Whole, and Half Day Absence minutes.

Calendar Minute Fields

If a grade level included in the calendar has minutes that are different from the standard minutes, these minutes are entered in the Grade Level Setup tool and used in the Day Count report when that grade level is selected.

Screenshot of the Grade Levels tool with callouts around Standard Day, Whole Day, and Half Day Absence minutes.

Grade Level Calendar Minute Fields

Report Editor

The following defines the options available on the Day Count Report.

Option	Description
Student Selection	Students can be selected for inclusion on the Day Count Report by selecting either a Grade Level (or multiple grade levels) or an Ad hoc Filter. Available grade levels are based on the calendar selected in the Campus toolbar. Choosing an Ad hoc Filter reports attendance information for only those students in the filter. When creating an Ad hoc filter for this report, carefully test (use caution) when adding fields with multiple results to ensure the query returns distinct rows and does not cause the number of resulting rows to impact the reported number of days absent.
Date Entry	Attendance day count information is included in the report for only those attendance events within the entered dates. Date entry is not required to return day count information; these fields could be left blank to return day count information for the entire school year or from the start of the school through a specific date. Enter Start and End Dates in mmddyy format or use the calendar icon to select dates.
Attendance Days	Determine the number of attendance days to include on the report. These can be left blank, just like the start and end dates; doing this will not limit the number of students who have a certain number of attendance days. Having at Least - The entered value will only return students with this number of attendance days. This field could be used to remove students from the report with no attendance events. Having at Most—The entered value will only return students who have up to this number of attendance days. This field could be used to remove students who are no longer enrolled due to excessive absences.
Calculation Options	The Exact Calculation option sums the student's absent minutes and divides that value by the student's day minutes. The Daily Approximation option estimates the student's absences and sums the value. If a minute value has been added on the Grade Level, these values are used instead of those added at the Calendar level.
Sort Options	The following options can sort the Day Count Report: Name - students print in alphabetical order by Last Name. Grade and Name - students print first in grade level order (starting with the lowest grade level in the selected school), then alphabetically by last name within each grade level. Absent Days and Name - students print first by the number of absent days (highest to lowest), then alphabetically by last name.
Report Format	Determines how the report is generated - in PDF or DOCX format.

Generate the Day Count Report

Select which students to include in the report by selecting a grade level or an Ad hoc filter.
Enter Start and End Dates to limit the range of dates to a set month, week, or even one day.
Enter the Having at Least and Having at Most days of absence values.
Select the desired Calculation Option.
Select the desired Sort Option.
Select the desired Report Format.
Click the Generate Report button. The report prints in a new browser window.

The report prints student names and attendance data in two columns.

Screenshot of the Absence Day Counts Report sorted alphabetically in PDF format. Day Count Report, Alphabetical by Last Name Sort - PDF Format