{"id":9571,"date":"2015-08-13T20:52:14","date_gmt":"2015-08-13T20:52:14","guid":{"rendered":"http:\/\/www.davidmckie.com\/?page_id=9571"},"modified":"2015-12-03T01:56:49","modified_gmt":"2015-12-03T01:56:49","slug":"fall-2015-jour-4101","status":"publish","type":"page","link":"http:\/\/www.davidmckie.com\/fall-2015-jour-4101\/","title":{"rendered":"Fall 2015 JOUR 4101"},"content":{"rendered":"<table border=\"0\" width=\"1249\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\" height=\"1573\"><\/td>\n<td style=\"text-align: center;\" valign=\"top\"><strong>Data Journalism research methods, Fall 2015<\/strong>\u00a0<strong>JOUR 4101 – E<\/strong> <strong>Wednesdays 19:00-22:00<\/strong> <strong>Location: Room 1105 River Building (the TV Newsroom)<\/strong> <strong>David McKie<\/strong> <strong>181 Queen Street<\/strong> <strong>1-613-288-6523 (office)<\/strong> <strong>1-613-290-7380 (cell)<\/strong> <strong>1-613-288-6490 (fax) Email: <a href=\"mail to:david.mckie@cbc.ca\">david.mckie@cbc.ca<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><a style=\"color: #ea9629;\" href=\"#Week1\">Week one |<\/a>\u00a0<a href=\"#Week2\">Week two |<\/a><a href=\"#Week3\">\u00a0Week three |<\/a>\u00a0<a href=\"#Week4\">Week four |<\/a>\u00a0<a href=\"#Week5\">Week five |<\/a>\u00a0<a href=\"#Week6\">Week six|<\/a>\u00a0<a href=\"#Week7\">Week seven |<\/a><a href=\"#Week8\">\u00a0Week eight |<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"#Week9\">Week nine |<\/a>\u00a0<a href=\"#Week10\">Week ten |<\/a>\u00a0<a href=\"#Week11\">Week eleven |<\/a>\u00a0<a href=\"#Week12\">Week twelve |<\/a><a href=\"#Week13\">\u00a0Week thirteen |<\/a>\u00a0<a href=\"#Tutorials1\">Tutorials |<\/a><a style=\"color: #ea9629;\" href=\"#Data1\">Data sets |<\/a><\/p>\n<h4 style=\"text-align: left;\">COURSE DESCRIPTION<\/h4>\n<p style=\"text-align: left;\">The goal of the Data Journalism Storytelling course is to teach students how to find and negotiate for data that is already publicly\u00a0available, or must be obtained formally or informally through access to information. We will\u00a0analyse the information using the following: Excel; the data-visualization\u00a0tools,\u00a0<a href=\"http:\/\/www.tableausoftware.com\/tableau-software?cid=701600000005cS4&ls=Paid%20Search&lsd=Google%20AdWords%20-%20Tableau%20-%20Free%20Trial&adgroup=Tableau%20-%20Brand%20All&kw=tableau%20public&adused=7110377175&distribution=search&gclid=CKjPzebtyLUCFa1AMgodIRoACw\">Tableau<\/a>\u00a0<a href=\"http:\/\/www.tableausoftware.com\/tableau-software?cid=701600000005cS4&ls=Paid%20Search&lsd=Google%20AdWords%20-%20Tableau%20-%20Free%20Trial&adgroup=Tableau%20-%20Brand%20All&kw=tableau%20public&adused=7110377175&distribution=search&gclid=CKjPzebtyLUCFa1AMgodIRoACw\">Public<\/a>,\u00a0<a href=\"http:\/\/www.google.com\/drive\/start\/apps.html\">Google’s\u00a0<\/a><a href=\"http:\/\/www.google.com\/drive\/start\/apps.html\">Fusion Tables<\/a>; the document-annotation software called\u00a0<a href=\"https:\/\/www.documentcloud.org\/home\">DocumentCloud<\/a>;\u00a0and the mapping program called ArcMap.<\/p>\n<p style=\"text-align: left;\">Taken together, these skills comprise computer-assisted reporting, also\u00a0known as data journalism. Our textbook will be,\u00a0<a href=\"http:\/\/www.oupcanada.com\/higher_education\/companion\/comm_studies\/9780195424577.html\">“Computer-Assisted<\/a>\u00a0<a href=\"http:\/\/www.oupcanada.com\/higher_education\/companion\/comm_studies\/9780195424577.html\">Reporting: A Comprehensive Primer”.<\/a><\/p>\n<p style=\"text-align: left;\">At the end of this term, students will become adept searching for information, analyzing the material for story ideas, or for questions that could lead to stories. They’ll learn how to use Excel to spot trends, and employ data-visualization and mapping programs to show the patterns and allow readers to interact with the material, such as being able to identify the income level or levels of crime in their neighbourhood.<\/p>\n<p style=\"text-align: left;\">As well, they’ll be taught how to perform spatial joins, allowing them to,\u00a0for instance, see how many income groups, federal contaminated sites,\u00a0oil spills, construction projects, discarded needles and syringes and government grants fall\u00a0within certain municipal, provincial and federal electoral boundaries.\u00a0These matches, and more importantly the story ideas that are produced,\u00a0can\u00a0<i>only<\/i>\u00a0be obtained using mapping software <a href=\"http:\/\/www.esri.com\/software\/arcgis\" target=\"_blank\">ArcMap <\/a>and <a href=\"http:\/\/www.qgis.org\/en\/site\/\" target=\"_blank\">Qgis<\/a>.<\/p>\n<p style=\"text-align: left;\">For instance, spatial joins have allowed journalists such as the Ottawa\u00a0Citizen’s Glen McGregor to tell the\u00a0<a href=\"http:\/\/www.ottawacitizen.com\/entertainment\/movie-guide\/After%2Bfederal%2Bchanges%2Bwaterways%2Brules%2Bcent%2Bprotected%2Blakes%2BConservative%2Bshores\/7466027\/story.html\">story<\/a>\u00a0about the bodies of water protected under the Harper government’s Navigable\u00a0Waters Protection Act that are in or near federal Conservative ridings. Working with census data, we will also learn how to map variable such as income level, much the same way The Gazette’s Robero Rocha did to help readers visualize the <a href=\"http:\/\/www.montrealgazette.com\/news\/interactives\/household-survey\/interactive_page.html\" target=\"_blank\">median household income<\/a>. He also used\u00a0<a href=\"http:\/\/www.montrealgazette.com\/news\/interactives\/photo-radars\/index.html\" target=\"_blank\">data to show<\/a>\u00a0the locations of\u00a0several police radar cameras, how many tickets and fines each one collected, and\u00a0street-level photographs of their locations.The assignments, or stories, will be submitted as blogs in WordPress\u00a0that will allow for a multi-media treatment. Documents used as reference\u00a0material will be uploaded to the account that will be created for you\u00a0in <a href=\"https:\/\/www.documentcloud.org\" target=\"_blank\">DocumentCloud<\/a>, annotated, and then embedded into the blogs.<\/p>\n<p style=\"text-align: left;\">Though it’s designed to be a data-journalism-focused research methods course, there will also be a with a heavy emphasis on storytelling, both with words and data in interactive maps and charts. As such, we will begin\u00a0each class with a story that has appeared in the news: either as an example\u00a0of how data journalism was used, or how it could have been used. These\u00a0discussions and the exercises will help students develop new analytical\u00a0and storytelling skills, driven by data. In addition to our textbook, we will also use tutorials to drive home some of the key Excel and mapping skills that will form the course’s backbone.<\/p>\n<p style=\"text-align: left;\">The course will be divided up into\u00a0four, three-week modules. Each module will teach the following skills:Excel; Fusion Tables, Tableau Public; ArcMap\/Qgis.<\/p>\n<p style=\"text-align: left;\">There will be three assignments ( please see chart below ), building to a final\u00a0assignment that combines all the skills we’ve learned during the semester. At the end of each of the four modules, there will be an in-class tests worth five percent each.<\/p>\n<p style=\"text-align: left;\">Our textbook will be Computer-Assisted Reporting: A Comprehensive Primer, which is stocked at the Carleton library.<\/p>\n<h4 style=\"text-align: left;\">Examples stories using data journalism<\/h4>\n<p class=\"entry-title\" style=\"text-align: left;\" title=\"The passengers aboard Sunwing Flight 656 were arrested by Peel Regional Police officers, said a police department spokesperson\">Women charged after plane disruption prompts military escort <a href=\"http:\/\/www.theglobeandmail.com\/news\/national\/plane-gets-military-escort-after-passengers-disrupt-flight\/article20231266\/#dashboard\/alerts\" target=\"_blank\">http:\/\/www.theglobeandmail.com\/news\/national\/plane-gets-military-escort-after-passengers-disrupt-flight\/article20231266\/#dashboard\/alerts<\/a><\/p>\n<p class=\"entry-title\" style=\"text-align: left;\" title=\"According to Transport Canada aviation data, 78 per cent of all reports of alcohol-, cigarette- or marijuana-related incidents of Canadian flights were for incidents on WestJet planes\">WestJet has \u2018little tolerance\u2019 for intoxicated flyers (The Globe and Mail)<a style=\"color: #ea9629;\" href=\"http:\/\/www.theglobeandmail.com\/news\/national\/plane-gets-military-escort-after-passengers-disrupt-flight\/article20231266\/#dashboard\/alerts\" target=\"_blank\">http:\/\/www.theglobeandmail.com\/news\/national\/westjet-has-little-tolerance-for-intoxicated-flyers\/article20290565\/#dashboard\/alerts<\/a><\/p>\n<p class=\"entry-title\" style=\"text-align: left;\" title=\"According to Transport Canada aviation data, 78 per cent of all reports of alcohol-, cigarette- or marijuana-related incidents of Canadian flights were for incidents on WestJet planes\">To download disruptive passenger stories, please click <a href=\"http:\/\/www.davidmckie.com\/Disruptive%20passenger stories.pdf\" target=\"_blank\">here<\/a><\/p>\n<p style=\"font-weight: 400; text-align: left;\">Civil Aviation Daily Occurrence Reporting System (CADORS): Main Menu <a href=\"http:\/\/wwwapps.tc.gc.ca\/Saf-Sec-Sur\/2\/cadors-screaq\/m.aspx\" target=\"_blank\">http:\/\/wwwapps.tc.gc.ca\/Saf-Sec-Sur\/2\/cadors-screaq\/m.aspx<\/a><\/p>\n<p style=\"text-align: left;\">To download the CADORS disruptive passenger Excel file, please click <a href=\"http:\/\/www.davidmckie.com\/Disruptive%20passenger stories.pdf\">here<\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theglobeandmail.com\/news\/national\/westjet-has-little-tolerance-for-intoxicated-flyers\/article20290565\/#dashboard\/alerts\" target=\"_blank\">This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press and Globe and Mail editorial)<\/a> <a style=\"font-size: 11px; line-height: 2;\" href=\"http:\/\/www.theglobeandmail.com\/news\/national\/westjet-has-little-tolerance-for-intoxicated-flyers\/article20290565\/#dashboard\/alerts\" target=\"_blank\">http:\/\/www.thestar.com\/news\/gta\/2014\/08\/11\/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html <\/a><a href=\"http:\/\/www.theglobeandmail.com\/news\/national\/westjet-has-little-tolerance-for-intoxicated-flyers\/article20290565\/#dashboard\/alerts\" target=\"_blank\">http:\/\/www.theglobeandmail.com\/globe-debate\/editorials\/vote-fire-hydrant-for-mayor\/article20102235\/#dashboard\/follows\/<\/a><\/p>\n<p class=\"headline\" style=\"text-align: left;\">Pipeline map: Have there been any incidents near you? (CBC News) <a href=\"http:\/\/www.cbc.ca\/news2\/interactives\/pipeline-incidents\/\" target=\"_blank\">http:\/\/www.cbc.ca\/news2\/interactives\/pipeline-incidents\/<\/a><\/p>\n<p class=\"story-h\" style=\"text-align: left;\">Korea: Mapping the dead of Canada\u2019s forgotten war (Global News) <a href=\"http:\/\/globalnews.ca\/news\/938142\/korea-mapping-dead-canadas-forgotten-war\/\" target=\"_blank\">http:\/\/globalnews.ca\/news\/938142\/korea-mapping-dead-canadas-forgotten-war\/<\/a><\/p>\n<p class=\"printable-title\" style=\"text-align: left;\">A question of life and death.\u2019 Grieving kin call for median barrier on Waterloo expressway <a href=\"http:\/\/www.therecord.com\/news-story\/4047409--a-question-of-life-and-death-grieving-kin-call-for-median-barrier-on-waterloo-expressway\/\" target=\"_blank\">http:\/\/www.therecord.com\/news-story\/4047409–a-question-of-life-and-death-grieving-kin-call-for-median-barrier-on-waterloo-expressway\/<\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.therecord.com\/news-story\/4047409--a-question-of-life-and-death-grieving-kin-call-for-median-barrier-on-waterloo-expressway\/\" target=\"_blank\">Toronto data reveals hundreds of discarded syringe <\/a><a style=\"font-size: 11px; line-height: 2;\" href=\"http:\/\/www.therecord.com\/news-story\/4047409--a-question-of-life-and-death-grieving-kin-call-for-median-barrier-on-waterloo-expressway\/\" target=\"_blank\">http:\/\/www.thestar.com\/news\/gta\/2013\/08\/15\/toronto_data_reveals_hundreds_of_discarded_syringes.html<\/a><\/p>\n<p style=\"text-align: left;\">The Windsor Star’s data desk <a href=\"http:\/\/www.windsorstar.com\/news\/data-desk\/index.html\" target=\"_blank\">http:\/\/www.windsorstar.com\/news\/data-desk\/index.html<\/a><\/p>\n<p style=\"text-align: left;\">After federal changes to waterways rules, 90 per cent of protected lakes lap on Conservative shores (The Ottawa Citizen) <a href=\"http:\/\/www.ottawacitizen.com\/entertainment\/movie-guide\/After%2Bfederal%2Bchanges%2Bwaterways%2Brules%2Bcent%2Bprotected%2Blakes%2BConservative%2Bshores\/7466027\/story.html\">http:\/\/www.ottawacitizen.com\/entertainment\/movie-guide\/After%2Bfederal%2Bchanges%2Bwaterways%2Brules%2Bcent%2Bprotected%2Blakes%2BConservative%2Bshores\/7466027\/story.html<\/a><\/p>\n<p style=\"text-align: left;\">A new view of Edmonton (Edmonton Journal) <a href=\"http:\/\/www.edmontonjournal.com\/news\/living-on-the-edge\/index.html\">http:\/\/www.edmontonjournal.com\/news\/living-on-the-edge\/index.html<\/a><\/p>\n<p style=\"text-align: left;\">Battleground B.C.: Election Trends (The Vancouver Sun) <a href=\"http:\/\/www.vancouversun.com\/news\/electiontrends.html\">http:\/\/www.vancouversun.com\/news\/electiontrends.html<\/a><\/p>\n<p style=\"text-align: left;\">A new view of Edmonton (Edmonton Journal) <a href=\"http:\/\/www.edmontonjournal.com\/news\/living-on-the-edge\/index.html\">http:\/\/www.edmontonjournal.com\/news\/living-on-the-edge\/index.html<\/a><\/p>\n<p style=\"text-align: left;\">Battleground B.C.: Election Trends (The Vancouver Sun) <a href=\"http:\/\/www.vancouversun.com\/news\/electiontrends.html\">http:\/\/www.vancouversun.com\/news\/electiontrends.html<\/a><\/p>\n<p style=\"text-align: left;\">Federal Parolees Per Capita (The Vancouver Sun) <a href=\"http:\/\/www.vancouversun.com\/news\/parolees-capita.html\">http:\/\/www.vancouversun.com\/news\/parolees-capita.html<\/a><\/p>\n<p style=\"text-align: left;\">Explore the data: Toronto bicycle collisions mapped over 25 years (The Globe and Mail) <a href=\"http:\/\/www.theglobeandmail.com\/news\/toronto\/explore-the-data-toronto-bicycle-collisions-mapped-over-25-years\/article543684\/\">http:\/\/www.theglobeandmail.com\/news\/toronto\/explore-the-data-toronto-bicycle-collisions-mapped-over-25-years\/article543684\/<\/a><\/p>\n<p style=\"text-align: left;\">Interactive Map: Explore the data behind Toronto’s working poor (The globe and Mail) <a href=\"http:\/\/www.theglobeandmail.com\/news\/toronto\/interactive-map-explore-the-data-behind-torontos-working-poor\/article2332885\/\">http:\/\/www.theglobeandmail.com\/news\/toronto\/interactive-map-explore-the-data-behind-torontos-working-poor\/article2332885\/<\/a><\/p>\n<p style=\"text-align: left;\">METHADONE AND THE POLITICS OF PAIN (The Seattle Times) <a href=\"http:\/\/seattletimes.nwsource.com\/flatpages\/specialreports\/methadone\/methadoneandthepoliticsofpain.html\">http:\/\/seattletimes.nwsource.com\/flatpages\/specialreports\/methadone\/methadoneandthepoliticsofpain.html<\/a><\/p>\n<h4 style=\"text-align: left;\"><strong>WHAT YOU WILL LEARN<\/strong><\/h4>\n<p style=\"text-align: left;\">1) How to find data in cyberspace<\/p>\n<p style=\"text-align: left;\">2) How to use a spreadsheet to analyze statistics<\/p>\n<p style=\"text-align: left;\">3) How to create a pivot table<\/p>\n<p style=\"text-align: left;\">4) How to use advanced functions in Excel<\/p>\n<p style=\"text-align: left;\">5) How to use technical skills such as exporting tables from PDFs into Excel<\/p>\n<p style=\"text-align: left;\">6) How to use MySQL<\/p>\n<p style=\"text-align: left;\">7) How to advance your numeracy skills<\/p>\n<p style=\"text-align: left;\">8) How to use Fusion Tables<\/p>\n<p style=\"text-align: left;\">9) How to use Tableau Public<\/p>\n<p style=\"text-align: left;\">10) How to use ArcMap, Qgis and ArcGIS Online<\/p>\n<p style=\"text-align: left;\">11) How to become effective storytellers using data-journalism techniques<\/p>\n<h4 style=\"text-align: left;\"><\/h4>\n<table class=\"alignleft\" style=\"height: 566px;\" border=\"1\" width=\"829\">\n<tbody>\n<tr>\n<td width=\"608\" height=\"63\">\n<h3 align=\"center\">Assignments and Deadlines<\/h3>\n<\/td>\n<td width=\"61\" height=\"63\">Percent<\/td>\n<td width=\"43\"><\/td>\n<\/tr>\n<tr>\n<td height=\"56\">Assignment#1: A story using numbers crunched in Excel due on Oct.2<\/td>\n<td height=\"56\">20%<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td height=\"53\">Assignment #2: Particulars to be announced. Nov. 13<\/td>\n<td height=\"53\">20%<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td height=\"48\">Assignment #3: Particulars to be announced. Due date between Dec. 4-9<\/td>\n<td height=\"48\">30%<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td height=\"38\">Four in-class tests after each modules worth five per cent each<\/td>\n<td height=\"38\">20%<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td height=\"38\">Participation\/professional conduct: For informative participation and professionalism displayed in class and on-line<\/td>\n<td height=\"38\">10%<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left;\">GRADES<\/p>\n<p style=\"text-align: left;\">We will be using a 12-point grading scale with the marks to be as follows, meaning the final mark will be out of 120 with the following breakdown:<\/p>\n<p style=\"text-align: left;\">A+ = 12<\/p>\n<p style=\"text-align: left;\">A= 11<\/p>\n<p style=\"text-align: left;\">A-= 10<\/p>\n<p style=\"text-align: left;\">B+ = 9<\/p>\n<p style=\"text-align: left;\">B= 8<\/p>\n<p style=\"text-align: left;\">B-=7<\/p>\n<p style=\"text-align: left;\">C+=6<\/p>\n<p style=\"text-align: left;\">C=5<\/p>\n<p style=\"text-align: left;\">C-=4<\/p>\n<h4 style=\"text-align: left;\">COMMUNICATIONS WITH STUDENTS<\/h4>\n<p style=\"text-align: left;\">This will be done primarily through email correspondence and phone calls,\u00a0given that I do not have an\u00a0office at Carleton. The protocol will dictate that emailed queries will\u00a0be answered as promptly as\u00a0possible, usually within the hour. As such, it will be important for you\u00a0to regularly check your email account for updates regarding assignments,\u00a0new data sets or class work. You’ll also be required to use your Carleton\u00a0account.<\/p>\n<h4 style=\"text-align: left;\">PROFESSIONALISM<\/h4>\n<p style=\"text-align: left;\">We\u2019ll conduct ourselves as professional journalists. That\u00a0means attending class, showing up on time; being prepared and ready to\u00a0make a meaningful contribution based on the preparation work you’ve been\u00a0assigned; paying attention to your instructor and colleagues and ignoring\u00a0email correspondence, Facebook, text messages, Twitter, and promptly responding\u00a0to emails from the instructor. You’ll also be expected to stay on top\u00a0of current events, which is part of your obligation as a journalist. If\u00a0you must miss class, please communicate with the instructor via email.<\/p>\n<p style=\"text-align: left;\">If it\u2019s for a medical reason, then you may be required to provide\u00a0a doctor\u2019s note. If it\u2019s for an internship, then you\u2019ll\u00a0have to provide details.<\/p>\n<h4 style=\"text-align: left;\">REQUIRED SUPPORT RESOURCES<\/h4>\n<p style=\"text-align: left;\">The course would be taught in the TV computer lab, using the overhead projector.\u00a0As the school possesses an ArcMap licence, we are be able to use the\u00a0mapping software,\u00a0which is installed on the desktops. The library’s\u00a0<a href=\"http:\/\/www.library.carleton.ca\/contact\/service-points\/maps-data-and-government-information-centre\">Maps,\u00a0<\/a><a href=\"http:\/\/www.library.carleton.ca\/contact\/service-points\/maps-data-and-government-information-centre\">Data and Government Information Centre<\/a>\u00a0is well positioned to provide\u00a0support to faculties including journalism and communications.<\/p>\n<h4 style=\"text-align: left;\">OUTLINE<\/h4>\n<h6 style=\"text-align: left;\"><strong><b>Week One(<a href=\"#TOP\" name=\"Week1\">TOP<\/a>) –\u00a0<\/b>Sept. 2<\/strong><\/h6>\n<p style=\"text-align: left;\">Introduction to the course.<\/p>\n<p style=\"text-align: left;\">Downloading datasets from websites and sorting and filtering them for trends.<\/p>\n<p style=\"text-align: left;\">Read chapters three and four of Computer-Assisted Reporting.<\/p>\n<p style=\"text-align: left;\">To open and save the ACOA tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/ACOATutorial.pdf\" target=\"_blank\">here.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Links:<\/strong><\/p>\n<h6 class=\"entry-title\" style=\"text-align: left;\" title=\"New startups are built for mobile, social media-savvy audiences who grew up creating things on the Web\"><strong><b>Week Two(<a href=\"#TOP\" name=\"Week2\">TOP<\/a>)Sept. 9<\/b><\/strong><\/h6>\n<p style=\"text-align: left;\">What we will cover<\/p>\n<p style=\"text-align: left;\">A review of our sorting and filtering from the previous week<\/p>\n<p style=\"text-align: left;\">An introduction to pivot tables<\/p>\n<p style=\"text-align: left;\"><b>National Institute for Computer-Assisted Reporting<br \/>\n<\/b><a href=\"http:\/\/www.nicar.org\/\" target=\"_blank\">http:\/\/www.nicar.org\/<br \/>\n<\/a><a href=\"http:\/\/data.nicar.org\/\">http:\/\/data.nicar.org\/<br \/>\n<\/a><a href=\"http:\/\/www.ire.org\/resource-center\/listservs\/subscribe-nicar-l\/\">http:\/\/www.ire.org\/resource-center\/listservs\/subscribe-nicar-l\/<\/a><\/p>\n<p style=\"text-align: left;\"><b>Investigative Reporters and Editors, Inc.<br \/>\n<\/b><a href=\"http:\/\/www.ire.org\/\" target=\"_blank\">http:\/\/www.ire.org\/<\/a><\/p>\n<p style=\"text-align: left;\"><strong>How to use Excel to reveal stories from spreadsheets<\/strong><br \/>\n<a href=\"https:\/\/blog.infogr.am\/data-analysis-for-journalists-using-excel\/\">https:\/\/blog.infogr.am\/data-analysis-for-journalists-using-excel\/<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Questions and Answers on Data Journalism to Guide You<\/strong><br \/>\n<span style=\"font-family: inherit; font-size: inherit; line-height: 2;\"><a href=\"https:\/\/blog.infogr.am\/questions-and-answers-on-data-journalism-to-guide-you\/\">https:\/\/blog.infogr.am\/questions-and-answers-on-data-journalism-to-guide-you\/<\/a><\/span><\/p>\n<p style=\"text-align: left;\"><!-- Web Experience Toolkit (WET) \/ (BOEW) wet-boew.github.com\/wet-boew2\/License-eng.txt \/ wet-boew.github.com\/wet-boew2\/Licence-fra.txt --><!--END base-eng.html --><\/p>\n<p style=\"text-align: left;\"><!--START css.html --><script src=\"\/wet-boew\/build\/js\/jquery.min.js\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-no\/type\"><\/script><script src=\"\/wet-boew\/build\/js\/polyfills\/html5shiv-min.js\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-no\/type\"><\/script><\/p>\n<p style=\"text-align: left;\"><noscript><\/noscript><!--END css.html --><!-- CustomScriptsCSSStart --><\/p>\n<p style=\"text-align: left;\"><!-- The stuff inside the following comment block is not seen by any version of IE but seen by all other browsers --><!-- This stylesheet is for IE only --><\/p>\n<p style=\"text-align: left;\"><!-- CustomScriptsCSSEnd --><!--START before-header-novav-eng.html --><\/p>\n<div id=\"wb-body\">\n<div id=\"wb-core\">\n<div id=\"wb-core-in\" class=\"equalize\">\n<div id=\"wb-main\">\n<div id=\"wb-main-in\">\n<p id=\"wb-cont\" style=\"text-align: left;\"><strong>Incident-based crime statistics, by detailed violations<\/strong><br \/>\n<a href=\"http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&id=2520051\">http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&id=2520051<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Population by year, by province and territory (Number)<\/strong><br \/>\n<a href=\"http:\/\/www.statcan.gc.ca\/tables-tableaux\/sum-som\/l01\/cst01\/demo02a-eng.htm\">http:\/\/www.statcan.gc.ca\/tables-tableaux\/sum-som\/l01\/cst01\/demo02a-eng.htm<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Population by year, by municipality<\/strong><br \/>\n<a href=\"http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&retrLang=eng&id=0510056&pattern=051-0056..051-0064&tabMode=dataTable&srchLan=-1&p1=-1&p2=31\">http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&retrLang=eng&id=0510056&pattern=051-0056..051-0064&tabMode=dataTable&srchLan=-1&p1=-1&p2=31<\/a><\/p>\n<p id=\"cn-cont\" style=\"text-align: left;\"><strong>Notice \u2013 Supplementary Information to the 2015 Immigration Levels Plan<\/strong><br \/>\n<a href=\"http:\/\/www.cic.gc.ca\/english\/department\/media\/notices\/2014-11-06.asp\">http:\/\/www.cic.gc.ca\/english\/department\/media\/notices\/2014-11-06.asp<\/a><\/p>\n<p id=\"cn-cont\" style=\"text-align: left;\"><strong>Syrian Refugees<\/strong><br \/>\n<a href=\"http:\/\/www.cic.gc.ca\/english\/refugees\/crisis\/syria.asp\">http:\/\/www.cic.gc.ca\/english\/refugees\/crisis\/syria.asp<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p style=\"text-align: left;\"><a href=\"https:\/\/blog.infogr.am\/data-analysis-for-journalists-using-excel\/\">\u00a0<\/a>An introduction to using ratios<\/p>\n<p style=\"text-align: left;\">Discussion of assignment due Sept 30<\/p>\n<p style=\"text-align: left;\">To download the pivot table using ACOA data tutorial, click <a href=\"http:\/\/www.davidmckie.com\/Pivot%20Table tutorial using ACOA data.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the calculating percent of totals tutorial, click <a href=\"http:\/\/www.davidmckie.com\/Calculating%20percentages of totals tutorial.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the calculating rates tutorial, click <a href=\"http:\/\/www.davidmckie.com\/Calculating%20rates.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Reading: Chapter 4<\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Three(<a href=\"#TOP\" name=\"Week3\">TOP<\/a>)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Sept. 16<\/strong><\/h6>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\">\u00a0To download \u00a0the in-class Excel test, please click <a href=\"http:\/\/www.davidmckie.com\/Excel%20test using Transport Canada.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\">Further discussion of the Sept. 30 assignment<\/p>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\">Introduction to MySQL<\/p>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\">To download the instructions for downloading MySQL, please click<a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows.pdf\" target=\"_blank\"> here<\/a>.<\/p>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\">To download the Logical Functions And IF Statements tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Tutorial%20using Logical functions and IF Statements.pdf\">here<\/a>.<\/p>\n<p style=\"text-align: left;\"><strong>Qs and As for the assignment which will be due midnight Oct. 2\u00a0<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>What is required?<\/strong> A 600-word story using the Statistics Canada crime data we explored in class? A 500-word explanation\u00a0in a Word document\u00a0of how you researched the story, including original documents, data and sources, complete with their phone numbers, email addresses and Twitter accounts. \u00a0An Excel workbook containing the original table and worksheets containing subsets of your data?<\/p>\n<p style=\"text-align: left;\"><strong>How is the assignment to be submitted?<\/strong> You will upload the story to a WordPress category that you’ll be assigned. The Word document and Excel workbook are to be emailed to my CBC address as attachments.<\/p>\n<p style=\"text-align: left;\"><strong>What am I looking for in the story?<\/strong> A well-told yarn, with a sharp, crisp lead that makes the audience want to keep reading. Avoid using too many numbers. Think about the most important numbers, and concentrate on them. As writing coach Don Gibb once remarked, choose a number as carefully as you choose a quote. All your references MUST be hyperlinked to the original source. For instance, if you are referring to a study that states a certain fact, then there should be a hyperlinked reference to the original document. What I want to see is evidence of solid research. DO NOT LINK TO NEWS REPORTS THAT SIMPLY REFER TO THE STUDY IN QUESTION.<\/p>\n<p style=\"text-align: left;\"><strong>Should the story have any interviews?<\/strong> Yes, at least two, including someone who is directly or indirectly impacted by the situation you’re writing about. So get the data work completed early enough to allow for enough time to find the right characters for your story.<\/p>\n<p style=\"text-align: left;\"><strong>Should one of the interviewees be an expert?<\/strong> Yes. It could be a knowledgeable police officer, a criminologist or a lawyer. The expert should not be an advocate. Seek out\u00a0credible, non-partisan voices.<\/p>\n<p style=\"text-align: left;\"><strong>Should I have any visualizations?<\/strong> Absolutely. We’ll explore visualizations more in-depth as the term progresses. For this assignment, there should be at least one, preferably a picture of the subject of your story. If you already know how to use other visualization tools, please feel free to use them, though you will not receive extra marks for doing so.<\/p>\n<p style=\"text-align: left;\"><strong>Can I submit a draft?<\/strong> Yes. However, because this is a large class, I will accept ONLY ONE\u00a0per student, and will not accept a draft 48 hours before the due date. Remember, a draft can be point form, or even an explanation of where you intend to take the story, if you’re running out of time. Your assignment should not be your first draft.<\/p>\n<p style=\"text-align: left;\"><strong>What is the deadline?<\/strong> Sept 30 at midnight. Anything after that will be considered late and docked half a mark. Extensions will be granted for exceptional circumstances only. However, we must have a conversation.<\/p>\n<p style=\"text-align: left;\"><strong>Links<\/strong><\/p>\n<p style=\"text-align: left;\">A continuation of ratios using Transport Canada’s vehicle recalls data and <a href=\"http:\/\/www.ontario.ca\/page\/public-sector-salary-disclosure\" target=\"_blank\">Ontario’s Public sector salary disclosure data<\/a><\/p>\n<p class=\"entry-title\" style=\"text-align: left;\"><strong>University enrolment<\/strong><br \/>\n<a href=\"http:\/\/www.univcan.ca\/canadian-universities\/facts-and-stats\/enrolment-by-university\/\" target=\"_blank\">http:\/\/www.univcan.ca\/canadian-universities\/facts-and-stats\/enrolment-by-university\/<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Elections Canada<br \/>\n<\/strong><a href=\"http:\/\/www.elections.ca\/WPAPPS\/WPF\" target=\"_blank\">http:\/\/www.elections.ca\/WPAPPS\/WPF<\/a><\/p>\n<p style=\"text-align: left;\">Download federal campaign\u00a0<a href=\"http:\/\/davidmckie.com\/FederalCampaignContributions.xlsx\" target=\"_blank\">donation data\u00a0<\/a><\/p>\n<p style=\"text-align: left;\"><strong><b>Week Four(<a href=\"#TOP\" name=\"Week4\">TOP<\/a>)<\/b><\/strong><\/p>\n<h6 style=\"text-align: left;\"><strong>Sept. 23<\/strong><\/h6>\n<p style=\"text-align: left;\">To download the Windows version of MySQL downloading tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows tutorial.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the Mac version of the MySQL downloading tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on a Mac.pdf\" target=\"_blank\">here<\/a><a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows_revised.pdf\" target=\"_blank\">.<\/a><\/p>\n<p style=\"text-align: left;\">An in-class Excel exercise<\/p>\n<p class=\"story-title\" style=\"text-align: left;\"><strong>Martin Winterkorn, Volkswagen CEO, resigns amid emissions scandal<\/strong><br \/>\n<a href=\"http:\/\/www.cbc.ca\/news\/business\/volkswagen-martin-winterkorn-resigns-1.3239916\">http:\/\/www.cbc.ca\/news\/business\/volkswagen-martin-winterkorn-resigns-1.3239916<\/a><\/p>\n<p style=\"text-align: left;\"><strong>This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)<\/strong><br \/>\n<a href=\"http:\/\/www.thestar.com\/news\/gta\/2014\/08\/11\/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html\" target=\"_blank\">http:\/\/www.thestar.com\/news\/gta\/2014\/08\/11\/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html<\/a><\/p>\n<p style=\"text-align: left;\">Toronto Parking Ticket <a href=\"http:\/\/www1.toronto.ca\/wps\/portal\/contentonly?vgnextoid=ca20256c54ea4310VgnVCM1000003dd60f89RCRD&vgnextchannel=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD\" target=\"_blank\">Download<\/a>\u00a0site<\/p>\n<p class=\"entry-title\" style=\"text-align: justify;\"><strong>Beech Street fire hydrant has netted city $65,000 since\u00a02008<\/strong><br \/>\n<a href=\"http:\/\/ottawacitizen.com\/news\/local-news\/beech-street-fire-hydrant-has-netted-city-65000-since-2008\">http:\/\/ottawacitizen.com\/news\/local-news\/beech-street-fire-hydrant-has-netted-city-65000-since-2008<\/a><\/p>\n<p class=\"entry-title\" style=\"text-align: justify;\">Ottawa Parking Ticket <a href=\"http:\/\/www.davidmckie.com\/OttawaFireHydrantFineData.xlsx\">Data<\/a><\/p>\n<p style=\"text-align: left;\">A continuation of MySQL<\/p>\n<p style=\"text-align: left;\">Links:<\/p>\n<p style=\"text-align: left;\"><strong>Vanishing Canada: Why we\u2019re all losers in Ottawa\u2019s war on data<\/strong><br \/>\n<a href=\"http:\/\/www.macleans.ca\/news\/canada\/vanishing-canada-why-were-all-losers-in-ottawas-war-on-data\/\">http:\/\/www.macleans.ca\/news\/canada\/vanishing-canada-why-were-all-losers-in-ottawas-war-on-data\/<\/a><\/p>\n<p style=\"text-align: left;\"><strong><b>Week Five(<a href=\"#TOP\" name=\"Week5\">TOP<\/a>)<\/b><\/strong><\/p>\n<h6 style=\"text-align: left;\">Sept. 30<\/h6>\n<p style=\"text-align: left;\"><strong>WHAT WE WILL COVER<\/strong><\/p>\n<p style=\"text-align: left;\">A continuation of MySQL<\/p>\n<p style=\"text-align: left;\">To download the MySQL tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Tutorial%20for importing Ottawa Fire Hydrant Parking Violation Data Into MySQL.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the MySQL queries for the Ottawa 2008 parking data, please click <a href=\"http:\/\/www.davidmckie.com\/HYDRANT_2008%20SCRIPTS FOR CLASS.sql\" target=\"_blank\">here.<\/a><\/p>\n<p style=\"text-align: left;\">To download the MSQL load Mac query for the Ottawa 2008, please click <a href=\"http:\/\/www.davidmckie.com\/Parking.sql\">here.<\/a><\/p>\n<p style=\"text-align: left;\">To download the city of Ottawa 2008 Fire Hydrant Parking Ticket Data for Tutorial, please right- click<a href=\"http:\/\/www.davidmckie.com\/HydrantViolations_2008_.csv\"> here<\/a><br \/>\nand save it as a csv file.<\/p>\n<p style=\"text-align: left;\">Links:<\/p>\n<p id=\"yui_3_11_0_1_1443620292605_29\" class=\"story-title\" style=\"text-align: left;\"><strong>Police report a pot possession incident every 9 minutes in Canada<\/strong><br \/>\n<a href=\"http:\/\/www.cbc.ca\/news\/canada\/manitoba\/pot-possession-incidents-1.3247653\">http:\/\/www.cbc.ca\/news\/canada\/manitoba\/pot-possession-incidents-1.3247653<\/a><\/p>\n<p style=\"text-align: left;\"><strong><b>Week Six(<a href=\"#TOP\" name=\"Week6\">TOP<\/a>)<\/b><\/strong><\/p>\n<h6 style=\"text-align: left;\"><strong>Oct. 7<\/strong><\/h6>\n<p style=\"text-align: left;\">A continuation of MySQL.<\/p>\n<p style=\"text-align: left;\">To download the city of Ottawa 2008-2014 Fire Hydrant Parking Ticket Data for the continuation of our MySQL tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/HydrantViolations_2008-2014.zip\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the second half of the MySQL tutorial using Ottawa’s Fire Hydrant Parking Ticket Data, please click <a href=\"http:\/\/www.davidmckie.com\/A%20continuation of the MySQL tutorial.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\"><strong><b>Week Seven(<a href=\"#TOP\" name=\"Week6\">TOP<\/a>)<\/b><\/strong><\/p>\n<h6 style=\"text-align: left;\"><strong>Oct.\u00a014<\/strong><\/h6>\n<p style=\"text-align: left;\">To download the in-class MySQL test, please click \u00a0<a href=\"http:\/\/www.davidmckie.com\/MySQL%20test_final.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Discussion of the next assignment, whose due date will be determined.<\/p>\n<h6 style=\"text-align: left;\"><strong>Assignment Qs and As<\/strong><\/h6>\n<p style=\"text-align: left;\"><strong>What’s the due date?<\/strong>\u00a0Nov. 13 at midnight.<\/p>\n<p style=\"text-align: left;\"><strong>What’s the topic?<\/strong> You have choices: restaurants, parking violations, or anything else you fancy.<\/p>\n<p style=\"text-align: left;\"><strong>What many interviews do I need?<\/strong> At least two. One must be an expert; the other must be involved somehow.<\/p>\n<p style=\"text-align: left;\"><strong>Do I have to do extensive work in MySQL?<\/strong> No, just the initial data work to obtain the table you want, which can be then<br \/>\nexported as a csv file.<\/p>\n<p style=\"text-align: left;\"><strong>Will I be required to use visualizations?<\/strong> Yes, at least two,<span style=\"color: #000000;\"> INCLUDING <\/span>DocumentCloud.<\/p>\n<p style=\"text-align: left;\"><strong>Will I required to hyperlink key references in my text to the original source?<\/strong> Absolutely!<\/p>\n<p style=\"text-align: left;\"><strong>Can I submit outlines and drafts?<\/strong> Yes, but given the size of the class, I can only review one version.<\/p>\n<p style=\"text-align: left;\"><strong>What do I submit?<\/strong> The same as the first assignment: The 600-word story posted to an assigned category on our WordPress site;<br \/>\na 500-word\u00a0background document; and ONE\u00a0dataset as a csv \u00a0or Excel file.<\/p>\n<p style=\"text-align: left;\"><strong>Will I be docked half a grade for neglecting to submit any of the required elements?<\/strong> Yes.<\/p>\n<p style=\"text-align: left;\"><strong>Remember:<\/strong> Keep it simple. Tell a story!!<\/p>\n<h6 style=\"text-align: left;\"><strong>Week Eight\u00a0(<a href=\"#TOP\" name=\"Week7\">TOP<\/a>)\u00a0<\/strong><\/h6>\n<h6 style=\"text-align: left;\">Oct.\u00a021<\/h6>\n<p style=\"text-align: left;\">To download the first MySQL tutorial using the Ottawa restaurant inspection data, please click \u00a0<a href=\"http:\/\/www.davidmckie.com\/Restaurant%20Inspection Data for Ottawa.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the second MySQL tutorial using the city of Ottawa’s restaurant inspection data, please\u00a0click <a href=\"http:\/\/www.davidmckie.com\/Restaurant%20Inspection Data for Ottawa_PartTwo.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the queries used for the second tutorial using the city of Ottawa restaurant inspection data,<br \/>\nplease click <a href=\"http:\/\/www.davidmckie.com\/ScriptsForSecondRestaurantInspectionTutorial.sql\">here<\/a>, right click, save the file, and remove the “txt” extension at the end of the file.<br \/>\nOnce you’ve saved the file that only contains the “sql” extension, save it to the folder that you’re using for the tutorial,<br \/>\nand then open it in MySQL.<\/p>\n<p style=\"text-align: left;\">Continuation with MySQL<\/p>\n<p style=\"text-align: left;\">To download the zip file containing the city of Ottawa’s parking violation data from 2010 to the June 8, 2015, please click <a href=\"http:\/\/www.davidmckie.com\/Dump20150816_OttawaParkingTickets.zip\">here.<\/a><\/p>\n<p style=\"text-align: left;\">To download a tip sheet for querying the parking violation data, please click <a href=\"http:\/\/www.davidmckie.com\/Tips%20working with the city of Ottawa parking ticket data.pdf\" target=\"_blank\">here.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Links<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>Health violations found at trendy Uncle Tetsu\u2019s Cheesecake<\/strong><br \/>\n<a href=\"http:\/\/www.metronews.ca\/news\/toronto\/2015\/07\/14\/health-violations-found-at-trendy-uncle-tetsus-cheesecake.html\">http:\/\/www.metronews.ca\/news\/toronto\/2015\/07\/14\/health-violations-found-at-trendy-uncle-tetsus-cheesecake.html<\/a><\/p>\n<p style=\"text-align: left;\"><strong>The Hornet’s Sting<\/strong><br \/>\n<a href=\"http:\/\/www.canada.com\/story.html?id=c5169c59-1adc-4687-867b-f02352b5a67b\">http:\/\/www.canada.com\/story.html?id=c5169c59-1adc-4687-867b-f02352b5a67b<\/a><\/p>\n<p style=\"text-align: left;\"><strong>‘I was only gone for two minutes …’<\/strong><br \/>\n<a href=\"http:\/\/www.canada.com\/story.html?id=f06e6a5d-25b4-4cc1-87e4-c1f0abb48dcd\">http:\/\/www.canada.com\/story.html?id=f06e6a5d-25b4-4cc1-87e4-c1f0abb48dcd<\/a><\/p>\n<p style=\"text-align: left;\"><strong>DineSafe cuts rate of sickness<\/strong><br \/>\n<a href=\"http:\/\/www.thestar.com\/life\/health_wellness\/nutrition\/2009\/04\/17\/dinesafe_cuts_rate_of_sickness.html\">http:\/\/www.thestar.com\/life\/health_wellness\/nutrition\/2009\/04\/17\/dinesafe_cuts_rate_of_sickness.html<\/a><\/p>\n<p style=\"text-align: left;\">To download the MySQL Ottawa restaurant dump file, please click <a href=\"http:\/\/www.davidmckie.com\/OttawaRestaurantInspectionsDumpFile.sql\">here<\/a>.<\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Nine(<a href=\"#TOP\" name=\"Week8\">TOP<\/a>)\u00a0(Fall break)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Oct. 28<\/strong><\/h6>\n<p style=\"text-align: left;\">Have a good break!!<\/p>\n<p style=\"text-align: left;\"><strong>Assignment: TBA It will be due on Nov. 25<\/strong><\/p>\n<p style=\"text-align: left;\">Reading for next class: Chapter seven “Mapping Your Way to the Story”<\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Ten(<a href=\"#TOP\" name=\"Week9\">TOP<\/a>)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Nov. 4<\/strong><\/h6>\n<p style=\"text-align: left;\">An introduction to mapping with <a href=\"https:\/\/www.library.carleton.ca\/contact\/staff-directory\/rebecca-bartlett\" target=\"_blank\">Rebecca Bartlett<\/a> and <a href=\"https:\/\/www.library.carleton.ca\/contact\/staff-directory\/joel-rivard\" target=\"_blank\">Joel Rivard<\/a>, the specialists from the Carlton library who will be supporting us during the next few weeks.<\/p>\n<p style=\"text-align: left;\">To obtain the instructions for downloading Qgis, please click <a href=\"http:\/\/www.davidmckie.com\/Instructions%20for installing QGIS on a PC and a Mac.pdf\" target=\"_blank\">here<\/a><\/p>\n<p style=\"text-align: left;\">To download the first Qgis tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Journalism4101_GISHandout2015.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Eleven(<a href=\"#TOP\" name=\"Week10\">TOP<\/a>)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Nov. 11<\/strong><\/h6>\n<p style=\"text-align: left;\">A continuation of Qgis<\/p>\n<p style=\"text-align: left;\">Repeat the first part of the Qgis tutorial from last week.<\/p>\n<p style=\"text-align: left;\">To download the search-and-rescue data for \u00a0Qgis, please click <a href=\"http:\/\/www.davidmckie.com\/SearchAndRescue.zip\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Working with census data from the city of Ottawa’s open data <a href=\"http:\/\/data.ottawa.ca\/dataset?q=census&sort=score+desc%2C+metadata_modified+desc\">site<\/a><\/p>\n<p style=\"text-align: left;\">To download the city of Ottawa’s 2014 ward shape file, please click <a href=\"http:\/\/data.ottawa.ca\/dataset?q=wards&sort=score+desc%2C+metadata_modified+desc\">here<\/a><\/p>\n<p style=\"text-align: left;\">Statistics Canada’s Beyond 20\/20 browser. To download, please click <a href=\"http:\/\/www.statcan.gc.ca\/eng\/public\/beyond20-20\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Census data from Reporting Methods syllabus. Please click <a href=\"http:\/\/www.davidmckie.com\/reporting-methods-carleton-university-journalism-5206\/#Census1\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Links<\/p>\n<p style=\"text-align: left;\"><strong>Elections Canada<\/strong><br \/>\n<a href=\"http:\/\/www.elections.ca\/home.aspx\">http:\/\/www.elections.ca\/home.aspx<\/a><\/p>\n<p id=\"wb-cont\" style=\"text-align: left;\"><strong>Completed Access to Information Requests (Federal)<\/strong><br \/>\n<a href=\"http:\/\/open.canada.ca\/en\/search\/ati?\">http:\/\/open.canada.ca\/en\/search\/ati?<\/a><\/p>\n<p style=\"text-align: left;\">F<strong>reedom of Information Requests Summary (City of Toronto)<\/strong><br \/>\n<a href=\"http:\/\/www1.toronto.ca\/wps\/portal\/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD\">http:\/\/www1.toronto.ca\/wps\/portal\/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Buyandsell.gc.ca (Public Works and Government Services Canada tender notices)<\/strong><br \/>\n<a href=\"https:\/\/buyandsell.gc.ca\/procurement-data\/tenders\">https:\/\/buyandsell.gc.ca\/procurement-data\/tenders<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Government-Wide Reporting \u2014 Proactive Disclosure (Treasury Board Secretariat of Canada)<br \/>\n<\/strong><a href=\"http:\/\/www.tbs-sct.gc.ca\/pd-dp\/gr-rg\/index-eng.asp\">http:\/\/www.tbs-sct.gc.ca\/pd-dp\/gr-rg\/index-eng.asp<\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/open.canada.ca\/data\/en\/dataset\/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3\">http:\/\/open.canada.ca\/data\/en\/dataset\/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3<\/a><\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Twelve(<a href=\"#TOP\" name=\"Week12\">TOP<\/a>)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Nov. 18<\/strong><\/h6>\n<p style=\"text-align: left;\">A continuation of mapping census tracks<\/p>\n<p style=\"text-align: left;\">To download the cleaned-up version of the city of Ottawa’s 2014 wards file, please click <a href=\"http:\/\/www.davidmckie.com\/2014%20Wards_new.zip\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the Qgis mapping tutorial, using the Ottawa census data, please click <a href=\"http:\/\/www.davidmckie.com\/Census%20tutorial using the city of Ottawa.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To obtain \u00a0the Public Safety document that we requested last week through the federal \u00a0government’s<br \/>\nopen-data site, please click <a href=\"http:\/\/www.davidmckie.com\/(David%20McKie, Nov. 12, 2015) Pro-active disclosure_cyber threats oil and gas pipeline_AI-2015-00110-GR.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\"><strong>Links:<\/strong><\/p>\n<p class=\"story-title\" style=\"text-align: left;\"><strong>Refugee board members’ rulings varied widely in 2014, data suggests<\/strong><br \/>\n<a href=\"http:\/\/www.cbc.ca\/news\/politics\/refugee-board-members-rulings-varied-widely-in-2014-data-suggests-1.3076080\">http:\/\/www.cbc.ca\/news\/politics\/refugee-board-members-rulings-varied-widely-in-2014-data-suggests-1.3076080<\/a><\/p>\n<p class=\"title gutter\" style=\"text-align: left;\"><strong>2014 Refugee Claim Data and IRB Member Recognition Rates<\/strong><br \/>\n<a href=\"http:\/\/ccrweb.ca\/en\/2014-refugee-claim-data\">http:\/\/ccrweb.ca\/en\/2014-refugee-claim-data<\/a><\/p>\n<p class=\"title gutter\" style=\"text-align: left;\"><strong>Air France tweet about a diversion to Halifax<\/strong><br \/>\n<a href=\"https:\/\/mobile.twitter.com\/afnewsroom\/status\/666825287850696704\">https:\/\/mobile.twitter.com\/afnewsroom\/status\/666825287850696704<\/a><\/p>\n<p style=\"text-align: left;\" data-pb-field=\"customFields.web_headline\"><strong>Air France flight from Dulles Airport is diverted after threats were received<\/strong><br \/>\n<a href=\"https:\/\/www.washingtonpost.com\/local\/2015\/11\/17\/c7840394-8da7-11e5-ae1f-af46b7df8483_story.html?wpisrc=al_alert-COMBO-world%252Bnation\">https:\/\/www.washingtonpost.com\/local\/2015\/11\/17\/c7840394-8da7-11e5-ae1f-af46b7df8483_story.html?wpisrc=al_alert-COMBO-world%252Bnation<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Civil Aviation Daily Occurrence Reporting System (CADORS)<\/strong><br \/>\n<a href=\"http:\/\/wwwapps.tc.gc.ca\/saf-sec-sur\/2\/cadors-screaq\/m.aspx?lang=eng\">http:\/\/wwwapps.tc.gc.ca\/saf-sec-sur\/2\/cadors-screaq\/m.aspx?lang=eng<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Incident-based crime statistics, by detailed violations<\/strong><br \/>\n<a href=\"http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&id=2520051\">http:\/\/www5.statcan.gc.ca\/cansim\/a26?lang=eng&id=2520051<\/a><\/p>\n<h6 style=\"text-align: left;\"><strong><b>Week Thirteen(<a href=\"#TOP\" name=\"Week13\">TOP<\/a>)<\/b><\/strong><\/h6>\n<h6 style=\"text-align: left;\"><strong>Nov. 25<\/strong><\/h6>\n<p style=\"text-align: justify;\">Mapping quiz<\/p>\n<p style=\"text-align: justify;\">Outputting files tables from MySQL for geocoding using restaurant inspections<\/p>\n<p style=\"text-align: justify;\">To download the restaurant MySQL dump file, please click <a href=\"http:\/\/www.davidmckie.com\/RestaurantsInspectionDumpFile.sql\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">To download the geocoding tutorial using Qgis, please click \u00a0<a href=\"http:\/\/www.davidmckie.com\/Geocoding%20Using%20QGIS_New.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">GPS Visualizer<br \/>\n<a href=\"http:\/\/www.gpsvisualizer.com\/\">http:\/\/www.gpsvisualizer.com\/<\/a><\/p>\n<p style=\"text-align: justify;\">An introduction to Geocoding and ArcGIS Online<\/p>\n<p id=\"wb-cont\" class=\"h2 mrgn-tp-sm\" style=\"text-align: left;\">Federal Districts Canada – 2013<br \/>\n<a href=\"http:\/\/geogratis.gc.ca\/api\/en\/nrcan-rncan\/ess-sst\/56124851-71fc-4f94-8df2-40f59cd1dd46.html\">http:\/\/geogratis.gc.ca\/api\/en\/nrcan-rncan\/ess-sst\/56124851-71fc-4f94-8df2-40f59cd1dd46.html<\/a><\/p>\n<p style=\"text-align: justify;\">To download the search-and-rescue data, please click <a href=\"http:\/\/www.davidmckie.com\/SARData.xlsx\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">A Tim Hortons mapped out by wards in Google Fusion Table<br \/>\n<a style=\"font-family: inherit; font-size: inherit; line-height: 2;\" href=\"https:\/\/www.google.com\/fusiontables\/data?docid=1gHsGlEkBzA0791Bnsvldw5of9Zif0JMnsfe00i5e#map:id=3\">https:\/\/www.google.com\/fusiontables\/data?docid=1gHsGlEkBzA0791Bnsvldw5of9Zif0JMnsfe00i5e#map:id=3<\/a><\/p>\n<h6 style=\"text-align: justify;\"><strong>Links:\u00a0<\/strong><\/h6>\n<p style=\"text-align: justify;\"><strong>The Bank of Canada’s Inflation Calculator<\/strong><br \/>\n<a href=\"http:\/\/www.bankofcanada.ca\/rates\/related\/inflation-calculator\/\">http:\/\/www.bankofcanada.ca\/rates\/related\/inflation-calculator\/<\/a><\/p>\n<p style=\"text-align: justify;\"><strong><span class=\"story-flag exclusive\">EXCLUSIVE:\u00a0<\/span>Search and rescue for false alarms costs millions<\/strong><br \/>\n<a href=\"http:\/\/www.cbc.ca\/news\/politics\/search-and-rescue-for-false-alarms-costs-millions-1.2594306\">http:\/\/www.cbc.ca\/news\/politics\/search-and-rescue-for-false-alarms-costs-millions-1.2594306<\/a><\/p>\n<h6 style=\"text-align: justify;\"><strong>Qs and As for the final assignment<\/strong><\/h6>\n<p style=\"text-align: justify;\"><strong>When is the assignment due?<\/strong> Between Dec. 4 at midnight and Dec. 9 at midnight.<\/p>\n<p style=\"text-align: justify;\"><strong>What’s the word length?<\/strong> 600 words.<\/p>\n<p style=\"text-align: justify;\"><strong>What do I need so submit?<\/strong><\/p>\n<p style=\"text-align: left;\">1. csv file with your table;<br \/>\n2. a 500-word background document;<br \/>\n3. your story — with visualizations \u00a0and hyperlinks — as a Word file.<\/p>\n<p style=\"text-align: justify;\"><strong>Since I have to submit my story as a Word file, must I still upload it to the website?<\/strong> Yes.<\/p>\n<p style=\"text-align: justify;\"><strong>Where should I upload my story?<\/strong> To the category “Data Assignment_Three_2015”<\/p>\n<p style=\"text-align: justify;\"><strong>How many visual elements do I need?<\/strong> At least three, INCLUDING your embedded census file on ArcGIS Online, and<br \/>\na document uploaded and annotated in DocumentCloud<\/p>\n<p style=\"text-align: justify;\"><strong>Do the visualizations need to have a title and source?<\/strong> Yes.<\/p>\n<p style=\"text-align: justify;\"><strong>Will I be penalized for omitting a title, source, or both?<\/strong> Yes!<\/p>\n<p style=\"text-align: justify;\"><strong>What dataset should I use?<\/strong> The Ottawa census data, combined with the 2014 Ward shape file that you’ve been working with.<\/p>\n<p style=\"text-align: justify;\"><strong>How many voices does my story need?<\/strong> At least two, including an expert on the demographic trend upon which your story is based.<\/p>\n<p style=\"text-align: justify;\"><strong>Does an email exchange count as an interview?<\/strong>\u00a0As a fallback, yes. You should push for an interview in person, or over the phone. If you’re stuck with an emailed response, be sure to indicate it as such in your story.<\/p>\n<p style=\"text-align: justify;\"><strong>Will I be required to hyperlink key references in my text to the original source?<\/strong> Absolutely!<\/p>\n<p style=\"text-align: justify;\"><strong>Can I hyperlink to media report?<\/strong> No. Find the original document, or dataset and hyperlink to that. Remember, media reports are frequently forced to \u00a0issue\u00a0corrections. So you don’t want to be repeating someone else’s mistake. It’s always better to obtain your information from the original source.<\/p>\n<p style=\"text-align: left;\"><strong>Can I submit outlines and drafts?<\/strong> Yes, but given the size of the class, I can only review one version per student.<\/p>\n<p style=\"text-align: justify;\"><strong>Dec. 2<\/strong><\/p>\n<p style=\"text-align: left;\">To download the 2013 federal electoral boundary zip file we’ll<br \/>\nbe using for the test, please click <a href=\"http:\/\/www.davidmckie.com\/fed_cf_CA_2_1_shp_en.zip\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the csv search-and-rescue file we’ll be using for the test,<br \/>\nplease click, or right-click,\u00a0<a href=\"http:\/\/www.davidmckie.com\/SARDataForTest.csv\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To open the mapping test in a separate browser, please click <a href=\"http:\/\/www.davidmckie.com\/GIS%20test.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">Continuation of ArcGIS Online<\/p>\n<p style=\"text-align: left;\"><strong>Links:<\/strong><\/p>\n<p class=\"entry-title single-title\" style=\"text-align: left;\"><strong>Syrian refugees to begin arriving December 10: Government website<\/strong><br \/>\n<a href=\"https:\/\/ipolitics.ca\/2015\/12\/01\/syrian-refugees-to-begin-arriving-december-10-government-website\/\">https:\/\/ipolitics.ca\/2015\/12\/01\/syrian-refugees-to-begin-arriving-december-10-government-website\/<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Flights to Canada for Syrian refugees to start Dec. 10, document says<\/strong><br \/>\n<a href=\"http:\/\/www.cbc.ca\/news\/politics\/flights-to-canada-for-syrian-refugees-to-start-dec-10-document-says-1.3346228\">http:\/\/www.cbc.ca\/news\/politics\/flights-to-canada-for-syrian-refugees-to-start-dec-10-document-says-1.3346228<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Buyandsell.gc.ca (Public Works and Government Services Canada tender notices)<\/strong><br \/>\n<a href=\"https:\/\/buyandsell.gc.ca\/procurement-data\/tenders\">https:\/\/buyandsell.gc.ca\/procurement-data\/tenders<\/a><\/p>\n<p style=\"text-align: left;\"><strong>Government-Wide Reporting \u2014 Proactive Disclosure (Treasury Board Secretariat of Canada)<br \/>\n<\/strong><a href=\"http:\/\/www.tbs-sct.gc.ca\/pd-dp\/gr-rg\/index-eng.asp\">http:\/\/www.tbs-sct.gc.ca\/pd-dp\/gr-rg\/index-eng.asp<\/a><\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/open.canada.ca\/data\/en\/dataset\/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3\">http:\/\/open.canada.ca\/data\/en\/dataset\/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3<\/a><\/p>\n<p class=\"entry-title single-title\" style=\"text-align: left;\"><strong>Doomed Harper government made 49 \u201cfuture\u201d patronage appointments<\/strong><br \/>\n<a href=\"http:\/\/ipolitics.ca\/2015\/11\/23\/doomed-harper-government-made-49-future-patronage-appointments\/\">http:\/\/ipolitics.ca\/2015\/11\/23\/doomed-harper-government-made-49-future-patronage-appointments\/<\/a><\/p>\n<p class=\"entry-title single-title\" style=\"text-align: left;\"><strong>NICAR Listserv<\/strong><br \/>\n<a href=\"http:\/\/www.ire.org\/resource-center\/listservs\/\">http:\/\/www.ire.org\/resource-center\/listservs\/<\/a><\/p>\n<p class=\"story-title\" style=\"text-align: left;\"><strong><b>Tutorials(<a href=\"#TOP\" name=\"Tutorials1\">TOP<\/a>)<\/b><\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week one:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week two:<\/strong> <a href=\"http:\/\/www.davidmckie.com\/The%20sunshine list tutorial.pdf\" target=\"_blank\">.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>From week two:<\/strong><\/p>\n<p class=\"entry-title\" style=\"font-weight: 100; text-align: left;\"><strong>From week three:<\/strong><\/p>\n<p class=\"entry-title\" style=\"text-align: left;\">To download the instructions for downloading MySQL, please click<a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows.pdf\" target=\"_blank\"> here<\/a>.<\/p>\n<p class=\"entry-title\" style=\"text-align: left;\">To download the Logical Functions And IF Statements tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Tutorial%20using Logical functions and IF Statements.pdf\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">\u00a0<strong>From week four:<\/strong><\/p>\n<p style=\"text-align: left;\">To download the Windows version of MySQL downloading tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows tutorial.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the Mac version of the MySQL downloading tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on a Mac.pdf\" target=\"_blank\">here<\/a><a href=\"http:\/\/www.davidmckie.com\/Installing%20MYSQL on Windows_revised.pdf\" target=\"_blank\">.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>From week five:<\/strong><\/p>\n<p style=\"text-align: left;\">To download the MySQL tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/Tutorial%20for importing Ottawa Fire Hydrant Parking Violation Data Into MySQL.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the MySQL queries for the Ottawa 2008 parking data, please click <a href=\"http:\/\/www.davidmckie.com\/HYDRANT_2008%20SCRIPTS FOR CLASS.sql\" target=\"_blank\">here.<\/a><\/p>\n<p style=\"text-align: left;\">To download the MSQL load Mac query for the Ottawa 2008, please click <a href=\"http:\/\/www.davidmckie.com\/Parking.sql\">here.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>From week six:<\/strong><\/p>\n<p style=\"text-align: left;\">To download the city of Ottawa 2008-2014 Fire Hydrant Parking Ticket Data for the continuation of our MySQL tutorial, please click <a href=\"http:\/\/www.davidmckie.com\/HydrantViolations_2008-2014.zip\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the second half of the MySQL tutorial using Ottawa’s Fire Hydrant Parking Ticket Data, please click <a href=\"http:\/\/www.davidmckie.com\/A%20continuation of the MySQL tutorial.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\">To download the third MySQL tutorial using the Ottawa restaurant inspection data, please click \u00a0<a href=\"http:\/\/www.davidmckie.com\/Restaurant%20Inspection Data for Ottawa.pdf\" target=\"_blank\">here<\/a>.<\/p>\n<p style=\"text-align: left;\"><strong>From week seven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week seven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week seven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week seven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week ten:\u00a0<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week ten:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week eleven:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>From week eleven:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>From week thirteen:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>From week thirteen:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>From week thirteen:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>From week thirteen:<\/strong><\/p>\n<h6 style=\"text-align: justify;\"><strong>Data sets(<a href=\"#TOP\" name=\"Data1\">TOP<\/a>)<\/strong><\/h6>\n<p style=\"text-align: left;\"><strong>From examples in the syllabus introduction:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From examples in the syllabus introduction:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From examples in the syllabus introduction:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week one:\u00a0<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week two:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week three:<\/strong><\/p>\n<p style=\"text-align: left;\">Download federal campaign\u00a0<a href=\"http:\/\/davidmckie.com\/FederalCampaignContributions.xlsx\" target=\"_blank\">donation data\u00a0<\/a><\/p>\n<p style=\"text-align: left;\"><strong>From week two:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week three:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week five:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week six:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week seven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week eight:<\/strong><\/p>\n<p style=\"text-align: left;\">To download the zip file containing the city of the city of Toronto’s parking violation data from 2008 to the 2014, pleases click <a href=\"http:\/\/www.davidmckie.com\/Dump20150308.zip\">here.<\/a><\/p>\n<p style=\"text-align: left;\"><strong>From week nine:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week ten:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week eleven:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week twelve:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week thirteen:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>From week fourteen:<\/strong><\/p>\n<h6 style=\"text-align: left;\"><\/h6>\n<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\" height=\"26\"><\/td>\n<td style=\"text-align: left;\"><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Journalism research methods, Fall 2015\u00a0JOUR 4101 – E Wednesdays 19:00-22:00 Location: Room 1105 River Building (the TV Newsroom) David McKie 181 Queen Street 1-613-288-6523 (office) 1-613-290-7380 (cell) 1-613-288-6490 (fax) Email: david.mckie@cbc.ca Week one |\u00a0Week two |\u00a0Week three |\u00a0Week four |\u00a0Week five |\u00a0Week six|\u00a0Week seven |\u00a0Week eight | Week nine |\u00a0Week ten |\u00a0Week eleven |\u00a0Week … <a href=\"http:\/\/www.davidmckie.com\/fall-2015-jour-4101\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Fall 2015 JOUR 4101<\/span> <span class=\"meta-nav\">→<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-9571","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/pages\/9571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/comments?post=9571"}],"version-history":[{"count":108,"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/pages\/9571\/revisions"}],"predecessor-version":[{"id":10754,"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/pages\/9571\/revisions\/10754"}],"wp:attachment":[{"href":"http:\/\/www.davidmckie.com\/wp-json\/wp\/v2\/media?parent=9571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}