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

Metric: K12: Percentage of teachers by certificate type

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 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
• where School Level = 01304 (Elementary), 02402 (High School), 02399 (Intermediate), 02602 (Junior High School), 02400 (Middle), 02397 (Primary)

Narrow the list of K12 staff members to “teachers” using the following CEDS elements:

• Professional Educational Job Classification = Teacher
• K12 Staff Classification = Elementary Teachers, Kindergarten Teachers, Secondary Teachers, Special Education Teachers, and Ungraded Teachers.  

From the universe of teachers, narrow the list to those who are certified:

Pull all teachers where  

• Credential Type = Certification, and
• Credential Issuance Date is ≤ July 1 of the school year being reported, and
• Credential Expiration Date ≥ June 30 of the school year being reported or is null,  

Or where

Endorsement Type = 

• Elementary Education
• Secondary Education (English)
• Secondary Education (Mathematics)
• Secondary Education (Sciences)
• Secondary Education (Social Sciences)
• Agriculture
• American Sign Language
• Art Teacher
• Business Education
• Computer Science
• Dance
• Drama/Theater
• English as a Second Language (ESL)
• Foreign Language
• Gifted and Talented Education (GATE) Certification
• Health Educator
• Home Economics
• Journalism
• Music
• Physical Education
• Reading Specialist
• Special Education
• Speech Language Pathologist
• Technology
• Visually Impaired Teacher
• Education Technology
• Administrative Licensing
• Reciprocity
• Alternative Certification
• Librarian Certification

NOTE: this is not a comprehensive list of all possible endorsement types. Use whatever endorsement type(s) is recognized in your state.  

To determine the number of teachers with an Elementary Education endorsement type:   

• Count the total number of teachers from the universe of teachers.
• Count the total number of teachers with an Elementary Education endorsement type.
• Divide the number of teachers with an Elementary Education endorsement type by the total number of teachers and multiply by 100.

Repeat steps 1 through 3 for each subsequent endorsement type recognized in your state.

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