Collaboration in Civic Spheres

Archive for the ‘Education’ Category

Data viz: Seattle public schools “pass rates” on state tests

by Mike Klaczynski May 15th, 2013

To graduate from a public high school in Washington, students in the classes of 2013 and 2014 must pass the state’s High School Proficiency Exam (HSPE) in reading and writing and an End-Of-Course (EOC) test in either algebra or geometry. Starting in 2015 those requirements will grow to include EOCs in algebra and geometry, and biology. State assessment tests called the Measurement of Student Progress (MSP) are also given in grades three through eight to help students, parents, teachers and administrators assess academic progress and adjust teaching methods and curriculum as deemed necessary. For non-special education students, passing the regular tests requires a grade of Level 3 (proficient) or Level 4 (advanced). Using Washington state data on achievement tests taken and passed in math and reading in different Seattle public schools across different grade levels, we developed the following interactive data visualization. Explore it to see how neighborhood public schools rate, compared to others in the district.

USER INSTRUCTIONS
1) Make your selections. Under “choose grade,” use the pull-down menu to select a type of school (elementary, K-8, middle, high). Using the “compare schools” tool select one school, or all schools within that category, or a custom combination of schools. Under “choose a test,” select either math or reading.

2) Explore the data. Here’s an example. By choosing all elementary schools and state reading test pass rates, you can: a) get a quick comparative overview via a mouse-over of any school’s dot on the map. You’ll see a pop-up box summary for each dot over which you hover, with a combined multi-year pass rate in the chosen subject, and relative ranking versus peer schools within the district; b) drill in to a school’s data by clicking on its map dot. Then you will have two more views of the data – above to the left (percent low-income and not, plus total number of tests taken); and below (yearly results by grade, subject and income group, versus district averages).

Additional technical notes:

  • Aggregate pass rates for schools were calculated by the author using number of tests passed versus number taken, from the state’s data because the state’s own pass rates for some schools in some subjects did not match the data.
  • Pass rate data for some schools in some years are not available because it was not included in the state’s datasets.
  • “Low-income” students are currently defined by the state as those eligible for free or reduced-price school meals.
  • The state high school math assessment test was not offered in the 2010-2011 and 2011-2012 school years because it was being redesigned.
  • In 2008 and prior, the equivalent of the MSP, HSPE and EOC tests was called the Washington Assessment of Student Learning, or WASL.
  • RELATED: FAQs on state testing from Washington Office of Superintendent of Public Instruction; additional information on who must take what when, and alternative tests.


    Public Data Ferret is a news knowledge base program of the 501c3 public charity, Public Eye Northwest. Ferret In The News. Donate; subscribe (free)/volunteer.

    Seattle Central’s Tougher “Occupy” Code Advances

    by Matt Rosenberg March 20th, 2013

    Under proposed new state regulations all-night vigils by off-campus groups would be allowed outside of Seattle Central Community College, but a no-camping proviso already enacted would stay in place and a series of other guidelines would be enacted around the exercise there of First Amendment-protected free speech rights. Non-college protest groups such as “Occupy Seattle” – whose wild and wooly days-long encampment on the college’s grounds in fall 2011 sparked conflict with the college and neighbors while inspiring declarations of support from faculty and students – would be subject to a registration clause. They’d have to comply with provisions to limit noise; clean-up; pay costs for any litter left and damages caused; and refrain from blocking students and faculty from using college facilities. There’s also a long list of what constitutes prohibited “camping,” as well as a ban on leaflets with obscene language or incitements to violence, and a strong suggestion such flyers include author or group contact information, to encourage accountability.

    Thurston County eighth-graders middling on state tests

    by Matt Rosenberg March 14th, 2013

    In 2012, pass rates on the eighth-grade state achievement test exceeded the state average of 56.6 in four of nine Thurston County School Districts, and were lower in the other five. The best pass rate on that test among the county’s districts was in Olympia, where 66.9 percent of eighth-graders met the state performance standard in math. Three of the five districts which underperformed the state average on this metric had markedly low pass rates. They were Yelm, 39.2 percent; Tenino, 39.4; and Centralia, 43.8 percent. The Centralia, Yelm and Rochester districts include parts of neighboring counties.

    The data come from the Washington Office of the Superintendent of Public Instruction and are viewable through customized visualizations users can create with the Washington Achievement Data Explorer (WADE) developed by the Center for Education Data and Research at the University of Washington-Bothell. The first visualization below portrays the eighth grade state math test pass rates for Thurston County districts versus the state average. They are ranked on the right by 2012 outcomes, but by hovering over any district’s name, the seven-year history for the chosen metric can be tracked.

    On the eighth grade state reading achievement test, five of nine Thurston school districts outperformed the state average in 2012 and four underperformed it.

    Public Data Ferret’s Education archive

    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, grades and districts. Demographic data for each district or school, which is often correlated with outcomes, is also available. Among other features, Google Public Data Explorer provides customized HTML embed code for each data set that is constructed by users. This can be used to easily create charts like those displayed here, for Web sites or blogs. You can also enter the WADE interface, with a tutorial, through the the UW-Bothell/CEDR gateway.

    Some previous reports we’ve generated here recently have compared statewide eighth-grade pass rates on the state math and reading tests with results from among major urban region school districts in Washington; and between districts in Pierce, in Snohomish and in King counties. We also examined trends in statewide average pass rates in math and reading for all K-12 grades which take the tests.

    Editor’s Note: some of the general explanatory verbiage in this article was borrowed from our own above-linked articles.


    Public Data Ferret is a news knowledge base program of the 501c3 public charity, Public Eye Northwest. Ferret In The News. Donate; subscribe (free)/volunteer.

    WA achievement test pass rates mostly stagnant since 2006

    by Matt Rosenberg March 11th, 2013


    Recently updated state data packaged into customizable visualizations through the University of Washington-Bothell’s Center For Education Data and Research and its Washington Achievement Data Explorer (WADE) tool show that for third, fourth, fifth, eighth and tenth-graders in Washington, average statewide pass rates on state achievement tests in math and reading have been either relatively flat or down between 2006 and 2012. Pass rates on the state tests have grown for sixth and seventh-graders. A series of visualizations follow; as we mine the OSPI/WADE data on statewide pass rate progress for all grades taking the tests. By clicking on “Explore Data” in any of the visualizations, users can enter WADE’s Google Public Data Explorer interface and add in other school districts to compare results to the statewide data.

    Some previous reports we’ve generated here recently have compared statewide eighth-grade pass rates on the state math and reading tests with results from among major urban region school districts statewide; and from districts in Pierce, Snohomish and King counties. Now we’ll dive in to the state average pass rate results by grade – and progress, if any – from 2006 through 2012. Hover over the graph line for exact rates by year.

    Most Snohomish Districts Lag On State Reading Tests In 8th

    by Matt Rosenberg March 7th, 2013

    Of 13 Snohomish County school districts reporting results, eighth-graders in eight of them in 2012 lagged the state average in percent who could pass the state achievement test in reading. In math, seven of the 13 districts fell below the state average in percent of eighth-graders who could pass the state achievement test. Snohomish districts outperforming the state average in eighth-grade pass rates for both math and reading in 2012 were Northshore, Everett, Arlington and Mukilteo. Districts underperforming the state on both eighth-grade measures last year were Monroe, Marysville, Edmonds, Stanwood, Darrington and Lakewood. Three other districts exceed the state average in eighth-grade acievement test pass rates for one subject but not both: Granite Falls, Lake Stevens and Snohomish. Two related data visualizations follow, below.

    Troubles for most Pierce County school districts in 8th grade

    by Matt Rosenberg March 3rd, 2013

    By a rate of more than two-to-one, public school districts in Pierce County last year underperformed the statewide average for percentage of eighth-graders who could pass Washington’s math achievement test. A majority of districts also lagged the statewide average in percent of eighth-graders who passed Washington’s reading achievement test. Using the Google Public Data Explorer tool and an interface developed by the Center for Education Research and Data of the University of Washington-Bothell, we run two related visualizations incorporating recently-released 2012 data and corollary outcomes dating back to 2006, in math and reading for all 17 Pierce County school districts.

    Explore latest K-12 achievement data with UW tool

    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.

    Public Data Ferret’s Education archive

    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.


    Public Data Ferret is a news knowledge base program of the 501c3 public charity, Public Eye Northwest. Ferret In The News. Donate; subscribe (free)/volunteer.



    House bill would ease high school graduation requirements

    by Matt Rosenberg January 31st, 2013

    The Washington State House Education Committee this week took initial testimony on a bill that would lighten the state academic assessment testing load for students, and ease related high school graduation requirements. Since 2008, to graduate from a public high school Washington state students have had to pass High School Proficiency Exams, or HSPEs, in reading and writing, with a math End-of-Course (EOC) state assessment to be added to the mix for 2013. By 2015, under current state law, they will also have to pass a second state math EOC each year and a biology EOC to qualify for graduation. But the sponsor of House Bill 1015, Rep. John McCoy, (D-38), and array of educators who testified in support of it this week, believe all this gobbles up too much time and money, provokes too much anxiety for students, and accomplishes little else.