Login
Home > Blog

Ranking Public School Quality (Badly):
Forbes' has problems with information quality

7 Jul 2007 in

School quality is something about which everyone seems to have an opinion, and a compulsion to rank. For example, every year there is a kerfuffle about the college rankings published by US News and World Report. This year the ranks of college administrators refusing to provide data to US News has grown because opponents have become more organized.

Elementary and secondary school rankings are the latest trend, and the number of rankings can be expected to grow as more statistics are made available. What do these rankings actually mean?

Forbes' Christina Settimi reviewed 97 public school districts to rate "the best and worst school districts for the buck." But her methodology has too many fatal flaws to make the results interpretable. It offers an excellent case study in how not to provide statistical information. A federal agency armed with the same data could not have disseminated the Forbes ranking without violating the federal Information Quality Act and associated implementing guidelines:

Each one of these errors is fatal for information dissemination by the federal government. Contrary to the adage, the Forbes ranking is not good enough for government work.

WHAT IS THE SAMPLE FRAME?

There are many more than 97 school districts in the US. Why did Settimi choose these 97?

Using research provided by the Tax Foundation, a nonpartisan tax research group based in Washington, D.C., Forbes began with a list of the 775 counties in the country with populations greater than 65,000 that had the highest average property taxes. From this list we isolated the 97 counties where more than 50% of per-pupil spending contributions comes from property taxes.

School districts funded primarily through means other than property taxes are excluded. The reason for this exclusion is nowhere made clear. Any "bang for the buck" ranking that excludes thousands of school districts for arbitrary reasons has no value. When a sample frame is unrepresentative of the population, results from the sample cannot be applied to the population.

So when Settimi says "Marin County, Calif., provides the best bang for the buck," the best that can be said is that Marin ranked highest of the 97 school districts Settimi considered. As we show below, even that statement has to be presented with huge caveats. Settimi ranked it tops on criteria that she chose but did not reveal.

WHAT IS MEASURED?

Settimi's ranking purports to link two outputs (college entrance examination scores and high school graduation rates) with one input (per pupil spending) and one intermediate snapshot (proportion of high school students taking college entrance examination tests). These outputs are not the same as outcomes; an objective measure of school quality must control for the academic quality of inputs. A school that begins with 90th percentile students and raises them to the 91st percentile achieves very little, whereas a school that begins with 50th percentile students and raises them to the 80th percentile achieves a lot. The latter school is properly judged to have produced high quality, whereas the former school merely had high quality inputs and did no harm.

Which high schools are included in Settimi's calculations? For Alexandria VA (rank = 97), there is only one high school. But for Marin County CA (rank = 1), this cannot be determined. There are four high school districts in Marin County, with seven major high schools and several specialty and continuation high schools. These four districts are very different. For example, date available from the U.S. Department of Education's National Center for Educational Statistics shows that less than 5% of pupils in the Tamalpais High School district are eligible for free school lunches -- a commonly used proxy for economic disadvantage. But in neighboring San Rafael City High School District, 27% of pupils are eligible for free lunches. Which of these districts Is Settimi using for her comparison? She does not say.

High schools in Marin County vary. Whites and Hispanics each comprise 41% and 45% , respectively, of the students at San Rafael HS. At the other five major high schools, however, whites are 83% (Redwood), 72% (Tamalpais), 67% (Novato), 78% (San Marin), and 65% (Tomales). Hispanics are 4% (Redwood), 6% (Tamalpais), 20% (Novato), 12% (San Marin), and 31% (Tomales). Black students are a curiosity; the highest percentage at any Marin County high school is 7% (Tamalpais).

T.C. Williams HS in Alexandria VA is very different. It is 26% white, 43% black, and 24% Hispanic. 23% of its students are eligible for free school lunches. Of 7.051 students who attended the seven  major Marin County high schools, only 1,228 (17%) attended a school with a similar proportion of economically disadvantaged kids. Of these seven schools in Marin County, T.C. Williams is demographically most like San Rafael HS and its per-pupil spending is similar ($15,029 vs. $14,698). Whereas San Rafael is evenly balanced between white and Hispanic students, T.C. Williams has about twice as many black students as whites and Hispanics. It is culturally a completely different place. Yet, on some other conventional  measures of  "school quality," T.C. Williams fares better. Its pupil-teacher ratio (15.6) is a lot lower than that of San Rafael HS (21.4).

When the data for T.C. Williams HS are disaggregated, racial differences in educational performance become obvious:

Analogous racial differences in student performance are evident in data from San Rafael HS found on California Standardized Testing and Reporting (STAR):
[NA% means too few students were tested to report summary percent passing without revealing student identities.)

More detailed examination likely would reveal that high-performing students of any race or ethnic heritage are enrolled in advance placement classes where they encounter more demanding standards, similarly high-performing students, and possibly different teachers. In short, they may go to the same physical facility for school but their school experience is fundamentally different.

ARE THE DATA VALID?

Settimi suggests that they are not. Regarding high school graduation rates, she says they are not measured uniformly and she did not even attempt to validate the data she used:

Since no standard method to calculate a graduation rate is enforced nationally, and the college entrance exam boards will only release data below a state level directly to the schools, not the public, we were left to trust county, district and school officials to honestly and accurately report their results.


Graduation rates can be inflated by choosing not to include some students in the calculation. SAT and ACT scores are biased measures of average student performance because not all students take these exams. The more marginally qualified students take them, the lower will be the school's average. So one way to increase a school's average is to discourage marginal students from taking them. Interestingly, the proportion of students taking the SAT was higher in 97th-ranked Alexandria (65%) than in 1st-ranked Marin County (60%).

More representative data on student performance are available from NCES' National Assessment of Educational Progress, California's STAR system, and Virginia's School Report Cards. Settimi doesn't reveal why she used school district-wide SAT scores, which are clearly subject to selection bias.

WHAT ABOUT SCHOOL EXPENDITURE DATA?

Settimi's data on school spending are similarly problematic. She says Alexandria VA spent $15,029 i("Fiscal Year 2004, adjusted for the cost of living in the county's associated Metropolitan Statisical [sic] Area") -- the same figure reported by NCES. But she also says Marin County spent just $6,579 per pupil. NCES says the four high school districts spent $8,311 (Novato Unified), $14,698 (San Rafael City), $19,417 (Shoreline Unified), and $21,254 (Tamalpais Union). Not only do none of these figures match, they vary by more than 250%.

District-wide figures also disguise variations in funding within schools belonging to the same district. Access to within-district data is surely very difficult, and hampered by accounting systems that are not transparent, logically to prevent such differences from being detected.   

Finally,  these figures capture only school expenditures that are "on the books." Schools often raise considerable sums from other sources, notably parents, to fund special programs. Yet the fact that parents are willing to donate to fund special programs means that district-wide average funding is a poor proxy for actual financial inputs -- and that's even if  the public figures are accurate.

ARE THE CONCLUSIONS VALID?

Notwithstanding all of these problems, Settimi is not deterred from drawing sweeping conclusions:

The caveats to our methodology notwithstanding, our study shows that there are big differences in the quality of education relative to spending among counties and is further proof that money is not the only--or perhaps even the most important--factor when it comes to the quality of education.

But her study shows no such thing. She did not directly or indirectly measure school quality. She included just one input -- per pupil spending -- and apparently did that badly. She ignored many other important inputs, such as IQ, teacher qualifications and training, the availability of college prep courses, parental involvement, and socioeconomic status. She tried to link this single input measure to a pair of outputs -- graduation rates and SAT/ACT scores -- without regard for whether the data were any good. (She acknowledged that graduation rates probably were biased but did nothing to validate them, and she ignored the dominant source of bias in average SAT/ACT scores: the number of marginally qualified students who take them.)

The result is that the rankings for Marin County and Alexandria could be reversed even using Settimi's dubious methodology, just if the underlying data were corrected. Marin County fares especially well when per pupil expenditures are underestimated by, say, a factor of 2.

FATAL DEFECTS IN INFORMATION QUALITY

If for some reason the federal Department of Education wanted to rank school districts on cost-effectiveness, it could not legally disseminate a product as deeply flawed as the one produced by Christina Settimi and published by Forbes. The reason is that this ranking violates information quality standards that apply to EdD and which Forbes ought to consider applying to its own work products.

A federal agency cannot legally disseminate a nominally statistical report that fails all of these information quality standards. Reports that fail these standards should  not be taken seriously. Unfortunately, that's the only standard that Christina Settimi's study actually meets.

 


 


Selected Educational Statistics on
Marin County (CA) and Alexandria (VA) High Schools

High
School
(County)
[District]
Pupils
(Pupil/
Teacher
Ratio)
Number
(%)
Free
Lunch
Eligible
Demographic
Data for School
Reported by NCES
2000 Census
Demographic
Data for School District:
Numbers and %
Reported by NCES
Per Pupil Expend.
Reported by NCES
Per Pupil
Expend
Reported by
Forbes
Redwood
(Marin)
[Tamalpais Union]
1,467
(18.1)
27
(2%)

White
Black
Hispanic

1,211 
29
60

83%
2%
4%
*Total
White
Black
Hispanic
22,737
19,469
611
1,253

100%
86%
3%
1%

$21,254 $6,579
Tamalpais
(Marin)
[Tamalpais Union]
1,132
(18.1)
58
(5%)

White
Black
Hispanic

820
78
73

72%
7%
6%
San Andreas
(Marin)
[Tamalpais Union]
135
(16.9)
6
(4%)
White
Black
Hispanic
106
11
9
79%
8%
7%
San Rafael HS
(Marin)
[San Rafael]
1,008
(21.4)
268
(27%)

White
Black
Hispanic

417
33
450

41%
 3%
45%
*Total
White
Black
Hispanic
13,924
9,664
412
4,016
100%
69%
3%
29%
$14,698
Madrone HS
(Marin)
[San Rafael]
47
(15.7)
0
(0%)

White
Black
Hispanic

10
6
27

21%
13%
57% 
Terra Linda
(Marin)
[San Rafael]
1,027
(19.2)
70
(7%)
White
Black
Hispanic
742
31
158
72%
3%
15%
Juvenile Hall
(Marin)
[Marin Co Ofc of Ed]
177
(44.2)
40
(23%)

White
Black
Hispanic

81
24
63
 
46%
14%
36%
 NA  NA
Phoenix Academy
(Marin)
[Marin Co Ofc of Ed]
30
(1)
9
(30%)
White
Black
Hispanic
18
1
8
60%
3%
27%
Marine County
Special Education
(Marin)
[Marin Co Ofc of Ed]
249
(5.9)
51
20%)
White
Black
Hispanic
149
26
44
60%
10%
18%
Marin Oaks
(Marin)
[Novato Unified]
65
(15.9)
6
(9%)

White
Black
Hispanic

50
4
9

77%
6%
14%
*Total
White
Black
Hispanic
12,540
9,814
266
2,119
100%
78%
2%
17%
 $8,311
Marin School of Arts And Technology
(Marin)
[Novato Unified]
178
(17.8)
4
(2%)
White
Black
Hispanic

132
3
25

74%
2%
14%
Nova Education Center
(Marin)
[Novato Unified]
97
(22.0)
1
(1%)
White
Black
Hispanic

62
0
8
64%
0%
8%
Novato
(Marin)
[Novato Unified]
1,146
(24.8)
141
(12%)

White
Black
Hispanic

769
46
230

67%
4%
20%
San Marin
(Marin)
[Novato Unified]
1,051
(24.8)
74
(7%)

White
Black
Hispanic

820
27
121

78%
3%
12%
Shoreline HS
(Marin)
[Shoreline Unified]
7
(-1)**
2
(29%)

White
Black
Hispanic

5
0
2
 
71%
0%
29%
*Total
White
Black
Hispanic
1,344
1,016
13
402
100%
76%
0%
30%
$19,417
Shoreline Independent Study
(Marin)
[Shoreline Unified]
3
(-1.0)*
NA
White
Black
Hispanic
3
0
0
100%
0%
0%
Tomales(Marin)
[Shoreline Unified]
220
(12.4)
56
(25%)

White
Black
Hispanic

144
0
69


65%
0%
31%

TC Williams
(Alexandria)
[Alexandria]
2,859
(15.6)
659
(23%)

White
Black
Hispanic

740
1,219
692

26%
43%
24%
*Total
White
Black
Hispanic
21,537
9,363
7,006
5,031
 100%
43%
33%
23%
$15,029  $15,029
Source: NCES except where noted.
Notes:

* 2000 Census Data: Total population 18 years of age or younger
** As reported.

 


 

|
"Best And Worst School Districts For The Buck"
(According to
Forbes.com)

[add a comment]

Add a Comment

Rank County State Per Pupil Spending 1 College Entrance
Exam Score2,3
College
Entrance Exam
Participation Rate3
Graduation Rate3
1 Marin CA $6,579 1,133 60.40% 96.80%
2 Collin TX $7,048 1,103 69.40% 92.20%
3 Hamilton IN $8,897 1,075 76.00% 95.00%
4 Norfolk MA $8,845 1,090 87.80% 89.20%
5 Montgomery MD $8,824 1,101 76.50% 91.40%
6 Fairfield CT $8,376 1,051 82.70% 92.00%
7 Howard MD $9,488 1,113 72.00% 93.80%
8 Monmouth NJ $10,081 1,059 83.30% 98.90%
9 Williamson TX $7,163 1,066 72.40% 88.80%
10 Fort Bend TX $6,906 1,034 73.10% 90.90%
11 Morris NJ $10,642 1,092 85.30% 98.40%
11 Loudoun VA $8,223 1,073 78.00% 87.00%
13 Hunterdon NJ $11,198 1,104 91.00% 97.50%
14 Somerset NJ $10,084 1,112 87.20% 88.30%
15 Denton TX $7,039 1,081 62.20% 89.70%
16 Ozaukee WI $9,959 24 72.20% 96.80%
17 Johnson KS $7,756 23 66.20% 95.50%
17 Santa Clara CA $5,500 1,098 49.70% 88.40%
19 Chester PA $11,314 1,075 79.60% 95.90%
20 Bergen NJ $11,712 1,072 87.50% 99.00%
21 Frederick MD $6,686 1,052 55.00% 95.00%
21 San Mateo CA $5,916 1,062 46.50% 92.60%
23 Middlesex MA $9,485 1,074 82.10% 87.50%
24 Albemarle VA $8,497 1,098 74.00% 84.00%
25 Sussex NJ $9,932 1,039 73.60% 97.70%
26 Kendall IL $7,826 19.8 97.70% 92.70%
27 Lake IL $8,985 22 94.60% 94.10%
28 Fairfax VA $8,438 1,114 70.50% 84.00%
28 Napa CA $6,328 1,055 31.70% 94.60%
30 McHenry IL $7,980 21.2 93.90% 92.00%
31 Nassau NY $11,711 1,073 86.00% 90.20%
32 Will IL $7,520 20 94.10% 91.10%
33 Martin FL $6,420 1,055 65.00% 84.90%
34 Middlesex NJ $10,143 1,030 75.30% 97.40%
35 Montgomery PA $11,758 1,068 74.00% 94.80%
36 Kane IL $7,665 20 95.10% 88.80%
37 Carroll MD $7,833 1,046 62.00% 93.80%
38 Galveston TX $6,756 1,048 68.20% 84.60%
38 Travis TX $7,795 1,054 78.20% 81.30%
40 Washington RI $10,648 1,062 67.70% 93.30%
41 Geauga OH $9,503 22 73.40% 96.50%
41 Montgomery TX $6,685 1,051 62.60% 85.90%
43 Waukesha WI $10,013 23 67.20% 95.60%
44 Rockland NY $13,956 1,071 86.80% 87.40%
45 Bucks PA $11,158 1,054 65.80% 94.60%
46 Westchester NY $14,352 1,084 81.50% 84.90%
47 McLean IL $9,508 21.3 91.20% 92.00%
48 Hanover VA $6,979 1,025 67.00% 86.00%
49 Chesterfield VA $6,977 1,030 69.00% 84.00%
50 Hartford CT $10,347 1,022 76.80% 90.40%
51 Calvert MD $7,166 1,050 57.00% 90.00%
52 Comal TX $6,938 1,015 65.60% 87.10%
53 Randall TX $6,644 1,046 33.70% 89.00%
54 Barnstable MA $8,896 1,038 77.20% 83.10%
55 Sarasota FL $6,822 1,057 60.90% 81.70%
56 Cumberland ME $9,625 1,050 65.60% 88.70%
57 Monroe FL $6,072 973 76.80% 76.70%
58 Brazos TX $7,968 1,091 54.80% 82.40%
59 Putnam NY $12,616 1,050 72.30% 88.40%
60 Newport RI $9,725 1,021 65.10% 91.40%
60 Knox TN $7,048 22 85.00% 75.80%
62 Brazoria TX $6,830 1,033 62.10% 82.40%
63 Dane WI $10,576 23.9 63.10% 87.80%
64 Arlington VA $11,855 1,085 72.00% 81.00%
65 Delaware OH $10,256 22.4 64.20% 95.50%
65 Hays TX $7,342 1,017 62.20% 86.60%
67 Indian River FL $6,455 1,018 45.00% 85.30%
68 Ocean NJ $8,920 999 69.30% 86.90%
69 Tarrant TX $6,891 1,018 59.50% 85.20%
69 Palm Beach FL $5,995 1,005 58.50% 69.00%
71 Cass ND $8,641 22 70.60% 85.00%
71 St. Johns FL $7,034 1,043 63.00% 76.80%
73 Collier FL $6,126 1,018 49.00% 74.30%
74 Cook IL $9,238 18.8 92.80% 83.10%
75 Henrico VA $6,990 1,033 57.30% 82.00%
75 Anne Arundel MD $8,217 1,056 51.00% 83.00%
77 Lancaster NE $9,106 22.6 76% 5 81.20%
78 Suffolk NY $10,423 940 82.60% 87.00%
79 Delaware PA $10,959 1,003 65.10% 91.40%
80 York ME $8,616 999 58.50% 88.50%
81 Charlotte FL $6,458 996 44.40% 76.70%
82 Lee FL $6,213 965 43.80% 69.40%
82 Minnehaha SD $7,139 22.7 61.70% 81.80%
84 Dallas TX $6,883 971 55.80% 81.30%
85 Harris
*
*
*
Check to receive notifications of future comments.
Yes
No