Guest speakers will be added as the semester progresses.
All assignments are due by 6pm the Sunday before class. Send both of the instructors links to files in your dropbox accounts by the deadline. They should not be changed after deadline (we'll know).
- 01- Jan 28: Overview of using data and records in investigative reporting / Story review proposal
- 02- Jan 29-Feb 4 Numbers in the newsroom / Best practices / Story memo initial exploration
- 03- Feb 5-11: Negotiating for electronic public records / Story memo brainstorming
- 04- Feb. 12-18: Advanced Excel: pivot tables, strategies for data cleanup
- 05- Feb. 19-25: More advanced Excel Due: proposal for story memo
- 06- Feb. 26-March 4: Reviewing advanced spreadsheets / Intro to MySQL
- 07- March 5-11: SQL: selecting, grouping / Review of story memo proposals
- 08- March 19-25: SQL joins & other SQL issues
- 09- March 26-April 1:
PDF solutions: Cometdocs, Tabula (free); ABBYY FineReader (paid)
Due April 1: Preliminary analysis for story memo - 10- April 2-8: Exploratory visualization for investigations / Work on data analysis issues in class
- 11- April 9-15:
Data cleanup / Open Refine and intro to regular expressions
- 12- April 16-22: Intro to scraping using Chrome Scraper; programming solutions
- 13- April 23-29: Network analysis, data science techniques / Due April 27, 7pm: Nut graf for story memo
- 14- April 30-May 6: Catch-up week, reviews of draft story memos / Bulletproofing handout Due before class May 6: Draft of story memo
- 15- May 13, final class:
Where to go from here / Handout
Due: Final story memo
---- Begin weekly story presentations (2 each week) ---
------- Spring break ------