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