Special Education Mainstream Refined ADA Report 

Summary: This report displays special education mainstream refined average daily attendance and special education mainstream refined flex attendance ADA (if applicable). This reporting includes percent in attendance (PIA) for each six weeks and total refined ADA.

Usage: Use this report to verify special education mainstream funding projections for current year and to compare six weeks and total ADAs with prior years as reported in Summer PEIMS.

Special Notes:

• As of 2024-2025 all Remote Attendance (RA/RS attendance) reporting is removed.
• 2020-2021 through 2023-2024 COVID-19 Remote Attendance
  • Totals include RS and RA remote attendance per the calculation.
  • The Row will be labeled with (Covid-19 Remote) in the 2021 Year column.
• 2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1. – Steps 1 – Steps 2 applied on this report. Step 3 is outside the scope of this report at this time. (see Calculations below for details)

Data Source(s): PEIMS Summer records

• As of 2024-25 Ed-Fi:
  • Student Attendance Domain : BasicReportingPeriodAttendance Entity (42400)
    • Student Attendance Domain : FlexibleRegularReportingPeriodAttendance Entity (42500)
• Pre 2024-2025 (XML and earlier)
  • Interchange Student Attendance
    • 42401-Special Programs Reporting Period Attendance Extension Complex Type
      • Attendance Event Indicator E1085 = 11 Regular – SpecialEd Mainstream
    • 42505-Special Program Reprortng Period Attendance Extenstion Complex Type
      • Attendance Event Indicator E1085 = 12 Flexible – SpecialEd Mainstream

Definitions:

• Attendance Type
  • Total Attendance – Displays only if there is Regular Attendance AND at least one Flex Attendance row.
  • Regular Attendance – Based upon Summer PEIMS reporting of BasicReportingPeriodAttendance (E0940)
  • Flex Attendance (will only display if LEA is reporting Summer PEIMS Flex Attendance (E1049) where FlexAttendanceProgram (E1045) is 1, 2 or 6
    • Flex Attendance – OFSDP: E1045 = 1
    • Flex Attendance – HSEP: E1045 = 2
    • Flex Attendance – Online Dropout Recovery : E1045 = 6

Calculations:

• 2019-2020 COVID-19 ADA:
  • REQUIRED: 2018-2019 Summer PEIMS files and 2019-2020 Summer PEIMS files uploaded into OnDataSuite for this calculation to accurately compute.
    • 2018-2019 Historical Ratio =2018-2019 Refined ADA (1-6 six weeks) divided by 2018-2019 Refined ADA (1-4 six weeks).
      • This ratio will display at the end of every 2019-2020 row.
      • It will be used in the Covid-19 Adjusted Refined Total calculation for all ADA sections of the report.
    • 2019-2020 rows will be shaded red to highlight the differences between years.
    • 2019-2020 5th and 6th six weeks data will display “Covid-19” indicating it will be ignored in the 19-20 calculations.
    • 2019-2020 Covid-19 Adjusted Refined Total = 1st – 4th six weeks Refined ADA ((Sum of 1st – 4th six weeks)/4)) multiplied by the 2018-2019 Historical Ratio
    • 2019-2020 Refined Total PIA = 1st – 4th six weeks PIA

• Refined ADA by six weeks – Sum of all students’ total eligible special ed mainstream days present in a six-week period / number days taught in the six week period
  • 2020-2021 through 2023-2024 RA/RS included : (Total eligible days present SPED Mainstream + RS Total eligible days present SPED Mainstream + RA Total eligible days present SPED Mainstream) / number days taught
    As of 24-25 there is no more RA/RS attendance reporting.
• Regular Attendance Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
  • (Total Elig Sp Ed Mainstream Days Present First Six Weeks / Number Days Taught First Six Weeks) +
  • (Total Elig Sp Ed Mainstream Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
  • (Total Elig Sp Ed Mainstream Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
  • (Total Elig Sp Ed Mainstream Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
  • (Total Elig Sp Ed Mainstream Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
  • (Total Elig Sp Ed Mainstream Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
  • Total Result / Number of reporting periods with values = Refined ADA Total
• PIA (Percent in Attendance) by six weeks and total (only applicable to Regular Attendance reporting) = ((Total Eligible Days Present + Total Ineligible Days Present) / (Total Eligible Days Present + Total Ineligible Days Present + Total Days Absent)) * 100
  • 2020-2021 through 2023-2024 RA/RS included: ((Total eligible days present + RS Total eligible days present + RA Total eligible days present + Total Ineligible Days Present) / (Total eligible days present + RS Total eligible days present + RA Total eligible days present + Total Ineligible Days Present + Total Days Absent )) * 100
• Flex Attendance Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
  • Same calcualtions as Regular Attendance only based upon FlexAttendance TotalEligSpEdMainstreamDayPresent (e1049) reporting.

Features:

• Filters:
  • Multi-select Years (Default Current Year)
  • District/Campus Summary (Default District Summary)
    • Multi-select Campuses
    • Check District/Campus Summary in conjunction with campus(es) to display a campus summary of the campuses selected and each individual campus on a separate row
  • All Grades Summary (Default All Grades Summary)
    • Multi-Select Grades
    • Check All Grades Summary in conjunction with grade level(s) to display a grade level summary of the grades selected and each individual grade level on a separate row
  • Multi-select Instructional Tracks (Default All Tracks)
  • Focus List to pull a group of students
  • Toggle Student Counts – this will display the count of unique TXUIDS in each row, reporting period.

• Tools Menu (upper right)
  • Export to Excel
  • Hide Division Borders – applicable to multi year filter selections only
  • Bookmark
  • Heatmap On (designate a minimum and maximum limit to highlight specific areas of concern)
• Drill down on Regular Attendance and Flex Attendance ADA counts to see detailed student list for the respective calculation.