This week we focused on getting together our deliverables and putting the finishing touches on everything we committed to deliver. This ended up being a lot of data analysis and thinking about good ways to represent data. We also continued the development of our branding and began compiling our ArcGIS Map.
ArcGIS Map: Katie met with David in the GIS lab on Friday to finalize data sources for the map. We will be using shapefiles from the SF Find maps to denote neighborhoods in our map. All the data from the surveys regarding geographical information is extracted and we are in the process of transferring that data to our GIS map. The layer of the map Katie is currently working on includes over 400 start and end points of the members' commutes to track which neighborhoods are most popular for bikers. The next layer which will be completed by Monday will include special routes.
Survey Response Category (Qualitative) Analysis and Branding: One of the big goals this week was to analyze the write-in responses that we received from the survey we sent out to SFBC’s female members. The replies were in response to the question “Do you have any other comments on biking in SF or ideas to encourage women ridership in SF?”
We received a variety of responses that varied significantly in subject matter. To better analyze the responses in order to extract valuable information from them, we did an initial read-through of the responses and came up with 8 categories of comments/ideas that arose frequently. After discussing the categories with Janice, we narrowed them down to the following six:
1) SAFETY: Infrastructure such as separated bike lanes and other measures to protect cyclists from automobiles.
2) BEHAVIOR: Tools to increase confidence and skills on the road, including workshops and classes.
3) COMMUNITY BUILDING: Facilitating friendships and support networks between female cyclists by making sure the existing bike community is more inclusive as well as also finding women-only spaces.
4) BUILDING BIKING INTO DAILY ROUTINE: This includes things like aesthetic/hygiene concerns and bike storage options/theft avoidance.
5) BIKE CLOTHING/GEAR
6) BIKE AND GEAR PURCHASING: In addition to help with buying bicycles, this includes things like helping women find friendly and helpful bike maintenance options.
We are now in the process of taking a tally of the number of times each of the following categories come up, and will soon be better able to rank each of them by the number of times the survey responders brought them up.
We also continued to develop our logo this week, receiving feedback from some additional members of the SFBC. We will contact a graphic designer this week and finalize the logo. We also drafted our mission statement this week, incorporating information from our discussion with Janice and from the focus groups, and we will continue to refine it and the other branding materials over the next few days.
Quantitative Data Analysis: This week we finished processing the data from our surveys. The process of converting the information from our survey responses (about 400 replies!) into usable data was challenging. The biggest challenge was figuring out an appropriate way to represent qualitative responses such as: “not sure” or “somewhat encourages” into numbers that we could use to make graphs. We chose to focus this part of our data analysis on the set of questions that asked responders to rate potential ways to improve women ridership (social gatherings, guest speakers, skill-sharing workshops, regular bike rides, online discussion forum, and bike education). For these responses we paired each of the 4 possible responses with a number that illustrated something about how positively or negatively a responder endorsed an answer. For example we paired “doesn't encourage” with a numeric value of -1. We then used these numeric responses in order to graphically represent how our survey participants felt about specific ideas.
Looking towards next week
Final Presentation: The final presentation is less than a week away and we are very excited to show our community partners and peers what we have accomplished this quarter.
Report: Our report which is a portion of our final deliverable will include all our survey data analysis, GIS map and findings, and final branding. Our aim is that the SFBC will use our recommendations and findings to further support their campaign and find our work useful in producing more components of a toolkit and resource guide.
Website: The website is coming along and will hopefully be done not long after our final presentation.