NC Attendance Calculations - TOPIC ARTICLE ONLY

Average Daily Attendance (ADA)

Average Daily Attendance (ADA) for the North Carolina Principal's Monthly Report is based on the student's absent and present status by evaluating Unexcused and Excused absences separately. The student's absent or present status is based on the combined sum of Unexcused and Excused absence time.

Summary of PMR ADA Logic

The following table provides information on how ADA totals are summarized for the PMR. 

Question If Yes… If No…
1.

Have all instructional school days for the selected PMR Month that are marked as both Instruction and School Day in the Day Setup tool been identified? 

Proceed to Step 2.

Mark all applicable days as Instruction and School Day in the Day Setup tool, then proceed to Step 2.

2.

For each instructional day, have the following student‑level procedures been completed? See the table in the Determination of Absent or Present for Individual Days for guidance. 

Proceed to Step 3.

Complete the required steps for each student for that instructional day, then proceed to Step 3.

3.

Have the student’s total present days (in membership and not in violation) for the PMR Month been counted?

Proceed to Step 4.

Count the student’s present days for the PMR Month, then proceed to Step 4.

4. 

Has the total number of instructional days for the student in the PMR School Month been determined?

Divide the student’s total present days in the PMR School Month by the total instructional days in the PMR School Month.


This value is used for attendance reporting.

Identify the total number of instructional days for the student in the PMR School Month, then repeat Step 4.


Determination of Absent or Present for Individual Days

Present/Absent determination references the student day minutes instead of an individual student’s scheduled minutes. The  ADA calculation incorporates logic for calendar days with the Standard Code Day Event of ‘AD.’

The following database fields are used in the calculation: 

  • CampusDictionary.standardCode
  • Day.eventType
  • DayEvent.instructionalMinutes 
  • Calendar.studentDay
Question If Yes... If No...
1. Is the student's Scheduled Instructional Minutes greater than or equal to 50% of the total student day minutes?  Proceed to Step 2. The student is excluded from PMR Reporting. 
2.  For the Instructional Day being analyzed, does the day have a Day Event scheduled with a Standard Code Day Event of AD?  The Instructional Minutes from the Day Setup are used as the denominator for the student's individual day absence calculation.

Proceed to Step 3.
If there is more than one Day Event scheduled on that day with a Standard Code of AD, and more than one Day Event has Instructional Minutes added, the average of the Instructional Minutes from the Day Events that have a Standard Code of AD is used as the denominator for the student's individual day absence calculation.

Proceed to Step 3.
The Student Day Minutes from the Calendar Information are used as the denominator for the student's individual day absence calculation.

Proceed to Step 3.
3. For the day being analyzed, SUM the Excused and Unexcused Absence Minutes for the student and divide by the identified denominator in Step 2.

Is that total greater than 50%?
The student is considered ABSENT. Proceed to Step 4. 
4.  Of the student's scheduled minutes, are any of those courses scheduled during a period marked as Non-Instructional?  The student is considered ABSENT.  The student is considered PRESENT. 

In Membership

A student is considered In Membership when ANY of the following are true:

  • The student is on-site AND at least 50% present on their first day of enrollment. 
  • The student is enrolled in Staggered Kindergarten AND assigned to be at home on the first day of school. 
  • The student has a primary enrollment with an Admission Status of MST1: Member - Standard Day Program or MED1: Member - Extended Day Program AND scheduled more than 50% (this is an exact - not rounded -  calculation; students scheduled 49.9% of the day are not eligible). 
  • The student is identified as Medically Fragile (has attendance records with a State Code of 1S: Hospital/Homebound). 
  • The student is enrolled in a publish school AND in a Teacher-in-Treatment Program (has attendance records with a State Code of 1H: Teacher-in-Treatment).  
  • The student is scheduled into one or more NC Virtual Public School courses AND NOT enrolled in a private school or home school
  • The student's enrollment has a State Grade Level of Pre-K and an Admission State of MST1: Member - Standard Day Program.

Not In Membership

A student is considered Not In Membership until the first day the student is in attendance. 

A student is considered Not In Membership when ANY of the following are true:

  • It is before the start date of the enrollment record. Students who are not present on their initial enrollment day must have their Enrollment Start Date moved forward until they have met the requirements to be present. 
  • The student is not enrolled in Staggered Kindergarten or is enrolled in Staggered Kindergarten but not in attendance on the first day of enrollment. 
  • The student's Admission Status on the Enrollment record is VST1: Visitor - Standard Day Program/Foreign Exchange Student. 
  • The student has a primary enrollment with an Admission Status of MST1: Member - Standard Day Program or MED1: Member - Extended Day Program AND scheduled LESS than 50% (this is an exact - i.e., not rounded - calculation; students scheduled 50% of the day are eligible).  

In Violation

The student is considered In Violation (also known as the 10-Day Rule) when ANY of the following are true: 

  • The student has ten consecutive absences marked as unexcused based on the date the report is generated.
  • Examples:
    • When a student has nine days of consecutive absence at the end of PMR 1 and one day of absence at the start of PMR 2 [Total of 10 consecutive absence between 2 school months], and the report is generated on the first day of PMR2, the student does not meet the requirements of being in violation. 
    • When a student has nine days of consecutive absence at the end of PMR 1 and one day of absence at the start of PMR 2 [Total of 10 consecutive absences between 2 school months], and the report is generated on the second day of PMR2, the student does meet the requirements of being in violation. 

Not in Violation

The student is considered Not In Violation when ANY of the following are true: 

  • The student is present for that day.
  • The student has an attendance record for that day with one of the following State Codes:
    • 1H: Teacher-In-Treatment
    • 1M: Medically Fragile
    • 1S: Hospital/Homebound
    • 1R: Present Off-Site
    • 1Q: School Sponsored Activity
  • The student has an attendance event that does not have one of the State Codes above and is NOT considered in violation (marked absent for ten consecutive days) 
  • The student is considered to be in violation but is marked present (no attendance events) on the 11th day. 
  • The student was suspended for any length of time. 
  • When the student has 10 consecutive unexcused absences causing violation days and returns on the 11th day or after in one PMR interval (school month), the 10 or more consecutive days remain as violation days, but the student does not show as a membership violations, and continues to be counted in membership.

Basic PMR Calculation

This report uses the following guidelines for most of the reported fields. 

When... Then...
When Grade Level is STANDARD
  • The student's Admission Status (Enrollments > State Reporting Fields > Admission Status) needs to be MST1: Member - Standard Day Program OR MED1: Member - Extended Day Program.
  • The State Grade Level Code CANNOT be one of the PK, P0-P3.
When Grade Level is STANDARD TOTAL All standard enrollments are summed.
When Grade Level begins with XG The State Grade Level Code needs to be UG (Ungraded). 
When Grade Level begins with XG Total All XG enrollments are summed.
When Grade Level begins with School Total The sum of Standard Total, XG Total, and Extended Total reports.
When Grade Level begins with PK
  • The student's Admission Status (Enrollments > State Reporting Fields > Admission Status) needs to be MST1: Member - Standard Day Program.
  • The State Grade Level Code must be PR, PK, or P0-P3.