Summary Attendance Summary errors
By Sharon VanCleave
August 22, 2010

In August at the PowerSchool Users Conference in Kearney, several people were asking questions about the Student Attendance Summary having errors of students being over the # of days in session. I copied the following information from p. 68 of the Nebraska State Reporting Setup Guide published on August 16, 2010.

The table didn't copy very good, but the first column is Periods Absent and the second column is Days Attendance Value.


Attendance Conversion Example
To minimize possible rounding error in the Student Summary Attendance extract, it is recommended that you set up Attendance Conversions at your district with one decimal place only. NDE does not accept two decimal places on the DaysPresent, DaysAbsent, or DaysTruant fields on the extract. Use attendance conversions set to 0.1, 0.2, or 0.5 increments as detailed in the example below.
Periods Absent   Days Attendance Value
0    1
1   0.9
2   0.8
3   0.7
4   0.5
5   0.3
6   0.2
7   0.1
8    0
Do not use Attendance Conversions set to 0.25 or 0.125 as that will result in rounding errors. See the example below.
Example: If a student misses 2 of 8 periods in the day, the attendance value will be 0.25 absent and 0.75 present. These numbers are rounded up to one decimal place on the Student Summary Attendance extract resulting in 0.3 and 0.8. This totals 1.1 which is greater than the possible value of 1 for the day.
Example: A student has 161.8 days attended and 12.3 days absent. This totals to 174.1 which is greater than the amount of school days in the calendar (174). This causes the student record to error at the state.