Module 1–MONDAY MORNING, June 21

Go back to main resources page

This module introduces you to the basics of data journalism and to Microsoft Excel. We have two introductory videos, and then you’ll watch a video from David McKie on basic analysis with Excel.

First, watch the introduction to data journalism video (runs 7:54).

This video was created originally for the 2020 summer data school so some details are dated. However, the main points are the same.

Next, watch the video on “what do we mean by data?” (runs 9:01)

This video was also created originally for the 2020 summer data school.

Now that we have introduced you to data journalism and talked about data, we’ll start with our first instructional video. In this video, you will learn how to download hate-crime data from Statistics Canada’s Police-reported hate crime data broken down by cities, and analyze the data by sorting and filtering.

Make sure you have a browser and Microsoft Excel open before you begin watching the video, so you can follow along and repeat the steps on your computer.

David uses a number of links in his demonstrations. You can find them here.

You can start and stop the video below as you go along.  This is the web link David uses in the video to obtain the hate crimes data.

From the textbook: Chapters 1,2 and 3 of The Data Journalist provide an introduction to data journalism and obtaining data. Chapter 4 is an overview of spreadsheets. Sorting and filtering are covered on pages 57-59. Additional online tutorials can be found at https://learninglink.oup.com/access/vallance-jones-student-resources#tag_appendix-a

Live session recording, morning module, June 21

Go back to main resources page

We are proud to work with our partners and sponsors