Comprising of video lectures, tutorials, assignments, readings and discussion forums, this course is open to anyone in the world with an Internet connection who wants to tell stories with data.
The 5 modules are:
- Module 1 - Data journalism in the newsroom
- Module 2 - Finding data to support stories
- Module 3 - Finding story ideas with data analysis
- Module 4 - Dealing with messy data
- Module 5 - Telling stories with visualisation
Every module is divided into 4 sections. Every section contains one video of approximately 15 minutes. We estimate that the average time a student has to spend on a module (or 1 week), is about 4-5 hours.
Our recommendation is to complete one module per week. Not faster, in order to let the learned material sink in, and not slower in order to stay on top of things. You are free however, to complete the course at your own pace. Meaning that if you feel you comprehend a module, and you have enough time, you are free to advance to the next one. Alternatively, if you don't have enough time one week, you are free to postpone it, and catch up later.
Module 1: Data journalism in the newsroom
This module is an introduction to data journalism. It shows what data journalism is, how it works on a busy news desk and what skills you need to know to practise it.
- Module introduction (01:29)
- What is data journalism? (13:06)
- Inside a data team (14:39)
- How to turn numbers into stories (15:38)
- The business case for data journalism (11:18)
Module 2: Finding data to support stories
This module deals with the range of skills that journalists use to obtain data. This includes setting up alerts to regular sources of information, simple search engine techniques that can save hours of time and using laws in your own and other countries.
- Module introduction (02:03)
- Setting up ‘data newswires’ (12:55)
- Strategic searching - tips and tricks (17:23)
- Introduction to scraping (14:37)
- Data laws and sources (17:59)
Module 3: Finding story ideas with data analysis
This module focuses on using spreadsheets and basic statistics to find patterns in data that will reveal story ideas and add evidence to the resulting stories.
- Module introduction (01:49)
- Newsroom math and statistics (15:46)
- Sorting and filtering data in Excel (15:57)
- Making new variables with functions (18:14)
- Summarizing data with pivot tables (16:19)
Module 4: Dealing with messy data
This module addresses messy data - data that needs to be organised before it can be used. It covers the so-called ‘cleaning’ process, at the end of which the dataset can be analysed using techniques from Module 3.
- Module introduction (01:31)
- Optional: OpenRefine tutorial (12:18)
- Correct bad formatting (13:14)
- Misspellings (15:22)
- Invalid values and duplicates (16:00)
- Advanced cleaning techniques (13:42)
Module 5: Telling stories with visualisation
This module deals with how to transform data into stories, infographics and interactive visualizations: the best practices and the principles of graphic design that a journalist needs to know.
- Module introduction (02:15)
- The main principles of datavisualisation (15:45)
- Choosing the best graphic forms (26:28)
- The art of insight (19:25)
- Bonus: Hands-on with Adobe Illustrator (17:15)