#CIJSummer

Investigative Journalism Summer Conference
Where new tools meet traditional craft
04 – 06 July 2019

Class information 2019

This page will be updated continuously, as talks and hands-on workshops get confirmed.

You can book for individual days as well as for all three days. On Thursday 4 July and Friday 5 July we will focus on practical skills, while Saturday 6 July will feature keynote talks, networking, discussions and #CIJSummer drinks reception.

Please note that some classes form mini-courses and are best attended as a whole.

The sessions marked [R] on the timetable will be recorded. Videos will be published on the CIJ YouTube channel a few weeks after the conference.

Some data journalism workshops take place in computer labs where computers will be provided, but most will require you to bring your own laptops. Please see Technical Requirements page for all the info. The Data Concierge service will be run every day to help you with installing software if you have difficulty doing it at home. Please make sure you have all the software installed before coming to the classes!

All data journalism workshops are practical, hands-on classes designed to teach participants the software and data analysis techniques used by journalists in the newsroom.

Data Concierge
Help with installing data software for #CIJSummer 2019. Bring your laptop and tell us the data journalism sessions you plan to attend, and one of our ‘concierges’ will help you to install the necessary software before you arrive at your chosen sessions.

You will need to have admin privileges on the laptop you are working with.

 

Refreshments are served several times a day (but not all the time) throughout the course, with a speakers and delegates lunch and drinks party held on Saturday.

Keynote/Networking Day Saturday 6 July 

Tickets are available for individual days, including Saturday keynote talks only. See the Book Now page for more information.

09:30 – Welcome from James Harkin, Director of the CIJ
09:50- 10:50 – Gavin MacFadyen Memorial Lecture – Maria Ressa

A Filipino-American journalist and author and co-founder of Rappler, will deliver our annual Gavin MacFadyen Memorial Lecture. 

 

11:10- 12:10 – Clare Rewcastle Brown. The Inside Story of the 1MDB Scandal.

Award winning investigative journalist and author of The Sarawak Report, Clare Rewcastle Brown talks about her three-year long investigation, which exposed the theft of $8billion from a Malaysian development fund by corrupt officials accused of working for the country’s then prime minister Najib Razak.

12:10 – 13:10 – Lunch

 

13:10- 14:10  – Fiona Hamilton. Moderated by Duncan Campbell. A Life in Crime.

How has crime reporting changed, and what are the new challenges of the beat? In a rare and wide-ranging conversation Fiona Hamilton, Crime and Security Editor of The Times, will talk to Duncan Campbell, veteran crime reporter at The Guardian, and author of the new book Underworld: The Inside Story of Britain’s Professional and Organised Crime.

14:30- 15:30 – Breakout talks.

Breakout 1 Robert Hunter. Cross-examination, Interrogation, Political Interviewing: What’s going on beneath the surface?

Robert Hunter is a solicitor advocate, who made interviewing techniques his lifelong interest. Having done many a cross-examination himself, he also analysed political interviewing and even attended the US police interrogation course. Robert is profoundly deaf and is a founder of City Disability charity.

Breakout 2 Geoffrey Livolsi, Aliaume Leroy and Tom Flannery. Yemen: The price of disclosure

In April, using open-source intelligence and secret government documents, a team of journalists at the new French investigative outlet Disclose published a scoop on French arm sales to Yemen – as a result of which they faced harassment by French military intelligence and now a possible jail sentence. The team behind the story will discuss their investigation and its consequences.

15:50- 16:50 – Shiv Malik in conversation with Jane Bradley. Let’s talk about sources.

Sources play a vital role in alerting journalists to wrong-doing, but how should investigative journalists go about cultivating them? And how should you work with them once you’ve got your story? How can journalists protect their sources? And what happens if the source betrays the journalist? This talk will discuss the sensitive, often complex, and sometimes fraught relationships between journalists and those who tell them their stories.

16:50 – 17:00 – Closing remarks
17:00 – Drinks reception


Information Security Advice Clinic

Thu 4 -Sat 6 July: Getting Hands-on, Installing the Tools for Digital Self-Defence

Visit the security zone in the atrium with your laptop and learn how to set up tools to browse anonymously, chat and mail with encryption and prevent data-loss from theft/confiscation of laptops and storage media. This will include the TOR-browser, PGP mailcrypto and OTR-chat.

The security software we will be using are all free of cost and will work on Windows, Mac and Linux laptops. They will not work on iPads or Android tablets. Please bring a laptop that you are able/allowed to install software on and contact us with any specific questions beforehand.

Talks and Mini-Courses

Thursday 4 July – Friday 5 July

Hands-on Workshops: (B) signifies beginner, (I) intermediate and (A) advanced levels
You do need to have your own laptop for most of the hands-on classes. You do not need laptops for Excel 1-3 and Google Sheets (but please set up a Google account if you do not have one already).
Courses with numbers (eg Excel 1, Excel 2, Excel 3…) are best taken in sequence.
The number of places in hands-on classes is limited and allocated on a first come, first served basis. 
———————————————–

All sessions are listed in alphabetical order.

Accessing Information Under FOIA 1
Jenna Corderoy 
This session will outline the basics of the Freedom of Information Act (FOIA), and how you can apply it to your research, campaigns and investigations. We’ll go through the types of information that can be accessed from government bodies and how you can draft effective requests to get the most out of the Act. We will also look at how to make requests for information under the lesser-known Environmental Information Regulations. Towards the end of the session, we will demonstrate WhatDoTheyKnowPro, an online FOIA toolkit for journalists developed by MySociety.

Accessing Information Under FOIA 2
Jenna Corderoy 
This session will go through the FOIA appeals process, and teach you how to argue your case when government bodies are doing whatever they can to prevent a disclosure. At the end of the session, we will look at how to send freedom of information requests around the world. To finish, we’ll discuss and work through some of the FOIA challenges that you have encountered.

 

Best European Examples of Data Journalism
Winny de Jong
For her Data Journalism Newsletter, Winny collects the best of the Data Journalism Web. In this presentation, she shares her favourites from all over Europe, carefully explaining why she loves these publications so much. Can’t wait for the presentation? Subscribe at http://bit.ly/ddjnews to get a small Data Journalism Party in your inbox every Sunday.

 

Build a Better News Mousetrap: A crash-course in design thinking 1 & 2, Hands-on
Aron Pilhofer
Design thinking is a methodology for building better news products. It is used by some of the largest, most innovative news sites in the world to rapidly develop and test new products and features. In these hands-on workshops, we will learn the basics of design thinking, and how this approach has revolutionised the process. Together we will learn the basics of design thinking and apply what we’ve learned to a real-world problem.

 

Building Your Own Searchable Document Archive
MC McGrath and Brennan Novak
This session teaches you how to make searchable document archives. Transparency Toolkit recently built a hosted archive service to help journalists compile, explore, filter, and publish large sets of documents. You will learn how to use this software to create a searchable database by uploading files in your browser, analyse the data with text mining tools, and publish the documents.

No technical background is required.

 

The Cornerman. A True Crime Investigation
Alon Aviram
This session will reveal the rise and fall of one of Britain’s most elusive organised crime bosses whose whispered name terrified communities from London’s glitzy West End to the leafy West Country. Firmly on the police’s radar ever since his name was linked to two notorious and still unsolved gangland murders twenty years ago in London, the Cornerman used his connection with one of the capital’s most successful crime families to build a network extending along the M4 corridor to Bristol. He walked free from prosecutions for kidnapping, murder and extortion of a championship football club owner. At least ten men, women and children, have been taken into witness protection on the police’s insistence. Meanwhile, the Cornerman continued to cash in by running protection rackets, cosying up to big players in the world of sport, and providing security for the men behind high society nightclubs loved by the young royals and A-list celebrities. This talk will give a behind-the-scenes account of that long-term shoe-leather investigation.

 

Covert Filming
Paul Samrai
Not so much a masterclass than a highly informative overview of every aspect of covert filming by Paul who has been doing it for last 25 years.
He has worked for every single major channel in the UK and major international broadcasters. Learn about role playing, bonding with the subject, coping and exit strategies, the latest equipment and how to escape when rumbled. There’s never been a better time to get involved with covert filming. Learn from the best in the business.

 

Creating Data Visualisations and Interactives with Flourish, Hands-on
Katie Riley

Flourish was built on the principle that everyone in a newsroom – not just developers – should be able to quickly and easily make beautiful interactive graphics and data visualisations. In this session, you’ll learn how to do just that. The trainer will introduce the tool and lead participants through the process of creating, editing and publishing data-driven stories using Flourish. No previous experience with data visualisation or any coding knowledge is required.
Own laptop required. Flourish is a completely browser-based tool, so all participants need to do is show up with a computer that can connect to the internet. Please sign up for a free Flourish account (via https://app.flourish.studio/register), so the class can get started right away.

 

Cross-Border Journalism Case Studies
Brigitte Alfter, Nikolas Leontopoulos, Simon Bowers and Daphné Dupont-Nivet
Cross-border collaborative journalism has proven to be a powerful method: Panama Papers, Football Leaks or Implant Files have set the political agenda and lead to significant societal change. Our panel have worked extensively on cross-border stories and will share their experiences with you using examples of stories they’ve recently worked on.

 

Cross-Border Journalism – Everybody Can Learn It
Brigitte Alfter
If you’re impressed by large cross-border stories like CumEx Files, Panama Papers or Malta Files, but are daunted by the prospect of working on cross-border stories – don’t be. It is a method everybody can learn. In this workshop, Brigitte Alfter will give an introduction to the basic considerations of cross-border collaborative journalism, the levels of intensity and the process from idea to publication and beyond. Brigitte is the author of Cross-Border Collaborative Journalism: A Step-By-Step-Guide. 

 

Data Escape Room, Hands-on
Jonathan Stoneman and other data trainers

The Data Escape Room is a 60 minute data-driven challenge designed to test and develop your data skills with additional 60 minutes allowed for questions and individual help. Working in a small team you will be given a selection of real data and tasked with working out what the story is. Using all your team’s collective skills and your preferred software (eg Excel, googlesheets, R – all taught at the conference) you will sift through data and other material under extreme time pressure. It’s a great opportunity to try what you have learned and work out what other skills you might need to acquire. Bring your laptop, and come prepared to have some fun along the way.
Own laptop required.

 

Data Journalism in the Newsroom: How Data Enriches Stories
Helena Bengtsson, Caelainn Barr, Leila Haddou
This panel of experienced data journalists will explain how data can give greater depth to your stories and discuss best-practice for integrating data analysis into newsroom workflows. If you’re new to data journalism and want to find out what the techniques can do for you, or if you work with data journalists and want a greater understanding of their role to inform your expectations then this talk is for you.

 

Developing Cross-Border Ideas
Brigitte Alfter, Nikolas Leontopoulos and Daphné Dupont-Nivet

Cross-border stories – wow… but how do you get started? In this workshop we discuss the quality of cross-border journalism ideas: How to systematically develop a cross-border story, how to deal with cross-border aspects of a local story, and how to find potential team members to further develop the story idea with.

 

Don’t be Numbed by Numbers
Jonathan Stoneman
What do you do when faced with a really big dataset for the first time? Using examples, Jonathan Stoneman will discuss approaches that help reduce a daunting mountain of data to a manageable mass.
Although this is not a hands-on session it will be possible to download the demo data and follow along if you bring your own laptop.

 

Excel 1: The Power of Data Analysis for Stories (B), Hands-on
Helena Bengtsson and Jonathan Stoneman

Data is everywhere and spreadsheets can help reporters to find story ideas in the data. This course introduces data analysis using Microsoft Excel. Participants will learn basic calculations to find examples, outliers, trends and spikes in data and explains how sorting and filtering can help you generate story ideas.
The class takes place in a Goldsmiths computer lab. No laptops required, but you can use your own if you like. See technical requirements. 

Excel 2: Finding Patterns in the Data (B), Hands-on
Helena Bengtsson and Jonathan Stoneman

The second spreadsheet course covers more advanced formulas for Excel – how to clean data and use functions to help reporters quickly find great stories within data. We will also take a look at simple charts for finding trends or ideas for stories.
The class takes place in a Goldsmiths computer lab. No laptops required, but you can use your own if you like. See technical requirements. 

Excel 3: Summarising Your Data for the Big Picture (I), Hands-on
Helena Bengtsson and Jonathan Stoneman
To complete your spreadsheet toolkit, learn how to make pivot tables and other functions that will summarise trends in your data and enable you to cross-match data from different sources.
The class takes place in a Goldsmiths computer lab. No laptops required, but you can use your own if you like. See technical requirements. 

 

Finding the Human Face in a Data-Driven Investigation
Leila Haddou and Paul Bradshaw
We use data in our investigations to find out about the the scale of a problem that is affecting people, systems that aren’t helping them, or to shine a light on particular individuals. This workshop focuses on techniques for finding the human stories that help bring that data to life, from scoping the characters and settings that can help inject movement into your story, to tips on finding and interviewing key sources.

 

Follow the Money: Financial Investigations
Cynthia O’Murchu
The session will teach you ways to investigate an individual or company’s finances. It will take you on a virtual trip around the world to show how to access public records in offshore jurisdictions and the stories they can yield.

 

Forensic Journalism: Image and Spatial Analysis in Investigative Reporting
Nick Masterton and Robert Trafford
Forensic Architecture work on human rights violation investigations with a range of different partners, from international prosecutors to media organisations. This session will provide an insight on this work from the mindset of both an architect and a journalist, with examples and workshop exercises in image analysis, geo-locating, and interpreting video. You’ll learn how that material goes out into the world and is received, the forums in which the organisation operates, and a consideration of the advantages and weaknesses of Forensic Architecture’s work in new media/social media spaces.
Own laptop required.

 

Forensic Journalism: How Open Source Investigations and Field Reporting are Uncovering the Tragedy of Yemen
Christiaan Triebert and Iona Craig. Moderated by Chris Woods
More than 10,000 civilians have died since the Saudi-led war against Yemen’s Houthis began in 2015. While traditional field investigations are still critical to covering the crisis, open source monitoring and investigations are increasingly playing a role in holding power to account.

 

Googlesheets 1 (B) Hands-on
Pamela Duncan and Luuk Sengers
Data journalism introduction: overview of the seven building blocks behind data stories. The basics: use Googlesheets to carry out basic calculations and percentage increases.
The class takes place in a Goldsmiths computer lab. Please create a Google Drive account, if you do not have one already. No laptops required, but you can use your own if you like.

Googlesheets 2 (B) Hands-on
Pamela Duncan and Luuk Sengers
Finding your top line: sorting and filtering in Googlesheets/Excel. With handy/fun tools such as split, concatenate, currency conversion, translate.
The class takes place at a Goldsmiths computer lab. Please create a Google Drive account, if you do not have one already. No laptops required, but you can use your own if you like.

Googlesheets 3  (B) Hands-on
Pamela Duncan and Luuk Sengers
Quick-smart data summary/analysis using pivot tables, merging datasets (VLookUps) and basic scraping using Google’s Import tools.
The class takes place at a Goldsmiths computer lab. Please create a Google Drive account, if you do not have one already. No laptops required, but you can use your own if you like.

 

Graph Databases 1 (I) Hands-on
Leila Haddou and Max Harlow
In data journalism, we tend to use relational databases – data in table form – such as Excel or SQL to do our analysis and find stories. Graph databases are different, but are incredibly useful to find connections or patterns within our data that would be difficult, if not impossible, to spot using a relational database. This session will provide a hands-on introduction to graph database software Neo4j, showing examples of its use for investigative stories including the Panama Papers, and demonstrate how to build a graph database of political donations and match them with corporate data to see at a glance the networks involved.
Own laptop required. For graph databases 1 and 2: Install Neo4j (https://neo4j.com/download). See technical requirements. 

Graph Databases 2 (I) Hands-on
Leila Haddou and Max Harlow
In part two, you will learn to analyse your newly built graph database using Cypher, Neo4j’s query language. It is advisable to have completed part one to get the most out of this session.
Own laptop required. For graph databases 1 and 2: Install Neo4j (https://neo4j.com/download). See technical requirements. 

 

Heineken in Africa
Olivier van Beemen. Moderated by David Dunkley Gyimah
From hiring sex workers to sell their products to buttressing murderous regimes, what are Western multinationals really up to in Africa and how might we go about researching it?

 

The Human Cost of the Housing Crisis
Lois Kapila, Maeve McClenaghan and Tom Bristow
Council estates are being knocked down to build luxury developments and ‘affordable’ housing is out of reach of those that most need it. Meanwhile the number of homeless on the streets and people in temporary accommodation is growing. Our three panelists have independently researched the social cost of this and the impact on people’s lives and will be discussing their methods of translating investigations into impact.

 

If you are planning to take any of the data journalism sessions, we recommend you attend the introductory session that will help you decide how many, and which of the data sessions you should attend for your particular needs:

Introduction to Data Journalism: How to get the most out of the #CIJSummer Data Strand.
Data trainers
This session will provide a chance to find out what data journalism classes are on offer and which tools are best for which tasks. Our data trainers will advise you on the best data pathway and explain how you can improve your journalism with data analysis.

 

An introduction to statistics through Benford’s Law for Fraud Detection
Andrew Garthwaite
If you’re wondering if there’s something a bit fishy about a dataset, but you don’t know where to start looking, you might get some relief from a weird quirk of numbers called Benford’s Law that’s ready to help in your search. Largely forgotten about for 80 years, it’s become a handy part of a fraud investigators toolkit in the last decade. Learn how to use it in your investigations, and pick up a brief introduction to using statistics at the same time.

 

Investigating the National Health Service
Shaun Lintern

A walk through of some of the Health Service Journal’s most high-profile investigations, including tips and pitfalls to avoid when working with bereaved families and whistleblowers, plus how best to get to grips with complex policy to find that story.
Some of the stories included will be exposing the cover-up of a murder on a hospital ward; body parts being stockpiled; uncovering one of the biggest NHS maternity scandals; and a year long investigation of a cover-up involving child deaths by the NHS.

 

Investigating Offshore Finances and Money-Laundering
Mollie Hanley and Graham Barrow
How do you investigate ‘dark money? Knowing how ‘dark money’ enters the financial system is crucial to covering money laundering, corruption, bribery and tax evasion. In this session you will be provided with the tips, tools and resources for shining a light on a murky world.

 

Investigative Interview Techniques
Fiona Gabbert
This talk will provide an overview of investigative interviewing tools and techniques used within a forensic context. The focus here is to elicit detailed and reliable information from witnesses and suspects as this can play a central role in legal decision-making and, ultimately, the delivery of justice. Throughout the talk psychological factors known to underpin successful investigative interviews will be introduced, including building and maintaining rapport, establishing the role of the interviewer and interviewee, providing retrieval support, and asking the right questions at the right time.

 

Libel and Privacy Laws
Justin Walford
In this session you will learn about libel and privacy and hear how recent cases have affected the law. This class is for anyone who wants to update their legal knowledge and find out how they are affected by recent legal developments.

 

Online Toolkits and Resources for Data Journalists
Winny de Jong
First Aid for your data journalism learning problem. When you’re diving into a new field of expertise, it can be overwhelming. Our trainer is here to help: tell her what you’d like to learn and why so far that didn’t work out; and she’ll try to point you to the online toolkit or resource you didn’t know you needed. This workshop will be a full improvisation, so buckle up.

 

Open Source: Fantastic Formulas to Filter Social Media
Henk van Ess

Who is the mysterious person behind a mining contract in the Central African Republic? What do you do when you have only a very common name and no photos? And what to do when a Twitter account is completely deleted? You filter social media with what you have. In this session you will find out how Mr/Mrs Brown was tracked down via clever use of fantastic filtering in social media, based on the trainer’s work for European news media.

 

Open Source: Tracking Down a Most-Wanted Criminal via Instagram
Henk van Ess
What is “chronolocation” and why do we need it? How do we research deceiving Instagrams? What is wrong with Google reverse image search? What is the hidden connection between Instagram and Facebook?
How can you track down a fugitive criminal with Instagram and a little help from Facebook and Google, when the police want to know who the convict contacted and where he is right now? This session will answer all these questions and more
This is the first public session ever about the case that made headlines in The Netherlands this spring.

 

Open Source: The GRU Globetrotters, Tracking Clandestine International Operations
Christo Grozev
Tracking agents of the Russian secret service and their European operations requires employing the full range of open source intelligence techniques. This class will show you many tips and tricks, while explaining how they were used in a range of investigations looking into GRU activities in Switzerland, Bulgaria and elsewhere.

 

Open Source: The Skripal Poisoning Investigation
Christo Grozev
When two suspects were identified in the police investigation surrounding the poisoning of former spy Sergei Skripal and his daughter Yulia last March, several researchers from Bellingcat began a hunt to verify the real identities of the suspects, and their links to Russian military intelligence. This class will talk you how through the OSINT tools and techniques, corroborated by reporters on the ground, that made the investigation possible.

 

R 1: Introduction to R (B), Hands-on*
Caelainn Barr and Niamh McIntyre
In the first class, R-1, you’ll be shown the basics and get familiar with R and RStudio, import data and learn some functions for getting to grips with your dataset including sorting and filtering. This class assumes no prior experience with R.
Own laptop required. See technical requirements. 

R 2:  Data Wrangling and Statistics (A), Hands-on*
Caelainn Bar and Niamh McIntyre
In R-2 you’ll get down to some data wrangling and learn how join datasets and carry out calculations in R that will allow you to identify trends in the data for storytelling. You’ll also learn statistical functions in R and how to use ggplot2 for basic visual analysis.
Own laptop required. See technical requirements. 

R 3:  Scraping and APIs (A), Hands-on*
Caelainn Barr and Niamh McIntyre
In the third and final class, you’ll use R to scrape, clean and structure data from webpages and APIs. You’ll also learn how to use R to convert, join and split difficult data files.
Own laptop required. See technical requirements. 

*If you are a complete beginner, these sessions will work best if you come to classes 1 to 3 as we will be building on knowledge and datasets from class to class. However, if you have experience in R you are free to join classes 2 and/or 3.

 

SCIENCE: 101 on Science Reporting
Kevin McConway. Moderated by Wendy Grossman
Where to find stories and how to read research papers and university and journal press releases. An explanation of scientific methods, randomised clinical trials and their importance, including assessing aspects like sample sizes, statistics and risk assessments.

 

SCIENCE: Reporting on Academic Misconduct and the Business of Science
Éanna Kelly, Hannah Devlin and Holly Else.  Moderated by Emma Stoye
Science is often admired for its pure and infallible nature, but scientists are humans and, like any of us are affected by biases, conflicts of interest and money. And sometimes they do bad things that need exposing. Why do scientists go rogue, and what are the stories we can tell about this? How do you find stories about bad science, and how do you tell them? How do funding and policy affect research priorities? Come and learn about this and more in this session organised in partnership with the Association of British Science Writers.

 

SCIENCE: Digging Out Research Discoveries and Science Scoops
Crispin Dowler, Joshua Howgego, Julian Sturdy and Mike Power. Moderated by Wendy Grossman
Much of core science reporting these days is driven by big science PR machine: major journals, universities and businesses bombard journalists with ready-to-print press releases that set the agenda and frame science and tech stories. A few brave journalists go beyond this flurry to find their own stories and find untold scoops. In this session, organised in partnership with the Association of British Science Writers you will find out how to break from the pack and find the science stories that no one else has and that your editors will love

 

SCREENING: The Panama Papers
Followed by Q&A with Bastian Obermayer and Simon Bowers
The biggest global corruption scandal in history, and the hundreds of journalists who risked their lives to break the story. This documentary from Alex Winter charts the story of this huge cross-border collaboration, from first contact with the source to the coordinated international publication.

 

SCREENING: No Stone Unturned
Followed by Q&A with Barry McCaffrey
An in-depth look at the unsolved 1994 Loughinisland massacre, where six Irishmen were murdered, presumably by a Unionist paramilitary group, while watching the World Cup at the local pub in Loughinisland, Northern Ireland.

 

Story-Based Inquiry 1: A Method Through the Madness
Luuk Sengers and Mark Lee Hunter
Investigation has a dirty name with editors, who think it’s about slowly rummaging through piles of garbage till you find (or don’t find) a jewel. Too often, they’re right. This session will show you how to choose a subject and define your investigation as a story from the start, using hypotheses. The method helps you figure out what to look for, how to look for it and how to sell it to your boss and the public.

Story-Based Inquiry 2: Creative Techniques
Mark Lee Hunter and Luuk Sengers
In this session we map the plot of a story – a sequence of events that must have occurred, which we can subsequently verify and enrich. Simultaneously, we create scenes, with characters whose actions and conflicts define the content and meaning of the story. These events lead to the sources you need.

Story-Based Inquiry 3: Practical Tools
Luuk Sengers and Mark Lee Hunter
This session begins with an alternative to the timeline – a map of the actors in your story and the sources they hold. Now that we’ve shown you where to acquire information assets, we’ll show you how to optimise them. We’ll create a simple but effective database in which you collect the results of your investigation. This ‘MasterFile’ makes it easier to structure your story – the hardest part of composition. It’s a way to write while you research, instead of first researching and then writing. It’s also a way to build resources for a long, successful career.

Story-Based Inquiry 4: Crafting the Story
Mark Lee Hunter and Luuk Sengers
This session shows you how to compose a story that hits hard and fast, and builds to a powerful conclusion. The core of this method is continuous composition and referencing – an approach that saves both you and your colleagues time and anguish. We turn the ‘MasterFile’ into a narrative structure based on a chronology or a sequence of themes and characters. We apply techniques for controlling rhythm, the element that keeps your audience reading, listening or watching. We finish with quality control – reducing the risk of mistakes that can cause damage to others and your own reputation.

 

SQL for Journalists 1 (I) Hands-on
Crina Boroş
What to do when Excel is not enough to crunch your data and hardcore coding is not your style? SQL is like Excel, but on steroids! This is the first of three workshops that will introduce you to the lingua franca of programming and a popular relational database. You’ll see what SQL does: create a database, import a spreadsheet, and learn about the main ‘select statements’.
Note: Familiarity with Excel is recommended for those wishing to attend.
Own laptops required. See technical requirements. 

​SQL for Journalists 2 (I) Hands-on
Crina Boroş
You’ll learn about the power of the ‘golden query’ through the introduction of functions, filters and analysing data using code for reporting. You’ll also start joining tables.
Note: Familiarity with SQL ‘select statements’ is necessary, and with Excel recommended for those wishing to attend.
Own laptops required. See technical requirements. 

SQL for Journalists 3 (I) Hands-on
Crina Boroş

Building on SQL 1 and 2, you’ll make tables talk to each other, clean dirty data and update tables.
Note: Familiarity with SQL ‘select statements’ is necessary, and with Excel recommended for those wishing to attend.
Own laptops required. See technical requirements. 

 

Top-Shopped: Investigating Sir Philip Green
Claire Newell
In this talk you will hear about the hard-hitting investigation the speaker co-authored for the Telegraph: uncovering the behaviour of businessman Sir Philip Green. You will hear how the investigation began and evolved, the role of whistleblowers, and about the injunction that almost shut it down.

 

Understanding Company Accounts: How to get the Most of Companies House
Martin Tomkinson and Robert Miller
Any UK-based investigative journalist or aspiring journalist should have a working knowledge of Companies House. Companies House is the central registry for all UK registered limited or PLC companies and contains a wealth of useful information for those who know how to use the site. The aim of this class is to show how to get the most information from the official website, as well as highlighting what information can’t be found there. The class will give ample time for questions and queries and is an absolute must for anybody who does not feel confident in using this vital tool for investigators.
Class handout: Companies House.

Understanding Company Accounts 1-4
Raj Bairoliya
This mini-course taught by a journalist-friendly forensic accountant will show you how to understand company accounts and get beyond the corporate PR spin. The emphasis will be on teaching practical skills rather than a series of lectures. The objective of the course is to ensure that all participants feel comfortable with a set of accounts and know where and how to look for relevant information.
The only prerequisites for this course are numeracy and an interest in financial matters as the theory will be taught in the first class and applied to real-life examples in the following sessions.
You must attend all the classes in this strand to benefit from it fully.
It will include the following topics: motivation to massage earnings; profit and loss account; balance sheet; funds flow statement; notes. And will finish with putting it all together, an interactive session building up a sample set of accounts or case study questions.
The participants are actively encouraged to ask questions throughout.
Raj’s handbook: The Investigative Journalist’s Guide to Company Accounts. Second edition. 

 

Unlimited Power: Investigating Tony Robbins
Jane Bradley and Katie Baker
In May, BuzzFeed News published a major investigation into the world’s most famous self-help guru Tony Robbins, who claims to have revolutionised millions of lives including some of the most vulnerable. The investigation revealed that Robbins has publicly berated victims of rape and abuse at his events – and is accused by nine women of inappropriate sexual advances or exposing himself to them, including groping followers and sexually harassing staffers. The millionaire’s legal team aggressively fought to shut the story down.

 

Web Scraping for Journalists 1+2 (B) Hands-on
Paul Bradshaw

In these hands-on sessions you will be introduced to some of the basic techniques to get started on scraping data for investigations:
– investigation ideas: how to spot opportunities to use scraping and automation in investigations
– scraping basics: finding structure in HTML and URLs; what’s possible with programming
– simple scraping jobs: how to write a basic scraper in five minutes
– data journalism tools: the challenges of scraping hundreds of webpages, dozens of documents, or the invisible contents of databases.
Own laptop required. See Technical requirements. 

 

Web Scraping Without Code (B) Hands-on
Pamela Duncan and Niamh McIntyre
How to use the import functions for scraping data into Googlesheets, building a basic scraper with websraper.io and OCR 3 ways.
The class takes place at a Goldsmiths computer lab. Please create a Google Drive account, if you do not have one already.No laptops required, but you can use your own if you like.<

 

Why Code? 
Max Harlow, Niamh McIntyre, Helena Bengtsson. Chaired by Leila Haddou.
A talk for those who are unsure on how knowledge of code can help journalists in their investigations. Leila Haddou will talk to a developer, Max Harlow; a code newbie data journalist, Niamh McIntyre; and a code old-hand data journalist and editor, Helena Bengtsson. The discussion will cover the use of code for journalism, which language to learn, and why and how it can improve your investigations. Questions from the audience are welcome and encouraged.