Calculating a Response

Percentage of K12 teachers with less than one year, one to five years, and more than five years of experience 

Use the following CEDS elements to identify the school year:  

• School Year = most recent school year, 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 teacher: 

• is associated with a State Education Agency through the State Agency Identifier where State Agency Identification System = State
• is associated with a Local Education Agency through the Local Education Agency Identifier where Local Education Agency Identification System = State
• is associated with a K12 school through the School Identifier where School Identification System = State
  

From the universe of teachers, narrow the list to K12 teachers using the following CEDS elements: 

• Role = K12 Staff
• Professional Educational Job Classification = Teacher

Identify which teachers have been teaching for less than one year: 

• Years of Prior Teaching Experience < 1 year 

Identify which teachers have been teaching for one to five years: 

• Years of Prior Teaching Experience ≥ 1 year and ≤ 5 years 

Identify which teachers have been teaching for more than five years: 

• Years of Prior Teaching Experience > 5 years 

To determine the percentage of K12 teachers with less than one year, one to five years, and more than five years of experience: 

Teachers with less than one year experience:

• Count the total number of K12 teachers
• Count the total number of K12 teachers who have less than one year experience
• Divide the total number of K12 teachers who have less than one year experience by the total number of K12 teachers. Multiply by 100. 

Teachers with 1-5 years of experience:

• Count the total number of K12 teachers
• Count the total number of K12 teachers who have 1-5 years of experience
• Divide the total number of K12 teachers who have 1-5 years of experience by the total number of K12 teachers. Multiply by 100.

Teachers with more than 5 years of experience: 

• Count the total number of K12 teachers
• Count the total number of K12 teachers who have more than 5 years of experience
• Divide the total number of K12 teachers who have more than 5 years of experience by the total number of K12 teachers. 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 element(s) to disaggregate the final set of students 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 element to disaggregate the final set of teachers by Sex: 

• Sex = Male, Female, or Not Selected

General Connection Information

CEDS elements are shown in bold/italicized font. 

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

This metric is a measurement for a key indicator, “Teacher experience,” and measures whether students have equitable access to experienced teachers.