Hand-outs and plans for data track at Global Investigative Journalism Conference in Kiev

Program for the conference

Hands-on training

Sarah Cohen on timelines

Internet

Albrecht Ude: Surfing anonymously and unfiltered

Albrecht Ude: Searching people

Yahoo Pipes

Paul Bradshaw on Yahoo Pipes

http://onlinejournalismblog.com/2008/07/16/how-to-create-basic-mashups-with-yahoo-pipes/

http://onlinejournalismblog.com/2009/12/18/how-to-create-a-custom-meta-search-in-yahoo-pipes/

Excel-training:

Luuk Sengers and John Bones: Excel 1
Luuk Sengers and John Bones: Excel 2
Extra material from Jennifer LaFleur

Google Fusion:

Jennifer LaFleurs material

Hand-out on polygons – Exercise.

Google Refine:

Combining data with Refine

Cleaning data with Refine
http://onlinejournalismblog.com/2011/07/05/cleaning-data-using-google-refine-a-quick-guide/

http://onlinejournalismblog.com/2011/04/14/data-for-journalists-json-for-beginners/

http://onlinejournalismblog.com/2011/03/18/getting-full-addresses-for-school-data-in-an-foi-response/

http://onlinejournalismblog.com/2011/09/09/how-to-use-the-cablesearch-api-to-quickly-reference-names-against-wikileaks-cables/

http://onlinejournalismblog.com/2011/07/22/how-to-grab-useful-political-data-with-the-they-work-for-you-api/

http://blog.ouseful.info/2011/05/06/merging-datesets-with-common-columns-in-google-refine/

Chase Davis on Google Refine API

Site on Google Refine with tutorials

Panels:

Crowdsourcing
Crowdsourcing

Sebastian Mondial: Advices for crowdsourcing

Nils Mulvad: New methods for covering events and investigative journalism melt together
Nils Mulvad: Crowdsourcing in investigative journalism.

Apps for investigations
Nils Mulvad: Some Apps for investigations
Story-based inquiry
English: Story-based inquiry

Russian: Story-based inquiry

Presentation of Story-based inquiry in Kiev

Access to data

DATA FLOOF IN INDIA AFTER RTI
David Smallmans handout 1
David Smallmans handout 2

Wikileaks

Andy Lehrens presentation on Wikileaks
Jan Gunnar Furelys presentation on Wikileaks
Musikilu Mojeeds presentation on Wikileaks
David Leighs presentation on Wikileaks
Jan Michael Ihls presentation: How can journalists and leakers trust each other again

Some other material

Giannina Segnini on CAR-methods

Sarah Cohen on textmining

Sarah Cohen and Aron Pilhofer on vizualisation

Andy Lehren: Social Media Tools

James Grimaldi: Multimedia

Bo Elkjærs presentation

Frédéric Zalac, Serena Tinari and Susanne Reber on Investigating Big Pharma

Arms smuggling – TRILOGY In the Name of the State – Matej Surc, Blaz Zgaga – Slovenia
(Maps in this presentation are copyrighted by Sanje Publishing House, Ljubljana, Slovenia. www.sanje.si)

Tracking the billions – with O’Murchu and Shleynov – presentation 1
Tracking the billions – with O’Murchu and Shleynov – presentation 2

Chief Bisong Etahoben: THE KILLING SOCCER STORY

Ana Aranas presentation

Result of group thinking – lots of good tips

Advice from Albrecht Ude on New Tools for Today’s Investigative Journalist.