This is an old revision of the document!
YTD Attendance
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