Percentage in Attendance Comparison By Ethn, Gender, Grade and Special Pop

Report Location: Student>Student Custom Reports>Attendance Reports>Attendance Summary

Summary: This report displays percentage of attendance across multiple years by ethnicity, gender, grade, special populations and all students for each six weeks reporting period and cumulative YTD totals.

Usage: Review attendance trends longitudinally across years to check for funding issues at the district or campus level.

Special Notes:

• 2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1
  • 2019-2020 Reporting Periods 5 and 6 will display Covid-19 and will be ignored for graphing and 19-20 Cumulative PIA calculation.
• 2020-2021 & 2021-2022 COVID-19 Remote Attendance Calculation Adjustments
  • Percentage of Attendance (PIA) calculations are all based on the 42400 day elements
    • Sum of (E0937 Total Eligible Days Present + E1678 RS Total Eligible Days Present + E1679 RA Total Eligible Days Present + E0936 Total Ineligible Days Present) / Sum of (E0937 Total Eligible Days Present + E1678 RS Total Eligible Days Present + E1679 RA Total Eligible Days Present + E0936 Total Ineligible Days Present + E0036 Total Days Absent) * 100

Data Source(s):

• Summer PEIMS records
  • Interchange Student
    • 40100 – StudentExtension
  • Interchange Student Program
    • 40110 – StudentProgramExtension
    • 41163 – StudentSpecialEdProgramAssociationExtension
  • Interchange Student Attendance
    • 42400 – BasicReportingPeriodAttendanceExtension
• Fall PEIMS records
  • Interchange Student
    • 40100 – StudentExtension
      • E0919 – At Risk

Definitions:

• All Students
  • All students reporting Eligible Days Present (E0937) > 0
  • Note: This row will display on all filtered reports.
• Ethnicity
  • Hispanic/Latino – E1375 = true
  • American Indian or Alaska Native – E1343 = 01 (DC097)
  • Asian – E1343 = 02 (DC097)
  • Black or African American – E1343 = 03 (DC097)
  • Native Hawaiian or Other Pacific Islander – E1343 = 04 (DC097)
  • White – E1343 = 05 (DC097)
  • Two or More Races – E1375 = false AND E1343 = multiple DC097
• Gender
  • Male – E0004 = M (C013)
  • Female – E0004 = F (C013)
• Grade
  • Grade level rows – E0017 (C050)
• Special Population
  • At Risk – E0919 = 1 (C088)
  • Early Reading Indicator – E1522 = 1 (C195)
  • Economic Disadvantage – E0785 > 00 (C054)
  • Emergent Bilingual – E0790 = 1 (C061)
  • Foster Care – E1528 = 1, 2, or a (C196)
  • Gifted and Talented – E0034 = 1 (C088)
  • Homeless Status – E1082 > 0 (C189)
  • Migrant – E0984 = 1 (C088)
  • Military Connected – E1529 > 0 (C197)
  • RDSPD – E0833 > 0 (C067)
  • Section 504 – E1603 = 1 (C088)
  • Special Education – E0794 = 1 (C088)
  • Unaccompanied Youth – E1084 = 1, 2, or 4 (C192)

Calculations:

• Percentage of Attendance (PIA) calculations are all based on the 42400 day elements
  • Sum of (E0937 Total Eligible Days Present + E0936 Total Ineligible Days Present) / Sum of (E0937 Total Eligible Days Present + E0936 Total Ineligible Days Present + E0036 Total Days Absent) * 100

Features:

• Filter on:
  • Category (Default All)
    • Ethnicity
    • Gender
    • Grade
    • Special Population
  • Multi-select Year (Default most recent 3 years)
  • Multi-select Instructional Track (Default All)
  • Multi-select Campus (Default All)
    • Based on 42400 Campus ID Of Enrollment
    • High Schools
    • Middle Schools
    • Elementary Schools
  • Multi-select Grade Level (Default All)
    • Based on 42400 Grade Level Code
    • High Schools
    • Middle Schools
    • Elementary Schools
  • Multi-select Year (default most recent 3 years)
• Hide/Show Reporting Periods
  • Show Reporting Periods (Default) shows each six weeks reporting periods plus the cumulative percentage in attendance
  • Hide Reporting Periods shows only the cumulative percentage in attendance column
• Tools drop-down:
  • Heatmap
    • Highlight anomalies
    • Click Show/Hide Heatmap Options to adjust display
  • Graph Control
    • Pie, Bubble, Trend Line, or Bar Graph
    • Apply selection to all rows using ‘Select All’ check box above categories
    • Apply selection to all rows within each category by clicking the check box next to the category title (Ethnicity, Gender, Grade, Special Population)
    • Individually select rows within the categories
  • Graph Zooming