Monday, March 28, 2011

Show Me the Data: Chicago, Miami-Dade, and New York City Show Their Data


by Joseph Hawkins

If you go to the Montgomery County Public Schools (MCPS) public website and attempt to find Excel files—real data which can be “played” with—you will find nothing. All you will find are Portable Document Format files, commonly referred to as PDFs or Adobe files.

I have always advocated for access to real data. Why not? If taxpayers are supporting a data-driven school district—and this concept comes out of MCPS Superintendent Jerry Weast’s mouth every 10 seconds—then surely we cannot be afraid of sharing data. Shouldn’t a useful document such as Schools at a Glance exists as an Excel file?  Click here to see Schools at a Glance:


But instead of focusing on why MCPS always says no to public requests for real data or informs the requester that it will cost a zillion dollars to create data, let’s visit three large public school districts’ public websites and see what real data they offer up to the public.

The Chicago Public Schools provides users with a rich variety of downloadable Excel files. My two favorite files—the Advanced Placement (AP) results file which provides rich details for all city high schools (including race/ethnicity information) and the National Student Clearinghouse results file. Isn’t Superintendent Weast out and about bragging on the MCPS Clearinghouse data? Why not share? Click here to see why Chicago is my kind of data town:


For each school in its system, the Miami-Dade County Public Schools provide in downloadable Excel files basic enrollment data, attendance and mobility rates, and graduation and dropout rates. Most of this information is the data found in the MCPS Schools at a Glance document. Miami-Dade also provides an Excel for on performance measures from 2003 through 2010. Click here to see what Miami provides:


The New York City Public Schools are not as data friendly as Chicago or Miami, but they provide access to some Excel files. If nothing else, they underscore the possibilities and the spirit behind being data friendly.  Click here to see what New York City provides:


When it comes to real data, PDFs are never the starting point but rather an end point. Data people know this!

A document like the MCPS Schools at a Glance clearly resides first as data, either as one huge Excel file or multiple Excel files or in some database that can create and export data formatted as Excel files. Regardless, the data in those files can be manipulated and “played” with—one is not able to play with information in PDFs without a lot of labor devoted to reformatting and reentering information.

It seems to me that MCPS could place on its public website Schools at a Glance—as well as other data files (e.g., AP results, National Student Clearinghouse results)—in file formats that are data-friendly. And when that happens, I promise I’ll stop asking Show me your data!

2 comments:

  1. Very, very true indeed! We should ask the Office of Shared Accountability for a data feed of some sort. I will try to do that tonight.

    ReplyDelete
  2. I've also been frustrated by this. So, I've started to convert the files myself. You can see the first few on my website. If you download them, let me know if they are useful, or if there are other data that would be more useful.

    http://kickenson.info/Kickenson.info/MCPS-Data.html

    ReplyDelete

If your comment does not appear in 24 hours, please send your comment directly to our e-mail address:
parentscoalitionmc AT outlook.com