Module 4–TUESDAY AFTERNOON, May 23

Go back to main resources page

Spreadsheets were made for doing math, and luckily for us, they make the math easy. This module covers some of the most common calculations you’ll do in Google Sheets.

Download the data used in the first video. The data is in csv format and will need to be uploaded to Sheets.

Watch the video on calculating percentages in Google Sheets (runs 12:08). Or download.

Download the data for the second video on averages and medians. It is in csv format and will need to be uploaded to Google Sheets.

Watch the video on calculating averages and medians in Google Sheets (runs 5:39). Or download.

Exercise for videos above

Download the data for the exercise (csv format)

  1. You will work with a dataset of COVID-19 cases per month (csv). You will need to upload it to Google Sheets. Replicate the steps in the video, this time working out the percentage of all COVID-19 cases, for each month, for each country. Don’t forget to convert your formulas to values using paste special, as shown in the video, once you have calculated the percentages.
  2. Using the skills your learned in the first module, on interviewing and sorting, sort the sheet to show which countries had the highest percentages of the cases. Do this for each month and make note of the results. Don’t forget to freeze the first row, as shown in the video for module 1, before sorting.
  3. Working with the dataset of COVID-19 cases per month (same as in 1 above), work out the percentage change in the number of cases from March to May. Don’t forget to convert your formulas to values using paste special, as shown, once you have calculated the percentage change figures.
  4. Using the skills you learned in the first module on sorting, sort the sheet from largest to smallest percentage change and smallest to largest. Make note of the results.
  5. Based on the results you found in 2 and 4 above, think about the kinds of stories you might tell. Be ready to discuss in the live session.

Supplemental material

The next video uses the same data as in the first three modules. Download here or directly from the European Centre for Disease Prevention and Control.

Watch the video on calculating rates. Or download the video.

 

David McKie has prepared a tutorial that goes through the steps (pdf format) shown in the video on rates.

Exercise

Try using the steps in this video to calculate deaths as a percent of the reported cases.

Live session east: 7 p.m. Atlantic, 6 p.m. Eastern

Live session west: 7:30 p.m. Eastern, 6:30 Central, 4:30 Pacific

Go back to main resources page