Please Note: The CAR PowerPoint, along with the general CAR guide and Excel Filters and Pivot Tables handouts, below were all updated for the “CAR for Business Journalist” workshop, which was held at SABEW’s annual conference on March 15, 2012. A new handout, “Importing HTML to Excel,” was provided following the free, pre-conference workshop.
WHAT YOU WILL LEARN
- Find and download online databases.
- How to use Excel spreadsheets to analyze that information. No previous experience with Excel is expected.
- How to translate that analysis into business stories.
Jaimi Dowdell joined IRE as a training director in October 2008. She taught this workshop in Atlanta and Milwaukee in 2010. Before joining IRE, she was computer-assisted reporting editor at the St. Louis Post-Dispatch for more than three years. Her duties included obtaining and analyzing data for daily and long-term stories; training staff on CAR and investigative techniques; and maintaining the newspaper’s online data center. In addition to her work at the Post-Dispatch, she taught a CAR course for Washington University in St. Louis.
Take a look through the workshop session recording and resources below. At your own pace, you can walk through the self-guided lesson on how to best utilize online databases and tools for business journalism investigations.
Jaimi Dowdell also worked at IRE and NICAR in the Database Library and Resource Center while completing her master’s degree at the University of Missouri.
- "Be a Better Business Watchdog - Handout" (PDF)
- Getting Around Excel (PDF)
- Excel Formulas -- A Quick List (PDF)
- Sorting Lists with Excel (PDF)
- Excel Filters and Pivot Tables (PDF)
- Importing HTML to Excel (PDF) -- These instructions only work for Excel in Windows. Stackoverflow.com suggests saving webpages as HTML documents and opening them in Excel for automatic mapping. Please note that auto-mapping is not always successful.