Welcome to the 2021 data journalism in Africa masterclasses by Media Hack Collective. Course materials and resources will be available here.

 

Table of contents

1. Weekly meetings
2. Guest speakers
3. Data repositories
4. Gates Goalkeepers report 2021
5. Web scraping
6. Data visualisation
7. Custom maps
8. Basic maths for journalists
9. Spreadsheets: How to interview a dataset

 

 

📅 Weekly meetings

 

 

Final meeting: 8 November 2021

  • Topic: Your data story
  • Recording: Link here
  • Password: Same password as the speaker and lesson videos.

Week 5: 10 November 2021

  • Topic: How to tell stories with data
  • Recording: Link here
  • Password: Same password as the speaker and lesson videos.

Week 4: 3 November 2021

  • Topic: How to find, structure and create datasets
  • Recording: Link here
  • Password: Same password as the speaker and lesson videos.

Week 3: 27 October 2021

  • Topic: Data visualisation: How to make complex data easy to understand
  • Recording: Link here
  • Password: Shared on email and in the WhatsApp group.

Week 2: 20 October 2021

  • Topic: Spreadsheets: How to “interview” a dataset
  • Recording: Link here
  • Password: Shared on email and in the WhatsApp group.

Week 1: 12 October 2021

  • Topic:  Introduction: What is data journalism?”
  • Recording: Link here
  • Password: Shared on email and in the WhatsApp group.

 

📣 Guest speakers

Several guest speakers are sharing their insights and experience in the masterclasses. There will be a guest speaker either as a live Q&A or a pre-recorded video will be made available to you. If the speakers are available for a live call, we will alert you ahead of time. 

The guest speakers talk freely about their work and as a result, these video recordings are password protected. The videos are for training purposes only and not for public distribution. We ask that you respect this and not share your password.

 

The things that you need to look out for when you have science data with Mia Malan, Bhekisisa Editor-in-chief and Executive Director

 

One of my favourite data stories – and how I did it with Ron Nixon, The Associated Press Global Investigations Editor

 

From statistician to data journalist with Purity Mukami, Finance Uncovered statistician and data journalist

 

You can do data journalism without a maths degree with Purity Mukami, Finance Uncovered statistician and data journalist

 

My experience with the Pandora Papers with Purity Mukami, Finance Uncovered statistician and data journalist

 

Tips for doing data stories in Nigeria with Joshua Olufemi, Dataphyte founder and publisher.

 

Nigerian data project: Mapping Makoko with Jacopo Ottaviani, Code for Africa Chief Data Editor

 

Data journalism tips: My experience with Citizen TV with Patricia Andago, Odipo Dev Researcher

 

How to find good African data with Kate Wilkinson, Africa Check Deputy Chief Editor

 

The ABCs of data journalism with Athandiwe Saba, Mail & Guardian Deputy Editor

Articles

 

🗄️ Data repositories

How to download data from data repositories

 

 

How to open CSVs in Excel

 

 

📄 Gates Goalkeepers Report 2021

Gates Goalkeepers Report data insights with Senoe Torgerson, Bill & Melinda Gates Foundation Senior Program Officer

 

📄 Web scraping

Using ImportHtml to import data into Google Sheets (part 1)

 

 

Working with ImportHtml (part 2)

 

 

Extracting data from PDFs using Tabula

 

📊 Data visualisation

Why should you do data visualisation?

 

 

Choosing charts

 

 

Datawrapper

Sign-up for a free account here.

 

 

Flourish

Sign-up for a free account here.

 

 

Google Charts

 

 

Demo and assignment: Data story

We want you to replicate the visualisation that was created and presented in the virtual meeting on Wednesday, 27 October 2021. This video will take you through the steps. Your exercise assignment is in your folder.

 

 

Effective data storytelling

 

Presenting readers with data can be overwhelming to them if not done right. This talk by Media Hack co-founder, Alastair Otter, at the African Investigative Journalism Conference focuses on a high-level overview of the process of turning data into stories and looks at the various methods and approaches that can be used.

 

Putting it all together: scraping data and creating a map in Datawrapper

The WHO report is available in your Google Drive folder. If you need to download Tabula, here is the link.

 

 

Resources: JSON files

Africa
openAFRICA

Kenya
Counties

Nigeria
Local government areas

South Africa
Municipal Demarcation Board

Uganda
Districts

Zimbabwe
Districts

 

📍 Custom maps

Mapshaper

https://mapshaper.org/

 

Custom maps: Flourish and Mapshaper

 

 

Custom maps: Case study

 

 

🧮 Basic maths for journalists

Introduction

 

 

Average: Case study

 

Average, Mean, Median and Mode

 

 

Formula: Average

 

Formula: Median and Mode

 

 

Formula: Rate

 

 

Formula: Rank

 

 

Formula: Percentage change

 

 

🔍 Spreadsheets: How to “interview” a dataset

Introduction

 

 

Best practices and tips

 

 

Structured data

 

Filtering

 

 

Sorting

 


Summarising

 

 

More on pivot tables