Course: JRN315 JN8404
Term: Fall 2021
Ryerson University
Title: Advanced Research Methods: Investigative Reporting
Section: 1
Type: LEC
Hours: 6
Day/Time: Friday 13:00-19:00
Method: Hybrid
Land Acknowledgement
While we may not all be in Toronto it is important to acknowledge the treaty areas and
unceded territories we occupy and thank the Indigenous nations for welcoming us to their
territory.
Toronto is in the ‘Dish With One Spoon Territory’. The Dish With One Spoon is a treaty
between the Anishinaabe, Mississaugas and Haudenosaunee that bound them to share the
territory and protect the land. Subsequent Indigenous Nations and peoples, Europeans and all newcomers have been invited into this treaty in the spirit of peace, friendship and respect.
Instructor Information
Instructor:
David McKie
Email Address:
David email: davidmckiec@gmail.com
Phone Number:
David: 613-290-7380 (cell)
Office Hours: TBD
Teaching Assistant:
Camila Bains
Email address: camilla.bains@ryerson.ca
Phone Number: 647-921-9146
Biography
I am an Ottawa-based, award-winning journalist who spent 26 years honing his skills at the Canadian Broadcasting Corporation as an investigative producer.
I am now the National Observer’s deputy managing editor.
I teach at the schools of journalism at Carleton University, the University of King’s College, and Ryerson University, and have co-authored three journalism textbooks and two user guides on freedom-of-information laws and privacy, respectively.
In addition to my teaching, I’m a data-journalism trainer who has conducted workshops for the Canadian Association of Journalists, the U.S.-based National Institute for Computer-Assisted Reporting, the Humber Institute of Technology and Advanced Learning, and the Canadian Association of Community Television Users and Stations. I also continue to offer data-journalism training to the CBC.
I have a BJ and an MJ from Carleton.
You can find more information about me on my online cv.
Course Overview
Course Description
Senior students explore the world of specialized investigative reporting, using tools such as complex public record-searching, spreadsheet analysis and advanced Internet search
techniques. They complete a complex reporting project using a variety of methods.
Course Focus and Scope
The course provides a wide-ranging introduction to investigative research and writing.
Through a combination of virtual and in-person lectures, workshops, and a live investigation, students will learn to identify research sources, extract the necessary information, and put it to use. Public records, data, and freedom-of-information requests will be among the techniques taught to enrich both investigative projects and daily reporting.
Part of every meeting will be devoted to planning work on our group investigation and discussing or work-shopping the reporting, and the direction of the investigation will change depending on where the work leads us.
This lab portion is a practicum. It will introduce participants to investigative
collaborations, which encompasses skills in the areas of solutions and data journalism as
we work together as a group to hold government and industry to account on a national
scale. We will learn on the job as journalists do, working side by side as we report the story.
In consequence, part of every meeting will be devoted to planning work on our group
investigation and discussing or work-shopping the reporting, and the direction of the
investigation will change depending on where the work leads us.
Learning Outcomes
At the end of this course, students will be able to:
- Conceptualize and pitch an investigative story;
- Understand investigative reporting in the current climate of the industry;
- Evaluate the effectiveness of investigative projects;
- Thinking critically about research, ethics, legal risks and self-care;
- Research using public records, federal access-to-information and provincial and municipal freedom-of-information requests, online tools and
other documentation; - Develop sources and carry out investigative and accountability interviews;
- Identify and obtain foundational documents and data sets, know how to use a
spreadsheet as to analyze data and organize information using a timeline; - Create data visualizations using tools such as Tableau and Datawrapper;
- Debunk poor research, and understand concepts of sampling, correlation, and
margins of error, using federal polling data being used during the election campaign; - Utilize tools critical to emerging areas of investigative journalism such as
disinformation; - Collaborate effectively on a possible cross-Canada investigation with colleagues;
- Write an in-depth pitch document.
Teaching Methods
Please read this carefully. While this course appears as 6 hours of scheduled class on
Fridays from 1 pm to 7 pm, this has been adapted into two hours of asynchronous
learning, which you can complete anytime during the week, but must be completed before
classes, an in-person or online lecture from 3:00 – 5:00 PM ET on Fridays with David McKie;
and an in-person or online lab from 5:15 to 7:00 PM ET with David McKie. These adaptations have been made to create the best learning experience in light of the continuing pandemic.
Details below
Asynchronous Learning
Asynchronous learning includes reading assignments, audio and visual materials, and
concept checks, all of which are posted in D2L. These assignments replace two hours of class time, therefore students should expect to spend up to two hours to complete these materials. All materials are available one week in advance of the next class. All the required materials should be completed before class and form the basis for in-class exercises, quizzes and lab work. It is highly recommended that you set aside two hours a week in your schedule and treat this as if it was a scheduled class. You may wish to organize socially distant or online study groups to help reinforce your commitment to online learning.
Please do not fall behind!
The lecture or group presentations 3:00 – 5:00 PM ET on Fridays with David McKie
When we meet virtually, a zoom link will be posted to this lecture in D2L usually just prior to the lecture. As this is a hybrid course, there will also be monthly in-person meetings at dates to be announced at the beginning of the course.
The lecture includes direction, teaching and hand-on practicing of skill sets.
Occasionally there is a guest speaker.
The Lab 5:15 to 7 PM ET with David McKie
The latter part of the course will be devoted to group work where you will discuss your project, brainstorm new ideas and troubleshoot. The instructure will visit with each group to chart progress, and suggest ideas.
About both classes, the Lecture and the Lab
- This will be a hybrid course with most of our sessions happening virtually. Once a month we will meet in person, though people who want to continue meeting virtually during those classes are welcome to do so.
- The lecture and lab will be recorded if you miss a class, but attendance is part of your
final mark; - When virtual, it is preferred that you have cameras on during these sessions if possible, especially when engaging with guest speakers;
- Attendance is taken at the beginning of classes, and the classes start on time;
- Attendance and participation in seminars count toward your grade;
- You may miss one lecture and one lab class without a penalty to your attendance or
explanatory note; - If you miss a class, you are still responsible to catch up by watching the recording,
as information from these classes may be referenced in quizzes and is necessary to
the investigation; - All grading is done by David McKie;
- Investigations are unpredictable, inherently changeable. The assignments and the
class schedule in this outline will be updated as our reporting progresses.
Because this is a journalism course, the news often overtakes our best-laid plans, and new
readings and speakers will be added throughout the semester. So please, make sure you
check D2L regularly. However, we commit that no mandatory reading will be
added with less than one week’s notice.
Acknowledging that some students may have challenges attending class due to time zone
issues, those students should contact the professors as soon as possible to discuss
accommodations. While we will do our best to accommodate you please be aware that realtime.
Lab participation is a course requirement. Students who experience connectivity
issues should contact the professors. Please be aware it is possible to participate by
telephone in Zoom, through a local number, as an alternative if video calling is not possible
due to connectivity issues.
Required Course Textbook(s) and Materials
Digging Deeper, A Canadian Reporter’s Research Guide, by David McKie et. al., available through the Ryerson University online bookstore. This book will serve both as a class text, and as a review guide once you have completed the course.
In order to help with your access-to-information requests and data work, you may want to purchase Your Right to Know and The Data Journalist — also by David McKie et. al. — respectively. The latter two books are optional.
Students must either subscribe to the digital version or own a
hard copy of the Canadian Press Stylebook 18th edition and Caps and Spelling 22nd
edition. (There are no assigned readings in the stylebook, but marks will be deducted from
assignments for style errors.)
Marking Scheme
For more information about exams, please see Ryerson University’s Senate Policy on
Examinations No. 135. For more information about grade appeals and reassessments
please see relevant Senate Policies:
Assignment | Percentage |
Group presentation on your topic | 15 |
Group story pitch of your project | 15 |
Individual story work during the term | 15 |
Final package | 15 |
Weekly group project updates from week six | 10 |
Professionalism | 15 |
Access-to-information requests | 15 |
Total | 100 |
Grade Scale
Grade | Grade Point Value | Description |
A+ | 90-100 | Excellent and above expectations |
A | 85-89 | Excellent |
A- | 80-84 | Very good |
B+ | 77-79 | Good |
B | 73-76 | Decent effort but needs improvement. |
B- | 70-72 | Below expectations. |
F | 0-69 | Fail |
INC | Incomplete | |
ILL | Compassionate reasons, illness |
Classroom management
The subject matter of this course is serious in nature, rooted in themes such as corruption,
illegality and abuse of the public trust. This inevitably leads to often intense discussions
about the role of journalism and how best to gather difficult information and present it in a
fair, balanced and legally responsible manner. These topics often inspire strong feelings and debates, all of which contribute meaningfully to our collective understanding of the issues and our work in covering them. They are typically fascinating, even when difficult, and are essential to our collective understanding of the issues we are exploring.
Questions and comments will always be graciously received and respected. Attempts to
think outside the box or pose contrary viewpoints will be equally welcomed. This work
focuses on issues with strong sides and sometimes polarized views. Our discussions should reflect that in the interest of understanding.
Throughout, I will seek to maintain civil and productive discussion that fosters learning,
mutual respect and professional collegiality. There will be disagreements on issues, as there should be. But we will maintain civility and push to understand opposing views. I will
constantly seek to provide an environment that is free from harassment and discrimination.
This is your right and your responsibility, protected by this university’s policy. Racism, sexism, ableism, homophobia, transphobia and xenophobia are not tolerated. We respect one another’s unique lived experiences. We aim to be thoughtfully critical, and always kind.
A note about devices
Buzzing phones and can be disruptive even over Zoom — or in-person — and texting or multi-tasking during lectures is not conducive to learning. Please do not send or read messages via your handheld device during classes, or try to do other work simultaneously during class. If you are expecting a truly important call during a class, inform us in advance, and mute your mic. If a call does come in, turn off your video.
Please speak to us if you have any concerns about device use during class.
Late Assignments
Deadlines matter in journalism, they matter at RSJ and they matter in this class.
Extensions will be granted only on health or compelling compassionate grounds and MUST
be discussed before the work is due.
All other late assignments will receive grade deductions based on the university’s senate
policy, and be penalized one letter grade (from B to B- etc.) for each day or portion of day
beyond the deadline. That means an assignment due at noon ET and handed in beyond that deadline will lose one letter grade every 24 hours past the deadline.
Missed term work or examinations
Health Certificate
If you will miss an assignment, test or examination due to illness, you should let your
instructor know in advance and then submit an Academic Consideration Request Form
within three working days of the missed assessment. If you are a B. Journ., student, this form should go to RSJ student affairs coordinator, Bev Petrovic; all other students should submit the documentation to their home department or program’s student affairs coordinator or program administrator.
If this happens only once per semester, you will NOT have to provide a health certificate or
other documentation from a health-care provider — Ryerson University’s new policy on
missed assessments indicates that students need a health certificate signed by a physician
only if they miss more than one assignment, test or examination in a course in a single
semester. If you are going to miss a second assessment, please let me know in advance or
ASAP after the fact.
Missed Term Work or Examinations – with Accommodation Letters
Students are expected to complete all assignments, tests, and exams within the time frames and by the dates indicated in this outline.
If you need accommodations according to Policy 159: Academic Accommodation of Students with Disabilities, the student and instructor must discuss any modifications as soon as possible.
Missed Term Work or Examinations – without Accommodation Letters Exemptions or deferral of an assignment, term test, or final examination is only/may be permitted for a medical or personal emergency or religious observance.
Please provide documentation as below:
- Health Certificate: If you will miss an assignment, test or examination due to illness,
you must submit a health certificate and an Academic Consideration Request form
within three working days of the missed deadline, test, or examination submit to RSJ
Student Advisor, Bev Petrovic — not to your instructor. - Religious, Aboriginal, and Spiritual Observance: For accommodations based on
religious, Aboriginal, and spiritual observance reasons, a Request for Accommodation of Student Religious, Aboriginal and Spiritual Observance form and an Academic Consideration Request form must be submitted within the first two weeks of class or, for a final examination, within two weeks of the posting of the examination schedule.
Plagiarism
Ethical and truthful work
Your work should be accurate, verifiable and your own; using fake interviews,
misrepresenting or making up sources, data or using misleading visuals/audio, are all
serious journalistic and academic offences. Your work also must be free of any copyright restrictions. If you have ANY doubts, please speak to the instructor. Details are in the School of Journalism’s Rules of Conduct, which contain greater detail about truth-telling issues specific to the practice of journalism. These are in the student handbook.
All work you submit must be entirely your own. Penalties for fabrication, plagiarism or other forms of cheating will range from failing an assignment to failing the course and will include a disciplinary notice being placed on your academic record.
You are required to adhere to Ryerson University’s Academic Integrity policy which covers
plagiarism and other transgressions. It is at:
http://www.ryerson.ca/senate/policies/pol60.pdf
Course Information
The following section addresses course-specific issues and general information about
student access and support.
Departmental Policies and Course Practices
To learn more about course management expectations, please review Ryerson University’s
Course Management Policy No.166
Student safety while reporting
I know you are all adventurous journalists who want to get the story, and when practicing
journalism, we normally go to where the story is! But please always keep your personal
safety in mind while reporting. Please keep in mind the safety of others in your family as
they may be at risk from the pandemic. Always leave a situation or interaction in which you
feel unsafe or harassed. Avoid going into private residences on your own, and follow the
law and recommendations for safety during the pandemic in your province. Make sure
someone always knows where you are while reporting. If you are reporting a story that
involves listening to accounts of traumatic events, be sure to check in with yourself often
and take breaks before you need them. Speak to me if you have a story that you think
requires some planning around health and safety and I will be happy to assist.
Accessibility
Ryerson University’s Student Learning Support office will work confidentially and directly
with you if you have temporary and permanent disabilities that impact your academic
functioning; your rights and responsibilities are outlined here:
Ryerson Senate Policy for Academic Accommodation of Students with Disabilities No.
159.
Once the instructor receives an accommodation letter, the instructor should meet with the
student to discuss what arrangements should be made to assignments, classes or other
issues in the course.
Ryerson Student Email
All students in full and part-time graduate and undergraduate degree programs and all
continuing education students are required to activate and maintain their Ryerson online
identity at ryerson.ca/accounts in order to regularly access Ryerson’s email, RAMSS, the
my.ryerson.ca portal and learning management system, and other systems by which they
will receive official university communications.
Specific Details on IT Requirements
A computer and a phone are required for this course. Please review the minimum technical
requirements for students to access Ryerson University’s online learning resources.
You should install the following software:
- Zoom is available to Ryerson Students here: https://ryerson.zoom.us/
- Google Chrome (Week 2) is available here: https://www.google.com/chrome/
Microsoft Excel (Needed for week 3) - https://www.ryerson.ca/ccs/services/software/microsoft/
Throughout this course you will be prompted to add chrome extensions and bookmark links. The class will also be using google drive to share documents.
Student Support and Assistance
If you are experiencing technical or administrative issues with your course, help is
available by completing the Ask RSJ form.
Ryerson University offers services to address a broad range of common challenges students face. Don’t hesitate to ask your instructor for assistance connecting with any of these great resources.
- The Learning Success Centre: offers help with transitioning to university, English
language skills, study skills and math support (yes, journalists do need to do math) - Ryerson Centre for Student Development and Counselling: provides support to
address personal, educational and career concerns.
There is a wide range of other services available to Ryerson students; if you need any kind
of assistance, PLEASE just ask—ask your instructor, the course lecturer, the student affairs
coordinator or any other RSJ instructor or staff member.
In addition to Ryerson’s services and supports, Good2Talk is a free, confidential helpline
providing professional counselling and information and referrals for mental health,
addictions and well-being to post-secondary students in Ontario, 24/7/365. Students can
reach Good2Talk by calling 1-866-925-5454 or by dialing 2-1-1 and asking to be connected
to Good2Talk.
This is a demanding program; our expectations are high and the standards are rigorous.
But please know that, when you encounter problems, we are here to help. For that reason,
you should never hesitate to reach out.
Assignment Descriptions
More detail will be provided in D2L a week in advance of the due date; a full assignment
description is posted at least one week in advance.
Assignments
Assignment | Description | Value | Due Date | |
An in-class group presentation about your topic | This presentation, based on each group’s initial research, will be written up as a PowerPoint and presented in class. Each member will be required to participate with a discussion about their contribution. | 15% (group) | Sept. 24 | |
Access-to-information requests | This will be formal request based on the criteria discussed the previous week and reading Chapter 10 in Digging Deeper | 15% (individual) | Oct 1 | |
An in-class group story pitch | You will be required to complete this “Watchdog: Storyboarding worksheet” courtesy of the Investigative Reporters and Editors. Each member will be required to participate with a discussion about their contribution. | 15% (group) | October 8 | |
Overall final story package or latest draft | This will be the final draft to take the form of a pitch, or draft story if your research progresses that far. | 15% (Group) | Dec 3 | |
Individual story work during term | Broken down by who does what within each group. Each person will be required to share a Google Sheet with tables containing entries for each task, which would include searching for public records, filing access-to-information requests and conducting background interviews. | 15% (individual) | ||
Weekly group project updates. | From week six to week 13 indicating progress and status of major elements of the story package. This, too, can be shared in a Google Sheet. | 10% (group) | ||
Professionalism | This grade will be a combination of your participation in class based on the assigned readings, and your work following the video tutorials. | 15% (individual) |
Rubrics
Grading rubric for assignment one: An in-class group presentation about your topic
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Research and understanding (33.33%) |
Has a clear understanding of the story’s focus and is able to identify the major players. | Has a good, general understanding of the story and its main characters, but has some gaps in the explanation. | Has a poor understanding of the story and its focus and is unable to explain it clearly. |
Analysis and thinking (33.33%) |
Shows an excellent understanding of the types of records that were used and whether they were employed effectively. | Shows a good understanding of the types of records used and whether they were employed effectively. | Shows a poor understanding of the types of records used and whether they were employed effectively. |
Writing and presentation (33.33%) |
Writing is crisp and clear. Words are carefully chosen and spelled correctly. Follows CP style. | Writing is generally sound, but may contain a few poorly crafted sentences. Minor spelling mistakes and/or problems with CP style. | Writing is unclear or word choice not ideal, or major problems with punctuation. Several spelling mistakes and/or major problems with CP style.
F: misspelled name |
Grading rubric for assignment two: filing access-to-information requests
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Filing of a federal request (33.3%) |
Has conducted the legwork necessary to file at least two well-researched, properly worded requests at this level. | Has done the legwork, but has only filed one request and conducted some research. | Has neglected to file a request and has done no research. |
Filing at the provincial level (33.3%) |
Has conducted the legwork necessary to file at least one well-researched and properly worded request at this level. | Has done the legwork for one request with some research and adequate wording. | Has neglected to file a request and has done no research. . |
Filing af the municipal level (33.3%) |
Has conducted the legwork necessary to file at least one request at this level. | Has conducted the legwork necessary and shows evidence that a request will be filed. | Has neglected to file a request and has done no research. |
Grading rubric for third assignment: An in-class group story pitch and completing a Watchdog: Storyboarding worksheet
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Quality of the story idea (33.3%) |
It is a brand new story or novel treatment of a well-known story. | It contains some new elements, but needs work. | Focus is old, irrelevant or unclear. |
The quality of the records (33.3%) |
The public records shed new light on the story and advance our knowledge and will be an integral part of the story. | The records cover some new ground and can be used sparingly. | The records are of little to no use. |
The quality of the multimedia elements. (33.3%) |
The multimedia elements add value to the public records in the story you are pitching because they are up to date, and provide a level of detail not contained in the records. | The elements provide valued-added content, but mostly are repetitions of what we already know in the proposed story. | The elements are unclear and provide no new information. |
Grading rubric for fourth assignment: Overall final story package or latest draft
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Quality of the story idea (33.3%) |
It is a brand new story or novel treatment of a well-known story. | It contains some new elements, but needs work. | Focus is old, irrelevant or unclear. |
The quality of the records (33.3%) |
The public records shed new light on the story and advance our knowledge and will be an integral part of the story. | The records cover some new ground and can be used sparingly. | The records are of little to no use. |
The quality of the multimedia elements. (33.3%) |
The multimedia elements add value to the public records in the story you are pitching because they are up to date, and provide a level of detail not contained in the records. | The elements provide valued-added content, but mostly are repetitions of what we already know in the proposed story. | The elements are unclear and provide no new information. |
Grading rubric for individual story work during term
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Keeping track of your work (33.3%) |
Completes the workflow forms at least three times a week, which includes monitoring the Google alerts on your topic, filing formal and informal access-to-information requests, searching for public records and conducting background interviews. | Completes the workflow forms at least twice a week, which includes monitoring the Google alerts on your topic, filing informal and formal requests, searching for public records and conducting background interviews. | Completes the workflow forms once a week, which includes monitoring the Google alerts on your topic, filing informal and formal requests, searching for public records and conducting background interviews. |
The quality of the records (33.3%) |
Your public records shed new light on the story and advance our knowledge and will be an integral part of the story. | The records cover some new ground and can be used sparingly. | The records are of little to no use. |
The quality of the multimedia elements. (33.3%) |
Keeping track of multimedia elements that can be used for the project that shed new light. | Keeping track of multimedia elements that can be used for the project that shed some new light. | Keeping track of multimedia elements that can be used for the project that shed little or no new light. |
Grading rubric for weekly group project updates
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Quality of the story idea (50%) |
Progress is updated once a week in a Google doc that includes the highlights of group discussions, progress, setbacks and challenges. | Progress is updated once every two weeks in a Google doc that includes the highlights of group discussions, progress, setbacks and challenges. | Progress is updated once a month in a Google doc that includes the highlights of group discussions, progress, setbacks and challenges. |
The quality of the records (50%) |
There is clear evidence of a to-do list for the following week. | There is some evidence of a to-do list for the following week. | There is no evidence of a to-do list for the following week. |
Grading rubric for professionalism
Excellent (A- to A+) |
Good (B- to B+) |
Below expectations (C+ and below) |
|
Class attendance (33.3%) |
Attendance ninety per cent of the time | Attendance 80 per cent of the time | Attendance less than 60 per cent |
Completing video tutorials (33.3%) |
Completes the tutorials and is able to duplicate the work when tested. | Completes the tutorials, but is only able to partially complete the work when tested. | Does not complete the tutorials and can not complete the work when tested. |
Participation (33.3%) |
Participates during class discussions without being asked, and completes the assigned readings. | Participates during class discussions but has to be asked, and completes the assigned readings. | Does not participate during class discussions and does not complete the assigned readings. |
Weekly Schedule
Week one: Sept. 10
What we will learn:
Class recording
https://www.youtube.com/watch?v=u0w1GbvlDMQ
Course outline;
Discussion of the course;
Discussion of strategy behind an investigation and what makes it different from a regular story;
Read and discuss the specific examples under the links section;
Discuss example of an investigative story read in class, what worked, what didn’t;
General discussion about public records;
Learning about filing an informal access-to-information request and search for public records;
Split into groups.
Links:
https://studio.youtube.com/video/u0w1GbvlDMQ/edit
https://j-source.ca/j-source-newsletter-sign-up/
New ‘ultra potent’ opioids hitting Toronto streets in recent weeks as overdose deaths mount
https://www.thestar.com/news/investigations/2021/07/26/new-ultra-potent-opioids-hitting-toronto-streets-in-recent-weeks-as-overdose-deaths-mount.html
New ‘ultra potent’ opioids hitting Toronto streets in recent weeks as overdose deaths mount
https://www.thestar.com/news/investigations/2021/07/26/new-ultra-potent-opioids-hitting-toronto-streets-in-recent-weeks-as-overdose-deaths-mount.html
Toronto Star/National Observer: Generation Distress
https://ijb.utoronto.ca/projects/generation-distress/
Clean water broken promises
https://www.nationalobserver.com/tags/clean-water-broken-promises
https://storymaps.arcgis.com/stories/cbdc979bf27642bfba51689ca3c180e8
Clean water broken promises
https://www.nationalobserver.com/tags/clean-water-broken-promises
https://storymaps.arcgis.com/stories/cbdc979bf27642bfba51689ca3c180e8
How an Ontario paper mill poisoned nearby First Nations
https://www.nationalobserver.com/2021/09/01/how-ontario-paper-mill-poisoned-nearby-first-nations
Decades-old water pollution ravaged the health of 2 Ontario First Nations. Elders are still fighting for justice
https://www.nationalobserver.com/2021/09/02/water-pollution-ontario-first-nations-elders-environmental-justice
Decades after mercury poisoned the water, Grassy Narrows still searches for answers
https://www.nationalobserver.com/2021/06/16/decades-after-mercury-poisoned-water-grassy-narrows-searches-answers
CBC: The Big Spend
https://www.cbc.ca/news/topic/Tag/The%20Big%20Spend
Canada tax agency reveals secret study linking home prices to millionaire migration, five years after freedom-of-information request
https://yhoo.it/3gZpCeH
25-year-old internal memo to Canada Revenue Agency predicted foreign money distorting housing market
https://www.theglobeandmail.com/canada/british-columbia/article-25-year-old-internal-memo-to-canada-revenue-agency-predicted-foreign/
Fix broken Access to Information law, public tells federal review
https://www.theglobeandmail.com/politics/article-fix-broken-access-to-information-law-public-tells-federal-review/
Federal
Completed Access to Information Requests
https://bit.ly/3D7b0mT
Question Period Notes
https://search.open.canada.ca/en/qp/
CBC
https://cbc.radio-canada.ca/en/impact-and-accountability/access-to-information/list-of-ati-requests-processed-by-cbc-radio-canada
Completed access to information requests
https://www.priv.gc.ca/en/privacy-and-transparency-at-the-opc/proactive-disclosure/completed-access-to-information-requests/
Provinces
British Columbia
Main: http://www.gov.bc.ca/citz/iao/foi/
Completed requests:
http://www2.gov.bc.ca/gov/search?id=4BAD1D13C68243D1960FECBBF7B8B091
Manitoba
Main: http://www.gov.mb.ca/chc/fippa/
Completed requests: https://www.manitoba.ca/openmb/infomb/fippa.html
Proactive disclosure:
https://www.manitoba.ca/openmb/index.html
https://manitoba.ca/openmb/infomb/departments/index.html
Newfoundland and Labrador
Main: http://www.atipp.gov.nl.ca/info/accessrequestform.html
Completed requests: http://atipp-search.gov.nl.ca/
Nova Scotia
Info: http://novascotia.ca/is/programs-and-services/information-access-and-privacy.asp
File a request online: https://iaprequest.novascotia.ca/
Completed requests: https://beta.novascotia.ca/search-previously-released-information-freedom-information-and-protection-privacy-foipop-request
Yukon
Main: http://www.atipp.gov.yk.ca/
Completed requests: https://open.yukon.ca/data/sites/default/files/20200800-Release.pdf
Cities
Calgary
https://www.calgary.ca/CA/city-clerks/Pages/Information-Access-Privacy/FOIP-request.aspx
Information disclosure: https://www.calgary.ca/ca/city-clerks/legislative-services/confidential-information-release.html
Halifax Regional Municipality http://www.halifax.ca/AccessPrivacy/index.php
Completed requests: https://www.halifax.ca/city-hall/accountability-transparency/access-information/completed-requests
Ottawa
Main: http://ottawa.ca/en/city-hall/your-city-government/access-information-and-privacy
Completed requests: https://ottawa.ca/en/city-hall/accountability-and-transparency/accountability-framework/freedom-information-and-protection-privacy/disclosure-mfippa-requests
Regina
Main: https://www.regina.ca/city-government/administration/office-of-the-city-clerk/#outline-access-to-information-and-protection-of-privacy
Completed requests: http://open.regina.ca/group/freedom-of-information
Toronto
https://www.toronto.ca/city-government/accountability-operations-customer-service/access-city-information-or-records/freedom-of-information/
Completed requests: https://open.toronto.ca/dataset/freedom-of-information-requests-summary/
Vancouver
Main: http://vancouver.ca/ctyclerk/foi/index.htm
Completed requests: http://vancouver.ca/your-government/information-released-through-foi-requests-this-year.aspx
Winnipeg
Main: http://winnipeg.ca/clerks/fippa/
Completed requests: http://winnipeg.ca/clerks/fippa/AccessToInfo.stm
Required readings:
Chapters 1,2,3,4, 10 Digging Deeper
Week two: Sept. 17
Class recording
https://www.youtube.com/watch?v=01cd-GeaEFk
What we will learn:
Discussing what we learned about filing, informal access-to-information and freedom-of-information requests;
Learning about filing formal access-to-information requests;
Discussing story pitches;
Discussing the first assignment;
Split into your groups to discuss your pitches.
A shopping list of key records to obtain through a access-to-information request
20 records you can get using the federal Access to Information Act
1. RECORD: Ministerial briefing notes. DEPARTMENT: All departments. ASK FOR: All briefing notes prepared specifically to help the new minister become acquainted with his/her new portfolio. HINT: Make this request a week or two after a new cabinet is named. RESULT: Yields wide range of information about a department’s plans/activities.
2. RECORD: Expense claims. DEPARTMENT: All departments/agencies. ASK FOR: Receipts, invoices and guest lists detailing travel and hospitality expenses claimed by a deputy minister or other senior bureaucrat that are more detailed than the ones you’ll find in the information federal institutions are obliged to file on line. HINT: Limit request to no more than one year’s worth of claims.RESULT: Can reveal spending habits and establish dates of key meetings, dealings. Remember former federal heritage minister Bev Oda’s $16-dollar glass of orange juice!
3. RECORD: Correspondence. DEPARTMENT: All departments/agencies. ASK FOR: Correspondence with a minister or agency head on a topic of interest. HINT: Frame request narrowly. For instance, exclude letters from the public if you do not require them. RESULT: Can uncover letters from provincial premiers, lobby groups.
4. RECORD: House cards or Question Period Notes. DEPARTMENT: All departments. ASK FOR: All cards prepared for the minister in the House of Commons on a specific issue. HINT: Watch headlines, Commons debates for ideas. RESULT: Often contain much more detail, background than revealed in Question Period. NOTE: At the federal level, these notes are released proactively twice a year.
5. RECORD: Material on possible legislation. DEPARTMENT: All departments. ASK FOR: Records concerning possible legislation or other initiatives on a given issue. HINT: Limit request to cover the last year to ensure currency of material. RESULT: Provides insight into initiatives that might be in pipeline, and reasons why the initiatives might (or might not) proceed.
6. RECORD: Meeting minutes. DEPARTMENT: All departments/agencies. ASK FOR: Minutes from the two most recent meetings of a specific committee. HINT: Make calls to find out meeting schedules and whether minutes are kept. RESULT: Can aid in understanding internal policy debates and decisions.
7. RECORD: Audits. DEPARTMENT: All departments, most agencies. ASK FOR: Audits and evaluations completed by or for the department/agency on specific subjects in the last year. HINT: Ask department informally for list of audits conducted in the last year. RESULT: Audits often reveal shortcomings in programs, policies. NOTE: Increasingly, audits are released proactively.
8. RECORD: Polls. DEPARTMENT: All departments, but especially Privy Council Office. ASK FOR: Polls conducted for the department on a given subject. HINT: Some (but not all) polls are released informally. RESULT: Can reveal public attitudes towards government policies.
9. RECORD: Contract information. DEPARTMENT: All departments. ASK FOR: A copy of the contract for a specific project such as the federal government’s beleaguered Phoenix pay system. HINT: Public Services and Procurement Canada administers many contracts, including Phoenix. RESULT: Reveals details of financial arrangements with private companies.
10. RECORD: Responses to discussion papers. DEPARTMENT: Any department that publishes consultation/discussion paper. ASK FOR:Copies of all submissions in response to the department’s paper. HINT: Put in request just after cut-off date for submissions. Only narrow request if certain submissions are required. RESULT: Reveals views of wide cross-section of groups on pressing issues.
11. RECORD: Contracted studies. DEPARTMENT: Privy Council Office. ASK FOR: Specific studies, research conducted for PCO. HINT: Ask informally for list of studies, which is updated regularly. RESULT: Yields advice prepared for government on unity, security, parliamentary affairs and other key issues.
12. RECORD: 20-year-old cabinet documents. DEPARTMENT: Privy Council Office. ASK FOR: Cabinet records on a specific issue. HINT:Check almanac for noteworthy past events. RESULT: Meeting minutes reveal thinking of ministers on issues. (Cabinet documents routinely become public only after 30 years).
13. RECORD: Prime Minister’s email. DEPARTMENT: Privy Council Office. ASK FOR: E-mail sent to the Prime Minister by visitors to his website. HINT: Limit request to a one-week period. RESULT: Names of correspondents are deleted, but letters yield an interesting mix of feedback, including light-hearted, angry and thoughtful correspondence.
14. RECORD: Criminal intelligence briefs. AGENCY: RCMP. ASK FOR: Criminal intelligence briefs prepared during the last six months. HINT:Make time-frame the last couple of years if you are seeking a brief on a specific subject. RESULT: Briefs cover issues such as aboriginal militancy, drug trade and smuggling.
15. RECORD: Incident reports. AGENCY: RCMP. ASK FOR: Incident report on a specific event. HINT: Broaden request to include other records if incident is a prolonged one, such as a standoff. RESULT: Can help explain police decision-making.
16. RECORD: Lessons learned. DEPARTMENT: National Defence. ASK FOR: “Lessons learned” from major military missions. HINT: Wait a month or two after mission is complete. RESULT: Provides evaluation of peacekeeping tours and other assignments.
17. RECORD: UFO reports. DEPARTMENT: Transport. ASK FOR: Reports of unidentified flying objects filed by the public. HINT: UFO reports are also often filed with Defence and RCMP. RESULT: Names of people who make reports are deleted, but other details can be released.
18. RECORD: Observer reports. DEPARTMENT: Fisheries. ASK FOR: Observer reports prepared for the department. HINTS: Limit request to specific geographic area and time frame. RESULTS: Can provide details about operations of foreign vessels.
19. RECORD: SIRC reports. AGENCY: Security Intelligence Review Committee. ASK FOR: Specific reports prepared by committee on CSIS activities. HINT: Reports are listed in back of committee’s annual report. RESULT: Reports, though heavily edited, provide check on spy agency CSIS.
20. RECORD: CRTC debriefing notes. AGENCY: Canadian Radio-television and Telecommunications Commission. ASK FOR: Debriefing notes prepared in connection with a specific licensing hearing. HINT: Make request shortly after licence decision is made. RESULT: Can provide behind-the-scenes reasoning on why TV, radio licences are granted or denied.
Ten ways to improve your searches
1. Look to the headlines for ideas.
2. Check the relevant federal websites for forms, contacts, info on departmental holdings.
3. Call the access coordinator before making your request.
4. Call the co-ordinator after submitting your request.
5. Make similar requests to more than one department, agency or government.
6. Keep a photocopy or scan of each request and attach all return correspondence.
7. Negotiate with departments, agencies or governments.
8. Be persistent. If necessary, complain.
9. Read and re-read the records you receive carefully.
10. Don’t get discouraged.
Links
From private emails to Post-it Notes: How politicians avoid scrutiny
https://www.opendemocracy.net/en/freedom-of-information/private-emails-post-it-notes-how-politicians-avoid-scrutiny/
ATI extension examples and medical device company court reference.pdf
Search Briefing Note Titles and Numbers
https://search.open.canada.ca/en/bn/
Access to Information and Privacy Coordinators
http://www.tbs-sct.gc.ca/atip-aiprp/apps/coords/index-eng.asp
Information about programs and holdings
https://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/sfgei-srgfff-eng.asp#A
Access to Information: general info
https://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/index-eng.asp
Access to Information request forms
http://www.tbs-sct.gc.ca/tbsf-fsct/350-57_e.asp
epost Connect
https://www.canadapost.ca/cpc/en/business/postal-services/digital-mail/epost-connect.page
Make a federal complaint online
https://www.oic-ci.gc.ca/en/make-complaint-online
Information Commissioner of Canada
https://www.oic-ci.gc.ca/en
2020-21 Annual Report: The pandemic has exacerbated deficiencies of the access to information system
https://www.newswire.ca/news-releases/2020-21-annual-report-the-pandemic-has-exacerbated-deficiencies-of-the-access-to-information-system-881994781.html
Resources
Dean Beeby’s access-to-information tipsheet.pdf
Click here to see an example of an access-to-information request.
Canadian Access to Information News Story Index
http://www.canadafoi.ca/atianewsintro.pdf
To download a tip sheet for pitching, editing and storyboarding an investigative project, please click here.
To download the PowerPoint on the same topic, please click here.
Workflow
Group assignments: Make sure group members begin filing access-to-information requests. Members charged with other tasks should also be doing their jobs.
An initial group presentation about your topic due next class on Sept 24. This work will evolve into a formal presentation that will be due Oct. 8
Each group will conduct initial public records (covered in Digging Deeper) research to find out everything it can about the topic – including:
-
-
-
- What interests you about the topic? What do you think will interest our audience?
- What is new about this topic?
- Determine what organizations, bodies or governments have any regulatory involvement or control over your topic and what each does;
- How do the organizations work together (if they do) and when do they work at cross-purposes?
- What isn’t regulated or controlled at all?
- What do they monitor, how do they do it?
- What sort of data do the organizations collect?
- What format is the data in and what is the historical range of data accessible?
- How easy it to obtain this data?
- Is there information that might be available ONLY if we submit formal or informal access-to-information requests?
- What do you want to know that you haven’t been able to find out?
- What interests you?
- What do you think will interest our audiences?
-
-
Answers to these questions should allow each group to develop initial ideas about your project.
-
-
- What seems worth pursuing?
- What isn’t worth pursuing and why?
- How can you engage your audience?
- What media formats seem appropriate?
-
Assigned task for following class: Create a Google alert tracking stories using access-to-information records.
Week three: Sept. 24
Class recording
https://www.youtube.com/watch?v=0NLoybJWVzs
What you will learn
Brief discussion about stories in your Google alerts produced by access-to-information requests;
Group presentations;
Assignment due: Initial group presentation
As part of its formal presentation, each group will present its findings about its topic, answering the questions noted above, including outlining the data and information available and what isn’t available.
The group will propose ideas about what seems most interesting and worth pursuing, where there could be stories that would interest a general audience.
Each presentation should between 20 to 30 minutes. All members of the group must participate in the presentation, explaining the work they have done thus far. Each presentation will be followed by a general discussion among the class about the ideas presented by the group in an attempt to refine them, compare and contrast what each group discovers and what that means for our overall projects.
Readings: Review Chapter 4 in Digging Deeper
Assigned task for following class.
Creating annotations in DocumentCloud
Week four: Oct. 1
Class recording
https://www.youtube.com/watch?v=P4JaFmj7cSc
What you will learn:
Hansard and other public record searches;
Discussion of the second pitch due on Oct. 8;
Learning how to use DocumentCloud.
Links
Federal Hansard Search
https://www.ourcommons.ca/publicationsearch/en/
Historical Hansard
http://parl.canadiana.ca/
https://www.lipad.ca/
BC Hansard
https://www.leg.bc.ca/advanced-search
Alberta Hansard
https://www.assembly.ab.ca/assembly-business/transcripts/about-hansard
Saskatchewan Hansard
https://www.legassembly.sk.ca/legislative-business/debates-hansard/
Manitoba Hansard
https://www.gov.mb.ca/legislature/hansard/hansard.html
Ontario House Hansard Search
http://hansardindex.ontla.on.ca/
Quebec Hansard
http://www.assnat.qc.ca/en/patrimoine/lexique/hansard.html
New Brunswick Hansard
https://www1.gnb.ca/legis/qp/index-e.asp
Nova Scotia Hansard
https://nslegislature.ca/legislative-business/hansard-debates
Newfoundland and Labrador Hansard
https://www.assembly.nl.ca/houseBusiness/Hansard/
Prince Edward Island Hansard
https://www.assembly.pe.ca/offices/assembly-administrative-offices/hansard
Northwest Territories Hansard
https://www.ntassembly.ca/documents-proceedings/hansard
Yukon Hansard
https://yukonassembly.ca/house-business/hansard
Nunavut Hansard
https://assembly.nu.ca/hansard
Buy and Sell
https://buyandsell.gc.ca/
NVIVO
https://library.carleton.ca/services/nvivo
Statistics Canada’s data tables
Labour force characteristics, monthly, seasonally adjusted and trend-cycle, last 5 months
https://www150.statcan.gc.ca/n1/daily-quotidien/210108/dq210108a-eng.htm?HPA=1&indid=3587-2&indgeo=0
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Open data portals
http://www.davidmckie.com/open-data-portals/
Labour force characteristics, monthly, seasonally adjusted and trend-cycle, last 5 months
https://www150.statcan.gc.ca/n1/daily-quotidien/210108/dq210108a-eng.htm?HPA=1&indid=3587-2&indgeo=0
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
City of Ottawa 311 service requests
https://open.ottawa.ca/search?q=311%20service%20requests
Canadian Institute for Health Information
https://www.cihi.ca/en
Week five: Oct. 8
Brief continued discussion of public records searches, including Hansard, auditors’ general, coroners and court records (Canlii);
Feedback on first two assignments;
Your formal pitch will be due.
Assignment – Presentation in this class of planned story concept and elements and proposed stories if more than one is contemplated.
This should be prepared as a story pitch the group would make to a story meeting. All members of the group will participate in the story pitch. It would include: What are the new and investigative elements?
-
-
- Why is the topic important?
- Details of background research they have done in terms of media coverage, government reports etc. that form the background for this project;
- Who they plan to interview?
- What data they will use and where it will come from?
- How will records obtained through access-to-information requests be integrated and what back-up plans will be used if ATI records fail to materialize?
- What multimedia elements such as visual, audio, graphs and photos will be used;
- What they hope the audience will take away from their story/stories;
- How does their work fit into the larger national project, if at all.
-
Reading for class after reading week: Chapter 8, Digging Deeper – Getting People to Talk: The Art of the Interview
Week six: Oct. 15 — study break
Week seven: Oct . 22
What you will learn
The essential elements of a good interview;
Learning about different kinds of interviews (background, on-the-record);
How to conduct the accountability interview.
Links:
Six basic rules of interviewing.pdf
CBS 60 Minutes interview with former U.S. President Barack Obama — Part 2
https://www.youtube.com/watch?v=KieU1kzUCRo
Charlie Rose interview with Barack Obama
https://charlierose.com/videos/26938
Assigned task for following week: Follow the tutorial for chronology-building tutorial.
Using Excel to build chronologies
Assigned task for the following week: we will be meeting individually in groups to discuss progress.
Week eight: Oct. 29
What you will learn
Investigative tools: building chronologies and contact lists;
Using Google Sheet as a one-stop shop;
Advanced searches;
Downloading Ontario political financing data.
Links:
Google News Advanced Archive Search
http://news.google.com/archivesearch/advanced_search
LexisNexis AlaCarte! (advanced search)
http://alacarte.lexisnexis.com/partners/int/lexisnews/srchNW.asp
Aspertame Kills
http://www.aspartamekills.com/
Federal lobbyists search
http://www.ocl-cal.gc.ca/eic/site/lobbyist-lobbyiste1.nsf/eng/h_nx00274.html
Ontario Lobbyist Registry
http://www.oico.on.ca/home/lobbyists-registration/overview
Political Financing: Elections Ontario
https://www.elections.on.ca/en/political-financing0.html
Assigned task for the following week: TBD
Week nine: Nov. 5
Class recording
https://www.youtube.com/watch?v=6nEUkWiZnKA
What you will learn:
How to dig into court records using CanLii, which includes quasi-judicial bodies such as human rights tribunals, labour boards, coroners’ reports and professional disciplinary bodies;
An introduction to court records (affidavits, search warrants, bankruptcy records, etc)
Links:
B.C.’s 9-1-1 system was plagued by staffing shortages and long wait times long before the heat wave crisis: documents
https://www.theglobeandmail.com/canada/british-columbia/article-bcs-9-1-1-system-was-plagued-by-staffing-shortages-and-long-wait-times/
BC system was plagued by staffing shortages.pdf
British Columbia
Main: http://www.gov.bc.ca/citz/iao/foi/
Completed requests:
http://www2.gov.bc.ca/gov/search?id=4BAD1D13C68243D1960FECBBF7B8B091
The Canadian Legal Information Institute (a voluntary initiative and is not a comprehensive listing of all class action lawsuits currently underway in Canada)
http://canlii.org/en/index.php
Proposed class action launched against Northwood over COVID-19 deaths
https://www.cbc.ca/news/canada/nova-scotia/covid-19-class-action-launched-northwood-1.5595560
Proposed Northwood lawsuit expanded to seek damages from N.S. government
https://atlantic.ctvnews.ca/proposed-northwood-lawsuit-expanded-to-seek-damages-from-n-s-government-1.4998568
A statement of claim in the proposed class action lawsuit against Halifax long-term care home Northwood.
Six Ontario nursing homes ‘failed to protect residents’ from COVID-19, proposed class action lawsuit alleges
https://www.cp24.com/news/six-ontario-nursing-homes-failed-to-protect-residents-from-covid-19-proposed-class-action-lawsuit-alleges-1.4913747
A proposed class-action lawsuit filed against Responsive Group Inc., a company that owns several nursing homes in Ontario.
Proposed class action lawsuit led by former constable alleges racism in RCMP
https://www.cbc.ca/news/canada/british-columbia/rcmp-lawsuit-racism-1.5648362
RCMP Class Action Lawsuit Alleges Systemic Racism
https://ca.topclassactions.com/lawsuit-settlements/discrimination/rcmp-class-action-lawsuit-alleges-systemic-racism/
Class Action Database — Canadian Bar Association
https://www.cba.org/Publications-Resources/Class-Action-Database
Class Action Database (U.S.)
http://www.consumer-action.org/lawsuits/
Kim – Spencer – McPhee Barristers
http://www.kimorr.ca/index.html
Federal Court of Canada
https://www.fct-cf.gc.ca/en/home
The Criminal Code
http://laws.justice.gc.ca/eng/
Supreme Court of Canada
https://www.scc-csc.ca/home-accueil/index-eng.aspx
Tax Court of Canada
http://www.tcc-cci.gc.ca/
Recent Courts Martial results
https://www.canada.ca/en/department-national-defence/corporate/reports-publications/military-law/recent-courts-martial-results.html
Class Proceedings Act
https://www.canlii.org/en/ns/laws/stat/sns-2007-c-28/latest/sns-2007-c-28.html
List of Class Action Lawsuits (U.S)
http://www.classaction.org/list-of-lawsuits
Find out how to request a decision by the Parole Board of Canada
https://www.canada.ca/en/parole-board/services/decision-registry.html
http://www.advocatedaily.com/index.html
Quebec Human Rights Tribunal
http://www.tribunaux.qc.ca/mjq_en/TDP/index-tdp.html
Office of the Chief Coroner
https://www.mcscs.jus.gov.on.ca/english/DeathInvestigations/office_coroner/coroner.html
BC Coroners Service
https://www2.gov.bc.ca/gov/content/life-events/death/coroners-service
Have you been bankrupt? You could become Minister of National Revenue
http://www.davidmckie.com/have-you-been-bankrupt-you-could-become-minister-of-national-revenue/
Office of the Superintendent of Bankruptcy Canada
http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/home
Bankruptcy
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home
Tutorial for conducting bankruptcy searches
Bankruptcydata.com
http://bankruptcydata.com/
Incident-based crime statistics, by detailed violations, Canada, provinces, territories and Census Metropolitan Areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017701
Incident-based crime statistics, by detailed violations, police services in the Atlantic provinces
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017801
Ontario discipline decisions
https://www.cpso.on.ca/News/Discipline-Decisions
Law Society of Upper Canada (list of disbarred lawyers)
http://www.lsuc.on.ca/with.aspx?id=2147486087
Office of the Chief Coroner – Ontario
https://www.mcscs.jus.gov.on.ca/english/DeathInvestigations/office_coroner/coroner.html
Court Record Examples
COVID-19 related class action claim against an Ontaio nursing home chain
Statement of claim against the RCMP
Omar Khadr 2010 Supreme Court of Canada decision uploaded to DocumentCloud
Factum containing demands that Khadr’s settlement be given to victim uploaded to DocumentCloud
Parole Board Decision
Bankruptcy Filing
The bishop’s search warrant uploaded to DocumentCloud
Divorce Proceeding
National Parole Board Statistics
Notice of proposed Armed Forces Settlement
Assigned reading: Chapter 9 in Digging Deeper
Week ten: Nov. 12
Class recording
https://www.youtube.com/watch?v=Tw4GXXv6S4c
What you will learn:
The basics of following money;
The difference between a publicly traded corporation and private company;
How to find out how much a company made;
How to find key numbers in a financial report;
Links:
Access to information requests
CEWS Registry Results
https://apps.cra-arc.gc.ca/ebci/hacc/cews/srch/pub/bscSrch?dsrdPg=1&q.srchNm=car&q.ordrClmn=NAME&q.ordrRnk=ASC
Wage subsidies were meant to preserve jobs. In many cases, the $110.6-billion response padded bottom lines
https://www.theglobeandmail.com/business/article-canada-emergency-wage-subsidy-data-analysis/
Wage subsidies were meant to preserve jobs_Globe and Mail investigation.pdf
CEWS recipients_scraped Nov 2, 2021.xlsx
Air Canada to review French policies as CEO begins private instruction
https://www.cbc.ca/news/canada/montreal/air-canada-ceo-french-lessons-1.6242954
https://www.tradingview.com/e/MSuvXQsL/
https://www.sedar.com/
Air Canada
https://www.aircanada.com/ca/en/aco/home.html#/
Air Canada investor relations
https://www.aircanada.com/ca/en/aco/home/about/investor-relations.html
Air Canada 2020 Proxy Circular
https://www.documentcloud.org/documents/21103394-air-canada-proxy-circular_2020
Air Canada 1st Quarter 2020 financial statement uploaded to DocumentCloud
https://www.documentcloud.org/search/Project:%20%22Corporate%20filings%22
Air Canada annual report uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20494069-air-canada-audited-financial-statement-filed-feb-12-2021
Air Canada management discussion and analysis that accompanies the 2020 financial statement uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20494072-air-canada_2020_mda_q4
Air Canada granted bankruptcy protection
https://www.cbc.ca/news/business/air-canada-granted-bankruptcy-protection-1.366723
CCAA records list
https://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/h_br02281.html
D Bank CEO Bharat Masrani’s total compensation falls to $10.5-million in pandemic year
https://www.theglobeandmail.com/business/article-td-bank-ceo-bharat-masranis-total-compensation-falls-to-105-million-in/#:~:text=Log%20in-,TD%20Bank%20CEO%20Bharat%20Masrani’s%20total%20compensation,%2410.5%2Dmillion%20in%20pandemic%20year&text=Bharat%20Masrani%2C%20Group%20President%20and,%2C%20on%20Sept%203%2C%202020.
TD Investor Relations
https://www.td.com/investor-relations/ir-homepage/financial-reports/quarterly-results/qr-2021.jsp
TD Proxy Circulars
https://www.td.com/investor-relations/ir-homepage/share-information/proxy-circulars/proxy.jsp
TD Proxy Circular annotation uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20498512-td-bank_e-2021-proxy-circular#document/p33/a2020896
MarketWatch
http://www.marketwatch.com/?link=MW_Nav_FP
Nasdaq
http://www.nasdaq.com/
Stockwatch
http://www.stockwatch.com/
Advanced Real-Time Chart Widget
https://www.tradingview.com/widget/advanced-chart/
Air Canada
https://www.aircanada.com/ca/en/aco/home.html#/
Air Canada investor relations
https://www.aircanada.com/ca/en/aco/home/about/investor-relations.html
Air Canada 1st Quarter 2020 financial statement uploaded to DocumentCloud
https://www.documentcloud.org/search/Project:%20%22Corporate%20filings%22
Air Canada annual report uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20494069-air-canada-audited-financial-statement-filed-feb-12-2021
Air Canada management discussion and analysis that accompanies the 2020 financial statement uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20494072-air-canada_2020_mda_q4
Pfizer quarterly reports
https://investors.pfizer.com/financials/quarterly-reports/default.aspx
Pfizer 10-K uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20494062-sec-filings_pfizer-10-k
Canadian Survey on Business Conditions: Impact of COVID-19 on businesses in Canada, May 2020
https://www150.statcan.gc.ca/n1/daily-quotidien/200714/dq200714a-eng.htm?HPA=1
Economic and Fiscal Snapshot 2020
https://www.canada.ca/en/department-finance/services/publications/economic-fiscal-snapshot.html
Economic and Fiscal Snapshot 2020 uploaded to DocumentCloud
https://www.documentcloud.org/documents/6983305-Economic-and-Fiscal-Snapshot-2020.html#document/p61/a570933
BUSINESS ANALYSIS
Google Finance
http://finance.google.com/finance
Bank of Canada keeps key interest rate target on hold
https://www.ctvnews.ca/business/bank-of-canada-keeps-key-interest-rate-target-on-hold-1.5340944
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Bank of Canada
http://www.bankofcanada.ca/
Big Six Banks
https://www.investopedia.com/terms/b/bigsixbanks.asp
RBC Economic Research
http://www.rbc.com/economics/#
BMO Capital Markets
http://economics.bmocapitalmarkets.com/
CIBC Economics Research
https://economics.cibccm.com/economicsweb/EconomicsHome#!WORKSPACE_ID=ECO_HOME
Scotia Bank Economics
http://www.gbm.scotiabank.com/ResearchCapabilities/RE_Scotia_Economics.htm
TD Economics
https://www.td.com/economics/analysis/economics-index.jsp
National Bank Economic Analysis
https://www.nbc.ca/en/rates-and-analysis/economic-analysis.html
BMO Financial Group
https://newsroom.bmo.com/index.php?s=2429
InvestD
https://invesd.com/home
Hoovers
http://www.hoovers.com/#megamenu_0.html
Summary table — Debt to equity ratio by industries (Statistics Canada)
http://www.statcan.gc.ca/pub/61-219-x/2010000/t007-eng.htm
Business Insider
http://www.businessinsider.com/
Financial glossary (Reuters)
http://glossary.reuters.com/index.php?title=Main_Page
Society of American Business Writers and Editors
http://sabew.org/resources/resources/
“Best Business Writing” anthologies compiled by Columbia University
For the most recent edition, click here
Worthwhile Canadian Initiative
http://worthwhile.typepad.com/
SECURITIES COMMISSIONS
US Securities and Exchange Commision
https://www.sec.gov/
British Columbia Securities Commission
http://www.bcsc.bc.ca/
Alberta Securities Commission
http://www.albertasecurities.com/Pages/Default.aspx
Manitoba Securities Commission
http://www.msc.gov.mb.ca/index_en.html
Ontario Securities Commission
http://www.osc.gov.on.ca/en/home.htm
http://www.osc.gov.on.ca/en/Proceedings_before-commission_index.htm
The Autorité des marchés financiers (AMF)
http://www.lautorite.qc.ca/index.en.html
Nova Scotia Securities Commission
http://www.gov.ns.ca/nssc/
The Securities Commission of Newfoundland and Labrador
http://www.gs.gov.nl.ca/cca/fsr/rulemaking/
Public sector money trails
Federal Budgets
https://www.canada.ca/en/department-finance/services/publications/federal-budget.html
Five-Year Departmental Evaluation Plan 2020-2021 to 2024-2025
https://www.sac-isc.gc.ca/eng/1601896999938/1601897029080
Ontario budget 2021
https://budget.ontario.ca/2021/contents.html
One patrol ship and 118 Crown vehicles vandalized, part of $24.2-million in lost property in 2018-19
https://www.hilltimes.com/2020/01/15/one-patrol-ship-and-118-crown-vehicles-vandalized-part-of-24-2-million-in-lost-property-in-2018-19/230140
Public Accounts of Canada 2020
https://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/2020/index-eng.html
Federal Public Accounts – PDF format
https://epe.lac-bac.gc.ca/100/201/301/public_accounts_can/pdf/index.html
Federal Public Accounts – Volume one
https://beta.documentcloud.org/documents/20493461-p51-1-2020-3-eng
Federal Public Accounts – Volume two
https://beta.documentcloud.org/documents/20493462-p51-1-2020-2-eng
Federal Public Accounts – Volume three
https://beta.documentcloud.org/documents/20493461-p51-1-2020-3-eng
BUSINESS REPORTING
Donald W. Reynolds National Center for Business Journalism
http://businessjournalism.org/
Beginners’ Guide to Financial Statements (U.S. Securities and Exchange Commission)
http://www.sec.gov/investor/pubs/begfinstmtguide.htm
Assigned class for next class: TBD
Week eleven: Nov. 19
Class recording
https://www.youtube.com/watch?v=h5ucGvHxIuA
What you will learn:
Making sense of records received through access to information;
Decoding records;
Building chronologies.
Links
Uploading documents to DocumentCloud
https://www.youtube.com/watch?v=i_d0zsw6hhQ&feature=youtu.be
DocumentCloud Tips and Tricks
https://www.documentcloud.org/help/tips
Feds’ two billion tree goal hinges on provincial buy-in
https://www.nationalobserver.com/2021/06/10/news/federal-two-billion-tree-goal-hinges-provincial-buy-in
Is the feds’ two billion trees program simply a path to more logging?https://www.nationalobserver.com/2021/06/18/news/transparency-feds-two-billion-tree-planting-program
Week twelve: Nov. 26
What you will learn:
A quick review of auditors general reports, using two report cards on the federal and Ontario environment track records as examples
Reviewing procedure for filing formal access-to-information complaints
Working with data using Statistics Canada hate crime and Correctional Service of Canada offender profile data
Sorting; filtering; building pivot tables
Discussion of final group presentation
Links:
Canada’s climate change efforts going from ‘failure to failure,’ says commissioner’s report
https://www.cbc.ca/news/politics/environment-commissioner-report-failure-to-failure-1.6262523
Commissioner of the Environment and Sustainable Development
https://www.oag-bvg.gc.ca/internet/english/parl_lp_e_901.html
Ontario ignoring public’s rights to environmental consultation, public info: audit
https://www.cbc.ca/news/canada/toronto/ontario-auditor-general-report-environmental-audits-1.6257828
Office of the Auditor General of Ontario
https://www.auditor.on.ca/en/content/annualreports/annualreports.html
Inside the war on hate
https://www.winnipegfreepress.com/local/heedless-to-hate-perilous-indifference-575777282.html
Statistics Canada Tables
https://www150.statcan.gc.ca/n1/en/type/data
Police-reported hate crime, by type of motivation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510006601
Police-reported hate crime, by most serious violation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510006701
Police-reported hate crime, number of incidents and rate per 100,000 population, Census Metropolitan Areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510019101
Incident-based crime statistics, by detailed violations, Canada, provinces, territories and Census Metropolitan Areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017701
Bias behind bars: A Globe investigation finds a prison system stacked against Black and Indigenous inmates
https://www.theglobeandmail.com/canada/article-investigation-racial-bias-in-canadian-prison-risk-assessments/
Correctional Services of Canada offender profile datasets
https://open.canada.ca/data/en/dataset?organization=csc-scc
Open Data File 20170409 v3.xlsx
CEWS Registry Results
https://apps.cra-arc.gc.ca/ebci/hacc/cews/srch/pub/fllLstSrh?dsrdPg=411&q.ordrClmn=NAME&q.ordrRnk=ASC
Ken Boessenkool and Mike Moffatt: It’s time for the banana talk, Mr. Macklem
Information Commissioner of Canada
https://www.oic-ci.gc.ca/en
Information and Privacy Commissioner of Ontario
https://www.ipc.on.ca/
Week thirteen:
Dec. 3
Class recording
https://www.youtube.com/watch?v=AGsQ6gTUxlM
What we will cover:
Story pitches from all three groups;
FOI follow-up;
Course wrap-up
Links
Governor General’s office investigating internal network breach
https://www.burnabynow.com/national-news/governor-generals-office-investigating-internal-network-breach-4821639
ANALYSIS: 3 pages, 520 days of delay, and Canada’s busted access-to-information system
https://globalnews.ca/news/8415871/canada-access-to-information-delays-covid-19/
Additional Resources
In Behind the Scenes: A Canadian Journalism Foundation with Globe and Mail investigative reporters discussing their techniques and tips
https://twitter.com/cjffjc/status/1466850238677794816
Data Journalism Academy: Writing with data
https://sites.google.com/view/mj-basic-data-academy/data-state-of-mind/writing-with-data?authuser=0
The Quartz guide to bad data
https://github.com/Quartz/bad-data-guide
Michael Creagen’s instructional video for photo ideas
https://www.youtube.com/watch?v=V9Gb69vlxKo&feature=youtu.be
Downloadthemall (Youtube demo)
https://www.youtube.com/watch?v=hzl4WIExeUA
Downloadthemall (for Firefox)
https://www.downthemall.net/
Downloadthemall (for Chrome)
https://chrome.google.com/webstore/detail/downthemall/nljkibfhlpcnanjgbnlnbjecgicbjkge?hl=en
Tutorials
Climate disaster public record reporting guide
Video Tutorial
Video one: https://www.youtube.com/watch?v=Urk-XR05bg4&feature=youtu.be
PDF Tutorial
Tutorial one: Using Tableau to Visualize COVID_updated.pdf
Practice Data
Dataset for Tableau Practice Session: The Public Agency of Canada’s COVID-19 DATA with a cleaned up date column
Getting data into Tableau:
https://www.youtube.com/watch?v=rrt8hyOaZRI
Working with data:
https://www.youtube.com/watch?v=a7nuVSsXWeM
Building dashboards:
https://www.youtube.com/watch?v=Es50LH0Pbiw