Tuesday, October 18
Agenda
No homework for Thursday. Probably a bit of study work for Tuesday
Ignore the current homepage
A primer for the U.S. Census American Community Survey data
The U.S. Census records such an incredible, intimidating volume of data points about American life that is is hard to know where to begin. This guide aims to explain how Census data is organized, how to find important and interesting data points, and how the data is distilled and displayed by journalism outlets.
SQL Part 1: Select, Sort, and Transform Data
This this first unit of SQL lessons, we cover the syntax and concepts to fetch, sort, and -- as we've done using spreadsheet functions -- transform data values.
Assignments
In class work
From the data starterpacks page, please download the following SQLite databases: