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

Course Introduction

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 course you will learn how to view, edit, and organise data in spreadsheets to inform the questions that your journalism output aims to answer.

Start Course

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

FAQ

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