Data journalism – UOHack - Rob Denton

View Github Repository Open presentation in a new window

uohack

See all presentation from uohack

Data journalism – UOHack - Rob Denton

0 0

data-journalism

On Github uohack / data-journalism

Data journalism

UOHack - Rob Denton

Vocab

(5-10 minutes)

Workflow

(5-10 minutes)

Example

(30-40 minutes)

Questions

Quick UOHack pitch

 
 

Tuesdays 6-8 p.m. here

CSV

(Comma separated values) 
						name, age, positionRob, 24, Web DeveloperMary, 25, ReporterPeter, 54, PhotographerJane, 36, Designer
- Anyone can open (Excel, sheets, etc.) - Almost anyone can export as - If you only take one thing away today, remember this

Excel vs. Google Sheets

- Not terrible but not everyone has Excel - Can upload to Google - Second best to CSV

PDFs

- Not great - Some can work with, some not (interactive vs. image) - 9/10 times they can provide CSV

Database files

- Too many to name - Many old, proprietary - Ask if they can export as CSV or Excel - NO SCREENSHOTS OF DATA

Printed files

- Unless you want to go all Spotlight...
 

Ask for data nicely

If you have no other choice,pursue open records request (FOIA)

- FOIA is an act of war, takes congressional approval

SPLC

Workflow

  • Story idea, press release, etc.
  • Acquire data
  • Clean data
  • Report story (let data guide you)
  • Visualize data

Example time

  • High school graduation rates
  • CU grades
  • ASUO budget data

High school graduation rates

bit.ly/1zCW6BR

CU grades

bit.ly/1S9KzmE

ASUO budget

bit.ly/1qfCosd

Questions?

Hit me up anytime@robertrdenton

Data journalism UOHack - Rob Denton