by Matt Rosenberg February 25th, 2013
Using the Google Public Data Explorer tool, we run two visualizations from recently-released 2012 data on percent of eighth graders meeting the Washington state achievement test passing standard in math, and reading, at 26 selected urban-region districts. In each case, half the districts exceed statewide average performance and half don’t. See custom charts, below. Top performers on the eighth-grade state math achievement test – among districts we examined – were Bellevue, Lake Washington, Port Angeles, Everett, and Olympia. The lowest performers for the same measure in 2012 were the East Valley district near Yakima, plus Yakima, Tacoma, Pasco and Longview. State academic achievement tests data for 2012 have recently been added to the user-friendly, interactive Washington Achievement Data Explorer (WADE) database operated by the Center for Education Data and Research (CEDR) at the University of Washington in Bothell. WADE is integrated with and can be explored using tools from Google Public Data Explorer.
At the WADE site, users can select school districts to compare for achievement test outcomes by grade and subject. Demographic data for each district, which is often correlated with outcomes, is also available. The data come from the Washington State Office of the Superintendent of Public Instruction. Among other features, Google Public Data Explorer provides customized HTML embed code for each data set that is constructed by users. Following are two charts developed by Public Data Ferret using the WADE site.
First are eighth-grade “meeting the math standard” rates for the 26 selected urban-region school districts in Washington state, from 2006 through 2012. They are ranked on the right by 2012 outcomes, but by hovering over any district’s name, its seven-year history for the metric chosen can be tracked.
Next, for the same 26 districts, are the 2012 rankings and seven-year histories of percent of eighth graders meeting the state standard on the reading achievement test.
By clicking on “Explore The Data” in the lower right-hand corner of either of the above charts, you can enter the WADE interface at Google Public Data Explorer and devise a customized report from the state data, choosing different measures and districts. You can also enter the WADE interface, with a tutorial through the the UW-Bothell/CEDR gateway.