Tuesday, Jan. 5, 2015
Discussion: Class overview and discussion on identifying subjects/data sources for short posts/visualizations
Seminar: Backgrounding and data research online
Assignments to be completed by Jan. 8
- Join IRE and email IRE staff about getting set up with your CometDocs membership.
- Find three tipsheets in the IRE Resource Center on a subject/subjects in which you are interested.
- Write a one-page memo about how you can use the information in the tipsheets as a model to report out Data Hub posts or stories for The Peninsula Press. Come to class prepared to discuss.
IRE tipsheet 4079 on search terms.
Thursday, Jan. 8, 2015
Seminar: Data Journalism is a big umbrella
- Journalism about data
- Journalism using data (traditional Computer-Assisted Reporting)
- Data as journalism (apps)
- Research, tools and algorithms in the service of journalism (DocumentCloud, Overview, etc.)
Discussion: Short data posts and visualizations for Peninsula Press Data Hub.
Assignments to be completed by Jan. 13:
Data Hub Memo: One-page memo detailing an idea for a Data Hub post and visualization. Explain how you searched for the data sources and what is available. Include in your memo what makes the topics newsworthy and what your next steps are. Upload memo to Google Drive by class start on Jan. 13.
DocumentCloud: Log in and practice using DocumentCloud. Walk through the guided tour.
CIR and Daycare:
Chapter 1, Computer-Assisted Reporting, A Practical Guide.
Tuesday, Jan. 13, 2015
Guests from Center for Investigative Reporting to discuss collaborative project.
Class discussion: Project logistics.
Exercise/discussion: Negotiating for data
Assignments to be completed by Jan. 15:
- Review feedback on your memo, start the process of obtaining the needed data and begin reporting out a data post (including starting interviews). Note that first draft is due Jan. 20 by start of class.
Chapter 2 and chapter 7, Computer-Assisted Reporting, A Practical Guide.
IRE PDF 4126 on negotiating for data
Thursday, Jan. 15
Practice: Introduction to Tableau
- What makes a visualization effective? Class discussion
- Discussion of possible data and document analysis for collaborative project and discussion of possible stories. Discuss various roles on the teams. Divide into reporting/analysis teams.
Assignments due by Jan. 20:
- Install Tableau on your own laptop if you plan to use it on your own computer. Tableau is also set up in the lab. (I will email the key information to you).
- Tableau tutorial from NICAR 2014. Note: use the Tableau Desktop software you have installed. You do NOT need to install Tableau Public. However, to publish vizes, you will need to create a Tableau Public account.
- First draft of your data post and Tableau viz, as well as short memo explaining what reporting and data analysis you have done so far and why you selected the chart types you are using in the viz. Upload to Google Drive before class.
Flowing Data’s best vizes of 2014
IRE contest entry PDF 26350
Chapter 5-6, Computer-Assisted Reporting, A Practical Guide.
Tuesday, Jan. 20
Seminar: Data journalism involves spreadsheets, SQL joins, data-mapping and data visualization. But that is not what data journalism is really about. Data journalism is about the same thing as all good journalism: the story.
Assignments due by Jan. 22:
- Set up an account with AP Overview. Go through the Overview video tutorials.
- Post to Google Drive a draft of assigned open records request. Your specific open records assignment will be posted to your Google Drive folder.
Care Home Crisis case study, The Data Journalism Handbook
Thursday, Jan. 22
CLASS as normal
Practice: PDF to spreadsheets, a little data cleanup using CometDocs and Excel.
Discussion: Collaborative class project and team divisions and roles.
Assignments due by Jan. 27:
- Review feedback on draft of public records request, make changes and submit actual request (cc me). Throughout the quarter provide regular updates on progress for data request and negotiations.
- Analyze daycare summary data and write memo explaining your analysis, including what you used to analyze the data and possible avenues for news stories.
Reading by Jan. 27
Infographics and Visualizations as Tools for the Mind, by Alberto Cairo, incoming Knight Chair in Visual Journalism, University of Miami.
IRE tipsheet on graphic and interactive design by Kat Downs Mulder, an interactive designer and the graphics director at The Washington Post. You want PDF No 366o.
Tuesday, Jan. 27
Seminar: Creating data out of unstructured information and uncovering hidden stories.
Presentation/critique: A selection of draft Data Hub posts/visualizations (randomly selected, so be prepared to present).
Assignments due by Jan. 29:
- Collaborative project teams meet and identify possible specific story topics or lines of reporting. Each student team takes on part of the work to tag in AP Overview and then exports and analyzes that summary information created from the tagging process.
- (If we have scanned records yet, begin process of uploading and OCRing of scanned documents, reading documents and noting errors.
Reading by Jan. 29
Airport Insecurity, The Seattle Times
Your Courts, Their Secrets, The Seattle Times
Wikileaks case study, The Data Journalism Handbook
Thursday, Jan. 29
Practice: Advanced Excel analysis review
Practice/Discussion: In-class work on collaborative data project and discussion of next reporting steps.
Presentation/Critique: A selection of Data Hub posts/visualizations (randomly selected, so be prepared to present).
Assignments due by Feb. 3
- Collaborative project teams submit a one-page outline of project story ideas based on work to date. Upload to Google Drive before class. Include a description of the role of each team member.
- Follow the scraping tutorial provided in Google Drive.
Reading by Feb. 3
Chapter 8, Computer-Assisted Reporting, A Practical Guide.
Tuesday, Feb. 3
Presentation/critique: A selection of Data Hub posts/visualizations (randomly selected, so be prepared to present).
Practice: A review/quiz of SQL
Assignments due by Feb. 5
- If your Data Hub post was critiqued, then revise and submit revised draft.
- Memo and analysis of summary inspection data for collaborative project using SQL and spreadsheets. Upload a one-page memo on your analysis and findings to Google Drive before class start time. Include a section on what data you would like to have that isn’t in the summary data.
Reading by Feb. 5
Thursday, Feb. 5
Seminar: Finding your data story
Practice: More SQL
Assignment due by noon, Feb. 9
- Collaborative project teams meet and identify possible specific story topics or lines of reporting. Collaborative project teams submit a one-page outline of project story ideas based on work and summary analysis. Upload to Google Drive before class. Include a description of the role of each team member.
Assignments due by Feb. 10
Chapter 9-10, Computer-Assisted Reporting, A Practical Guide.
Tuesday, Feb. 10
Thursday, Feb. 12
Seminar on reporting and writing the data story.
Discussion of class assignments and schedule, including Data Hub posts, collaborative project and individual projects. On individual projects we will discuss choosing your own topic, selecting a story off of the news or analyzing lobbying data in California.
Data visualization and Tableau assistance option
Tableau representative Dash Davidson will be available through Thursday afternoon for hands-on feedback on visualizations. Please sign up on this Google spreadsheet for one-on-one times in Chaffee (Room 452). Pizza served at noon!
Assignments due by Feb. 17
- Data Hub posts —Submit revised draft of Data Hub post, including text and visualization.
- Revised group memo on summary analysis and story ideas for collaborative project
- Chapter 3-4, Computer-Assisted Reporting, A Practical Guide.
- SQL primer
- PDF 3866, titled Dodging Disaster by Liz Lucas in IRE tipsheets, (search for tipsheet number on the IRE site).
Tuesday, Feb. 17
Seminar and Practice: A review/intro on Structured Query Language followed by a quiz for those who are not assigned to scan records for the collaborative project. At least four students will be scanning documents on Tuesday from 9 a.m. to 1 p.m. with Center for Investigative Reporting.
Assignments due by Feb. 19:
- Initial story memo for individual story/project, include what the minimum and maximum story could be, and next reporting steps and interim deadlines. (1-2 pages)
- One-page memo on what you think the key data analysis was that made the Methadone investigation a strong news investigation (see reading assignment below).
Please read this entire series and watch related videos.
Thursday, Feb. 19
Seminar: When mapping tells a story you otherwise would miss. A case study by investigative reporter Michael J. Berens. (Date may change)
Assignments due by Feb. 24:
- Initial story memo for individual CAR project, include what the minimum and maximum story could be, and next reporting steps. (1-2 pages)
Oso mudslide coverage (link to come)
Logging and landslides (link to come)
Tuesday, Feb. 24
Practice: A review/intro on Structured Query Language followed by a quiz
Assignments due by Feb. 26:
We’ll be doing revisions and publication of Data Hub posts on an ongoing basis.
Thursday, Feb. 26
Seminar: Guest lecture by Michael J. Berens of the Chicago Tribune
Assignments due by Tuesday, March 3
A top (lede, nutgraf, context) and update on progress for your individual project.
IRE tipsheet 3350.pdf
How to make a storymap, by Sharon Machlis
Tuesday, March 3
Discussion: Reporting your own project — identifying trends.
Assignments due by March 5
Completed draft of individual story project and viz or map.
IRE tipsheet 3935.pdf
Thursday, March 5
Seminar: Statistics — how to use them, when to avoid them and when to get help.
Discussion: Cautionary tales
Assignments due by March 10:
Tuesday, March 10
Seminar: Mind the gap –when data are missing
Critique/Presentation: Read/present the top of your story (first 5-10 grafs)
Thursday, March 12
Critique/Presentation: Read/present the top of your story (first 5-10 grafs)
Final draft of individual project is due by start of class time. Final edits completed during exam week for publication on Peninsula Press.