Timetable of the Summer School for Investigative Journalism 2007

8.30	Registration, tea and coffee
9.00 - 9.15 Auditorium	Welcome Sue Robertson, Dean, School of Arts, City University Gavin MacFadyen, Director CIJ
9.15 - 10.15 Auditorium	Computer-assisted reporting: a story from start to finish Heather Brooke, Aron Pilhofer
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
10.30 - 11.30	Covert recording - Michael Cowley		Excel 1: formulas, calculations (B hands-on) - David Donald	Internet searching: Google and beyond (B hands-on) - Tommy Kaas
11.45 – 1.00	Libel and privacy laws - Philip Conway, Justin Walford (starts at 11.30)		Excel 2: sorting, filtering other tools (B hands-on) - David Donald	Web detective (B hands-on) - Tommy Kaas
1.00 – 2.00	Lunch
2.00 – 3.15 Auditorium	Main session: Lowell Bergman Whistleblowers and Confidential Sources
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
3.30 – 4.45	Understanding company accounts 1. Company documents 2. Company information from outside the UK - Robert Miller		Access 1: understanding databases (B hands-on) - Aron Pilhofer	Data Mining (B hands-on) - Tommy Kaas
5.00 – 6.15	3. A company balance sheet 4. A profit and loss statement - Raj Bairoliya		Access 2: needle in the haystack; summarizing (B hands-on) - Aron Pilhofer	Excel 1: formulas; calculations (B hands-on) - David Donald

8.30	Tea and coffee
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
9.00 – 10.15	Understanding company accounts 5. The small print 6. Questions and answers - Raj Bairoliya	A covert investigation: illegal logging - Mike Davis	Excel 2: sorting, filtering other tools (B hands-on) - David Donald	Internet searching: Google and beyond (B hands-on) - Tommy Kaas
10.30 - 11.45	Working in Iraq - Ali Fadhil		Access 1: understanding databases (B hands-on) - Aron Pilhofer	Web detective (B hands-on) - Tommy Kaas
12.00 – 1.00	Writing up your investigation - Mark Hunter	White slavery - unearthing historical secrets - Don Jordan, Michael Walsh	Access 2: needle in the haystack; summarizing (B hands-on) - Aron Pilhofer	Data mining (B hands-on) - Tommy Kaas
1.00 – 2.00	Lunch
2.00 – 3.30	Main session: Seymour Hersh
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
3.45 – 4.45	International stories - Building networks of journalists - Stephen Grey, Paul Radu	Where is investigative journalism going? - Mark Hunter	Data Mining (B hands-on) Tommy Kaas	Using stats for stories (A demo) David Donald
5.00 – 6.00	Investigating the Multinationals Lowell Bergman, Luc Herman, Tom Mangold		Web 2.0 - tools for the newsroom (A demo) Aron Pilhofer	Excel 3: statistics (A hands-on) - David Donald
7.00	Drinks Party

8.30	Tea and coffee
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
9.00 – 10.15	A murder investigation: the death of Anna Politkovskaya - Roman Shleynov		Web detective (B hands-on) - Tommy Kaas	Mapping for stories (A demo) - David Donald
10.30 - 11.45	Interviewing for television and radio - Tom Mangold, Jenny Chryss	Reporting sport: beyond goals, gossip and groin strains Kevin Mousley	Access 3: Joins and deeper analysis (A hands-on) - Aron Pilhofer	Social network analysis (A demo) - Tommy Kaas
12.00 – 1.00	Working undercover - Audrius Lelkaitis, Allan Little	Record keeping and project management - Luuk Sengers (free software)		Analysts Notebook - (A demo) Stephen Grey
1.00 – 2.00	Lunch
2.00 – 3.15	Main session: David Leigh BAE Systems: a UK corruption story
	Course 1 - Room LG 002	Course 2 - Room LG 003	Computer Lab 1 - Room 1001	Computer Lab 2 - Room 2001
3.30 – 4.45	Making FOIA work for you - Heather Brooke, David Banisar	Security and Investigative Journalism - Simos Xenitellis	Internet searching: Google and beyond - Tommy Kaas	Web 2.0 - tools for the newsroom (A demo) Aron Pilhofer
5.00 – 5.45	What do editors want? Luc Hermann, Sharon Tiller
5.45 – 6.00	Final announcements and thanks Adrian Monck, Head of Journalism, City University Gavin MacFadyen

The Centre for Investigative Journalism