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 (Ratio of number of students to number of full-time equivalent (FTE) counselors) is a measurement for a key indicator, “(Access to college and career advising),” and measures the ratio of K12 students to the number of full-time equivalent counselors available in high schools.

K12 - Ratio of number of students to number of full-time equivalent (FTE) counselors

Calculating a Response:

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

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

Use the following CEDS element to narrow the list to only bring in data associated with High Schools:

1.      Has School Level = High School, Secondary

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:

a.      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

b.      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

c.      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

d.      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 = Grades associated with High School

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

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 = School Counselors, Secondary School Counselors

For the universe of K12 counselors, sum their full-time equivalency using the following CEDS elements:

1. Staff Full Time Equivalency

Calculation Instructions:

1. Identify the total number of students.
2. Identify the sum of full-time equivalent (FTE) counselors.
3. Create a ratio for student-to-counselor for each school.

(Ex: If there are 150 students and 1.5 FTE counselors for a given school, the student-to-counselor ratio would be 100:1.)

Disaggregates

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