User Tools

Site Tools


powerschool:powerschool:ytd_attendance

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:

  1. Select the students, All, by Grade, or by Teacher
  2. Select Quick Export for the selected students
  3. Export using the fields listed above
  4. Take the results text file and save it to the Desktop
  5. Open MS Excel
  6. Import the results text file into MS Excel
  7. Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS"
  8. Filter on the Abs column = 0
  9. Filter on UTD = 0 and UDS = 0
  10. 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:

  1. Select the students, All, by Grade, or by Teacher
  2. Select Quick Export for the selected students
  3. Export using the fields listed above
  4. Take the results text file and save it to the Desktop
  5. Open MS Excel
  6. Import the results text file into MS Excel
  7. Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS"
  8. Filter on the Abs column to show 0, 1, 2, 3 values
  9. Filter on UTD = 0 and UDS = 0
  10. Confirm the Combination of TDY and DMS totals less than or equal to 8
powerschool/powerschool/ytd_attendance.1557253717.txt.gz · Last modified: 2019/05/07 14:28 by lokes