Summer School 2006

The 2006 CIJ Investigative Journalism Conference and Summer School was held on the 21-23 July at City University, London. For the first time in the summer school's history, workshops on data journalism and Computer Assisted Reporting (CAR) ran parrallel with lecturers and talks, allowing attendees the opportunity hone their data skills under expert guidance and supervision.

Speakers

Speakers included:

Anna Politkovskaya, the late Russian journalist and human rights activist, Aron Pilhofer, Associate Managing Editor for Digital Strategy at The New York Times, and Chuck Lewis, investigative journalist and founder of The Centre for Public Integrity.

The summer school featured guest lectures and workshops by, amongst others, Philip Conway, Andrew Gilligan, Raj Bairoliy, Alexenia Dimitrova, Martin Tomkinson, Stephen Grey, Fredrik Laurin, Gordana Igric, Alfred McCoy, Mike Moran, Heather Brooke, Luc Hermann, Andre Verloy, Ben Goldacre, Mark Hunter, Jeff Katz, David Leigh and Phillip Knightley.

Timetable

Lectures and Workshops

Friday 21 July

 

09:00-09:15

Introduction

Gavin MacFadyen, Director of the CIJ, and Sue Robertson, Dean of the School of Arts, City University, London

09:15-10:15

Overview of Computer Assisted Reporting (CAR)

Aron Pilhofer

10:30-11:30

Media Law

Philip Conway

Monitoring Charities

Andrew Gilligan

13:00-14:00

Lunch

14:00-15:15

The Poisoning of Children

Anna Politkovskaia

15:00-16:45

Business: Profit and Loss

Raj Bairoliy

How to Use Secret Archives

Alexenia Dimitrova

17:00-18:15

Business: Balance Sheets

Raj Bairoliya

Illegal organ transplants: Israel-Bulgaria

Elena Kodinova (Session Chaired by David Leigh)

 

Saturday 22 July

 

09:00-10:00

Business: Company Notes

Raj Bairoliya

10:10-11:30

Business: UK Documents

Martin Tomkinson

Business: Off-Shore Documents

Jeff Katz

Business: Homework and Q&A

Raj Bairoliva

11:45-13:00

Extraordinary Rendition

Stephen Grey and Fredrik Laurin

Evaluating Experts 1: Spinning Health – Pharmaceutical Fraud, Lying and Selling Disease

Luc Hermann

 

Lunch

14:00-15:00

Chuck Lewis

15:15-16:30

Evaluating Experts 2: Torture

Anna Politkovskaia, Gordana Igric and Alfred McCoy

16:45-17:45

Covert Recording

Mike Moran

An Organised Crime State: Trans-Dniester, a Cross-Border Investigation

Stefan Candea (Session Chaired by David Leigh)

18:00-19:00

Freedom of Information Acts

Heather Brooke, Luc Hermann and Andre Verloy

19:00-21:00

Drinks Party

 

Sunday 23 July

 

09:00-10:15

Writing Investigations

Mark Hunter

10:30-11:45

How to Avoid Being Conned

Jeff Katz, Mark Hunter and Rosie Waterhouse

12:00-13:00

Corruption: Contracts

Neill Stansbury

13:00-14:00

Lunch

14:00-15:15

Evaluating Experts 3: Bad Science

Ben Goldacre and Brian Deer

17:00-18:00

Evaluating Experts 4: Spies

Phillip Knightley, Mark Hosenball, Alfred McCoy and David Leigh

Computer Assisted Reporting (CAR) Sessions

Friday 21 July

 

 

CAR Track 1

CAR Track 2

Internet Track 1

09:00-10:15

Overview of Computer Assisted Reporting (CAR)

Aron Pilhofer

 

 

10:30-11:30

Excel 1: Formulas and Calculations

David Donald

Access 1: Understanding Databases

Aron Pilhofer

Search With a Strategy

Tommy Kass

11:45-13:00

Excel 2: Importing and Cleaning

David Donald

Access 2: Find the Needle in the Haystack

Aron Pilhofer

 

14:00-15:15

Anna Politkovskaia

(See main conference programme)

15:30-16:45

Excel 3: Data Manipulation

David Donald

Access 3: Understanding Databases

Aron Pilhofer

Electronic Tools for Journalists

Fredrik Laurin

 

Saturday 22 July

 

 

CAR Track 1

CAR Track 1

Internet Track

09:00-10:10

Mapping 1: X-Point

Michael Holm

 

10:15-11:30

Mapping 2: ArcView Demo

Michael Holm

Using Statistics to Dig Deeper

David Donald

Validate the Web

Tommy Kass

11:45-13:00

Access 1: Understanding Databases

Aron Pilhofer

Excel 1: Formulas and Calculations

David Donald

Google’s Hidden Power

Tommy Kass

14:00-15:00

Chuck Lewis

(See main conference programme)

15:30-16:55

Access 2: Find the Needle in the Haystack

Michael Holm

Excel 2: Importing and Cleaning

David Donald

The Web as a Collaboration Tool

Aron Pilhofer

16:45-18:00

Access 3: Summarising Data – Find the Story

Michael Holm

Excel 3: Data Manipulation

David Donald

News Factory: Introduction to RSS

Ben Hammersley

 

Sunday 23 July

 

 

CAR Track 1

CAR Track 1

Internet Track

09:00-10:15

Overview of Computer Assisted Reporting (CAR)

David Donald

 

Skills Students Need To Work in the Online World

Ben Hammersley

10:30-11:45

Excel 1: Formulas and Calculations

David Donald

Doing CAR with Open Source

Aron Pilhofer

Research on Hidden Pages

Tommy Kass

12:00-13:00

Excel 2: Importing and Cleaning

David Donald

Access 1: Understanding Databases

Michael Holm

One-on-one: What’s Next For Your CAR Skills

14:00-13:05

Alfred McCoy and Dr Mary E. McCoy

(See main conference programme)

15:30-16:45

Excel 3: Data Manipulation

David Donald

Access 2: Find the Needle in the Haystack

Michael Holm

One-on-one: What’s Next For Your CAR Skills

17:00-18:00

Pulling Data Off the Web

Tommy Kass

Access 3: Summarising Data – Find the Story

Michael Holm

One-on-one: What’s Next for your CAR Skills

Talks and Training

The Poisoning of Children (keynote)
The late investigative reporter Anna Politkovskaia on the alleged mass poisoning of school children in Chechnya.

Corruption: Contracts
Neill Stansbury’s talk on investigating corruption and identifying key players through the paper trail.

How to Avoid Being Conned
Jeff Katz, Mark Hunter and Rosie Waterhouse on cross-referencing information from sources and the importance of verifying documents.

Evaluating Experts: Bad Science
Ben Goldacre, author of Bad Science, discusses the mainstream media's reporting on health and science issues.

Extraordinary Rendition
Stephen Grey and Fredrik Laurin on the hidden global networks allowing the apprehension and extrajudicial transfer of people into detainment camps.