This is an old revision of the document!
YTD Attendance
Two methods for tallying up the Absences, Tardies, and Early Dismissals for a set of students are explained below.
Select a set of students then use the Print Report option to run the YTD Attendance Status report.
The report can be run so the results are ordered alphabetically, by grade, period or
Quick Export for Attendance Totals
Quick Export Fields:
student_number
lastfirst
grade_level
Home_Room
'^(daily.att.count;;abs)
'^(daily.att.count;;TDY)
'^(daily.att.count;;UTD)
'^(daily.att.count;;DSM)
'^(daily.att.count;;UDS)
To create a list of students with Zero (0) Absences, no unexcused Tardies nor unexcused Early Dismissals, and 8 or more Excused Tardies and/or Excused Early Dismissals:
Select the students, All, by Grade, or by Teacher
Select Quick Export for the selected students
Export using the fields listed above
Take the results text file and save it to the Desktop
Open MS Excel
Import the results text file into MS Excel
Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS"
Filter on the Abs column = 0
Filter on UTD = 0 and UDS = 0
Confirm the Combination of TDY and DMS totals less than or equal to 8
To create a list of students with 3 or less Absences, no unexcused Tardies nor unexcused Early Dismissals, and 8 or more Excused Tardies and/or Excused Early Dismissals:
Select the students, All, by Grade, or by Teacher
Select Quick Export for the selected students
Export using the fields listed above
Take the results text file and save it to the Desktop
Open MS Excel
Import the results text file into MS Excel
Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS"
Filter on the Abs column to show 0, 1, 2, 3 values
Filter on UTD = 0 and UDS = 0
Confirm the Combination of TDY and DMS totals less than or equal to 8