Category: 4 Google Fusion Tables
Experimenting with Google Fusion Tables
The data visualization below incorporates two sets of data: the geographical location of the schools operated by the Hartford Public School system and the achievement characteristics of each school, that is the percentage of students who met the proficient level on state tests in each school. As the legend suggests, red schools are the worst performing while green schools are the highest performing. The schools are divided based on data from 2013, but by clicking on the school, the viewer can observe the percentage of students at proficient from 2007-2013. This map easily lets viewers identify the locations of high performing schools and if participating in the Open Choice program, parents can gauge the distance from their home to their preferred school choice. Of course, this use will further be enhanced once I am able to include a searchable feature, which I provided a link for in my last post.
However, data can be misleading, and as Jack commented in my previous post, achievement data is not directly linked to the students which reside in that area because of the Open Choice program, which allows students to apply to attend any one of the HPS-run schools. Furthermore, the map does not fully highlight the progress from 2007-2013, and so one could assume that low-performing schools have always been low-performing schools, without clicking on each data point. For example, in 2007 36.4% of students at ML King met proficient. The school has steadily improved, and in 2013 57.2% of students met proficient. If this progress was more easily visible, a viewer might conclude that ML King has found a successful method to improve achievement, and further improvement is likely. To highlight progress, an interactive chart might best complement the map, or even a time slide feature in which viewers can select the year, and the achievement data will adjust accordingly.
This second map is very similar to the one above, but shows CAPT scores, which is the state test taken by students in Grade 10. As a result, the markers only represent high schools.
Assignment 4
The polygon map above shows Connecticut Unified School Districts organized by median household income. The visualization is interactive as clicking on one of the separated locations allows the user to see the name of the district, the percent of 8th graders who passed the Connecticut Mastery Test on average, and the exact median household income. This graph would be very useful for both of my Data Visualization partners as it shows the relationship between geography and household income in this specified area of Connecticut, and since my first data visualization establishes a correlation between median household income and test scores, this can be used as a point of comparison as well. For this specific project, I believe all my desired features were available. My first visualization is below.
IPC Google Fusion
For IPC, there are many types of charts and maps that are useful in displaying data. So far I have been moving along with organizing my data. In this map, it shows the number of patients in each residential city/town in 2007. As I progress with the data, I hope to add more information, such as frequency of injury in each city.