Data visualization: Making your spreadsheet make sense

Transcript

1. JOUR 5200 – May 15, 2019 Trish Audette-Longo Data visualization: Making data make sense
3. Before you start: • Make sure that you can read the information in a spreadsheet.
4. • Start by highlighting a column.
5. • Click “Format” and select • Select Format >> AutoFit Row Height • Ensure “Wrap Text” is also selected
6. Just in case… • Save your more legible spreadsheet, then create a back-up version of your data by saving your spreadsheet with a new name (for example, “save as” ottflood2).
7. Just in case… • Save your more legible spreadsheet, then create a back-up version of your data by saving your spreadsheet with a new name (for example, “save as” ottflood2). • At some point when you work with data, you will make a mistake; saving multiple versions allows you to: 1. Check your work (especially your findings or conclusions) against the original data; and 2. Back up one or two steps if things go sideways.
8. Additional resources • OpenRefine: “A free, open source, powerful tool for working with messy data.”
9. Based on this data… • We are going to create three different data visualizations based on the data set: 1. A map 2. A word cloud 3. A graph to show how #ottflood was used in conversation with other topics