Graduate Course 2015/2016 – Winter term
Wednesdays: 7:00 to 10:00 p.m.
Room 2311 River Building
David McKie
David McKie, CBC News
Phone: (O) 613-288-6523 (C) 613-290-7380
Jim Bronskill
Jim Bronskill, The Canadian Press
Phone: (O) 613-231-8653 (C) 613-859-3752 (fax) 613-238-4452
| Course Objectives | Needs and Special Accommodations | Assignments and Evaluation | Course Schedule | Link to a more detailed syllabus | Business Story | Whatever-happened-to? Story | Database Story | Access-to-information story | Week one | Week two | Week three | Week four | Week five | Week six | Week seven | Week eight | Week nine | Week ten | Week eleven | Week twelve |
Course Objectives
1) Obtain a thorough grounding in journalistic research methods.
2) Acquire skills, such as data-journalism reporting techniques, needed to make sense of the information gathered and filing access-to-information requests.
3) Develop the ability to shape the information into accurate and compelling stories.
Special needs and Accommodation (TOP)
You may need special arrangements to meet your academic obligations during the term. For an accommodation request the processes are as follows:
Pregnancy obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/
Religious obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/
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, contact your PMC coordinator to send us your Letter of Accommodation 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). After requesting accommodation from PMC, meet with one of us to ensure accommodation arrangements are made. Please consult the PMC website for the deadline to request accommodations for the formally-scheduled exam (if applicable) at http://www2.carleton.ca/pmc/new-and-current-students/dates-and-deadlines/
You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at http://www2.carleton.ca/equity/
School ethics policy:
http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/EthicsPolicy.pdf
School publishing policy:
http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/PublishingPolicy.pdf
School electronic media usage policy:
http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/media-usage-policy-2010.pdf
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. Each assignment has three components, all of which will figure in the grade:
A. Copies of the actual documents compiled / gathered (in paper or electronic form).
B. A description of how the documents were obtained, and why they were useful.
C. The resulting story.
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.
Final standing in this course is determined by the course instructors subject to the approval of the Dean of Public Affairs. This means that final grades submitted by the instructors may be subject to revision. No grade is final until it has been approved by the Dean.
Due Dates
1) Draft business story due Thu., Jan. 21, 12 p.m.
2) Business story due Sat. Jan 30, 10 a.m.
3) Draft Whatever-happened-to? story due Thu., Feb 11, 12 p.m.
4) Draft Database story due Thu., Feb 25, 12 p.m.
5) Whatever-happened-to? story due on Sat., Feb 27, 9 a.m.
6) Draft access-to-information story due Thu., March 10, 12 p.m.
7) Database story due Sat., March 12, 9 a.m.
8) Access-to-information story due Sat., March 21, 9 a.m.
Course Schedule (TOP)
Jan. 6: a. Course introduction b. Corporate / Business resources (Advanced Google searches, Researching companies, corporate filings, securities exchanges) c. Assignment: Business story
|| Reading: Digging Deeper, Chapters 1, 2, 9, Appendix C: Finance Facts, the Excel portion of chapter 11 and Appendix A: A Quick Guide to Spreadsheets
Note: To find the rest of the appendices, please click here.
Jan. 13: a. Corporate / Business resources (part two) b. Assignment: Whatever-happened-to? story c. One-on-ones / Research time
|| Reading: Digger Deeper, the rest of Chapter 11
Jan. 20: a. Draft business story due Jan. 21 at noon b. Databases (part one) c. One-on-ones / Research time
|| Reading: Digging Deeper, Chapters 4, 5
Jan. 27: a. Business story due on Jan. 30 at 10 a.m. b. Databases (part two) c. Assignment: Database story
Feb. 3: a. Introduction to Access to Information b. Assignment: Access-to-information story
|| Reading: Digging Deeper, Chapter 6
Feb. 10: a. Draft Whatever-happened-to? story due Feb.11 at noon b. Business story feedback c. Access to Information tips: focusing a request, negotiating, seeking partial releases / previously released records / complaints d. Databases (part three) / One-on-ones
Feb. 17: Reading Week. No class scheduled.
Feb. 24: a. Draft database story due Feb. 25 at noon b. Whatever-happened-to? story due Feb. 27, 9 a.m. c. Access to Information: Making sense of records (decoding documents, chronologies) d. One-on-ones / Research time
|| Reading: Digging Deeper, Chapter 8
March 2: a. Draft access-to-information story due March 10 at noon b. Interviewing / Sources c. Public records
|| Reading: Digging Deeper, Chapter 5
March 9: a. Database story due March 12, 9 a.m. b. Whatever-happened-to? story feedback c. Courts / Legal Affairs
March 16: a. Access-to-information story due March 19, 9 a.m. b. Overlooked Access-to-information records c. One-on-ones / Research time
March 23: a. Database story feedback b. Enterprise journalism tips
March 30: a. Access-to-information story feedback. b. Sharing what we’ve learned
Business story (TOP)
A news story about a publicly traded company. 600 words, to be submitted by Jan. 30 at 10 a.m.
What’s required?
1) A 600-word story on a publicly traded company.
2) The story MUST emerge from the financial statement(s).
3) Upload the story to the category on the WordPress site that you’ll be assigned.
4) At least two interviews, including one with an expert who can put the number(s) in context. The expert can be a business professor, or a business analyst. It can’t be someone who works for a special interest group.
5) An interview, emailed response, public statement such a news release, or discussion in the financial document of a company representative discussing an aspect of the trend that you’ve discovered.
6) An annotated financial statement(s) uploaded to DocumentCloud that MUST be embedded in your story.
7) A visualization of stock prices in Tradingview that MUST be embedded in your story. The visualization must have a title and source.
What’s to be submitted?
1) A 500-word explanation in a Word document that explains how you got the story, the sources you used or attempted to contact and their coordinates (phone numbers, email address, twitter handle, LinkedIn page, etc.)
2) One Excel spreadsheet containing your calculations.
3) The story in a Word document.
3) The assignment is also to be uploaded to our WordPress site to the “category” which will be assigned.
Answers to general questions
Q: Can it be any company?
A: Yes.
Q: Does it have to be the most recent financial statement?
A: Yes.
Q: Which types of financial statements should I be using?
A: Stick with the ones discussed in the business chapter.
Q: Should I create a Google Alert for my company?
A: Yes!
Q: Who should the expert be?
A: It could be a business professor, for instance. So as soon as you choose your company, be sure to line up an interview. It can’t be a representative from an advocacy group.
Q: What if no one from the company gets back to me?
A: This is a distinct possibility. So brace yourself. Certainly, try to obtain the company’s comments on the record either through an interview or emailed response. Failing these two options, there are other ways to obtain the company’s point of view that are described in chapters four, seven and nine. For instance, what has the company said in the Management Discussion and Analysis section of the financial statement, in a news release, an interview, an appearance before a Parliamentary committee, a court document, etc.?
Q: Can I refer to what the company has said in a previous media report?
A: No. That report could be incorrect, or the corporate executive could have been misquoted. Stick to options described in the previous answer.
Q: What multi-media elements should the story contain?
A: A chart or line graph showing the company’s stock prices, using the TradingView website, as demonstrated in the tutorial. You should also have a picture of the company or person in your story. If it’s a business prof, the piece should have a picture that is properly sourced.
Q: How do I illustrate the financial statement?
A: It MUST be uploaded to DocumentCloud and annotated, which means that each annotation contains your analysis of the significance of the numbers, why they matter and why they are in your story. For an example, please see BlackBerry’s latest financial statement.
Q: Must the story contain hyperlinks?
A: An emphatic YES!!!! The idea is to hunt for the original records described in chapter four of our textbook. For instance, if you cite a quotation from the financial statement, then there must be a hyperlink to the statement in DocumentCloud, or you can embed the entire document, which is preferable. DO NOT LINK to media reports, as they are secondary sources that could contain factual errors. Always use original documents to check numbers, and then show people where you got them. So be sure to link to primary documents and datasets. For instance, if you refer to a speech an executive delivered, hyperlink to the speech, or better yet, uploaded it to DocumentCloud and annotate the section in question. Get used to hunting for primary records. The hyperlinks also allow the reader to delve into the weeds, which then allows you to stick to a tight narrative.
Q: How many numbers should I use?
A: Please keep it simple!! TELL A STORY. Just take one or two numbers and write about them. Take what the financial statement(s) gives you. Do not begin with any preconceived notions of what the story may be.
Q: Can I use the financial statement to confirm a story idea I already have?
A: No. The idea is to analyze the financial statement, and then let the story emerge from the analysis. (Note: this is true for all the assignments. That is, the story should originate from the record you’re studying.) The story could be as simple as profits are up compared to the same quarter from the previous year; or the cost of sales has increased significantly; or the company may be making money, but only by selling property or parts of its business. So, to repeat, avoid going into the story with a pre-conceived idea. Let the story emerge from the financial statement. The business chapter should give you some ideas. If not, I’m happy to brainstorm or provide feedback on your draft.
Q: When is the draft due?
A: Jan. 21 at noon
Q: When is the story due?
A: Saturday, Jan. 30, at 10 a.m.
Whatever-happened-to? story (TOP)
A news story that updates the reader on a memorable person or event from 1991. If you choose to write about a person, select someone who hasn’t attracted much, or any, public attention in the last 25 years. 600 words, due Feb. 27, 9 a.m.
Checklist:
a. Story must include comments from your interview with the person in question or participant(s) in the original event.
b. Copies of two pieces of documentation gathered during research for your story.
c. 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?
Answers to general questions
Q: The story must include comments from my interview with the person in question or participant(s) in the original event. Does that mean I need to do just one interview?
A: No, treat the story as you would any other. Though it depends on the story, three voices seems about right. You might interview one person who remembers the original event, someone involved in the issue today and an expert – such as a professor or author – who can place the issue in perspective.
Q: Do I need to include hyperlinks in my story?
A: If they help the reader, yes, one or two well-chosen hyperlinks are welcome.
Q: What sort of documentation do you want?
A: It could be anything that helped you do the story, such as a news clipping about the original event, a photo, a telephone listing of someone you tracked down or a partial transcript of one of your interviews.
Q: Could the documentation be an audio or video clip?
A: Yes. But please be sure to test all posted links and media to make sure they work.
Q: How should I post my story?
A: Post your story in the Whatever-happened-to? category of the syllabus in the same way you filed your Business story.
Q: How should I hand in my two pieces of documentation?
A: You could upload an annotated document to DocumentCloud that is then embedded in the WordPress post. Depending on the format, you could also upload the scanned documentation directly to WordPress. For instance, you could post a .jpeg file of a photograph or a Word document with a screen grab of a Canada 411 entry. However, you post your documentation, don’t forget to answer the questions on the checklist about each piece.
Q: When is the draft due?
A: Feb. 11 at noon (by email in the body of a message).
Q: When is the story due?
A: Feb. 27, 9 a.m. (posted in the in the Whatever-happened-to? category of the syllabus).
Remember:
(*) Think of your person or event as a rock dropped into a pond 25 years ago. You are charting the ripples.
(*) Do not write a rehash. Ask yourself: Could my story have been written in 1991? If so, something’s wrong.
(*) Tell a story.
Database story (TOP)
Data Journalism Assignment
A 600-word story that either uses data to advance a story making news or explore brand new territory. The draft is due by Feb. 25 at 12:p.m. The final version must be submitted by 9 a.m. on March 12.
What’s required?
- A 600-word story based on data downloaded from a federal, provincial or municipal open-data site.
- The story MUST emerge from the data.
- Upload the story to the category on the WordPress site that you’ll be assigned.
- At least two interviews, including with one expert who can put the trend that you’ve identified into context. As was the case with the business assignment, the expert can’t be an advocate, member of a special interest group, or an acquaintance or friend.
- An annotated primary document, be it a bylaw, law, public policy statement, or academic study.
- A visualization using Google Fusion Tables
What’s to be submitted?
- A 500-word explanation in a Word document that explains how you got the story, sources you used or attempted to reach, along with contact information such as phone numbers, email addresses, Twitter handles, and LinkedIn pages.
- ONE — AND ONLY ONE– Excel spreadsheet containing your original table on one worksheet, and subsequent worksheets with your the filtered tables that you’ve used for your analysis. PLEASE DO NOT SUBMIT MULTIPLE EXCEL WORKBOOKS.
- A Word document with your story – minus the visualizations.
- The assignment is also be uploaded to our WordPress site to the “category”, which will be assigned.
Answers to general questions
Q: Can it be any topic?
A: Yes.
Q: Can it be a dataset that we have already used in class.
A: Yes, though I’d prefer that you find something fresh because the searching tests your data-hunting skills.
Q: How extensive should my analysis be?
A: You’ll only be required to use the skills we’ve learned in class and also covered in the textbook: sorting, filtering, using basic math to determine rates of increase and pivot tables. Depending on the nature of the database, you’ll be required to use a combination of these skills.
Q: What if I’m having trouble finding data?
A: Let me know, and I’m happy to brainstorm.
Q: Once I’ve found my dataset, what if I’m struggling with the analysis?
A: Again, please let me know and I will help you. The idea is spend as little time with your data as possible. So it will be important to get the analysis out of the way quickly, allowing yourself the maximum length of time to conduct the research and find people.
Q: Must the story emerge from the data?
A: Yes.
Q: Should I set up a Google Alert once I’ve decided on a topic?
A: Yes.
Q: What’s an example of a story that can be told from data?
A: For instance, the city of Ottawa has a dataset of citizen’ complaints about everything from lack of garbage pick-up to excessive noise. After building a pivot table, you may discover that a particular ward has the highest number of complaints per capita, or that a particular kind of complaint is the most prevalent at certain times of the year. From there, you’d dig for information, talk to people, and then interview sources (city politicians, bureaucrats, bylaw officers, residents, urban study professors, and so on.) to determine why the trend is occurring and what is being done to solve the problem.
Q: What if the politician or bureaucrat doesn’t get back to me?
A: As was the case with the business assignment, this lack of cooperation is a distinct possibility. So be prepared to execute plan-B, which could be an emailed response, or something the official has said publicly in a news release, testimony before a committee, or blog post.
Q: Then does an emailed response count as an interview?
A: Yes, but only if you’ve attempted to interview the official over the phone, or in person.
Q: Can I quote officials from previous news stories?
A: An emphatic no. The official could have been misquoted. You risk repeating the error. It’s best to use your research skills to find original records, which is also the point of these assignments.
Q: How much visualization do I need?
A: At least two visualizations. One MUST be a document uploaded to, and then annotated in DocumentCloud; the second must be a visualization in Google Fusion Table, or another piece of open-source software that you may have learned in another class, or on your own.
Q: Does the document have to be annotated?
A: Again, yes.
Q: Must the story contain hyperlinks that take me to original sources of information?
A: Yes. As was the case in the business assignment, please avoid linking to media reports, as they are secondary sources of information that could contain factual errors. We always strive to find original sources of information such as studies, minutes of meetings, annual reports, and datasets from open data websites. Get used to hunting for primary records, and use the hyperlinks to provide value-added and technical information that should not be used to bog down your story.
Q: How many numbers should I use?
A: The fewer, the better. However, make sure that you pull the key bits of analysis out of the data. For instance, the rate at which something increased, key dates, the top-five instances of the trend that you have discovered.
Q: Can you show me examples of stories students have done in the past?
A: Yes. Please click here to see the first stories my data-journalism students told last fall using Statistics Canada’s crime data.
Q: When is the draft due?
A: Feb. 25 at 12:p.m
Q: When is the story due?
A: 9 a.m. on March 12.
Best of luck!
Access to Information story (TOP)
A news story based on documents obtained through freedom-of-information laws.
Length: 600 words. Story due March 19, 9 a.m.
Checklist:
- A 600-word news story based on documents provided to you.
- Copies of at least two – but not more than 10 – particularly relevant pages of information from these records that assisted your story.
- For the pages in (b) above, full-sentence answers to these questions:
(*) What is the information?
(*) From which department did these pages come?
(*) Why was this information helpful?
- Copies of one request to EACH of the three levels of government (municipal, provincial, federal).
e. A copy of one request for previously released records from the federal government.
f. Copies of correspondence received/sent by you during the course of each of the four requests.
Access-to-information story questions and answers
Q: How do I hand in my assignment?
A: Upload everything – including documents, photos and answers to the three questions – to the relevant “category” of the syllabus. 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: My request forms include personal information (address, phone number). Can I black it out before uploading them?
A: Yes.
Q: How should I select which pages to hand in?
A: Choose records that contain passages you quoted or information that underpinned your story. You can hand in more than two pages, but no more than 10 pages. Please try to highlight relevant passages and do not hand in entire documents or huge volumes of paper.
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 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: Do I have to use the documents in my story?
A: Yes, there should be a substantial connection between the records you have obtained and your story. A good test of this is to ask, ‘Could I really have done this story without the documents?’
Q: Must I include extras?
A: A few, well-chosen hyperlinks in the story and a photo or chart are welcome.
Q: When is the draft due?
A: Thu., March 3, noon (pasted in the body of an email)
Q: When is the story due?
A: Sat., March 19, 9 a.m.
Week One (TOP)
Links
5206-16-PowerPointOne.ppt
BusinessDictionary.com
http://www.businessdictionary.com/
Tradingview
https://www.tradingview.com/e/MSuvXQsL/
For the tutorial that explains how to download an interactive stock-price chart, please click here.
For the tutorial that explains how to embed the Tradingview stock-price chart and the DocumentCloud annotations, please click here.
For instructions on how to upload data to infogr.am, please click here.
Q3 Fiscal 2016 Financial Information.pdf
Consolidated Statements of Operations.pdf
To obtain the PDF of Consolidated Statements of Operations that Cometdocs converted into a spreadsheet, right-click here to save.
An analysis of Blackberry’s third quarter financial statement annotated in DocumentCloud
To find out how much BlackBerry CEO John Chen made during the company’s last fiscal year, check out the 2015 Proxy Circular uploaded and annotated in DocumentCloud by clicking here.
To see examples of vizualizations, including TradingView and DocumentCloud, please click here.
Blackberry Stock Prices in TradingView
http://www.davidmckie.com/blackberry-2/
Cometdocs
http://www.cometdocs.com
Week Two (TOP)
MarketWatch Oil Prices
http://www.marketwatch.com/investing/future/crude%20oil%20-%20electronic
Stephen Poloz says divergent monetary policy may see loonie lower
http://www.cbc.ca/news/business/stephen-poloz-monetary-divergence-1.3393141
Bank of Canada
http://www.bankofcanada.ca/
Canada added 22,800 jobs in December
http://www.cbc.ca/news/business/canada-jobs-december-1.3395020
Labour Force Survey, December 2015
http://www.statcan.gc.ca/daily-quotidien/160108/dq160108a-eng.htm?HPA
Labour force survey estimates (LFS), by census metropolitan area based
http://www5.statcan.gc.ca/cansim/a26?id=2820135
Estrie Language school going bankrupt, teachers told
http://www.cbc.ca/news/canada/ottawa/estrie-language-school-going-bankrupt-teachers-told-1.2510995
Office of the Superintendent of Bankruptcy Canada
http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/br02049.html
To download Estrie’s bankruptcy records, click here
For the tutorial that explains how to download an interactive stock-price chart, please click here.
For the tutorial that explains how to embed the Tradingview stock-price chart and the DocumentCloud annotations, please click here.
To see and download the second PowerPoint presentation, please click here.
Oti Boateng SHS launches 25th Anniversary
http://www.ghanaweb.com/GhanaHomePage/regional/Oti-Boateng-SHS-launches-25th-Anniversary-401369
County newsletter hits silver anniversary
http://www.cincinnati.com/story/news/local/boone-county/2015/12/19/county-newsletter-hits-silver-anniversary/77642900/
In Tiananmen Square, no trace of remembrance on 25th anniversary of protests
https://www.washingtonpost.com/world/security-tight-as-china-represses-tiananmen-anniversary/2014/06/04/4d1c39e9-84c4-475c-a07a-03f1d2dd9cdf_story.html
Week Three (TOP)
Links
Glory Days CEO Pay in Canada Soaring to Pre-Recession Highs
https://www.policyalternatives.ca/sites/default/files/uploads/publications/National%20Office/2015/01/Glory_Days_CEO_Pay.pdf
50 data-journalism ideas (NICAR)
http://mtduk.es/prez/50ideas.html#/
Canada exporting arms to countries with dicey human rights records
http://www.theglobeandmail.com/news/politics/canada-exporting-arms-to-countries-with-suspicious-human-rights-records/article15817569/?cmpid=rss1
Industry Canada Trade Data
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home?OpenDocument
Canada’s weapons exports grew more than 89 per cent under Harper
https://ipolitics.ca/2016/01/20/canadas-weapons-exports-grew-more-than-89-per-cent-under-harper/
Report on Exports of Military Goods from Canada
http://www.international.gc.ca/controls-controles/report-rapports/mil-2012-2013.aspx?lang=eng
Contaminated sites cleanup to cost billions more, budget office says
http://www.cbc.ca/news/politics/contaminated-sites-cleanup-to-cost-billions-more-budget-office-says-1.2604939
Federal contaminated sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Drug seizure stories (CBC News)
http://www.cbc.ca/news/politics/story/2013/03/27/pol-busted-at-the-border-drug-seizures-cbsa.html
http://www.cbc.ca/news/politics/story/2013/03/27/pol-border-drug-seizures-china-gbh.html
http://www.cbc.ca/news/canada/montreal/story/2013/03/27/montreal-hot-spot-for-canada-drug-seizures.html
http://www.cbc.ca/news/canada/british-columbia/story/2013/03/27/bc-cbsa-drugs-ketamine.html
http://www.cbc.ca/news/canada/windsor/story/2013/03/28/wdr-cocaine-seizures-ambassador-bridge.html
http://www.cbc.ca/news/canada/nova-scotia/story/2013/03/27/ns-border-halifax-smuggle.html
http://www.cbc.ca/news/canada/manitoba/story/2013/03/27/mb-khat-manitoba-border-smuggling.html
http://www.radio-canada.ca/grands-titres/
http://www.cbc.ca/news/politics/inside-politics-blog/2013/03/post-15.html
To obtain the Canada Border Service Agency seized commodities dataset, please click here.
Week Four (TOP)
Edmonton
http://data.edmonton.ca/
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Vancouver
http://data.vancouver.ca/
Ontario
http://www.ontario.ca/government/open-data-ontario
http://www.ontario.ca/government/open-government
The federal government
http://open.canada.ca/en
The U.S. government
https://www.data.gov/
Decontaminating LeBreton sites could cost as much as $50 million, says expert
http://ottawacitizen.com/news/local-news/decontaminating-lebreton-sites-could-cost-up-to-50-million-expert-says
Federal contaminated sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Contaminated Sites in Ottawa
https://www.google.com/fusiontables/data?docid=1fvwcrfoII58b4Li_K__Kfxox3WG6VJ-zbTsQx09S#map:id=3
City of Windsor Recognized As Open Data Trailblazer
http://windsorite.ca/2016/01/city-of-windsor-recognized-as-open-data-trailblazer/
https://www.publicsectordigest.com/articles/view/1547
Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
City of Toronto’s Open Data website
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=9e56e03bb8d1e310VgnVCM10000071d60f89RCRD
The city of Ottawa’s Open Data site
http://data.ottawa.ca/en
To download zipped file 311 complaints from 2013-Sept 2015 exported from MySQL, please click here. (Note, depending on the browser, you may have to save the file by right-clicking on the “here” link.
Public safety minister vows to overhaul ‘punitive’ criminal pardons system
http://www.cbc.ca/news/politics/liberal-criminal-justice-pardons-1.3412533
To download the pardon’s dataset, please click here.
Week Five (TOP)
5206-16-PowerPointThree.pptx
Access to Information fillable request form.doc
Nathan’s Group_Access to Information Request NFB.doc
Spencer’s Group_Access to information request exercise.doc
Nikki’s Group_Wiart_ATIP.docx
Dave’s Group Access to Information fillable request form LA LOCHE.doc
Links
Open government push requires ‘cultural shift’ in public service, federal documents warn
http://www.thestar.com/news/canada/2016/02/04/open-government-push-requires-cultural-shift-in-public-service-federal-documents-warn.html
A Time For Openness
http://suzannelegault.ca/
Access to Information sites
CANADA
Access to Information Act
http://laws-lois.justice.gc.ca/eng/acts/A-1/
Privacy Act
http://laws-lois.justice.gc.ca/eng/acts/P-21/
Federal Departments and Agencies
http://canada.ca/en/gov/dept/index.html
Info Source (directory of holdings)
http://www.infosource.gc.ca/emp/emp05-eng.asp
Open Data Portal
http://data.gc.ca/
Search Summaries of Completed ATI Requests
http://data.gc.ca/eng/search/ati?
David McKie’s CAIRs page
CAIRS
Access to Information and Privacy Coordinators
http://www.tbs-sct.gc.ca/atip-aiprp/apps/coords/index-eng.asp
Access to Information request forms
http://www.tbs-sct.gc.ca/tbsf-fsct/350-57_e.asp
Access to Information fillable request form
Specific Exemptions under the Access to Information Act (Treasury Board of Canada Secretariat)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=13784
Office of the Information Commissioner
http://www.oic-ci.gc.ca/eng/
Office of the Privacy Commissioner
http://www.priv.gc.ca
PROVINCES AND TERRITORIES
Alberta
http://www.servicealberta.ca/foip/
British Columbia
http://www.gov.bc.ca/citz/iao/foi/
Completed Freedom of Information requests at BCFerries
http://www.bcferries.com/about/foi/tracker.html
Access in the Academy: Bringing FOI and ATI to Academic Research (BC Freedom of Information and Privacy Association)
https://www.gifttool.com/donations/Donate?ID=1552&AID=2700:
Manitoba
http://www.gov.mb.ca/chc/fippa/
http://www.gov.mb.ca/chc/fippa/disclosure.html
Manitoba (Access to information requests — weekly listing)
http://www.gov.mb.ca/chc/fippa/disclosure.html
New Brunswick
Main:http://www2.gnb.ca/content/gnb/en/services/services_renderer.200949.html
Law: http://www.gnb.ca/acts/acts/r-10-3.htm
Newfoundland and Labrador
http://www.atipp.gov.nl.ca/info/accessrequestform.html
Northwest Territories
https://www.justice.gov.nt.ca/en/access-to-information-held-by-public-bodies/
Nova Scotia
Main: http://www.foipop.ns.ca/
http://novascotia.ca/is/programs-and-services/information-access-and-privacy.asp
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
Main: http://www.accessandprivacy.gov.on.ca/english/doi/index.html
Forms: http://www.accessandprivacy.gov.on.ca/english/download/index.html
Information and Privacy Commissioner decisions and resolutions
Prince Edward Island
http://www.gov.pe.ca/jps/FOIPPfaqs
Quebec
http://www.cai.gouv.qc.ca/index-en.html
Quebec access-to-information coordinators
http://www.cai.gouv.qc.ca/documents/CAI_liste_resp_acces_eng.pdf
Saskatchewan
http://www.justice.gov.sk.ca/Contacts-by-Institution
Requests:
http://www.oipc.sk.ca/Forms.htm
Yukon
http://www.atipp.gov.yk.ca/
CITIES
Calgary
http://www.calgary.ca/CA/city-clerks/Pages/Freedom-of-Information-and-Protection-of-Privacy/Freedom-of-Information-and-Protection-of-Privacy.aspx
Edmonton
http://www.edmonton.ca/city_government/city_organization/freedom-of-information-and-privacy.aspx
Fredericton
http://www.fredericton.ca/en/citygovernment/rtipp2013.asp
Ottawa
http://ottawa.ca/en/city-hall/your-city-government/access-information-and-privacy
Halifax Regional Municipality
http://www.halifax.ca/AccessPrivacy/index.php
Hamilton
http://www.hamilton.ca/CityDepartments/CorporateServices/Clerks/MFIPPA_adn_PHIPA.htm
Moncton
http://www.moncton.ca/Government/Right_to_Information_and_Protection_of_Privacy_Act__RTIPPA_.htm
Montreal
http://ville.montreal.qc.ca/portal/page?_pageid=5798,39687582&_dad=portal&_schema=PORTAL
Regina
http://www.regina.ca/residents/council-committees/learn-city-clerk/access_to_information_and_protection_of_privacy/
Saskatoon
https://www.saskatoon.ca/city-hall/send-comments-concerns-city/freedom-information
Toronto
http://www.toronto.ca/cap/form_foi.htm
Waterloo
http://www.waterloo.ca/en/government/freedomofinformation.asp
Winnipeg
http://winnipeg.ca/clerks/fippa/
Vancouver
http://vancouver.ca/ctyclerk/foi/index.htm
Week Six (TOP)
5206-16-PowerPointFour.ppt
Colour-coded contaminated sites in Fusion Tables
https://www.google.com/fusiontables/data?docid=1XQ1gK1nLQ6yyN56yAPFwDEX8xpsEkoXf12MV-LIQ#map:id=3
Federal contaminated sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
To obtain the tutorial colour-coding the contaminated sites and uploading to Fusion Tables, please click here.
Click here to obtain the contaminated sites dataset we used for this tutorial.
Digging Deeper’s spreadsheet and Fusion Tables on-line appendices
http://www.oupcanada.com/higher_education/companion/comm_studies/9780199008490/student_resources.html
The city of Ottawa’s Open Data site
http://data.ottawa.ca/en
To download the Fusion Tables tutorial for the city of Ottawa’s complaints data, please click here.
To download zipped file the city of Ottawa’s 311 complaints from 2013-2015 exported from MySQL, please click here. (Note, depending on the browser, you may to save the file by right-clicking on the “here” link.
To download the city of Ottawa ward KML file, please either right-click and “save as” or simply click here.
Week Seven (TOP)
5206-16-PowerPointFive.pptx
Week Eight (TOP)
Full text of Peter Mansbridge’s interview with Justin Trudeau
http://www.cbc.ca/news/politics/canada-election-2015-justin-trudeau-interview-peter-mansbridge-full-transcript-1.3219779
5206-16-PowerPointSix.ppt
Liberals to keep memos on openness a secret
http://www.theglobeandmail.com/news/politics/liberals-to-keep-memos-on-openness-a-secret/article28994172/
GLOBE EDITORIAL:If Ottawa wants to be more open, maybe it should just be more open
http://www.theglobeandmail.com/globe-investor/personal-finance/how-to-see-live-shows-without-paying-broadway-prices/article28999197/
Rudny & McKinney-Making government information more accessible
http://news.nationalpost.com/full-comment/rudny-mckinney-making-government-information-more-accessible
Week Nine (TOP)
Canadian agency given deadline by U.S. body to clean up food safety
http://www.theglobeandmail.com/news/politics/canadian-agency-given-deadline-by-us-body-to-clean-up-food-safety/article28961876/
Foreign Audit Reports (United States Department of Agriculture – Food Safety Inspection Service)
http://www.fsis.usda.gov/wps/portal/fsis/topics/international-affairs/importing-products/eligible-countries-products-foreign-establishments/foreign-audit-reports
2014 USDA Audit of the Canadian Meat, Poultry and Egg Inspection Systems
http://www.inspection.gc.ca/food/exports/2014-usda-audit/eng/1456865619649/1456865656831
|
