Data Journalism Winter Bootcamp 2015

    From Excel to SQL - learn how to manage datasets and find stories

    Goldsmiths, University of London
    5 January 2015 - 9 January 2015
    This five-day workshop on database journalism is designed for reporters with little or no knowledge of data journalism and will give you a foundation in the essential skills.
     
    This course is now fully booked. Please email juliet@tcij.org to be added to the waiting list.
     
    Course fees:
    Full price: £500
    NUJ member: £375
    Student: £250
    SQL only (last three days): £300
     
     

    Course Outline

    This five-day workshop in data journalism, also known as computer-assisted reporting, is designed for reporters with little or no knowledge of data journalism and gives a foundation in the essential skills. By the end of the workshop, attendees will be able to produce data-driven, evidence-based stories and investigations that will make a difference in their newsrooms and the communities they serve.

    Reporters who have some spreadsheet skills but need to learn how to manage and use larger data sets can attend this portion of the workshop at a reduced cost. The last three days will take their existing skills to a new level, giving them the ability to make greater impact with database-driven stories.
     
    Please get in touch with Juliet: juliet@tcij.org if you have any questions.
     

    Timetable

    You can also download a word document version of the timetable.

     

     
     
     
     
     
     
     

    MONDAY, 5 January
    9 - 9.30am               Registrations
    9:30 - 10:30am        Introduction: What data journalism is and its place in the newsroom
    10:30 - 11.15am      Best practices and introduction to spreadsheets
    11:30 – 12.30pm     Spreadsheet exercises: formulas
    12.30 - 1:30pm        Lunch
    1:30 - 4pm               Spreadsheet exercises: filtering and sorting and Q&A
    4.15 – 5.30pm         Freedom of Information in the UK with FOIA expert, Jenna Corderoy

    TUESDAY, 6 January
    9.30 – 10 am           Using spreadsheets for stories and review
    10 – 12.30 pm         Spreadsheets exercises: pivot tables
    12.30 – 2:30 pm      Lunch and open lab
    2:30 – 3.30 pm        Using Google Fusion Tables with Crina Boros
    3:30 – 4:30 pm        Spreadsheet exercises: Analysing data, problem-solving, data cleaning
    4:30 – 5:30 pm        Finding data for spreadsheets and importing and Q&A

    WEDNESDAY, 7 January  
    9 - 10 am                  Moving from spreadsheets to databases     
    10 - 10:30 am           Using database managers for stories
    10:30 am - Noon      Introduction to Structured Query Language (SQL)           
    Noon - 2:30 pm        Lunch and open lab
    2:30 - 5 pm               Database and SQL exercises: The Select statement
    5 – 6 pm                   Database and SQL exercises: The power of aggregating data

    THURSDAY, 8 January
    9 - 10 am                  Moving from flat files to relational databases
    10 - 11 am                Using relational databases and SQL for stories
    11 am – Noon          Database and SQL exercises: Joining           
    Noon - 2:30 pm       Lunch and open lab
    2:30 - 5 pm              Importing and cleaning data for databases with SQL; building your own databases;   
    5 – 6 pm                  Analysing data and problem solving and Q&A

    FRIDAY, 9 January
    9 - 10 am                A data analysis perspective
    10 - 11 am              Interviewing your data for statistical analysis. Working cross functions/SQL
    11 - 12:15 pm         Working with categorical variables: Frequencies, crosstabs and significance tests
    12:15 - 1:30 pm      Lunch
    1:30 – 3:00 pm       Moving up the ladder to continuous variables: Regression analysis
    3:00 – 4:30 pm       Continue regression analysis
    4:30 – 5 pm            Wrap up: Q&A and taking it back to the newsroom