Calculate Section Level FTE

Contents

Introduction

The Calculate Section Level FTE report is a district-level report that calculates section-level, teacher FTE values. The report produces an output file and also populates the calculated values in the FTE fields on the staff and section pages. These FTE values are used for Staff Assignment reporting.

Required Setup

 Staff

The staff member must be active and tied to at least one section, as well as have at least one contract record that is active on the snapshot date and created with a teaching contract type.

Start Page> [select staff]> Edit Information> Staff Demographics & Employment> Contract Info> New/Edit

• The Contract record must list the FTE amount.

• The Contract Type must be a teaching contract type.

• The Contract record Entry Date is required but the End Date can be blank.

Notes:

• If the staff member has multiple, active contract records, the sections must be set with the applicable contract number. If the staff member only has a single contract record, it will be assumed all sections apply to that contract.

• While there are additional data entry fields on the Enter New Contract Record page, only the following fields are required for the Teacher FTE Calculation report to work:

  • Contract Number

  • Contract Type

  • Contract Start Date

  • FTE

Section

Start Page> School Setup> Sections> [select course]> [select section]

• The Section must be active on the snapshot date

• The Section cannot be excluded from:

  • ADA reporting

  • State Reporting

  • FTE Calculation functionality

• The Staff's Teaching Role must be set to:

  • Teacher of Record

  • Co-Teacher

  • Lead Team Teacher

  • Note: This field can be blank and it will be assumed the staff is the Teacher of Record.

Course

Start Page> School Setup> Courses> [select course]

The Course cannot be excluded from:

• ADA reporting

• State Reporting

• FTE Calculation functionality

FTE Calculations

FTE is calculated for staff who have the role Teacher of Record, Lead Team Teacher, or Co-Teacher. A teacher's FTE is calculated per section, by contract number. The calculation considers the following:

• The teacher's FTE in the Staff Contract record

• The  teacher's Staff Contract record number value

• The teacher's sections that are active on the report's user-defined snapshot date.

• Manually entered FTE

• Manually entered teaching assignments  

• Previously entered FTE values

For multiple sections, the number of qualifying sections is divided by the teacher's FTE. Sections that meet for more periods during the week are not weighted more heavily  than those that meet for fewer periods. For example, if a teacher has five qualifying sections, and their FTE is 1, each section would be a .2 (regardless of how often a section meets).

Calculations for Manually Entered FTEs and Staff Assignments

Manually entered FTE values are not overridden by the calculated FTE; instead, these values are deducted from the overall FTE amount and the remainder is used for calculating FTE's for any remaining sections. For example, if a teacher has five qualifying sections and his or her FTE is 1, and one of the sections has a manually entered FTE value of .3, the report subtracts the manually entered .3 from the total FTE of 1 and the remaining .7 FTE is split between the remaining four sections.

If a teacher has a manually created Staff Assignment record with the same contract number as a Staff Contract record, the FTE amount in the manually created Staff Assignment record is subtracted from the Staff Contract FTE. The remainder is calculated in the same manner as a section with a manually entered FTE.

When a teacher has a manually created Staff Assignment record as well as a section with a manually entered FTE value, if the contract number is the same, the manually entered FTE amounts in both the Staff Assignment record and the section are subtracted from the overall FTE amount in the Staff Contract record.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Course, Section, and Staff Selection

• Course or section must not be excluded from ADA

• Course or section must not be excluded from state reporting

• Course or section must not be excluded from FTE calculation

• Course, section, and teacher must be active on the report's user-defined snapshot date.

Report Input

  For help with navigation and running the report, see How to Find and Generate a Report. 

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.