Interviewing the data

Today

• Focus on questions - good questions
• Look at the data we created
• Some spreadsheet basics
• Ask questions about our high schools
• Analyze some big projects

A STORY IDEA IS A QUESTION

Spreadsheet jargon

CVS, XLS and other horrors

• CSV – common separated values
• Excel – a Microsoft product for spreadsheets
• Google sheets

ENTRIES

Column

Row

Cell

Formula

Adjustments

Sort – to change the order based on data in one column, rows stay the same

Filter – to remove rows based on a searching one column

Maps can also help to find patterns

Clean up