This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
powerschool:powerschool:ytd_attendance [2019/05/07 14:23] lokes [Quick Export for Attendance Totals] |
powerschool:powerschool:ytd_attendance [2019/05/15 15:33] lokes [Quick Export for Attendance Totals (Presidential Award Candidates)] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== YTD Attendance ====== | ====== 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, | ||
{{: | {{: | ||
+ | The unexcused UTD and UDS are listed to avoid a situation where a student is chronically late, but never absent for the entire day. | ||
Line 19: | Line 23: | ||
' | ' | ||
- | 1 - Select the students, All, by Grade, or by Teacher | + | 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: |
- | 2 - Select Quick Export for the selected students | + | |
- | 3 - Export using these fields: | + | - **Example: // |
- | student_number | + | |
- | lastfirst | + | - Export using the fields |
- | grade_level | + | - Take the results text file and save it to the Desktop |
- | Home_Room | + | - Open MS Excel |
- | ^(daily.att.count;; | + | - Import the results text file into MS Excel |
- | ^(daily.att.count;; | + | - Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS" |
- | ^(daily.att.count;; | + | - Filter on the Abs column = 0 |
- | ^(daily.att.count;; | + | - Filter on UTD = 0 and UDS = 0 |
- | ^(daily.att.count;; | + | - Confirm the Combination of TDY and DMS totals less than or equal to 8 |
- | 4 - Take the results text file and save it to the Desktop | + | 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: |
- | 5 - Open MS Excel | + | - Select the students, All, by Grade, or by Teacher |
- | 6 - Import the results text file into MS Excel | + | - Select Quick Export for the selected students |
- | 7 - Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS" | + | - Export using the fields listed above |
- | For the first list: | + | |
- | 8 - Filter on the Abs column = 0 | + | - Open MS Excel |
- | 9 - Filter on UTD = 0 and UDS = 0 | + | - Import the results text file into MS Excel |
- | 10 - Confirm the Combination of TDY and DMS totals less than or equal to 8 | + | - Change the column headings to reflect the exported data "Abs / TDY / UTD / DSM / UDS" |
- | For the second list: | + | - Filter on the Abs column to show 0, 1, 2, 3 values |
- | 8 - Filter on the Abs column to show 0, 1, 2, 3 values | + | - Filter on UTD = 0 and UDS = 0 |
- | 9 - Filter on UTD = 0 and UDS = 0 | + | - Confirm the Combination of TDY and DMS totals less than or equal to 8 |
- | 10 - Confirm the Combination of TDY and DMS totals less than or equal to 8 | + |