How create simple data visualisations in Google Sheets

10:41

minutes

View all courses

>

Sorting and cleaning data for journalism

>

How create simple data visualisations in Google Sheets

>

Next Lesson

>

Next Course

Choose a lesson

How to get started with sourcing, cleaning, and visualising data in Google Sheets

9

min

How create simple data visualisations in Google Sheets

10:41

min

How to source and scrape data to support your journalism

01:31

min

How to scrape data from PDF documents using Tabula

15:03

min

How to scrape fixed table data from a website using ImportHTML

10:38

min

About this lesson

Instructors

More Courses

About this lesson

In this video you will learn: 1) How to choose the correct chart in Google Sheets 2) What not to do with data visualisations

In this lesson you will learn:

1. How to choose the correct chart in Google Sheets

2. What not to do with data visualisations

Lesson Resources

Resources used in this lesson are available to download

Download resources

Lesson instructor

Tegan Bedser

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

More courses

Tools for visualising data in journalism

Visualisations bring the “ooooh” factor to data-driven journalism, but their purpose is greater than simply making your story “pretty”. This course will teach you where and how you can source data for your journalism stories, how to clean and organise data, as well as how to visualise data using simple charts.

2

lessons

38:78min

An introduction to visualising data using choropleth maps

In this course you will learn how to visualise data using a template map and a map you have found yourself. You will also learn how to source, visualise, and add data to a map for your story using Mapshaper, Datawrapper, and Flourish.

5

lessons

1h 33min

How to do solutions journalism

This course introduces you to the concept of solutions journalism through a series of lectures by experienced members of Solutions Journalism Network. It is intended to make you conscious of why this form of journalism is valuable and necessary. The introduction to solutions journalism is also aimed at helping you get started in the process of producing your own solutions journalism story.

5

lessons

40min

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

Knowledge and feedback

Contact

info@africadatahub.org

Social media