Would you like to receive notifications about more lessons?

Close icon
Sign-up to Africa Data Hub Newsletter for updates on training.

Training

An introduction to using data in Journalism

An introduction to Google Sheets

7

minutes

View all courses
>

An introduction to using data in Journalism

>
An introduction to Google Sheets
>

Next Lesson

>
Next Course

Choose a lesson

An introduction to Google Sheets

7

min

Working with data in Google Sheets

15

min

Using data visualisation in journalism

8

min

How to choose the right chart/graph

6

min

How to create charts in Google Sheets

9

min

About this lesson
Instructors
More Courses

About this lesson

In this lesson you will learn: 1) What a Google Sheets header row is and how to manipulate it 2) How to check the format of your data 3) How to make a copy of the original data.

In this lesson you will learn:

1. What a Google Sheets header row is and how to manipulate it

2. How to check the format of your data

3. How to make a copy of the original data.

Lesson Resources

Download icon

Resources used in this lesson are available to download

Download resources

More courses

How to clean, summarise and analyse data

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.

5

lessons

36min

Formulas, functions, averages and ranking in Google Sheets

You can do data journalism without a maths or data science degree. In this course, you will learn how to do simple calculations in Google Sheets that will help you calculate and communicate data as evidence in your story telling.

5

lessons

1h 11min

Sorting and cleaning data for journalism

This course will teach you where and how you can source data for your journalism stories, how to clean and organise data so that it’s ready for analysing and visualising in your data story.

5

lessons

46:13min

View all ADH courses

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
Mapped data
Vaccine Tracker
COVID-19 Observer
Data Repository
Knowledge and feedback
Glossary
Attribution Guide
User survey
Cookie policy
Code of conduct
Newsletter
Our Brand
Contact
info@africadatahub.org
Social media
© Africa Data Hub. Open Cities Lab is a non-profit organisation DSD: 255-261NPO / PBO (18A): 930067929. The ADH project is Licensed under a Creative Commons Attribution 4.0 International License.