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 at least a bachelor’s degree 

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 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 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 Pre-kindergarten Teachers using the following CEDS element:  

• K12 Staff Classification = Pre-kindergarten teachers 

From the list of Pre-kindergarten 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 early learning program year being reported
• Assignment End Date ≥ June 30 of the early learning program year being reported, or is null

From the list of Lead Teachers, identify those that have at least a Bachelor’s Degree using the following CEDS elements: 

• Degree or Certificate Type = 01051 (Bachelor’s (Baccalaureate) degree
• Degree or Certification Conferring Date ≤ July 1 of the early learning program year being reported. 

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

• Count the number of pre-k lead teachers with at least a bachelor’s degree
• Count the total number of teachers
• Divide the number of pre-k lead teachers with at least a bachelor’s degree by the total number of 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