Bilingual/ESL Refined ADA Report Post 2019 

Summary: This report displays bilingual/ESL refined average daily attendance and percent in attendance for each six weeks and total by the different types of programs that started tracking during the 2019-2020 school year.

Usage: Use this report to verify bilingual/ESL attendance for current year, review PIA for the different programs, and to eventually compare six weeks and total ADA and PIA with prior years.

Special Notes:

• 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)
• 2020-2021 and 2021-2022 COVID-19 Remote Attendance Adjustments
  • Totals include RS and RA remote attendance per the calculation.
  • The Row will be labeled with (Covid-19 Remote) in the 2021 Year column.

Data Source(s): PEIMS Summer records

• Interchange Student Extension
  • 40100 – Student Extension Complex Type
• Interchange Student Attendance Extension
  • 42400 – Basic Reporting Period Attendance Extension Complex Type (for PIA calculation)
  • 42401 – Special Programs Reporting Period Attendance Extension Complex Type
    • Attendance Event Indicator (E1085) = 02 Regular – Bilingual/ESL

Definitions:

• BE-Biling/ESL
  • Students reported with Bilingual/ESL Funding Code (E1651) = “BE” AND EmergentBilingualIndicator (E0790) = 1
• D1-Bil Dual Lang
  • Students reported with Bilingual/ESL Funding Code (E1651) = “D1” AND EmergentBilingualIndicator (E0790) = 1
• D2 (EL)-Bil Dual Lang
  • Students reported with Bilingual/ESL Funding Code (E1651) = “D2” AND EmergentBilingualIndicator (E0790) = 1
• D2 (EP)-Bil Dual Lang
  • Students reported with Bilingual/ESL Funding Code (E1651) = “D2” AND EmergentBilingualIndicator (E0790) = 0, F, S, 3, 4 or 5

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 bilingual/ESL days present (E0938) in a six-week period / number days taught (E0935) in the six week period
  • 2020-2021 & 2021-2022 RA/RS included: (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 Elig Bilingual/ESL Days Present First Six Weeks / Number Days Taught First Six Weeks) +
  • (Total Elig Bilingual/ESL Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
  • (Total Elig Bilingual/ESL Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
  • (Total Elig Bilingual/ESL Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
  • (Total Elig Bilingual/ESL Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
  • (Total Elig Bilingual/ESL Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
  • Total Result / Number of reporting periods with values = Refined Total ADA
• PIA (Percent in Attendance) by six weeks and total = ((Total Eligible Days Present + Total Ineligible Days Present) / (Total Eligible Days Present + Total Ineligible Days Present + Total Days Absent )) * 100
  • 2020-2021 & 2021-2022 RA/RS included: ((Total eligible days present + RS Total eligible days present + RA Total eligible days present) / (Total eligible days present + RS Total eligible days present + RA Total eligible days present + Total Ineligible Days Present + Total Days Absent)) * 100

Features:

• Filter on:
  • Multi-select Years (Default most recent PEIMS summer file loaded)
    • Note: Bilingual/ESL Funding Code breakdown started 2019-2020
  • 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
• Use ‘Heatmap On’ and choose ADA or PIA with a minimum and maximum limit to highlight specific areas of concern
• Drill down on ADA counts to see detailed student lists (20-21 & 21-22 RA/RS included in drilldowns)