Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 2
Out of the Spreadsheet & into the Community Rahul Bhargava, - - PowerPoint PPT Presentation
Out of the Spreadsheet & into the Community Rahul Bhargava, - - PowerPoint PPT Presentation
Out of the Spreadsheet & into the Community Rahul Bhargava, rahulb@mit.edu, @rahulbot Out of the Spreadsheet & into Rahul Bhargava 2 the Community MIT Center for Civic Media TICTec 2016 rahulb@mit.ed Motivations Out of the
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 3
Motivations
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 4
Measuring Impact
your project
+ =
measurement data
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 5
Measuring Impact Together
your project
+ =
measurement data definition collection analysis presentation Opportunities for participation!
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 6
Going from Data to Story Together
Asking Questions Finding the Data Finding a Story Telling Your Story Trying it Out
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 7
Going from Data to Story Together: Example #1
Asking Questions Finding the Data Finding a Story Telling Your Story Trying it Out
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 8
Asking Questions Together is Hard
All the trees in Somerville, MA, USA Data from the city of Somerville Scraped by Rahul Bhargava Presented via Microsoft Excel
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 9
Asking Questions Together with WTFcsv
Presented via wtfcsv.databasic.io
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 10
Going from Data to Story Together: Example #2
Asking Questions Finding the Data Finding a Story Telling Your Story Trying it Out
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 11
Telling Your Story Together: Data Murals
Created by youth from Groundwork Somerville, facilitated by Emily and Rahul Bhargava
“The numbers tell a story” “Someone cared enough to do [the mural], and it benefits everyone” “I’ve never made [an infographic], now I totally feel like I could. I’m inspired.”
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 12
The Data Mural Process
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 13
Make This Whole Process Participatory
Asking Questions Finding the Data Finding a Story Telling Your Story Trying it Out
- Brainstorming questions to ask
- Looking for stories in data
- Making a data storybook
- Building data sculptures
- Practice convincing diverse audiences
- And more…
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 14
Impact Data is an Opportunity
Out of the Spreadsheet & into the Community TICTec 2016 Rahul Bhargava MIT Center for Civic Media rahulb@mit.ed 15
Next Steps
- Checkout datatherapy.org for more ideas
- Contact me: rahulb@mit.edu, @rahulbot