Tipsheets and tutorials

Session materials from panels, demos and hands-on classes at the 2014 CAR Conference. Are you a CAR 2014 speaker with materials we don’t yet have on this list? Send them to web editor Sarah Hutchins at sarah@ire.org or resource center director Lauren Grandestaff at lauren@ire.org.

Wednesday

TechRaking 5ish: Bootstrapping the news (Sponsored by The Center for Investigative Reporting) | 1 p.m. in Chesapeake
Slides from the session

Detecting corporate fraud (Sponsored by Donald W. Reynolds National Center for Business Journalism) | 2 p.m. in Salon DEF
Slides from speakers Roddy Boyd and Theo Francis
Handout
Handout
Handout

THURSDAY


Tableau Public for beginners (Hosted by Tableau) | 9 a.m. in Stadium 1
Handout from Tableau

Mapping Mini Boot Camp | 9 a.m. in Stadium 2
Slides from speaker Jennifer LaFleur

Amazon Cloud Basics | 9 a.m. in Stadium 4
Pinboard from speaker Scott Klein
Tips & tricks for grabbing data from websites from Klein

PyCAR Mini Boot Camp – Team A | 9 a.m. in Stadium 5
GitHub repository

NewsCamp::The next generation of data viz | 9 a.m. in Grand Ballroom East
Slides from speaker Alberto Cairo

This just in: Data for breaking news investigations | 9 a.m. in Salon BC
Tipsheet from speakers Chris Keller, Jaimi Dowdell, Justin Fenton

Rifling through the mapping toolbox | 9 a.m. in Salon DEF
Slides from speakers Michael Corey and Ryan McNeill

Follow the Fracking | 10 a.m. in Salon BC
Slides from speaker Tom McGinty

Enhance your stories with statistics | 10 a.m. in Salon DEF
Slides from speaker Rob Barry
Slides from speaker Stven Rich

NewsCamp::Intro to D3 | 10 a.m. in Grand Ballroom East
Slides from speaker Irene Ros
Slides from speaker Alastair Dant

The data-driven story (Part 1) Conceiving and launching | 10 a.m. in Grand Ballroom West
Slides from speakers Jennifer LaFleur, David Donald, Brant Houston

Make dirty data shine with OpenRefine | 10 a.m. in Stadium 4
Slides, tipsheet and data from speaker Frederick Kaimann

The data-driven story (Part 2) Putting the package together | 11 a.m. in Grand Ballroom West
Slides from speaker Maud Beelman

Maps and charts in R: real newsroom examples | 11 a.m. in Stadium 3
GitHub repository from speaker Matt Waite

Dig into business with data investigations | 11 a.m. in Salon BC
Slides from speaker Rob Barry

Love your life, retire your servers |11 a.m. in Salon DEF
Slides from speakers Andy Boyle and Tasneem Raja

Killers and other criminals: Keeping tabs on crime | 2 p.m. in Salon BC
Slides from speaker Laura Amico
Slides from speaker John Bones

Free tools for data analysis | 2 p.m. in Salon DEF
Tipsheet from speakers Matt Wynn and Martin Burch

Hacks or Hackers? | 2 p.m. in Grand Ballroom East
Tipsheet from speaker Isaac Wolf

Make reporting better, together — Collaborative reporting with GitHub | 3 p.m. in Chesapeake
Slides from speaker Ben Balter

Breaking out the heavy artillery – using data to track weapons | 3 p.m. in Salon BC
Slides from speaker Griff Palmer

Slides from speaker David Fallis

When data don’t exist | 3 p.m. in Salon DEF
Slides from speaker Sarah Cohen

Harnessing the power of the crowd | 4 p.m. in Salon DEF
Slides from speaker Robert Benincasa

FRIDAY


Getting started with Excel  | 9 a.m. in Stadium 1
Tipsheet from speaker Helena Bengtsson

Build your first News App | 9 a.m. in Stadium 3
Tipsheet from speaker Ben Welsh

It’s a disaster | 9 a.m. in Salon BC
Slides from speakers Matt Jacob, Alex Richards

Finding great stories in not-so-great nonprofits | 9 a.m. in DEF
Slides from speaker Kendall Taggart

Fusion Tables for beginners | 9 a.m. in Stadium 4
Slides from speaker Daniel Lathrop

The year in CAR in odorama | 9 a.m. in Grand Ballroom East
Slides from speakers Jaimi Dowdell and Mark Horvit with Jennifer LaFleur, Odor Master

Liberate data from PDFs with Tabula | 10 a.m. in Salon A
Tipsheet from speaker Jeremy Merrill
Slides from speakers Jeremy Merrill and Mike Tigas

Wading through the sea of data on hospitals, doctors, medicine and more | 10 a.m. in Salon BC
Slides from speaker Peter Eisler
Tipsheet from speaker Charlie Ornstein

Complaints: A road map for killer investigations | 10 a.m. in Salon DEF
Tipsheet from speakers Jill Riepenhoff
Tipsheet from speaker Tisha Thompson
Data from Riepenhoff and Thompson

Introduction to R | 10 a.m. in Stadium 5
GitHub repository from speaker Sharon Machlis

Free the data: Getting government agencies to give up the goods | 10 a.m. in Grand Ballroom West
Tipsheet from speaker Kirsten Mitchell
Tipsheet from speaker Deb Nelson
Tipsheet from speaker Kate Willson

Analyze networks with NodeXL | 11 a.m. in Stadium 4
Tipsheet from speaker Peter Aldhous

Creating maps: Principles, mistakes and potential | 11 a.m. in Grand Ballroom East
Tipsheet from speakers Noah Veltman and Tom MacWright

More than an editor: Leadership for data-driven projects | 11 a.m. in Salon BC
Slides from speaker Maud Beelman
Tipsheets from Beelman

Campaign Finance I: Mining FEC data | 11 a.m. in Salon DEF
Tipsheet from speaker Chris Schnaars
Slides from speaker Chris Schnaars

The customized Census: Using microdata | 2 p.m. in Salon A
Slides from speaker Katie Genadek

Investigating racial inequality | 2 p.m. in Salon BC
Tipsheet from speaker Lawrence Lanahan
Presentation from speaker Lawrence Lanahan
Tipsheet from speaker Nikole Hannah-Jones
Slides from speaker Hannah-Jones

Building maps with leaflet and mapbox.js | 2 p.m. in Stadium 3
Tutorial from speaker Becca Aaronson

Protecting your work from prying eyes | 2 p.m. in Grand Ballroom East
Tipsheet from speaker Jennifer Valentino-DeVries

Social media for investigations | 2 p.m. in Grand Ballroom West
Slides from speakers Mandy Jenkins and Robert Hernandez

100+ tips and tools for news research | 3 p.m. in Grand Ballroom East
Tipsheet from speaker Margot Williams

DataViz for everyone: A practical guide to going responsive | 3 p.m. in Grand Ballroom West
GitHub repository from speaker Chris Amico

How PANDA works: Software architecture for big data | 3 p.m. in Chesapeake
Slides from speaker Chris Groskopf

Weathering the storm: Using data to track nature’s fury | 3 p.m. in Salon BC
Slides from speakers Stephen Stirling and Ian Livingston
Tipsheet from speakers Stephen Stirling and Ian Livingston

50 ideas in 50 minutes | 3 p.m. in Salon DEF
Spreadsheet from speaker MaryJo Webster

Everyday scripting | 3 p.m. in Stadium 3
GitHub repository from speaker Agustin Armendariz

SQLite for command line | 3 p.m. in Stadium 4
GitHub repository from speaker Matt Kiefer
Slides from Kiefer

Lightning talks (Sponsored by John S. and James L. Knight Foundation) | 4:15 in Grand Ballroom East
1. Refactoring; or Why Your Code Sucks and How to Fix It, Christopher Groskopf
2. A Few of My Favorite Wee Things, Lena Groeger
3. Natural Language Processing in the kitchen, Anthony Pesce
4. Five (more) algorithms in five (more) minutes, Chase Davis
5. What we can learn from terrible data viz, Katie Park
6. Practical Calculus, Steven Rich
7. Detecting What Isn’t There, Sisi Wei
8. The whole internet in 5 minutes!, Jeremy Bowers
9. How to Raise an Army, Tyler Fisher
10. You Must Learn, Ben Welsh

SATURDAY


Introduction to mapping: Importing and displaying data geographically with QGIS | 9 a.m. in Stadium 1
Tipsheet from speaker Peter Aldhous

Build your first News App | 9 a.m. in Stadium 3
Tipsheet from speaker Ben Welsh

How to feel like you’re hacking without really doing it | 9 a.m. in Stadium 4
Slides from speaker Samantha Sunne

Ruby 1: Introductions | 9 a.m. in Stadium 5
Slides from speaker Al Shaw

My friend FRED: A free tool for searching and graphing business, economic and government data | 9 a.m. in Salon A
What is FRED handout from speaker Keith Taylor
Tipsheet from speaker Keith Taylor

Danger! Hazardous materials: Using data to uncover pollution | 9 a.m. in Salon BC
Slides from speaker Ben Poston
Slides from speaker Denise Malan

Threat modeling: Security for your story | 9 a.m. in Grand Ballroom East
Video and slides from speaker Jonathan Stray

The art and craft of finding people | 9 a.m. in Grand Ballroom West
Tipsheet from speaker Rick Yarborough
Slides from speaker Julie Tate

Mapping 2: Manipulating and editing geographic data with QGIS | 10 a.m. in Stadium 1
Tipsheet from speaker Peter Aldhous

Counting and summing with SQL | 10 a.m. in Stadium 2
Tipsheet from speaker Andrea Fuller

A quick trip through data in the sciences | 10 a.m. in Grand Ballroom East
Slides from Cynthia Hsu

An app for that: Mobile tech and tools for reporting | 10 a.m. in Grand Ballroom West
Slides from speaker David Ho

How to uncover inequity and swindlers in subsidized housing programs near you | 10 a.m. in Salon DEF
Slides from speaker Tim Henderson

Excel magic: Advanced functions in Excel | 11 a.m. in Stadium 1
Tipsheet from speaker MaryJo Webster
Excel data from MaryJo
“5 tips for data manipulation in Excel” by attendee Sharon Machlis for ComputerWorld

PostGIS & CartoDB | 11 a.m. in Stadium 4
GitHub repository from speakers Michael Keller & Andrew Hill

Go! Go! In the hot seat with breaking news | 11 a.m. in Salon A
Tipsheet from speakers Jaimi Dowdell and Megan Luther

Examining prescribing patterns (Phil Meyer Award winner) | 11 a.m. in Salon BC
Slides from speakers Jennifer LaFleur and Charles Ornstein

It’s not just for looks: Presentation as a storytelling tool | 11 a.m. in Grand Ballroom East
Slides from panel

The fine art of negotiating for data | 11 a.m. in Grand Ballroom West
Slides from speakers Andrew Lehren, Ellen Gabler and Joanna Lin

A picture of Earth through time: Storytelling with Google Earth Engine | 11 a.m. in Chesapeake
Intro to Google Earth Engine from speaker Vanessa Schneider

NewsCamp::Demystifying D3 | 2 p.m. in Grand Ballroom East
GitHub repository from speaker Irene Ros
Slides from speaker Alastair Dant

Regular expressions | 2 p.m. in Salon A
Links and notes from speaker Amanda Hickman

Getting started with Python | 2 p.m. in Stadium 3
GitHub repository links and more from speaker Anthony DeBarros

You won’t believe what static site generators can do for news apps | 3 p.m. in Chesapeake
The NPR visuals team’s opinionated project template for client-side apps

Data deep dives (part 1) | 3 p.m. in Salon DEF
Slides from speaker Paul Overberg

Digging online for global data | 4 p.m. in Grand Ballrom East
Tipsheet from speaker Jonathatn Stoneman
Tipsheet from speaker Jeff Kelly Lowenstein

When to scrape: Tools and techniques | 4 p.m. in Grand Ballroom West
11 tips for scrapers at the next level from speaker Nils Mulvad

Cross-platform collaboration for data projects | 4 p.m. in Salon BC
Slides from speaker Josh Kleinbaum
Slides from speaker John Walton

Intro to SDR (Software Defined Radio) | Open Mic
Slides from Jon Keegan and Ken Schwencke

SUNDAY


Census I: Must-have data for every beat | 9 a.m. in Grand Ballroom West
Tipsheet from speaker Ron Campbell
Slides from Ron Campbell

Intro to Fusion Tables | 9 a.m. in Stadium 4
Slides from speaker Tim Henderson

Tools for Social Network Analysis investigations | 9 a.m. in Salon BC
Slides from speaker Rich Gordon

Advanced searching techniques | 9 a.m. in Salon DEF
Slides from speaker Acton Gorton

Census I: Must-have data for every beat | 9 a.m. in Grand Ballroom West
Tipsheet from speaker Mike Maciag
Tipsheet from speaker Paul Overberg

Census II: Going beyond the basics  | 10 a.m. in Grand Ballroom West
Tipsheet from speaker Ron Campbell

Web tools, tips and tricks for investigations | 10 a.m. in Grand Ballroom East
Tipsheet from speakers Jaimi Dowdell, Mark Horvit and Megan Luther

Census III: Mapping and presentation | 11 a.m. in Grand Ballroom West
GitHub repo from speakers John Keefe and Chris Amico
Tips on how to remove water from Census tract maps from speaker Keefe