4100A – 5508A – Professional Practices – Specialized Media
Investigative Journalism Project
Fall 2021
Mondays
8:35 am – 11:25 pm
Nicol Building 4050 – hybrid
David McKie
Office hours: By appointment
Phone 613-290-7380
Email: @davidmckiec@gmail
David, Fred Vallance-Jones, Rob Cribb and Dean Jobb are co-authors of
Digging Deeper Third Edition
David McKie, Jim Bronskill
Your Right To Know
COURSE DESCRIPTION
This course will give students the skills:
- to identify issues for investigation and in-depth research within a defined topic;
- to conduct that research;
- to find stories in the data and information;
- to discover information and data, assemble and present the data in an engaging and informative format, including online graphics packages;
- to conduct interviews and follow-up research;
- to write and build online stories using multiple media formats, choosing and using the best format for each element in each story;
- to produce finished packages of information on the selected subjects.
The course, to be delivered as a hybrid model, will teach you how to take a deep dive into an investigative project, from pitch to final project and potential follow-up.
You will have the option of working as part of a national investigative project under the leadership of the Institute for Investigative Journalism at Concordia University in Montreal, or the Investigative Journalism Bureau at the University of Toronto. Details about the partnership for the latest project will be explained during the first class.
For those who would rather pursue a more independent path, you will have the option to stick to the same themes of the institute and bureau investigations, which would still allow you to tap into the research of other students across the country.
And for those who want to do something entirely different, you will have the option to explore ideas with the guidance of the group and instructor. Pitches must be accepted BEFORE work can begin. A more independent path will allow you to pursue a story you’ve always wanted to explore but never had the time. This course is also designed to give you that option, too.
The aim is publishing on a time table to be determined based on factors such as newsworthiness. and the schedules of the publications in question. The National Observer and/or Capital Current will be possible venues for your work.
The course will operate like a project, with each group pitching its ideas on how to approach the issue, doing the research, deciding on story elements and producing the finished package. As part of that process, each group will submit regular progress reports to be reviewed with the instructor to ensure you stay on target to produce the most up-to-date drafts at the end of the term.
REQUIRED TEXTS AND READING
Optional: Your Right To Privacy: Minimize Your Digital Footprint
Canadian Press Style Guide: An Overview
ASSIGNMENTS
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. 27 | |
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 4 | |
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 18 | |
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. 13 | |
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. |
The specific details for each assignment can be found on the week-by-week section on Brightspace or my WordPress site.
That is also the place to find details about what we are doing in class each week of the term.
COMMUNICATIONS WITH STUDENTS
All communications with the class will be done virtually, the old-fashion way — phone, or email using the gmail address (davidmckiec@gmail.com) located at the top of the syllabus. Email and Google drive are the methods we will use to exchange information about pitches, progress reports and stories.
You must check the syllabus regularly to stay on top of what is happening in the class from week to week, as class plans may change to reflect project developments during the term, or the availability of guest speakers etc.
DEADLINES
The specific deadlines for each assignment are outlined in assignment notes posted within the weekly description of course content and at the top of this syllabus.
All written assignments should be completed in MS Word format in 12-point type, double-spaced. Finished material or links to material should be e-mailed to me by the deadlines noted on the syllabus. Marked assignments will be returned promptly with my comments. Please keep an electronic copy of each finished assignment you submit and also keep copies of the returned, graded assignments.
You are responsible for filing all your assignments on time. It is not acceptable to have others file assignments for you. A missed deadline can mean you failed the assignment.
GRADING
There is no final exam in this course. The final grade for the course will be determined as follows:
Assignment | Percentage |
Group presentation on your topic | 15 |
Group story pitch of your project | 15 |
Individual story work during the term | 20 |
Final package | 15 |
Weekly group project updates from week six | 10 |
Professionalism | 10 |
Group project template for outsiders | 10 |
Final project critique | 5 |
Total | 100 |
The normal journalistic standards will apply to all assignments. Work must be submitted on time with penalties for missing deadlines. Assignments should be clear, concise, engaging and interesting, with special emphasis on originality and innovative ways of telling stories for a general audience. Written stories should comply with Canadian Press style. Style errors in your copy will result in a lower grade.
The grade for professionalism will reflect participation in class discussions, in-class exercises, your work habits and how you present yourself as a journalist.
GRADING DETAILS
For undergraduate students: 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 graduate students: 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.
GRADING CRITERIA
Professionalism matters here, as it will throughout your careers. This is a professional school, so you will be expected to meet professional standards in both assignments and conduct.
Regarding assignments, meeting professional standards means completing them according to the criteria outlined in class and in the course outline, as well as submitting them on time. If you are unclear about the requirements for any assignment, it is your responsibility to ask the instructor for clarification well before the assignment is due.
Assignments will be graded for both their journalistic and production values. Marks for journalistic values will be based on the strength or newsworthiness of the story idea; the difficulties overcome in gathering the necessary research, interviews, photos and other elements critical to the story; the depth of the research, the strength and relevance of the audio clips, photos and other elements to the focus of the report; and the accuracy of all the details. Marks for presentation will be for adherence to the style and format for assignments outlined in class; the organization of the material; the clarity and effectiveness of the storytelling; the creative use of photos, sound, audio interviews and other interactive elements. Where the relative quality of reporting and presentation vary significantly, separate grades will be indicated and the final grade for the assignment will be an average of the two.
Letter grades will be awarded to each assignment within the following range:
An A-range grade will be awarded to excellent work. Generally, that means stories or story packages which are newsworthy, complete, clear, well-written, original, multi-sourced with primary records, use compelling interview clips, photos and other interactive elements and are ready for publication without little or no editing.
A B-range grade will be awarded to solid work. That means stories or story packages which may include good reporting and research, interesting interview quotes/clips, strong photos, appropriate audio material etc. but may be lacking in one or more of the elements — especially primary records — required for A-range work listed above.
Grades of C or D will be awarded to sub-standard work — stories that are missing several of the elements listed above.
An F may be given to stories that are late; contain significant errors of fact; misspell the name of a person or a place; fail to meet the requirements of the assignment; or seriously violate the School’s Ethics and Professional Standards.
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. 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.
- Do not interview relatives, friends or acquaintances unless you have permission from the instructor.
For undergraduate students: 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. 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.
For graduate students: General Regulations, Section 19, of the Graduate Calendar http://calendar.carleton.ca/grad/gradregulations/. If an academic offence is suspected, it will be referred to the Office of the Dean of the Faculty of Graduate and Postdoctoral Affairs.
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.
- 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.
- 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.
- 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.
COURSE POLICIES
Attendance: Attendance is mandatory. You must attend at least 9 (nine) classes in order to pass the course. If you miss more than three classes, (not including an apprenticeship) it’s an automatic fail. If you’re absent for medical reasons, you must provide the appropriate medical documentation.
You are expected to arrive promptly, not five or 10 minutes late, and not to leave class for extended breaks or to take calls. When you’re late or away, you miss material that has to be repeated. If you have a valid reason for missing a class, advise me before by e-mail, not through a friend or classmate, just as you would an employer.
Academic Advice: For undergraduate students: 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 joan.thompson@carleton.ca or Undergraduate Supervisor Randy Boswell at randy.boswell@carleton.ca
For graduate students: 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 Jana Lynde-Smith at JenaLyndesmith@cunet.carleton.ca or Graduate Supervisor Kanina Holmes at http://KaninaHolmes@cunet.carleton.ca
Apprenticeships – It’s possible you will have an apprenticeship this term. BJ3/MJ1 students may miss no more than one week of journalism courses (and in-class assignments) per academic year while on an apprenticeship. BJ4/MJ2 students may miss no more than two weeks. Please consult with me before you schedule a placement.
Deadlines – As a journalist you can’t miss them. As a journalism student, you’re not allowed to, either: a missed deadline means you fail the assignment. Exemptions due to personal illness, family tragedy or other exceptional circumstances must be arranged ahead of time whenever possible and be supported by documentation.
Electronics – Phones, tablets, laptops—please keep them muted, closed and out of sight while class is in session. Staying focused on what’s going on in the classroom will help you learn—but don’t just take my word for it. During our virtual meetings, the temptation may be greater to tune out. Please resist the temptation to do so. Read this: http://journals.sagepub.com/doi/10.1177/1469787417721382
You’ll have breaks during our class time to step away from your computer.
Intellectual property – Classroom teaching and learning activities, including lectures, discussions, presentations, etc., by both instructors and students, are copy protected and remain the intellectual property of their respective author(s). All course materials, including PowerPoint presentations, video tutorials, outlines, and other materials, are also protected by copyright and remain the intellectual property of their respective author(s). Students registered in the course may take notes and make copies of course materials for their own educational use only. Students are not permitted to reproduce or distribute lecture notes and course materials publicly for commercial or non-commercial purposes without express written consent from the copyright holder(s).
REQUESTS FOR ACADEMIC ACCOMMODATION
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 https://carleton.ca/equity/accommodation/pregnancy-accommodation-form/
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 https://carleton.ca/equity/accommodation/religious-observances/
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 (PMC) at 613-520-6608 or pmc@carleton.ca for a formal evaluation or contact your PMC coordinator to send your instructor your Letter of Accommodation at the beginning of the term. You must also contact the PMC no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation from PMC, meet with your instructor as soon as possible to ensure accommodation arrangements are made. For more: https://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, and is 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: https://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 https://students.carleton.ca/course-outline/
Who I am:
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. As you can see above, two of the books will be used for this course.
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.
A DISCLAIMER
Every effort will be made to adhere to the weekly schedule outlined on the course page in CU Learn and my WordPress site. However, as this course is part of a collaboration among journalism programs at several universities, there may be juggling or changes to the weekly schedule as the year progresses to reflect the need for common work at specific points during the term.
Investigative Journalism Examples
Award Winners
Canadian Association data journalism award and overall award winner:
Bias Behind Bars
https://www.theglobeandmail.com/canada/article-investigation-racial-bias-in-canadian-prison-risk-assessments/
2020 Philip Meyer Award Winners
https://www.ire.org/ire-announces-winners-of-2020-philip-meyer-journalism-award/
COVID-19 related investigations
https://www.cbc.ca/news/topic/Tag/The%20Big%20Spend
How Ontario taxpayers likely lost almost $10 million on COVID-19 tests they’ll never see
https://www.thestar.com/business/2021/07/15/how-ontario-taxpayers-likely-lost-almost-10-million-on-covid-19-tests-theyll-never-see.html
Several of Doug Ford’s key pandemic decisions were swayed by business interests, Star analysis suggests
https://www.thestar.com/business/2021/07/15/several-of-doug-fords-key-pandemic-decisions-were-swayed-by-business-interests-star-analysis-suggests.html
https://bit.ly/3ky52F2
Chrystia Freeland defends wage subsidy as opposition accuses Liberals of ‘showering their rich Bay Street friends’
https://www.theglobeandmail.com/politics/article-chrystia-freeland-defends-wage-subsidy-as-opposition-accuses-liberals/
Flexible reporting standards mean investors know little about when companies used emergency wage subsidies
https://www.theglobeandmail.com/business/article-when-companies-quietly-use-cews-investors-lose/
Wealthy hedge funds, money managers received Canada Emergency Wage Subsidy
https://www.theglobeandmail.com/business/article-wealthy-hedge-funds-money-managers-received-canada-emergency-wage/
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/
Maggots, Rape and Yet Five Stars: How U.S. Ratings of Nursing Homes Mislead the Public
https://www.nytimes.com/2021/03/13/business/nursing-homes-ratings-medicare-covid.html?searchResultPosition=1
Ont. nursing homes have had 22 years to do safety upgrades. COVID-19 reveals deadly cost of delay
https://www.cbc.ca/news/health/covid-19-coronavirus-long-term-care-homes-ontario-1.5604009
Lockdown Delays Cost at Least 36,000 Lives, Data Show
https://www.nytimes.com/2020/05/20/us/coronavirus-distancing-deaths.html?campaign_id=60&emc=edit_na_20200520&instance_id=0&nl=breaking-news&ref=cta®i_id=29021587&segment_id=28630&user_id=6de68069fe244be82427d0bfd0d2af8e
General investigations
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
Week one – September 13
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:
Class recording
https://www.youtube.com/watch?v=3nawY81FykM
J-Source newsletter sign-up
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
Toronto Star/National Observer: Generation Distress
https://ijb.utoronto.ca/projects/generation-distress/
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
List of access to information and privacy coordinators by institution
https://www.tbs-sct.gc.ca/ap/atip-aiprp/coord-eng.asp
Government Electronic Directory Services (GEDS)
https://geds-sage.gc.ca/en/GEDS?pgid=002
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
Alberta
http://www.servicealberta.ca/foip/
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
New Brunswick
https://www2.gnb.ca/content/gnb/en/departments/finance/office_of_the_chief_information_officer/content/rti.html
Newfoundland and Labrador
Main: http://www.atipp.gov.nl.ca/info/accessrequestform.html
Completed requests: http://atipp-search.gov.nl.ca/
Northwest Territories
https://www.justice.gov.nt.ca/en/access-to-information-held-by-public-bodies/
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
The Right to Know Coalition of Nova Scotia
http://www.nsrighttoknow.ca/
Nunavut
http://www.gov.nu.ca/eia/information/how-place-atipp-request
Ontario
https://www.ontario.ca/page/how-make-freedom-information-request
Prince Edward Island
https://www.princeedwardisland.ca/en/information/justice-and-public-safety/freedom-information-and-protection-privacy-foipp
Quebec
Main: http://www.cai.gouv.qc.ca/english/
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
For next week: Continue filing informal federal and provincial requests for records. File at least ten; Set up Google Alerts; Set up a Tweetdeck.
Assigned reading: Chapters 1-4, 10 of Digging Deeper
Week two – Sept 20
Class recording
https://www.youtube.com/watch?v=izKHMeWc9bU
What we will cover:
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. 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.
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.
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 co-ordinator 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
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
Completed Access to Information Requests
https://open.canada.ca/en/search/ati?_ga=2.69692565.406018153.1536604353-1818651053.1522773341
Question Period Notes
https://search.open.canada.ca/en/qp/
Search Briefing Note Titles and Numbers
https://search.open.canada.ca/en/bn/
Make an access to information or personal information request
https://www.canada.ca/en/treasury-board-secretariat/services/access-information-privacy/access-information/request-information.html
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 sure your access-to-information person begins filing requests. Members charged with other tasks should also be doing their jobs.
An initial group presentation about your topic due next class on Sept 27. This work will evolve into a formal presentation that will be due Oct. 18
Each group will conduct initial public records (covered in Digging Deeper) research to find out everything they can about their 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 – each group should prepare a presentation on all this for next week’s class?
-
Week three – Sept 27
Class recording
https://www.youtube.com/watch?v=KGvF9xXdkb0
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 be 20 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 4
Class recording
https://www.youtube.com/watch?v=09z0-a6XYTQ
What you will learn:
Hansard and other public record searches;
Discussion of the second pitch due on Oct. 18.
Creating annotations in DocumentCloud
Links
While Canada sent hundreds of millions in aid to Jordan, its king grew his collection of luxury homes
https://www.thestar.com/news/investigations/2021/10/03/king-of-jordan-homes-tax-haven-canada-accountant.html
How the Catholic Church was freed from obligation to residential school survivors
https://www.theglobeandmail.com/canada/article-how-the-church-was-freed-from-obligation-to-school-survivors/
The Catholic Church in Canada is worth billions, a Globe investigation shows. Why are its reparations for residential schools so small?https://www.theglobeandmail.com/canada/article-catholic-church-canadian-assets-investigation/
List of Charities – basic search
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en
NFA attack ads target Trudeau as Tories shift gears on gun control
https://www.nationalobserver.com/2021/09/08/news/nfa-attack-ads-target-trudeau-tories-shift-gears-gun-control
Facebook Ad Library
https://www.facebook.com/ads/library/?active_status=all&ad_type=political_and_issue_ads&country=CA&media_type=all
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
Ontario Court Search
https://www.ontario.ca/page/search-court-cases-online
BC Court Search
https://justice.gov.bc.ca/cso/index.do
Brainstorming in class as we learn more about public records
For this class we will continue talking about your pitches from the previous week.
Each group will spend time discussing progress, including assignments to group members and a research plan, including setting up Google alerts for your topic, collecting public records, developing sources and possibly connecting with the larger group at the institute or bureau.
Each group should also catalogue what data it has found that relates to its subject, and how to deal with the gaps in the research. By the end of this class the group should have a better idea of its strategy to identify and collect public records discussed in Digging Deeper, including reports, audits and databases, and a system for continuing to file federal, provincial and municipal formal and informal access-to-information requests. This strategy must be part of your Oct 18 presentation.
IMPORTANT NOTE — After today’s class we will not meet again until after Thanksgiving. So, each group should indicate what individual members of your group plan to do in the following week.
Thanksgiving
Week six – Oct 18
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 seven – Oct 25
Reading week
Week eight- Nov 1
Class recording
https://www.youtube.com/watch?v=Xjz-xwvuyTY
What we will cover
The essential elements of a good interview;
Learning about different kinds of interviews (background, on-the-record);
How to conduct the accountability interview.
Links:
Briefing Book for the Minister of Public Safety Canada
https://www.publicsafety.gc.ca/cnt/trnsprnc/brfng-mtrls/trnstn-bndrs/20191120/index-en.aspx
Theses Canada
https://www.bac-lac.gc.ca/eng/services/theses/Pages/theses-canada.aspx
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: Watch the tutorial for downloading Ontario political financing data.
Week nine – Nov 8
Class recording
https://www.youtube.com/watch?v=8v0TbLSrc_A
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 15
Class recording
https://www.youtube.com/watch?v=GhORR0H1jNI
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
When it comes to CEWS, it’s your money – but none of your business
https://www.theglobeandmail.com/investing/personal-finance/taxes/article-when-it-comes-to-cews-its-your-money-but-none-of-your-business/
When it comes to CEWS, it’s your money – but none of your business
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 22
Making sense of records received through access to information;
Decoding records.
Class recording
https://www.youtube.com/watch?v=WG5pcD3G5xE
Links:
How the U.S. Lost Ground to China in the Contest for Clean Energy
https://www.nytimes.com/2021/11/21/world/us-china-energy.html
‘Things are not going well’: City knew of reliability issues before accepting LRT system
https://www.cbc.ca/news/canada/ottawa/lrt-reliability-issue-testing-john-manconi-1.6249830
Inside Saint John’s response to a ‘devastating’ cyberattack
https://www.cbc.ca/news/canada/new-brunswick/saint-john-cyberattack-records-1.6252873
Week twelve – Nov 29
Class recording
https://www.youtube.com/watch?v=YpN25qKtQdA
What you will learn:
Bankruptcy searches
Working with data
Links:
Over 60 per cent of B.C. opposes NDP efforts to charge for information: Pollhttps://vancouversun.com/news/politics/as-requests-increase-govt-blocks-access-to-info?r
Documents reveal Ford government opted not to pursue $1-billion penalty from 407 Express Toll Route
https://www.thestar.com/business/2021/11/26/ford-brokers-secret-deal-with-407-toll-road-to-forgive-potential-1-billion-penalty.html
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/
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
Week thirteen – Dec 6
Class recording
https://www.youtube.com/watch?v=__7TMImZa_M
What you will learn:
Auditors general reports;
A continuation of data work, examining Corrections Canada offender profiles
More on access to information;
Filing complaints.
Links:
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/
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/
He Says He’s No Murderer. That’s Why He’s Still in Prison
https://www.nytimes.com/2021/12/02/nyregion/joseph-gordon-parole-murder.html
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
Summary of request for medical device records
https://open.canada.ca/en/search/ati/reference/0849a15c91060fc04a835730092db579
Medical devices complaint decision letter_SC – HC – CR – FR – 3218-01553 – A-2018-000166.pdf
Problems with implantable medical devices
https://www.documentcloud.org/documents/21137709-david-mckie-june-14-2021-delayed-release-of-records-re-problems-with-implantable-devices_a-2018-0001666_vn
Information Commissioner of Canada
https://www.oic-ci.gc.ca/en
Information and Privacy Commissioner of Ontario
https://www.ipc.on.ca/
Week fourteen – Dec 13
Class recording
https://www.youtube.com/watch?v=GSgArbrpYi0
What we will cover:
Finish discussion about filing access-to-information complaints;
Story pitches from all three groups;
Course wrap-up;
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
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
Investigative books
Chasing the Truth: A Young Journalist’s Guide to Investigative Reporting
Backlash: The Undeclared War Against American Women Paperback – Aug. 15 2006