This activity will take 30 to 45 minutes. You should have these materials on hand:
- A basic Internet connection
- A phone, tablet, or computer for each small group of 3 people
- 1 printed copy of the WTFcsv handout per group
- Paper & pens
- Planning to show the videos offline? Click here to download them in advance.
Kick-Off The Activity
Increasingly, data arrives on our doorstep in the form of a spreadsheet. Somebody sends you an excel file or you download something from the web. In this activity, you will work with colleagues to ask good questions of a spreadsheet so that you can take it from data points to data story. You will use Databasic.io's WTFcsv tool, get acquainted data types, and do some basic spreadsheet analysis. 'csv' stands for comma separated values, a common spreadsheet format on the web. WTF stands for... well... the question you ask when someone sends you an inscrutable csv file.
In this activity participants will brainstorm questions to ask sample datasets based on summaries of the columnar data. Work in groups of 2-3 colleagues for about 10 minutes with the data. At the end give them a minute to pick the best question and write it down on the handout, indicating the question, any other data they might need to answer it, and how they would get that data. Start the activity by playing the kickoff video below for your group, which explains all this.
Have Everyone Share Back
Play this video after each small group has written their questions on the WTFcsv handout. Here we outline some things to discuss as each group enumerates their questions and the process they might take to start answering them. For example, you want to validate groups that asked 'meta questions', like 'where is this data from?' or 'Can we trust this data?' as well as groups that started to ask questions about patterns that they saw in the data itself. If groups ask questions about patterns in data, ask them to take a step towards answering them. What other data would they need to answer their questions? Who collects that data?
Wrap-Up and Talk Next Steps
Now that you've done some basic spreadsheet analysis, this video will help you think about where to go from here. For example, what information in your organization is captured in spreadsheet form? Could you use this same approach with survey result data? With financial data? With lists of donors or web analytics? How can having groups come up with questions help you take the next step with your organization's data? We also discuss some common pitfalls to try to avoid, like remembering to consider outliers and keeping in mind that correlation is not causation.
Learn With Others
People around the world are using this activity. Learn from their comments below, and please share your experience with others by submitting it! Comments you leave here will be moderated. Once approved, they will be shared on this page and are public.