Madison Area Schools

2011 Middle School Rankings

2011-11-04T13:16:00.004-06:00

It's been a while since my last post but now that the 2011 testing has started, I thought I'd share the middle school rankings from the 2010 test data.

6 of the top 10 are Madison Metro; 4 of the bottom 10 are Madison Metro. What can you say about that? Who knows. There's almost a 15% difference in the number of students scoring advanced from the #1 to the #10 school though. That's pretty high.

The other thing I find interesting is the fact that the Core Knowledge charter school doesn't outperform the "regular" high performing MMSD middle schools. It is getting better though - in the 2008 data, the Core Knowledge kids were at 55%; now they're way up at 70.4%. Of course you have to be in a lottery to get into the Core Knowledge school (plus you have to live in Verona - not my suburban dream but to each his own). You can just move to one of the high performing attendance areas in the MMSD to get in there.

It's interesting to point out that Sherman is also moving up a bit. 37.8% is nothing to shout about but better than the 25% of 2008.

Madison Area Elementary School Performance Map

2011-04-25T20:22:00.003-06:00

This data is directly from the previous post but displayed in a potentially more informative way.

What you are seeing below is a map of Madison-area elementary school boundaries colored by rank order where bright green = best and bright red = worst.

Rank order is a little misleading in some ways. It somewhat artificially creates visual differences based on sometimes small statistical differences. On the other hand it's pretty interesting and informative especially where dramatic color differences border each other.

There are several schools not displayed on here you may notice. Two in Middleton and Waunakee have no data that differentiates economically vs. non-economically disadvantaged students.

If you have boundary maps for Monona Grove or McFarland, post or email a link because I couldn't find any maps for them to code.

Click a region to show a pop-up with detailed elementary school information.

Madison Elementary School Boundaries
Displayed in Rank Colored Order
Color key: Green is best, Yellow is better, Orange is OK, Red is worst

2011 Elementary School Rankings

2011-04-13T15:40:00.004-06:00

Well really these are based on 2010 data but posting for 2011.

I had a brief scare having to do with differences between the data I present and what you might hand calculate from the DPI web site. The per-school scores of previous posts are correct. The aggregated data for districts is incorrect due to an error on my part. I will be re-examining the aggregated district data at a later point.

For now, you can see how our area elementary schools scored on their 2010 tests.

I am impressed again that 8 of the top 10 elementary schools are Madison Metro. Not only that but all of the top 6 are Madison Metro. I'm further pleased to note that my personal favorite, Marquette Elementary has moved up quite a bit to spot #3 in the local roundup!

A good elementary-level education has been shown to affect the rest of a child's life. The data again illustrate the importanct of particular schools and very specific local areas. Again, these are not economically disadvantaged students. Performance between schools of these students should be similar but it unfortunately is not.

High Schools in 2009

2009-12-23T13:25:00.005-06:00

For high school rankings, not much is different from 2008 although there seems to have been a slight trend upward of all the area schools.

Middle Schools and Obama's Visit

2009-11-05T14:25:00.004-06:00

Non-Economically Disadvantaged Comparison

With Obama's recent visit to Wright Middle School, it seems like an opportune time to post the statistics for area middle schools.

Despite the apparent success of Wright, I wouldn't identify it as a particularly great school based on the data. As usual these data are for non-economically disadvantaged 8th graders.

As you can see James Wright (James Wrt) falls quite low in the rankings although I guess it's not so terrible compared on a state-wide basis. 44th percentile statewide is no great shakes though.

The top few remain generally the same year to year but switch places slightly. The top 5 schools are all Madison metro. Low and behold, the bottom 4 are also Madison metro.

I think both O'Keefe Middle School and Hamilton should be called out specifically this year though. In state-wide rankings across all middle schools, Hamilton comes in at #3 and O'Keefe at #5. Those are darn good scores.

The chart is below.

Economically Disadvantaged Comparison

Not to be a jerk about it but if you compare economically disadvantaged students across these same middle schools, you don't see James Wright as a stellar performer there either.

The overall scores are pretty abysmal across the board but if you compare these using statewide percentiles, you can get some idea of the quality of these schools with regard to educating the poor.

Spring Harbor does a pretty impressive job with low income students. Spring Harbor is a magnet school so I'm guessing it tends to draw the more education-oriented students of all types.

At 16th percentile statewide, Wright is no miracle cure at this point. Maybe the education money from the feds will help.

Latest Madison-area elementary stats for 2009

2009-10-21T14:06:00.008-06:00

I'm a bit late on the new data which arrived early this summer but here you can see some new charts for the 2009 (really the 2008 data released in 2009). Here you can see the local elementary schools and their rankings.

Looks like the top 10 remained mostly the same. Shorewood Elementary moved up, Van Hise moved down a little but not dramatically. Lowell inexplicably shot up from the 63rd percentile to the 98th percentile. And, yes, I double-checked and the data are accurate. Again 8 of the top 10 elementary schools are Madison Metro (MMSD) schools.

I would say though that all the schools falling into the 90th percentile state-wide are excellent though. Keep in mind that means those schools produce better students than 90% of the other schools in the state. That's pretty darn good.

MMSD has the dubious honor of having 9 of the 10 worst schools in the area though. And Allis coming in at the 5th percentile is tragically bad. I reiterate the fact that your school quality varies dramatically based on exactly where you live within a district.

School district performance over time

2009-03-30T10:42:00.003-06:00

If you were wondering how a few of the districts seem to be performing over time, it seems there is no discernable trend. The chart below shows 10th grade average scores for school districts and as you can see, they bump up, they bump down but there's no obvious trend other than perhaps a general narrowing of the gaps between them.

2008 High School Rankings

2009-03-20T08:57:00.003-06:00

You can basically just look at the chart below. West High is the perennial winner of this category though Memorial comes close.

I wouldn't say that the schools lower down are particularly terrible given that only 3 are below the 50th percentile statewide. However if given the choice, I would not have my kid attend Lafollette. Poor Fighting Bob - I don't think he would have approved of the abysmal state of that school.

Personally, I would like to see East HS move higher. I don't see any reason why it shouldn't be higher.

Middle Schools in 2008

2008-11-25T09:28:00.005-06:00

If you recall your middle school years, I think you know how critical that particular period is to your educational future. Well at least that's what I recall from the days of yore where your "track" was decided in middle school.

Even if that's no longer the case, in middle school you're forming your peer group that, most likely, you will be with through high school.

Long story short, Madison Metro has the best middle schools. As you can see in the table, the top 5 schools are MMSD.

If you look at the statewide data, you'll see that not only are Spring Harbor, O'Keeffe and Hamilton the top 3 in Madison, they are #3, #4 and #5 statewide. These public schools are bested only by the ALPs charter school in Oshkosh and Swallow Elementary in Hartland.

Not to deny Cherokee and Jefferson their due as #19 and #20 statewide of course.

Of course it's not all golden for the MMSD because the bottom 4 area schools are ALSO MMSD schools. In fact, Sherman is quite terrible sitting in the 10th percentile down there; 47th from the bottom statewide. About the only thing you can say is that it's better than some of the, no doubt, awful Milwaukee public schools.

I'm sure the MMSD digs into this all the time but I would really like to understand why theoretically similar demographics should result in wildly different scores. For example, the O'Keeffe and Sherman attendance areas are adjacent. Yet one is #4 statewide and the other #425 statewide.

Most of the schools appear to be fairly consistent year-to-year but it looks like Savanna Oaks in Verona dropped precipitously from #3 in the area to #12 in the area. I wonder why?

And despite the recent problems at Toki, it's doing a pretty good job still.

New data are here! New data are here!

2008-11-14T14:51:00.013-06:00

I'm reminded of the scene in The Jerk where Steve Martin gets overly excited about finding his name in the new phone book.

Apparently I'm just as much of a dork about new school performance data but only half as coked up...

So the new data was finally released and I processed it through my spreadsheet thingy. You can see the data for Madison area elementary schools below.

Somewhere in this blog you can find my methodology but basically the idea is to compare apples to apples. In school terms, based on the available data, that's comparing children of similar economic backgrounds. To that end, I have selected only data from students that are non-economically disadvantaged.

The score figure listed is the average percent of students scoring "advanced" across all WKCE tests (math, reading, social studies, science, etc.). My intention is to rank schools by a single figure.

The percentile figure listed is the percent of schools across all of Wisconsin that the listed school is better than. For example, Falk Elementary has a better score than 81% of all other Wisconsin schools. The color is just to give you a visual picture of those percentiles.

It comes as no surprise compared to my previous analyses that Madison Metro has the best and worst schools.

I was curious to see how individual schools go up and down quite dramatically. I had analyzed this before in a previous post and the variability seems to continue.

Again take note that of the top 10 schools on this list, 8 are Madison Metro schools. Surprisingly, Nichols Elementary in Monona is up there. Movin' on up, to the eastside...

It's fun to note that not only is Van Hise in the 100%-th percentile, it is actually the #1 elementary school in Wisconsin based on my calculations. Randall Elementary comes in at #3 statewide. 7 of the top 25 elementary schools in Wisconsin are MMSD schools!

On the other hand, there are some SORRY performances by MMSD schools. Lindbergh being the worst waaaay down in the 14-th percentile. I'm a supporter of schools but when what should be the same group of students performs at #1 in Wisconsin in one school and #663 in another, the heat needs to come down somewhere. Really, would you have us believe that the Lindbergh students are uniquely that terrible? Some of it may fall on the parents but a 50% difference on test scores cannot be attributed to them alone.

I reiterate my statement that educational quality comes down to tiny geographic areas served by individual schools. Perhaps it's socio-economic to a large degree given the wealth differences that are also geographically based but who really knows...

Size Doesn't Matter (in Madison)

2007-10-22T12:59:00.000-06:00

As a fan of smaller schools, much as it pains me to write, I find that with respect to student performance, the size of the school does not matter at all. At least in Madison.

After reading this article from the WSJ, I became curious about the expert's statement that "Research so far, Odden said, fails to show a clear link between achievement and school size, particularly within the range of sizes in Madison." Frankly, I didn't believe him.

So I dug into the data and, it turns out, given the limited amount of data I used, it seems there is absolutely not correlation between school (or in this case, class) size and test performance.

Now that is not to say small schools should be eliminated. There are other positive attributes of small schools that I have not measured here. I'm only looking at (as I've referred to many times) the average total percentage of non economically disadvantaged students who achieve in the "advanced" score category for the statewide tests.

First try - Positive Correlation

Here's my first analysis. You can see what looks like a mild correlation between 4th grade class enrollment and performance. That is, the larger the school, the better the performance. It's pretty zigzaggy and the R-squared value is .295 which isn't exactly highly correlated but it is somewhat correlated.

Then I began to think, hmm... the newer schools are bigger and they tend to be in more affluent areas hence we might be seeing simply a correlation to location rather than really to size. Hence my next analysis.

Right Try - No Correlation

What I figured is that the test scores had to be normalized somehow to the school itself. We can't compare a big new suburban Madison school to an old urban school, right? We really can only properly compare scores within a school to itself.

Fortunately class sizes change within schools. So what I did was normalize the test scores to the schools' average test score. So the graph below shows test scores as percentages above or below the individual school's average plotted against the 4th grade enrollment.

E.g. a point at a grade enrollment of 30 with a value of 120% indicates that for some school having an enrollment of 30, they had a test score that was 20% higher than their average test score.

You can see now that the correlation (via the R-squared) is exactly 0.0. There is no relationship between school size and test performance.

School District Shoot-out

2007-10-17T13:59:00.000-06:00

Oh alright, I shouldn't have entitled this a "shoot-out" I guess but that's what I'm calling an over time comparison of the local districts. The comparison shown below shows, for each district and year, the percentage of non-economically disadvantaged students across all grades and all tests scoring advanced.

Winners

I think the clear winners really are Madison, Middleton-Cross Plains, and Verona. I say that because their score lines sit above the rest in a sort of little group. They cross each other but not any of the lines below. And you can see how they're clustered at a high level in both 2006 and 2007.

Trends

One thing this graph shows is how districts are faring over time. 5 years isn't a long time but there seem to be a few trends (or non-trends as the case may be). I did a linear regression on the data points which may or may not be valid but it's better than eyeballing and actually contradicts eyeballing in several cases.

The district making the most progress with regard to increasing scores is Monona Grove. I think that's pretty evident in the chart. Of course starting low makes that easier, right?

The district making the worst progress is Evansville which is making a relatively steep descent. The only other districts heading down in scores are Oregon (very slight), Marhsall and Edgerton.

Sun Prairie is heading upward pretty well also. The rest of the districts are heading upward at a fairly slow pace and you can see that on the chart.

Test Quality

I'm sure the test creators analyze their test quality to no end but there doesn't appear to be a clear simultaneous bump up or bump down for any particular year. I would expect, if the tests were poorly designed, that one year might be easier than another and you'd see all districts going up and down simultaneously. Not so, apparently.

Madison Elementary Schools' Progress

2007-10-15T13:10:00.000-06:00

What's happening with Madison elementary schools over time?

Well, it's not that clear. The first graph below shows west-side elementary schools progress over time with respect to my measurements. It does sort of seem they are doing better. Generally speaking the lines trend upward especially in the 2007 data point. The way they all trend upward for 2007 makes me think there is something not comparable between the 2007 and 2006 tests.

The second graph shows east-side elementary schools. It's a lot more zig-zaggy than the west-side ones. Three, in particular, really shoot down for 2007: Sandburg, Mendota, and Glendale. I wonder why that is? Those are precipitous drops. Looks to me like you want your kids at Lowell or Marquette which really seem pretty good on this chart (and, of course according to the table in my previous post).

High Schools

2007-10-08T10:06:00.000-06:00

Put that in your Pipe and Smoke It

For those folks so enamored of the various suburban "great schools" you should make sure you look at the facts. Specifically, I'm pretty amazed at the relatively poor performance of Waunakee HS. It's down in the 66th percentile statewide. That's not terrible but it's not a super-dooper school either. Contrast it with West HS which is in the 99th percentile statewide and, in fact, the 4th best high school in Wisconsin (according to my analysis, etc, etc)

Anyway for the most part, the high schools do pretty well. I would say anything above 80th percentile statewide is pretty good. Who knew that Wisconsin Heights HS was so good? I don't even know where it is! It got on this list because the district was in the area. It probably helps that they only have something like 95 students in 10th grade.

Amazing Facts

So what's kind of interesting to me is the high performance of Sun Prairie High School compared with the middling (at best) performance of students in Sun Prairie middle schools. Their two middle schools I have data for were hanging around at about 60th percentile statewide for 8th grade tests.

Then BOOM! the students get smart 2 grades later and push their high school scores to 92nd percentile. Of course this is a snapshot so the student groups are different. So perhaps the bad 8th grade scores we see will translate to bad 10th grade scores in 2 years. Or perhaps Sun Prairie HS is really, really good at educating.

Dane County Middle Schools 2007 Rankings

2007-10-05T13:53:00.000-06:00

So you know when I say 2007 rankings, the test data is from 2006, right? Anyway again comparing only non-economically disadvantaged students, you can see 6 of the top 10 are Madison schools; both Verona schools are up in the top 10 as is Monona and Waunakee.

In general, I would say that the middle schools of the area seem to be doing pretty well. There are a couple duds way down at the bottom but you'll notice a lot fewer black circles than in my previous post on area elementary schools.

Of course I wouldn't say being in the 50th percentile statewide is any great accomplishment but, hey, at least it's not Whitehorse down in the 16th percentile there.

Something to take note of is that O'Keefe and Sherman have been merged. Some of Sherman's students are at O'Keefe and some at another school. I'm sure we can expect the excellent score of O'Keefe to descend precipitously as we average the 36.6 from Sherman with the 65.8 of O'Keefe to get, what, 51.2 dropping the best middle school down to 7th place or something.

You know the MMSD board really needs to be more aware of perception versus education. It is true that the goal is to educate all children highly. It is also true that that ain't gonna happen! One thing they can do something about is managing perceptions. Is it better to say, MMSD has the 6th best middle school in the state (non-poor, etc, etc) and a bad school? Or is it better to say MMSD has some above average middle schools? My thought is the prior. People demand excellence not above averageness.

Anyway again can anyone explain how Whitehorse can be so bad while O'Keefe can be so good?

Dane County Elementary Schools Re-ranked

2007-10-03T13:45:00.000-06:00

-The 2007 state testing data is out and I thought I'd take another look. Again I'm looking here at Dane County area schools only compared with each other and state-wide as well. The data you will see only includes non-poor students -- you can read more about why below.

Some Madison Elementary Schools are Tops

As you can see, Madison schools are simultaneously excellent and terrible. The top 8 are MMSD schools as are 6 of the bottom 10. Wow!

Not only does MMSD have top elementary schools in the area but the top 8 are above the 95% percentile statewide. That means those 8 schools are better (with respect to my measurements) than 95% of the other elementary schools in Wisconsin.

Furthermore, MMSD schools Lowell, Randall, and Van Hise are the #1, #2, and #3 elementary schools STATEWIDE. Yes you heard right. According to my ranking those are the 3 best elementary schools in the state for non-poor students.

Of the top 25 schools statewide, 7 are MMSD schools. No other area schools make the top 25.

You might consider moving to one of those attendance areas because these schools and the students in them are really, really good.

Other Madison Schools are the Pits

6 out of 10 of the worst area schools are also MMSD schools. WTF? These aren't poor kids scoring so badly either. I sliced and diced the data and couldn't find any demographic explanation for the bad scores. For those bad schools, no demographic group has a significantly higher score than the average shown (not white, asian, or black, kids, girls, boys, nothing). The only explanation can be that some of those schools are truly terrible.

How did I analyze the data?

The data are essentially the same as described in this post except for "Assumption 3". This time instead of selecting white student's data as a proxy for socio-economic class, I took a poster's advice and used data for students who are not "economically disadvantaged." You can read about what defines that here.

The reason I'm restricting to the non-poor is to compare apples-to-apples. Averages across all students don't really tell the story. It's sort of like saying that Medina, WA with a population of about 3,000 and the home of Bill Gates, has an average per-capita net worth of $19,000,000. That's sort of silly, right? Poor students are much more challenging to educate and thus skew averages for districts with no poor students higher.

So the short story can be seen in the table below. To explain the numbers, for example, Marquette Elementary in Madison had an average across all subject tests of 67.8% of its (non-poor) students test in the "Advanced" ranking. That 67.8% puts Marquette in the 98%-th percentile of elementary school state-wide. That is to say, Marquette has higher scores than 98% of all the other elementary schools in the state.

Where's my school?

You might notice your school not on this list. Waunakee, for example, does not report any data for poor versus non-poor students. Perhaps that's because no elementary school students qualify for free lunch? If you don't see your school on the list, they did not report the non-poor category of students.

Also, I've restricted my analysis to the following districts: Belleville, Cambridge, De Forest, Deerfield, Edgerton, Evansville, Madison, Marshall, McFarland, Middleton-Cross Plains, Monona Grove, Oregon, Stoughton, Sun Prarie, Verona, Waunakee, and Wisconsin Heights.

High Schools

2007-04-17T20:56:00.000-06:00

Madison has the same issues with high schools as with middle schools: the top 2 and #3 from the bottom. By the way Madison West is the #2 high school in the state out of 265 others. I suspect with the Madison high schools, you could average the feeder middle school scores and get a close relationship to the high school average. Clearly LaFollette is a problem.

The relatively dismal performance of Monona Grove HS is interesting – I would not have guessed that.

Middle Schools

2007-04-10T20:20:00.000-06:00

Same methodology; shorter list! Here you can see Madison schools simultaneously thrashing the competition but also being incredibly bad. This is why you can’t just say “Oh the average MMSD score is so low – it must be a terrible school district.” Looky – the top 5 schools are Madison middle schools. 6 of the 9 in the top 10% are Madison middle schools.

Hamilton Middle school is 6th from the top among the 320 or so middle schools statewide. Again that’s pretty darn good. On the other hand, if your kids go to Wright or Whitehorse, you probably want to move or request an intra-district transfer if you can.

Elementary Schools

2007-04-01T08:23:00.000-06:00

It was the best of times, it was the worst of times

As you can see in the table below, Madison has some kickin' schools and some really dismal ones.

Table of Results

Below is a table of the results I obtained by ranking area elementary schools by advanced scoring percentages.

As you can see the range is pretty broad from 33.2% to 75.4%. The top school, Randall Elementary, had an average of 75.4% of students scoring in the Advanced range across the 5 tests administered. This is an excellent score. This score puts Randall below only two other elementary schools statewide. Keep in mind, this is out of about 550 elementary schools I analyzed – that’s really, really good.

Statewide color ranking explanation

I’ve made a color-coded column in each chart that represents the performance of the school relative to the state-wide performance of schools in its category. By relative performance, I mean its percentile rank. Here’s the key:

To explain, notice the schools with the red marker at the bottom? Those 4 schools are in the bottom 50% percentile in the state. That means they are worse than half the schools in the state. See the top 12 on the list that have a blue marker? Those 12 schools are in the top 10% of schools in the state.

My take on this is that it’s pretty important where, exactly, you live and which elementary school you go to. Madison has the best elementary school and the 6th from the bottom. So you can’t just say “Yeah Madison schools are excellent.” You can, however, say my particular school is excellent. Notice that of the 12 in the top 10%, 8 are Madison schools.

I think it’s fair to say you shouldn’t get all pumped up about moving to, say, Mount Horeb because, relatively speaking, it’s got a pretty poor elementary school according to my calculations.

The Wisconsin state school data and how I used it

2007-03-30T17:21:00.001-06:00

The data I analyzed consisted of the state standardized tests given to students in grades 4, 8 and 10. This covers elementary, middle and high schools so we can get a decent idea of the relative quality of the various school levels.
The tests have several sections (e.g. reading, math, science, etc.) and they do not provide raw scores. Instead they provide the percentage of students scoring in one of 4 groups:

Minimal performance
Basic
Proficient
Advanced

So for one school and one test, you’ll get something like:

	Math
	Minimal performance	7%
	Basic	23%
	Proficient	40%
	Advanced	30%

Assumptions

In order to make any sense of this mass of data, I had to make a bunch of assumptions and selections of the data that I considered important to me and people like me (including my friends who had the original question).

Assumption 1: The percent of students scoring in the Advanced score range represents the quality of a school.

First, just like in Lake Wobegone, everyone assumes their kids are above average and I’m no exception. I assume that my kids have the ability to be in the Advanced score range. The more kids a school has in the Advanced score range, the more likely my kids will be able to be in that range.

Second, this seems like a reasonable proxy for educational quality. If one school has 5% of its students scoring in the Advanced range and another has 35% in the Advanced range, which one do you think is better?

Assumption 2: The average of percentages of students scoring in the Advanced range over all tests for a particular grade represents the overall quality of a school.

Since there are 4-7 tests taken, I had to combine them somehow into one number. I chose to average across all the tests at a particular school the percent of students scoring in the Advanced score range.

One problem is obviously that a school could have a fantastic Math score and a dismal English score resulting in a reasonably good average. A second problem is that a statistician might have a problem with this averaging strategy – comments welcome if you’re a stats whiz.

I think, however, this reasonably combines the scores to obtain a single number for one school.

Assumption 3: We’re all white. NOTE FOR THE 2007 and later data, I used non-economically disadvantaged students rather than white.

I only collected and compared scores of white/Caucasian students. I did this for two reasons.

First, I was specifically concerned with my kids’ opportunities not yours. If you’re non-white, I’m sorry, you can try to figure this out yourself for your own demographic and you probably should. If they had more specific demographics that relate to educational performance, I would have used that as well (e.g. parents educational level, etc.) but they only provide race and gender. My reasoning is that if a school is good for my kids’ particular demographic then it’s good for their education.

My guess is that in this data set, race is actually a proxy for economic class which, I think, is probably a better predictor for academic achievement. So my guess is that these results apply to all races having a similar economic status to the average white Madisonian.

Second, I had a feeling that the well-known and unfortunate “achievement gap” between whites and minorities causes the statistics to be not comparable between schools with varying minority populations.

Clearly the achievement gap is a problem in schools with significant minority populations and needs to be addressed. I’m just not analyzing or addressing it here.

Introduction to my Comparison of Madison Area Schools

2007-03-30T17:06:00.000-06:00

What is this blog?

This blog will contain my personal analysis of Dane County schools primarily based on the state testing data. The posts are really intended to be read sequentially, more or less. So far it's not really a stream-of-consciousness like a normal blog; rather it's more of a straightforward analysis.

Why bother with this?

Our friends recently mentioned that they were concerned with the Madison schools among other things and were thinking about moving to a small town like Lodi. Other people we know are putting their kids in private school. I thought that Madison schools might not be in the dismal situation that seems to be the conventional wisdom today but I couldn't say for sure.

I stumbled upon the State of Wisconsin web site that provides test scores for various grades for every school in Wisconsin and decided to conduct an analysis to see what I could discover about the various schools in the area. Should we move? Should they move? Should you be concerned about the schools? I attempt to answer these questions given numerous assumptions.

Summary of Results

Madison has the best schools in Dane county and among the best in all of Wisconsin.

But, and it’s a big BUT, you have to make sure you’re in the right one. Choose poorly and you get a relatively bad school.

Verona and Middleton also seem to have good schools comparable to the Madison ones. You still need to choose the best one by location but you won’t end up with bad one anywhere in either Verona or Middleton.
The trend in Madison’s elementary school test scores seems to be heading toward the middle rather maintaining high scores and increasing low ones.

Some area schools are relatively bad. Does that mean your kid won’t get a decent education there? No. What does it mean? I think it means that your kid will more likely have average scores than high scores. If you think your kid is going to be a hard-working average student, then it probably doesn’t matter where your child goes is my guess.