Public Affairs Data Journalism, Fall 2017

This Week

Week 4, Day 8: 2017-10-19

Let’s MuckRock: https://www.muckrock.com

The site is pretty easy to use, but you can follow these instructions from last year’s homework as a reference: http://2016.padjo.org/assignments/foia-records-fun/

More SQL

  • Aggregating in SQL with GROUP BY and HAVING
  • SQL Joins

Next week

About COMM 273D

Homepage: 2017.padjo.org

About this class

Location and Time

McClatchy Hall (Building 120), Room 410

Tuesdays and Thursdays
1:30 to 2:50PM
September 26 through
December 7, 2017

Instructor

Dan Nguyen, Lorry I. Lokey Visiting Professor in Professional Journalism

Office Hours

Room 342, McClatchy Hall
Monday and Wednesdays
2 to 4PM, or by appointment

Description

Accountability journalism has always relied on efficient and purposeful observation, analysis, and investigative drive. The ubiquity of high-powered networked computers today makes the work both easier and yet even more necessary for the modern journalist.

Students are expected to become proficient in research and database programming and, as a result, attain the practical experience and wisdom necessary for real-world empirical journalism projects.

Prerequisite: Journalism M.A. student or permission of the instructor.


Full syllabus

Search Page