2024-25 NCES data Middle school (grades 6-8) NCES 260426004102

Western Middle School — Auburn, MI

Federal NCES profile for Western Middle School, including enrollment, faculty, free-lunch eligibility, demographics, and resource indicators — Resource Investment Index 41/100.

0/100100/10041/100
👥 Class size
24
🌟 Gifted program
70
🎓 Counselors
55
📋 Attendance
17
How this works: Each indicator above is scored 0–100 from federal NCES and CRDC data, then averaged into the Resource Investment Index. This measures resource allocation — staffing, programs, and support services — not standardized test scores or academic outcomes. Full methodology →

School address

Public location data per NCES (National Center for Education Statistics) Common Core of Data. Verify the school's current address on the NCES CCD record.

Enrollment

681

Michigan · 2024-25 NCES data

Teachers (FTE)

38.0

Federal CCD staff survey

Students per teacher

19.1:1

vs 18.2:1 Michigan avg

+5% vs state

Free-lunch eligible

31.5%

vs 54.3% Michigan avg

-42% vs state

Student-teacher ratio in context

How Western Middle School compares with Michigan and U.S. medians

Slightly above state median

Source: NCES Common Core of Data As of 2024-25 federal staff survey Total enrollment ÷ full-time-equivalent classroom teachers

The federal record — no proprietary index, no editorial formula. PlainSchools publishes the actual federal measurements — enrollment, staffing, demographics, discipline, and finance — straight from the NCES Common Core of Data, CRDC, and F-33 surveys. No composite rating, no opinion-based score on top. You get the same raw numbers researchers and policymakers use, with benchmarks, spending context, and equity indicators computed from the same federal datasets. Full methodology linked below.

What this school's NCES data tells you

Western Middle School reports 681 enrolled students to the National Center for Education Statistics (NCES) alongside 38.0 full-time-equivalent teachers, producing a 19.1:1 student-teacher ratio. That figure sits 5% above the Michigan state mean of 18.2:1, signalling larger average class loads than peers in the same state. Against the national 2024-25 average of 15.9:1, it is 20% higher, a useful calibration for families comparing districts across state lines.

Title I and federal lunch eligibility offer another window into the student body: 31.5% of pupils qualify for free meals, a proxy for household income that federal programs use to direct funding. The free-lunch share is 42% below the Michigan average and 39% below the national baseline. Counselor coverage works out to roughly 227 students per counselor, meeting the American School Counselor Association recommendation of 250:1. Chronic absenteeism — missing 10% or more of school days — stands at 33.2% according to the 2021-22 Civil Rights Data Collection.

On the finance side, the surrounding Bay City School District spends $15,225 per pupil district-wide, below the Michigan average of $15,842 and below the national average of $19,490. Revenue comes 20.2% from local sources (property taxes), 61.2% from the state, and 18.7% from federal programs per the NCES F-33 finance survey. Taken together, these measurements produce a Resource Investment Index of 41/100 (D), calculated from 4 distinct NCES and CRDC indicators measuring resource allocation rather than academic outcomes.

Source: National Center for Education Statistics Common Core of Data + CRDC + F-33 · 2024-25

How Western Middle School compares

Cross-validating school-level NCES values against Michigan state and U.S. national means lets readers see whether this school is an outlier or in line with peers.

Metric This school vs Michigan Michigan avg U.S. avg
Students per teacher 19.1:1 ▲ 5% 18.2:1 15.9:1
Free-lunch eligible 31.5% ▼ 42% 54.3% 51.8%
Enrollment 681 top 87%

Source: NCES Common Core of Data School-level CCD + state/national means from Public School Universe · 2024-25

What the federal data reveals about equity at this school

Federal measurements — not ratings — surface the resource and opportunity picture. Below are the indicators that researchers, civil-rights monitors, and funding formulas use to assess equity.

Economic need
31.5%
free-lunch eligible — 42% below the Michigan average of 54.3%
Below the 40% Title I threshold — federal aid targets individual qualifying students rather than schoolwide programs.
Staffing depth
19.1:1
students per teacher — 5% above state mean
Top 73% in Michigan — lower ratio than 27% of state schools
Between 15:1 and 20:1 — in line with the typical U.S. public-school staffing range.
Engagement
33.2%
chronically absent (missed 10%+ of school days)
Chronic absenteeism at or above 20% — the CDC threshold for "high" — signals significant barriers to regular attendance.
Funding equity
$15,225
per pupil, district-wide — below Michigan avg of $15,842
Below the U.S. average per-pupil spend — funding constraints may affect programs, facilities, and staffing.
Support staff
Counselors3.0 FTE
Per 227 students — the combined health-and-guidance staffing load for this school.
Discipline context
0
in-school suspensions + 0 out-of-school
Suspension rate: 0.0 per 100 students. Combined in-school and out-of-school rate: 0.0 per 100 students. Reported via the Civil Rights Data Collection. Includes 1 expulsion.

Overview

Enrollment 681 Top 87% in Michigan — larger than 13% of 3,399 state schools
Teachers (FTE) 38.0
Students per teacher 19.1:1 +5% vs state
Free-lunch eligible 31.5% -42% vs state
NCES ID 260426004102

Student demographics

White 87.2%
Hispanic or Latino 5.9%
Two or More 5.0%
African American 0.9%
American Indian / Alaska Native 0.6%
Asian 0.3%
Native Hawaiian / Pacific Islander 0.1%

Largest group: White at 87.2% of enrollment.

Programs & staff

Gifted & talented Yes
Counselors (FTE) 3.0
Students per counselor 227:1

Discipline & special education

Chronically absent 33.2%
In-school suspensions 0
Out-of-school suspensions 0
Expulsions 1

Funding & spending

District-wide per-pupil expenditure for Bay City School District, which includes Western Middle School.

$15,225
Per student
-4%
vs Michigan
Avg $15,842
-22%
vs U.S.
Avg $19,490
Revenue mix
Local 20.2%
State 61.2%
Federal 18.7%

Source: NCES F-33 School District Finance Survey District-level finance · FY 2021-22 Per-pupil expenditure reflects the district-wide average. Individual school budgets are not reported at the federal level.

Other Schools in This District

Bay City School District · 5 sibling schools

View district profile

Educator & family resources

In-depth guides on understanding NCES data, school choice, and education funding.

Frequently asked questions about Western Middle School

How many students attend Western Middle School?

Western Middle School has 681 students enrolled. It is a middle school in AUBURN, MI.

What is the student-teacher ratio at Western Middle School?

The student-teacher ratio at Western Middle School is 19.1:1, which is 5% higher than the Michigan average of 18.2:1 and 20% higher than the national average of 15.9:1.

What percentage of students receive free lunch at Western Middle School?

31.5% of students at Western Middle School are eligible for free lunch, compared to the Michigan average of 54.3%.

What is the racial and ethnic makeup of Western Middle School?

The largest demographic group at Western Middle School is White at 87.2%. The school serves a diverse student body in AUBURN, MI.

What is the Resource Investment Index for Western Middle School?

Western Middle School has a Resource Investment Index of 41/100 (D) based on 4 factors: student-teacher ratio, counselor availability, attendance rates. This index measures federal resource allocation — staffing levels, program availability, and support services — not standardized test scores or academic outcomes.

Explore PlainSchools

Source: National Center for Education Statistics (NCES) CCD + Public School Universe (2024-25), CRDC (2021-22), F-33 District Finance Survey (FY 2021-22) · 2024-25 Data as of the 2024-25 school year. Coverage from U.S. Department of Education NCES Common Core of Data. Varies by entity type — administrative districts and certain charter networks may report only a subset of fields.

All federal data sources used on this page
  • NCES Common Core of Data (CCD) — universe of U.S. public schools and districts. nces.ed.gov/ccd
  • NCES Civil Rights Data Collection (CRDC) — discipline, absenteeism, and AP-course participation. ocrdata.ed.gov
  • NCES F-33 School District Finance Survey — per-pupil expenditure and revenue sources. nces.ed.gov/ccd/f33agency
  • USDA National School Lunch Program (NSLP) — free and reduced-price lunch eligibility. fns.usda.gov/nslp
  • U.S. Census Bureau ACS — demographic and socioeconomic context for school catchment areas. census.gov/programs-surveys/acs
  • U.S. Department of Education ESSA Title I — federal Title I program participation. ed.gov