Data Journalism Spring Bootcamp 2014

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

    City University London, Northampton Square, EC1V 0HB
    14 April 2014 - 18 April 2014
    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.
    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 note: For this course you need to bring your own laptop for Friday 18 April only. All our courses are scheduled to go ahead subject to a minimum number of attendees signing up. The minimum number for each course differs and this is just to enable us to cover costs of the training venue and trainer fees where applicable. We will give at least one month's notice should courses be cancelled or postponed.

    Please get in touch with Minal: if you have any questions.

    Training venue:

    Room Level B307a, University Building,
    Northampton Square,
    London, EC1V 0HB.

    Monday, 14 April
    9 - 9.30am              Registrations and coffee

    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

    Tuesday, 15 April
    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
    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, 16 April
    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, 17 April
    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; negotiating for data
    5 – 6 pm                  Analysing data and problem solving and Q&A

    Friday, 18 April
    9 - 10 am               Recent stories using advanced techniques – a data analysis perspective
    10 - 11 am             Interviewing your data for statistical analysis
    11 - 12:15 pm        Working with categorical variables: Frequencies, crosstabs and significance tests
    12:15 - 1:30 pm     Lunch
    1:30 – 3:00 pm       Making and mushing categorical variables: Recoding for frequencies and crosstabs
    3:00 – 4:30 pm       Moving up the ladder to continuous variables: Linear regression
    4:30 – 5 pm            Taking it all back to the newsroom

    View the Freedom of Information presentation