Data Journalism – Google Sheets
Googlesheets 1
Data journalism introduction: an overview of the seven building blocks behind data stories. The basics: using Googlesheets to carry out basic calculations and percentage increases.
Googlesheets 2
Finding your top line: sorting and filtering in Googlesheets/Excel. With handy/fun tools such as split, concatenate, currency conversion, translate.
Googlesheets 3
Quick-smart data summary/analysis using pivot tables, merging datasets (VLookUps) and basic scraping using Google’s import tools.
Technical Requirements
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.
Luuk Sengers
Luuk Sengers is an experienced teacher and investigative journalist. He lectures at universities and in newsrooms and writes data-driven stories for the leading Dutch magazine De Groene Amsterdammer. He is also the co-developer of Story-Based Inquiry.
Pamela Duncan
Pamela Duncan is the editor of the Guardian’s Data Project team, an occasional award-winning journalist (#humblebrag) and a self-confessed data nerd. She can usually be found at her desk poring over spreadsheets and using her coding skills - usually a combination of scraping, regex and pandas/Python - to build and analyse datasets to produce high quality and exclusive data stories.
- 4 July 2019 10.45–15.00
Location: Room 104 - PSH Building - Goldsmiths, University of London