Journalism 4208 and 5508, Section E, Fall 2017

Data Journalism research methods, Fall 2016 JOUR 4101 – E Wednesdays 19:00-22:00
Location: Room 1105 Richcraft Hall (the TV Newsroom)Instructor:
David McKie

181 Queen Street
Phone Number: 1-613-288-6523 (office) 1-613-290-7380 (cell)
Teaching Assistants:
Muhammad Zeeshan

Phone Number: (613) 700-0352
Kent Jacobs
Phone Number: 613-406-5250

Data journalism stories |  What you will learn |    Needs and Special Accommodations  | Assignments and deadlines |  Week one | Week two | Week three | Week four | Week five | Week six |Week seven | Week eight | Week nine | Week ten | Week eleven | Week twelve | Week thirteen | Assignment One | Assignment One |Assignment Two| Assignment Three | Assignment Four | Readings | Additional Reading |Tutorials | Datasets |


The goal of the Data Journalism Storytelling course is to teach students how to find and negotiate for data that is already publicly available, or must be obtained formally or informally through a federal access-to-information or provincial or municipal freedom-of-information request. We will analyse the records using the following: Excel; MySQL, the data-visualization such as Tableau Public and  ArcGISOnline; the document-annotation software called DocumentCloud; and the mapping program called Qgis.

Taken together, these skills comprise computer-assisted reporting, now more commonly known as data journalism. Our textbook is The Data Journalist: Getting the Story

At the end of this term, students will become adept at searching for information, perusing and downloading files from government open-data websites, analyzing the material for story ideas, or for questions that could lead to stories. They’ll learn how to use Excel or MySQL to spot trends, and employ data-visualization and mapping programs to show the patterns and allow readers to interact with the material, such as being able to identify the income level or levels of crime in their neighbourhood.

As well, they’ll be taught how to perform spatial joins, allowing them to, for instance, see how many income groups, federal contaminated sites, oil spills, construction projects, discarded needles and syringes and government grants fall within certain municipal, provincial and federal electoral boundaries. These matches, and more importantly the story ideas that are produced, can only be obtained using mapping software ArcMap and Qgis.

For instance, spatial joins have allowed journalists such as Glen McGregor, formally with the Ottawa Citizen and now  with CTV News, to tell the story about the bodies of water protected under the former Harper government’s Navigable Waters Protection Act located in or near federal Conservative ridings.

Working with census data, students will also learn how to map characteristics such as income level, much the same way former Montreal Gazette journalist, Robero Rocha, did to help readers visualize the median household income.  This exercise will be good preparation for the 2016 long-form census results , which  Statistics Canada is publishing this year.

Stories and visualizations will be submitted as blogs on this course’s WordPress site, allowing for a multi-media treatment. Documents used as reference material will be uploaded to the account that will be created for you in DocumentCloud, annotated, and then embedded into the blogs.

Though it’s designed to be a data-journalism-focused research methods course, there will also be a heavy emphasis on storytelling, both with words and data in properly-labelled and sourced interactive maps and charts. As such, we will begin each class with a story that has appeared in the news: either as an example of how data journalism was used, or how it could have been used. These discussions and the exercises will help students develop new analytical and storytelling skills.  Specially designed tutorials based on data used in this class, and tutorials from The Data Journalists will be used to drive home some of the key spreadsheet and mapping skills that will form the course’s backbone.

The course will be divided up into four, three-week modules. Each module will teach the following skills: Excel; MySQL, analysis using the mapping  software Qgis; and visualization using ArcGIS Online and OpenStreetMaps.

There will be four assignments ( please see chart below ), building to a final assignment that combines all the skills we’ve learned during the semester. There will also be two in-class tests worth five percent each, one to test your spreadsheet skills, the other to gauge your knowledge of conducting basic queries in MySQL.

This is a professional school, and you’ll be held to professional standards in both assignments and conduct. As a student of journalism, you must read and adhere to the School’s policies:

  1. Our ethics policy sets out the rules of behaviour that you, as students and journalists, are expected to follow as you carry out your assignments for this course.
  2. Our publishing policy requires certain authorizations before journalistic coursework can be published outside of the class. In addition, your sources must understand that any assignments they are associated with may be published outside of class.
  3. Our policy on electronic media usage requires that you follow copyright regulations with respect to your use of all materials culled from the Internet.

Undergraduates can find all three policies on this page

Graduates can find all three policies here

You are expected to be familiar with these policies and apply them to your work. Failure to abide by them will adversely affect your standing in the course.

Special needs and Accommodation (TOP)

You may need special arrangements to meet your academic obligations during the term. For an accommodation request the processes are as follows:

Pregnancy obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website:

Religious obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website:

Academic Accommodations for Students with Disabilities: The Paul Menton Centre for Students with Disabilities (PMC) provides services to students with Learning Disabilities (LD), psychiatric/mental health disabilities, Attention Deficit Hyperactivity Disorder (ADHD), Autism Spectrum Disorders (ASD), chronic medical conditions, and impairments in mobility, hearing, and vision. If you have a disability requiring academic accommodations in this course, please contact PMC at 613-520-6608 or for a formal evaluation. If you are already registered with the PMC, contact your PMC coordinator to send us your Letter of Accommodation at the beginning of the term, and no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation from PMC, meet with one of us to ensure accommodation arrangements are made. Please consult the PMC website for the deadline to request accommodations for the formally-scheduled exam (if applicable) at 

You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at

School ethics policy:

School publishing policy:

School electronic media usage policy:

Data Journalism Stories (TOP)

Examples stories using data journalism

How Is Immigration Viewed In The EU?

How to avoid Toronto’s parking ticket hot spots

Fatal Force

New map explores the mysteries of Edmonton’s tax assessments

NSA Files: Decoded

Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds

This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)

Walmart: Thousands of police calls. You paid the bill.

The 100 WORST landlords in Toronto

Settling for Misconduct

To gain access to a running, up-to-date list of the latest data journalism stories, please click here.


1) How to find data on government open-date web portals

2) How to use a spreadsheet to analyze statistics

3) How to create a pivot table

4) How to use advanced functions in Excel

5) How to use technical skills such as exporting tables from PDFs into Excel

6) How to use MySQL

7) How to advance your numeracy skills

8) How to use Tableau Public

9) How to use Qgis , ArcGIS Online, and the web platform, OpenStreetMap

10) How to geocode data points

11) How to become effective storytellers

Assignments and Deadlines (TOP)

Assignments in this course are governed by the provisions of the document Ethics and Standards in the School of Journalism and Communication. There are four assignments, each with a deadline. Lateness will be penalized with the deduction of a half a grade for every day the story is overdue, though exceptional circumstances will be taken into account.

Questions or appeals about your grade on assignments or other graded components of the course should be raised with the instructor no later than seven business days after the grade has been issued, as explained in the university’s academic regulations (2.7 and 2.8). Your final course grade is based on grades earned throughout the term on the assignments and other graded components listed in the syllabus. This means requests to raise an overall course grade at the end of the term or year cannot be considered.

Standing in a course is determined by the course instructor subject to the approval of the Faculty Dean. This means that grades submitted by an instructor may be subject to revision. No grades are final until they have been approved by the Dean.

There is no final examination. Each assignment has two components, all of which will figure in the grade:

A. A description of how the documents and data were obtained, why they were useful and how the material was analyzed

B. The resulting story

Final standing in this course is determined by the course instructors subject to the approval of the Dean of Public Affairs. This means that final grades submitted by the instructors may be subject to revision. No grade is final until it has been approved by the Dean.

Academic Integrity

This course abides by Carleton University’s Academic Integrity Policy. Acts of academic dishonesty include, but are not restricted to, plagiarism and unauthorized resubmission of work, and will be dealt with accordingly.

Students who fake any part of their stories or research, plagiarize anyone else’s work, or otherwise cheat on their assignments will get MORE than just a failing grade. They will be dealt with according to the university’s rules for Academic Integrity.

The full undergraduate policy is here

 The full graduate policy is here



Assignment#1: A story using numbers crunched in Excel due before class on midnight Sept. 22 15%
Assignment #2: Particulars to be announced. Deadline: Midnight Oct. 20 15%
Assignment #3: Particulars to be announced. Deadline: Midnight Nov. 17 20%
Assignment #4: Particulars to be announced. Deadline: Midnight Dec. 4 30%
Two in-class tests (Excel and MySQL, respectively) worth five per cent each on dates in class to be determined. 10%
Participation/professional conduct: For punctuality, informative in-class participation and professionalism displayed by actions such as prompt responses to emailed messages, and the prompt following of emailed instructions regarding the use of certain software. 10%


A+       90-100             A         85-89               A-        80-84

 B+       77-79              B         73-76               B-        70-72

 C+       67-69              C         63-66               C-        60-62

 D+       57-59              D         53-56               D-        50-52

Stories in the A-range are newsworthy, original, accurate, and well-told with very little editing. As such, they are publishable. Stories in the B-range contain similar qualities, but require more editing, and possible restructuring, especially if the lead is buried, or the focus is unclear.  Stories in the C-range and D-range require additional research and substantial re-writing in order to them to be published. Stories assigned an “F” grade miss deadlines without being granted extensions and contain major errors.


This will be done primarily through email correspondence and phone calls, given that I do not have an office at Carleton University. The protocol will dictate that emailed queries will be answered as promptly as possible, if possible within the hour. As such, it will be important for you to regularly check your email account for updates regarding assignments, new datasets or class work. You’ll also be required to use your Carleton University account, not a second account such as gmail.


We’ll conduct ourselves as professional journalists. That means attending class, showing up on time; being prepared and ready to make a meaningful contribution based on the preparation work you’ve been assigned; paying attention to your instructor and colleagues and ignoring email correspondence, Facebook, text messages, Twitter, and promptly responding to emails from the instructor. You’ll also be expected to stay on top of current events, which is part of your obligation as a journalist. If you must miss class, please communicate with the instructor via email well ahead of time, and then make sure you take steps to catch up.

If your absence is due to a medical reason, you may be required to provide a doctor’s note. If it’s for an internship, then you’ll have to provide details.


The course would be taught in the TV computer lab, using the overhead projector. As the school possesses an ArcMap licence, we are be able to use the mapping software, which is installed on the desktops. We also use the open-source software, Qgis. The library’s Maps, Data and Government Information Centre is well positioned to provide support to faculties including journalism and communications.


Week One(TOP)

Sept. 6

What we will cover:

Introduction to the course

Installing needed software

A discussion about open data

Making an informal access-to-information request for a federal dataset

Sorting and filtering

Working with Statistics Canada’s crime data and the Canadian Institute for Health Information’s
hospitalization data


Open data websites

Access to information and privacy

Hate crimes against Muslims in Canada up 60%, StatsCan reports

Week Two(TOP)

Sept. 13


A review of our sorting and filtering from the previous week

An introduction to using ratios and numeracy fundamentals

Functions using IF statements

How to use DocumentCloud


Ontario’s 2016 deficit was $991 million, beating target by $3.3 billion

Ontario Releases 2016-17 Public Accounts

The Public Accounts of Ontario 2016-17

Ontario Data Catalogue

Canadian international merchandise trade, July 2016

Trade Data Online

Section 1: Concepts and definitions

Seasonally adjusted data – Frequently asked questions

Week Three(TOP)

Sept. 20


Pivot tables

Specialized functions

Cracking PDFs using Cometdocs

Discussion of the Sept. 22 assignment

Review infogram tutorial


10 principles for data journalism in its second decade

Public sector salary disclosure

Ottawa Police


Week Four(TOP)

Sept. 27


Test: spreadsheet, filtering, sorting pivot tables; general open data concepts explained in chapter  two

Introduction to MySQL

Performing basic select queries


This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)

Top complaints to City of Toronto’s 311 line and how to avoid a complaint against your home

The city of Ottawa’s 2017 Monthly Service Requests

Ontario’s public sector salary disclosure

Week Five(TOP)

Oct. 4


Continuation of MySQL

Queries to join tables  IN MySQL

Discussion of assignment due on Oct. 20


Shielded By The Badge: Convicted, But Still Policing

 Statistics Canada

Ottawa Public Health Inspection Data





Week Six(TOP)

Oct. 11


A continuation of MySQL perfecting the queries we’ve learned so far

And an introduction to web scraping


Office of the Commissioner of Lobbying of Canada: Registry Search and Statistics

The Social Network – screen scraping scene

Boil Water Advisories – Health Canada

First Nation locations

Examples of stories that have used more sophisticated data journalism techniques, including scraping
and building algorithms

Before you read the stories, you can check out the explanations from the NICAR listserv by clicking here.

How the Doctors & Sex Abuse project came about

Uber seems to offer better service in areas with more white people. That raises some tough questions

BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found

Bhumika Can Speak For Herself

What We Learned About The Mood Of Trump’s Tweets

Computational Journalism

Week Seven(TOP)

Oct. 18


An introduction to mapping and Qgis with Rebecca Bartlett, a specialist from the Carlton library who,
in addition to your second teaching assistant, Kent Jacobs, will be supporting us during the next few weeks.

A discussion of the census assignment due on Nov. 17


2016 Census of Population advisory: Aboriginal peoples, Immigration and ethnocultural diversity, and Housing

NHS Profile, Canada, 2011

2016 Census Program release schedule

Searching and Downloading OpenStreetMap Data


How the Epidemic of Drug Overdose Deaths Ripples Across America

This Week’s Top Ten in Data Journalism

Week Eight (TOP(Fall break)

Oct. 25

Have a good break!!

Week Nine (TOP

Nov. 1


The latest 2016 Census 2016 census release
A review of importing maps and data and joining them in Qgis


Map: Where immigrants in Canada live –  Nearly 22% of Canada’s population are immigrants, according to latest Census figures

Aging Aboriginals pose new fiscal, social challenge for government: census

How the Star’s census coverage came together

First-time GTA home buyers take to the skies in condos

Condo lifestyle the choice of more families

Map: Where immigrants in Canada live

Dictionary, Census of Population, 2016

Hierarchy of standard geographic areas for dissemination, 2016 Census

Reference materials, 2016 Census

2016 Census – Boundary files

Census Profile, 2016 Census

Download, Census Profile, 2016 Census

2011 Census Profile – Comprehensive download files for a selected geographic level: CSV or TAB

2011 NHS Profile – Download NHS data for a complete geographic level: CSV or TAB

GeoSearch – search geography by  name or code

GeoSearch (Statistics Canada’s geographic gateway)

Guide to the Census of Population, 2016

A continuation of mapping and an introduction to Statistics Canada’s latest census release —
Immigration and ethnocultural diversity 

Crowdmapping as a new data source for journalists


Week Ten(TOP)

Nov. 8


Working with census data

An introduction to OpenStreetMap

Week Eleven(TOP)

Nov. 15


Introduction to ArcGIS Online

Spatial joins

A discussion of the final assignment


An International Consortium of Investigative Journalists: a collection of Paradise Papers stories

Create Your ArcGIS Public Account

Median Household Income Mapped in ArcGIS Online

Pipeline Incident Data

Federal Contaminated Sites

Federal Contaminated Sites Inventory

Federal Contaminated Sites Inventory Open Dataset Data Dictionary

Week Twelve(TOP)

Nov. 22


Review of previous assignment

Discussion of final assignment

Spatial joins in Qgis


Toronto is now majority visible minority. What about your neighbourhood

TransCanada starts excavation work after South Dakota pipeline leak


Pipeline Incident Data – National Energy Board

Decontaminating LeBreton sites could cost as much as $50 million, says expert

Federal Contaminated Sites Inventory

Week Thirteen(TOP)

Nov. 29


Test with details to come

Geocoding in Qgis

Buffering in Qgis


The man who gives out the most parking tickets in Boston

Here’s where your bike is most likely to get stolen in Toronto

Toronto Police Service – Public Safety Data Portal

Assignment One(TOP)

Qs AND As:

What is the due date? Before class by midnight Sept. 22

What is required? A 600-word story using a dataset  that we have explored in class or another dataset from the agency that you prefer more? A 500-word explanation in a Word document of how you researched the story, including original documents, data and sources, complete with their phone numbers, email addresses and Twitter accounts.  An Excel workbook containing the original table and worksheets containing subsets of your data?

Should I check with you before using the data? No. You’ll be using the datasets that we’ve discussed so far in class including StatsCan crime data and the Canadian Institute for Health Information’s hospitalization data.

How should I analyze the data? Using the techniques that we’ve studied so far (filtering, sorting, percentage increases)

How is the assignment to be submitted? You will upload the story to a WordPress category that you’ll be assigned. The Word document and Excel workbook are to be emailed to my CBC address as attachments.

What am I looking for in the story? A well-told yarn, with a sharp, crisp lead that makes the audience want to keep reading. Avoid using too many numbers. Think about the most important numbers, and concentrate on them. As writing coach Don Gibb once remarked, choose a number as carefully as you choose a quote. All your references MUST be hyperlinked to the original source. For instance, if you are referring to a study that states a certain fact, then there should be a hyperlinked reference to the original document. What I want to see is evidence of solid research. DO NOT LINK TO NEWS REPORTS THAT SIMPLY REFER TO THE STUDY IN QUESTION.

Should the story have any interviews? Yes, at least two, including someone who is directly or indirectly impacted by the trend that you’ve identified. So get the data work completed early enough to allow for enough time to find the right characters for your story. You have plenty of time to complete the assignments, so finding the right characters should be feasible.

Should one of the interviewees be an expert? Yes. It could be a knowledgeable police officer, a criminologist , lawyer, trade expert or professor. The expert MUST not be an advocate. Seek out credible, non-partisan voices.

Will I lose marks for having less than one interview? Yes, half a grade.

Should I have any visualizations? Absolutely. We’ll explore visualizations more in-depth as the term progresses. For this assignment, there should be at least two, including a picture of the subject of your story. with  its shallow learning curve might be the easiest option for this story. If you are already familiar with other visualization tools, please feel free to use them.

Will I lose marks for neglecting to submit visualizations, or at least the minimum number of them? Yes,  half a grade.

Can I submit a draft? Yes. However, because this is a large class, I will accept ONLY ONE per student, and will not accept a draft less than 48 hours BEFORE the due date. Remember, a draft can be point form, or even an explanation of where you intend to take the story, if you’re running out of time. Your assignment should not be your first draft.

What is the deadline? Midnight Sept. 22. Anything after that will be considered late and docked half a mark. Extensions will be only  be granted for exceptional circumstances. However, we must have a conversation.

Assignment Two (TOP)

Qs AND As:

What’s the due date?  By midnight Oct. 20

What do I submit?

  1. The 600-word story, posted to the “CarletonDataJournalism2” category on our WordPress site;
  2. A 500-word background document which MUST contain the MySQL script you used to create your table;
  3. The csv file that you exported from MySQL;
  4. Save your actual story as a Word file and submit that, too.

How is the assignment to be submitted? You will upload the story to a WordPress  “CarletonDataJournalism2”
category .

What’s the topic? Any dataset that we have discussed in the MySQL section.

How many interviews do I need? At least two. One must be an expert; the other must be involved somehow.

Do I have to do extensive work in MySQL? No, just the initial data work to obtain the table you want, which can be then
exported as a csv file.

Will I be required to use visualizations? Yes, at least two. If you’re using a  picture, make it a good size that
spans the width of the story.

Will I be required to hyperlink key references in my text to the original source? Absolutely!

Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version, using the same criteria outlined in the assignment one Q and A.

Will I be docked half a grade for neglecting to submit any of the required elements? Yes.

Will I be docked half a grade for neglecting to give my visualizations titles, source citations and
I didn’t for the first assignment.  But will for this one.

Remember: Keep it simple.  The fewer numbers, the better. Tell a story!!

Assignment Three (TOP)

Qs AND As:

What’s the due date? By midnight Nov. 17

This assignment will be based on Statistics Canada’s Oct. 25, 2017 Census release on Immigration and ethnocultural diversity.

What’s the topic? The characteristics of the census tract that you choose to highlight, focusing on factors such as the reason for
the particular concentration of people in the area of town that you’ve identitied.

How many interviews do I need? At least two. One must be the person who is involved in the story; for instance, someone who embodies the trend.

Will I be required to use visualizations? At least two. The map that you have created in Qgis uploaded to ArcGIS Online or Google Fusion Tables;
and a photo of the person who is featured in your story.

Will I required to hyperlink key references in my text to the original source? Absolutely! And even better
if the source document is uploaded to DocumentCloud as a PDF and annotated.

Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version.

What do I submit? A 600-word story posted to the assigned category on our WordPress site to the
category called CarletonDataJournalism3; and a 500-word background document.

Will I be docked half a grade for neglecting to submit any of the required elements? Yes.

Will I be docked half a grade for neglecting to give my visualizations titles, cite sources or provide
cutlines for my photographs? 

Will I be docked half a grade for a late submission? Yes.

Remember: Keep it simple. Tell a story!!

Assignment Four (TOP)

Qs AND As:

Deadline: By midnight Dec. 4

The sky is the limit for this assignment. You can choose any dataset: a new one, or one that we’ve already used. You can also follow up a previous story. The choice is yours.

As for the type of story, it can be a 600-word piece; a paragraph that sets up self-explanatory and well-made visualizations with titles, cut lines, source citations; or a combination of the first two. In short, any of the formats we used for previous assignments.

Your story can also have multi-media elements, but make sure to stick to the word length.

You’ll notice that I’ve attached more conditions that in the past I have tended to ignore. Given that this is a final
assignment, I will apply the conditions strictly with no exceptions. So please read the assignment specs
carefully. If you have any questions, or if anything is unclear, please feel free to ask for clarification.

Post the story to the “CarletonDataJournalism4” category.

What’s the topic? Any topic.

Must I properly cite the source of my data? Yes.

Will I lose a half a grade for neglecting to do so? Yes.

How many interviews do I need? At least three. One must be the person who is involved in the story and
an expert who can provide context.

Must I conduct at least one of the interviews in person? Yes.

Will I get docked a half a grade if I neglect to do this? Yes.

How will the audience know if I’ve conducted the interview in person? If there is the kind of colour,
description, and photographs that we’ve discussed in the feedback to previous assignments. For instance, what was the decor
of the individual’s office or home. What does it look like?

Will I be required to use visualizations? At least two. One must be a picture, complete with cut line and
photo credit. The second can be Infor.gram or ArcGIS Online. The nature of your material determines the second visualization.  For instance, if there is geographic information, then it makes sense to use ArcGIS. If  your dataset contains both geographic material and information that would benefit from a chart, then you could use both.

Will I required to hyperlink key references in my text to the original source? Absolutely! Unless it is a killer
quotation, simply cite the study, report, or project and then hyperlink to the document or website.

Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version.

What do I submit? A 600-word story posted to “CarletonDataJournalism4” category;
and a 500-word background document, and the actual story in Word. Please respect the word-count for both parts of the assignment. A few words over 600 is not  the end of the world. Anything past 50 words over the limit is too much and will lead
to a loss of half a mark.

Will I be docked half a grade for neglecting to submit any of the required elements? Yes.

Will I be docked half a grade for neglecting to give my visualizations titles, source citations and 
cut lines? 

Will I be docked half a grade for a late submission? Yes. However, if you need an extension, please let me know.

Remember: Keep it simple. Tell a story!!


Week One: 
The Data Journalist: Chapter four

Week two:

Week three:
Chapters two and four to prepare for the Sept. 27 test

Week four:
Chapter  five

Week eight:
Chapters six and seven

Week twelve

Chapter seven – Working with GIS Programs

Additional Reading (TOP)

Week one:
The colour of money.  Writing coach, Don Gibb’s, must-read article on using numbers in stories


From week one:

To obtain the tutorial on sorting and filtering the Canadian Institute for Health Information’s hospitalization
data, please click here.

From week two:
To obtain the tutorial on calculating per cents, please click here.

To obtain the pivot table tutorial, please click here.

For instructions on how to upload data to, please click here.

From week three:

To obtain the specialized functions tutorial, please click here.

To obtain the questions we used for our pivot table exercise using ACOA data, please click here.

From week four:

To obtain the Google Fusion Table tutorial, please click here.

To obtain the Excel test, please click here.

From week five:

To download the Windows version of MySQL installation tutorial, please click here.

To download the Mac version of the MySQL installation tutorial, please click here.

Click here to see the YouTube tutorial on downloading 311 complaints data from the city of Ottawa’s
open data portal and uploading it to MySQL. The accompanying PPT presentation and MySQL scripts used
to create the are the next two links, respectively.

PowerPoint to accompany MySQL tutorial using 2017 311 data.pptx

Queries for Ottawa 311 data 2013-2017.sql

CH5 – Making Tables and Importing Data into MySQL.pdf

CH5 – Getting Started with Queries in MySQL.pdf

From week six:

Tutorial for querying Ottawa inspections data in MySQL.pdf

Allinspection_queries_for_tutorial.sql (note: right-click to save this file, and then paste it into a new
query tab in your Workbench)

Appendix A:Data Integrity and Cleaning.pdf

WebScraping PowerPoint

From week seven:



From week seven:

From week nine:

CH7 – QuickTourQGISDesktop.pdf

CH7 – Selecting Featuresin QGIS Desktop.pdf

CH7 – The Data Journalist: Selecting Featuresin QGIS Desktop.pdf

From week ten:

Please click  here for the tutorial for joining csv files with census tract shape files in Qgis


For Kent Jacob’s tutorial on  downloading Open Street Map data, please click here.

From week eleven:

Building Maps with ArccGIS Online_updated.pdf

From week twelve:


CH7 – Working with Projections in QGIS.pdf

From week thirteen:



From week one:
To download Canadian Institute for Health Information heart attack
hospitalization data, please click or right-click here.

From week two:

From week three:

To download the workbook for the
“Working with specialized functions in Excel” tutorial, please click here.

The Data Journalist- Getting the Story_updated.xlsx



Ward_12-Rideau-Vanier_Crimes Against The Person.pdf


From week four:
Ontario Public Sector Salaries Data – 2014-16 – for

From week five:

From week six:

To obtain the city of Ottawa parking ticket dump file,
please right-click here and then save the zipped folder to your hard drive.

For the queries used to create the tables in the city of Ottawa parking ticket dump file,
please right-click here and save the file to your hard drive.

To obtain the dump file containing federal lobbyist records and the queries used to
load and create the tables, please right-click here and save the zipped folder to your hard drive.

First Nations Boil Water Advisories and Locations in Google Sheets

From week seven:

The income data for the mapping tutorial in Qgis

From week eight:

From week nine:

From week ten:

To obtain the files that accompany the census tract tutorial under
the week ten section of “Tutorials”, please click here.

Please click here for 2016 median household income csv files broken down by census tracts.

From week twelve:


From week thirteen:

Canadian Post Codes