1. Class Information

    Class Information

    Detailed information about what you can expect at the 2016 CIJ Investigative Journalism Summer Conference.
    #CIJSummer

     

     

    Full details
    Full details
  2. About the Conference

    Bookings are now OPEN

    #CIJSummer Conference
    22-24 June 2017
    Goldsmiths, University of London
     

    Full details
    Full details
  3. Timetable 2017

    Timetable

    Plan your time at the Summer Conference. #CIJSummer

    Full details
    Full details
  4. Teachers and Speakers

    Teachers and Speakers

    Some of the world's best speakers and trainers are coming to the CIJ Summer Conference. #CIJSummer

    Full details
    Full details
  5. Directions

    Directions

    How to get to the CIJ Investigative Journalism Conference venue at Goldsmiths, University of London.

    Full details
    Full details
  6. Previous Summer Schools

    Previous Summer Schools

    See our archive of videos and reviews from our previous Summer Schools.

    Full details
    Full details

Class Information

This page will be updated on regular basis.

This year you can book for individual days as well as for all three days. On Thursday 22 June and Friday 23 June we will focus on practical skills, while Saturday 24 June will feature keynote talks, networking and discussions. 

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

The sessions marked [Rec] will be recorded.

The Data Journalism Workshops take place in computer labs. These sessions are practical, hands-on classes designed to teach participants the essential software and data analysis techniques used by journalists in the newsroom.

Some hands-on classes will require delegates to bring their own laptops with some software preinstalled. It will be clearly stated in the class descriptions and in the timetable. 

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.

Keynotes/Networking Day Saturday 22 June 

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

TBC

Networking Sessions

For the first time this year, we will be offering specific networking sessions and sessions offering useful resources for journalists. 
These will be informal meetings, lead by our trainers and speakers. Come for a cuppa and meet likeminded people.
Formats will vary.

Computer Security Advice Clinic

Visit the security zone at the Atrium with your laptop. You will learn to set-up various 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, OTR-chat.

The software tools 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.

You are advised to download CIJ Logan InfoSec handbook (free).

Talks and Mini-Courses

Thursday 22 June - Friday 23 June

(In alphabetical order. Excluding Data Journalism. See below.)

Accessing information under FOIA - 1
Jenna Corderoy and Sid Ryan
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 all the kinds of information that can be accessed from government bodies, including datasets, and how you can draft effective requests to get the most out of the Act. We will also take a look at how to make requests for information under the lesser-known Environmental Information Regulations.

Accessing information under FOIA - 2
Jenna Corderoy and Sid Ryan
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. Towards 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.  

Coping with Big Datasets 
Jonathan Stoneman
Some open data available for download will land on your desktop as an array of data so vast it is difficult to know where to begin. Jonathan Stoneman will work through some examples and show some key strategies that work for big datasets, whatever the subject matter.

Covert Filming
Allan Harraden and Paul Samrai
This session on covert filming has evolved over the years into a state-of-the-art technical workshop looking at last-resort methods to acquire evidence for public interest investigations. It is taught by a leading undercover technician and an experienced television reporter who discuss the process and ethics of going undercover and look at the latest high-quality equipment.

How to Get the Most Out 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
 
Libel and Privacy Laws
Justin Walford
Justin Walford will talk about libel and privacy and discuss 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.
 
Power is Everywhere: How stakeholder-driven media build the future of watchdog news
Mark Lee Hunter
Media controlled by stakeholder groups, such as Greenpeace.org or Breitbart.com, are changing the rules and the economy of watchdog journalism. Instead of addressing public opinion, they address communities of action and influence, telling them not only what matters,, but what to do about it. In this talk, based on a new, free e-book of the same title, we will look at the deep roots of this phenomenon, and above all, at how investigative journalists can live from and with this movement without sacrificing their values. 

Story-Based Inquiry 1: 
Hypothesise your story
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
Create the Timeline and Scenarise the story
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: From Source Mapping to the MasterFile
Build assets for the story and beyond
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: Craft the Story
From narrative effects to quality control
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 time and anguish, for you and your colleagues. 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 watching. We finish with quality control - reducing the risk of mistakes that can cause damage to others and your own reputation.

Tableau Data Viz 1
Sophie Sparkes and Florian Ramseger
Introduction to data journalism with Tableau Public:
- How to create simple charts (bar charts, line charts and maps)
- How to add simple interactivity to charts
- How to publish and embed visualization in your article
Bring own laptop. 
Please install Tableau Public prior to the start of the class.
https://public.tableau.com

Tableau Data Viz 2
Sophie Sparkes and Florian Ramseger
More advance data journalism with Tableau Public:
- Data cleaning and data preparation in Tableau
- More advanced formatting of charts
- Designing charts for mobile
Bring own laptop. 
Please install Tableau Public prior to the start of the class.
https://public.tableau.com
 
 

Data Journalism (CAR)

Note: B signifies the beginner’s course, A is the advanced course. Courses with numbers (eg Excel 1, Excel 2, Excel 3…) should be taken in sequence.
 
You do not need to have your own laptops for these classes. All classes take place in computer labs. Number of places is limited. Places are allocated on first come, first served basis. 
 
 
You’re new to data journalism and not sure how to get started adding data skills to your reporting toolkit? Or you’ve been to the Summer Conference before but see new data courses and want to know what they’re about. We’ll introduce you to data journalism, go over how to succeed in building your skills and answer your questions. This session is where it all begins.
Spreadsheets are a great way to get started with CAR. But what happens when that dataset gets a little too big, or your analysis too complex? That's when it's time to move to a database manager like Microsoft Access. This class will introduce the basics of working with databases, including basic queries, filtering and sorting.
 
The second Access course continues by introducing more complex analytical tools and techniques. The session will cover grouping, counting, summing and other aggregate functions.
 

Access 3: Joining Databases for Deeper Analysis

Basic analytical techniques only go so far when you have multiple datasets to work with. The third class in the database series introduces the real power of relational databases. In this session, you will learn how to take multiple tables of data and stitch them together to find hidden gems that make a great story.

Data Management: Importing and Cleaning Data (B) Hands-on
Caelainn Barr and Helena Bengtsson
You’re learning your data analysis skills and discovering how to find great story ideas in data. But you’re also discovering most data are not in great shape when you get databases from other sources or the web. And you’ve got to get that data into the apps you use for analysis. Learn strategies and techniques for importing the data into the tools you use and for cleaning that bad data.
 

 
See the timetable for trainers
Data is everywhere – from government computers to websites. This course introduces data analysis using Microsoft Excel. Spreadsheets can help reporters find story ideas in the data. Participants will learn basic calculations, rates, ratios and analytic tools that generate story ideas. 
 
See the timetable for trainers
The second spreadsheet course covers built-in analytical tools, such as sorting, filtering, chart creation that help reporters quickly find great stories within databases.
 

See the timetable for the trainers
To complete your spreadsheet toolkit, learn how to make pivot tables that will summarise trends in your data.

 
Excel 4: Statistics for Journalists (A) Hands-on
Crina Boros

Statistical analysis that produces good story tips does not have to be done with statistical software. Reporters comfortable with spreadsheets will find that many stats can be done using Excel. This session takes participants through cross-tabulations and regression analysis using a spreadsheet, and shows how reporters find stories with these techniques.
Fusion Tables: Google's Online Tool for Visualising Data (A)
Crina Boros 
When you examine your data, you see geographical values, such as street addresses, and you realize that seeing a map of your data will help in your analysis while also making a great interactive for users of your website. Learn how to map geographic data with this online tool from Google and add this skill to your data journalism toolkit.

Graph Database 1 (A) Hands-on
Leila Haddou  

Graph databases are fast becoming the go-to tool for investigative reporters seeking to understand the connections and relationships within their data. Used in the Panama Papers, this session will provide a practical introduction to Neo4j.
No Graph Database experience required. 
In the second session you will learn how to merge multiple datasets into the graph and the basics of the Cypher query language. 
No Graph Database experience required.

Python - 1 (A), Hands-on
Caelainn Barr and Will Franklin
In Python I we will introduce some basic programming concepts such as variables and functions, and learn some simple techniques that you can use to analyse and interrogate your datasets.

Python - 2 (A), Hands-on
Caelainn Barr and Will Franklin
Building on the lessons we learnt in the first class, in Python II we’ll look at  more advanced techniques to analyse and find patterns in the data for your story.

R - 1 (A), Hands-on
Caelainn Barr and Karrie Kehoe
In the first class, R I, we'll talk about the origins of R, what it can be used for, take a tour around RStudio, import data and learn some basic functions for getting to grips with our dataset.

R - 2 (A), Hands-on
Caelainn Barr and Karrie Kehoe
In R II we'll get down to some data wrangling and learn how to sort, filter, join and carry out some other basic functions in R that will allow you to identify trends in the data for storytelling.

R - 3 (A), Hands-On
Caelainn Barr and Karrie Kehoe
In the third and final class, R III, we'll explore some of the statistical packages in R and use ggplot2 for basic visual analysis.

 SQL 1: Learning Structure Query Language to Take Control of Your Data (A), Hands-on
Crina Boros and Helena Bengtsson
You’re using Excel and finding good stories in data. But you’re also needing to manage all of that data, store it and retrieve what you need from. Structured Query Language is the industry standard for data management and is its own analytical tool. This course gets you started learning SQL.
 

 SQL 2: Advancing your SQL Skills (A), Hands-on
Crina Boros and Helena Bengtsson
This second course in SQL builds on the first. You’ll learn more SQL commands to manage and analyse your data. After completion of this second SQL session, you should be on your way to including SQL as an important part of your data journalism toolkit. The instructor also will talk about how to continue your SQL development and what SQL apps are available on all platforms.

Tableau Data Viz 1
Sophie Sparkes and Florian Ramseger
Introduction to data journalism with Tableau Public:
- How to create simple charts (bar charts, line charts and maps)
- How to add simple interactivity to charts
- How to publish and embed visualization in your article
Bring own laptop.
Please install Tableau Public prior to the start of the class.
https://public.tableau.com
 
Tableau Data Viz 2
More advance data journalism with Tableau Public:
- Data cleaning and data preparation in Tableau
- More advanced formatting of charts
- Designing charts for mobile
Bring own laptop.
Please install Tableau Public prior to the start of the class.
https://public.tableau.com.