about summer school
directions
timetable
speakers
class information
hightlights

timetable

Below is the timetable for summer school 2011, for a more detailed decription of classes, click on the title.

Our keynote speakers for this year are: Kristinn Hrafnsson, Annie Machon, and Kathryn Bolkovac. Please note that Julian Assange is unable to attend this year. You can read a message from Julian on the main tcij.org website.

To read more about our speakers please click their name or visit the speakers page.

To reserve a place on the course please fill in the summer school booking form.

To view prices and ways of paying for your place, please check the about page.

The school is open to all.

more information
Tel: 020 7040 8220
Email: minal@tcij.org

Please note: This timetable is subject to change. (Rec) Indicates that the session will be recorded.

Friday 15 July

8.15 - 9.00	Foyer	Registrations, tea and coffee

9.00 - 9.30	Auditorium	Gavin MacFadyen, Director of the CIJ

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001
09.45 - 10.55	Understanding Company Accounts: How to Get the Most of Companies House Martin Tomkinson	Libel and Privacy Issues: Legal Update Andrew Bousfield and Justin Walford	CAR in the UK: an Introduction (B) Cynthia O'Murchu and Elena Egawhary	Media Legislation and Digital Freedoms (Rec) Smári McCarthy	Access 1: Understanding Databases (B) Hands-on Aron Pilhofer and Jennifer LaFleur

11.10-12.20	Understanding Company Accounts: How UK Companies Avoid Tax Richard Brooks and Richard Murphy	Investigative Journalism and Digital Technology - impacts, innovations and inspirations (Rec) Iain Overton and Gavin MacFadyen	Internet 101 (B)David Donald	Excel 1: Data Analysis for Stories (B) Hands-on James Ball and Luuk Sengers	Access 2: Digging for the Story (B) Hands-on Aron Pilhofer and Jennifer LaFleur

12.20 - 13.35	Lunch

13.35 - 14.45	Kristinn Hrafnsson- WikiLeaks - Auditorium

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001

15.00 - 16.10	Understanding Company Accounts: Profits and Losses Raj Bairoliya	Whistleblowing and the EU (Rec) Hans Martin Tillack	CAR in the Newsroom: Jumpstarting a CAR Programme (A) (Rec) Cynthia O'Murchu	Excel 2: Finding Patterns in the Data (B) Hands-on James Ball and Luuk Sengers	Access 3: Joining Databases for Deeper Analysis (B) Hands-on Aron Pilhofer and Jennifer LaFleur

16.25 - 17.35	Understanding Company Accounts: Assets and Liabilities Raj Bairoliya	What to do When There is no Data - Sampling and Building Databases (A) Jennifer LaFleur	Mapping and Visualisation for Story Gathering: Using Tableau (Rec) James Ball	Excel 3: Summarising Data for the Big Picture (B) Hands-on Cynthia O'Murchu and Elena Egawhary	Social Network Analysis (A) Hands-on David Donald

18.00 - 19.00	Panel - Hacking - David Leigh, Gavin Millar and Jeff Katz - Auditorium

Saturday 16 July

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001

09.00 - 10.10	Understanding Company Accounts: The Small Print and Q&A Raj Bairoliya	The Ikea Investigation - Tax Planning Through a World Wide Web of Companies Stellan Björk	Dreaming Data; Ideas for Investigations (B) Elena Egawhary and David Donald	Introduction to Statistics (A) Jennifer LaFleur	Excel 1: Data Analysis for Stories (B) Hands-on Cynthia O'Murchu and David Donald

10.25 - 11.35	Offshore Jurisdictions: Seek and Hide Martin Woods and Jeff Katz	Whistleblowing and the Law (1) (Rec) Gavin Millar QC and Dr Andrew Scott	Story-based investigation 1: Using hypotheses and chronologies to frame and advance your project. Mark Hunter and Luuk Sengers	Scraping Data with ScraperWiki (Rec) Anna Powell Smith and Nicola Hughes	Excel 2: Finding Patterns in the Data (B) Hands-on Elena Egawhary and David Donald

11.50 - 13.00	Using the Freedom of Information Act Rob Evans	Whistleblowing and the Law: a Hypothetical Case (2) Gill Phillips, Gavin Millar QC and Dr Andrew Scott	Story-based investigation 2: Creative Techniques. (Scenarisation and sourcemapping Mark Hunter and Luuk Sengers	Querying and Analysing Scraped Data in ScraperWiki Anna Powell Smith and Nicola Hughes	Excel 3: Summarising Data for the Big Picture (B) Hands-on Cynthia O'Murchu and Elena Egawhary

13.00 - 14.00	Lunch

14.00 - 15.10	Annie Machon - The Secret State and its Control of the Media - Auditorium

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001

15.25 - 16.35	Public Spending: NHS Case Study Sally Gainsbury	Using Twitter in Investigations (Rec) Paul Lewis	HBOS and the Lessons Learned(Rec) Paul Moore	Story-based investigation 3: practical tools. Using a research database and other record keeping software. Mark Hunter and Luuk Sengers	Excel 4: Statistics for Journalists (A)Hands-on David Donald

16.50 - 18.00	Offshore Financial Centres (Via Skype) David Marchant	Role of NGOs in Investigative Journalism (Rec) Panel: Gavin Hayman, Benedict Southworth, Faith Doherty and Paul Lashmar (chair)	Story-based investigation 4: Crafting the story - a continuous process. Mark Hunter and Luuk Sengers	Practical Information Security: Part 1 Wojtek Bogusz	Document Cloud (A) Hands-on (Rec) Aron Pilhofer

18.00 - 20.00	Drinks and Networking

Sunday 17 July

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001

10.00 - 11.10	Town Hall Finance: Investigating Local Authorities. Richard Orange Richard Orange	Interactive Data: Lessons From the New York Times (A) Aron Pilhofer	Web Tools for Data Visualisation (A) Jennifer LaFleur	Importing data (B) Hands-on Elena Egawhary	Practical Communication Security and Privacy: Part 2 Wojtek Bogusz

11.25 - 12.35	Exposing Spin Melissa Jones	Medical Whistleblowers Panel: Margaret Haywood, Eileen Chubb and Terry Bryan	Newsgathering online Graham Holliday	Access 1: Understanding Databases (B) Hands-on Aron Pilhofer and James Ball	Mapping for Stories 1 (A) Hands-on Jennifer LaFleur

12.50 - 14.00	Student Journalists and the Data Protection Regime (Rec) Richard Orange	Tunneling Under FIFA's Barbed Wire Andrew Jennings		Access 2: Digging for the Story (B) Hands-on Luuk Sengers and James Ball	Mapping for Stories 2 (A) Hands-on Jennifer LaFleur

14.00 - 15.00	Lunch

15.00 - 16.10	Kathryn Bolkovac - Sex Trafficking, Military Contractors and One Woman's Fight For Justice - Auditorium

	Talk 1 - Room LG002	Talk 2 - Room LG003	CAR 1 - Room 2003	CAR 2 - Room 1001	CAR 3 - Room 2001

16.25 - 17.35	How to do Covert Filming Roddy Mansfield and Allan Harraden	How to look for dictator’s loot. (Rec) Robert Palmer	Web Detective Paul Myers	Access 3: Joining Databases for Deeper Analysis (B) Hands-on David Donald and Luuk Sengers	CAR Q&A (B-A) Hands-on Jennifer LaFleur and James Ball

17.45 - 18.00	Thank you and goodbye

cij is a registered charity - number 1118602

Registered charity no. 1118602

web design london : pedalo limited