1. Home
  2. HB3 Student ADA Report – Refined, HS, SPED Mainstrm, Bil, Early Ed, PEG, Res Facility

HB3 Student ADA Report – Refined, HS, SPED Mainstrm, Bil, Early Ed, PEG, Res Facility

Summary: This report provides Student ADA data for HB3 program funding related to District Summary, High School, Special Education Mainstream, Bilingual/ESL, Early Education (K-3), PEG and Residential Placement Facility on a single report.

Usage: Use aide to help complete the Summary of Finance(SOF) template data elements related to program ADA calculations as defined by HB3.

Special Notes: As TEA provides updates for the HB3 funding changes, the reports will be updated.

  • 2019-2020 COVID-19 ADA Adjustments per TEA GuidanceGeneral 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)
  • 2020-2021 and 2021-2022 COVID-19 Remote Attendance Adjustments
    • Totals include RS and RA remote attendance per the respective section calculation.

Data Source(s): PEIMS Summer records

  • Interchange Student Attendance Extension
    • 42400-Basic Reporting Period Attendance Extension Complex Type
    • 42401-Special Programs Reporting Period Attendance Extension Complex Type
      • Attendance Event Indicator (E1085) = 11 Regular – SpecialEd Mainstream
      • Attendance Event Indicator (E1085) = 02 Regular – Bilingual/ESL

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 top of the HB3 Student ADA report on the 2019-2020 year ONLY.
        • It will be used in the Covid-19 Adjusted Refined Total calculation for all ADA sections of the report.
      • 2019-2020 5th and 6th six weeks data will display N/A per TEA guidance that it will be ignored for 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

Basic Attendance ADA:

  • Refined ADA by six weeks – Sum of all students’ total eligible days present (E0937) from 42400 Basic Reporting Attendance in a six-week period / number days taught (E0935) in the six week period
    • 2020-2021 and 2021-2022 RA/RS included: (Total eligible days present (E0937) + RS Total eligible days present (E1678) + RA Total eligible days present (E1679 ) / number days taught (E0935)
  • Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
    • (Total Eligible Days Present First Six Weeks / Number Days Taught First Six Weeks) +
    • (Total Eligible Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
    • (Total Eligible Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
    • (Total Eligible Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
    • (Total Eligible Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
    • (Total Eligible Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
    • Total Result / 6 = Refined ADA Total

Special Program Attendance ADA:

  • Refined ADA by six weeks – Sum of all students’ total eligible identified special program event from 42401 Special Programs Attendance in a six-week period / number days taught (E0935) in the six week period
    • 2020-2021 and 2021-2022 RA/RS included per special program area: (Total eligible days present + RS Total eligible days present + RA Total eligible days present) / number days taught 
  • Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present First Six Weeks / Number Days Taught First Six Weeks) +
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
    • (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
    • Total Result / 6 = Refined ADA Total

Refined ADA District Summary.

  • Basic Attendance ADA calculation for all students district wide.

High School (Grades 9-12) Refined ADA District Summary.

  • Basic Attendance ADA calculation for grades 9-12 only and reported by grade and summary for grades 9-12 in total.

Special Education Mainstream Refined ADA District Summary.

  • Special Program ADA calculation for all students’ eligible Special Education Mainstream days present (E0940) from 42401 Special Programs Attendance.

Bilingual/ESL Refined ADA District Summary.

  • 2020-2021 and 2021-2022 RA/RS Bilingual/ESL Funding Codes included in criteria: Bilingual/ESL Funding Code (E1651), RS Bilingual/ESL Funding Code (E 1680) and RA Bilingual/ESL Funding Code (E1681)
  • Bilingual/ESL ADA – Not in Dual Language Program – EB ADA calculation for students reported with Bilingual/ESL Funding Code (E1651) = “BE” AND the student is LEP (E0790) = 1
    • Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
  • Bilingual – Dual Language One & Two Way Pgm – EB ADA calculation for students reported with (Bilingual /ESL Funding Code (E1651) = “D1” OR “D2”) AND student is LEP (E0790) = 1.
    • Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
  • Bilingual – Dual Language Two Way Pgm – Non EB ADA calculation for students reported with Bilingual/ESL Funding Code (E1651) = “D2” AND the student is non-LEP (E0790) = 0, F, S, 3, 4 or 5)
    • Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.

The Summer PEIMS updates regarding the new element Bilingual/ESL Funding Code (E1651) as defined in the TEDS section 2.4 page 144 have been updated in this section of the report as of April 13, 2020

Early Education Refined ADA District Summary. HB3 funding for grades K-3 only. Students may be duplicated counted in both rows.

  • K-3 Educationally Disadvantaged students: Students classified as Economic Disadvantaged (E0785) =01, 02 or 99 and in grade K – 3.
    • Basic Attendance ADA calculation for selected students.
  • K-3 Limited English Proficient students: Students classified as LEP (E0790) = 1 and Bilingual/ESL Funding Code (E1651) = BE, D1 or D2 and in grade K-3.
    • Basic Attendance ADA calculation for selected students.

*Note: The Total is a sum of each row on this section and includes any student that is duplicate counted.

Public Education Grant (PEG) ADA District Summary.

  • Basic Attendance ADA calculation for all students reported with Student Attribution (E1000) = 03 (PEG)

Residential Placement Facility ADA District Summary (new reporting for HB3 Funding as of 19-20)

  • Special Program ADA calculation for all students’ eligible Residential Facility days present (E1652 from 42401 Special Programs Attendance.

Features:

  • Filter on:
    • Multi-select Years (Default latest PEIMS file loaded)
    • District/Campus Summary (Default District Summary)
      • Multi-select Campuses
      • Check District/Campus Summary in conjunction with campus(es) to display a campus summary and each individual campus
    • Multi-select Instructional Tracks (Default All Tracks)
    • Drill down on counts to see detailed student list
    • Toggle Student Counts – displays student count below ADA in each section.
  • Under Tools: Use ‘Heatmap On’ with a minimum and maximum limit to highlight specific areas of concern.

Resources for Calculations: TEA HB3 Resource page: https://tea.texas.gov/About_TEA/Government_Relations_and_Legal/Government_Relations/House_Bill_3

Updated on 11/30/2021

Was this article helpful?