Introduction​ ​to​ ​Data​ ​Journalism

    Boost your journalistic and investigative skills with #data. A course for beginners. 

     

    Goldsmiths University of London
    27 September 2017 - 28 September 2017

    Bookings

    Big organisations (10+ people) - £285
    Freelancers/small orgamisations (9 people and fewer) - £255
    Full-time students - £110
    Goldsmiths students: contact marina(at)tcij.org for Goldsmiths discount. 

    Please REGISTER HERE FIRST
    To pay with PayPal - see below. You can make a payment even if you do not have a PayPal account. 

    Why​ ​should​ ​you​ ​know​ ​how​ ​to​ ​find​ ​stories​ ​in​ ​spreadsheets?​ Data analysis has become an indispensable tool for investigative reporting and research, but also a very sought-after skill for beat reporting. By crunching a few numbers or learning to aggregate, you can discover whether a problem is systematic or incidental, find the good or bad news story at a graph’s glance, or discover the devil in the detail.

    Course Outline

    This workshop is designed for​ ​entry​ ​level​ ​skills​: if you have never opened a spreadsheet, or if you have but are not able to do much in it, you’re invited to discover the power of spreadsheets for reporting. We will get you up to speed with what you need to know, and over the hump in class so that you can start DDJ-ing in your newsroom the day after.

    *For​ ​Participants​ ​who​ ​wish​ ​to​ ​bring​ ​their​ ​own​ ​machines: unfortunately, there will be no time to install EXCEL in class. Participants may bring their laptop if they have already installed EXCEL. All participants must have admin right over their laptops. Excel online will not work. Nor will Numbers or LibreOffice Calc. Google spreadsheets will have limited use.

    WEDNESDAY,​ ​27​ ​September
    9:00– 9.30       Registrations
    9:30 – 10:30    Introduction: What data journalism is and its place in the newsroom. Best practices and introduction to spreadsheets
    10:30 – 11:15  Types of data, where and how to find them. Data & transparency laws overview
    11:15 - 11:30   Coffee break
    11:30 – 12:30  Spreadsheets interviews with formulas 

    12:30 – 13:30 Lunch

    13:30 – 14.30  What questions can filtering and sorting answer?
    14:30 – 14:45  Coffee break
    14:45 – 16:00  Dig deeper with pivot tables
    16:00 – 16:15  Coffee break
    16.15 – 17.30 ​ ​Graphs, pie charts, sparklines and other data vis demons and Q&A

    THURSDAY,​ ​28​ ​September 
    9:30 – 10:00  Quick data cleaning, importing and formatting tips
    10:00 – 12.30 Spreadsheets uncovered: reviewing all learnt spreadsheet skills

    12:30 – 14:30 Lunch and open lab

    14:30 – 15:30  Interactive data viz using online apps - you’ll get to vote which one!
    15:30 – 15:45  Coffee break
    15:45 – 17:00  Beyond the spreadsheet - quick introduction to SQL Lite browser app
    17:00 – 17:30  How to carry on learning: resources and Q&A

    About the trainer

    Crina Boroş is an investigative journalist reporting on HSBC leaks, UK and offshore money-laundering, Afghan victims’ compensation, women’s rights, EU lobbying, workers’ abuse, civil service transparency and accountability. Her work for Greenpeace's Energy Desk on fishing quotas was recently shortlisted for the 2017 Paul Foot award. She specialises in data journalism / CAR, cross-border, freedom of information and undercover reporting. She has produced front-page headline-generating features, statistical analysis and watchdog reporting. She is a CAR (data journalism) trainer and member of Investigative Reporters and Editors (IRE).

    'Very knowledgable, but down-to-earth [trainer]. Communicated in a very accessible and humorous way. Gave great real world examples and tips.'

    Please REGISTER FIRST then make a payment. CIJ bank details can be found on the registration form. 
    Don't have a PayPal account? No worries! You can make a PayPal payment with a credit/debit card. Just click below. 


    Pay now