Category: 8 Demo in Progress

DataViz Progress Report

Posted on Author Stefania Ruibal

Diverging Map Age 5-17  

Google Fusion Table

My partners goal for this project is to create an interactive data visualization representing Girl Scout partner potential by comparing current participation to current census data. By using a diverging map the Girl Scouts are able to see where they are reaching more participants than expected and where they are  not reaching enough. This map contains all age data from 5-17 years old broken down into three age groups based off of census data. The maps are using percentage of possible partners to create a diverging map using standard deviation to determine what is above average membership and what is below average membership.

Tasks completed:

  • Organized Girl Scout data into pivot table representing all age levels
  • Combined Girl Scout data with population data
  • Calculated potential partner percentage
  • Used standard deviation to combine data for Google fusion diverging map
  • Created diverging map with all data on one spread sheet
  • Created google fusion template

Things to do:

  • Work with Google fusion template to combine 5 maps
  • Work on issue of only having 3 age levels because of census data
  • Add points containing locations of Girl Scouts meeting places
  • Finalize design of map
  • Work on color scheme for maps to have them match girl scout colors
  • Add a key telling you what each color is representing
  • Use template to edit view window (show actual percentages, decide what should be seen in each window)
  • Tweak template to what partner wants

 

 

 

 

Binh’s demo-in-progress

Posted on Author Binh Vo

Repository
Do minorities have a higher bond? (1998-2014)

Repository
Arrest rate per capita (1998-2014)

For this project, my partner would like to create various data visualization based on the bond data in Connecticut. He wants to see how race plays a factor or how many bonds are there for each town in Connecticut. There are many different data visualization you can create with many different variable.

*Updated both leaflet and chart

Steps I’ve completed:
Using a pivot table to arrange my data
Using a leaflet as a data visualization
Using a highChart as a data visualization
Added markers
Adjusted arrest rate per capita

Steps to be done:
Use different ranges of color based on the density
Create more Visualizations with different templates
Manipulate other variables
In progress of making a linkchart

Demo in Progress

Posted on Author Norah Do

Link to project (still in progress): http://ngocdo67.github.io/cwp-map/

My partner’s goal for this project is to create an interactive map of the region, which consists of 37 towns and cities in Connecticut. The map would have five tabs regarding the following information: number of people served, median age, median household income, poverty, and unemployment rate. For each tab, when the users hover the mouse over each town, they would see the key data points in the information window. On the other hand, when they click on each town, the link that leads to the PDF file containing that town’s profile would pop up. The first tab, which shows the number people served, would be the default tab that appears on the organization’s website. This would be the only tab in which all the towns are colored yellow. In the other four tabs, the colors for the towns would be different shades of yellow  from light to dark depending on the data of that town. Furthermore, the project should be sustainable, which means that the data should be easy to update and there should be detailed instructions on how to do so.

Steps I have completed:

  • Discussed with my community partner to present the available options and understand their preference
  • Created multi-tabbed Leaflet map of the region
  • Created the map so that users can hover and click on the towns for information
  • Created the data file for the first four tabs
  • Tried different fill colors for the map

Steps to be done:

  • Insert the data of the fifth tab into the map once I receive the data
  • Decide on the appropriate fill color for the map
  • Calculate the break between ranges of colors for the multi-colored maps
  • Minor changes in the information window and reference at the bottom of the map
  • Write a detailed instructions on how to update the data
  • Create a legend for the map