General Connection Information

CEDS elements are shown in bold font. 

This metric is part of the Education-to-Workforce (E-W) Indicator Framework, specifically “E-W System Conditions” which pertain to key institutional or systemic environments, policies, and practices within E-W systems that support positive E-W outcomes. 

Calculating a Response

Teacher Retention – K12: Percentage of teachers who return to teaching in the same school from year to year 

Use the following CEDS elements to identify the school year:  

• For K12 teachers, School Year = the most recent school year or the school year being reported, representing July 1 through June 30. 

Use the following CEDS elements to determine the universe of teachers:

• Pull all unique teachers which is determined by using a unique Staff Member Identifier where Staff Member Identification System = State

Where the K12 teacher: 

• is associated with a State Education Agency through theState Agency Identifier where State Agency Identification System = SEA
• is associated with a Local Education Agency through the Local Education Agency Identifier where Local Education Agency Identification System = SEA, and
• is associated with a K12 school through the School Identifier where School Identification System = SEA. 

From the universe of teachers, narrow the list to teachers who continue to teach in the same school from year to year using the following CEDS elements:  

K12 Teachers for Year 1

• Employment Status = Contractual, Probationary
• Teaching Assignment Start Date ≤ June 30 of the school year being reported (Year 1)
• Teaching Assignment End Date = null
• K12 Staff Classification = Elementary Teacher, Secondary Teacher, Kindergarten Teacher, Special Education Teacher, Ungraded Teacher

K12 Teachers for Year 2 

Using the list of K12 teachers for Year 1, determine those who were retained in Year 2 and returned to the same school (where School Identifier did not change):

• Employment Status = Contractual, Probationary
• Teaching Assignment Start Date ≤ the date of the start of Year 2 (the school year one year after Year 1), no earlier than July 1.
• Teaching Assignment End Date > the date of the start of Year 2 or null
• K12 Staff Classification = Elementary Teacher, Secondary Teacher, Kindergarten Teacher, Special Education Teacher, Ungraded Teacher 

To calculate the percentage of teachers who return to teaching in the same school from year to year, use the following calculations.  

• Count the total number of teachers who taught in this school in Year 1 and returned to the same school in Year 2.
• Count the total number of teachers from Year 1.
• Divide the number of teachers who return to teaching the same school from Year 1 to Year 2 by the total number of teachers from Year 1. Multiply by 100. 

Disaggregate by Race and Ethnicity

Use the following CEDS elements to disaggregate the final set of teachers by Race: 

Filter records where Hispanic or Latino Ethnicity = No.

Count, by race, where any of the following are true:

• Race = American Indian or Alaska Native 

• Race = Asian 

• Race = Black or African American 

• Race = Native Hawaiian or Other Pacific Islander 

• Race = White 

• Race = Demographic Race Two or More Races 

• Race = Race and Ethnicity Unknown 

Use the following CEDS elements to disaggregate the final set of teachers by Hispanic or Latino Ethnicity: 

• Filter records where Hispanic or Latino Ethnicity = Yes

Disaggregate by Sex

*Note: CEDS does not have a Gender element. While Sex is not a proxy for Gender it is the closest approximation currently available.

*Note: Male + Female will not always equal 100% for states that have more choices beyond male and female.

Use the following CEDS elements to disaggregate the final set of teachers by Sex: 

• Sex = Male, Female, or Not Selected