Teaching Assistant:
Muhammad Zeeshan
Email:  Phone Number: (613) 700-0352

Rebecca Bartlett & Meaghan Kenny
GIS and Digital Resources Librarians
Research Support Services
Carleton University Library
613-520-2600 x 408
.

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 |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 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;  DocumentCloud; Qgis; and ArcGISOnline;

Taken together, these tools are packaged into a discipline called 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 or  background information for interviews.

As the course’s name suggests, there will be a heavy emphasis on storytelling, using words, maps, charts, video and sound. 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 or should have been used. These discussions and in-class 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 Journalist will be used to hone your newly-learned skills.

The course will be comprised of three modules: spreadsheets (Excel); mapping (Qgis and ArcGIS Online) and database managers (MySQL) and web scraping.

There will be three assignments ( please see chart below ). At the end of each segment, there will be an in-class tests worth five percent.

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.

Requests for Academic 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
Please contact your instructor 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: carleton.ca/equity/wp-content/uploads/Student-Guide-to-Academic-Accommodation.pdf

Religious obligation
Please contact your instructor 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: carleton.ca/equity/wp-content/uploads/Student-Guide-to-Academic-Accommodation.pdf

Academic Accommodations for Students with Disabilities
If you have a documented disability requiring academic accommodations in this course, please contact the Paul Menton Centre for Students with Disabilities  at 613-520-6608 or for a formal evaluation or contact your centre coordinator to send your instructor your letter of accommodation at the beginning of the term. You must also contact the Paul Menton Centre no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation, meet with your instructor as soon as possible to ensure accommodation arrangements are made. carleton.ca/pmc

Survivors of Sexual Violence
As a community, Carleton University is committed to maintaining a positive learning, working and living environment where sexual violence will not be tolerated. Survivors are supported through academic accommodations as per Carleton’s Sexual Violence Policy. For more information about the services available at the university and to obtain information about sexual violence and/or support, visit: carleton.ca/sexual-violence-support

Accommodation for Student Activities
Carleton University recognizes the substantial benefits, both to the individual student and for the university, that result from a student participating in activities beyond the classroom experience. Reasonable accommodation must be provided to students who compete or perform at the national or international level. Please contact your instructor 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. https://carleton.ca/senate/wp-content/uploads/Accommodation-for-Student-Activities-1.pdf

For more information on academic accommodation, please contact the departmental administrator or visit: students.carleton.ca/course-outline

Data Journalism Stories (TOP)

Examples stories using data journalism

Pollution from Canadian refineries an ’embarrassment’ compared with U.S.
https://www.thestar.com/news/investigations/2018/05/02/pollution-from-canadian-refineries-an-embarrassment-compared-to-us.html

General Investigations

Medical Disorder, parts one and two (Toronto Star)
http://projects.thestar.com/doctor-discipline/

http://projects.thestar.com/doctor-discipline/part-2/index.html

http://projects.thestar.com/doctor-discipline/part-3/index.html

People have a right to ‘as much transparency as possible’ when it comes to doctors’ pasts, health minister says
https://www.thestar.com/news/medical-disorder/2018/05/03/people-have-a-right-to-as-much-transparency-as-possible-when-it-comes-to-doctors-pasts-health-minster-says.html

Rachel Browne (Vice News)
https://news.vice.com/en_ca/article/d35eyq/black-and-indigenous-people-are-overrepresented-in-canadas-weed-arrests

Jacques Marcoux and Katie Nicholson (CBC Manitoba)
https://newsinteractives.cbc.ca/longform-custom/deadly-force

Nael Shiab (L’Actualité)
http://lactualite.com/societe/2017/06/28/un-canada-sans-immigrants/

http://lactualite.com/societe/2018/01/23/philippe-couillard-vous-fait-il-perdre-ou-economiser-de-largent-notre-robot-journaliste-repond-a-vos-questions/

Canada’s Highest Paid CEO’s (The Globe and Mail)
https://www.theglobeandmail.com/report-on-business/careers/management/executive-compensation/table-canadas-top-100-highest-paid-ceos/article30131636/?from=30171589

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

Stories from open-data sites

Streetcars account for half of deadly TTC collisions with pedestrians, cyclists
https://www.thestar.com/news/gta/2018/06/25/streetcars-account-for-half-of-deadly-ttc-collisions-with-pedestrians-cyclists.html

Streetcars account for half of deadly TTC collisions with pedestrians, cyclists
https://www.thestar.com/news/gta/2018/06/25/streetcars-account-for-half-of-deadly-ttc-collisions-with-pedestrians-cyclists.html

 As #NearMissToronto picks up steam with cyclists and pedestrians on Twitter, we map your tweets of near death
https://www.thestar.com/news/gta/2018/07/17/as-nearmisstoronto-picks-up-steam-with-cyclists-and-pedestrians-on-twitter-we-map-some-of-their-tweets-of-near-death.html

Census-related stories

Report reveals alarming — and growing — racialized income divide in GTA
https://www.thestar.com/news/gta/2019/05/06/report-reveals-alarming-and-growing-racialized-income-divide-in-gta.html

Stories about data journalism

In the dark: The cost of Canada’s data deficit
https://www.theglobeandmail.com/canada/article-in-the-dark-the-cost-of-canadas-data-deficit/

Divorce and marriage data crucial for understanding Canada’s public health, researchers argue
https://www.theglobeandmail.com/canada/article-divorce-and-marriage-data-crucial-for-understanding-canadas-public/

Health-care data in the cloud? Early adopter took a giant leap, and it paid off
https://www.theglobeandmail.com/business/article-health-care-data-in-the-cloud-early-adopter-took-a-giant-leap-and-it/

The data game: How information on everything from flight patterns to parking lots can reveal valuable clues about where the market is heading
https://www.theglobeandmail.com/investing/article-quandl-and-the-invasive-use-of-data/?intcmp=notifications

Morning Update: Canada’s firearm data gap; Trump’s new China trade threat
https://www.theglobeandmail.com/canada/article-morning-update-canadas-firearm-data-gap-trumps-new-china-trade/

Poor flood-risk maps, or none at all, are keeping Canadian communities in flood-prone areas
https://www.theglobeandmail.com/canada/article-poor-flood-risk-maps-or-none-at-all-are-keeping-canadian-communities/

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 scrape a website

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. Plagiarism is a serious offence, which cannot be resolved directly between the student and the course instructor. If an academic offence is suspected, it will be referred to the Office of the Dean of the Faculty of Public Affairs. The Associate Dean of the Faculty will conduct a rigorous investigation, including an interview with the student, when an instructor suspects a piece of work has been plagiarized. Penalties are not trivial. They can include a final grade of “F” for the course.

• Do not, under any circumstances, present someone else’s work as your own.
• Do not download and/or copy any files, stories, photos, audio or video you find online or elsewhere and use them as your own.
• Do not fabricate sources of information.
• Do not invent facts.

For undergraduates: Undergraduate Calendar section 12.0 Academic Integrity http://calendar.carleton.ca/undergrad/regulations/academicregulationsoftheuniversity/ or http://carleton.ca/senate/wp-content/uploads/Academic-Integrity-Policy1.pdf

For graduates: General Regulations, Section 19, of the Graduate Calendar http://calendar.carleton.ca/grad/gradregulations/

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

For undergraduates: The passing grade for this course is a grade of C

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 undergraduate 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.

*******

For graduates: The passing grade for this course is a grade of B minus

Informal 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.

For information about the formal Grade Review process, please see the Graduate Regulations: http://calendar.carleton.ca/grad/gradregulations/administrationoftheregulations/#15

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.

Ethics and Professional Standards
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.

3. 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. One of the rules, for example, makes clear that you must not interview relatives or friends for your story, except in rare and special circumstances and with the advance permission of the instructor.
4. 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.
5. Our policy on electronic media usage requires that you follow copyright regulations with respect to your use of all materials culled from the Internet. For example, you cannot use any pictures you find online in your assignments unless you get written permission from the copyright holder to use them and submit it to the instructor.

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.

Academic Advice

For undergraduates: If you have questions about the journalism program, degree requirements, your standing in the program or your academic audit, you should contact your Undergraduate Administrator Joan Thompson at or Undergraduate Supervisor Mary McGuire at 

For graduates: If you have questions about the journalism program, degree requirements, your standing in the program or your academic audit, you should contact your Graduate Administrator Mary Choueiri at or Graduate Supervisor Chris Dornan at

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 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. You are expected to attend ALL classes. If personal reasons prevent you from attending a specific class, please let me know in advance via email.

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, Research Support Services is well positioned to provide support to faculties including journalism and communications.

OUTLINE

Week One(TOP)

Sept. 5

What we will cover:

Introduction to the course

Installing needed software (Excel, MySQL, QGIS, ArcGIS Online)

A discussion about open data

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

Sorting and filtering using Statistics Canada’s incident-based crime statistics by detailed violations data

LINKS:

Informal Access to Information requests
https://www.canada.ca/en/treasury-board-secretariat/topics/access-information-privacy/access-information.html

Canadian police dismissing fewer sexual-assault cases
https://www.theglobeandmail.com/canada/article-canadian-police-dismissing-fewer-sexual-assault-cases/

Statistics Canada’s data tables

Despite looming legalization, cannabis possession charges remain a reality
https://www.cbc.ca/news/canada/edmonton/cannabis-possession-charges-edmonton-1.4665903

Information on the changes made on Statistics Canada’s website,
replacing the old CANSIM tables

Statistics Canada’s incident-based crime statistics by detailed violations data

Statistics Canada’s cannabis consumer prices

TREB loses Supreme Court bid to appeal release of real estate sold figures
http://www.cbc.ca/news/business/treb-real-estate-sale-prices-1.4795903

Week Two(TOP)

Sept. 12

WHAT WE WILL COVER

A continuation with Statistics Canada data tables

Using ratios and numeracy fundamentals

Downloading a table from an open data site and sorting and filtering

Pivot tables

Links

Global Affairs INFORMAL REQUEST for Records About Marijuana Legalization A2016 00470

Loss of part-time jobs drives Canada’s unemployment rate, but full-time work rises
https://www.thestar.com/business/2018/09/07/loss-of-part-time-jobs-drove-canadas-unemployment-rate-but-full-time-work-rises.html

In sobering news for the Ford government, Ontario lost 80,000 jobs in August
https://www.thestar.com/news/queenspark/2018/09/07/in-sobering-news-for-the-ford-government-ontario-lost-80000-jobs-in-august.html

Welcome to My StatCan
https://www.statcan.gc.ca/eng/mystatcan/login?HPA=1

StatCan release schedules
https://www150.statcan.gc.ca/n1/dai-quo/cal1-eng.htm

Labour Force Survey, August 2018
https://www150.statcan.gc.ca/n1/daily-quotidien/180907/dq180907a-eng.htm?HPA=1

Annual demographic estimates by census metropolitan area, age and sex, based on the Standard Geographical Classification (SGC) 2011
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710007801

Annual safety reports (City of Ottawa)
https://ottawa.ca/en/residents/transportation-and-parking/road-safety/annual-safety-reports#2017-ottawa-road-safety-report

2017 Tabular Transportation Collision Data – 2017_collisions_xlsx (City of Ottawa)
http://data.ottawa.ca/dataset/collisiondata2017/resource/aeb4ec75-2225-4fc5-9844-f937fcd04777

Week Three(TOP)

Strategies for negotiating for more detailed sets than the ones posted on
government open-date sites

A continuation of pivot tables, using the City of Ottawa’s collision data

Calculating percentages

An introduction to specialized functions used to analyze data

Combining research with other primary sources

Using DocumentCloud

LINKS:

Annual safety reports (City of Ottawa)
https://ottawa.ca/en/residents/transportation-and-parking/road-safety/annual-safety-reports#2017-fatal-collision-breakdown

Ottawa’s Strategic Road Safety Action Plan
https://www.documentcloud.org/documents/4896107-02-Safe-Roads-Document-1-Action-Plan-English.html

City of Ottawa Transportation Collision Data
http://data.ottawa.ca/dataset?q=transportation+collision+data

Ottawa Collision Data – MacOdrum Library
https://library.carleton.ca/find/gis/geospatial-data/ottawa-collision-data

Temporary Foreign Worker Program work permit holders by top 50 countries of citizenship and sign year¹, 2007 to 2016
https://open.canada.ca/data/en/dataset/6609320b-ac9e-4737-8e9c-304e6e843c17

International students in Canadian Universities, 2004-2005 to 2013-2014
https://www150.statcan.gc.ca/n1/pub/81-599-x/81-599-x2016011-eng.htm

Universities Canada
https://www.univcan.ca/universities/facts-and-stats/

Ontario releases its annual Sunshine List of top public sector salaries
https://www.cbc.ca/news/canada/toronto/ontario-sunshine-list-2017-public-sector-salary-disclosure-1.4589673

Public sector salary disclosure 2017: all sectors and seconded employees
https://www.ontario.ca/page/public-sector-salary-disclosure-2017-all-sectors-and-seconded-employees

https://library.carleton.ca/find/gis/geospatial-data/ottawa-collision-data

Week Four(TOP)

Sept. 26

WHAT WE WILL COVER

Continuation specialized functions

LINKS:

Sunshine List analysis reveals $10,000 gender pay gap at Ottawa’s main universities
https://ottawacitizen.com/news/local-news/sunshine-list-analysis-reveals-10000-gender-pay-gap-at-ottawas-main-universities

Sunshine List so white: Minorities almost invisible among Ontario’s best-paid public servants
https://www.cbc.ca/news/canada/toronto/sunshine-list-so-white-ontario-public-sector-executives-1.4593238

Ontario’s sunshine list shows men far outnumber women — and women earn less
https://www.thestar.com/news/canada/2016/04/06/ontarios-sunshine-list-shows-men-far-outnumber-women-and-women-earn-less.html

SunshineLists
https://www.sunshineliststats.com/

Routine Disclosure and Active Dissemination Plans
https://ottawa.ca/en/routine-disclosure-and-active-dissemination-plans#

Bike Ottawa Interactive Maps
https://maps.bikeottawa.ca/

Ottawa collisions mapped
https://maps.bikeottawa.ca/collisions/

Week Five(TOP)

Oct. 3

WHAT WE WILL COVER

Excel test

Ottawa full-time equivalents
http://data.ottawa.ca/dataset/full-time-equivalent-fte-count

Download QGIS archive
http://www.kyngchaos.com/software/archive/qgis/

An introduction to mapping with Rebecca Bartlett, a specialist from the Carlton library.

Joining data tables and shapefiles  in Qgis, using census data from Statistics Canada and a second, yet-to-be-determined government agency.

LINKS

Is Canada ‘ripping us off’? Or is it the best U.S. trade partner?https://www.washingtonpost.com/graphics/2018/business/us-canada-trade-balance/?utm_term=.5d06e66050de

A majority of Torontonians now identify themselves as visible minorities
https://www.thestar.com/news/gta/2017/10/25/a-majority-of-torontonians-now-identify-themselves-as-visible-minorities-census-shows.html

Municipal Wards (Toronto’s open-data catelogue)
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/#29b6fadf-0bd6-2af9-4a8c-8c41da285ad7

Week Six(TOP)

Oct. 10

WHAT WE WILL COVER

A continuation working with census data

An introduction to OpenStreetMap

Counting points in polygons

A look-ahead to the assignment

LINKS:

Census Program
https://www12.statcan.gc.ca/census-recensement/index-eng.cfm

Census Reference Materials
https://www12.statcan.gc.ca/census-recensement/2016/ref/index-eng.cfm

Dictionary, Census of Population, 2016: Complete A to Z index
https://www12.statcan.gc.ca/census-recensement/2016/ref/dict/az1-eng.cfm#C

Incompletely enumerated Indian reserves and Indian settlements
https://www12.statcan.gc.ca/census-recensement/2016/ref/dq-qd/iir-rii-eng.cfm

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

2016 Census Ward Data – 2016 Census by Wards
http://data.ottawa.ca/en/dataset/2016-census-ward-data/resource/75bf4c3d-8726-43a0-bd0c-ea8ee7128b6e

Statistics Canada’s Crowdsourcing Program Using OpenStreetMap
https://www.statcan.gc.ca/eng/crowdsourcing

City of Ottawa address points
http://data.ottawa.ca/dataset?q=address+points&sort=score+desc%2C+metadata_modified+desc

Week Seven(TOP)

Oct. 17

WHAT WE WILL COVER

A continuation of work with census data and

Links:

New census counts 25,502 unoccupied homes in Vancouver, for 15 per cent jump over 2011
https://vancouversun.com/news/local-news/census-counts-25502-unoccupied-homes-in-vancouver-more-than-double-the-estimate-by-city-hall

Here’s Where Metro Vancouver’s 66,719 Unoccupied Homes Are [Interactive]
https://betterdwelling.com/city/vancouver/heres-metro-vancouvers-66719-unoccupied-homes-interactive/

Toronto Has Over 99,000 Unoccupied Homes, Here’s Where They Are [Interactive]
https://betterdwelling.com/city/toronto/toronto-has-over-99000-unoccupied-homes-heres-where-they-are-interactive/

About Better Dwelling
https://betterdwelling.com/about/

Map of inadequate housing in Ottawa using ArcGIS Online
http://davidmckie.com/category/digi-1examples/

infopigeonofficial
https://www.instagram.com/infopigeonofficial/?hl=en

Oct. 24

Have a good break!!

Week Nine (TOP) 

Nov. 1

WHAT WE WILL COVER

A mapping test

Introduction to MySQL

Importing data

Simple select statements

LINKS:

Mapping test.pdf

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

Ottawa 311 complaints 2018
http://data.ottawa.ca/dataset/2018monthlyservicerequests

Open Data Inventory (Federal)
https://open.canada.ca/data/en/dataset/4ed351cf-95d8-4c10-97ac-6b3511f359b7

EmEditor
https://www.emeditor.com/

UltraEdit
https://www.ultraedit.com/

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

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

Links:

Week Ten(TOP)

Nov. 7

WHAT WE WILL COVER

Joining tables in MySQL

Links:

Week Eleven(TOP)

Nov. 15

WHAT WE WILL COVER:

A continuation of joining tables in MySQL

LINKS:

Ottawa nursing homes have seen at least 163 cases of abuse since 2012 (Ottawa-Citizen)
http://ottawacitizen.com/news/local-news/more-than-2000-cases-of-non-compliance-and-163-cases-of-abuse-at-ottawa-long-term-care-homes

Ottawa Food Safety Inspections
https://app01.ottawa.ca/inspections/index.html?type=food&lang=en

Ottawa Public Health – Inspection Results
http://www.ottawapublichealth.ca/en/public-health-services/inspection-results.aspx

Long-term care overview
https://www.ontario.ca/page/about-long-term-care

Retirement Homes Regulatory Authority Public Register
https://www.rhra.ca/en/search-the-public-register/

Bereavement Authority of Ontario
https://thebao.ca/

Week Twelve(TOP)

Nov. 21

WHAT WE WILL COVER

Review of linking tables in MySQL

Working with City of Ottawa parking-ticket data

LINKS:

Ottawa restaurants
https://ottawamagazine.com/

City parking tickets big business for private companies
https://www.cbc.ca/news/canada/ottawa/businesses-institutions-profit-from-ottawa-parking-tickets-1.4791938

Parking hotspots (CTV News)
https://ottawa.ctvnews.ca/video?clipId=620093

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

Week Thirteen(TOP)

Nov. 28

WHAT WE WILL COVER

MySQL test

Creating tables and importing files into MySQL

LINKS:

Black market animal smuggling – ATIP
https://www.cbc.ca/news/politics/black-market-animal-smuggling-canada-1.4720102

‘We’re guinea pigs’: Canada’s oversight process for implanted medical devices stuns suffering patients
https://www.cbc.ca/news/health/implanted-files-medical-devices-icij-1.4909196

Insulin pumps linked to more reports of injury and death than any other medical device, records show
https://www.cbc.ca/news/health/implant-files-insulin-pumps-1.4915491

Why many Canadians face long waits or big bills to have painful medical devices removed
https://www.cbc.ca/news/health/medical-devices-implant-files-removal-1.4913807

Patients stunned over lack of oversight for implanted medical devices | The Implant Files
https://www.cbc.ca/news/thenational/patients-stunned-over-lack-of-oversight-for-implanted-medical-devices-the-implant-files-1.4921997

Canadian doctors sounding the alarm over Biocell breast implants | The Implant Files
https://www.cbc.ca/news/thenational/canadian-doctors-sounding-the-alarm-over-biocell-breast-implants-the-implant-files-1.4921862

Health minister vows to strengthen oversight of medical devices after investigation reveals problems
https://www.cbc.ca/news/health/health-minister-responds-the-implant-files-1.4926186

International Consortium of Investigative Journalists:‘Deeply concerned’ by Implant Files, Canada vows to strengthen medical device oversight
https://www.icij.org/blog/2018/11/deeply-concerned-by-implant-files-canada-vows-to-strengthen-medical-device-oversight/?utm_content=buffer32620&utm_medium=social&utm_source=twitter.com&utm_campaign=Buffer+-+Twitter

Health Canada Releases Action Plan on Medical Devices
https://www.canada.ca/en/health-canada/news/2018/12/health-canada-releases-action-plan-on-medical-devices—plan-accelerates-action-to-improve-the-safety-effectiveness-and-quality-of-medical-devices.html

Ottawa unveils plan to make medical devices like insulin pumps, pacemakers safer
https://www.ctvnews.ca/health/ottawa-unveils-plan-to-make-medical-devices-like-insulin-pumps-pacemakers-safer-1.4225985

Health Canada introduces new safegaurds against faulty medical devices
https://www.thestar.com/news/investigations/2018/12/20/ottawa-unveils-plan-to-make-medical-devices-like-breast-implants-pacemakers-safer.html

Health Canada announces oversight plan to improve safety of medical devices
https://www.theglobeandmail.com/canada/article-health-canada-unveils-new-protocols-to-improve-safety-of-medical/