(Rec) indicates that the session was recorded.

You can attend any class in any strand. Please note, however, that some classes form mini-strands and are best attended as a whole. 

Biographies for all our speakers can be found on the Summer School speaker page.

More Information
Tel: 020 7040 8220
Email: marina@tcij.org

Friday 6 July          
08.45 - 09.30 Registration, tea and coffee Great Hall Foyer      
09.30 - 10.00 Welcome by Gavin MacFadyen, Director of the CIJ  Great Hall       
           
  Talk 1 - Room AG08 Talk 2 - Room AG09 Talk 3 - Room AG07 CAR 2 - Room A308 CAR 3 - Room AG35A+B
           
10.10 - 11.20 Understanding Company Accounts: How to Get the Most of Companies House Martin Tomkinson and Robert Miller Libel and Privacy Law Philip Conway and Justin Walford How do Investigative Stories Get Commissioned? David Leigh and Iain Overton (Rec) CAR Intro: Start here if you are New to CAR (B) David Donald  
           
11.40-12.50 Understanding Company Accounts: Profits and Losses Raj Bairoliya Miscarriages of Justice: The Case of Sam Hallam Paul May and Matt Foot. (Rec) From Ian Tomlinson to Jimmy Mubenga: Investigating in the Open Paul Lewis Excel 1: the Power of Data Analysis for Stories (B), Hands-on.  Alex Ascherson and Luuk Sengers Document Cloud (A), Hands-on Aron Pilhofer
           
12.50 - 14.00     Lunch    
14.00 - 15.10 Keynote: Lessons from Leveson: Do Investigative Journalists Need to Behave Differently? (Rec) David Leigh, Charlotte Harris, Martin Bright, Brian Cathcart. Chaired by Gavin MacFadyen. Great Hall  
           
  Talk 1 - Room AG08 Talk 2 - Room AG09 Talk 3 - AG07 CAR 2 - Room A308 CAR 3 - Room AG35A+B
           
15.25 - 16.35 Understanding Company Accounts: Assets and Liabilities Raj Bairoliya Statistics and How to Interpret Them Ed Swires-Hennessy. (Rec) Reporting the Riots: Twitter, Data and BBM Simon Rogers and Paul Lewis Excel 2: Finding the Patterns in the Data (B)  Hands-on Alex Ascherson and Luuk Sengers Web Detective Paul Myers
           
16.50 - 18.00 Understanding Company Accounts: The Small Print and Q&A Raj Bairoliya Communicating with Statistics Ed Swires-Hennessy (Rec) Reading the Riots: A Collaborative Investigation Simon Rogers and Paul Lewis Excel 3: Summarising your Data for the Big Picture (B) Hands-on Alex Ascherson and Luuk Sengers Intro to Web Scraping (A) Hands-on, Aron Pilhofer
18.15 -21.00 Drinks Reception College Common Room      

Saturday 7 July          
  Talk 1 - Room AG08 Talk 2 - Room AG09 Talk 3 - Room A220 CAR 2 - Room A308 CAR 3 - Room AG35A+B
           
09.00 - 10.10 Story-based Inquiry 1. A Method Through the Madness: how Hypotheses Frame and Sell your Story Mark Lee Hunter Understanding Company Accounts - An Interactive Demonstration  Raj Bairoliya Getting CAR Right (B), Best Practice and First Efforts Kathryn Torney and David Donald. (Rec)   Excel 1: the Power of Data Analysis for Stories (B) Hands-on Alex Ascherson and Elena Egawhary
           
10.25 - 11.35 Story-based Inquiry 2. The Hidden Scenario: Using Timelines and Characters to Advance your Story Luuk Sengers Privacy Law Gavin Millar QC What to do when there is no Data - Sampling and Building databases (A) Hands-on David Donald Interactive Data: Lessons from the New York Times (A). Aron Pilhofer Excel 2: Finding the Patterns in the Data (B) Hands-on Alex Ascherson and Elena Egawhary
           
11.50 - 13.00 The Olympics: Look who's Coming to London Andrew Jennings Access Information on Social Networking Sites Neil Smith Story-based Inquiry 3. Take Control: Making and using Masterfile Luuk Sengers Access 1: Understanding Databases (B), Hands-on Aron Pilhofer and Jonathan Stoneman Excel 3: Summarising your Data for the Big Picture (B), Hands-on, Alex Ascherson and Elena Egawhary
           
13.00 - 14.10     Lunch    
  Talk 1 - Room AG08 Talk 2 - Room AG09 CAR 1 - Room A220 CAR 2 - Room A308 CAR 3 - Room AG35A+B
14.10 - 15.20 Story-based Inquiry 4. Writing an Investigation: the Last (and First) Hurdle Mark Lee Hunter Access Information on Databases Neil Smith    Access 2: Digging for the Story (B), Hands-on Aron Pilhofer and Jonathan Stoneman Excel 4: Statistics for Journalists (B) Hands-on David Donald
           
15.35 - 16.45 Independent Investigative Journalism: Starting your own Organisation Natalia Viana. (Rec) Understanding Company Accounts: How Companies Avoid Tax Richard Brooks Data Visualisation 1: Principles and Spreadsheet Tools for Finding Visual Patterns in your Data (B) Hands-on David Donald Access 3: Joining Databases for Deeper Analysis (B), Hands-on Aron Pilhofer and Jonathan Stoneman Importing Data (B) Hands-on Elena Egawhary.
           
17.05 - 18.15 Keynote: What's Wrong With the NHS (Rec) Dr Phil Hammond  Great Hall    

Sunday 8 July          
  Talk 1 - Room AG 08 Talk 2 - Room AG 09 CAR 1 - Room A220 CAR 2 - Room A308 CAR 3 - Room AG35A+B
           
10.00 - 11.10 Secrets of the Banking Capital of the World Jean Francois Tanda How to do Courts Reporting and get the Best Stories Paul Cheston, Gavin Millar QC. (Rec) Data Visualisation 2: Fusion Tables(A) Hands-on Aron Pilhofer and Alastair Dant
 
SQL 1 (A), Hands-on David Donald and Alex Ascherson Excel 1: the Power of Data Analysis for Stories (B) Hands-on Jonathan Stoneman and Caelainn Barr
           
11.25 - 12.35 Covert reporting. Luke M.  Getting Scoops from the Local Councils Paul Francis and Ted Jeory Understanding Public Accounts Sally Gainsbury SQL 2 (A), Hands-on David Donald and Alex Ascherson Excel 2: Finding the Patterns in the Data (B), Hands-on Jonathan Stoneman and Caellain Barr
           
12.50 - 14.00 How the Spindoctors took over the BBC (and how we can beat them) Andrew Jennings How to Request Documents under the Freedom of Information Act Brendan Montague and Lucas Amin. (Rec) The Future of Data Journalism, Demo Aron Pilhofer and Alastair Dant  Social Network Analysis: Using NodeXL to analyse Social Networks (A) Hands-on David Donald Excel 3: Summarising Your data for the Big Picture (B), Hands-on Jonathan Stoneman and Caelainn Barr
           
14.00 - 15.10     Lunch    
           
  Talk 1 - Room AG08 Talk 2 - Room AG09 CAR 13 - Room A220 CAR 2 - Room A308 CAR 3 - Room AG35A+B
           
15.10 - 16.20 The World of Corporate Investigations and the Practice of Due Diligence Jeff Katz Removing Memory from Special Forces Soldiers in South Africa, and the Effect of PTSD on Soldiers and Journalists with Pieter Jooste and Andrew Bousfield (Rec) Copyright and Data Security: Key Issues for Journalists Richard Orange   What's next? Ideas, Trends and Practices (B) David Donald and Luuk Sengers
           
16.40 - 17.50 Keynote - Uncovering Corruption Sheila Coronel Great Hall    
           
17.50 - 17.55   Thank you and goodbye