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 key institutional or systemic environments, policies, and practices within E-W systems that support positive E-W outcomes

Calculating a Response

Metric: Pre-K: Percentage of lead teachers with specialized training in pre-K 

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 staff member:

• is associated with a State Education Agency through the State 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 or Organization Identifier where Organization Identification System = SEA
• where School Level = Pre-kindergarten/early childhood, and
• where Early Learning Program Year is the program year being reported

From the universe of teachers, narrow the list to only Lead Teachers using the following CEDS elements: 

• Classroom Position Type = 73072 (Lead Team Teacher)
• Assignment Start Date ≤ July 1 of the school year being reported
• Assignment End Date ≥ June 30 of the school year being reported, or is null

From the list of Lead Teachers, identify those that have specialized training in pre-K using the following CEDS elements: 

• Early Childhood Credential = State Awarded Preschool Credential, or 
• Professional Development Activity Education Levels Addressed = Prekindergarten

To calculate the percentage of pre-K lead teachers with at least a bachelor’s degree,  

• Count the number of lead teachers that have specialized training in pre-K
• Count the total number of lead teachers
• Divide the number of lead teachers that have specialized training in pre-K by the total number of lead teachers and 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