1. Home
  2. Bilingual / ESL Refined ADA Report Pre 2020

Bilingual / ESL Refined ADA Report Pre 2020

Summary: This report displays bilingual/ESL refined average daily attendance and percentage in attendance for each six weeks and total up through the 2018-2019 school year. Subsequent years starting with 2019-2020, bilingual/ESL is reported by different bilingual/ESL funding codes (see Bilingual/ESL Refined ADA Report Post 2019).

Usage: Use this report to verify bilingual/ESL funding projections for current year and to compare six weeks and total ADAs with prior years.

Data Source(s): PEIMS Summer records

  • Interchange Student Attendance
    • 42401-Special Programs Reporting Period Attendance Extension Complex Type
      • Attendance Event Indicator E1085 = 02 Regular – Bilingual/ESL

Calculations:

  • 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
  • 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 ADA Total
  • PIA (Percent in Attendance) by six weeks and total = ((Total Eligible Days Present E0937 + Total Ineligible Days Present E0936) / (Total Eligible Days Present E0937 + Total Ineligible Days Present E0936 + Total Days Absent E0036)) * 100

Features:

  • Filter on:
    • Multi-select Years (Default Current Year)
      • Note: Last year available 2018-2019
    • 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
    • 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 and each individual grade level
    • Multi-select Instructional Tracks (Default All Tracks)
  • Focus List to pull a group of students
  • Use ‘Heatmap On’ with a minimum and maximum limit to highlight specific areas of concern
  • Drill down on ADA counts to see detailed student lists
Updated on 11/02/2021

Was this article helpful?