CAR Training Materials 2011

Global Investigative Reporting Conference, Kyiv:

• Tipsheet: Google Fusion Level 1
• Tipsheet: Google Fusion Level 2
• Powerpoint: When there is no data (with Helena Bengtsson)
• Data: Life expectancy by country
• Data: US foreign lobbying
• Data: Nursing homes
• Data: Restaurants
• Visualizing

Tipsheets:

• CAR overview
• Stats for reporting with David Donald
• Logistic regression in SPSS
• Annotated logistic output
• Excel quick tips
• Excel exercises
• Access quick tips
• Access exercises
• Bulletproofing your analysis
• The power of maps

More information from IRE

Powerpoints:

• FOIA basics - STL BWW
• The document (and data) state of mind - STL BWW
• Stats the way we like them (and the jingle)
• Car overview
• 50 ideas in 50 minutes
• Mapping

Teaching and training CAR:

• Training tips for the newsroom
• Training models for the newsroom
• Newsroom CAR skills survey
• Syllabus - Texas Christian University
• Syllabus - University of Missouri
• Syllabus - American University
• Syllabus - American University graduate school

Mapping data sets

• Mapping 1 - Basic maps with ArcView
• Mapping 2 - Layers
• Mapping 3 - Geocoding
• Mapping 4 - Projections and datum oh my
• West Wing and projections
• Who's in Danny's room

Practice data sets (note many of these are extracts of larger databases or have been edited - do not use for stories!!!)

Excel:
City budget
U.S. Tourism by country
Texas county by county populations
ICE removals
Baseball salaries
High school coach salaries
DolososAmericaLatina
Deer records
Download soccer standings

Access:
Hunting accidents
Zoo disposition of animals – U.S.
Latin American zoos
NEA Grants
Amusement park accidents


Downloading data from the Web:
Texas marriage licenses