Friday 18 July [0]
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 Donald, Aron 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 Conway, Justin 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 |
| 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 Brooke, David Gordon | Excel 2: sorting, filtering, other tools (B hands-on) David Donald | Excel 3: summarizing 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 poer and PR Andy Rowell | Excel 3: summarizing 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-crime – how to find your story Julian Newman (EIA) | You and your computer 2: protect your privacy (B hands-on) Dmitri Vitaliev | Access 2: needle in the haystack; summarizing (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 Kaas | 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 | PC Lab EG012 | |
| 3.20 – 4.30 | FOIA Workshop: UK and Europe David Banisar, Heather Brooke | The politics of science: the toxic chemistry of everyday products Mark Schapiro | Going undercover online - risks and solutions (B demo) Paul Myers | Web detective (B hands-on) Tommy Kaas | Excel 4: statistics (A hands-on) David Donald |
| 4.40 – 5.50 | The Gas Trade - who controls, who benefits 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 demo) Tommy Kaas |
| 6.00 - 8.00 | 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 3A CAR A-Z |
|
| 9.00 – 10.10 | Following the international business trail and the world of corporate investigators Paul Radu, Jeff Katz | Oil: Stories from Iraq and West Africa Irene Gerlach, Greg Muttitt | Nonlinear journalism: graphics, data and visuals online (A hands-on) Aron Pilhofer, Francis 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 contracts and deals Richard Orange | Google Maps: visualizing 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 Nichol, Raphael Rowe | Anglo American - mining and the environment James Sanders | Social network analysis (A hands-on) Tommy Kaas | Training the trainers 1 (A hands-on) David Donald |
| Lunch | ||||
| Room C350 | Room C348 | PC Lab EG07 | PC Lab 3A | |
| 2.00 – 3.10 | War on Terror, Inc Solomon Hughes | How to do covert filming 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 Schapiro, Michael Warhurst Oliver Thompson Lecture Theatre |
|||
| 4.40 – 5.00 | Final announcements and thanks Gavin MacFadyen |
|||