Registration 2013

A visitor to this blogged asked about the 2012 school assignment data, so I cleaned it up and got most of it working. I also responded to someone on Chambanamoms.com who just asked about registration. To top it off, Unit 4 put out there annual schedule of Choice Community Forums:

  • Thursday, January 24, 2013 6:00 p.m. Stratton Elementary – 902 N. Randolph Street – Champaign
  • Tuesday, February 5, 2013 6:00 p.m. Carrie Busey Elementary – 304 Prairie Rose Lane – Savoy
  • Tuesday, February 19, 2013 6:00 p.m. Temple Baptist Church – 1100 Broadmoor Drive – Champaign

Here are the visualizations I did of the “overchosen” schools, or basically, which schools folks selected for which choices (you get a grand total of 5 choices):
overchosen_visualization_2011

overchosen_visualization_2012_adjustedoverchosen_visualization_2012

The one the left is from 2011, the one in the center is 2012. A quick glance shows a very common trend (which has persisted for the past 4 years that I have been collecting data), with a very minor “flattening” effect in 2012 (just slightly more diversification). One interesting thing that popped up in 2012 is that Carrie Busey jumped up two spots while Barkstall dropped 3. I also added an “adjusted” graph to the right which shows how the magnet registration (done in February, prior to the March 2012 registration) affected the popularity of the schools. As you can see, the magnet registration pretty much filled up each of the three magnet schools (Garden Hills, Stratton and BTW aka Washington).

On November 7th (and December 7th and January 4th) I followed up with the district administration and the Board about Dr. Susan Zola’s proposed Choice recommendations. I am still waiting to hear back. I reiterated the need to go back to the four local software companies I identified last year in an effort to completely rework the Choice RFP. While this is a big deal to me, I am wondering if anyone else even cares. 🙂

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:

http://lottery.cb-pta.com/test/visualize.php?year=2012

 

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.

2012-2013 Kindergarten Lottery data released

I have finally received the Kindergarten Lottery data:

https://thecitizen4blog.files.wordpress.com/2012/05/champaign-k-cc-ses-lottery-2012-13_cleaned.xlsx

I have not yet added this to my online database, but will do so later today. I was a tad disappointed that my request to standardize the data was not satisfied – my hope is that we will stop using Alves and thus the standarization temporarily becomes a moot issue. I need to follow up with Dr. Wiegand about that.

So all you number crunchers – go have fun. I have also heard a rumor (via a poster on chambanamoms.com) that someone else is creating databases and charts from U4 data. Let me know if you are that person, because I would like to collaborate a little.

Registration/School Assignment: getting technical again

This post is going to be a little technical. You have been warned. 🙂

 

So I have an online database; I am not aware of anyone who has written any queries against it other than myself (have not yet built the functionality to save and archive input queries). My overall goal is to 1) move responsibility for the “computer program” and relevant data away from Massachusetts and into Champaign, and 2) create a catalyst that results in provoking Unit 4 to be much more transparent about this whole process than they are now. That word “transparent” means different things to different people, so here is where I am coming from – basically, put as much information online as possible. Let people see what is happening. Sure, ok, remove names and addresses, I am cool with that.

 

In order for that to happen, Read the rest of this entry »

Reflection on the Jan 26 School Assignment Community Forum

Here is a letter I sent to various Unit 4 Administrators and a Board Member:

Good evening, ladies and gentlemen,

The video is a huge hit! It is such a huge improvement over the previous forms of communicating information. It is exciting to see Unit 4 and the FIC moving in this direction.

While several of us were talking after the presentation, several things came up – specifically about getting information online and maybe even making a couple posters:

  1. put edulog online
  2. while #1 is being talked about, I have a google maps + javascript solution that gets pretty darn close
  3. Show people a map with the school district boundaries and the location of each school. Maybe a 4′ x 3′ posterboard and people can insert pushpins (I have done this elsewhere with great success).

Jamar, Orlando and Judy asked for the URLs for my projects. Feel free to share these Read the rest of this entry »

Overchosen Schools: interactive, database-driven chart

This is still in BETA, but I wanted to get something out there for folks that were hungry for information.

The following URL goes to a website I set up and maintain. It runs php on the server and javascript on your computer (thus you need to enable javascript to see anything). Right now, you can go against two years, 2011 and 2010:

http://lottery.cb-pta.com/test/visualize.php?year=2011

http://lottery.cb-pta.com/test/visualize.php?year=2010

You can try other years, but it will not be pretty. 🙂

This is live data I have received from FOIA requests with Unit 4 – when I get 2012 data, I’ll add that to the database and we can all have fun with it.

PS – If anyone knows how the heck CSS transform-origin really works, please let me know – it is a pain in the arse.

PS2 – my apologies to Microsoft Internet Explorer Users. Please upgrade to a better browser. 🙂

The Kindergarten Lottery public database will be offline for a while

Gordy, who so graciously hosted my stuff on sacrophyte.com, is moving to a new server. The new hosting company (BlueHost) is a bit more strict in who gets to manage subdomains, so we mutually agreed that it would be good for me to move my stuff elsewhere. I have taken backups and I hope to resurrect sacrophyte.com somewhere. Some time. But the immediate future is unknown. I might hit up the IMC for this.

Not that anyone really cares…..   🙂