How to clean, summarise and analyse data

lessons

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

minutes

Start course

Course introduction

As a journalist, you interview a lot of people for your stories; you should interview your data as if you were interviewing a person. In this module you will learn how to view, edit, and organise data in spreadsheets to inform the questions that your journalism output aims to answer.

Course lessons

Course introduction

How to structure data

min

How to filter data

min

How to sort data

min

How to summarise data

min

How to create a pivot table

min

instructors

Tegan Bedser

Tegan Bedser is a project manager for training and editorial projects at Media Hack Collective (MHC).

Get started

How to structure data

In this video you will learn: 1) What is structured data 2) How to hide and insert columns and rows in Google Sheets to analyse data. 3) How to format and verify data in Google Sheets.

Start this lesson

Get feedback

Request assignments to test your skills and get feedback from our instructors.

Email us now for support

course development in partnership with

We believe in the power of data to help us to understand the world around us and improve it. And we know that good visualisations are a powerful way to communicate insights.

FAQ

Be the first to know about our new training material!

Africa Data Hub seeks to lower the barriers that African journalists face to access and use data in their storytelling around health and development.

This work is supported by the Bill & Melinda Gates Foundation.

Data resources

Knowledge and feedback