- Enrollment
- 1,053
- Students per teacher
- 19.1:1
- Resource Index
- 48/100
Middle school (grades 6-8) · Sunnyvale, CA
Columbia Middle
Federal NCES profile for Columbia Middle, including enrollment, faculty, free-lunch eligibility, demographics, and resource indicators - Resource Investment Index 42/100.
2024-25 NCES dataMiddle school (grades 6-8)NCES 063846006464
👥 S:T ratio 22
🌟 Gifted program 30
📋 Attendance 73
Scored 0–100 from federal NCES and CRDC indicators, resource allocation, not test scores. Full methodology →
The verdict
Columbia Middle earns 42/100 on the Resource Investment Index, with class sizes smaller than 70% of California schools.
- #2 of 4
- middle schools in Sunnyvale · Resource Index
- 42
- Resource Index · Typical
- 19.4:1
- small classes for California
- 42.6%
- free-lunch eligible
Columbia Middle has class sizes smaller than 70% of California schools. Computed live against every California school reporting to NCES.
By Resource Investment Index, Columbia Middle ranks #2 of 4 middle schools in Sunnyvale, CA.
School address
District: Sunnyvale · California
NCES ID 063846006464 Verify on NCES CCD record →
CCD year-over-year · 2022-23 → 2023-24
+85 students YoY
Columbia Middle grew from 587 students in 2022-23 to 672 in 2023-24 (+14.5%).
Teacher FTE added 36.2 → 36.9 across the same CCD years.
Source: NCES Common Core of Data public-school universe (2022-23, 2023-24).
Growing CCD campus
+85 students YoY 063846006464 · Sunnyvale, CA Middle · MID · TRAD
697 enr · 19.4:1 · 42.6% lunch · RII 42
Nearest enrollment peer: Sunnyvale Middle (1,053 students)
Columbia Middle grew from 587 students in 2022-23 to 672 in 2023-24 (+14.5%). Teacher FTE added 36.2 → 36.9 across the same CCD years. Read with this school → · District book → · California schools → · Find another →
Columbia Middle in the enrollment neighbourhood
Fall enrollment among this campus and nearest district peers
- Sunnyvale Midd
Sunnyvale Middle
1,053 students
- Ellis Elementa
Ellis Elementary
768 students
- This school
Columbia Middle
697 students
- Cherry Chase E
Cherry Chase Elementary
622 students
- Cumberland Ele
Cumberland Elementary
586 students
- Bishop Element
Bishop Elementary
465 students
What this shows Columbia Middle reports 697 students on the CCD universe file.
How Columbia Middle compares
Columbia Middle is a growing campus on CCD: ratios and free-lunch share vs California and U.S. means.
| Metric | This school | vs California | California avg | U.S. avg |
|---|---|---|---|---|
| Students per teacher | 19.4:1 | ▼ 10% | 21.5:1 | 15.7:1 |
| Free-lunch eligible | 42.6% | ▼ 23% | 55.5% | 51.7% |
| Enrollment | 697 | top 24% | - | - |
Source: NCES Common Core of Data School-level CCD + state/national means from Public School Universe · 2024-25
19.4:1
Leaner classes than 18% of US schools, heavier class loads than most.
697
Bigger than 80% of US schools by enrollment, a large campus nationally.
Equity indicators methodology
Economic need
42.6%
free-lunch eligible
- 23% below the California average of 55.5%
Above the 40% Title I schoolwide threshold; federal funds support the whole school, not individual students.
Staffing depth
19.4:1
students per teacher
- 10% below state mean
Top 30% in California - lower ratio than 70% of state schools
Between 16:1 and 20:1, squarely in the typical U.S. public-school staffing range.
Engagement
10.9%
chronically absent (missed 10%+ of school days)
In the 10-15% range, above the pre-pandemic national baseline but within the broader post-pandemic picture.
Funding equity
$24,087
per pupil, district-wide
- above California avg of $18,665
Well above the U.S. public-school average, reflecting substantially higher local or state investment per enrolled student.
Support staff
Counselors0.0 FTE
Student-support staffing from the Civil Rights Data Collection.
Discipline context
39
in-school suspensions + 36 out-of-school
Suspension rate: 5.6 per 100 students. Combined in-school and out-of-school rate: 10.8 per 100 students. Reported via the Civil Rights Data Collection.
Student demographics
Hispanic or Latino 54.1%
Asian 17.6%
White 15.4%
Two or More 7.2%
American Indian / Alaska Native 2.9%
Native Hawaiian / Pacific Islander 2.0%
African American 0.9%
Largest group: Hispanic or Latino at 54.1% of enrollment.
Student-body diversity index 64.6/100
Simpson diversity index - at 64.6, Columbia Middle is more mixed than the California school average of 46.0.
Programs
District finance for Sunnyvale reports $24,087 per pupil (NCES F-33) - open the district page for the full revenue mix.
How Columbia Middle Compares to District-Mates
| School | Enrollment | Economic Profile | Student-Teacher Ratio |
|---|---|---|---|
| Sunnyvale Middle | Larger | Lower economic need | Similar S:T ratio |
| Ellis Elementary | Similar size | Lower economic need | Higher S:T ratio |
| Cherry Chase Elementary | Similar size | Lower economic need | Higher S:T ratio |
| Cumberland Elementary | Similar size | Lower economic need | Similar S:T ratio |
| Bishop Elementary | Smaller | Similar economic need | Higher S:T ratio |
Comparisons are relative to Columbia Middle's own figures; each column derives from NCES Common Core of Data.
Other Schools in This District
- Enrollment
- 768
- Students per teacher
- 25.6:1
- Resource Index
- 32/100
- Enrollment
- 622
- Students per teacher
- 21.4:1
- Resource Index
- 43/100
- Enrollment
- 586
- Students per teacher
- 20.2:1
- Resource Index
- 42/100
- Enrollment
- 465
- Students per teacher
- 21.1:1
- Resource Index
- 32/100
Similar middle schools in Sunnyvale
3 comparable middle schools (grades 6-8) serving the same city.
Nationwide middle schools with similar size or staffing
Out-of-state peers matched by enrollment and by student-teacher ratio, not the same-city or same-district lists above.
Similar enrollment (~697 students)
Frequently asked questions about Columbia Middle
How many students attend Columbia Middle?
Columbia Middle has 697 students enrolled. It is a middle school in Sunnyvale, CA. CCD year-over-year: 587 (2022-23) → 672 (2023-24), up 85.
What is the student-teacher ratio at Columbia Middle?
The student-teacher ratio at Columbia Middle is 19.4:1, which is 10% lower than the California average of 21.5:1 and 24% higher than the national average of 15.7:1. Lower ratios generally mean more individual attention per student.
What percentage of students receive free lunch at Columbia Middle?
42.6% of students at Columbia Middle are eligible for free lunch, compared to the California average of 55.5%.
What is the racial and ethnic makeup of Columbia Middle?
The largest demographic group at Columbia Middle is Hispanic or Latino at 54.1% of enrollment, in Sunnyvale, CA. Its student body is more racially and ethnically mixed than most US schools, with a diversity index of 64.6/100.
What is the Resource Investment Index for Columbia Middle?
Columbia Middle has a Resource Investment Index of 42/100 (typical reported resources relative to schools nationally) based on 3 factors: student-teacher ratio, gifted-program reporting, chronic absenteeism. Not a test-score or academic measure (national median ~41/100, see methodology).
How does Columbia Middle rank among middle schools in Sunnyvale?
By Resource Investment Index, Columbia Middle ranks #2 of 4 middle schools in Sunnyvale, CA. This compares federal resource and staffing data among local peers; it is not a test-score or academic ranking. See all middle schools in Sunnyvale on the city page.
What other schools are in Sunnyvale?
Besides Columbia Middle, Sunnyvale also operates Sunnyvale Middle (1,053 students), Ellis Elementary (768 students), and Cherry Chase Elementary (622 students). See the Sunnyvale district page for the complete list.