Timetable 2008

Friday 18 July
 
8.30 Registration, tea and coffee
9.00 – 9.15 Welcome Gavin MacFadyen, Director cij Adrian Monck, Head of Journalism, City University Oliver Thompson Lecture Theatre
9.15 - 10.10

The Conventions of Churnalism: objectivity, balance and bad journalism  Nick Davies Oliver Thompson Lecture Theatre

 

Talk 1 Room C350

Talk 2 Room C348

CAR 1 PC Lab EG07

CAR 2 PC Lab Level 3A CAR A-Z

CAR 3 PC Lab EG12

10.20 - 11.30
The Serious Fraud Office Robert Wardle No session An introduction to CAR (demo) David DonaldAron Pilhofer Excel 1: formulas, calculations (B hands-on) Heather Brooke No session
11.40-12.50
Understanding company accounts 1. Company documents Robert Miller Libel and privacy law update Philip ConwayJustin Walford Excel 1: formulas; calculations (B hands-on) David Donald Excel 2: sorting, filtering, other tools (B hands-on) Elena Egawhary Access 1: understanding databases (B hands-on) Aron Pilhofer
1.00 - 1.50 Lunch
2.00 - 3.10 Power and Responsibility John Pilger in conversation with Gavin MacFadyen Oliver Thompson Lecture Theatre
Room C350 Room C348 PC Lab EG07 PC Lab Level 3A PC Lab EG12
3.20 – 4.30
Understanding company accounts 2. A company balance sheet 3. Profit and loss statements Raj Bairoliya MPs' expenses, ministerial scalps and the FOIA Heather BrookeDavid Gordon Excel 2: sorting, filtering, other tools (B hands-on) David Donald Excel 3: summarising data; pivot tables (B hands-on) Elena Egawhary Access 2: needle in the haystack; summarizing (B hands-on) Aron Pilhofer
4.40 – 5.50
Understanding company accounts 4. The small print Raj Bairoliya Spinning climate change: oil, nuclear power and PR Andy Rowell Excel 3: summarising data; pivot tables (B hands-on) David Donald Internet searching: Google and beyond (B hands-on) Tommy Kaas Access 3: joining tables for investigations (B hands-on) Aron Pilhofer

   

Saturday 19 July
 
8.30 Tea and coffee
Talk 1 Room C350 Talk 2 Room C348 CAR 1 PC Lab EG07 CAR 2 PC Lab Level 3A CAR A-Z CAR 3 PC Lab EG12
9.00-10.10
No session You and your computer: protect your privacy Dmitri Vitaliev Investigating a website (B demo) Paul Myers Access 1: understanding databases (B hands-on) Aron Pilhofer Excel 1: formulas; calculations (B hands-on) Elena Egawhary
10.20-11.30
Investigating organised crime Drew Sullivan Investigating eco-crim - how to find your story Julia Newman (EIA) You and your computer 2: protect your privacy(B hands-on) Dmitri Vitaliev Access 2: needles in haystack; summarising (B hands-on) Aron Pilhofer Excel 2: sorting, filtering other tools (B hands-on) Heather Brooke
11.40-12.50
Hypothesis-based investigation: managing your project Mark Hunter How the news gets it wrong - getting statistics right Sheila Bird Importing data into Excel (B-hands-on) Tommy Kass Access 3: joining tables for investigations (B hands-on) Aron Pilhofer Excel 3: summarizing data; pivot tables (B hands-on) Elena Egawhary
Lunch
2.00 - 3.10 Hijacking the global food supply Vandana Shiva Oliver Thompson Lecture Theatre
Room C350 Room C348 PC Lab EG07 PC Lab Level 3A CAR A-Z PC Lab EG12
3.20 - 4.10
FOIA Workshop: UK and Europe David BanisarHeather Brooke The politics of science: the toxic chemistry of everyday prodcuts Mark Schapiro Going undercover online (B demo) Paul Myers Web detective (B hands-on) Tommy Kaas Excel 4: statistics (A hands (A hands-on) David Donald
4.40 – 5.50
The Gas Trade - who controls, who benefts Tom Mayne (Global Witness) Policing terrorism vs. freedom of expression Heather Rogers, Gavin Millar GIS: power of statistical maps (A demo) David Donald Importing data into Excel (B hands-on) Elena Egawhary Data mining: web scraping for beginners (B hands-on) Tommy Kass
Party

   

Sunday 20 July
 
8.30 Tea and coffee
Talk 1 Room C350 Talk 2 Room C348 CAR 1 PC Lab EG07 CAR 2 PC Lab Level 3A CAR A-Z
9.00 - 10.10
Following the international business trail and the world of corporate investigators Paul RaduJeff Katz Oil and the Gulf of Guinea Irene Gerlach, Greg Muttitt Non-linear journalism: graphics, data and visuals online (A hands-on) Aron PilhoferFrancis Irving Using freedom of information (B hands-on) Heather Brooke
10.20-11.30
Writing an investigation: the last (and first) hurdle Mark Hunter Town Hall finance: how to investigate cnotracts and deals Richard Orange Google Maps: visualising data (A hands-on) Tommy Kaas CAR A-Z Q&A (final session CAR A-Z (B hands-on) David Donald and Elena Egawhary
11.40-12.50
Miscarriages of justice Jim NicholRaphael Rowe Anglo American -mining and the environment James Sanders Social network analysis(A hands-on) Tommy Kaas Training the trainers (A hands-on) David Donald
Lunch
2.00 – 3.10
War on Terror Solomon Hughes How to do covert filiming Allan Harraden, Roddy Mansfield Monitoring websites: RSS and other tools (A hands-on) Tommy Kaas Training the trainers 2 (A hands-on) David Donald
3.20 - 4.30 Global environmental power in the 21st century - the EU flexes its muscles Mark SchapiroMichael Warhurst Oliver Thompson Lecture Theatre
4.40 - 5.00 Final announcments and thanks Gavin MacFadyen Oliver Thompson Lecture Theatre