Tipsheets and tutorials
Session materials from panels, demos and hands-on classes at the 2013 CAR Conference. Were you a CAR 2013 speaker with materials we don't yet have on this list? Send them to web editor Tony Schick at tony@ire.org or resource center director Laurent Grandestaff at lauren@ire.org.
THURSDAY
Tableau Public for beginners and pros -- 9 a.m. to 5 p.m. in Seneca/Iroquois
Information design and crossing the digital divide -- 9 a.m. Regency North
Getting started: digging deep with data journalism -- 9 a.m. in Regency Center
- Download the tipsheet from presenter Jill Riepenhoff
- View Jill Riepenhoff's slides
- View Jaimi Dowdell's presentation
Exploratory data analysis -- 9 a.m. in Regency South
Newscamp::Data science for nerdy journalists -- 9 a.m. in Keeneland
- See speaker Hadley Wickham's course materials here
- Download a paper from speaker Hadley Wickham about tidy data
- CAR attendee Sisi Wei made her notes from Hadley Wickham's R session available here.
My friend FRED: Using Fed data tools to add context to stories -- 9 a.m. in Churchill Downs
FOIA Machine -- 10 a.m. in Churchill Downs
- Access the new tool on display here, or find out more about it in the about section here
- View the presentation here
Waste investigations for any community -- 10 a.m. in Regency Center
- Access Erin Jordan's slides
- Access Tim Eberly's slides
- Access Josh Sweigart's slides
- View the food waste data
Web tools for investigators -- 11 a.m. in Regency South
Down and dirty with the DocumentCloud API -- 11 a.m. in Churchill Downs
The data-driven story part 1: conceiving and launching -- 11 a.m. in Regency Center
Bringing Excel to the web with Excel 2013 and SkyDrive -- 2 p.m. in Churchill Downs
Dig deeper with social tools -- 2 p.m. in Regency South
The data-driven story pt. 2: Putting the package together -- 2 p.m. in Regency Center
Mobile + DataViz: Friends or frenemies? -- 2 p.m. in Regency North
The data-driven story part 3: bulletproofing and presentation -- 3 p.m. in Regency Center
Wrangling web data with Google docs: beginner course -- 3 p.m. in Churchill Downs
- View the slides from speakers Sean Sposito and Acton Gordon
- View slides Ted Han and Sean Sposito put together demystifying web scraping for IRE 2013
- An online guide from Sharon Machlis at Computerworld about automatically updating a Google Spreadsheet
Practical machine learning: Tips, tricks and real-world examples for machine learning in the newsroom - 3 p.m. in Regency North
Hone your Fusion Tables training skills -- 4 p.m. in Regency Center
No complaints: Navigating the New American Fact Finder, improvements and updates -- 4 p.m. in Churchill Downs
FRIDAY
Intro to SQLite -- 9 a.m. in Kentucky Suite
Excel 1 -- 9 a.m. in Shawnee-Cherokee
Build your first news app with Django -- 9 a.m. in Seneca/Iroquois
Those dastardly PDFs -- 9 a.m. in Regency North
Year in CAR -- 9 a.m. in Regency Center
Intro to programming in Ruby -- 10 a.m. in Kentucky Suite
Inspect this -- 10 a.m. in Regency Center
Excel 2 -- 10 a.m. in Shawnee-Cherokee
Introduction to text editors -- 10 a.m. in Gulfstream/Hialeah
Data viz on a shoestring -- 10 a.m. in Regency South
CAR on the beat -- 11 a.m. in Regency South
Is 911 a joke in your town? -- 11 a.m. in Regency Center
Intro to Javascript the right way -- 11 a.m. in Kentucky Suite
Covert reporting using technology to cover your tracks -- 11 a.m. in Regency North
Beyond the scoreboard: Using data to investigate sports -- 2 p.m. in Regency Center
Data on the fly: real-time news coverage -- 2 p.m. in Regency South
Excel Magic: Advanced functions for data cleaning and more -- 2 p.m. in Keeneland
- See speaker MaryJo Webster's list of favorite excel things
- Attendee Emma Carew Grovum made her notes on this class available here
Twitter mecahnics, strategy and apps -- 2 p.m. in Gulstream/Hialeah
- See Doug Haddix's tips for using Twitter advanced search
- View Doug Haddix's slides on apps and tools
- Read Doug Haddix's Twitter handout sheet
Using OpenRefine to clean and explore dirty data -- 3 p.m. in Keeneland
Disasters: Preparing for and digging in after the storm -- 3 p.m. in Regency Center
How to serve mad traffic -- 3 p.m. in Churchill Downs
Stats in Excel -- 4 p.m. in Keeneland
Computer Science 101: How to speak the language of the people who speak computer -- 4 p.m. in Regency South
Lightning Talks -- 4 p.m. in Regency Center
- How coding can make you a better reporter, presented by Ben Welsh
- ILENE, presented by Jeff Larson and Jennifer LaFleur
- News games, presented by Sisi Wei
- Be your own Nate Silver, presented by Jeff Larson
- Dude, who stole my congressman. presented by Paul Parker
- Data from Dude, who stole my congressman
- Z-Scores: How you can compare apples with oranges by Robert Gebeloff
- 5 algorithms in 5 minutes by Chase Davis
SATURDAY
The great divide: Investigating income inequality -- 9 a.m. in Regency Center
Discovery, validation, publication: How to be ready for your social media Sandy -- 9 a.m. in Churchill Downs
How can we get the widest impact out of technology projects? -- 9 a.m. in Regency North
Inside baseball: What data journalism can learn from sports -- 10 a.m. in Regency North
The one-query story: Quick hits for your newsroom -- 10 a.m. in Regency Center
Building data-driven beats -- 9 a.m. in Regency South
Scraping with Node.js -- 11 a.m. in Kentucky suite
How to edit a news app -- 11 a.m. in regency south
Developing reusable visualization components using D3 and Backbone -- 11 a.m. in Churchill-Downs
Dashboards for reporting -- 11 a.m. Regency North
Data tactics for the well-rounded business reporter -- 11 a.m. in Regency Center
Infect the CMS -- 2 p.m. in Regency North
Dodging disasters: How to avoid making errors with data -- 2 p.m. in Regency South
Git and Github: Learning to commit to version control -- 2 p.m. in Keeneland
Python programming for the rest of us 1, 2, 3 --2 p.m. in Kentucky Suite
Python programming for the rest of us 2: Database connections -- 3 p.m. in Kentucky Suite
Finding stories in health data -- 3 p.m. in Regency Center
- Download Charles Ornstein's tipsheet
- Download Charles Ornstein's presentation
- David Donald's slides
- Michael Pell's slides
(Way) beyond charts: Making interactives fun -- 3 p.m. Regency North
Making timelines -- 3 p.m. in Gulfstream/Hialeah
Connecting the dots with NodeXL -- 4 p.m. in Gulfstream/Hialeah
Campaign finance the data science way -- 4 p.m in Regency North
Data journalism around the globe -- 4 p.m. in Regency South
Mapping best practices -- 9 a.m. in Regency Center
Finding data online -- 11 a.m. in Regency South
Mapping in ArcView