Module 6–WEDNESDAY AFTERNOON

Go back to main resources page

Seeing is believing, and that’s true in data journalism as well. During COVID-19, visualizations have been everywhere, from column charts showing the trend in new cases over time, to line graphs showing the curve of cumulative cases and deaths. Datawrapper is a great, free tool that you can use to make surprisingly sophisticated visualizations with the kinds of scales, transitions and eye-appeal that used to require learning a hard-to-learn tool such as d3.JS. You can still do more with code, but you can do a lot with Datawrapper.

This module is a little less intensive than this morning’s.

You’ll need to download datawrapper and create an account before starting the videos.

For the first video, you will work with the Excel sheet you create in the first half of this morning’s module (rolling average of cases per 100,000 by province).

Watch part 1 of the video on creating visualizations with Datawrapper.

Watch part 2 of the video on creating visualizations with Datawrapper.

Link to data used in the second video (opens in new tab)

Wednesday afternoon exercises

Make a working copy of the sheet you created for the IF function exercise this morning. You can do this in a new workbook, or in a new worksheet in the same book.

It’s probably a good idea to get rid of the values for Canada from your new working copy before proceeding with this exercise. Just remember to keep your original copy of the data.

Now, following the methods in the first Datawrapper video, make a line chart of the proportion of fully vaccinated individuals, by province. Try to make the chart look good. You may have to make some choices.

For more practice, try making some charts of your own! What can you learn from charting the different columns, including the ones you calculated this morning?

Live session: 5 p.m. Eastern (Recording below)

Go back to main resources page

We are proud to work with our partners and sponsors