JOUR 5206: Introduction to Investigative Journalism – 2025 Winter term Carleton School of Journalism and Communication

Share

Wednesdays: 7:00 to 10:00 p.m.

              Location:
Classes 1 (Jan. 8) and 12 (April 2) will be held in Richcraft Hall Room 4115
Classes 2 through 11 will be held virtually and synchronously

     Brightspace: https://brightspace.carleton.ca/d2l/home/285090

David McKie, davidmckiec@gmail.com
Phone: (C) 613-290-7380

Jim Bronskill, The Canadian Press

David, Fred Vallance-Jones, Rob Cribb and Dean  Jobb are co-authors of
Digging Deeper Third Edition
David McKie and Jim Bronskill are co-authors of
Your Right To Know: How to Use the Law to
Get Government Secrets

 David and Fred are co-authors of
The Data Journalist: Getting the Story

 Assignments and Evaluation | Course Schedule |Data Visualization |Backstory |Dollars and Sense story |Access-to-information assignment Week one Week two Week three | Week four | Week five Week six Week seven Week eight Week nine Week ten Week eleven Week twelve |Tutorials | Datasets |

Course Objectives

1) Obtain a thorough grounding in journalistic research methods.

2) Acquire skills needed to make sense of the information gathered.

3) Develop the ability to shape the information into accurate and compelling stories for all platforms.

 

Ethics and Professional Standards

This is a professional school, and you’ll be held to professional standards in both assignments and conduct. As a student of journalism, you must read and adhere to the School’s policies.

  1. Our ethics policy sets out the rules of behaviour that you, as students and journalists, are expected to follow as you carry out your assignments for this course. One of the rules, for example, makes clear that you must not interview relatives or friends for your story, except in rare and special circumstances and with the advance permission of the instructor.
  2. Our publishing policy requires certain authorizations before journalistic coursework can be published outside of the class. In addition, your sources must understand that any assignments they are associated with may be published outside of class.
  3. Our policy on electronic media usage requires that you follow copyright regulations with respect to your use of all materials culled from the Internet. For example, you cannot use any pictures you find online in your assignments unless you get written permission from the copyright holder to use them and submit it to the instructor.

Ethics and professional standards for the School of Journalism: https://carleton.ca/sjc/wp-content/uploads/Ethics-Policy-Updated-2018-Aug-6.pdf

You are expected to be familiar with these policies and apply them to your work. Failure to abide by them will adversely affect your standing in the course.

If you have questions about the journalism program, degree requirements, your standing in the program or your academic audit, you should contact Graduate Administrator Kemi Obando kemi.obando@carleton.ca or Graduate Supervisor Sarah Everts at  sarah.everts@carleton.ca

Plagiarism

The University Academic Integrity Policy defines plagiarism as “presenting, whether intentionally or not, the ideas, expression of ideas or work of others as one’s own.”  This includes reproducing or paraphrasing portions of someone else’s published or unpublished material, regardless of the source, and presenting these as one’s own without proper citation or reference to the original source. Examples of sources from which the ideas, expressions of ideas or works of others may be drawn from include but are not limited to: books, articles, papers, literary compositions and phrases, performance compositions, chemical compounds, artworks, laboratory reports, research results, calculations and the results of calculations, diagrams, constructions, computer reports, computer code/software, material on the internet and/or conversations.

Examples of plagiarism include, but are not limited to:

  • any submission prepared in whole or in part, by someone else, including the unauthorized use of generative AI tools (e.g., ChatGPT);
  • using ideas or direct, verbatim quotations, paraphrased material, algorithms, formulae, scientific or mathematical concepts, or ideas without appropriate acknowledgment in any academic assignment;
  • using another’s data or research findings without appropriate acknowledgement;
  • submitting a computer program developed in whole or in part by someone else, with or without modifications, as one’s own; and
  • failing to acknowledge sources through the use of proper citations when using another’s work and/or failing to use quotations marks.

Course copyright

Classroom teaching and learning activities, including lectures, discussions, presentations, etc., by both instructors and students, are copyright protected and remain the intellectual property of their respective author(s). All course materials, including PowerPoint presentations, outlines, and other materials, are also protected by copyright and remain the intellectual property of their respective author(s).

Students registered in the course may take notes and make copies of course materials for their own educational use only. Students are not permitted to reproduce or distribute lecture notes and course materials publicly for commercial or non-commercial purposes without express written consent from the copyright holder(s).

Attendance

Showing up, whether it’s to a reporting assignment, a team meeting with colleagues or a shift at work, is a key part of journalism. Being there and being reliable matters. The same is true for attending class, regardless of whether it’s a lecture, seminar or workshop.

All students must attend at least nine classes or 75 per cent of instructional time in order to pass this course. If you miss more than this amount (not including apprenticeships), it’s an automatic fail. If you are sick, you must communicate this to your instructors before the class, just as one would do on a job. If you don’t do this, we’ll assume you have simply skipped class. If you anticipate missing more than three classes or 75 per cent of instructional time, please contact the instructors by email as soon as possible to discuss your personal circumstances.

COVID-19 and the Classroom

All members of the Carleton community are required to follow COVID-19 prevention measures and all mandatory public health requirements.

Statement on student mental health

As a University student you may experience a range of mental health challenges that significantly impact your academic success and overall well-being. If you need help, please speak to someone. There are numerous resources available both on- and off-campus to support you: https://carleton.ca/wellness/

Emergency Resources (on and off campus): https://wellness.carleton.ca/get-help-now/

Carleton Resources:

Off Campus Resources:

Equity and diversity

Discussion and debate play valuable roles in online and in-person classes. Differing views should focus on the content of the material and efforts should be made to understand how a person’s lived experience might or ought to shape their perspectives. Racist, sexist, homophobic, transphobic, and ableist language will not be tolerated.

Carleton’s journalism program is committed to creating a welcoming, stimulating, professional and creative environment for our increasingly diverse student body. We commit to eliminating racism against Racialized and Indigenous people as well as inequities or other barriers based on ethnicity, nationality, religion, gender expression, sexual orientation, or ability. We hope our program’s commitment to anti-racism and anti-oppression practices will benefit all of our students while they are here and that it will foster a wider culture of equity and inclusion in newsrooms of the future as they respond to and report on an increasingly diverse society.

The Permanent Working Group was established in order to help keep the journalism school on track with structural changes that aim to make the school a safe and welcoming environment for all students. The group also provides specific direction and advice to the journalism program committee and head on matters pertaining to equity and inclusion. Students wishing to propose programmatic ideas or who have concerns may contact us directly via https://carleton.ca/sjc/journalism/equity-and-inclusion/permanent-working-group/

The Department of Equity and Inclusive Communities fosters the development of an inclusive and transformational university culture where individual distinctiveness and a sense of belonging for every member drive excellence in research, teaching, learning and working at Carleton. Students with complaints may direct them to the Department of Equity and Inclusive Communities via https://carleton.ca/equity/

The journalism program has a student-led Association for Equity and Inclusion in Journalism and Media. Its mission is to make the journalism school a safe(r) space for Black, Indigenous, and students of colour, 2SLGBTQ+ students and students with disabilities/disabled students. More information about the association can be found at https://carleton.ca/sjc/journalism/equity-and- inclusion/student-association/

Academic accommodation

You may need special arrangements to meet your academic obligations during the term. For an accommodation request the processes are as follows:

Academic consideration for medical or other extenuating circumstances: Students must contact the instructor(s) as soon as possible, and normally no later than 24 hours after the submission deadline for course deliverables. [Provide any additional information on your requirements for short-term informal accommodations. If you require supporting documentation for short-term considerations, you may only request the Academic Consideration for Coursework form. You may not request medical notes or documentation.]

Students should also consult the Course Outline Information on Academic Accommodations for more information. Detailed information about the procedure for requesting academic consideration can be found here.

Pregnancy and Family-Status Related Accommodation: Please write to me with any requests for academic accommodation during the first few weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details about the accommodation policy, visit the Equity and Inclusive Communities (EIC) website.

Religious obligation: write to me with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details click here.

Academic Accommodations for Students with Disabilities: The Paul Menton Centre for Students with Disabilities (PMC) provides services to students with Learning Disabilities (LD), psychiatric/mental health disabilities, Attention Deficit Hyperactivity Disorder (ADHD), Autism Spectrum Disorders (ASD), chronic medical conditions, and impairments in mobility, hearing, and vision. If you have a disability requiring academic accommodations in this course, please contact PMC at 613-520-6608 or pmc@carleton.ca for a formal evaluation. If you are already registered with the PMC, please request your accommodations for this course through the Ventus Student Portal at the beginning of the term, and no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). Requests made within two weeks will be reviewed on a case-by-case basis. For final exams, the deadlines to request accommodations are published in the University Academic Calendars. After requesting accommodation from PMC, meet with me to ensure accommodation arrangements are made. Please consult the PMC website for the deadline to request accommodations for the formally-scheduled exam (if applicable).

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

Accommodation for Student Activities: Carleton University recognizes the substantial benefits, both to the individual student and for the university, that result from a student participating in activities beyond the classroom experience. Reasonable accommodation will be provided to students who compete or perform at the national or international level. Write to me with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. https://carleton.ca/senate/wp-content/uploads/Accommodation-for-Student-Activities-1.pdf

Instructions for setting up your campus pin card

Details can be found here: https://carleton.ca/technicalservices/card-access-how-tos/

Textbooks

Digging Deeper 3rd edition is the main textbook for this course. It is available at the Carleton bookstore for rent ($55.99 and up) or purchase – digital ($86.14 and up) or hard copy ($113.25). Buying the book online is another option. The Data Journalist is an optional textbook, which will come in handy during the weeks when we focus on data. And Your Right To Know, also an optional textbook, will be useful for our access-to-information sessions.

Assignments and Evaluation (TOP)

Assignments in this course are governed by the provisions of the document Ethics and Standards in the School of Journalism and Communication. There are four assignments, each with a deadline. Lateness will be penalized, though exceptional circumstances will be taken into account. There is no final examination. With the exception of the access-to-information assignment, each has three components, all of which will figure in the grade:

  1. Copies of the actual documents compiled / gathered.
  2. A description of how the documents were obtained and why they were useful.
  3. The resulting story or visualization.

Each of the four assignments is worth 20 per cent of the overall course grade. The remaining 20 per cent of the grade will be determined based on presence / punctuality, participation and professionalism, including quiz results.

Due Dates

1) Data visualization outline due Mon., Feb. 3, noon.
2) Data visualization due Sun., Feb. 9, noon.
3) Access-to-information requests must be filed by Thu., Feb. 13, 11:59 p.m.
4) Backstory outline due Sun., Feb. 16, noon.
5) Backstory assignment due Sun., March 2, 11:59 p.m.
6) Dollars and Sense outline due Fri., March 7, 11:59 p.m.
7) Dollars and Sense story due Sun., March 16, noon.
8) Access-to-information assignment due Sun., March 23, noon.


Grades (additional information)

The passing grade for this course is B minus.

Informal questions or appeals about your grade on assignments or other graded components of the course should be raised with the instructor no later than seven business days after the grade has been issued.

For information about the formal Grade Review process, please see the Graduate Regulations: https://carleton.ca/FASS-FPA-teaching-regulations/grades-and-grading/

Standing in a course is determined by the course instructor subject to the approval of the Faculty Dean. This means that grades submitted by an instructor may be subject to revision. No grades are final until they have been approved by the Dean.

 

Course Schedule (TOP)

Jan. 8 (In person): a. Course introduction / self-assessment b. Introduction to Access to information c. Access-to-information tips: Previously released records
|| Reading: Digging Deeper, Chapters, 1, 2, 10

Jan. 15 (Virtual): a. Access-to-information tips: Previously released records, focusing a request, negotiating, seeking partial releases b. Assignment: Access to information
|| Reading review: Digging Deeper, Chapters, 1, 2, 10

Jan. 22 (Virtual): a. Data (part one) b. Assignment: Data visualization
|| Reading: Digging Deeper: Chapter 11
|| Optional reading: The Data Journalist: Chapters 2, 4

Jan. 29 (Virtual): a. Data (part two)
|| Reading: Digging Deeper, Chapters 3, 4, 6
|| Optional reading: The Data Journalist: Chapter 8

Feb. 5 (Virtual): a. Introduction to historical records b. Assignment: Backstory c. Data visualization due Sun., Feb. 9, noon.
|| Reading review of chapters covered so far to prepare for Feb. 12 quiz

Feb. 12 (Virtual): a. Quiz based on readings and in-class learning b. Mid-course checkup c. Elements of storytelling d. Access-to-information requests must be filed by Thu., Feb. 13, 11:59 p.m.
|| Reading: Digging Deeper, Chapters 7, 8

Feb. 19:  Break Week. No class scheduled.

Feb. 26 (Virtual): a. Data visualization feedback. b. Dollars and Sense (part one) c. Assignment: Dollars and Sense story d. Backstory assignment due Sun., March 2, 11:59 p.m.
|| Reading: Digging Deeper, Chapter 9

March 5 (Virtual): a. Dollars and Sense (part two) b. Public records (part one)
|| Reading review: Chapters 4, 9

March 12 (Virtual): a. Backstory feedback b. Public records (part two) c. Dollars and Sense story due Sun., March 16, noon.
|| Reading: Chapter 7

March 19 (Virtual): a. Access-to-information tips: Making sense of records (decoding documents, chronologies) b. Access-to-information assignment due Sun., March 23, noon
|| Reading: Chapter 5

March 26 (Virtual): a. Dollars and Sense story feedback b. Data: Additional techniques
|| Reading review: Digging Deeper, Chapters 4, 5, 7, 8, 9

April 2 (In person):  a. Access-to-information assignment feedback b. Quiz based on readings and in-class learning c. Enterprise journalism tactics

Virtual office hours
We are available to discuss course material and assignments with you by email, phone or after class. Our virtual office hours are Wednesday 11 a.m. to noon ET – please advise David or Jim in advance that you would like to speak with one or both of us.

Data visualization  (TOP)

A digital visualization that tells a story based on analysis of data, due Sun., Feb. 9, noon. (An outline is due Mon., Feb. 3, noon.)

What is required for emailed outline draft visualizations?

  1. The dataset(s) you want to use in an Excel workbook that contains three tabs: the original dataset with the URL pasted into the first available cell in the first row; two subsequent worksheets with the filtered datasets that will be visualized.
  2. A brief, point-form explanation in the body of an email of why the data tables are newsworthy.
  3. At least two public records to support the visualization.

What is required for the approved visualizations?

  1. Two newsworthy visualizations displaying two different trends from your dataset. For instance, one could be the kind of vertical bar chart. The second, a map.
  2. The visualizations must be newsworthy. For instance, one of the  Statistics Canada tables we have examined in class and mined for new information that adds value to what we already know. In the case of Labour Force Survey, it could be comparing the lot of different age groups in Ontario. For the Consumer Price Index statistics, it could be a comparison of the price of items before the pandemic to the present day. For instance, you might create a dashboard in Tableau to allow users to see which provinces had the highest gasoline prices. Ideally, these numbers should be used in stand-alone, value-added visualizations that could be shared on social media as a way of bringing eyeballs to an original story.
  3. You must use up to 100 words to set up each visualization, using AT LEAST three of the kinds of public records described in chapter 4 of Digging Deeper for contextual background information.
  4. The public records MUST be uploaded to DocumentCloud (which we will learn more about well before the final version of the assignment is due) with the appropriate annotations.
  5. Upload the visualizations and explanations to the category on our WordPress site, JOUR 5206_2025_1. You’ll be shown how to do this.

What’s to be submitted?

  1. Two DIFFERENT visualizations in ONE blog post kept in draft format. Each visualization must be accompanied by a 100-word explanation that explains the news value. Upload the blog post to the WordPress category “JOUR 5206_2025_1”
  2. A 500-word explanation in an email  Word document that briefly explains WHY you chose the visualizations, their news value, and the public records you used to provide context.
  3. In your explanations used to set up the visualizations, there must be links to AT LEAST three different public records uploaded to DocumentCloud (Don’t worry! You will learn how to upload and annotate documents.). The DocumentCloud links MUST take readers to the appropriate annotations in the public record. You can use a SAME record for each visualization.
  4. The Excel workbook that contains four worksheets: worksheet one – the original table with the URL pasted into the first available cell in the first row; worksheet two – the working copy of the original table; worksheet three – the filtered and cleaned-up table used to provide the first visualization; worksheet four – the cleaned-up table used to provide the second visualization. Only provide ONE workbook, even if you are using two tables from different datasets. The visualization does not have emerge from a pivot table. It can also be from regular table that is filtered and sorted.
  5. The Word document with your background explanation and the Excel workbook must be emailed to me.

Data visualization frequently asked questions

Q: Can I choose any dataset?
A: One of the two datasets we have mined in class.

Q: Do I have to run the dataset by you?
A: No, because you already did that in the outline.

Q: Can the graph visualization be a jpg or png file?
A: NO!! It must be embedded as an interactive visualization that allows for a reader engagement? For further clarification, this means taking the visualization embed code and pasting into the HTML tab of your blog post. I’ll use a demonstration to show  you how to do this. If you still run into problems, please let me know.

Q: Will I lose marks for embedding a graph as a jpg or png file?
A: Yes, half a grade.

Q: Can I use two similar visualizations?
A: For the sake of variety, you MUST create two COMPLETELY DIFFERENT ones. For instance, a dataset that contains important numbers may also have geographic information such as longitude and latitude coordinates, or names of countries, provinces and cities. In this case, you could display your numbers from your Excel spreadsheet in an infographic. In a second visualization, you could then display the geographic coordinates in Tableau.

Q: Will I lose marks for neglecting to ensure my visualizations have titles, cutlines, and credits for sources?
A: Yes.  Half a grade

Q: Do I have to use Tableau?
A: No, you can use another visualization software with which you are more comfortable. However, you’ll be getting a license for Tableau Desktop, which you are free to use for this assignment. I’ll also be preparing instructional videos.

Q: Will I lose marks for neglecting to upload and annotate my public documents in DocumentCloud? 
A: Yes, half a grade.

Q: How should I use the public records?
A: As background information to provide context or advance the story.

Q: What would be an example of a public record?
A: The kinds that are discussed in Chapter 4 of Digging Deeper and during the first few weeks of this class. 

Q: Can a public record be an article or news report?
A: NO! The focus in this course is the use of the primary records described in Digging Deeper. While news reports that show up in  your Google alerts are useful as tip sheets for sources of information, they can not be the primary reference, in large part because the reports could contain inaccuracies.

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.

Backstory assignment  (TOP)

A story that draws on archival- or library-based sources from at least 35 years ago (1990 or earlier) to provide historical depth on a current Canadian issue or event. 600 words, due Sun., March 2, 11:59 p.m. (An outline is due Sun., Feb. 16, noon.)

Outline checklist:

Send your outline (pasted in the body of an email, not a Word document) by Sun., Feb. 16, noon.

It should be no more than 200 words and include:
(*) A few words about an issue or event in the news today (i.e. what is happening now that makes it worth looking into the backstory?)
(*) A brief description of the backstory – the original issue or event from 35 or more years ago that will be the focus of your story.
(*) What kinds of historical sources do you hope to use in your research (e.g. newspaper archives, parliamentary debates, archival documents, a memoir, photographs)?
(*) Who (or what kinds of sources) do you hope to interview (or rely on) for the story?

Story Checklist

The story must include:

  1. First-hand research involving historical records, photographs, news articles, museum artifacts or similar materials.
  2. Comments from a) someone involved in the original issue or events and b) an expert who is familiar with the issue or events and can provide context. (Ideally, the comments from the person involved in the original events will come from an interview you conduct. If you are writing about the 1970s or later, you should be able to track down someone from that period to interview. If everyone is dead, you will need to turn to written or audiovisual resources.)
  3. At least one photo or other illustration to accompany the story. It might be an archival photo or one that you have taken.
  4. Copies of two pieces of documentation gathered during research for your story (not more than one or two pages apiece).
  5. For EACH of the two pieces of documentation, full-sentence answers to these questions:

(*) What is the documentation?
(*) How did you find/obtain it?
(*) Why was the documentation helpful?

Backstory: Frequently Asked Questions

Q: How do I hand in my assignment?
A: Upload everything – including documents and answers to the three questions – to the relevant “category” of the syllabus (InvestigativeJournalism2025_2). Save it as a draft. It doesn’t matter what format you choose, but most supporting material should be in PDF, .jpeg or Word format. You can also use DocumentCloud to upload pages of your records to the syllabus.

Q: Can I write about non-Canadian events?
A: No.

Q: Does my topic have to be a national issue?
A: No, it could be a provincial or local one.

Q: Can I just revisit any interesting episode from the past?
A: No, there has to be a reason you’re writing about this subject – a clear and substantial connection to something happening today. For instance, given the negotiation to build an NHL arena on Ottawa’s LeBreton Flats, you might do a story about the history of the neighbourhood. Another idea would be to look at the origins of skating on the Rideau Canal, given the annual Winterlude festival with plenty of skaters. (DON’T DO THESE ACTUAL TOPICS. You will find something more original.)

Q: Could my current news peg be an anniversary?
A: Yes, but it should be a natural milestone, such as the 50th, 75th or 100th anniversary. It would be even better if there is some evidence the anniversary is being celebrated or publicly marked in some way.

Q: I am writing about events that took place 100 years ago and everyone involved is dead. Will that work?
A: Yes, that’s fine, and it’s why I have made it optional to interview someone involved in the original events. But perhaps you will find a diary entry or autobiography quotation that will help bring a deceased person’s voice into the story. And if your story involves events from 40 or even 50 years ago, I would hope you could track someone down from the era to interview.

Q: What sort of documentation do you want?
A: It could be almost anything that helped you do the story: a photo of a relevant page from a memoir, a page from an archival record, a telephone or email listing that helped you find someone to interview, an excerpt from an interview transcript – the choice is yours.

Q: Could my illustration(s) accompanying the piece double as my documentation?
A: Quite possibly, if they helped you do the story. Be sure you have permission to post the photos or other illustrations from each rights holder or creator.

Dollars and Sense story  (TOP)

A news story based on the financial records of an institution. 600 words, due Sun., March 16, noon. (An outline is due Friday, March 7, 11: 59 p.m.) 

 What is required?

1) A news story about any aspect of a publicly traded company making headlines, including grocery store chains, oil and gas companies and financial institutions such as banks.

2) The story MUST come from the financial statement: a calculation you’ve made using numbers  in the statement.

3) Upload the story in draft format to the “InvestigativeJournalism2025__3″ category. 

4) AT LEAST two interviews: One with an expert; the second with an individual with a direct connection to the specific program or program area at the heart of the story. For instance, the latter could be a person, group or institution impacted by the company’s financial difficulties or success. The former could be an economist or a university or college professor who studies the corporation.

What do you need for the initial draft on March 7?

In an email, a one- or two-sentence  lede, followed by a point-form ( no more than six bullet points) explanation that contains the following:  your company, the financial record(s), where you see the story heading; a possible Statistics Canada table(s) for additional context; possible interviewees.

The information described above MUST be contained in an email and in point-form. Keep it tight.

What’s to be submitted on March 16, noon?

1) An emailed, 500-word explanation in a Word document that briefly explains — in point form, even — the steps you took to get the story, the coordinates of your interviewees (email address; email, etc.) and the people you attempted to interview.

2) An Excel sheet with your calculations emailed as an attachment. Please ensure that all the tables (possibly from different datasets) are in ONE Excel workbook.

3) In addition to uploading the story to the “InvestigativeJournalism2025__3″ category on our website, a Word document with your actual story, which will contain my feedback.

4) The uploaded story to the website MUST have at least two visualizations: one must be a visualization similar to what was required for my previous assignment. It can be done in Tableau, or Datawrapper, and doesn’t have to be a dashboard. A simple line or bar graph embedded in your post as an interactive graphic (not a jpg) will do. The graph could be the company’s stock prices; it’s profit or revenue over two similar quarters, etc. The second visualization must be a photograph — with cutline and source citation — of an individual in your story. It’s best to ask for a recent photo during your interview. When laying it out, make sure it is easy to see, which means column-width.
You MUST also upload your financial statement(s) and other possible documents to DocumentCloud and provides hyperlinks to the annotated sections.

Dollars and Sense Story Questions and Answers

Q: Can I choose any company?
A. Yes. 

Q: What company record do I need?
A: A publicly traded company’s most recent financial statement. Many companies and financial institutions such as banks are releasing their quarterly reports. So, you should have access to lots of fresh material.

Q: What financial statements do I need?
A: At least two: the most recent quarterly report; and the accompanying management’s discussion and analysis, which must be read in conjunction with the numbers in the quarterly report. Others could include a proxy circular – described on page 214 of Digging Deeper – that contains information such as executive pay; or a news release which typically plays up the positive news like revenue and downplays negative news such as shrinking profits or losses.

Q: How can I tell a story about a company whose financial situation has already made news?
A:  The key is context. In the case of grocery stores facing charges of “greedflation”, you could analyse profits before and during the pandemic to see if the criticisms hold true, and then tap into a discussion among some opposition politicians such as the NDP and economists and other experts who debate whether these companies are making excessive profits on the backs of consumers. The same could be said for oil and gas companies, or banks.

Q: Can I also use public records in addition to the company’s financial statements for context?
A: Yes. The public records we have already studied would be good starting points. Or records similar to the ones you cited in your data-visualization assignment.

Q: What kind of story are you looking for?
A: The idea is to keep it simple. As was the case with the data-visualization assignment, select ONE number from the financial statement: profit or losses; operating profits; cash on hand; revenues, etc. Look at how the number is behaving compared to the same quarter in the previous year and explain why the number is going up, down, or staying the same. Now, of course, to select the best number, you may have to review several of them, as was the case with the Consumer Price Index.

Q: Typically, where can I find these numbers?
A: In the company’s balance sheets we will review and analyze in class.  As we have discussed, begin with the tables. 

Q: So, you’re not looking for an analysis of the financial statement?
A: No! For the most part, financial statements can jargon-filled and difficult to understand. So, PLEASE keep it simple. Select one number from the balance sheet, as we will discuss in class, and find as much context for that number, beginning with the management’s discussion and analysis which — as discussed in Digging Deeper — accompanies the quarterly filing. Then, you might broaden the context to other previously mentioned public records.

Q: So, this story can be a lookback?
A: Yes. By their very nature, recently-released financial statements are snapshots in time, three months in the case of a quarterly or interim financial statement, 12 months in the case of an annual report, which also doubles as a fourth-quarter report. What you’re looking for is fresh information providing context about an aspect of the company’s business during the period in question.

Q: Can the story also look ahead?
A: Yes. Typically, financial statements will discuss future challenges in the management’s, discussion & analysis section, which is discussed on pp. 213-2014 of Digging Deeper’s Following the Money chapter.

Q: Can you provide an example?
A:  For instance, Air Canada’s management discussion and analysis report might weigh in on the effect  high fuel prices could have on its bottom line. Or a grocer could discuss challenges of keeping prices below the rate of inflation, given public anger over the high price of food.  Or a automaker might express concern about U.S. tariffs.

Q: Can I use Statistics Canada information such as job numbers and inflation for additional context?
A: Absolutely! One of the goals of this assignment is to follow the analysis and research we conducted with digging into the inflation numbers. If you are discussing a company’s fourth quarter, which could be the last three months of 2024, you’d want to use tables that measure unemployment or the impact on industrial sectors or the price of certain items for that time period to provide additional context. In short, feel free to build on the work you did for the data-visualization assignment.

Q: Can a visualization be Statistics Canada’s inflation numbers for commodities that relate to my company’s business such as food or gas?
A: Yes, in fact, I would encourage this, as it would allow you to build on the skills you developed dong the data-visualization assignment. 

Q: Must the story emerge from the numbers in the financial statement?
A: YES!!!!

Q: So, I don’t have to read the entire financial report?
A: Absolutely not! Just find a key number in a table, and information in the financial statement — contained in a note, or the management’s discussion & analysis — that puts the number into context.

Q: I need at least two interviews for my story, and one must be an expert. Can you give me an example?
A: Yes, at least one of them must be an expert. That individual can be business prof., an economist with a bank or think tank. In short, someone who is neutral and knowledgeable about the company. The expert CAN NOT be an advocate who is known to be a critic of the company you are profiling, or a union official who represents the workers.

Q: What if I have trouble contacting people?
A: To be on the safe side, avoid relying on a limited number of sources. The wider and earlier you cast your net, the better. And avoid waiting until the last minute by exercising good time management. Start with the obvious: people affected by the company in question, customers, clients, etc. post-secondary institutions such as Carleton or the University of Ottawa have business departments. Check them out for experts who have studied the company in question. Banks have economists who follow various sectors. Check out the so-called “notes” or reports they publish after their companies have released their latest filings. 

Q: Must I interview a company representative?
A: Certainly try.  Failing an interview, a written statement will do. Failing that, just point out in the story the company neglected to respond to requests for an interview or comment. And then try to find what the company has said publicly in a news release, in a recorded interview, or a recording of an earnings discussion with investors and journalists posted on the company’s website. Or you could find out if a company executives testified before MPs or Senators studying the possible connection between inflation and rising prices for commodities such as food. Finally, you could also find detailed explanations in the management’s discussion and analysis, which is why you MUST start your analysis by reading key parts of this document.

Q: Can I accept an emailed statement as one of the interviews?
A: Yes, but ONLY if it is a company official. And only after you have pushed for something in-person. If you are stuck with a statement, be sure to set it up in the story by pointing out that the official in question refused an interview, choosing instead to issue a statement that avoided answering the question. Then, be sure to paraphrase and quote selectively from the statement, if at all. In short, no long, boring, jargon-laden statements that say nothing, but give the appearance of accountability.

Q: Must I provide hyperlinks to the financial statement annotation in my story?
A: Yes. This is a MUST. This allows readers to quickly locate and digest the source of your information from the type of primary records discussed in Digging Deeper.

Q: Will I be deducted marks for neglecting to upload and annotate my documents?
A: Yes. At least half a grade. 

Q: Is it important to properly cite the source of my analysis?
A: Absolutely. This is crucial. The key number cited in your lede should be “according to an analysis of company X’s most recent quarterly report.”

Q: Will I lose a mark for neglecting to cite the source of my analysis?
A: Yes, half a grade.

Q: Do I have to publish the story?
A: Initially, make sure it’s in draft format. Once it is marked, and approved for publication, feel free to make the suggested changes, then publish.

Q: Can I use a video excerpt of testimony at a House of Commons committee?
A: Yes, the most multimedia elements such as video, graphics such as the ones you produced for your data-visualization assignment.

Q: After receiving the green light to publish, can I also offer it to Capital Current?
A:  Yes.

Access-to-Information assignment  (TOP)

An exercise involving preparation and submission of original freedom-of-information requests to all levels of government, due Sun., March 23, noon. (Requests must be filed by Thu., Feb. 13.)

Assignment checklist

  1. Copies of one original request to EACH of the three levels of government (municipal, provincial-territorial, federal).
  2. Proof of one request for previously released records from the federal government (e.g. an email reply or receipt indicating you have made the request).
  3. Copies of correspondence received/sent by you during the course of each of the four above-noted requests (municipal, provincial, federal, previously released federal records)
  4. A few lines detailing what you have done to track the progress of each of the four requests, including the status of each as of end of day Fri., March 21.
  5. Copies of at least two – but not more than five – particularly relevant pages of information from a previously released set of records from any ONE level of government.
  6. For the pages in (#5) above, full-sentence answers to these questions:
    (*) What is the information?
    (*) From which government and department (or other public body) did these pages come?
    (*) How would these records be helpful in researching or writing a story? Please try to highlight relevant facts or passages in the records using DocumentCloud.

Access-to-information requests must be filed by Thu., Feb. 13.
Assignment due Sun., March 23, noon.

Access-to-information assignment questions and answers

Q: How do I hand in my assignment?
A: Upload everything – including documents and answers to the three questions – to the relevant “category” of the syllabus (InvestigativeJournalism2025_4). Save it as a draft. It doesn’t matter what format you choose, but most supporting material should be in PDF, .jpeg or Word format. You can also use DocumentCloud to upload pages of your records to the syllabus.

Q: Do all of my requests have to be on the same topic?
A: No. Request whatever records you might find useful.

Q: Do you want every piece of correspondence related to the four requests?
A: I want to see all relevant correspondence to help me understand how things proceeded.

Q: I dealt with agencies largely on the phone. What should I do?
A: Please give me dates and brief summaries of these calls wherever possible.

Q: I forgot to make copies of my requests. What should I do?
A: Please try to recreate the wording and date of your original requests as best you can.

Q: Can #5. and #6. on the above checklist be based on previously released pages that I find online?
A: Yes, though the pages must come from a site administered by a municipal, provincial, territorial or federal government.

Q: So, I don’t necessarily have to analyze previously released federal documents?
A: That’s correct. Although you must request some previously released federal documents, you may not actually receive the copies in time to analyze them. So, for example, you can simply download some previously released records from one of the provincial or federal sites that make actual documents available, as demonstrated in class, and analyze those.

Q: I received some records in response to one of my original requests. Can I analyze those records for the assignment?
A: Yes, you are welcome to analyze those records for the assignment if they are suitably newsworthy.

As we have discussed, you should receive 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 arrive within a week or 10 days.
(*) Many of you will also receive time-extension or fee-assessment letters.
(*) 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.

Remember, as outlined on the checklist, you will also need to obtain and analyze some previously released records from any level of government. As you will recall, several provincial and federal sites provide actual copies of releases for immediate download, so everyone will be able to easily find such records.

Here is an example of what I expect in the way of analysis, using the example of RCMP records.

A link to excerpts from the documents with a few relevant annotations: https://www.documentcloud.org/documents/6818659-Ortis-RCMP-ATIPs.html

(*) What is the information?
These are emails and memos about the arrest of RCMP employee Cameron Jay Ortis, who was charged under the Security of Information Act.

(*) From which government and department did these pages come?
The records are from the RCMP, a federal agency.

(*) How would these records be helpful in researching or writing a story? Please try to highlight relevant facts or passages in the records.
The records reveal behind-the-scenes information that could form the basis of a news story about the Ortis case, giving readers a sense of the anxiety within the RCMP about his arrest.

The documents show that after the shocking apprehension of one of their own on national-secrecy charges, rank-and-file Mounties were encouraged to get counselling if needed, decline to speak with the media and avoid the headquarters venue where a news conference on the case was taking place.

Week One (TOP)

Class recording
https://www.youtube.com/watch?v=y8XVU_n_Vro

What you will learn

What the course is all about;
The basics of access to information;
How to make an access-to-information request.

5206-25-PowerPointOne

5206-25-PowerPointTwo

Links

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.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/sfgei-srgfff-eng.asp#A

Access to Information: general info
https://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/index-eng.asp

Access to Information request service
https://atip-aiprp.tbs-sct.gc.ca/

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/corporate/promo/information-access-and-privacy.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: Search previously released (disclosed) information from a Freedom of Information and Protection of Privacy (FOIPOP) request – Government of Nova Scotia

The Right to Know Coalition of Nova Scotia
https://www.facebook.com/righttoknowns/

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/

Saskatchewan
http://www.saskatchewan.ca/residents/justice-crime-and-the-law/your-rights-and-the-law/make-a-freedom-of-information-request

Yukon
Main: https://yukon.ca/en/legal-and-social-supports/legal-services/request-access-information-records
Proactive disclosure: https://open.yukon.ca/

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: https://www.halifax.ca/city-hall/accountability-transparency/access-information
Completed requests: https://www.halifax.ca/city-hall/accountability-transparency/access-information/completed-requests

Hamilton
https://www.hamilton.ca/city-council/city-clerks-office/freedom-information-privacy-protection

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/access-information

Toronto
https://www.toronto.ca/city-government/accountability-operations-customer-service/access-city-information-or-records/freedom-of-information/
Completed requests: https://open.toronto.ca/dataset/freedom-of-information-requests-summary/

Vancouver
Main: http://vancouver.ca/ctyclerk/foi/index.htm
Completed requests: http://vancouver.ca/your-government/information-released-through-foi-requests-this-year.aspx
Vancouver police – completed requests: Published Freedom of Information Requests – Vancouver Police Department (vpd.ca)

Winnipeg
Main: http://winnipeg.ca/clerks/fippa/
Completed requests: https://data.winnipeg.ca/Organizational-Support-Services/Fippa-Request-Responses/pfbi-rm6v

COMPLETED ACCESS REQUESTS

Federal departments and agencies
https://open.canada.ca/en/search/ati

Library and Archives Canada
Search and download completed Access to information requests on archival records

National Capital Commission
https://ncc-ccn.gc.ca/access-to-information-requests-disclosure-copies

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

Regina (Note: not all are freedom-of-information responses) http://open.regina.ca/group/freedom-of-information

Ottawa
https://ottawa.ca/en/city-hall/accountability-and-transparency/accountability-framework/freedom-information-and-protection-privacy/disclosure-mfippa-requests

Nova Scotia
https://informationaccess.novascotia.ca/

Newfoundland
http://atipp-search.gov.nl.ca/

U.S. State Department
https://foia.state.gov/Search/Search.aspx

U.S. Customs and Border Protection
https://www.cbp.gov/site-policy-notices/foia/reading-room

Week Two (TOP)

Class recording
https://www.youtube.com/watch?v=nfegpuvxC2k

What you will learn

More on crafting an access-to-information request;
Requesting previously released records;
Details of the access-to-information assignment.

5206-25-PowerPointThree

Links

“TIP OF THE ICEBERG” RESEARCH

Proactive disclosure global list
https://open.canada.ca/en/proactive-disclosure

Question period notes
https://search.open.canada.ca/qpnotes/

Publications global list
https://publications.gc.ca/site/eng/weeklyAcquisitionList/lists.html?sy=2023

House of Commons publication search
https://www.ourcommons.ca/PublicationSearch/en/

Departmental reports (this one is for Public Safety Canada, but departments have their own, usual under Transparency or Publications and Reports)
https://www.publicsafety.gc.ca/cnt/rsrcs/pblctns/index-en.aspx?t=dprtmntl

Transparency (this one is for the Treasury Board Secretariat, but many departments have a Transparency link on homepage)
https://www.canada.ca/en/treasury-board-secretariat/corporate/transparency.html

Public opinion reports
https://library-archives.canada.ca/eng/services/government-canada/public-opinion-research/search-report/Pages/search-report.aspx

House of Commons sessional papers directly from the Library of Parliament catalogue
https://parl-gc.primo.exlibrisgroup.com/discovery/search?query=any,contains,%3F&tab=SESSIONAL&search_scope=SESSIONPAP&vid=01CALP_INST:01CALP&lang=en&offset=0

Week Three (TOP)

Class recording
https://www.youtube.com/watch?v=rzp9s0fN2tA

What you will learn

The concept of open data;
How to download Statistics Canada’s Consumer Price Index dataset and building pivot tables;
How to use the same techniques to analyze data on other open-data sites;
Preliminary discussion of the data-visualization assignment.

Links

 

Open Government
https://open.canada.ca/en

Canada’s inflation rate ticks down to 1.8% with help from GST holiday
https://financialpost.com/tag/inflation/

Canadas inflation rate ticks down to 1.8 per cent with help from GST holiday.pdf

Consumer Price Index: Interactive app
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm

Consumer Price Index, December 2024
https://www150.statcan.gc.ca/n1/daily-quotidien/250121/dq250121a-eng.htm

Week Four (TOP)

Class recording
https://www.youtube.com/watch?v=Tyc5Ub5Io4Q

Tableau line graph tutorial
https://www.youtube.com/watch?v=7hh2_-QVZXE

What you will learn

Continuation of data analysis using Statistics  Canada’s Labour Force Survey data;
How to upload tables to Tableau Desktop;
How to upload public documents to DocumentCloud.
Review the data-visualization assignment.

Links

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
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410028701

Week Five (TOP)

What you will learn

Continuation of data visualization discussion and instructions for uploading content to WordPress;
Introduction to historical records;
Exploring archival resources.

Links

Fourth tutorial on creating an extract in Tableau
https://www.youtube.com/watch?v=oAps8yMV7II

Uploading documents to DocumentCloud tutorial
https://www.youtube.com/watch?v=i_d0zsw6hhQ&feature=youtu.be

HISTORICAL RESEARCH

5206-25-PowerPointFour.ppt

Backstory examples

Ottawa’s last total solar eclipse was in 1979 — it was a total letdown
https://ottawacitizen.com/news/local-news/ottawas-last-total-solar-eclipse-in-1979-was-a-total-letdown

This isn’t the first time American leaders have suggested annexing Canada
https://www.cbc.ca/news/canada/newfoundland-labrador/canada-annex-america-1.7434523

Scraps, Stickwork and Star Power: A look back at the first official NHL all-star game
https://www.thecanadianpressnews.ca/sports/scraps-stickwork-and-star-power-a-look-back-at-the-first-official-nhl-all-star/article_21554b52-611a-57f0-a279-d54d746305bf.html

‘We won’t give up until prices come down’: How Ontarians protested grocery stores in 1966
https://www.tvo.org/article/we-wont-give-up-until-prices-come-down-how-ontarians-protested-grocery-stores-in-1966

51 years ago, a railway strike led to the most ‘explosive’ alcohol-fuelled ‘rampage’ on Parliament Hill
https://ottawacitizen.com/news/politics/51-years-ago-a-railway-strike-led-to-the-most-explosive-alcohol-fuelled-rampage-on-parliament-hill/wcm/70c8951c-e7bc-480f-bede-c371e8037741?taid=66c77d961f937b0001378402&utm_campaign=trueanthem&utm_medium=social&utm_source=twitter

Links

City of Ottawa archives
City of Ottawa Archives | City of Ottawa

Historical Hansard
http://parl.canadiana.ca/
https://www.lipad.ca/

Early Canadiana
http://online.canadiana.ca/

CBC Digital Archives
http://archives.cbc.ca/

Globe and Mail, Ottawa Citizen, Toronto Star historical databases available through Carleton’s library
https://library.carleton.ca/find/news/news-databases

Newspaper database
http://www.newspapers.com

Library and Archives Canada
http://www.bac-lac.gc.ca

LAC Ask Us a Question
https://library-archives.canada.ca/eng/services/public/ask-us-question/pages/ask-us-question.aspx

ArchivesCanada.ca: Gateway to Canada’s past
https://archivescanada.accesstomemory.ca/

Canada Year Book – historical collection
https://www65.statcan.gc.ca/acyb_r000-eng.htm

Toronto Public Library Digital Archive
https://digitalarchive.tpl.ca

University of Calgary digital collections
https://digitalcollections.ucalgary.ca/

Internet archive
http://archive.org

Week Six (TOP)

Class recording
https://www.youtube.com/watch?v=Ff_1QXWFFY4

What you will learn

How much useful information you have soaked up, via our first quiz;
Elements of storytelling, including how to write a good lede.
Fielding questions about the access-to-information requests that must be filed by Feb. 13, midnight.

5206-25-PowerPointFive-5.pptx

Links

LEDE WRITING

Results from Town of Erin’s Monopoly night are in and the community has spoken
https://www.orangeville.com/news/results-from-town-of-erins-monopoly-night-are-in-and-the-community-has-spoken/article_17722988-b3c9-5078-a5e6-f6fcea7cebaa.html

Sign of the times: Planning Act notices will no longer be mailed
https://www.barrietoday.com/local-news/sign-of-the-times-planning-act-notices-will-no-longer-be-mailed-10188582

With a player on each 4 Nations roster, Panthers will soon have another champion
https://www.sportsnet.ca/nhl/article/with-a-player-on-each-4-nations-roster-panthers-will-soon-have-another-champion

Telescopes spy a monster radio jet streaming from a bright and early object in the universe
https://halifax.citynews.ca/2025/02/06/telescopes-spy-a-monster-radio-jet-streaming-from-a-bright-and-early-object-in-the-universe/

Super Bowl Food: Delicious recipe ideas for Chiefs vs. Eagles game
https://www.toronto.com/things-to-do/food-and-drink/super-bowl-food-delicious-recipe-ideas-for-chiefs-vs-eagles-game/article_48f417ea-b0b7-578f-bfff-4593cd26cfe1.html

Patriotic Ontario pilot creates massive maple leaf in the sky to send message to U.S.
https://www.cbc.ca/news/canada/london/ontario-pilot-maple-leaf-drawn-on-flight-path-1.7452626

STORY FLOW

Confusion and backlash over City of Edmonton’s neighbourhood renewal plans
https://globalnews.ca/news/11010095/backlash-edmonton-neighbourhood-renewal-plans/

Ongoing road, sidewalk reconstruction work frustrates Ottewell residents
https://www.ctvnews.ca/edmonton/article/ongoing-road-sidewalk-reconstruction-work-frustrates-ottewell-residents

Week Seven (TOP)

Class recording
https://www.youtube.com/watch?v=lY6LviYsZEs

What you will learn

Feedback on data-visualization assignment;
The basics of following money;
The difference between a publicly traded corporation and private company;
How to find out how much a company made;
How to find key numbers in a financial report.

Links

NDP study into greedflation and rising grocery costs to hear from grocery executives
https://www.ndp.ca/news/ndp-study-greedflation-and-rising-grocery-costs-hear-grocery-executives

Grocers called back to Parliament to testify about plans to stabilize prices
https://www.cbc.ca/news/politics/grocers-called-back-to-ottawa-1.7005942

Standing Committee on Agriculture and Agri-Food
https://www.ourcommons.ca/documentviewer/en/44-1/AGRI/meeting-87/evidence

Loblaw corporate filings uploaded to DocumentCloud
https://www.documentcloud.org/projects/26991-corporate-filings/

Loblaw third quarter 2023 uploaded to DocumentCloud
https://www.documentcloud.org/documents/24172412-lcl_q3_2023_fs/#document/p2/a2625265

Loblaw third quarter 2024 uploaded to DocumentCloud
https://www.documentcloud.org/documents/25545956-lcl-q3-2024-fs/

SEDAR search
https://www.sedarplus.ca/landingpage/

Politicians are pushing pipelines amid tariff threats. But companies are past that
https://www.nationalobserver.com/2025/02/14/analysis/politicians-pipelines-companies-tariffs

Trump wants Keystone XL Pipeline revived — but is there industry appetite for it?https://globalnews.ca/news/11034052/trump-says-he-wants-keystone-xl-pipeline-to-be-built/

National Bank, BMO and Scotiabank: A breakdown of the big banks’ first-quarter earnings so far
https://www.theglobeandmail.com/business/article-canada-banks-earnings-first-quarter-2025/
http://www.davidmckie.com/National Bank, BMO and Scotiabank_Globe and Mail.pdf

Scotiabank and BMO plan for tariff hits to Canada’s economy as a potential trade war escalates tensions with U.S.
https://www.theglobeandmail.com/business/article-scotiabank-and-bmo-plan-for-tariff-hits-to-canadas-economy-as-a/

Scotiabank and BMO plan for tariff hits…tensions with U.S.pdf

RBC quarterly and annual reports
https://www.rbc.com/investor-relations/financial-information.html
https://www.rbc.com/investor-relations/index.html

RBC annual report uploaded to DocumentCloud
https://www.documentcloud.org/documents/25545926-rbc-2024-fourth-quarter-annual-report/

BMO’s first-quarter profit jumps as Scotiabank reports drop
https://globalnews.ca/news/11033811/bmo-scotiabank-q1-earnings-2025/

BMO news release
https://newsroom.bmo.com/2025-02-25-BMO-Financial-Group-Reports-First-Quarter-2025-Results

BMO’s tariff concerns
https://newsroom.bmo.com/2025-02-25-BMO-Financial-Group-Reports-First-Quarter-2025-Results#:~:text=The%20provision%20for%20credit%20losses%20on%20performing%20loans%20in%20the%20current%20quarter%20was%20largely%20driven%20by%20the%20impact%20of%20the%20uncertain%20economic%20environment%2C%20including%20potential%20tariffs%2C%20on%20future%20credit%20conditions%2C%20and%20portfolio%20credit%20migration%2C%20partially%20offset%20by%20lower%20balances%20in%20certain%20portfolios.

BMO investor relations
https://www.bmo.com/en-ca/main/about-bmo/banking/investor-relations/home/

BMO Financial Group Reports First Quarter 2025 Results
https://www.documentcloud.org/documents/25545929-bmo-financial-group-reports-first-quarter-2025-results/?mode=document

SEDAR
https://www.sedarplus.ca/landingpage/

Week Eight (TOP)

Class recording
https://www.youtube.com/watch?v=HH9c1rQiowc

What you will learn

A continuation of the fundamentals of following money;
Discussion of dollars and sense assignment;
Learning how to ready proxy circulars;
Discussion of federal economic statements, budgets and public accounts;

Links

Albertans rocked by the sharpest increases in power bills so far this decade, Statscan data show
https://www.theglobeandmail.com/business/article-albertans-rocked-by-the-sharpest-increases-in-power-bills-so-far-this/#:~:text=Albertans%20experienced%20far%20and%20away,40%20per%20cent%20in%20Alberta.

Albertans rocked by the sharpest increases in power bills so far this decade, Statscan data show – The Globe and Mail.pdf
http://www.davidmckie.com/Albertans rocked by the sharpest increases in power bills so far this decade, Statscan data show – The Globe and Mail.pdf

Loblaw’s Galen Weston Jr. winner of Leadnow’s Canadian Profiteer of the Year Awards
https://docs.google.com/document/d/11VpxIvkn_fkWDQNPAgrmHxVetaSoblikAVqe87jtyhE/edit?tab=t.0#heading=h.7yh4nvtuz606

RBC 2024 (Management) Proxy Circular
https://www.rbc.com/investor-relations/_assets-custom/pdf/2024englishproxy.pdf

RBC 2024 (Management) Proxy Circular uploaded to DocumentCloud
https://www.documentcloud.org/documents/25551096-2024proxycircular-rbc-eng/

Federal budget 2024
https://budget.canada.ca/home-en.html
https://budget.canada.ca/2024/home-accueil-en.html
https://www.documentcloud.org/documents/25100898-budget-2024

2024 Fall Economic Statement
https://www.budget.canada.ca/update-miseajour/2024/home-accueil-en.html?utm_campaign=fin-fin-update-miseajour-24-25&utm_medium=vanity-url&utm_source=canada-ca_fall-economic-statement

2024 Fall Economic Statement uploaded to DocumentCloud
https://www.documentcloud.org/documents/25551076-2024-fall-economic-statement/

Public Accounts of Canada
https://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/index-eng.html

2024 Public Accounts, Vol 1, uploaded to DocumentCloud
https://www.documentcloud.org/documents/25551080-20204-public-accounts-vol-1/

2024 Public Accounts, Vol 2, uploaded to DocumentCloud
https://www.documentcloud.org/documents/25551088-20204-public-accounts-vol-2/

Lost federal revenue, property, money jumps to $649.5-million in 2023-24: Public Accounts
https://www.hilltimes.com/story/2025/01/13/lost-federal-revenue-property-money-jumps-to-649-5-million-in-2023-24-public-accounts/447251/

Lost federal revenue, property, money jumps to 649.5-million in 2023-24 – Public Accounts.pdf

Public Accounts, Vol 3, uploaded to DocumentCloud
https://www.documentcloud.org/documents/25551089-20204-public-accounts-vol-3/

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/

http://www.davidmckie.com/Cases up, costs down – feds report $227.1-million in lost revenue, public money and property in 2021-22.pdf

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

Office of the Parliamentary Budget Officer
https://www.pbo-dpb.ca/en

Resources

Week Nine (TOP)

Class recording
https://www.youtube.com/watch?v=8KuZt1mnxWo

What you will learn

Mining public records including coroners’ reports and tenders;
Finding and analyzing previously released freedom-of-information records;
Backstory feedback.

Links

Royal Bank of Canada Management Proxy Circular Now Available
https://www.rbc.com/newsroom/news/article.html?article=125984

2025 Annual and Special Meeting of Common Shareholders
https://www.rbc.com/investor-relations/annual-meetings.html

Canadian bank CEOs received pay increases in 2024 — except for these two
https://financialpost.com/fp-finance/banking/canadian-bank-ceos-pay-increases

RBC paid CEO $26-million last year, including an award for HSBC Canada acquisition
https://www.theglobeandmail.com/business/article-rbc-paid-ceo-25-million-last-year-including-an-award-for-hsbc-canada/

RBC paid CEO 26-million last year, including an award for HSBC Canada acquisition – The Globe and Mail.pdf

Budget watchdog projects $50.1-billion deficit for fiscal year ending March 31
https://www.theglobeandmail.com/politics/article-pbo-federal-budget-projection-outlook/

Budget watchdog projects 50.1-billion deficit for fiscal year ending March 31 – The Globe and Mail.pdf

Parliamentary Budget Office
Economic and Fiscal Outlook – March 2025
https://www.pbo-dpb.ca/en

Canada hits U.S. with tariffs on $29.8B worth of goods after Trump slaps levy on metals
https://www.cbc.ca/news/politics/canada-retaliatory-tariffs-1.7481258

Statistics Canada release schedule
https://www150.statcan.gc.ca/n1/dai-quo/cal1-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

International merchandise trade for all countries and by Principal Trading Partners, monthly 
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210001101

International trade monthly interactive dashboard
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2020013-eng.htm

Merchandise imports and exports, customs-based, by free trade agreement and by commodity
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1210017401

Canada-U.S. Trade Tracker
https://businessdatalab.ca/canada-u-s-trade-tracker/

Evaluating the potential impacts of US tariffs
https://www.bankofcanada.ca/publications/mpr/mpr-2025-01-29/in-focus-1/

Market Snapshots – The Canada Energy Regulator
https://www.cer-rec.gc.ca/en/data-analysis/energy-markets/market-snapshots/index.html
https://www.cer-rec.gc.ca/en/data-analysis/index.html

Office of the Auditor General of Canada
https://www.oag-bvg.gc.ca/internet/English/admin_e_41.html

Financial Accountability Office of Ontario
https://fao-on.org/en/

Office of the Auditor General of Ontario
https://www.auditor.on.ca/

Office of the Auditor General – City of Ottawa
https://www.oagottawa.ca/

AG report reveals city parks workers spending less time working than they say they are
https://www.cbc.ca/news/canada/toronto/toronto-park-workers-gps-tracking-report-1.7345991

Audit of Parks Branch Operations – Phase 1 Improving Oversight of Day-to-Day Maintenance Helps to Ensure City Parks are Beautiful, Clean and Safe
https://www.torontoauditor.ca/report/audit-of-parks-branch-operations-phase-1-improving-oversight-of-day-to-day-maintenance-helps-to-ensure-city-parks-are-beautiful-clean-and-safe/

City of Toronto Auditor General
https://www.torontoauditor.ca/

CanadaBuys
https://canadabuys.canada.ca/en

Search Government Contracts over $10,000
https://search.open.canada.ca/contracts/

Office of the Chief Coroner and the Ontario Forensic Pathology Service
https://www.ontario.ca/page/office-chief-coroner-and-ontario-forensic-pathology-service

Coroner’s report on B.C. heat-dome deaths calls for greater support for populations at risk
https://www.cbc.ca/news/canada/british-columbia/bc-heat-dome-coroners-report-1.6480026

BC heat-dome deaths investigation findings uploaded to DocumentCloud
https://www.documentcloud.org/documents/22074225-extreme_heat_death_review_panel_report/#document/p3/a2378687

BC Coroners Service
https://www2.gov.bc.ca/gov/content/life-events/death/coroners-service

Week Ten (TOP)

Class recording
https://www.youtube.com/watch?v=kwpOM72Xzuc

What you will learn

Public records, cont.: bankruptcies, public accounts, orders-in-council
Making sense of records received through access to information;
Decoding records, doing chronologies.

Links

Ignored warnings – Ottawa was told about loopholes and little oversight in its Indigenous procurement program – but grew it into a $1.6-billion operation that critics say is rife with shell companies
https://www.theglobeandmail.com/canada/article-ottawa-was-warned-about-problems-with-indigenous-procurement-but-grew/

Globe and Mail Indigenous procurement program investigation uploaded as a pdf

Indigenous groups press for greater say in Ottawa’s contracting policy rules
https://www.theglobeandmail.com/canada/article-indigenous-groups-press-for-greater-say-in-ottawas-contracting-policy/

Public Accounts of Canada 2024
https://www.canada.ca/en/public-services-procurement/services/payments-accounting/public-accounts/2024.html

Public Accounts 2024 Vol. three – professional services uploaded to DocumentCloud
https://www.documentcloud.org/documents/25597950-2024-vol3-ds3-eng/

Public Accounts Canada – open data
https://open.canada.ca/data/en/dataset/350b4f13-d84a-4e94-b221-1109dc00ab39

Hudson’s Bay files for creditor protection, intends to restructure
https://www.cbc.ca/news/business/hudsons-bay-creditor-protection-1.7477926

Hudson’s Bay says it will liquidate entire business if no financing can be secured
https://www.cbc.ca/news/business/hudson-s-bay-liquidation-funding-1.7484691

Hudson’s Bay Company ULC, the Operator of Hudson’s Bay Stores and TheBay.com, Initiates Restructuring Proceedings Under CCAA in Response to Canadian Retail Industry Challenges
https://www.businesswire.com/news/home/20250307260606/en/Hudsons-Bay-Company-ULC-the-Operator-of-Hudsons-Bay-Stores-and-TheBay.com-Initiates-Restructuring-Proceedings-Under-CCAA-in-Response-to-Canadian-Retail-Industry-Challenges

Office of the Superintendent of Bankruptcy
https://ised-isde.canada.ca/site/office-superintendent-bankruptcy/en

CCAA Records—Hudson’s Bay Company ULC
https://ised-isde.canada.ca/site/office-superintendent-bankruptcy/en/ccaa-records-search/ccaa-records-hudsons-bay-company-ulc

Court-Appointed Monitor for creditor protection request and possible bankruptcy
https://www.alvarezandmarsal.com/HudsonsBay

Hudson Bay factum uploaded to DocumentCloud
https://www.documentcloud.org/documents/25588960-hudsons-bay-et-al-factum-re-initial-order-march-7-2025/

Volume III, Section 3: Professional and special services –
https://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/2024/vol3/ds3/index-eng.html

Prime Minister announces the appointment of Canada’s new Fentanyl Czar
https://www.pm.gc.ca/en/news/news-releases/2025/02/11/prime-minister-appointment-canadas-new-fentanyl-czar#:~:text=The%20Prime%20Minister%2C%20Justin%20Trudeau,new%20Fentanyl%20Czar%2C%20effective%20immediately.

Orders in Council search
https://orders-in-council.canada.ca/index.php?lang=en

Kanesatake calling on feds to help decontaminate toxic dump site
https://www.ctvnews.ca/montreal/article/kanesatake-calling-on-feds-to-help-decontaminate-toxic-dump-site/

Access to Information: Decoding records

Government Electronic Directory Services
https://geds-sage.gc.ca/en/GEDS?pgid=002

Privy Council Office: Access to Information Act release
http://www.davidmckie.com/wp-content/uploads/2025/03/A-2024-00057-US-Border-Excerpt.pdf

Previously released freedom-of-information records: Search and download

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

Regina (Note: not all are freedom-of-information responses)
http://open.regina.ca/group/freedom-of-information

Nova Scotia
https://informationaccess.novascotia.ca/

Newfoundland
http://atipp-search.gov.nl.ca/

National Capital Commission
https://ncc-ccn.gc.ca/access-to-information-requests-disclosure-copies

Library and Archives Canada
Search and download completed Access to information requests on archival records

Week Eleven (TOP)

Class recording
https://www.youtube.com/watch?v=d6rcevX2No0

What you will learn

Dollars and Sense assignment feedback;
New database strategies;
Audits, plans, results.

Links

Foreign control in the Canadian economy: Visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2020024-eng.htm

Annual demographic estimates, census metropolitan areas and census agglomerations: Interactive dashboard
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2020003-eng.htm

New motor vehicle registrations: Quarterly data visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2021019-eng.htm

Statistics Canada – Data Visualization Products
https://www150.statcan.gc.ca/n1/en/catalogue/71-607-X

Mark Carney raised $4.5 million in two-month Liberal leadership race
https://www.ctvnews.ca/politics/liberal-leadership/article/mark-carney-raised-45-million-in-two-month-liberal-leadership-race/

Elections Canada – political financing searches
https://www.elections.ca/content.aspx?section=fin&document=index&lang=e

Sample Elections Canada political donation dataset to download
http://davidmckie.com/Federal contributions_Jan 1, 2023-March 26, 2025.zip

Delta Airline plane crash
https://x.com/TorontoPearson/status/1891577633747386756

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

https://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng

Grants and Contributions
https://search.open.canada.ca/grants/?search_api_fulltext=arctic+gateway&grants%5B0%5D=org_name_en%3AWestern+Economic+Diversification+Canada&sort=agreement_start_date+desc&search_text=%22Provincial+Emergency+Financial+Assistance%22&page=1

Federal contaminated sites inventory
https://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil-eng.aspx

Sample active contaminated site table (right-click and save the file in csv format)
http://davidmckie.com/FCSI_2025635_TombstoneData.csv

List of charities and other qualified donees
https://www.canada.ca/en/revenue-agency/services/charities-giving/list-charities/list-charities-other-qualified-donees.html

Security of Arctic waters

Canadian leaders are waking up to Arctic security urgency
https://nunatsiaq.com/stories/article/canadian-leaders-are-waking-up-to-arctic-security-urgency/

Prime minister: Reinforcing Canada’s security and sovereignty in the Arctic
https://www.pm.gc.ca/en/news/backgrounders/2025/03/18/reinforcing-canadas-security-and-sovereignty-arctic

November 2022: Auditor general’s report: Arctic waters surveillance
https://www.oag-bvg.gc.ca/internet/English/att__e_44160.html

Arctic waters surveillance: audit summary
https://www.oag-bvg.gc.ca/internet/English/parl_oag_202211_06_e_44152.html

2023: Standing committee on public accounts
https://www.ourcommons.ca/committees/en/PACP/StudyActivity?studyActivityId=11927510#

Fisheries: notes for public accounts committee appearance
https://www.dfo-mpo.gc.ca/transparency-transparence/briefing-breffage/2023/waters-pacp-eaux-eng.html

February 2023: Public accounts committee proceedings
https://openparliament.ca/committees/public-accounts/44-1/50/the-chair-1

March 2023: Public accounts committee proceedings
https://openparliament.ca/committees/public-accounts/44-1/51/bill-matthews-1

2023-24 Fisheries plans report
https://waves-vagues.dfo-mpo.gc.ca/library-bibliotheque/41099977.pdf

2023-24 Fisheries results report
https://www.dfo-mpo.gc.ca/drr-rrm/2023-24/index-eng.html

2024-25 Fisheries plans report
https://www.dfo-mpo.gc.ca/dp-pm/2024-25/index-eng.html

2024-25 departmental plans reports – all departments
https://www.canada.ca/en/treasury-board-secretariat/services/planned-government-spending/reports-plans-priorities/2024-25-departmental-plans.html

2023-24 departmental results reports – all departments
https://www.canada.ca/en/treasury-board-secretariat/services/departmental-performance-reports/2023-24-departmental-results-reports.html

Parliamentary petitions

Petition asking PM to revoke Elon Musk’s Canadian citizenship garners support
https://toronto.citynews.ca/2025/02/22/petition-asking-pm-to-revoke-elon-musks-canadian-citizenship-garners-support/

Musk petition
https://www.ourcommons.ca/petitions/en/Petition/Details?Petition=e-5353

Path of an e-petition
https://www.ourcommons.ca/petitions/Documents/poster-e.pdf

All recent parliamentary petitions
https://www.ourcommons.ca/petitions/en/Petition/Search?category=All

Environmental Petitions
https://www.oag-bvg.gc.ca/internet/English/pet_fs_e_919.html

Petitions by Federal Institution
https://www.oag-bvg.gc.ca/internet/English/pet_lp_e_940.html

Petitions by issue
https://www.oag-bvg.gc.ca/internet/English/pet_lp_e_941.html

Petitions by number
https://www.oag-bvg.gc.ca/internet/English/pet_lp_e_938.html

Submitting a petition
https://www.oag-bvg.gc.ca/internet/English/pet_fs_e_43424.html#details-panel2

Week Twelve (TOP)

Class recording
https://www.youtube.com/watch?v=y54AtuswwWQ

What you will learn

Access-to-information assignment feedback;
Self-assessment survey follow-up;
How well you prepared for our quiz;
Investigative Reporting and Beat Journalism tactics;
Sharing things you have learned.

Links

Ontario Sunshine List is out: see the top 100 public workers earning above $100K in 2024 here
https://www.cbc.ca/news/canada/toronto/2024-ontario-sunshine-list-1.7496114

Ontario’s sunshine list of $100K+ earners grows to record 377,666 public servants
https://www.thestar.com/politics/provincial/ontarios-sunshine-list-of-100k-earners-grows-to-record-377-666-public-servants/article_34fcca89-cf10-436a-83ae-389dce7454f6.html

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

Federal briefing note titles
https://search.open.canada.ca/briefing_titles

U.S. Freedom of Information portal
https://www.foia.gov/

Canada scrambled to figure out Trump ‘Muslim ban,’ U.S. documents show
https://www.cbc.ca/news/politics/canada-travel-ban-trump-confusion-1.4690283

Tutorials(TOP)

From week one

From week two

From week three

From week four

From week five

From week six

From week nine

From week ten

From week eleven

From week twelve

Datasets (TOP)

From week three

From week four

From week five

From week seven

From week eleven

From week twelve