David Donald, teaching at the cij summer school 2009. David Donald, teaching at the cij summer school 2009.

summer school 2009

Despite the current economic downturn, this year’s cij summer school attracted more people than ever – with over 50 speakers and 130 delegates from as far afield as Argentina, Brazil, Denmark, Japan, Macedonia, Poland, Russia and the USA.

As always we had a packed programme, featuring some of the leading names in the field, from around the world.

Ian Hislop’s interview with Melanie McFadyean on the interplay between satire and investigative journalism, got people talking:

‘Refreshingly open’, was how one delegate described it.

Chuck Lewis spoke twice at this year’s event, his talk on the emerging investigative journalism ecosystem prompted one of you to say:

‘It completely opened my eyes to the real need for more investigative journalists…’

David Leigh’s talk on the legal intimidation which many investigative journalists experience in the UK, prompted a lot of feedback on the importance of knowing your rights and the law, including:

‘A great teacher – very helpful and practical advice’.

The recent economic crisis has got a lot of people thinking about business and finance issues, and our Understanding Company Accounts sessions were very popular.

‘Thoroughly interesting, clear and informative, and for me it was worth the summer school cost itself’.

‘Raj [Bairoliya] made accounts less daunting by speaking ‘normal’ English and translating the jargon.’

A number of attendees enjoyed the chance to network in our East meets West strand. This is the first time we have run it, and we were pleased to receive positive comments, including:

‘Good to hear experiences from people who come from countries we normally don’t hear about’

Many delegates expressed frustration that there were so many talks they couldn’t attend all the ones they were interested in. Every year we try to repeat as many sessions as possible while offering a wide range of subjects. This is not an easy thing to get right. It is inevitable that when running a conference comprising five strands simultaneously, there will be some clash so hard choices sometimes just have to be made.

There was one thing attendees wanted more of though – coffee!

‘For the future could you please arrange for the coffee not to run out by 10am.’

‘Get bigger coffee jugs and possibly an espresso [machine]!’

We really appreciate all the feedback we received. You can find more information about the speakers and video presentations or course notes from the timetable below.

Friday 17 July
8.30 – 9:15Registration and refreshments First floor foyer, near Great Hall
9.15 – 9:30Welcome Gavin MacFadyen, Director CIJ Great Hall
9.30 – 10.10Brief introductions to Computer Assisted Reporting, Understanding Company Accounts, and East Meets West Great Hall
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training 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 MillerWikileaks: Source protection, spies, lies and lawsuits on journalism’s high frontier Julian AssangeCAR 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 PilhoferNo session
11.40-12.50
Understanding company accounts 2: Profits and Losses Raj BairoliyaLibel and privacy law Philip Conway and Justin WalfordCAR A-Z
Excel 2: Finding patterns in the data (B) Hands-on
Cynthia O’Murchu and Elena Egawhary
Internet 101 (B), Hands-on David DonaldAccess 1: Understanding databases (B), Hands-on Jennifer LaFleur and Aron Pilhofer
12.50 – 14.00 Lunch
14.00 – 15.10Investigative Journalism and Satire as a Method Ian Hislop, chaired by Melanie McFadyean. Great Hall OPEN TO THE PUBLIC
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: Room AG35 A&B
15.20 – 16.30
Understanding company accounts 3: Assets and Liabilities Raj BairoliyaThe 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 DonaldAccess 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 BairoliyaEast Meets West: Brigitte Alfter Cross-border reporting and networking…CAR A-Z Importing Data to Excel (B), Hands-on David DonaldA guide to automated web browsing (A), Demo Mike SchrenkAccess 3: Joining databases for deeper analysis (B), Hands-on Jennifer LaFleur and Aron Pilhofer
Saturday 18 July
8.30Tea and coffee
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: Room AG35 A&B
09.00-10.10
Defamation and Privacy: A Tale of Two Businessmen Gavin Millar QCEast Meets West: Fight against corruption…CAR A-Z Access 1: Understanding databases (B), Hands-on Aron PilhoferExcel 1: The power of data analysis for stories (B), Hands on James Ball and Jennifer LaFleurDavid DonaldNo session
10.20-11.30
Conducting anonymous research Mike SchrenkEast 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 DonaldExcel 2: Finding patterns in the data (B) Hands-on James Ball and Jennifer LaFleurNewsgathering Online (A), Demo Murray Dick
11.40-12.50
Beyond Google: Shoeleather journalism and stealing documents Andrew JenningsEast Meets West: Investigating war crimesCAR A-Z Access 3: Joining databases for deeper analysis (B), Hands-on David Donald and Aron PilhoferExcel 3: Summarizing your data for the big picture (B), Hands-on James Ball and Jennifer LaFleurFinding people online (A), Demo Murray Dick
12:50 – 14:00 Lunch
14.00 – 15.10In Search of Truth: Power, the News Media and the Public’s Right to Know Chuck Lewis Great Hall OPEN TO THE PUBLIC
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: Room AG35 A&B
15.20 – 16.30
Hypothesis-based investigation: managing your project Mark HunterEast Meets West: Upcoming European Championship in UkraineMySQL 1 (A), Hands on Aron PilhoferImporting data to Excel (B), Hands-on Elena EgawharySocial network analysis (B), Hands-on Jennifer LaFleur
16.40 – 17.50East Meets West: Investigative cooperation speed dating Great Hall
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: Room AG35 A&B
16.40 – 17.50
Writing an investigation: the last (and first) hurdle Mark HunterPractical approach to improving computer and Internet security and privacy, part I (Demo) Wojtek BoguszMy SQL 2 (A), Hands-on Aron PilhoferAdvanced CAR: CAR and statistics (A), Demo David DonaldFreedom of Information Act for CAR (A), Demo Heather Brooke
18:00 – 20:00Summer school drinks oarty in the foyer: delegates, speakers and cij board First floor foyer, near Great Hall
Sunday 19 July
8.30Tea and coffee
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: 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 BoguszExcel 4: Summarising your data for the big picture – statistics (B), hands-on David Donald
10.20-11.30
Exposing spin David MillerHypothesis-based investigation: managing your project Mark HunterAdvanced CAR: Text mining: Seeing patterns in paragraphs and other unstructured text (A), Hands-on David DonaldHow to build a personal database for investigations Luuk SengersNewsgathering online (A), Demo Murray Dick
11.40-12.50
Town Hall finance: investigating local authorities Richard OrangeHow to do covert filming Roddy Mansfield and others TBCUsing CAR during a financial crisis (A), Hands-on David DonaldExcel 1: The power of data analysis for stories (B), Hands on James Ball and Elena EgawharyMapping for stories 1 (A), Hands-on Jennifer LaFleur
12:50 – 14:00 Lunch
14.00 – 15.10Where legal bullying succeeds – and how to make it fail David Leigh Great Hall OPEN TO THE PUBLIC
Talks: Room AG08Talks: Room AG09Training: Room A308Training: Room A220Training: Room AG35 A&B
15.20 – 16.30
Investigating the economic crisis Ann Pettifor and Tony Hillier. Moderated by Paul LashmarCorporate investigations and offshore jurisdictions Jeff KatzFreedom of Information Act for CAR (A), Demo Heather BrookeExcel 2: Finding patterns in the data (B) Hands-on James Ball and Elena EgawharyMapping for stories 2 (A), Hands-on Jennifer LaFleur
16.40 – 17.50
MP Expenses and FOIA Heather BrookeThe investigative reporter’s toolkit Luuk SengersInvestigating a website Paul MyersExcel 3: Summarising your data for the big picture (B), Hands-on James Ball and Elena EgawharyFinding people online (A), Demo Murray Dick
18:00 – 18:20Final announcements and thanks First floor foyer, near Great Hall