BIE Adverse Attendance Conditions Report

Path: BIE Reports > BIE Adverse Attendance Conditions Report
Search Terms: BIE Adverse Attendance Conditions Report

The BIE Adverse Attendance Conditions Report provides a way for states to report the impact adverse weather and road conditions have on student attendance. Information provided by this report may assist with federal funding procurement and distribution, busing changes and other necessary transportation changes to meet the needs of students affected by adverse weather and road conditions.

This report only considers students absent 50% or more of their scheduled school day with an attendance record tied to the following BIE Attendance Codes:

  • AWC: Adverse Weather Conditions
  • ARC: Adverse Road Conditions

The BIE Adverse Attendance Conditions Report is only available in State Edition sites. 

Screenshot of the BIE Adverse Attendance Conditions report editor.BIE Adverse Attendance Conditions Report

Report Logic

This report uses the following logic:

Click here to expand...

Students:

  • Student has a primary enrollment in the reporting calendar
  • Student must have a NASIS ID
  • Enrollment must not marked BIE Exclude 
  • Enrollment must not be marked No Show 
  • Enrollment Start Date and End Date must not be the same
  • Student's attendance must have been included in the Aggregated Attendance calculations
  • Unlike other BIE reports, all students (regardless of their enrollment type) will be included in the report assuming all other criteria has been met

School/District:

  • Attendance Codes are mapped to BIE Attendance Codes ARC and AWC for all calendars
  • DIS is enabled and synced

Calendar:

  • Calendar must be marked as BIE Type I:Instructional
  • Aggregate attendance MUST be calculated for the calendar to be included in reporting
  • Calendars marked as 'Excluded' will not report
  • Calendar dates falling outside of the date range entered in the BIE Adverse Attendance Conditions editor will not report
  • Calendars where one or less days are marked Instruction will not report

Aggregate Attendance Calculation:

The following aggregate attendance logic applies for adverse attendance calculations. A student who's attendance has not been aggregated will not be included in the reports.

For each day a student is enrolled, aggregate attendance calculations will:

  • SUM the total number of minutes the student is scheduled (rostered). The following requirements must be met for scheduled minutes to be included in aggregate attendance calculations:
    • Course must be marked for attendance
    • The period must be instructional
    • The day must be marked for attendance

Lunch minutes, future dated attendance records and exempt absences are not included in aggregate attendance calculations. 

  • SUM the total number of minutes the student is absent (Status = Absent; Excuse = Excused, Unexcused or Unknown).
    • This calculates by subtracting the Present minutes on the period from the total number of absent minutes
  • SUM the total number of days the student is scheduled (rostered).

Comparing the total number of minutes the student is scheduled for a day against the total number of minutes the student is absent for a day, federal days absent is identified as the number of days a student is more than 50% absent.

Attendance calculations for this report will be aggregated for students who have an enrollment in multiple calendars.

Tool Rights

Classic Path: System Administration > User Security > Users > Tool Rights > BIE Reports > BIE Adverse Attendance Conditions Report

In order to generate this report, users must have the Read tool right to the BIE Adverse Attendance Conditions Report. 

ReadWriteAddDelete
User can view and generate the BIE Adverse Attendance Conditions Report.Write tool right is not required to use this report.
Add tool right is not required to use this report.Delete tool right is not required to use this report.

Generate a Report

Before you start, consider the following. 

  • On a weekly basis, district-level data is automatically synced to the state. To capture attendance changes happening between syncs, a state administrator might consider manually running the Resync State Data tool to reflect more up-to-date data in attendance reports and chronic absenteeism calculations.
  • On a nightly basis, an automated attendance aggregation job processes the prior days attendance and recalculates the chronic absenteeism fields for each student. Because this job only looks at changes made to attendance fields the day prior, backdated attendance changes may not be included.  To ensure all attendance data (including any backdated changes) are included in the attendance aggregation, recommend to your districts they periodically run the Attendance Aggregation Refresh tool.

If both tools are used for the purpose of reflecting the most up-to-date attendance at the state level, Attendance Aggregation Refresh should be run first followed by the Resync State Data tool. 

  1. Select a Report Type from the two options available. 
    • Summary: Provides the statistical information needed to procure funding and is used for submitting to federal agencies.
    • Detail: Provides necessary student demographic information (name, grade, NASIS ID, etc.).
  2. Select one or both Attendance Codes
  3. Enter a start date and end date for the Report Date Range. If no date is entered, the earliest calendar start date and latest calendar end date (among all selected calendars across all schools) will apply.
  4. Select a School Year. Year will default to the year identified in the tool bar. 
  5. Select one to multiple schools from the school list under School
  6. Select Generate Report or Submit to Batch. Depending on the Report Type selected, the following formats are used:
    • Report Type:
      • Summary: Report generates in PDF
      • Detail: Report generates in CSV

Summary Report

The Summary Report provides statistical information necessary to procure federal funding. All calculations in the report are representative of student counts and attendance marks identified within the report date range entered.

Screenshot of an example of the BIE Adverse Attendance Conditions Summary Report.BIE Adverse Attendance Conditions Summary Report

Understanding the Summary Report

Only students marked absent with the BIE Attendance codes ARC and/or AWC for 50% or more of their scheduled day are included in report totals. If a student has an enrollment in more than one calendar, attendance will be aggregated across all calendars for the student.

FieldDescriptionLocation
SchoolThe name of the reporting school and the BIE Group Number

System Administration > Resources > School > Name


System Administration > Resources > School > BIE Group Number


Database:

School.name

School.ncesSchoolID

# Days ARCThe total number of instructional days within the reporting window where one or more students have been affected by adverse road conditions.

If no students are identified then 0 reports.
Calculated field


# Student Affected ARCThe total number of students affected by adverse road conditions within the report date range.

If no students are identified then 0 reports.

Calculated field


% ARCThe percentage of instructional days affected by adverse road conditions within the school.

Calculation:
 # Days ARC / Total Instructional Days

Calculated field



# Days AWCThe total number of instructional days within the reporting window where one or more students have been affected by adverse weather conditions.

If no students are identified then 0 reports.

Calculated field


# Student Affected AWCThe total number of students affected by adverse weather conditions within the report date range.

If no students are identified then 0 reports.

Calculated field


% AWCThe percentage of instructional days affected by adverse weather conditions within the school.

Calculation:
 # Days AWC / Total Instructional Days
Calculated field
# Days Adverse AbsentTotal number of instructional days within the reporting window where one or more student(s) have been affected by adverse road AND weather conditions.Calculated field
% Adverse AbsentThe percentage of instructional days affected by adverse road AND weather conditions for the school.

Calculation:
#Days Adverse Absent / total Instructional Days
Calculated field

Detail Report

The Detail Report provides schools with individual student information so necessary changes can be made for the students who's attendance is affected by adverse weather and road conditions.

Screenshot of an example of the BIE Adverse Attendance Conditions Detail Report.BIE Adverse Attendance Conditions Detail Report

Understanding the Detail Report

Only students marked absent with the BIE Attendance codes ARC and/or AWC for 50% or more of their scheduled day are included in the report. 

FieldDescriptionLocation
SchoolReports the school name and BIE Group NumberSystem Administration > Resources > School > Name

System Administration > Resources > School > BIE Group Number

Database:

School.name

School.ncesSchoolID

NASIS IDReports the student of record's NASIS ID.Census > People > Demographics > NASIS ID

Database:
Person.otherID
# Days ARC

Total number of instructional days within the reporting window the student has been affected by adverse road conditions (ARC).

Calculated field
% ARCThe percentage of the student's rostered days affected by adverse road conditions (ARC).

Calculation:
 # Days ARC / Total Student Rostered Days
Calculated field
# Days AWCTotal number of instructional days within the reporting window the student has been affected by adverse weather conditions (AWC).Calculated field
% AWCThe percentage of the student's rostered days affected by adverse weather conditions (AWC).

Calculation:
 # Days AWC / Total Student Rostered Days
Calculated field
# Days Adverse AbsentTotal number of instructional days within the reporting window where the student has been affected by adverse road AND weather conditions (ARC and AWC).Calculated field
% Adverse AbsentThe percentage of instructional days affected by adverse road AND weather conditions (ARC and AWC).

Calculation:
#Days Adverse Absent / Total Instructional Days
Calculated field
Last NameReports the student of record's Last Name.Census > People > Identities > Current Identity > Last Name

Database:
Identity.lastName
First NameReports the student of record's First Name.Census > People > Identities > Current Identity > First Name

Database:
Identity.firstName
Birth DateReports student's Date of Birth.Census > People > Identities > Current Identity > Birth Date

Database:

Identity.birthDate
GenderReports the student's gender as M (male) or F (female).Census > People > Identities > Current Identity > Gender

Database:
Identity.gender
GradeReports the BIE Grade Level Code mapped to the grade level the student is enrolled in.Student Information > General > Enrollments > BIE Grade Level Code
Database:

GradeLevel.regionalGrade