Journalism 4208 and 5508, Section E, Fall 2017

Share
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)
Email: david.mckie@cbc.ca
Teaching Assistants:
Muhammad Zeeshan

Email: muhammadzeeshan@cmail.carleton.ca
Phone Number: (613) 700-0352
Kent Jacobs
Email: 
Kent.Jacobs@carleton.ca
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 |

COURSE DESCRIPTION

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 https://carleton.ca/sjc/journalism/undergraduate-studies/resources-current-undergraduate-students/

Graduates can find all three policies here https://carleton.ca/sjc/journalism/graduate-studies/resources-current-students/

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: http://www2.carleton.ca/equity/

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: http://www2.carleton.ca/equity/

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 pmc@carleton.ca 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 http://www2.carleton.ca/pmc/new-and-current-students/dates-and-deadlines/ 

You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at http://www2.carleton.ca/equity/

School ethics policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/EthicsPolicy.pdf

School publishing policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/PublishingPolicy.pdf

School electronic media usage policy:

http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/media-usage-policy-2010.pdf

Data Journalism Stories (TOP)

Examples stories using data journalism

How Is Immigration Viewed In The EU?
http://www.rferl.org/contentinfographics/data-visualization-eu-migrants/27237198.html

How to avoid Toronto’s parking ticket hot spots
https://www.thestar.com/news/gta/2016/05/15/how-to-avoid-torontos-parking-ticket-hot-splots.html

Fatal Force
https://www.washingtonpost.com/graphics/national/police-shootings-2017/

New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments

NSA Files: Decoded
http://www.theguardian.com/world/interactive/2013/nov/01/snowden-nsa-files-surveillance-revelations-decoded#section/1

Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320

This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html

Walmart: Thousands of police calls. You paid the bill.
http://www.tampabay.com/projects/2016/public-safety/walmart-police

The 100 WORST landlords in Toronto
http://www.landlordwatch.com/

Settling for Misconduct
http://projects.chicagoreporter.com/settlements/

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

WHAT YOU WILL LEARN (TOP)

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

http://carleton.ca/senate/wp-content/uploads/Academic-Integrity-Policy1.pdf

 The full graduate policy is here http://calendar.carleton.ca/grad/gradregulations/

Assignments

Percent

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%

GRADES

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.

COMMUNICATIONS WITH STUDENTS

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.

PROFESSIONALISM

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.

REQUIRED SUPPORT RESOURCES

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.

OUTLINE

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

LINKS:

Open data websites
http://www.davidmckie.com/new-reporting-methods-syllabus/#Open1

Access to information and privacy
http://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/index-eng.asp

Hate crimes against Muslims in Canada up 60%, StatsCan reports
http://www.cbc.ca/news/canada/hate-crimes-muslims-statscan-1.4158042

Week Two(TOP)

Sept. 13

WHAT WE WILL COVER

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

 LINKS:

Ontario’s 2016 deficit was $991 million, beating target by $3.3 billion
http://www.cp24.com/news/ontario-s-2016-deficit-was-991-million-beating-target-by-3-3-billion-1.3579981

Ontario Releases 2016-17 Public Accounts
https://news.ontario.ca/tbs/en/2017/09/ontario-releases-2016-17-public-accounts.html

The Public Accounts of Ontario 2016-17
https://www.ontario.ca/data/public-accounts-volume-1-data

Ontario Data Catalogue
https://www.ontario.ca/search/data-catalogue

Canadian international merchandise trade, July 2016
http://www.statcan.gc.ca/daily-quotidien/160902/dq160902a-eng.htm?HPA=1

Trade Data Online
http://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home

Section 1: Concepts and definitions
http://www.statcan.gc.ca/eng/dai/btd/sad-faq/sec1#a8

Seasonally adjusted data – Frequently asked questions
http://www.statcan.gc.ca/eng/dai/btd/sad-faq

Week Three(TOP)

Sept. 20

WHAT WE WILL COVER

Pivot tables

Specialized functions

Cracking PDFs using Cometdocs

Discussion of the Sept. 22 assignment

Review infogram tutorial

LINKS

10 principles for data journalism in its second decade
https://medium.com/@paulbradshaw/10-principles-for-data-journalism-in-its-second-decade-3b45e08a4793

Public sector salary disclosure
https://www.ontario.ca/page/public-sector-salary-disclosure?_ga=2.17081073.912354988.1505873343-828559561.1492781507

Ottawa Police
https://www.ottawapolice.ca/en/

Cometdocs
https://www.cometdocs.com/

Week Four(TOP)

Sept. 27

WHAT WE WILL COVER

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

Introduction to MySQL

Performing basic select queries

LINKS:

This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html

Top complaints to City of Toronto’s 311 line and how to avoid a complaint against your home
http://globalnews.ca/video/3627618/top-complaints-to-city-of-torontos-311-line-and-how-to-avoid-a-complaint-against-your-home

The city of Ottawa’s 2017 Monthly Service Requests
http://data.ottawa.ca/dataset/2017monthlyservicerequests

Ontario’s public sector salary disclosure
https://www.ontario.ca/page/public-sector-salary-disclosure#section-3

Week Five(TOP)

Oct. 4

WHAT WE WILL COVER

Continuation of MySQL

Queries to join tables  IN MySQL

Discussion of assignment due on Oct. 20

LINKS:

Shielded By The Badge: Convicted, But Still Policing
http://www.startribune.com/minnesota-police-officers-convicted-of-serious-crimes-still-on-the-job/437687453/

 Statistics Canada
https://www.statcan.gc.ca/eng/start

Ottawa Public Health Inspection Data
http://data.ottawa.ca/dataset/public-health-inspection-data

EmEditor
https://www.emeditor.com/

UltraEdit
https://www.ultraedit.com/

Notepad++
https://notepad-plus-plus.org/

TextWrangler
https://www.barebones.com/products/textwrangler/

Week Six(TOP)

Oct. 11

WHAT WE WILL COVER

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

And an introduction to web scraping

LINKS:

Office of the Commissioner of Lobbying of Canada: Registry Search and Statistics
https://lobbycanada.gc.ca/eic/site/012.nsf/eng/00035.html

The Social Network – screen scraping scene
https://www.youtube.com/watch?v=haUfY0qnSyM

Boil Water Advisories – Health Canada
https://www.canada.ca/en/health-canada/topics/health-environment/water-quality-health/drinking-water/advisories-first-nations-south-60.html

First Nation locations
http://open.canada.ca/data/en/dataset/b6567c5c-8339-4055-99fa-63f92114d9e4

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
http://doctors.ajc.com/about_this_investigation/

Uber seems to offer better service in areas with more white people. That raises some tough questions
https://www.washingtonpost.com/news/wonk/wp/2016/03/10/uber-seems-to-offer-better-service-in-areas-with-more-white-people-that-raises-some-tough-questions/?utm_term=.67cfde71d69f

BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found
https://www.buzzfeed.com/peteraldhous/hidden-spy-planes?utm_term=.khMPZd7kL#.boeB3eK7x

Bhumika Can Speak For Herself
https://projects.asiaweekly.com/bhumika-can-speak-for-herself/

What We Learned About The Mood Of Trump’s Tweets
http://www.npr.org/2017/04/30/526106612/what-we-learned-about-the-mood-of-trumps-tweets

Computational Journalism
https://cacm.acm.org/magazines/2011/10/131400-computational-journalism/fulltext

Week Seven(TOP)

Oct. 18

WHAT WE WILL COVER

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

Links:

2016 Census of Population advisory: Aboriginal peoples, Immigration and ethnocultural diversity, and Housing
http://www.statcan.gc.ca/daily-quotidien/171018/dq171018e-eng.htm?CMP=mstatcan

NHS Profile, Canada, 2011
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/page.cfm?Lang=E&Geo1=PR&Code1=01&Data=Count&SearchText=Canada&SearchType=Begins&SearchPR=01&A1=All&B1=All&Custom=&TABID=1

2016 Census Program release schedule
http://www12.statcan.gc.ca/census-recensement/2016/ref/release-dates-diffusion-eng.cfm

Searching and Downloading OpenStreetMap Data
http://www.qgistutorials.com/en/docs/downloading_osm_data.html

OpenStreetMap
http://www.openstreetmap.org/#map=18/45.41807/-75.68215

How the Epidemic of Drug Overdose Deaths Ripples Across America
https://www.nytimes.com/interactive/2016/01/07/us/drug-overdose-deaths-in-the-us.html

This Week’s Top Ten in Data Journalism
https://gijn.org/2017/10/18/this-weeks-top-ten-in-data-journalism-4/

Week Eight (TOP(Fall break)

Oct. 25

Have a good break!!

Week Nine (TOP

Nov. 1

WHAT WE WILL COVER

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

Links:

Map: Where immigrants in Canada live –  Nearly 22% of Canada’s population are immigrants, according to latest Census figures
http://www.cbc.ca/news/politics/map-where-immigrants-in-canada-live-1.4372261

Aging Aboriginals pose new fiscal, social challenge for government: census
http://nationalpost.com/pmn/news-pmn/canada-news-pmn/aging-aboriginals-pose-new-fiscal-social-challenge-for-government-census

How the Star’s census coverage came together
https://www.thestar.com/trust/2017/10/27/how-the-stars-census-coverage-came-together.html

First-time GTA home buyers take to the skies in condos
https://www.thestar.com/business/real_estate/2017/10/26/first-time-gta-home-buyers-take-to-the-skies-in-condos.html

Condo lifestyle the choice of more families
https://www.thestar.com/life/homes/2017/10/28/condo-lifestyle-the-choice-of-more-families.html

Map: Where immigrants in Canada live
http://www.cbc.ca/news/politics/map-where-immigrants-in-canada-live-1.4372261

Dictionary, Census of Population, 2016
http://www12.statcan.gc.ca/census-recensement/2016/ref/dict/index-eng.cfm

Hierarchy of standard geographic areas for dissemination, 2016 Census
http://geosuite.statcan.gc.ca/geosuite/en/index

Reference materials, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/ref/index-eng.cfm

2016 Census – Boundary files
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2016-eng.cfm

Census Profile, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E

Download, Census Profile, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/download-telecharger/comp/page_dl-tc.cfm?Lang=E

2011 Census Profile – Comprehensive download files for a selected geographic level: CSV or TAB
http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/prof/details/download-telecharger/comprehensive/comp-csv-tab-dwnld-tlchrgr.cfm?Lang=E

2011 NHS Profile – Download NHS data for a complete geographic level: CSV or TAB
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/download-telecharger/comprehensive/comp-csv-tab-nhs-enm.cfm?Lang=E

GeoSearch – search geography by  name or code
http://geosuite.statcan.gc.ca/geosuite/en/index

GeoSearch (Statistics Canada’s geographic gateway)
http://www12.statcan.gc.ca/census-recensement/2016/geo/geosearch-georecherche/index-eng.cfm

Guide to the Census of Population, 2016
http://www12.statcan.gc.ca/census-recensement/2016/ref/98-304/index-eng.cfm

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
http://datadrivenjournalism.net/news_and_analysis/crowdmapping_as_a_new_data_source_for_journalists

Links:

Week Ten(TOP)

Nov. 8

WHAT WE WILL COVER

Working with census data

An introduction to OpenStreetMap

Week Eleven(TOP)

Nov. 15

WHAT WE WILL COVER:

Introduction to ArcGIS Online

Spatial joins

A discussion of the final assignment

LINKS:

An International Consortium of Investigative Journalists: a collection of Paradise Papers stories
https://www.icij.org/investigations/paradise-papers/

Create Your ArcGIS Public Account
https://www.arcgis.com/home/createaccount.html

Median Household Income Mapped in ArcGIS Online
http://www.davidmckie.com/median-household-income/

Pipeline Incident Data
http://open.canada.ca/data/en/dataset/7dffedc4-23fa-440c-a36d-adf5a6cc09f1

Federal Contaminated Sites
http://tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx

Federal Contaminated Sites Inventory
http://open.canada.ca/data/en/dataset/1d42f7b9-1549-40aa-8ac6-0e0302ff2902

Federal Contaminated Sites Inventory Open Dataset Data Dictionary
http://www.tbs-sct.gc.ca/fcsi-rscf/oddo/fcsi-rscf-eng.aspx

Week Twelve(TOP)

Nov. 22

WHAT WE WILL COVER

Gecoding

LINKS:

GPS Visualizer
http://www.gpsvisualizer.com/

Week Thirteen(TOP)

Nov. 29

WHAT WE WILL COVER

Buffering in Qgis

LINKS:

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. Infogr.am 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
cutlines?
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? 
Yes.

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 “DataJournalism4_2016” 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 two. 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 three. One must be a picture, complete with cut line and
photo credit. The other two can be viewed using Fusion Tables, Tableau Public, Infor.gram, Datawrapper,
ArcGIS Online. The nature of your material determines the visualization that you use.

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 annotated document uploaded to
DocumentCloud.

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 “DataJournalism4_2016” category;
and a 500-word background document. 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? 
Yes.

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

Remember: Keep it simple. Tell a story!!

Readings(TOP)

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 five:

Additional Reading (TOP)

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

Tutorials(TOP)

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 infogr.am, 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:

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:

Journalism4208_GISPresentation2017_PartOne.pdf

JOUR4208Handout_2017_final_Oct23_PartTwo.pdf

From week seven:

From week nine:

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

Introduction_to_VGI.pptx

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:

From week thirteen:

Datasets(TOP)

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

From week two:

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

From week three:

The Data Journalist- Getting the Story_updated.xlsx

OntarioPublicSectorSalaryDisclosure_2014-16.xlsx

DefectiveVehicleComplaints.xlsx

Ward_12-Rideau-Vanier_Crimes Against The Person.pdf

ACOA_ProjectInformation.xlsx

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

OttawaServiceCalls_2013-2017_Dump_20170926.zip

From week five:

Crime_1998-2016_Dump20171001_andQueries.zip

AllOttawaInspections_dump_ScriptsQueries.zip

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
https://docs.google.com/spreadsheets/d/18tG8YbWylLc2hw7M847-QOmpDBs1_ypRsgshhsbyAKQ/edit#gid=1825575614

webscraping.zip

From week seven:

The income data for the mapping tutorial in Qgis

From week eight:

From week nine:

Census2016_Immigration_Housing_CensusTractAndWardsBoundaryFiles.zip

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 eleven:

PipelineIncidentData.zip

FederalContaminatedSitesData.csv

From week thirteen: