Timetable 2009

Friday 17 July
 
8.30 - 9:15 Registration and refreshments First floor foyer, near Great Hall
9.15 – 9:30 Welcome Gavin MacFadyen, Director CIJ Great Hall
9.30 - 10.10 Brief introductions to Computer Assisted ReportingUnderstanding Company Accounts, and East Meets West Great Hall
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training Room AG35 A&B
10.20 - 11.30
Understanding company accounts 1: How to get the Most out of Companies House Martin Tomkinson and Robert Miller Wikileaks: Source protection, spies, lies and lawsuits on journalism's high frontier Julian Assange CAR A-Z Excel 1: The power of data analysis for stories (B), Hands on Cynthia O'Murchu and Elena Egawhary Car Intro (B), Demo David Donald and Aron Pilhofer No session
11.40-12.50
Understanding company accounts 2: Profits and Losses Raj Bairoliya Libel and privacy law Philip Conway and Justin Walford CAR A-Z Excel 2: Finding patterns in the data (B) Hands-on Cynthia O'Murchu and Elena Egawhary Internet 101 (B), Hands-on David Donald Access 1: Understanding databases (B), Hands-on Jennifer LaFleur and Aron Pilhofer
12.50 - 14.00 Lunch
14.00 - 15.10 Investigative Journalism and Satire as a Method Ian Hislopchaired by Melanie McFadyeanGreat Hall OPEN TO THE PUBLIC
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
15.20 – 16.30
Understanding company accounts 3: Assets and Liabilities Raj Bairoliya The Emerging New Investigative Journalism Ecosystem Chuck Lewis chaired by Gavin MacFadyen. CAR A-Z Excel 3: Summarising your data for the big picture (B), Hands-on Cynthia O'Murchu and Elena Egawhary Beyond the search engine (B), Hands-on David Donald Access 2: Digging for the story (B), Hands-on Jennifer LaFleur and Aron Pilhofer
16.40 – 17.50
Understanding company accounts 4: The Small Print and Q&A Raj Bairoliya East Meets West: Brigitte Alfter Cross-border reporting and networking... CAR A-Z Importing Data to Excel (B), Hands-on David Donald A guide to automated web browsing (A), Demo Mike Schrenk Access 3: Joining databases for deeper analysis (B), Hands-on Jennifer LaFleur and Aron Pilhofer
Saturday 18 July
 
8.30 Tea and coffee
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
09.00-10.10
Defamation and Privacy: A Tale of Two Businessmen Gavin Millar QC East Meets West: Fight against corruption... CAR A-Z Access 1: Understanding databases (B), Hands-on Aron Pilhofer Excel 1: The power of data analysis for stories (B), Hands on James Ball and Jennifer LaFleurDavid Donald No session
10.20-11.30
Conducting anonymous research Mike Schrenk East Meets West: Safe havens, dubious business practices and trafficking... CAR A-Z Access 2: Digging for the story (B), Hands-on Aron Pilhofer and David Donald Excel 2: Finding patterns in the data (B) Hands-on James Ball and Jennifer LaFleur Newsgathering Online (A), Demo Murray Dick
11.40-12.50
Beyond Google: Shoeleather journalism and stealing documents Andrew Jennings East Meets West: Investigating war crimes CAR A-Z Access 3: Joining databases for deeper analysis (B), Hands-on David Donald and Aron Pilhofer Excel 3: Summarizing your data for the big picture (B), Hands-on James Ball and Jennifer LaFleur Finding people online (A), Demo Murray Dick
12:50 - 14:00 Lunch
14.00 - 15.10 In Search of Truth: Power, the News Media and the Public's Right to Know Chuck Lewis Great Hall OPEN TO THE PUBLIC
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
15.20 - 16.30
Hypothesis-based investigation: managing your project Mark Hunter East Meets West: Upcoming European Championship in Ukraine MySQL 1 (A), Hands on Aron Pilhofer Importing data to Excel (B), Hands-on Elena Egawhary Social network analysis (B), Hands-on Jennifer LaFleur
 
16.40 – 17.50 East Meets West: Investigative cooperation speed dating Great Hall
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
16.40 - 17.50
Writing an investigation: the last (and first) hurdle Mark Hunter Practical approach to improving computer and Internet security and privacy, part I (Demo) Wojtek Bogusz My SQL 2 (A), Hands-on Aron Pilhofer Advanced CAR: CAR and statistics (A), Demo David Donald Freedom of Information Act for CAR (A), Demo Heather Brooke
 
18:00 - 20:00 Summer school drinks oarty in the foyer: delegates, speakers and cij board First floor foyer, near Great Hall
Sunday 19 July
 
8.30 Tea and coffee
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
09.00 - 10.10
SCOOP members meeting No Session CAR A-Z Q&A (A), Demo Jennifer LaFleur and Aron Pilhofer Practical approach to computer and Internet security and privacy Part II (workshop), (B), Hands-on Wojtek Bogusz Excel 4: Summarising your data for the big picture - statistics (B), hands-on David Donald
10.20-11.30
Exposing spin David Miller Hypothesis-based investigation: managing your project Mark Hunter Advanced CAR: Text mining: Seeing patterns in paragraphs and other unstructured text (A), Hands-on David Donald How to build a personal database for investigations Luuk Sengers Newsgathering online (A), Demo Murray Dick
11.40-12.50
Town Hall finance: investigating local authorities Richard Orange How to do covert filming Roddy Mansfield and others TBC Using CAR during a financial crisis (A), Hands-on David Donald Excel 1: The power of data analysis for stories (B), Hands on James Ball and Elena Egawhary Mapping for stories 1 (A), Hands-on Jennifer LaFleur
12:50 - 14:00 Lunch
14.00 - 15.10 Where legal bullying succeeds - and how to make it fail David Leigh Great Hall OPEN TO THE PUBLIC
Talks: Room AG08 Talks: Room AG09 Training: Room A308 Training: Room A220 Training: Room AG35 A&B
15.20 - 16.30
Investigating the economic crisis Ann Pettifor and Tony Hillier. Moderated by Paul Lashmar Corporate investigations and offshore jurisdictions Jeff Katz Freedom of Information Act for CAR (A), Demo Heather Brooke Excel 2: Finding patterns in the data (B) Hands-on James Ball and Elena Egawhary Mapping for stories 2 (A), Hands-on Jennifer LaFleur
16.40 – 17.50
MP Expenses and FOIA Heather Brooke The investigative reporter's toolkit Luuk Sengers Investigating a website Paul Myers Excel 3: Summarising your data for the big picture (B), Hands-on James Ball and Elena Egawhary Finding people online (A), Demo Murray Dick
 
18:00 - 18:20 Final announcements and thanks First floor foyer, near Great Hall