General Connection Information

CEDS elements are shown in bold/italicized font and CEDS options are shown in italics.

Analysis Recommendations Label 1

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 (Same-race student–teacher ratio by race and ethnicity) is a measurement for a key indicator, “(Representational Racial and Ethnic Diversity of Educators),” and measures whether educators reflect the racial and ethnic diversity of the student body.

K12 - Same-race student–teacher ratio by race and ethnicity

Calculating a Response:

Use the following CEDS elements to determine the school year for which the data will be measured for K12 students:

1.      School Year = most recent school year, representing July 1 through June 30

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

1. Pull all unique students which is determined by using a unique Person Identifier where Has Person Identifier Type = Student Identifierand Has Person Identification System = State
2. Where the Student:
1. is associated with a State Education Agency through the Organization Identifier where Has Organization Identification System = SEA and Has Organization Identifier Type = State Agency Identifier
2. is associated with a Local Education Agency through the Organization Identifier where Has Organization Identification System = SEA or LEA and Has Organization Identifier Type = Local Education Agency Identifier
3. is associated with a K12 school through the Organization Identifier where Has Organization Identification System = SEA or LEA or School and Has Organization Identifier Type = School Identifier
4. Has Role = K12 Student

From the universe of students, identify which grade each student is currently enrolled in using the following CEDS elements:

1.      Enrollment Entry Date is ≥ July 1 of the school being reported

2.      Enrollment Exit Date is ≤ June 30 of the school year being reported

3.      Entry Grade Level = Kindergarten (KG) through Twelfth grade (12), Ungraded (UG)

Use the following CEDS elements to determine the universe of K12 Teachers:  

1. Pull all unique K12 Teachers which is determined by using a unique Person Identifier where Has Person Identifier Type = Staff Member Identifier and Has Person Identification System = State
2. Where the K12 Teacher:
1. is associated with a State Education Agency through the Organization Identifier where Has Organization Identification System = SEA and Has Organization Identifier Type = State Education Agency Identifier
2. is associated with a Local Education Agency through the Organization Identifier where Has Organization Identification System = SEA or LEA and Has Organization Identifier Type = Local Education Agency Identifier
3. is associated with a K12 school through the Organization Identifier where Has Organization Identification System = SEA or LEA or School and Has Organization Identifier Type = School Identifier
4. Has Role = K12 Staff
5. K12 Staff Classification = Elementary Teachers, Kindergarten Teachers, Secondary Teachers, Special Education Teachers, Ungraded Teachers

Calculation Instructions:

For each race/ethnicity group:

1. Divide the number of students in a group by the total number of students. Multiply by 100.
2. Divide the number of teachers in a group by the total number of teachers. Multiply by 100.
3. Create a ratio for student-to-teachers for each race/ethnicity group.

(Ex: 2% of student are American Indian or Alaska Native and 8% of teachers are American Indian or Alaska Native. Then, create student-to-teacher ratio, which is 2:8. To finalize the ratio, find the lowest common denominator, which makes the ratio 1:4.)

Disaggregates

To disaggregate the information for K-12 Students, see https://ceds.ed.gov/connectManageCase.aspx?UseCaseId=30982.