130 likes | 221 Views
Journalism 285 Mondays and Wednesdays 8:10 a.m. - 11 a.m., Room 26-207. Course Info: http://cpj285.wordpress.com Dave Schermer Lecturer. Quiz. 4 multiple choice questions based on readings and past classes You can take it between 8:10 and 8:15 a.m.
E N D
Journalism 285Mondays and Wednesdays 8:10 a.m. - 11 a.m., Room 26-207 Course Info: http://cpj285.wordpress.com Dave Schermer Lecturer
Quiz • 4 multiple choice questions based on readings and past classes • You can take it between 8:10 and 8:15 a.m. • To begin, log in to Blackboard, click “Assignments,” then click on the quiz.
Midterm • Grade, answers and comments on Blackboard
Vox Pops • How did you pick your topic? • How did you pick your interviewees? • What was it like getting them to talk? • How easy or hard was it to get good responses? • What did you learn about the shooting and editing process?
Data Driven Journalism? • Web is a vast sea of data • Often too complicated for public • Journalist’s role • Examine it • Look for newsworthy info • Refine it • Make it clear
Data Examples • City salaries • Restaurant inspections • Property values • Crime maps(SLO Sheriff) • Police Logs(Cal Poly PD) • Sex offenders
Reporting Examples • SLO Tribune - Crime Map • LA Times – Teacher Performance • Sac Bee – Wildfire History • NY Times – Census Map
People Search • Zabasearch.com (free) • Intelius.com (paid)
Using Spreadsheets • Microsoft Excel, iWork, OpenOffice • Example: City Council travel • Copy data into Excel: Example • Managing info: time off requests • Google Docs Spreadsheets
Demo: Build a ChartTop 10 highest salaries in SLO • Get the data • Copy into Excel • Upload to Google Docs
LAB: Build a Chart • Find the top 10 highest salaries in your hometown at: lgcr.sco.ca.gov • Use “Total Wages” column • Click column name to sort list • Put the data into Excel • Column A should be “Title” • Column B should be “Salary” • Create a chart using Google Docs • Show me your finished chart
Reminders • Blog Post 4 due next class • Readings