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.

Reading

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.

Reading

CIR and Daycare:

http://cironline.org/reports/california%E2%80%99s-lack-online-child-care-records-leaves-parents-dark-5819

http://cironline.org/blog/post/cir-seeks-help-shine-light-california-day-care-records-6188

http://cironline.org/blog/post/calif-provide-limited-information-child-care-inspections-online-5903

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.

Readings

Chapter 2 and chapter 7, Computer-Assisted Reporting, A Practical Guide.

IRE PDF 4126 on negotiating for data

The Data Journalism Handbook: visualization

Thursday, Jan. 15

Practice: Introduction to Tableau 

Seminar

  • 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.

Reading

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.

Reading

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.

Also by Cairo: Data journalism needs to up its own standards and a critique of a data visualization by NPR.

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

To come

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

Reading

Chapter 9-10, Computer-Assisted Reporting, A Practical Guide.

 

Tuesday, Feb. 10

Scanner Wars

 

 

 

 

 

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

Reading

  • 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).

 Reading

Please read this entire series and watch related videos.

The Seattle Times: Methadone and the Politics of Pain 

 

 

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)

 Reading

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:

 

 

Ongoing assignment

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.

Reading 

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.

Reading

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.