How can I determine perfect attendance in PowerSchool?

If you want a quick way to determine which students have perfect attendance, there are two ways to use the Quick Export feature to do so, but it all depends on how you determine what perfect attendance is.  In this article we take two approaches:

  • Perfect Attendance Method #1:  A student has perfect attendance if they have never been absent for the entire day.  (Daily)
  • Perfect Attendance Method #2:  A student has perfect attendance if they have an absence of specific codes for a specific period.  (Period)

You will need to make a student selection and select the Quick Export function.  If you are not familiar with how to do that, refer to the article here.

Perfect Attendance Method #1 (Daily)

Description

This method is applicable to schools looking for the attendance of an entire day.  This may be because you have multiple or complex periods, or do no require the details that the period would provide.

According to historical Data Access Tags Supplement files published by PowerSchool, the code below is described in the following ways:

  1. Displays the total number of daily absences for the date range.
  2. Returns a numerical count of the total daily absence value as calculated by the attendance conversion. Because the attendance conversion is used, the DAT may be based on either Meeting, or Daily attendance, depending on which is set as the default for the FTE of the student reported on.

Quick Export Code

Student_number
lastfirst
Grade_level
~(*DM;8/1/20XX;7/31/20YY;format=##0)
~(*DABS;8/1/20XX;7/31/20YY;format=##0)

  • 8/1/20XX can be set for a date that is on or before the first day of the perfect attendance date range.
  • 7/31/20YY can be set for a date that is on or after the final day of the perfect attendance date range.

Analyzing the results

If executed correctly, your downloaded file should look similar to this screenshot when opened in a spreadsheet program:

20140129 1137 Capture

The red code in Column D represents the code:

~(*DM;8/1/20XX;7/31/20YY;format=##0)

and represents the total number of days that a student has been enrolled.  Think of this as the # of days possible.

The blue code in Column E represents the code:

~(*DABS;8/1/20XX;7/31/20YY;format=##0)

and represents the number of daily absences during the date range specified.

Perfect attendance will be any student that has a value of Zero in Column E!

Perfect Attendance Method #2 (Period)

Description

This method is applicable to schools looking to isolate the attendance for a specific period.  This may be because you use an attendance period, or only want to know what attendance is like at the end of the day, after lunch, etc.

According to historical Data Access Tags Supplement files published by PowerSchool, the code below is described in the following ways:

  1. Displays the total period attendance codes for the specified period.
  2. Returns a numerical count of the meeting attendance records for an individual student’s classes matching the specified expression. The expression parameter is required. The expression used will only return results for class enrollments with a matching expression. For example, entering the expression of 1(A) will not return results for the first period of a class with an expression of 1-2(A).

Quick Export Code

Student_number
lastfirst
Grade_level
~(*DM;8/1/20XX;7/31/20YY;format=##0)
~(per.att;P1(A);AU,AE,TE,TU,AS,TO;8/1/20XX;7/31/20YY)

  • P1(A) can be replaced with the appropriate period expression.
  • AU,AE,TE….can be replaced with a list of the attendance codes you wish to count.  You can find a list of attendance codes at Start Page > School (Setup) > Attendance Codes (Attendance)
  • 8/1/20XX can be set for a date that is on or before the first day of the perfect attendance date range.
  • 7/31/20YY can be set for a date that is on or after the final day of the perfect attendance date range.

Analyzing the results

If executed correctly, your downloaded file should look similar to this screenshot when opened in a spreadsheet program:

20140129 1153 Capture

The red code in Column D represents the code:

~(*DM;8/1/20XX;7/31/20YY;format=##0)

and represents the total number of days that a student has been enrolled. Think of this as the # of days possible.

The blue code in Column E represents the code:

~(per.att;P1(A);AU,AE,TE,TU,AS,TO;8/1/20XX;7/31/20YY)

and represents the number of occurrences of any of the attendance codes specified for the date range.

Perfect attendance for that period will be any student that has a value of Zero in Column E!

Updated on May 8, 2018

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Do NOT follow this link or you will be banned from the site!