Module 1–MONDAY MORNING, June 22
This module introduces you to the basics of data journalism. We have two introductory videos, and then you’ll start working with data on COVID-19 as you learn how to get to know a dataset and do some simple sorting.
First, watch the introduction to data journalism video (runs 7:54) or download it,
Next, watch the video on “what do we mean by data?” (runs 9:01) Or download.
Now that we have introduced you to data journalism and talked about data, we’ll start with our first instructional video. Before you watch it, you’ll need to download the data used in the video.
The data is in Excel format. Make sure you save it on your computer, so you can upload it to Google Sheets.
Note: All of the Google Sheets modules, Monday and Tuesday, use the same dataset from the European Centre for Disease Prevention and Control (download link above). You can read an explanation for how this dataset was collected here. If you would like up-to-date data, you can download it from the original source. Both XLXS and CSV versions are available there.
Now, watch the video on interviewing data and sorting in Google Sheets (runs 13:33) Or download it.
Make sure you have Google Sheets open before you begin watching the video, so you can follow along and repeat the steps on your computer (if you are unfamiliar with Google Sheets, go back and watch the introductory video).
You can start and stop the video below as you go along.
Exercise to practice your skills
Keep working with the same data in Google Sheets. Examine the data further, and practice sorting different columns. David McKie prepared this tutorial (pdf download) to go along with his video.
Live session east, on Zoom: 1 p.m. Atlantic/12 Eastern
Live session west: 2 p.m. Eastern/1 p.m. Central/11 a.m. Pacific
From the textbook: Chapters 1,2 and 4 of The Data Journalist. Chapter 4 focuses on Excel, which is the desktop equivalent of Google Sheets. The principles are the same as are most of the functions. If you want to follow up with Excel, you can do that using the textbook as a guide.