How to calculate students per counselor
Divide school enrollment by reported counselor full-time equivalent (FTE). FTE measures staffing allocation, not the number of people employed. Calculate a ratio only when enrollment is available and counselor FTE is greater than zero.
Hypothetical examples: 600 students ÷ 2.0 FTE = 300 students per counselor; 600 ÷ 0.5 FTE = 1,200. A fractional FTE can reflect a part-time or shared assignment. Neither result measures appointment availability or counseling quality.
What is the CRDC school counselor FTE variable?
In the 2017–18 CRDC school-level file, the variable is SCH_FTECOUNSELORS. Item STAF-4 in the official 2017–18 school form defines counselor FTE. K12 Atlas release v2026.07 uses CRDC SY 2021–22 for counselor staffing; consult that collection’s layout before reusing an older field mapping.
Zero FTE is different from a missing ratio
A reported zero means zero counselor FTE in that filing. Do not divide by zero or display it as a 0:1 ratio: that would imply no students per counselor. A blank staffing value provides no basis for calculating a ratio. Keep zero-FTE schools, missing records, and positive-FTE ratios in separate categories.
What the 250:1 reference means
The American School Counselor Association recommends 250 students per school counselor. It is a staffing reference, not a school rating. A school-level ratio and a national aggregate can use different populations, so check both denominators before comparing them.
Keep enrollment and staffing years together
CRDC staffing and a newer CCD enrollment figure describe different reporting periods. Such a mixed-year ratio can be useful for exploration if both years are disclosed, but it is not an observed same-year caseload. For a same-year comparison, align the school identifier, enrollment year, staffing year, and eligible school population.
Check the reported coverage
The counselor staffing summary and free state CSV distinguish reporting schools from the full public-school universe. Explore the Texas counselor data or California counselor data for state context. Use CRDC data and collection documentation to verify the original collection and the CRDC definition for the difference between staffing and directory records.
Need the school-level counselor field?
Start with the free Austin ISD sample, then choose district, metro, state, or national coverage.
Email me the sample →