Making the kindergarten lottery data look pretty

Or in other words, “visualization”


I have put together two different sets of interactive charts (using two different software vendors) to put a fresh spin on the “Schools of Choice” data. Please note, I do not yet have the 2013 data; these charts are for previous years. I am merely preparing to make some pretty pictures when I finally get the 2013 data. 🙂


via Highcharts

via Highcharts


Via Google MotionChart











PS – the one to the right has a cool “time-lapse” feature; look for the “play” button.

Overchosen Schools Chart is back: new data for 2012

It took a bit of work, but for those that like to go look at pictures and mouse-over a semi-interactive chart right away:


If you want previous years:


[just change the last number]


Some Notes:

  1. I have not yet got the “Maxiumum Occupancy” data to show up – it is in the javascript, but I believe Highcharts slightly modified a loophole I was hacking
  2. Alves delivered some messy data again. The most notable to you is that the names of the schools are all abbreviated
  3. Oh, you might also notice that the numbers seem a little low, especially for the magnet schools. I have to tweak the code a bit more to account for magnet selections, since they are reported in a funny way.

What exactly is an "overchosen" school?

They say a picture is worth a thousand words – here is some eye-candy:

I wish I could embed it here in WordPress, but I have not figured out how to do that (yet). This is just a taste of what I am doing with Kindergarten Lottery data I have received via FOIA from the school district. Personally, I think this graphically (and dramatically) demonstrates how some schools are “overchosen”. The charts are somewhat interactive so please mouse-over to see more information.

Please keep in mind this is merely an appetizer; I intend to have real charts driven from real data in the very near future.

PS – if you try to explore this website a bit, please keep in mind that I recently changed hosts and am in the midst of updating from the old, text- and tech-heavy format to the newer, lighter format. But, hey, I’ll entertain questions about the old stuff as well. 🙂

Better data browsing (better presentation of Lottery data)

This will be quick – working on a new prototype for the kindergarten lottery. This is merely a prototype, but I would like to collect comments from you all: