Special Education FTE Report

Summary: Report will display SPED FTEs by six weeks for all instructional settings except Mainstream (40) which is not reported in the summer PEIMS submission.

Usage: Review current year and prior year FTEs for reasonableness, by Instructional Setting, Campus and/or Grade.

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 & 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 Sources: Summer PEIMS

• Interchange Student Attendance Extension
  • 42400 Basic Reporting Period Attendance Extension Complex Type
  • 42401 Special Programs Reporting Period Attendance Extension Complex Type

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 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 Refined Total = 1st – 4th six weeks FTE ((Sum of 1st – 4th six weeks)/4)). This total is the 19-20 FTE total without the Historical Ratio applied.
    • 2019-2020 Covid-19 Adjusted Refined Total = 2019-2020 Refined Total multiplied by the Historical Ratio. *Note – predictive final FTE for settle-up funding.
• FTE by six weeks:
  • Special Education FTE = Total Contact Hours / (DAYS_TAUGHT * 6)
    • Contact Hours = (DAYS_ELIG * WEIGHT) HRS_EXCESS
      • Multiply the sum of eligible days present for each grade within each Special Education instructional setting by the corresponding weight factor, then subtract the hours excess to calculate the contact hours.
    • Sum the contact hours for all Special Education instructional settings.
    • Divide the contact hours by 6 times the number of days taught to yield the Special Education FTE.
  • 2020-2021 & 2021-2022 RA/RS incluced in Contact Hours: (Total eligible days present in instructional setting + RS Total eligible days present in instructional setting + RA Total eligible days present in instructional setting)
• Refined FTE Total – Sum of all six-week periods, divided by number of reporting periods with values, and reported to 3 decimal places.
  • (Total Eligible Days First Six Weeks / Number Days Taught First Six Weeks) +
  • (Total Eligible Days Second Six Weeks / Number Days Taught Second Six Weeks) +
  • (Total Eligible Days Third Six Weeks / Number Days Taught Third Six Weeks) +
  • (Total Eligible Days Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
  • (Total Eligible Days Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
  • (Total Eligible Days Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
  • Total Result / number of reporting periods with values = Refined FTE Total

Features:

• Filter on:
  • 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
  • All (Instructional) Settings Summary (Default All Settings Summary)
    • Multi-select Instructional Settings
    • Check All Settings Summary in conjunction with instructional setting(s) to display an instructional setting summary of the settings selected and each individual instructional setting on a separate row
  • Multi-select Instructional Tracks (Default All Tracks)
  • Focus List to pull a group of students
  • Drill down on FTE counts to see detailed student lists (20-21 & 21-22 RA/RS included in drilldowns)