Tipsheets & Links

Session materials from panels, demos and hands-on classes at the 2015 CAR Conference. Were you a NICAR15 speaker with materials we don’t yet have on this list? Send them to tipsheets@ire.org.

WEDNESDAY

Secrets of covering money | 1:30 p.m. in International 8-9

Techraking <=10: bootcamping the news | 1:00 p.m. in International 10

 

THURSDAY

Welcome and overview of the conference | 8:30 a.m. in International 8-9

No tipsheet available 

Key data for investigating universities | 9:00 a.m. in International 2-3

Investigating caregivers | 9:00 a.m. in International 4-5

Spotlight: Being a reporter when everyone’s a journalist and there’s data everywhere | 9:00 a.m. in International 6-7

No tipsheet available 

Getting started: Intro to CAR and the conference | 9:00 a.m. International 8-9

No tipsheet available 

From words to pictures: Text analysis and visualization | 9:00 a.m. International 10

Interactive data graphics in Tableau Public | 9:00 a.m. in M101

No tipsheet available 

Intermediate /advanced Python | M102

Getting started with open-source database manager MySQL | 9:00 a.m. in M103

No tipsheet available 

PyCAR – Team A | M104

Excel magic | 9:00 a.m. in M105

PyCAR – Team B | M106

No tipsheet available 

Twitter tricks and analytics | 9:00 a.m. in M107

Map Camp | M109

No tipsheet available 

The forgotten history of data journalism | 10:10 a.m. in International 2-3

No tipsheet available 

Tracking diseases | 10:10 a.m. in International 4-5

Do it once (and only once) | 10:10 a.m. in International 6-7

What the hell is R and all the other questions you’re afraid to ask | 10:10 a.m. in International 8-9

Interactives without programming: A new tool for building data-driven, interactive content | 10:10 a.m. in International 10

No tipsheet available 

Advanced design and interaction in Tableau Public | 10:10 a.m. in M101

No tipsheet available 

Excel for business and economics | 10:10 a.m. in M103

No tipsheet available 

Make Photoshop work for you | 10:10 a.m. in M105

Designing database applications to increase page views and ad revenues | 10:10 a.m. in M107

No tipsheet available 

Uncovering racial and economic divides using data | 11:20 a.m. in International 2-3

Data from scratch: When data don’t exist | 11:20 a.m. in International 4-5

Digging deeper with the web | 11:20 a.m. in International 6-7

No tipsheet available 

Spotlight: A conversation with Hanna Wallach – lessons from computational social sciences | 11:20 a.m. in International 8-9

No tipsheet available 

Tell stories about your community with real estate data | 11:20 a.m. International 10

Intermediate / advanced Python | 11:20 a.m. in M102

OpenRefine | 11:20 a.m. in M103

No tipsheet available

Getting started with Access | 11:20 a.m. in M105

No tipsheet available

First steps with R | 11:20 a.m. in M107

CAR on the beat | 2:10 p.m. in International 2-3

Make every international story a data story | 2:10 p.m. in International 4-5

Space journalism: Using satellite imagery for data projects | 2:10 p.m. in International 6-7

The latest on open records | 2:10 p.m. in International 8-9

No tipsheet available

Plotly: Making & sharing beautiful, engaging graphs | 2:10 p.m. in International 10

No tipsheet available

Intro to data stories in Tableau Public | 2:10 p.m. in M101

No tipsheet available

Stats: An introduction | 2:10 p.m. in M103

No tipsheet available

Counting and summing with Access | 2:10 p.m. in M105

Grabbing data from websites without scrapping | 2:10 p.m. in M107

Analyzing jobs in your community | 3:20 p.m. in International 2-3

I screwed up. I survived and you can, too | 3:20 p.m. in International 4-5

No tipsheet available

Humanizing numbers | 3:20 p.m. in International 6-7

Data journalism in the university: Making the paradigm shift | 3:20 p.m. in International 8-9

No tipsheet available

Bedfellows: Explore the relationships between PAC donors and recipients | 3:20 p.m. in International 10

No tipsheet available

Advanced calculations and analysis in Tableau Public | 3:20 p.m. in M101

No tipsheet available

Stats: Basic linear regression | 3:20 p.m. in M103

No tipsheet available

Joining tables with Access | 3:20 p.m. in M105

No tipsheet available

Import.io: Web scrapping without coding | 3:20 p.m. in M107

Map Camp | 3:20 p.m. in M109

No tipsheet available

Tell me a story I won’t forget | 4:30 p.m. in International 2-3

Teaching data journalism: Your best ideas | 4:30 p.m. in International 4-5

No tipsheet available

Investigating business with data | 4:30 p.m. in International 6-7

Broadcast: Viz, quick hits and the data you need | 4:30 p.m. in International 8-9

Let’s find the open and unsecured | 4:30 p.m. in International 10

Stats: Logistic regression | 4:30 p.m. in M103

No tipsheet available

Make the command line work for you | 4:30 p.m. in M105

No tipsheet available

Building better maps with Leaflet, Mapbox and JavaScript | 4:30 p.m. in M107

FRIDAY

The new ecosystem of health care data | 9:00 a.m. in International 2-3

VR for the NICAR world: Immersive data | 9:00 a.m. in International 4-5

No tipsheet available

The year in CAR | 9:00 a.m. in International 6-7

No tipsheet available 

Bridging the developer / journalist gap | 9:00 a.m. in International 8-9

No tipsheet available

Moonshining: Indexes pack high-proof explanatory power | 9:00 a.m. in International 10

GitHub 101: The basics | 9:00 a.m. in M101

No tipsheet available

Build your first news app | M102

Getting started in Excel | 9:00 a.m. in M103

No tipsheet available

Map like a pro with ArcGIS Online | 9:00 a.m. in M104

No tipsheet available

Regular expressions for beginners | 9:00 a.m. in M105

No tipsheet available

Fusion Tables for beginners | 9:00 a.m. in M106

No tipsheet available

Useful command line tools for reporters | 9:00 a.m. in M107

Amazon Cloud basics | 9:00 a.m. in M109

No tipsheet available

Visual journalism for tiny news desks | 10:10 a.m. in International 2-3

Thinking about interactivity | 10:10 a.m. in International 4-5

No tipsheet available

Watchdogging public spending | 10:10 a.m. in International 6-7

Red alert: Tools to automatically generate story leads | 10:10 a.m. in International 8-9

Introducing Geomancer: Don’t let your data be lonely tonight | 10:10 a.m. in International 10

No tipsheet available

How I learned to take command of the command line: A journalist’s guide to getting started | 10:10 a.m. in M101

Using formulas in Excel | 10:10 a.m. in M103

No tipsheet available

Making timelines | 10:10 a.m. in M104

Data alchemy | 10:10 a.m. in M105

No tipsheet available

Getting started with Python | 10:10 a.m. in M107

Crowdsourcing with Google Forms | 10:10 a.m. in M109

Color (and shape and place) my world | 11:20 a.m. in International 2-3

Local data that can lead to stories | 11:20 a.m. in International 4-5

Machine learning in the wild – #wins and #fails | 11:20 a.m. in International 6-7

Jobs and career straight-talk: For (and by) young’uns only | 11:20 a.m. in International 8-9

No tipsheet available

Demo: Tools for cracking PDFs | 11:20 a.m. in International 10

Web scraping using Python | 11:20 a.m. in M101

PivotTables in Excel | 11:20 a.m. in M103

Introduction to web programming | 11:20 a.m. in M104

No tipsheet available

Simple stats in Excel | 11:20 a.m. in M105

Visualizing your data with R | 11:20 a.m. in M106

Using data to detect environmental dangers | 2:10 p.m. in International 2-3

Critical questions to ask of studies, press releases and scientific reports | 2:10 p.m. in International 4-5

Stat-a-thon | 2:10 p.m. in International 6-7

Life after Excel and Access – the next steps | 2:10 p.m. in International 8-9

No tipsheet available

Scraping, APIs and data extraction | 2:10 p.m. in International 10

No tipsheet available

Advanced Django for data analysis | 2:10 p.m. in M101

Teach yourself to code | 2:10 p.m. in M102

Mini Boot Camp – Excel | 2:10 p.m. in M103

No tipsheet available

Mapbox | 2:10 p.m. in M104

Mini Boot Camp – Excel | M105

No tipsheet available

Getting data into Excel | 2:10 p.m. in M106

Intro to D3 | 2:10 p.m. in M107

Getting started with JavaScript | 2:10 p.m. in M109

Deep dives part 2 | 3:20 p.m. in International 2-3

No tipsheet available

Data behind the news | 3:20 p.m. in International 4-5

No tipsheet available

Free tools | 3:20 p.m. in International 6-7

Spotlight: Using abstraction to gain knowledge from numbers | 3:20 p.m. in International 8-9

Risk adjustment basics | 3:20 p.m. in International 10

No tipsheet available

GitHub 201: Leveling up with the command line | 3:20 p.m. in M102

Analyzing networks with Gephi | 3:20 p.m. in M106

Playing with Arduino | 3:20 p.m. in M107

Mapping JS: Building narrative with geo data + CartoDB | 3:20 p.m. in M109

SATURDAY

This just in: Data for breaking news | 9 a.m. in International 2-3

Processes, standards and documentation for data-driven projects | 9 a.m. in International 4-5

Design/Viz: What to do, and what not to do | 9 a.m. in International 6-7

Getting it the rightest you can | 9 a.m. in International 8-9

Defense against the dark arts: Security for you and your sources | 9 a.m. in International 10

No tipsheet available

Ruby 1: Introduction | 9 a.m. in M101

Advanced Fusion Tables | 9 a.m. in M105

No tipsheet available

No tipsheet available

Do more in R with these useful new packages | 9 a.m. in M106

Create your own interactive newsgame without coding | 9 a.m. in M107

Sensor journalism: Buzz or BS? | 10:10 am in International 2-3

How to build a happy team | 10:10 a.m. in International 4-5

No tipsheet available

(Keep) following the money on state and local politics | 10:10 a.m. in International 6-7

No tipsheet available

Social media sleuthing | 10:10 a.m. in International 8-9

Building mobile-ready visualizations and maps in minutes with Silk | 10:10 a.m. in International 10

Ruby 2: Acquiring and transforming data | 10:10 a.m. in M101

No tipsheet available

Text editing with Regular Expressions | 10:10 a.m. in M103

No tipsheet available

Advanced Python for data analysis: Part 1 | 10:10 a.m. in M104

No tipsheet available

Advanced SQL for analysis | 10:10 a.m. in M 105

R: Preplication | 10:10 a.m. in M106

Municipal bonds 101 | 10:10 a.m. in M107

Tools for cracking PDFs | 10:10 a.m. in M109

Deep dive: Philip Meyer Award winners | 11:20 a.m. in International 2-3

Go home and share your work! | 11:20 a.m. in International 4-5

No tipsheet available

Making data-informed design decisions | 11:20 a.m. in International 6-7

Policing the police | 11:20 a.m. in International 8-9

Intermediate/Advanced Security | 11:20 a.m. in International 10

Ruby 3: Simple web apps with Ruby | 11:20 a.m. in M101

Advanced Python for data analysis: Part 2 | 11:20 a.m. in M104

Under pressure: Real life in real time with breaking news | 11:20 a.m. in M106

Machine learning | 11:20 a.m. in M107

No tipsheet available

So they bought a federal candidate, now what? | 2:10 p.m. in International 2-3

Catching fire: Spreading data journalism throughout the newsroom | 2:10 p.m. in International 4-5

Spotlight: Talking about uncertainty | 2:10 p.m. in International 6-7

Data negotiation: To FOIA or not to FOIA | 2:10 p.m. in International 8-9

How to draw the Internet: Better interactives through paper prototyping | 2:10 p.m. in International 10

No tipsheet available

Introduction to mapping: Importing and displaying data geographically with QGIS | 2:10 p.m. im M102

Getting started with Python | 2:10 p.m. in M104

No tipsheet available

Mini Boot Camp – Access

No tipsheet available

Automate your development life: Build and deploy with Yeoman and Grunt | 2:10 p.m. in M106

No tipsheet available

Twitter Bootstrap: Responsive website framework | 2:10 p.m. in M107

Getting started with SQLite | 2:10 p.m. in M109

No tipsheet available

Getting started with machine learning | 3:20 p.m. in International 2-3

Data smells | 3:20 p.m. in International 4-5

50 ideas in 60 minutes | 3:20 p.m. in International 6-7

Flying solo: When your data “team” is just you | 3:20 p.m. in International 8-9

Visualization for reporting | 3:20 p.m. in International 10

Mapping 2: Manipulating and editing geographic data with QGIS | 3:20 p.m. in M102

Python 2 | 3:20 p.m. in M104

No tipsheet available

Reporting and presentation with DocumentCloud | 3:20 p.m. in M106

No tipsheet available

Summing and grouping in SQLite | 3:20 p.m. in M109

No tipsheet available

Editing the data story | 4:30 p.m. in International 2-3

Reporting out the data story | 4:30 p.m. in International 4-5

No tipsheet available

Mise en Place: What a restaurant kitchen can teach us about deadline coding | 4:30 p.m. in International 6-7

No tipsheet available

How not to make a fool of yourself with statistics | 4:30 p.m. in International 8-9

No tipsheet available

On repeat: How to use loops to explain anything | 4:30 p.m. in International 10

No tipsheet available

Web Inspector for complex scrapes | 4:30 p.m. in M102

Python 3 | 4:30 p.m. in M104

No tipsheet available

Advanced Python | 4:30 p.m. in M107

Joining and advanced operations in SQLite | 4:30 p.m. in M109

No tipsheet available

 

SUNDAY

The best of broadcast investigations 2014 | 9 a.m. in International 6-7

No tipsheet available

Game of your life: Data from day one to the day you die | 9 a.m. in International 8-9

No tipsheet available 

Shedding light on the dark web: Using tech to build corporate investigations | 9 a.m. in International 10

No tipsheet available

Lightning fast data analysis with Tableau: Part 1 | 9 a.m. in M101

Just enough Django: Distributed data entry in the newsroom | M102

Excel en Espanol | M103

No tipsheet available

Advanced SQL using PostgreSQL | 9 a.m. in M104

Mini Boot Camp | M105

No tipsheet available

Deep dives | 10:10 am in International 6-7

Finding data trails | 10:10 a.m. in International 8-9

No tipsheet available

Using machine learning to deal with dirty data: A Dedupe demonstration | 10:10 a.m. in International 10

Lighting fast data analysis with Tableau: Part 2 | 10:10 a.m. in M101

Making your own Yo bot | 10:10 a.m. in M104

Using Silk.co to analyze data and publish beautiful maps and charts in minutes | 10:10 a.m. in M106

No tipsheet available

Career roundtable | 11:20 a.m. in International 6-7

No tipsheet available

Mining searchable databases for stories | 11:20 a.m. in International 8-9

No tipsheet available 

Advanced DocumentCloud: Examples and suggestions | 11:20 a.m. in International 10

No tipsheet available

CAR wash | 11:20 a.m. in M104

No tipsheet available

Take home a text editor | 11:20 a.m. in M109

No tipsheet available