Index of all lessons

Main sections

• Spreadsheet Lessons
  • Spreadsheet Basics
  • Resources
• Learning spreadsheets with Census Surname data
  • Scoping out the Census Surname Data
  • How to Excerpt the Census Surname data
  • Manually building the Top 5000 Census Surname spreadsheet
  • Doing a Sanity Check of the Data with Pivot Tables
  • Gentle data cleaning with the Census surnames data
  • Categorizing the Census Surname Data

Individual lessons and notes

• Spreadsheet and Visualization Basics with Stanford Tuition
  • What we aren’t comparing (because it’s hard)
  • Stanford and economic data
  • Rough lecture
• Wrangling and Pivoting on U.S. Mass Shootings Data
  • Mother Jones counts something it finds interesting
  • Questions about Mojo’s mass-shootings data
• Reaction to the Vegas mass shooting
• Background reading on Lena Groeger