Jan. 12
Meet Your Computer Again for the First Time
The first step in data-driven journalism is learning how to see structure in the world. The second step is to make sure you have a clean machine with all the tools properly installed. We’ll do both today.
- IRE.org
- ITS Virtual Lab
- R and R Studio
- DB Browser for SQLite
- Google Fusion Tables
- Tableau Public
- QGIS
Jan. 14
The ‘Science’ Part of Data Science
Data driven stories don’t start with data. They start with an interesting question that reporters turn into a hypothesis they can test. Good journalism = good science.
Jan. 19
Introduction to Spreadsheets
Once you have an interesting question, getting the right data in the right format can help you answer it.
Jan. 21
More Spreadsheets
What do you do when the world gives you data lemons? Make data lemonade, using Pivot Tables and Excel’s functions to clean and restructure the data.
Jan. 26
Data in the Real World
Tyler Dukes from WRAL and statistics Ph.D. candidate Iain Carmichael talk about how they use date in their work, and where the worlds of journalism and data science collide.
Jan. 28
There R Another Way
Iain Carmichael shows us the advantages of using R.
Iain Carmichael shows us the advantages of using R.
Feb. 2
The Magic of Open Government Data
What kinds of data do state and local agencies in North Carolina collect? How can journalists use it and how easy is it to get?
Feb. 4
The Myth of Open Government Data
Today we get from WRAL’s Tyler Dukes the real story on how journalists find and use public data.
- Readings Due Today: “Numbers in the Newsroom,” Chapters 1, 2, 6, 7
- Assignments Due Today
Feb. 9
Introduction to SQL
“Hey data …” Using Structured Query Language, journalists can write questions they can ask the data over-and-over again. They can also begin to interact with data sets that are too large for spreadsheets.
Feb. 11
More SQL
Learn more SQL so you can challenge the data with tougher questions.
Feb. 16
I’m going to be like the creepy Mr. Hooper character in that video and show you how you can differentiate your reporting by joining two SQL tables that never would have gotten together in the wild. Some people just call them enterprise joins.
- Readings Due Today
- Assignments Due Today
Feb. 18
There Still R Another Way
Iain Carmichael comes back to show us how R can do some of the same queries and joins you can do in SQL.
- Readings Due Today
- Assignments Due Today
SPRING BREAK
March 22
Basic Web Maps
We’ll use Google Fusion Tables and Maps to make some cool interactive maps with campaign finance data.
- Readings Due Today
- Assignments Due Today
March 24
More Basic Web Maps
- Readings Due Today
- Assignments Due Today
March 29
Intro to Data Visualization
Reporters can use basic data visualization tools such as Tableau to quickly find story ideas.
- Readings Due Today
- Assignments Due Today
March 31
Intro to Data Visualization
Reporters can use basic data visualization tools such as Tableau to quickly find story ideas.
- Readings Due Today
- Assignments Due Today
April 5
Spatial Data & QGIS
Maps aren’t just pretty. They’re smart!
- Readings Due Today
- Assignments Due Today
April 7
Spatial Data & QGIS
Maps aren’t just pretty. They’re smart!
- Readings Due Today
- Assignments Due Today
April 12
Using Census Data
What they count and what they don’t.
- Readings Due Today
- Assignments Due Today
April 14
Mapping Census Data
Sing with me now: Who are the people in your VTD?
- Readings Due Today
- Assignments Due Today
April 19
R We on Schedule?
If not, we’ll catch up. If so, we’ll learn some new data visualization tricks in R.
- Readings Due Today
- Assignments Due Today
April 21
R We on Schedule?
If not, we’ll catch up. If so, we’ll learn some new data visualization tricks in R.
- Readings Due Today
- Assignments Due Today