District Summary Attendance Report (Texas)

Classic View: TX State Reporting > TEA Attendance > District Summary Attendance

Search Terms: District Summary Attendance, District Summary, TEA Attendance, TEA

The Texas TEA District Summary Attendance Report is a  report that details attendance information for students, schools, and districts. This report summarizes, in 6 week reporting periods, the attendance data of a school for multiple reporting periods at once.

 

TEA District Summary Attendance Editor Example

Report Logic

This report generates data for any student who is actively enrolled during the Reporting Period and whose ADA eligibility is not equal to 0. A student’s ADA eligibility is determined by the attendance accounting system. See the Report Layout for Eligibility Codes.

  • Courses with the State Report Exclude option selected on the Courses tab (Scheduling > Courses > Course) do NOT report.
  • CTE attendance and V code calculations consider suspensions lasting longer than 5 days. If a student has a state reportable suspension (in school or out of school) within the reporting window that lasts longer than 5 days, any attendance days after the 5th day will be counted as regular (not CTE) and student will report no V codes.
  • Attendance entered by the minute is saved to the database as period-based. This means exact time is not reported, only the period in which it falls.
  • When calculating CTE attendance days, logic excludes any date contained in a CTE Funding Exempt record that overlaps with the reporting period. 
  • When calculating CTE attendance days, logic excludes any date contained in a Non-Certified CTE record that overlaps with the reporting period. 
  • Grade levels do not need to match State Grade Levels in order to report.
  • When a user selects dates that cross multiple attendance periods, only the dates for the earliest period are considered and the rest do not report.


Generating the Report

  1. Select the District Summary Attendance option from the Report Type dropdown.
  2. Select a Report Format of either PDF or DOCX.
  3. Choose a school and calendar in the Period Model dropdown. The calendars list in the extract editor should populate once a period model has been selected.
  4. Select a calendar from the Calendar dropdown.
  5. Fill in the Start Date and End Date fields. There are several options for this action: 
    • Select the Calendar icon and select the start and end dates for the reporting period. 
    • Select the Start Date and End Date fields and manually input the start and end dates for the reporting period. 
    • Click on the period options below the Period model to quick set the start and end dates for the reporting period.
  6. Select either Grade to filter the report by grade and then choose a grade from the dropdown, or select Ad Hoc Filter and choose a filter from the dropdown options.
  7. Decide if you want to generate the report or submit to batch:
    Generate Report

    Click the Generate Report button to immediately generate the report. The report will appear in a separate window in the designated format.

    Submit to Batch

    Clicking the Submit to Batch button to send the extract to the Batch Queue List. Batch Queue functionality provides the ability to schedule when the extract is generated and allows users to navigate away from the report editor while the extract is being built. The Batch Queue List also lets users view and access historical reports which were run through the Batch Queue tool.


Report Example

District Summary Attendance Report

District Summary Attendance Report Contact Hours Calculations

Weight Factor Calculations

District Summary Attendance Report Weight Factor Calculations

Report Layout

ElementDescriptionLocation

Reporting Period

Required


The period of time that this report pulls from to generate an attendance summary. The general period of time for this report is six weeks. The full school year can be analyzed with this report, but it must be divided into approximately six equal reporting periods.System Administration > Calendar > Calendar > Attendance Periods > Attendance Periods Detail

Database:
Calendar.name

Total

Required


The sum total of A-R for all grades included in the report.Not dynamically stored

Database:
Calculated field

Grade Level

Required


The student grade level used to filter this report.


Note: Grade levels do not need to match State Grade Levels in order to report.

Student Information > General > Enrollment Tab > Grade


System Admin > Calendar > Calendar > Grade Level


Database:
Enrollment.grade

Instructional Days (A)

Required


The total number of days classes are held during the school year.Not dynamically stored

Database:
Calculated field

Student Count

Required


The number of students included in the report population with at least one day membership within the Reporting Period Date Range.Not dynamically stored

Database:
Calculated field

Days Membership (B)

Required


The total number of days that all students were enrolled in the school during the reporting period. Days Membership is calculated by adding together the number of Days Absent (C), number of Eligible Days Present (F), and number of Ineligible Days Present (E) for each grade within the reporting period and instructional track:


Days Membership = Days Absent +Eligible Days Present + Ineligible Days Present

Not dynamically stored

Database:
Calculated field

Total Days Absent (C)

Required


The total number of days students were absent during the reporting period.Not dynamically stored

Database:
Calculated field

Total Days Present (D)

Required


The total number of days students were present in the reporting period. Days Present is calculated as the number of Ineligible Days Present (E) plus the number of Eligible Days Present (F) for each grade within the reporting period and instructional track.


Days Present = Ineligible Days Present +Eligible Days Present

Not dynamically stored

Database:
Calculated field

Total Ineligible Days (E)

Required


The total number of days students were present and in membership, but ineligible for ADA funds.Not dynamically stored

Database:
Calculated field

Total Eligible Days (F)

Required


The total number of days students were present, in membership, and eligible for ADA funds.Not dynamically stored

Database:
Calculated field

Eligible Days Bilingual/ESL (G)

Required


The total number of days students were taking part in eligible Bilingual or ESL programs.Not dynamically stored

Database:
Calculated field

Eligible Days Pregnancy Related Services (H)

Required


The total number of days students were taking part in Pregnancy Related Service programs.Not dynamically stored

Database:
Calculated field

Eligible Days SpecEd Main (I)

Required


The total number of days students were in Special Ed Setting 40: Mainstream during the reporting period.Not dynamically stored

Database:
Calculated field

Bilingual/ESL Refined ADA (J)

Required


Bilingual/ESL Refined ADA is calculated by dividing the number of Eligible Bilingual/ESL Days Present (G) by the number of Instructional Days (A) for each grade within the reporting period and instructional track. (Rounded to the nearest 0.1):


Bilingual/ESL Refined ADA = Eligible Bilingual/ESL Eligible Days Present / Instructional Days

Not dynamically stored

Database:
Calculated field

SpecEd Main Refined ADA (K)

Required


Special Education Mainstream Refined ADA is calculated by dividing the number of Eligible Special Education Mainstream Days Present (I) by the number of Instructional Days (A) for each grade within the reporting period and instructional track:


Special Education Mainstream Refined ADA = Eligible Special Education Mainstream Days Present / Instructional Days


To be included, on the day being counted

  • the IEP must be active and locked, AND
  • the there must be an active Instructional Setting code of 40 on the Settings and Disabilities editor in the IEP
Not dynamically stored

Database:
Calculated field

Pregnancy Related Service FTE (L)

Required


Pregnancy-Related Services FTE is calculated as the number of Eligible Pregnancy-Related Services Days (H) multiplied by 0.2936; the result is divided by the number of Instructional days (A) for each grade within the reporting period and instructional track:


Pregnancy-Related Services FTE = (Elig Preg Rel Serv Days * 0.2936) / Instructional Days

Not dynamically stored

Database:
Calculated field

Career & Technology Ed FTE (M)

Required


Career & Technology Ed FTE is calculated by multiplying the Career & Technology Education Eligible Days Present (F) for each grade by the corresponding weight factor to calculate contact hours (see the Weight Factor Calculations table). All of the Career & Technology Education contact hours are added together and this sum is then divided by 6 multiplied by the number of Instructional days (A) to yield the Career & Technology Education FTE for the track:


Career & Technology Education FTE = Contact Hours / (6 * Instructional Days)

Not dynamically stored

Database:
Calculated field

Special Education FTE (N)

Required


Special Education FTE is calculated by adding all the Special Education Eligible Days Present (F) and multiplying this sum by the corresponding weight factor for each grade (see the Weight Factor Calculations table). Then the hours excess is subtracted to calculate the contact hours. All the Special Education contact hours are added together and this sum is divided by 6 multiplied by the number of Instructional Days (A) to yield the Special Education FTE for the track:


Speical Education FTE = Spec Ed Contact Hours / (6 * Instructional Days)

Not dynamically stored

Database:
Calculated field

Regular Program Refined ADA (O)

Required


Regular Program Defined ADA is calculated by the Total Refined ADA (P) minus the Career & Technology Education FTE (M) and Special Education FTE (N), rounded to the nearest 0.1:


Regular Program Defined ADA = Total Refined ADA - Career & Technology Education FTE - Special Education FTE

Not dynamically stored

Database:
Calculated field

Total Refined ADA (P)

Required


Total Refined ADA is calculated by dividing the number of Eligible Days Present (F) by the number of Instructional Days (A) for each grade within the reporting period and track:


Total Refined ADA = Eligible Days Present / Instructional Days

Not dynamically stored

Database:
Calculated field

Percent in Attendance (Q)

Required


Percent in Attendance is calculated by dividing the Days Present (D) by the Days Membership (B). This sum is then multiplied by 100:


Percent in Attendance = (Days Present / Days Membership) * 100

Not dynamically stored

Database:
Calculated field

Gifted and Talented (R)

Optional

The total number of students who have a Program of GT: Gifted &Talented.
Student Information > General > Flags > Student Flag Detail > Flags > GT: Gifted & Talented

Database:
Enrollment.giftedTalented