Data In The Newsroom
Fairleigh Dickinson University - Fall semester, 2008
Syllabus - updated 10/2/08
The final project - updated 10/7/08
More data cleaning
The dreaded enterprise join
Even more joins
More relational joins
Relational joins
SQL
More practice with summarizing and filtering queries
More Access practice
Introduction to database managers:
Negotiating for data:
Importing data into Excel :
Advanced Excel:
Tipsheet: String functions and more
Homework:Baseball.xls
More pivot table practice exercises:
homework: Exxon.xls
Intermediate Excel, filtering and pivoting:
More Excel practice:
Excel and math for journalists:
Introduction to Excel:
Spreadsheets for exercises:
Many of the databases, spreadsheets and tips linked above were created as teaching exercises by the very fine folks at IRE. If you visit the organization’s Web site, you can find a plethora of resources for teaching and learning computer-assisted reporting. I am immensely indebted to the work of IRE and the materials they allow me and other educators to use to pass on these skills.
