Instructor Information
Instructor:
David McKie
Email Address:
dmckie@torontomu.ca
davidmckiec@gmail.com
Phone Number:
613-290-7380
Course TA
Alina Snisarenko
Email address:
Alina.snisarenko@ryerson.ca
Phone Number:
647-867-2001
Location: Rogers Communication Centre, 213 Journalism – Lab
Dates: Sept 8, 2023 to Dec 1, 2023
Day and time: Fridays 10:00 AM — 13:00 PM
Delivery Mode: In-person and virtual
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 the National Observer’s deputy managing editor.
I teach at the schools of journalism at Carleton University, the University of King’s College, and Toronto Metropolitan 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’m a judge for the National Institute for Computer-Assisted Reporting’s Philip Meyer Journalism Award, Google’s Data-Driven Reporting Project and the Investintech – Canadian Association of Journalist Data Journalism Scholarship.
I have a Bachelor of Journalism degree and a Master of Journalism degree from Carleton.
You can find more information about me on my online cv.
Course Overview
Course Description
Research is the keystone of good journalism. Without it, we may be doing little more than passing on rumours, relaying so-called “fake news” or regurgitating public relations handouts. If you don’t check your information, how do you know what you’re telling people is even close tothe truth? Concerns about artificial intelligence’s impact on the realiability of news makes it even more important for journalists to tell stories based on reliable and verifable information. In short, check it out yourself by going to the original source. This exhortation will become our guiding principle.
This course will focus on learning the tools of good research that are essential to being acompetent journalist. Students will learn how to start mastering the ability to dig beneath the surface of a story. The course will encompass the craft of the “paper chase,” cultivating and using sources to full advantage, how to get the most out of your online research and how to use an interview not just to glean quotes, but to gather information. Detailed attention will be given to the systematic use of electronic databases; specialized techniques such mining open-data portals and reading financial statements to follow money; and how to use social media to your advantage: in short, how to approach a research challenge from multiple directions.
The course will also place an emphasis on data journalism. The amount of information flow travelling online means today’s journalists require a specialized skill set to find, sort, retrieve and analyze massive amounts of data. Beyond just finding data, we’ll also look at the importance of finding the story that the data tells — a critical and often overlooked component.
At the same time, the course will ask students to examine not just HOW to conduct research, but WHY you are doing it. The fully aware journalist investigates within a set of well-considered moral and ethical guidelines. We need to ask the questions, “What will the impact of my research be, and what lengths can I and should I go to get that information?”
Learning Outcomes
- Learn the rudimentary tools of research that you’ll need as a working journalist;
- Be introduced to the basic tools of data journalism;
- Appreciate and understand the context in which these skills should be applied;
- Obtain a thorough grounding in journalistic research methods;
- Acquire skills needed to make sense of the information gathered;
- How to evaluate multimedia elements to enhance your storytelling, including data-visualizations, and analyzing datasets;
- How to file formal and informal federal access-to-information and provincial freedom-of-information requests.
Teaching Methods
- In-class and virtual Lectures;
- In-class and virtual activities and discussion;
- One-on-one coaching sessions with yours truly and our amazing teaching assistant Alina Snisarenko;
- Because I’m based in Ottawa, classes will be in-person, and virtual via Zoom. (Zoom accessed via your university Zoom account). We will be in-person once a month with the first and last classes being face-to-face;
- I’ll also be creating video tutorials to help with some of the technial aspects. And because all our classes will be recorded on Zoom and then posted on our syllabus for your eyes only, you’ll also be able to use specific portions as instructional videos;
- Course documents will also be posted on D2L Brightspace, the university’s learning platform, as will this syllabus.
Required Course Textbook(s) and Materials
- Digging Deeper: A Canadian Reporter’s Research Guide, 3rd ed., Robert Cribb, et al.,OUP, 2011;
- The Data Journalist: Getting The Story, Fred Vallance-Jones and David McKie, OUP, 2017;
- If you’re having trouble ordering either book, you can use this link to order electronic copies from the Careton bookstore; Or you can use this link for the TMU bookstore, which also has hard copies of Digging Deeper and is ordering hard copies of The Data Journalist.
- The Data Journalist: Getting the Story eBook by Fred Vallance-Jones Kobo Edition | www.chapters.indigo.ca
- A Digging Deeper link passed along by Carly.
- Canadian Press Stylebook and CP Caps and Spelling. Available to you online while you are a student here at http://stylebooks.thecanadianpress.com/?url=/online/ Having a hard copy can be useful but the online version is searchable.
Optional
Marking Scheme
For more information about exams, please see Toronto Metropolitan University’s Senate Policy on Examinations No. 135. For more information about grade appeals and reassessments please see relevant Senate Policies.
| ASSIGNMENT | DUE | WORTH (PERCENTAGE OF TOTAL) |
| Access-to-information assignmnent | Thurs. Sept 21 at 11:59: p.m. Submit in Word or shared as a Google doc. | 10% |
| Data Visualization | Thurs Nov 2 at 20:00 Upload to WordPress site. | 15% |
| Assessment of a filing from a publicly traded company | Wed. Nov 15. at 10 a.m. Submit in DocumentCloud. | 20% |
| Assessment of Facebook’s ad library | Tues, Dec 4 at 17:00. | 20% |
| Three quizzes based on readings and class work. | Will be done and marked in class. Grades will be emailed. | 15% |
| Participation | See details below. | 10% |
| Professionalism | See details below. | 10% |
| GRADING RUBRICS | Excellent (A- to A+) | Good (B- to B+) | Below expections (C+ and below) |
| Access-to-information assignmnent | Has conducted the legwork necessary to file well-researched, properly worded requests and has shown clear evidence of tracking the progress of the requests. | Has conducted the legwork necessary to file moderately-researched and worded requests between and has shown some evidence of tracking the progress of the requests. | Has filed poorly researched and worded requests and has shown no evidence of tracking the progress of the requests and sent the requests to the wrong institutions. |
| Data Visualization | Has created a visualization using data from Statistics Canada with a title, legend, easily-understood symbolization, source citation and paragraph-length explanation about what the audience is seeing. | Has created a visualization using data from Statistics Canada with a title, legend, easily-understood symbolization, no source citation and no paragraph-length explanation about what the audience is seeing, or an explanation lacking in adequate detail to allow the reader to understand the visualization. | Has created a visualization using data from Statistics Canada with no title, no legend, poorly-understood symbolization, no source citation and no paragraph-length explanation about what the audience is seeing. |
| Assessment of a filing from a publicly traded company | Has used five annotations to explain the significance and newsworthiness of the information being cited. The pargraph-length explanations are well-written and grammatically correct. | Has used five annotations to explain the significance and newsworthiness of the information being cited. The pargraph-length explanations are lacking significant detail to put the information in context. | Has used fewer than five annotations to explain the significance and newsworthiness of the information being cited. The pargraph-length explanations are poorly written and contain grammatical errors. |
| Facebook ad library assignment | The story pitch is solid and based on extensive research. | The story pitch has potential, but still need more research. | The pitch is weak, based on insufficient research. |
| Three quizzes based on readings and class work. | Have answered all the questions correctly. | Has answered less then three-quarters of the questions correctly. | Has answered less than half of the questions correctly. |
ASSIGNMENT Q&As
1. Access-to-information assignment
An exercise involving preparation and submission of freedom-of-information requests to all levels of government, due Thurs. Sept 21 at 11:59: p.m.
You will file ONE formal request to each level of government: federal, provincial and municipal.
You will also file FIVE requests for previously released records from the federal government.
Assignment checklist
- Copies of one request to EACH of the three levels of government (municipal, provincial, federal);
- Copies of correspondence received/sent by you during the course of each of the above-noted requests;
- Proof of the five informal requests for previously released records from the federal government (e.g. an emailed acknowledgement);
- All of the above will be pasted and numbered in ONE emailed Word document. Here’s an example.
Access-to-information assignment questions and answers
Q: How do I submit my assignment?
A: Information related to the three formal requests and five informal requests must be pasted into ONE Word document which will be emailed as an attachment. Number each request.
Q: Do all of my requests have to be on the same topic?
A: No. Request whatever records you might find useful or of interest.
Q: Do you want every piece of correspondence related to formal and informal requests?
A: I want to see all relevant correspondence to help me understand how things proceeded and any steps you took to monitor the requests.
Q: So, I don’t necessarily have to analyze previously released federal records if I receive them before the end of the term?
A: That’s correct. Although you must request some previously released federal records such as documents or data, you may not actually receive the material in time for analysis.
As we discussed, you should have received some correspondence in response to your original requests and your previously released federal one. Here’s a closer look:
Original requests (municipal, provincial/territorial, federal):
(*) An acknowledgment letter or email should have arrived within a week or 10 days.
(*) Many of you will also receive time-extension or fee-assessment letters for your formal requests.
(*) If the time extension is more than 90 days or you have been assessed fees beyond the application charge, it is best to follow up with the agency to see if you can still narrow the request. It will help to recall our in-class conversation about narrowing a request by either focusing the time-frame or the type of records you seek.
(*) Sometimes it is not possible to narrow a request or you may simply choose not to because doing so would unduly limit the desired response.
(*) However, there is no need to pay additional fees for the purposes of the assignment.
Previously released federal request:
(*) For this one, if you used the Completed Access to Information Requests site, you may simply have received an automated reply acknowledging your request. But you might have also received a follow-up acknowledgment letter from the agency or even a letter with a full response, including records. For the purposes of the assignment all I need to see is the latest reply or response letter, whatever it might be (not the actual records).
Overall, I will be looking to see that you followed up each of your four requests as necessary and managed their progress prudently. I will be judging to make sure that you did your homework and sent the request to the proper institution.
2. Data visualization assignment
A digital visualization that tells a story based on analysis of data, due Thurs. Nov 2, 20:00
What’s to be submitted?
- ONE visualization dashboard created in Tableau uploaded to the class Instagram account Alina has created. The dashboard must be accompanied by a 100-word explanation that explains the news value and what folks are seeing on the dashboard.
- In your explanation used to set up the dashboard, there must be links to AT LEAST two different public records uploaded to DocumentCloud. The DocumentCloud link(s) MUST take readers to the appropriate annotations in the public record.
- The Excel workbook that contains the data used for your visualization in Tableau and the Tableau workbook submitted TOGETHER in a zipped folder.
Data visualization questions and answers
Q: Can I choose any dataset?
A: Yes. Ideally, it should be newsworthy.
Q: Can I choose a dataset we have used as an example in class?
A: Yes, but you would have to come up with different examples than the ones we used in class. For instance, you can use Statistics Canada’s Labour Force data that tracks employment. However, you MUST use different numbers from the ones we demonstrated in class.
Q: Do I have to run the dataset by you?
A: Not if it’s from Statistics Canada or another dataset we have examined in class. If it’s from another federal, provincial or municipal open-data portal, you’re welcome to check with me. However, doing so is optional. Remember, you’ll be judged on the newsworthiness of your visualization and the context you’ve provided. A reader should never wonder why you have created a visualization .
Q: Can the visualization be a jpg or png file?
A: Yes. It will have to be a jpg when uploaded to Instagram. However, because your dashboard will also live on your online Tableau Public, you can link to it.
Q: Do I have to create a pivot table in Excel before importing the data into Tableau?
A: Yes, this way you can use the pivot table as a reference point, just like we did in class.
Q: Will I lose marks for neglecting to ensure my dashboard has a title, and source?
A: Yes. Half a grade
Q: Do I have to use Tableau?
A: Yes.
Q: Does it have to be a dashboard?
A: Yes.
Q: Will I lose marks for neglecting to upload and annotate my public documents in my explanation to DocumentCloud?
A: Yes, half a grade.
Q: Will I lose marks for not referencing any public records in my explanation.
A: Yes, half a grade.
Q: How should I use public records?
A: Just like you would for any journalistic endeavour, as background information to provide context. For instance, if you cite higher unemployment number for males compared to females in a certain jurisdiction, use a public record such as a government report or study by an expert that explains WHY this is the case. You are not to guess, or provide an unsupported opinion. Or if you are creating a dashboard for inflation, you can site a Bank of Canada report that partially blames high prices on the lack of competition in the grocery store sector. The federal competition watchdog also produced a report on this. If you are using the crime statistics, there are many reports — produced by Statistics Canada itself — that provide excellent context for the numbers. As an additional resource, you might want to set up a Google alert(s) on your topic to see what pops into your inbox over the next few days. Media reports cite relevant material such as studies you could use for context.
Q: Can a public record be an article or news report?
A: NO! Despite what I said about the alert, which should ONLY be used as a tipsheet. The focus in this course is the use of the primary records described in Digging Deeper’s Chapter 4. While secondary sources such as media reports are useful as tip sheets for sources of information, they CANNOT be the primary reference, in large part because the media frequently contain inaccuracies that need to be corrected. So if a story mentions a statistic, fact or government program, be sure to go to the original source to verify the information being cited.
Q: Do I have to interview anyone?
A: No. The point of this assignment is to see how adept you are at choosing information from a publicly available dataset to display, and then consulting public records to add context.
Q. Can you show me an example?
A. Yes, check out the Tableau dashboard examples on this page on my website and the examples last year’s class posted to our Instagram page.
3. Assessment of a filing from a publicly traded company assignment
An analysis of a financial records of a publicly traded company, due Wed. Nov 15. at 10 a.m.
What is to be submitted?
The most recent financial statement of a publicly traded company uploaded to DocumentCloud and annotated. This is meant to be a critical look at the company’s finances and should not be mistaken for a company news release.
1. All I need is emailed URLs for the financial filings in DocumentCloud. Be sure to activate the “Collaborator” setting, which allows me to see them;
2. You’ll be required to provide FIVE separate annotations in the number of documents of your choosing.
3. You’ll be required to submit the most recent interim financial statement and the accompanying management’s discussion and analysis. If it’s an annual report, the management, discussion and analsyis may be in the same document. As explained in Digging Deeper’s business chapter, the analysis provides context for the numbers you’ll be required to annotated. At least two of the annotations must be key numbers such as profit and revenue. The other annotations can be of newsworthy statements in the management’s, discussion and analysis section.
3. Each annotation MUST have a title; and a short paragraph that explains the significance of the number or observation. For instance, if the company lost money, explain WHY. If the company concedes that it’s facing a rocky future in its management, discussion and analysis section, explain why this is potentially newsworthy. In addition to context from the management discussion and analysis, your explanation must also draw on at least ONE other additional public record for context with the accompanying URL. For instance, this is the annotation I created.
Frequently asked questions?
Q: Can it be any company?
A: Yes, as long as it is publicly traded?
Q: Do I have to choose a company that received a federal wage subsidy?
A: Yes. Check this directory.
Q: What financial records must I submit?
A: The two required documents will be the latest financial filing — an interim financial statement, or annual report — and the accompanying management’s, discussion and analysis. If you are referencing an interim statement, the analysis will be contained in a separate document. If it’s an annual report, the analysis may be in the same document.
Q: Can I submit other documents in addition to the two mandatory ones mentioned above?
A: Yes. But the information must be connected to the numbers you choose to highlight. In short, the extra documents must provide additional context.
Q: How can I tell whether it’s publicly traded?
A: If it’s financial statement is public. For instance, you can typically find financial statements on a company’s website under a heading, typically “investor relations.” If it sells stock in Canada, you can also find it using the search engine SEDAR.
Q: Does the company have to be publicly traded?
A: Yes.
Q: Why can’t it be a private company?
A: As explained in Digging Deeper’s business chapter, private companies are not required to make their financial information public. If private companies produce reports, the information is not subjected to the legal transparency obligations that characterize the filings of publicly traded companies.
Q: Do I have to calculate the percent differences between numbers from different quarters?
A: Yes, You can plug the numbers into an Excal workbook, as you can see in this example.
Q: Will I lose marks if I don’t perform these calculations in Excel?
A: No, because these are calculations you’ll have to perform if you discuss percent increases for line items such as revenues, or profits. If your analysis does not require calculations, then that’s fine. The bottom line is I’m looking for CONTEXT for the information you’ve highlighted in your five annotations.
Q: Do I have to upload other financial statements?
A: You have to upload the most recent management, discussion and analysis for context to explain your numbers. You may also want to upload the latest proxy circular to discuss executive compensation, if that detail is relevant to your assessment.
Q: So, how many financial statements do I upload?
A: For your analysis, you could end up uploading many documents, but what you choose to share with me may only be a subset of them. The bottom line is that you will five, separate annotations with a title and discription. For example, you may only choose to share the most recent quarterly or interim financial statement and the management, discussion and analysis. And in your annotation for a table in the financial statement, you may include the calculations you’ve performed in your Excel workbook cited above.
Q: Will I lose marks if the annotations don’t contain any explanation?
A: Yes, a full grade.
Q: So what must I submit?
A: The URLs for your DocumentCloud annations in a Word document, emailed to me.
Assessment of Facebook’s ad library
FACEBOOK AD LIBRARY Q&As
4. Facebook ad library analysis assignment
An exercise involving the analysis of the ads running in the Facebook library from Nov 1, 2023 to Nov 16, 2023.
You will be required to make one formal, 500-word story pitch based on your analysis of the library data that will be provided to you in Excel format. Due Dec 5, 17:00
Assignment checklist
- One Excel spreadsheet with the original table and a second sheet with the pivot table(s) you will use to drive your analysis;
- One Word document with the 500-word pitch that will contain the following: A focus statement; a paragraph-length explanation of WHY the ad or series of ads you’ve chosen is newsworthy, using a public record (a poll; news release, study, Question Period briefing note, etc.) as proof. For instance, the federal Liberal Party’s continued purchase of Facebook ads after a major fight with Meta and Google made news because of the irony of the situation. That is, a governing federal political party using the very same social media platform that’s threatening to stop running news to thwart the impending legislation.
- Treatment. Who would you interview and why? Sticking with the Liberal Party example, it would be unreasonable to suggest the prime minister, or perhaps even the new Heritage minister, especially if you’re working for a small news outlet. In this instance, it might be more reasonable to suggest a Liberal Party spokesperson or a political scientist who has been following and writing about this issue.
Facebook ad library analysis questions and answers
Q: Can I choose any advertiser?
A: Yes, as long as the person or institution is newsworthy. The case of the Liberal Party is clear, given the political controversy. But it might not be as obvious for another advertiser such as an institution, think tank, non-governmental organization or lobbyist. Just like any pitch, you have to make the case and explain why the individual or institution’s use of the ad library is newsworthy.
Q: How detailed should the focus statement be?
A: Ideally, one or two sentences. If it takes you longer to explain the pitch, your story needs work.
Q: Can you provide an example?
A: Sticking with the Liberal Party example: The Liberal Party of Canada is still advertising on Facebook despite Meta’s threat to thwart a new law that would make the company pay for news content.
Q: Part of the pitch is a paragraph-length explanation of WHY it’s a story. What criteria will be used to judge the explanation?
A: Newsworthiness and the research that went into it. The explanation can’t be aspiration. That is, you hope to do this or that. The explanation must be based on fact – just like the previous assignments – and at least one public record in addition to the ad in the library. In the Liberal Party example, a public record could be a Facebook ad, or a news release justifying its decision, or an institution’s criticism of the decision.
Q: The final part of the pitch is treatment or voice. How much detail will be required and how will the quality of that choice be judged?
A: Again, research, research, research. It just can’t be anyone, or someone you hope to interview. That won’t fly if you’re chasing for a daily CBC television or radio show, or writing a same-day story for a digital news outlet. It has to be someone who is relevant: a key player; an expert with knowledge of the subject you are pitching. The choice will also be based on the research you’ve conducted: the person’s social media posts; editorials or other forms of public criticism.
Q: But wait, didn’t you say we should avoid using media reports as references?
A: Yes, but if this is a critic expressing an opinion in an editorial, social media post, etc., then there is little chance of the individual being misquoted.
Q: Is 500 words a hard limit?
A: Yes. If you’ve done your homework, basing your assessment on the kinds of records discussed in this Q&A and in this course, then it shouldn’t take very long to convince an editor or a producer to let you do the story. Editors and producers are busy people. They don’t have time to read lengthy, meandering pitches. They need to be convinced within the first two or three sentences the pitch is worth pursuing.
Q: Do I have to do extensive analysis of the Facebook Ad Library?
A: No more than you’ve had to analyze a Statistics Canada table or financial statement before figuring out a story. Find an advertiser, do some research and pitch. Having said that, you may have to whittle your choice down to a few advertisers before settling on the right one. This is no different than the selection process used for previous assignments.
Three quizzes based on readings and class work
What will be required?
At the end of each of the course’s three discrete sections (each lasting four weeks), there will be a short quiz (cited on the syllabus), which should take no longer than 20 minutes to complete. The quizzes will be out of ten with two bonus questions and will be done as a group, in class. We will grade them together. You’ll email your result.
Q: Why are quizzes necessary?
A: To ensure you’ve done the readings and have been following along in class.
Q: Will I have to study for them?
A: Not if you’ve done the readings and participated in class.
Q: Will I be able to make up the quizzes if I miss class?
A: Yes, but only if I received notice BEFORE the class that you’ll be absent. If you simply fail to show up for class on that particular day with no warning, you will be forfeiting five marks.
Q: Will I get extra time to complete the quiz if I’m late?
A: Only if you’ve given me a heads-up before class you’ll be late. Otherwise, you’ll have to make do with the time you have.
Grading information
This is what the marks mean:
A+ (9-10)
Excellent work that shows exemplary initiative and only requires minor editing. Spelling, grammar and CP style rules are observed.
A (8.5)
Excellent work, with only minor editing. Spelling and grammar rules are observed, as is CP style. All it may be missing is a better source, a sharper example, or an extra detail.
A– (8)
Still very good work. There are few unanswered questions and needs only minor editing and attention to style. Spelling, grammar and style rules are observed.
B+ (7.7–7.9)
No major reporting problems but structural problems that may require further attention by you or moderate editing – stronger back-up for your lede, a point left unexplained, vague references to clarify, adding transitions, etc.
B (7.5)
The story needs moderate editing to clarify key statements or to add background. Some minor points have been left unexplained. Spelling and grammar rules are observed, as is CP style.
B– (7.0–7.3)
A competent piece of writing, but story shows some minor gaps in logic, or is missing a worthwhile fact or source. Needs moderate to major editing or rewriting. It may need additional reporting.
NOTE: You require a mark of at least B– (70) to pass this course.
D to C+ (5–6.9)
Marginally unacceptable. Work ranges from nearly adequate to seriously flawed, showing inattention to detail or a lack of journalistic fundamentals. It needs extensive editing, rewriting or more reporting to address problems. The story may lack balance, miss the lede or be under sourced. Not publishable without extensive work.
F(0–5)
Inadequate work. The story is confusing, inaccurate, incomplete, or contains a misspelled proper noun or name, a statement that is libelous, or an error in fact.
Classroom Management
Participation and Attendance
You can guarantee a good grade for participation by:
- doing the readings and exercises in advance and coming to class prepared;
- participating regularly in class discussions;
This mark will be assigned on the following basis:
- Infrequent or no participation; comments show little or no familiarity with the weekly readings, video tutorials or other material assigned by the instructor. Four to five (out of 10)
- Occasional participation; comments show general but not detailed knowledge of the readings, video tutorials, etc; comments tend to be expressions of personal opinion not based on the readings. five to eight (out of 10)
- Regular participation; comments show detailed familiarity with readings, video tutorials, etc; comments are based knowledged gleaned from the readings and other assigned material. six to ten (out of 10)
Professionalism
This course will uphold professional standards, which means functioning as if we are in a newsroom.
That means treating your colleagues with respect during discussions and attending class on time. I will ensure that you have “a learning environment that is safe, free from harassment and discrimination…characterized by mutual respect, inclusivity and civility (and)is free from interference and disruption…”, as articulated in the TMU policy.
There will also be regular correspondence between instructor and students. The expectation will be that the correspondence will be acknowledged as promptly as possible, as would be the case in a newsroom.
There is also an expection that you read the information about each assignment carefully to ensure you submit the necessary elements. We will review the assignments in class. However, if you STILL find anything confusing, it is up to you to seek clarification. You’ll be expected to submit all the necessary elements for each assignment.
There will also be technical requirements, mainly downloading software such as Tableau, DocumentCloud, and accessing our WordPress site where you will post your data visualizations. You will have to perform these tasks upon receiving instructions and making sure you are ready for the next class. If you’ve having problems, you’ll be expected to communicate with the instructor or TA, who will offer prompt assistance.
This mark will be assigned on the following basis:
- No acknowledgment of correspondence and failure to follow instructions for assignments and does not install the required software on on time. 2 to 5 (out of 10)
- Occasional acknowledgment of correspondence and some effort to follow instructions for assignments and install the required software on on time. 2 to 6 (out of 10)
- Prompt acknowledgment of correspondence and prompt attention to following instructions for assignments, installing the required software on on time, and asking help when required. 7 to 10 (out of 10)
Class Meetings
A detailed week-by-week schedule accompanies this syllabus. We will spend time discussing journalistic methods, the readings, and writing. Core reporting and writing skills will be introduced in lectures and activities accompanied by supporting materials. I’ll offer in-class critiques of completed work but anonymity will be protected. During the semester you will have a variety of marked assignments.
In most cases you can expect marked assignments to returned within two weeks.
If the instructor must adjust lectures, assignments or schedule, you will be advised in advance, via a group email, or an announcement on D2L. This may include additional readings related to just-breaking events.
Late Assignments
Professional journalists work in an environment of constant deadlines. We’ll do the same. Any assignment handed in after deadline will be marked down one point for all or part of every 24 hours that it is late. For instance, if your mark on the story is 16/20 but you are six hours late, your final mark will be 15/20. Another example: If you get 8/10 on an assignment but hand it in 36 hours late, your final mark will be 6/10.
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’re a B. Journ. student, this form should go to the J-School’s Academic and Outreach Coordinator; MJ students should submit the documentation to MJ 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 — the 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 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 without Accommodation Letters: Exemptions or deferral of an assignment is only/may permitted for a medical or personal emergency or religious observance. Please provide documentation as below:
Religious, Aboriginal, and Spiritual Observance: For accommodations based on medical or 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
Consult the School of Journalism Handbook for Student Reporters for guidance on best practices for ethical reporting on a wide range of issues/in different situations.
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 the University’s Academic Integrity policy which covers plagiarism and other transgressions. It is at:
http://www.torontomu.ca/senate/policies/pol60.pdf
Sources: Unless explicitly permitted by me, you may not use close friends, relatives, bosses or other journalism students as sources. You must tell me if there is any emotional or financial involvement, or any other potential conflict of interest with a source. Every source must be available for fact checking.
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 Toronto Metropolitan University’s Course Management Policy No.166
Student safety while reporting: I know you are all adventurous journalists who want to get the story by going where the story is happening so you can bear witness and gather information. But please always keep your personal safety in mind while reporting. Always leave a situation or interaction in which you feel unsafe or harassed. Avoid going into private residences on your own, and 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. 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
Toronto Metropolitan 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:
If you request to send me an accommodation letter, please contact me as soon as possible so we can discuss any necessary arrangements to assignments or issues related to the course.
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 University online identity at torontomu.ca/accounts in order to regularly access Toronto Metropolitan University’s email, RAMSS, the my.torontomu.ca portal and learning management system, and other systems by which they will receive official university communications.
Announcements relevant to class content/course management will be made via group emails.
Specific Details on IT Requirements
For minimum tech requirements to take this class see: https://www.ryerson.ca/covid-19/students/minimum-technology-requirements-remote-learning/
TMU offers fantastic resources to guide your ongoing independent learning. This is good news particularly for those of you who find yourself on the extreme ends of the spectrum when it comes to technology—whether you’re someone who’s been writing code and editing video since age 10 OR whether you still don’t know how to use the camera on your phone, there are resources you can use to move forward on the tech skills front. You can find those resources at insession.journalism.ryerson.ca (once you click on the link, you should sign in for full access). You can also log into my.ryerson.ca and click on Apps, then scroll to the bottom of the screen and select LinkedIn Learning. A subscription to this resource ordinarily costs a minimum of $25/month, but it’s free for TMU students. You’ll find video tutorials on a broad range of subjects of interest to J-students, from page layout to Photoshop to photography basics to DSLR video and much, much more.
Student Support and Assistance
If you are experiencing technical or administrative issues with your course, help is available by completing the Ask J-School Now form.
The 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.
- The 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 students; if you need any kind of assistance, PLEASE just ask—ask your instructor, the course lecturer, the student affairs coordinator or any other J-School instructor or staff member.
In addition to the University’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 dialling 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.
Weekly Schedule
Class recording
https://www.youtube.com/watch?v=BwbKyX1IoQ4
In-person
Week 1 – Introduction to access-to-information
08/09/2023
What you will learn
What the Reporting Methods course is all about;
The basics of access to information;
The difference between formal and informal requests;
How to make an informal access-to-information request.
Links
CBC head ‘blindsided’ staff with comments on broadcaster’s future, Poilievre: email
https://site-cbc.radio-canada.ca/documents/impact-and-accountability/ati/misc/2023/A-2023-00005.pdf
Documents Released in Answer to ATI Requests of General Interest
https://cbc.radio-canada.ca/en/impact-and-accountability/access-to-information/documents-released
Nuclear threat from Ukraine war prompts Ottawa to update plans for catastrophe
https://www.nationalnewswatch.com/2023/07/19/nuclear-threat-from-ukraine-war-prompts-ottawa-to-update-plans-for-catastrophe/
https://www.documentcloud.org/documents/23886229-a-2022-00357-release-package#document/p13/a2365370
Question Period Notes
https://search.open.canada.ca/en/qp/
Completed Access to Information Requests
https://open.canada.ca/en/search/ati?_ga=2.69692565.406018153.1536604353-1818651053.1522773341
Search Briefing Note Titles and Numbers
https://search.open.canada.ca/en/bn/
Open Government – Proactive disclosure and access to information
https://open.canada.ca/en
Information About Programs and Information Holdings (formerly Info Source)
https://www.canada.ca/en/treasury-board-secretariat/services/access-information-privacy/access-information/information-about-programs-information-holdings/sources-federal-government-employee-information.html
Secret Canada – The Globe and Mail’s access-to-information search tool
https://www.secretcanada.com/
ACCESS TO INFORMATION
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.canada.ca/en/treasury-board-secretariat/services/access-information-privacy/access-information/information-about-programs-information-holdings.html
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
PROVINCES AND TERRITORIES
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
Edmonton
http://www.edmonton.ca/city_government/city_organization/freedom-of-information-and-privacy.aspx
Fredericton
http://www.fredericton.ca/en/right-to-information-and-protection-of-privacy
Halifax Regional Municipality http://www.halifax.ca/AccessPrivacy/index.php
Completed requests: https://www.halifax.ca/city-hall/accountability-transparency/access-information/completed-requests
Hamilton
http://www.hamilton.ca/CityDepartments/CorporateServices/Clerks/MFIPPA_adn_PHIPA.htm
Moncton
https://www.moncton.ca/my-govt-work/right-information-and-protection-privacy-act
Montreal
http://ville.montreal.qc.ca/portal/page?_pageid=5798,39687582&_dad=portal&_schema=PORTAL
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
Saskatoon
https://www.saskatoon.ca/city-hall/send-comments-concerns-city/freedom-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
COMPLETED ACCESS REQUESTS
Federal
https://open.canada.ca/en/search/ati
British Columbia
http://www2.gov.bc.ca/gov/search?id=4BAD1D13C68243D1960FECBBF7B8B091
Vancouver
http://vancouver.ca/your-government/information-released-through-foi-requests-this-year.aspx
Manitoba
https://www.manitoba.ca/openmb/infomb/departments.html
https://www.manitoba.ca/openmb/infomb/fippa.html
Winnipeg
http://winnipeg.ca/clerks/fippa/AccessToInfo.stm#1
Regina (Note: not all are freedom-of-information responses)
http://open.regina.ca/group/freedom-of-information
Nova Scotia
https://informationaccess.novascotia.ca/
Halifax
https://www.halifax.ca/city-hall/accountability-transparency/access-information/completed-requests
Newfoundland
http://atipp-search.gov.nl.ca/
Yukon
https://open.yukon.ca/data/sites/default/files/20200800-Release.pdf
Readings
Chaper 10 Digging Deeper – Getting Behind Closed Doors: Using the Information Laws, page 237
Additional resources
Dean Beeby’s access-to-information tipsheet.pdf
Example of an Ontario request:
http://www.davidmckie.com/Ontario%20Data%202018%20Request.pdf
Week 2 – Access-to-information part two
Virtual
Class recording
https://www.youtube.com/watch?v=l7gwk3m_7Ls
15/09/2023
What you will learn
More on crafting an access-to-information request;
Making a formal request;
Details of the access-to-information assignment.
Links
Links
National Newswatch
https://www.nationalnewswatch.com/
Open Government – Proactive disclosure and access to information
https://open.canada.ca/en
Secret UFO memo sent to Canadian PM Justin Trudeau over mystery object shot down over Yukon in February
https://www.dailymail.co.uk/news/article-12500215/Secret-UFO-memo-sent-Canadian-PM-Justin-Trudeau-mystery-object-shot-Yukon-February.html
Read ‘Secret’ memo for Trudeau on unidentified object shot down over Yukon
https://www.ctvnews.ca/canada/read-secret-memo-for-trudeau-on-unidentified-object-shot-down-over-yukon-1.6548510
The Civil Aviation Daily Occurrence Reporting System (CADORS)
https://tc.canada.ca/en/aviation/publications/aviation-safety-letter/issue-2-2021/civil-aviation-daily-occurrence-reporting-system-cadors
CADORS main menu
https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/cadors-screaq/m.aspx
Mounties eyeing change to recreational cannabis use policy for members
https://www.firstpost.com/world/secret-memo-about-shooting-down-a-ufo-sent-to-justin-trudeau-in-feb-becomes-public-13106042.html
RCMP cannabis briefing note uploaded to DocumentCloud
https://www.documentcloud.org/documents/23961677-rcmp-aug-28-2023-informal-release-of-briefing-note-on-cannabis-use__a-2023-08643
Ottawa warns LGBTQ travellers they could be hit by U.S. state laws
https://www.cbc.ca/news/politics/global-affairs-lgbt-unitedstates-warning-1.6950833
Travel and your sexual orientation, gender identity, gender expression and sex characteristics
https://travel.gc.ca/travelling/health-safety/lgbt-travel
LGBTQ access-to-information request
http://www.davidmckie.com/LGBTQ travel U.S. travel advisory_A-2023-01693.pdf
Ontario must prepare for growing threat of extreme heat: report
https://www.nationalobserver.com/2023/09/14/news/ontario-must-prepare-growing-threat-extreme-heat-report
One year after taking on new name, Toronto Metropolitan University reflects on change
https://bit.ly/3ZqsWVd
One year after taking on new name, Toronto Metropolitan University reflects on chan – PDF version
http://www.davidmckie.com/TMU reflects on change.pdf
Records on policing Indigenous communities
https://www.documentcloud.org/documents/22416959-national-police-federation-on-serving-indigenous-communities
A new CSIS ad campaign is using Soviet-style imagery to warn Canadians about disinformation
https://www.cbc.ca/news/politics/csis-disinformation-ads-soviet-imagery-1.6955717
Briefing note titles and numbers
https://search.open.canada.ca/briefingt/
Question Period notes
https://search.open.canada.ca/qpnotes/
Question Period note: Labour exploitation in procurement
https://search.open.canada.ca/qpnotes/record/pwgsc-tpsgc,PSPC-2021-QP-00008
A shopping list of key records
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.
Readings
Chapters 1, 2, 3 The Data Journalist
Assignments
Review these Statistics Canada tutorials
Resources
How to use Statistics Canada’s data tables
https://www.statcan.gc.ca/en/sc/video/howto
How to use Statistics Canada’s Canadian International Merchandise (CIMT) web app
https://www.statcan.gc.ca/en/sc/video/CIMT-web-application
Click here to see a complete example of federal, provincial and municipally-based access-to-information requests required for the assignment.
Click here to see an example of a formal federal access-to-information request.
Click here to see an example of a provincial request.
Click here to see an example of a municipaly based request
Dean Beeby’s blog about journalism and transparency
https://www.deanbeeby.ca/blog
Dean Beeby’s access-to-information tipsheet.pdf
Week 3 – Learning about open data
Virtual
22/09/2023
Class recording
https://www.youtube.com/watch?v=AMiD4Zbi6gA
What you will learn
The concept of open data;
How to download and analyse Statistics Canada tables, filtering, sorting and building pivot tables;
How to use the same techniques to analyze data on other open-data sites.
Links
National Newswatch
https://www.nationalnewswatch.com/
Statistics Canada’s data tables
Canada has Indian diplomats’ communications in bombshell murder probe: sources
https://www.cbc.ca/news/politics/sikh-nijjar-india-canada-trudeau-modi-1.6974607
India suspends visa services for Canadian citizens, upending travel plans
https://www.nationalnewswatch.com/2023/09/21/india-suspends-visa-services-in-canada-and-rift-widens-between-countries/
Escalating tensions between India and Canada spark trade worries: experts
https://www.thestar.com/business/escalating-tensions-between-india-and-canada-spark-trade-worries-experts/article_6aea83a1-685d-553b-a29c-022b81768983.html
Escalating tensions between India and Canada spark trade worries: experts – PDF version
http://www.davidmckie.com/Escalating tensions between India and Canada spark trade worries_ experts.pdf
Canadian international merchandise trade, July 2023
https://www150.statcan.gc.ca/n1/daily-quotidien/230906/dq230906a-eng.htm
Trade Data Online
https://ised-isde.canada.ca/site/trade-data-online/en
Canadian International Merchandise Trade Web Application
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2021004-eng.htm
The International Trade Explorer, 2022
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2019005-eng.htm
International merchandise trade for all countries and by Principal Trading Partners, monthly (x 1,000,000)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1210001101
Canadian international merchandise trade by industry for all countries
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210013601
International merchandise trade by province, commodity, and Principal Trading Partners (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210011901
Canadian international merchandise trade by industry for all countries
https://open.canada.ca/data/en/dataset/cf26a8f3-bf96-4fd3-8fa9-e0b4089b5866
How to use Statistics Canada’s Canadian International Merchandise (CIMT) web app
https://www.statcan.gc.ca/en/sc/video/CIMT-web-application
Bank of Canada
https://www.bankofcanada.ca/
Government calls for meeting with CEOs of Canada’s biggest grocery chains to talk food prices
https://www.cbc.ca/news/politics/government-grocery-store-meeting-ottawa-food-prices-1.6967978
Minister says Canada’s largest grocery chains have agreed to ‘work’ on stabilizing food prices
https://www.cbc.ca/news/politics/freeland-champagne-grocery-ceos-meeting-1.6970207
Canada’s inflation rate rises to 4% in August, putting pressure on BoC
https://www.theglobeandmail.com/business/article-inflation-rate-canada-august-2023/
Canada’s inflation rate rises to 4% in August, putting pressure on BoC – PDF version
Canada’s inflation rate increases to 4% in August even as food prices slow
https://bit.ly/3PHKUiS
Canada’s inflation rate jumps to 4 per cent, making the BoC’s next rate decision harder
https://www.ctvnews.ca/business/canada-s-inflation-rate-reaches-4-per-cent-in-august-statcan-1.6567788
Canada’s inflation rate increases to 4% in August even as food prices slow – PDF version
http://www.davidmckie.com/Canada inflation rate increases to 4 per cent in Aug.pdf
Consumer Price Index Data Visualization Tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm
Food inflation has soared to a 41-year high — and people are going hungry
https://www.thestar.com/business/2022/09/20/inflation-expected-to-have-slowed-to-72-per-cent-in-august.html
Food inflation has soared to a 41-year high — and people are going hungry – PDF version
http://www.davidmckie.com/Food inflation soars.pdf
Conservatives may support part of the Liberal government’s affordability plan on GST
https://www.nationalnewswatch.com/2022/09/21/conservatives-may-support-part-of-the-liberal-governments-affordability-plan-2/#.YyyCCXbMJPb
Consumer Price Index
https://www150.statcan.gc.ca/n1/daily-quotidien/220920/dq220920a-eng.htm
Consumer Price Index, monthly, not seasonally adjusted
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1810000401
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Labour force characteristics, monthly, seasonally adjusted and trend-cycle, last 5 months
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410028701
Population estimates, quarterly
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1710000901
Population estimates on July 1st, by age and sex
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501
Resources
Tables downloaded from StatsCan and converted into Excel workbooks
1. International merchandise trade for all countries and by Principal Trading Partners, monthly (x 1,000,000)
http://www.davidmckie.com/Trade_Jan 1, 2022-July 2023_1210001101.xlsx
2. Canadian international merchandise trade by industry for all countries
http://www.davidmckie.com/India_NAICS_Jan 1, 2022-July 2023_1210013601.xlsx
3. International merchandise trade by province, commodity, and Principal Trading Partners (x 1,000)
http://www.davidmckie.com/International trade, NAICS, provinces_Jan 1, 2022-July 2023_1210011901.xlsx
4. Canadian international merchandise trade by industry for all countries
http://www.davidmckie.com/Exports to India_from MySQL.xlsx
How to use the data tables
https://www.statcan.gc.ca/en/sc/video/howto
Downloading Statscan labour force data tutorial
https://www.youtube.com/watch?v=aEanJKFR7Dk
Consumer Price Index frequently asked questions
https://www.documentcloud.org/documents/22672133-consumer-price-index-frequently-asked-questions
Consumer Price Index table analysed in Excel
http://www.davidmckie.com/CPI_Sept 21, 2022_1810000401.xlsx
CPI tutorial for downloading data into Excel and creating pivot tables
https://www.youtube.com/watch?v=qU0c1Cf0LF8
Assignment
Set up a DocumentCloud account
Uploading documents to DocumentCloud tutorial
https://www.youtube.com/watch?v=i_d0zsw6hhQ&feature=youtu.be
Week 4 – Open data part two
In-person
Class recording
https://www.youtube.com/watch?v=ZKWMKZwkHsk
29/09/2023
What you will learn
A continuation of working with datasets from open-data portals;
Links
Politics Briefing: Rota’s exit leads to high-end food donation to low-income Ottawa residents
https://www.theglobeandmail.com/politics/article-politics-briefing-rotas-exit-leads-to-high-end-food-donation-to-low/
Canada urgently needs to release its Holocaust-related records
https://www.theglobeandmail.com/opinion/article-canada-urgently-needs-to-release-its-holocaust-related-records/
Research Guide to Holocaust-related Holdings at Library and Archives Canada
https://library-archives.canada.ca/eng/collection/research-help/politics-government-law/holocaust-research-guide
Province provided emergency funds to Ottawa school boards contingent on consistent messaging
https://www.theglobeandmail.com/canada/article-province-provided-emergency-funds-to-ottawa-school-contingent-on/
Ottawa has spent at least six figures in legal fees to contest information disclosure orders
Alberta rejects requests for data on freedom of information system a second time
https://www.theglobeandmail.com/canada/article-alberta-foi-data-accountability/
Alberta rejects requests for data on freedom of information system a second time – PDF version
http://www.davidmckie.com/Alberta rejects requests for data on freedom of information system a second time.pdf
Parole board warned employees about threats following Saskatchewan stabbings: emails
https://nationalpost.com/pmn/news-pmn/canada-news-pmn/parole-board-warned-employees-about-threats-following-saskatchewan-stabbings-emails
Health card renewals plunged after paper reminders ended
https://www.guelphtoday.com/local-news/health-card-renewals-plunged-after-paper-reminders-ended-7585729
Ontario’s publicly funded colleges posted significant operating surpluses last year
https://www.theglobeandmail.com/canada/article-ontarios-publicly-funded-colleges-posted-significant-operating/
Ontario’s publicly funded colleges posted significant operating surpluses last year – PDF version
http://www.davidmckie.com/Ontario publicly funded colleges posted significant operating surpluses last year.pdf
Open data portals
http://www.davidmckie.com/open-data-portals/
Assignments
Review material from the first four weeks to prepare for next week’s in-class quiz;
Download Tableau using the codes you have been emailed;
Readings
The Data Journalist – Chapter 8
Week 5 – Introduction to data visualizations
06/10/2023
Class recording
https://www.youtube.com/watch?v=2rxpm-CkxhE
Virtual
What you will learn
In-class quiz;
Access-to-information assignment feedback;
A discussion of the concept of visualizing data;
Download Tableau and review examples;
How we data to help tell stories.
Links
Parole board warned employees about threats following Saskatchewan stabbings: emails
https://www.documentcloud.org/documents/24017351-parole-board-of-canada-oct-4-2023-informal-release-of-emails-re-myles-sanderson_a-2022-00023
Machine-sortable format: Parole decisions from 2011 through 2021
http://www.davidmckie.com/A-2022-00017 Response.xlsx
‘We’re ashamed’: Canada’s information watchdogs sign joint pact, urging governments to fix FOI systems
https://www.theglobeandmail.com/canada/article-were-ashamed-canadas-information-watchdogs-sign-joint-pact-urging/
‘We’re ashamed’: Canada’s information watchdogs sign joint pact, urging governments to fix FOI systems – PDF version
http://www.davidmckie.com/Were ashamed_ Canadas information w…pdf
‘The exact same problem as the Greenbelt’: Doug Ford hammered over changes to municipal boundaries
https://www.thestar.com/politics/provincial/the-exact-same-problem-as-the-greenbelt-doug-ford-hammered-over-changes-to-municipal-boundaries/article_e9875287-9f6e-55f1-9140-a61864d0440d.html
The exact same problem as the Greenbelt’: Doug Ford hammered over changes to municipal boundaries – PDF version
http://davidmckie.com/Doug Ford hammered over changing municipal boundaries.pdf
Canada added 64,000 jobs in September, led by Quebec and B.C.
https://www.cbc.ca/news/business/canada-jobs-september-1.6988856
Labour Force Survey, September 2023
https://www150.statcan.gc.ca/n1/daily-quotidien/231006/dq231006a-eng.htm?HPA=1
Labour force characteristics, monthly, seasonally adjusted and trend-cycle, last 5 months1, 2, 3, 4
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410028701
Number of Canadians reporting financial stress jumps 20% in a year — report calls increase a ‘national emergency’
https://www.thestar.com/business/number-of-canadians-reporting-financial-stress-jumps-20-in-a-year-report-calls-increase-a/article_38211bfc-28ce-505d-9563-7ecd40f73e48.html
Number of Canadians reporting financial stress jumps 20% in a year — report calls increase a ‘national emergency’ – PDF version
http://www.davidmckie.com/Financial stress now a national emergency, new report finds.pdf
Canadian kids cost parents more than $350,000 from birth to 17, Statistics Canada study suggests
https://www.theglobeandmail.com/investing/personal-finance/household-finances/article-expect-to-spend-more-than-350000-to-raise-a-child-in-canada-statistics/
Canadian kids cost parents more than $350,000 from birth to 17, Statistics Canada study suggests – PDF version
http://www.davidmckie.com/Canadian kids cost parents more than 350000.pdf
Parole board warned employees about threats following Saskatchewan stabbings: emails
https://nationalpost.com/pmn/news-pmn/canada-news-pmn/parole-board-warned-employees-about-threats-following-saskatchewan-stabbings-emails
MPs to study Access to Information system, federal ‘culture of secrecy’
https://www.thestar.com/politics/2022/09/26/mps-to-study-access-to-information-system-federal-culture-of-secrecy.html
Tableau
https://public.tableau.com/en-us/s/
Datawraper
https://www.datawrapper.de/
Readings
Chapter 11 The Data Journalists Telling Stories with Data
Week 6 – Reading Week
13/06/2023
Week 7 – Data visualization, part two
Virtual
20/10/2023
What you will learn
Class recording
https://www.youtube.com/watch?v=TdaIgO83LYA
Second tutorial using Statistics Canada’s larger crime dataset
https://www.youtube.com/watch?v=o5OKDAzKWLA
Third tutorial downloading the City of Toronto’s 311 data to create a dashboard in Tableau
https://www.youtube.com/watch?v=ISRx6nkvpMM
Fourth tutorial on creating an extract in Tableau
https://www.youtube.com/watch?v=oAps8yMV7II
Continued discussion of data visualizations;
Hands-on session with Tableau using Statscan unemployment data.
Links:
National Newswatch
hhttps://www.nationalnewswatch.com/
STATUS OF HOUSE BUSINESS: PART III – WRITTEN QUESTIONS
https://www.ourcommons.ca/DocumentViewer/en/44-1/house/status-business/page-12
Sessional papers’ catalogue
https://bit.ly/3Fmk2yR
Handgun crime stats – sessional paper
https://parl-gc.primo.exlibrisgroup.com/discovery/delivery/01CALP_INST:01CALP/12152289400002616?lang=en
Ottawa announces special envoy on antisemitism and pledges new law on online hate
https://www.theglobeandmail.com/politics/article-canada-special-envoy-holocaust-remembrance/
Ottawa announces special envoy on antisemitism and pledges new law on online hate – PDF version
http://www.davidmckie.com/Ottawa announces special envoy on antisemitism and pledges new law on online hate.pdf
Orders In Council – Search
https://orders-in-council.canada.ca/
Police-reported hate crimes rise again, as pandemic worsens discrimination: StatCan
https://www.ctvnews.ca/canada/police-reported-hate-crimes-rise-again-as-pandemic-worsens-discrimination-statcan-1.6325705
Infographic: Police-reported hate crime in Canada, 2021
https://www150.statcan.gc.ca/n1/pub/11-627-m/11-627-m2023026-eng.htm
Hamilton Police Release 2022 Hate Crime Statistics
https://hamiltonpolice.on.ca/news/hamilton-police-release-2022-hate-crime-statistics/
Statistics Canda hate-crime datasets
https://www150.statcan.gc.ca/n1/en/type/data?text=police%20reported%20hate%20crimes&sort=releasedate&p=1-data/tables#tables
Police-reported hate crime, by type of motivation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3510006601
Police-reported hate crime, by most serious violation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3510006701
Police-reported crime statistics in Canada, 2022
https://www150.statcan.gc.ca/n1/daily-quotidien/230727/dq230727b-eng.htm
Incident-based crime statistics, by detailed violations, Canada, provinces, territories, Census Metropolitan Areas and Canadian Forces Military Police
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017701
Hate crimes in Canada – 2022 – created using Tableau
http://www.davidmckie.com/category/digi-1examples/
Inflation cools to 3.8% in September. What that means for the Bank of Canada
https://globalnews.ca/news/10029648/canada-inflation-september-2023/
Police-reported crime in Canada, 2022
https://www150.statcan.gc.ca/n1/pub/11-627-m/11-627-m2023041-eng.htm
Police-reported crime statistics in Canada, 2022
https://www150.statcan.gc.ca/n1/daily-quotidien/230727/dq230727b-eng.htm
Documents reveal why RCMP didn’t pursue criminal probe of Justin Trudeau in SNC-Lavalin affair
https://www.thestar.com/politics/federal/documents-reveal-why-rcmp-didn-t-pursue-criminal-probe-of-justin-trudeau-in-snc-lavalin/article_4cc03ad0-18ac-5e68-b4ba-edecf2f7897d.html
Ten downtown condo buildings have 50 or more short-term rentals like Airbnb, city data shows
https://www.thestar.com/real-estate/ten-downtown-condo-buildings-have-50-or-more-short-term-rentals-like-airbnb-city-data/article_e23188c3-2999-5d77-b9b3-4dd2e374d0fc.html
Short-term rentals – City of Toronto open-data portal
https://open.toronto.ca/dataset/short-term-rentals-registration/
Open data portals
http://www.davidmckie.com/open-data-portals/
Ten downtown condo buildings have 50 or more short-term rentals like Airbnb, city data shows – PDF version
http://www.davidmckie.com/Data shows Toronto condos with most Airbnbs.pdf
Statscan medium income release on Instagram
https://www.instagram.com/p/CgxeqApLtVB/
Resources
Uploading documents to DocumentCloud tutorial
https://www.youtube.com/watch?v=i_d0zsw6hhQ&feature=youtu.be
Datasets for visualizations in Tableau
PropertyCrimes_theft_Hate3510017701.zip
Reading
Digging Deeper – Chapter 9
Week 8- following money in publicly traded companies
27/10/2023
Class recording
https://www.youtube.com/watch?v=ZTOYcoquB_U
In-person
What you will learn
Quiz based on the previous four weeks of open data and data visualization;
Brief discussion of next week’s data-visualization assignment and review of examples;
Discussion about the difference between monetary and fiscal policy;
The principles of following the money trail;
Discussing the differences between publicly traded and private companies — if we get to it
Links
National Newswatch
https://www.nationalnewswatch.com/
‘I don’t even know if I can turn my back’: Shocking video of coyotes snatching family cat comes even as sightings decline in Toronto
https://www.thestar.com/news/gta/i-don-t-even-know-if-i-can-turn-my-back-shocking-video-of-coyotes/article_b798be8d-0631-566f-813d-c46b3707cdf3.html
ATIP extension and correspondence for interim release
https://www.documentcloud.org/documents/24079832-innovation-science-and-economic-development-canada-oct-20-2023-90-day-extension-request-for-briefing-note-on-monthly-progress-report-on-national-broadband-connectivity_a-2023-00397
Maps: Tracking the Attacks in Israel and Gaza
https://www.nytimes.com/interactive/2023/10/07/world/middleeast/israel-gaza-maps.html
Are Canadians saving less for retirement?https://www.theglobeandmail.com/investing/personal-finance/retirement/article-are-canadians-saving-less-for-retirement/
Are Canadians saving less for retirement.pdf
BodySafe – City of Toronto open-data portal
https://open.toronto.ca/dataset/bodysafe/
Macklem warned premiers about dangers of putting BoC’s independence at risk
https://www.nationalnewswatch.com/2023/10/24/macklem-warned-premiers-about-dangers-of-putting-bocs-independence-at-risk/
Grocers called back to Parliament to testify about plans to stabilize prices
https://www.nationalnewswatch.com/2023/10/24/grocers-called-back-to-parliament-to-testify-about-plans-to-stabilize-prices/
Bank of Canada
https://www.bankofcanada.ca/
NDP’s proposed windfall profits tax would generate over $4 billion over five years: PBO
https://www.ndp.ca/news/ndps-proposed-windfall-profits-tax-would-generate-over-4-billion-over-five-years-pbo
Backgrounder: Market study of retail grocery competition in Canada
https://www.canada.ca/en/competition-bureau/news/2022/10/backgrounder-market-study-of-retail-grocery-competition-in-canada.html
Loblaw Companies Limited
https://www.loblaw.ca/
SEDAR
https://www.sedarplus.ca/landingpage/
Loblaw Companies Limited, 2023 second quarter interim financial statement uploaded to DocumentCloud
https://www.documentcloud.org/documents/24085701-lcl_q2_2023_fs-1
Loblaw’s increased profits
https://www.documentcloud.org/documents/24085701-lcl_q2_2023_fs-1#document/p2/a2398394
Loblaw Companies Limited, 2023 second quarter management’s discussion and analysis
https://www.documentcloud.org/documents/24085728-lcl_q2_2023_mda
Loblaw Companies Limited, notice of annual meeting of shareholders
https://www.documentcloud.org/documents/24085773-lcl_notice_2022_en
Loblaw Companies Limited, management proxy circular
https://www.documentcloud.org/documents/24085743-lcl_circular_2022_en
Air Canada management information circular, Feb 25, 2022
https://www.documentcloud.org/documents/23314996-air-canada-management-information-circular-feb-25-2022
Air Canada management information circular, Apr 5, 2019
https://www.documentcloud.org/documents/23314997-air-canada-management-information-circular-apr-5-2019
Canada Emergency Wage Subsidy (CEWS) Registry
https://apps.cra-arc.gc.ca/ebci/habs/cews/srch/pub/dsplyBscSrch?request_locale=en
CEWs scraped data in csv format
COVID-19 wage and rent subsidies for businesses
https://www.canada.ca/en/revenue-agency/services/wage-rent-subsidies.html
COVID-19 wage and rent subsidies for businesses
https://www.canada.ca/en/revenue-agency/services/wage-rent-subsidies.html
Securities and Exchange Commission
https://www.sec.gov/
MarketWatch
http://www.marketwatch.com/?link=MW_Nav_FP
Tradingview
https://www.tradingview.com/ideas/free/
Google Finance
http://finance.google.com/finance
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
Resources
BodySafe dataset from City of Toronto open data portal
http://www.davidmckie.com/bodysafe – 4326.xlsx
Beginners’ Guide to Financial Statements (U.S. Securities and Exchange Commission)
http://www.sec.gov/investor/pubs/begfinstmtguide.htm
Week 9
Virtual
3/11/2023
Following money in publicly in public sector institutions – part two
Class recording
https://www.youtube.com/watch?v=WPSGqYDdr1g
What you will learn
Following up from the previous week;
Discussion of the assignment in which you’ll asses a publicly traded company’s filing.
Links
Body Safe – City of Toronto
https://open.toronto.ca/dataset/bodysafe/
Body Safe — updated data obtained by asking
http://www.davidmckie.com/(David McKie, Oct 30, 2023) emailed inspection reports from 2019 to present.zip
Doug Ford’s office was involved in municipal land decisions, records reveal
https://www.theglobeandmail.com/canada/article-doug-fords-office-was-involved-in-municipal-land-decisions-records/
Doug Fords office was involved in municipal land decisions, records reveal.pdf
Sample records obtained by Environmental Defence uploaded to DocumentCloud
https://www.documentcloud.org/documents/24113987-ministry-of-municipal-affairs-and-housing_release-sample_2022-138
Canada Buys
https://canadabuys.canada.ca/en
Sessional papers’ catalogue
https://bit.ly/3Fmk2yR
Highlights of the Ontario government’s fall economic statement
https://www.thestar.com/news/canada/highlights-of-the-ontario-governments-fall-economic-statement/article_64e931e3-6dad-587f-888e-bdea1810a019.html
Canada Emergency Wage Subsidy (CEWS) Registry
https://apps.cra-arc.gc.ca/ebci/habs/cews/srch/pub/dsplyBscSrch
Air Canada’s quarterly profits soar as travel demand stays high
https://www.theglobeandmail.com/business/article-air-canada-reports-quarterly-profit-versus-year-ago-loss-on-strong/
Air Canada’s quarterly profits soar as travel demand stays high
http://www.davidmckie.com/Air Canadas quarterly profits soar as travel demand stays high.pdf
Air Canada Q3 2023 news release
https://www.documentcloud.org/documents/24114046-q3_2023_ac_news-release
Air Canada Q3 2023 interim report
https://www.documentcloud.org/documents/24114042-q3_2023_air_canada_consolidated_financial_statements_notes_-_english
Air Canada Q3 2023, Management’s Discussion and Analysis (MD&A)
https://www.documentcloud.org/documents/24114043-air_canada_q3_2023_mda_-_english
Air Canada proxy circular — executive compensation — 2022
https://www.documentcloud.org/documents/24114044-ac_proxycircular_eng_2023rv
Canada Emergency Wage Subsidy (CEWS) Registry
https://apps.cra-arc.gc.ca/ebci/habs/cews/srch/pub/dsplyBscSrch
Ontario Power Generation
https://www.opg.com/
Public Accounts of Canada
https://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/index-eng.html
Cases up, costs down: feds report $227.1-million in lost revenue, public money and property in 2021-22
https://www.hilltimes.com/story/2022/11/14/cases-up-costs-down-feds-report-227-1-million-in-lost-revenue-public-money-and-property-in-2021-22/355117/
Public Accounts of Canada
https://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/index-eng.html
Public Accounts of Canada Volume 111 uploaded to DocumentCloud
https://www.documentcloud.org/documents/23307718-2022-vol3-eng
Losses of Public Property as per the Public Accounts of Canada
https://open.canada.ca/data/en/dataset/eda3bce1-4866-45e4-9e13-ea98679e888f
Ontario’s Plan to Build: A Progress Update
https://budget.ontario.ca/2022/fallstatement/
Ontario’s “progress update” uploaded to DocumentCloud
https://www.documentcloud.org/documents/23307699-2022-fall-statement-en#document/p136/a2173094
Ontario economic update and fiscal review uploaded the DocumentCloud
https://www.documentcloud.org/documents/23307699-2022-fall-statement-en
The Public Accounts of Ontario 2021-22
https://www.ontario.ca/page/public-accounts-ontario-2021-22
NDP calling for probe of grocery store profits as food prices continue to rise
https://www.cbc.ca/news/politics/ndp-committee-study-grocer-store-profits-inflation-1.6596742
Federal Public Accounts
https://open.canada.ca/data/en/dataset/350b4f13-d84a-4e94-b221-1109dc00ab39
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://www.documentcloud.org/documents/21562922-2021-vol1-eng-1
Federal Public Accounts – Volume two
https://beta.documentcloud.org/documents/20493462-p51-1-2020-2-eng
Federal Public Accounts – Corrections to Volume two
https://beta.documentcloud.org/documents/20493460-erratum-vol2-org-415-416-418-419-eng
Federal Public Accounts – Volume three
https://www.documentcloud.org/documents/20493461-p51-1-2020-3-eng
Losses of Public Property as per the Public Accounts of Canada in csv format
https://open.canada.ca/data/en/dataset/eda3bce1-4866-45e4-9e13-ea98679e888f
Losses of public money due to an offence, illegal act or accident as per the Public Accounts of Canada in csv format
https://open.canada.ca/data/en/dataset/23f921e3-e229-4ee7-b65e-a3b99ca82ecb
Ministerial Expenditures by Standard Object as per the Public Accounts of Canada in csv format
https://open.canada.ca/data/en/dataset/9c4bcc95-bd73-4476-b86f-03553d489a45
Ministerial Expenditures by Type as per the Public Accounts of Canada
https://open.canada.ca/data/en/dataset/9df1d5f2-3c03-4dad-9b9b-67fcbafcc791
Federal Public Accounts – Volume three
https://beta.documentcloud.org/documents/20493461-p51-1-2020-3-eng
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
Annual Financial Report of the Government of Canada Fiscal Year 2019-2020
https://www.canada.ca/en/department-finance/services/publications/annual-financial-report/2020/report.html
Annual Financial Report of the Government of Canada Fiscal Year 2019-2020 – uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20493465-annual-financial-report-of-the-government-of-canada-fiscal-year-2019-2020-canadaca
Federal Fall Economic Statement 2020
https://www.budget.gc.ca/fes-eea/2020/home-accueil-en.html
Federal Fall Economic Statement uploaded to DocumentCloud
https://beta.documentcloud.org/documents/20419378-nov-30-2020-fiscal-update
Ontario’s Plan to Build: A Progress Update
https://budget.ontario.ca/2022/fallstatement/
Ontario’s “progress update” uploaded to DocumentCloud
https://www.documentcloud.org/documents/23307699-2022-fall-statement-en#document/p136/a2173094
The Public Accounts of Ontario 2021-22
https://www.ontario.ca/page/public-accounts-ontario-2021-22
Ontario public accounts 2021-22 uploaded to DocumentCloud
https://www.documentcloud.org/documents/23307701-tbs-2021-22-annual-report-and-consolidated-financial-statements-en-2022-09-21
Resources
Donald W. Reynolds National Center for Business Journalism
http://businessjournalism.org/
Week 10 – Conducting bankruptcy searches, decoding an access-to-information request
Class recording
https://youtube.com/watch?v=7uhOWAaDf64
Virtual
10/11/2023
What you will learn
Quiz based on the following-the-money exercises from the previous two weeks;
Access-to-information updates;
A look at the data we’ll be using for the Facebook ad library data assignment;
Learning how to decode records received through access-to-information requests;
Links
National Defence receives largest cut in first wave of federal spending review
https://www.theglobeandmail.com/politics/article-national-defence-receives-largest-cut-in-first-wave-of-federal/
The dustbin of history
https://www.theglobeandmail.com/canada/article-access-to-information-laws-historians/
The dustbin of history – pdf version
Ottawa paid nearly $670,000 for KPMG’s advice on cutting consultant costs
https://www.theglobeandmail.com/politics/article-federal-government-kpmg-consulting/
Ottawa paid nearly 670,000 for KPMGs advice on cutting consultant costs.pdf
Federal contracts sessional paper uploaded to DocumentCloud
https://www.documentcloud.org/documents/24124588-federal-contracts-awarded-since-fiscal-year-2015-16-broken-down-by-fiscal-year_99506093002616
Canada Revenue Agency records on international students receiving emergency benefits from March 1, 2020 to present
https://www.documentcloud.org/documents/24031270-canada-revenue-agency-sept-27-2023-informal-release-of-records-re-international-students-receiving-emergency-benefits-from-march-1-2020-to-present_a-2020-120225
Innovation, Science and Economic Development Canada, automotive theft in Canada – briefing note uploaded to DocumentCloud
https://www.documentcloud.org/documents/24153101-innovation-science-and-economic-development-canada-oct-19-2023-formal-release-of-briefing-note-re-automotive-theft-in-canada-as-processed-on-a-2023-00346_a-2023-00395-ja
BodySafe
https://open.toronto.ca/dataset/bodysafe/
Pablo Rodriguez faces questions about whether he misled Commons committee on Laith Marouf
https://www.theglobeandmail.com/politics/article-pablo-rodriguez-faces-questions-about-whether-he-misled-commons/
Pablo Rodriguez faces questions about whether he misled Commons committee on Laith Marouf – PDF
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/
Air Canada granted bankruptcy protection
https://www.cbc.ca/news/business/air-canada-granted-bankruptcy-protection-1.366723
Laurentian insolvency ‘made a bad situation worse’: Auditor-General says university should have opted for provincial aid
https://www.theglobeandmail.com/canada/article-laurentian-insolvency-made-a-bad-situation-worse-auditor-general-says/
Office of the Auditor General of Ontario – Special Report on Laurentian University
https://www.auditor.on.ca/en/content/specialreports/specialreports/LaurentianUniversity_EN.pdf
CCAA records list
https://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/h_br02281.html
Laurentian’s creditors
https://www.documentcloud.org/documents/23319053-lu-creditor-list-final
Companies’ Creditors Arrangement Act (CCAA) Records List
https://open.canada.ca/data/en/dataset/92697343-d36d-4427-a1a8-ebac6b2725cc
Companies’ Creditors Arrangement Act Records list imported into a master Excel file
http://www.davidmckie.com/CCAA-Records-Open-Data-2016-2022.xlsx
Office of the Superintendent of Bankruptcy (username and password creation)
https://www.ic.gc.ca/app/scr/registration-inscription/home.html?lang=eng
(Public Safety Canada, Nov 9, 2022) formal release of Aug 18, 2022, Preventing Online Sexual Exploitation Together Responding to the critical need_A-2022-00228
https://www.documentcloud.org/documents/23323967-public-safety-canada-nov-9-2022-formal-release-of-aug-18-2022-preventing-online-sexual-exploitation-together-responding-to-the-critical-need_a-2022-00228
5 local arrests made in provincewide child sexual exploitation investigation
5 local arrests made in provincewide child sexual exploitation investigation | CBC News
List of charities and certain other qualified donees – basic search
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en
Week 11 – introduction to Facebook’s ad library – part one
Virtual
17/10/2023
Class recording
https://www.youtube.com/watch?v=TNqvFoT0HBY
Alina’s instructional video on using the Facebook Ad Library data
https://www.youtube.com/watch?v=YCV90ubQnBQ
What you will learn
Data-visualization assignment feedback;
Discussion about the federal online news bill;
Discussion of Facebook ad library assignment.How to mine Facebook’s ad library for trends;
How to select the information you want and download the results;
Discuss examples of stories using materials from the ad library.
Links
Meta financial reports
https://investor.fb.com/investor-news/default.aspx
Facebook Ad Library
https://www.facebook.com/ads/library/?active_status=all&ad_type=political_and_issue_ads&country=CA&media_type=all
Canada Gazette, Part I, Volume 157, Number 35: Regulations Respecting the Application of the Online News Act, the Duty to Notify and the Request for Exemptions
https://canadagazette.gc.ca/rp-pr/p1/2023/2023-09-02/html/reg1-eng.html
The government’s online news bill can’t overcome its own flawed assumptions
https://thehub.ca/2023-09-04/opinion-the-governments-online-news-bill-cant-overcome-its-own-flawed-assumptions/
Canadian media trained audiences to use Facebook. With Meta blocking news, what’s next?https://www.cbc.ca/radio/sunday/canadian-media-news-meta-facebook-1.6939274
Liberal party launched over a dozen Facebook ads after government Meta boycott
https://nationalpost.com/news/politics/liberal-party-launched-over-a-dozen-facebook-ads-despite-government-ban
Alberta’s ‘national’ campaign to thwart electricity regulations heavily targeted at Albertans
https://edmontonjournal.com/news/politics/albertas-national-campaign-to-thwart-electricity-regulations-heavily-targeted-at-albertans
Alberta MP lambastes Smith for ‘baseless,’ ‘ludicrous’ statements on power generation
https://bit.ly/3MrTH6r
Smith is snowing Albertans on renewables
https://www.nationalobserver.com/2023/09/08/opinion/smith-snowing-albertans-renewables
Bill C-18: An Act respecting online communications platforms that make news content available to persons in Canada
https://www.parl.ca/legisinfo/en/bill/44-1/c-18
Doug Ford government paying for-profit clinic more than hospitals for OHIP-covered surgeries, documents show
https://www.cbc.ca/news/canada/toronto/ontario-doug-ford-private-clinic-surgeries-fees-hospitals-1.7026926
Resources
Facebook ad library dataset
http://www.davidmckie.com/Nov_01_to_16_FBAdLibrary_REVISED.xlsx
Week 12 – introduction to Facebook’s ad library – part two
24/11/2023
Class recording
https://www.youtube.com/watch?v=vGwVtDYh1gY
Alina’s quick tutorial on MacBook keyword searches
https://www.youtube.com/watch?v=8e7qcFR4O4A
Virtual
What you will learn
Discussion of Facebook ad library assignment and disinformation;
A deep dive into public records:
Links:
Right-wing U.S. media covered fiction as fact: A non-existent terrorist attack from Canada at Rainbow Bridge
https://www.cbc.ca/news/world/border-incident-erroneous-reporting-1.7036978
Nov 22, 2023, question period (14:26 mark)
https://parlvu.parl.gc.ca/Harmony/en/PowerBrowser/PowerBrowserV2/20231123/-1/40436
Liberals accuse Poilievre of ‘riling’ up Canadians in border crash comments
https://bit.ly/3QVWW7o
Liberals accuse Poilievre of riling up Canadians in border crash comments.pdf
Poilievre faces reporter questions about terrorism reference
https://twitter.com/acoyne/status/1727816154624704944
FBIBuffalo tweets
https://twitter.com/FBIBuffalo/status/1727517487523119232
https://twitter.com/FBIBuffalo/status/1727390895283044365?cn=ZmxleGlibGVfcmVjcw%3D%3D&refsrc=email
Canadian media trained audiences to use Facebook. With Meta blocking news, what’s next?https://www.cbc.ca/radio/sunday/canadian-media-news-meta-facebook-1.6939274
Fair Vote Canada
https://www.fairvote.ca/truth-in-advertising/
Meta financial reports
https://investor.fb.com/investor-news/default.aspx
Liberal party launched over a dozen Facebook ads after government Meta boycott
https://nationalpost.com/news/politics/liberal-party-launched-over-a-dozen-facebook-ads-despite-government-ban
CANLII
https://www.canlii.org/fr/
Class Action Database — Canadian Bar Association
https://www.cba.org/Publications-Resources/Class-Action-Database
Search for a report
https://library-archives.canada.ca/eng/services/government-canada/public-opinion-research/pages/search-por-reports.aspx#a1
Ontario public salary disclosure
https://www.ontario.ca/public-sector-salary-disclosure/2022/all-sectors-and-seconded-employees/
Canada Energy Dashboard
https://www.canadaenergydashboard.com/index.html
Canada: CO2 Country Profile
https://ourworldindata.org/co2/country/canada
Greenhouse gas emissions by sector, Canada
https://ourworldindata.org/grapher/ghg-emissions-by-sector?time=latest&country=~CAN
National Pollutant Release Inventory
https://www.canada.ca/en/services/environment/pollution-waste-management/national-pollutant-release-inventory.html
Housing Market Information Portal
https://www03.cmhc-schl.gc.ca/hmip-pimh/en#Profile/1/1/Canada
Canada Gazette, Part I, Volume 157, Number 35: Regulations Respecting the Application of the Online News Act, the Duty to Notify and the Request for Exemptions
https://canadagazette.gc.ca/rp-pr/p1/2023/2023-09-02/html/reg1-eng.html
Week 13 – Postmortem
1/12/2023
Class recording
https://www.youtube.com/watch?v=1FHx7Eh39sQ
Snack time!
In-person
What you will learn
Follow the money assignment feedback;
Continued deep dive into public records;
What you learned;
What you wish we had more time for.
Links
HillNotes
https://hillnotes.ca/
The Canadian Dollar: What Determines the Exchange Rate?
https://hillnotes.ca/2018/09/26/the-canadian-dollar-what-determines-the-exchange-rate/
Good news about the news — Google reaches deal with Canada
https://www.nationalobserver.com/2023/11/29/opinion/good-news-about-news-google-reaches-deal-canada
Good news about the news Google reaches deal with Canada.pdf
Justin Trudeau’s government badly fumbled the Online News Act — and a deal with Google doesn’t fix its fatal flaw
https://www.thestar.com/politics/political-opinion/justin-trudeau-s-government-badly-fumbled-the-online-news-act-and-a-deal-with-google/article_9ad85e88-08d1-58a6-90ca-46ae635b1958.html
Google deal doesnt fix Ottawas Online News Act fumble.pdf
http://www.davidmckie.com/Google deal doesnt fix Ottawas Online News Act fumble.pdf
Story based on cyber security briefing note obtained through an access-to-information request
https://www.documentcloud.org/documents/24178195-jim-bronskill-nov-29-2023-informal-release-of-briefing-note-re-dm-meeting-with-csec-chief-and-canada-energy-regulator-chief-re-cybersecurity_a-2023-00293
Auditors General
Auditor General of Canada
https://www.oag-bvg.gc.ca/internet/English/admin_e_41.html
Office of the Auditor General of Ontario
https://www.auditor.on.ca/
Le Vérificateur général du Québec
https://www.vgq.qc.ca/fr
Office of the Auditor General Nova Scotia
https://oag-ns.ca/
Coroners/Medical examiners
B.C. Coroner investigating 3 potential heat-related deaths
https://www.cbc.ca/news/canada/british-columbia/b-c-coroner-heat-deaths-1.6916188
BC Coroner extreme death report
https://www.documentcloud.org/documents/22074225-extreme_heat_death_review_panel_report
BC Coroner
https://www2.gov.bc.ca/gov/content/life-events/death/coroners-service
Office of the Chief Coroner and the Ontario Forensic Pathology Service
https://www.ontario.ca/page/office-chief-coroner-and-ontario-forensic-pathology-service#section-0
Saskatchewan coroners report
https://www.documentcloud.org/documents/23720389-sask-coroner-report-jury-recommendations-for-ballantyne-and-adams
Saskatchewan Coroners Service
https://www.saskatchewan.ca/government/government-structure/boards-commissions-and-agencies/saskatchewan-coroners-service
Ontario to do away with mandatory coroner’s inquests on construction site deaths
https://toronto.ctvnews.ca/mobile/ontario-to-do-away-with-mandatory-coroner-s-inquests-on-construction-site-deaths-1.6667355?cache=?autoPlay=true
Le Bureau du coroner – Quebec
https://www.coroner.gouv.qc.ca/
Nova Scotia Medical Examiner Service
https://novascotia.ca/just/cme/
Nova Scotia: Submission on the Right to Information Act
X Has Become a ‘Global Sewer,’ Mayor of Paris Says
https://www.nytimes.com/2023/11/27/business/anne-hidalgo-x-twitter.html
Class works
Marina Black Media
https://www.marinablackmedia.ca/
https://www.instagram.com/marinablackmedia/?igshid=MzRlODBiNWFlZA%3D%3D
Alexia’s Toronto Star EpiPen story
EpiPens should be mandatory in public places — they’re no different from other safety devices
PDF version: EpiPens should be mandatory in public places.pdf
Livia Writes
https://www.liviawrites.com/
Stories from home – Mehmet Oner
https://memetoner81.wixsite.com/journalist
https://www.instagram.com/m_e_h_m_e_t_o_n_e_r/?hl=tr
The Mike – Andrew Roberts
https://readthemike.com/?s=Andrew+Roberts