1. Write a book review of an English-language, non-fiction book that you have read recently in the general area of economics and/or politics. Imagine that your book review will be published in an online blog aimed at Carleton students, and therefore pitch it to that audience. For guidance on writing a book review, see the discussion at https://owl.purdue.edu/owl/general_writing/common_writing_assignments/book_reviews.html
NOTE: Please be sure to avoid plagiarism in your answer to this question.
2. Recall the construction of the line and stacked area charts for Beef, Pork, and Chicken Availability Per Capita in the US, 1910-2017, shown in Figures 6.33 and 6.34, respectively.
i) Using Google Sheets, construct a similar line chart and a similar stacked area chart for Per Capita Consumption of Meats in Canada, 1986-2015. The relevant data are available for download in an Excel spreadsheet at https://open.canada.ca/data/en/dataset/345b4d0e-d4e5-45bf- be00-295881865b72
NOTE: This Excel spreadsheet contains data for five different meats, so naturally your line chart should include five lines and your stacked area chart should include five layers. You may ignore the US data.
The first sheet (tab) of your Google Sheets spreadsheet should contain both the data (in a similar format and location – top-left – as in Figure 6.32). The second sheet (tab) should contain the line chart. The third sheet (tab) should contain the stacked area chart. And, the fourth sheet (tab) should contain the source information for the data.
ii) Name your Google Sheets spreadsheet Assignment 3 Question 2 and, following the appropriate instructions from Section 2.5 (Share Your Google Sheets), use the Share function to allow “anyone with the link” to access your Google Sheets spreadsheet, and then copy the link into your assignment as your answer to Question 2.
3. Recall the construction of the Datawrapper symbol point map for US City Population Change from 2010 to 2019 shown in Figure 7.35.
i) Using data from the Excel spreadsheet SUB-IP-EST2019-ANNRES-37.xlsx, available at https://www2.census.gov/programs-surveys/popest/tables/2010-2019/cities/totals/ , construct a Google Sheets spreadsheet for North Carolina Incorporated Places Population Change from 2010 to 2019, which is analogous to the Google Sheets spreadsheet for US City Population Change from 2010 to 2019 referred to in the textbook. Name your Google Sheets spreadsheet Assignment 3 Question 3 and, following the appropriate instructions from Section 2.5 (Share Your Google Sheets), use the Share function to allow “anyone with the link” to access your Google Sheets spreadsheet, and then copy the link into your assignment as your answer to part i). Note that you will have to strip off the “village”, “town”, and “city” designations for the various incorporated places.
ii) Following the instructions given in the textbook, download the data from your Google Sheets spreadsheet in CSV format to your computer. Then, use Datawrapper to construct a symbol point map for North Carolina Incorporated Places Population Change from 2010 to 2019, which is analogous to the symbol point map for US City Population Change from 2010 to 2019 shown in Figure 7.35. Be sure to select the USA >> North Carolina >> Municipalities map from within Datawrapper as the basis for your symbol point map. To avoid the symbol point map becoming too cluttered, be sure to use a maximum symbol size of 15 pixels for the circle symbol. Also, be sure to include a customized tooltip so that the reader can see both the 2019 population and the percentage change in population from 2010 through 2019 when they hover over a particular incorporated area.
When you have finished constructing your chart, click on Publish & Embed, click on Publish, then, under Share & Embed, find the Link to your visualization, click on the button entitled For Sharing, and then copy the URL to your Clipboard by clicking on the Clipboard button. Then, paste the URL from your Clipboard into your assignment as your answer to part ii).
2
NOTE: You will have to log in to your (free) Datawrapper account in order to be able to Publish your chart.
