Career & Technical Education (CTE) FTE Report Post 2021

Summary: Report provides Career and Technial(CTE) FTEs by each six weeks with a refined total as defined by HB1525 beginning with the 2021-2022 school year.

Usage: Data quality/funding – review report at district level and use filter to change to “All Campuses: Display All” to view by campus to verify reasonableness.

Data Sources:

• Summer PEIMS Attendance
  • Interchange Student Attendance Extension
    • 42400 Basic Reporting Period Attendance Extension Complex Type
    • 42401 Special Programs Reporting Period Attendance Extension Complex Type
      • CTE Attendance Multilplier subcomplex required.

Calculations:

• Funding Tiers :
  • Tier 1 – Not an Approved Program of Study – student is enrolled in a CTE Service ID NOT assigned to a Program of Study
    • Reference TEA Program of Study resources for service ids and weighted funding by POS.
  • Tier 2 – Levels 1 & 2 in an Approved Program of Study ; student is enrolled in a CTE Service ID designated as a Level 1 or Level 2 course per TEA Program of Study references noted above.
  • Tier 3 – Levels 3 & 4 in an Approved Program of Study ; student is enrolled in a CTE Service ID designated as a Level 3 or Level 4 course per TEA Program of Study references noted above.
• FTE by six weeks per Tier
  • Campus-Level – Career and Technical Education FTE is calculated by:
    • Career & Technical Education FTE = Total Track Contact Hours / (DAYS_TAUGHT * 6)
      • Contact Hours = (Total eligible days present + RS Total eligible days present + RA Total eligible days present * WEIGHT)
        • Multiply the sum of Career and Technical Education eligible days present by the corresponding weight factor to calculate contact hours:
          • (V1 – weight 1)
          • (V2 – weight 2)
          • (V3 – weight 3).
      • Sum the contact hours for all Career and Technical Education codes within the track.
      • Divide the total contact hours for each track by 6 times the number of days taught to yield the Career and Technical Education FTE for the track.
  • District-Level – Career and Technical Education FTE is calculated by adding the campus-level Career and Technical Education FTE for each tier for all tracks within each reporting period.
• Refined FTE Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
  • (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 / 6 = Refined FTE Total

*NOTE: All calculations are truncated at 3 decimal places. This may result in slight variances between summary and filtered detail totals.

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
  • Multi-select Instructional Tracks (Default All Tracks)
  • Drill down on FTE counts to see detailed student lists