1. a) Download the Excel file labelled 'Permanent Residents' from cuLearn. The table in the Excel file shows data on permanent residents by immigrant admission category and source country.

• What kinds of immigrant categories are there and what are the purposes of the main categories? (4 points)
• Make a line graph which shows the numbers of immigrants to Canada by category, from 2007 to 2016. (3 points)
• Which category was the largest in 2007? (1 point)
• Which was the largest in 2016? (1 point)

1. b) DownloadtheExcelfilelabelled'ResettledRefugeesandProtectedPersonsin Canada - Source Region' from cuLearn. The table in the Excel file shows the distribution of source regions for Resettled Refugees and Protected Persons in Canada.

• Make a stacked bar graph that shows where immigrants who entered Canada under the Resettled Refugees and Protected Persons in Canada program came from (i.e. source regions). Your graph should show source region compositions for each year from 2007 to 2016. (3 points)
• Describe the trends that you see. (2 points)

c) Download the Excel file labelled 'Admission Category and Destination Province' from cuLearn. The table in the Excel file shows where immigrants of each category resided on their arrival to Canada.

• Make a horizontal bar graph showing where each category of immigrant resided upon their arrival in Canada in 2016. (3 points)
• Where do economic immigrants tend to reside on arrival? Sponsored Family? Refugees? Describe. (3 points)

Admission Category and Destination Province.xlsx

Permanent Residents.xlsx

Resettled Refugees and Protected Persons in Canada - Source Region.xlsx

AutoSave OFF A APP . CO ... Resettled Refugees and Protected Persons in Canada - Source Region Home Insert Draw Page Layout Formulas Data Review View ? Tell me I Share Comments Insert v Calibri (Body) v 11 AA ab Wrap Text General Ex AP- O. Ex Delete v v Z Paste BIUV DVAv E Merge & Center $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data C16 4 X V J A B C D E F G H K 1 Source Regions for Resettled Refugees and Protected Persons in Canada, 2007 - 2016 Resettled Refugees and protected persons in Canada 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 w 4 Africa and the Middle East 33.5 42.2 48.4 45.4 45.9 46.4 55.7 57.9 67.6 32.8 5 Asia and Pacific 34.2 29.2 28.9 27.1 25.6 24.7 19 9 18.5 16.8 10.2 6 Europe 7.0 4.5 3.5 3.5 3.3 3.8 4.0 5.0 3.7 2.1 7 U.S.A. 1.5 1.1 1.3 2.7 2.8 3.0 1.9 1.4 0.8 0.3 8 Americas 22.8 22.1 17.0 20.0 21.3 21.1 7.8 14.8 9.2 3.6 1.9 1.1 9 No State Given 0.9 0.8 0.9 1.3 1.0 1.0 0.7 2.4 10 11 Source: IRCC Open Data Portal: https://open.canada.ca/data/dataset/1d3963d6-eea9-4a4b-8e4a-5c7f2deb7f29 12 13 14 15 16 17 18 19 20 21 22 4 Source Regions + + 190% ReadyAutoSave OFF A APP . CO ... Admission Category and Destination Province Home Insert Draw Page Layout Formulas Data Review View ? Tell me I Share Comments Calibri (Body) v 11 AA ab Wrap Text General Insert v Ex AP- O. Ex Delete v Paste BIUV DVAv E Merge & Center $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Sensitivity Filter Select Data D19 + X V fx A B C D E F G H 1 First Destination for Immigrants to Canada in 2016, by Admission Category 2 Admission category and destination province All Other Economic Sponsored Family Resettled Refugee & Protected W Person in Canada Immigration Newfoundland and Labrador 56 193 336 3 Prince Edward Island 1,966 82 264 1 6 Nova Scotia 3,384 654 1,423 22 7 New Brunswick 2,640 333 1,686 16 8 Quebec 31,600 11, 126 9,423 1,086 9 Ontario 45, 106 35,149 28,187 1,569 10 Manitoba 10,688 2,379 3,730 23 11 Saskatchewan 10,971 1,961 1,893 30 12 Alberta 28,430 13,012 7,215 539 13 British Columbia 20,303 12,972 4.656 135 14 Territories 256 143 30 3 15 16 Source: IRCC Open Data Portal: https://open.canada.ca/data/dataset/1d3963d6-eea9-4a4b-8e4a-5c7f2deb 7f29 17 18 19 20 D Destination Province + Ready + 200%AutoSave OFF A APP . CO ... Permanent Residents Home Insert Draw Page Layout Formulas Data Review View Tell me I Share Comments Calibri (Body) v 11 AA Insert v = ab Wrap Text General Ex AP- O. Ex Delete v v Z Paste BIUV VAv E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data C11 fx A B C D E F G H K 1 Immigrants to Canada by Admission Category, 2007 - 2016 Permanent Residents W N 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Economic 131,264 149,098 153,514 186,938 156,099 160,744 148,252 165, 198 170,375 156,000 71,982 65,553 67,648 78.004 Sponsored Family 72,139 71,894 1,335 69.868 $3,375 5.484 Resettled Refugee & Protected Person in Canada 27,963 21,860 22,851 24,69 27,876 23,095 24.139 24,070 32,113 58,912 Other 5,385 4,390 3,823 3,498 3,391 4,054 3,266 3,377 3,844 3,430 Source: IRCC Open Data Portal: https://open.canada.ca/data/dataset/1d3963d6-eea9-4a4b-8e4a-5c7f2deb7f29 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Admission Category + + 171% Ready