The week of Tuesday, September 29

These links contain material that I refer to in class but in self-contained article/aggregate/tutorial form.

How the Baltimore Sun used flawed FBI crime statistics to scrutinize the handling of sexual assault cases by the Baltimore Police.

Pivot tables are an effective tool for quickly summarizing the facts from a mass of records

A walkthrough of basic spreadsheet and pivot table usage (Part 1 of 3) We have a lot of ways to easily create beautiful, elaborate visualizations. But let’s see what we can do when we prioritize the story of the data over its visual presentation.

A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)

A walkthrough of using Pivot Tables to summarize earthquake data across two dimensions, allowing for even more insightful histograms (Part 3 of 3)

Assignments

Pivot Tables and SF Crime Data

Due: Tuesday, October 6
Points: 5

Use pivot tables to summarize San Francisco crime data

More pivot tables and crime data

Due: Tuesday, October 6
Points: 5

Use pivot tables to compare year-over-year crime data

Read 5 data journalism stories

Due: Thursday, October 1
Points: 5

Pick 5 data stories from a wide selection, write five short summaries

Notes for Thursday, October 1

More pivot tables:

Today's dataset: San Francisco police incidents for August 2014 and 2015

Notes for Tuesday, September 29

Hands-on lesson about earthquakes and pivot tables

Download the data here: usgs-north-america-quakes.csv

Let's try to do better than this map:

References

A list of public and easy-to-get (but not easy to analyze) datasets. They are all too big for easy spreadsheet work, but that’s why we’ll be learning about databases…