In this assignment, you will use U.S. Census data about state statistics to create interactive maps using two different tools.<\/p>\n
Getting Census Data<\/span><\/p>\nThe U.S. Census Bureau<\/a> is an important source of data at the national, state and local level in the United States. There is a census of all people in the U.S. every 10 years, which is mandated by the Constitution. But the Census Bureau is also responsible for a number of other surveys and information, including the American Community Survey.<\/p>\nCensus Reporter<\/strong> is an independent project for making U.S. Census data easier for journalists to browse and use. This assignment will use data downloaded from Census Reporter and mapped with Datawrapper and Flourish.<\/p>\n1. Browse Census Reporter to download a dataset.<\/p>\n\nGo to the Census Reporter page for income data: censusreporter.org\/topics\/income<\/a><\/li>\nClick on a code number for the data table you want to use. The instructions will use “Median Household Income” and you can choose that, or you can pick a different one.<\/li>\nIn the box that prompts you to type a location, start typing any state name and then select it. This will display the data for that state.<\/li>\nTo add all the other states, look for the “Add all states in…” link on the left and choose all of the U.S. states.<\/li>\n<\/ul>\nStart typing any state name, and make sure to choose the option labeled “state” over on the right in italics.<\/p><\/div>\nThis allows you to quickly add the exact same information for all other states.<\/p><\/div>\n2. As long as all 50 states are included in your data table, you can now download the data.<\/p>\n\nClick the download link in the top right and choose CSV.<\/li>\nThis will download a zip folder to your computer. Unzip the folder to extract the CSV file. You can rename it to a more descriptive name if you want.<\/li>\n<\/ul>\nCSV is a structured text file that we’re using in this instance because it’s accepted by all the different tools we want to use. It’s worth noting that one of the tools, Flourish, also accepts GeoJSON, which eliminates the step of matching up the geographies.<\/p><\/div>\n3. Don’t leave Census Reporter quite yet! If you scroll to the bottom of the page with the data you just downloaded, there is citation information that includes the precise description of this data. You’ll use this for your interactive maps, so either copy the citation or leave this page open.<\/p>\n\nThis tutorial video shows the process for downloading data and initial steps for creating a map:<\/p>\n<\/iframe><\/p>\n<p><span class=\"header\">Making Interactive Maps<\/span><\/p>\n<p>Now, display the income data on an interactive map. We’ll be using two web tools. They are free, but you will need to sign up for an account to save and submit your work:<\/p>\n<ul>\n<li>Flourish: <a href=\"https:\/\/flourish.studio\" target=\"_blank\" rel=\"noopener noreferrer\">flourish.studio<\/a><\/li>\n<li>Datawrapper: <a href=\"https:\/\/www.datawrapper.de\" target=\"_blank\" rel=\"noopener noreferrer\">www.datawrapper.de<\/a><\/li>\n<\/ul>\n<p>Both maps will display the same information, and you can make them in any order. Tips for each one are included below, but you are welcome to just try out the tools and see what happens.<\/p>\n<p>For both, make sure each map includes:<\/p>\n<ul>\n<li>A sequential color scale other than the default colors<\/li>\n<li>A descriptive headline that explains what is being shown<\/li>\n<li>The state name and the amount with a $ when you hover<\/li>\n<li>A subhead or text description pointing out an interesting fact (such as the highest or lowest, or how Washington compares).<\/li>\n<li>A data source that includes the full citation from Census Reporter<\/li>\n<\/ul>\n<p><span class=\"subhead\">Flourish<\/span><\/p>\n<p>1. Choose the template for <strong>US (states)<\/strong>.<\/p>\n<p>2. Make the Points Layer “disabled” to hide the unnecessary point data.<\/p>\n<div id=\"attachment_2187\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2187\" class=\"wp-image-2187 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png\" alt=\"\" width=\"800\" height=\"321\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-300x120.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-768x308.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2187\" class=\"wp-caption-text\">The Points Layer could of course be useful for other purposes, but we don’t have any relevant point data at the moment.<\/p><\/div>\n<p>3. Click the Data tab at the top and import your CSV file.<br \/>\n\u2022 Choose the option to <strong>Merge with current sheet<\/strong> to maintain the state shapes and Import Publicly.<br \/>\n\u2022 For the merge, select the columns that include state names.<\/p>\n<div id=\"attachment_2188\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2188\" class=\"wp-image-2188 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png\" alt=\"\" width=\"800\" height=\"373\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-300x140.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-768x358.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2188\" class=\"wp-caption-text\">The goal for merging is finding two columns with the same information so it’s clear how the other information should match up.<\/p><\/div>\n<p>4. For the map “Value” field, choose the column that represents the data you want to display. If you are using Median Household Income, for instance, it needs to be the column with values roughly in the 40,000-80,000 range.<\/p>\n<div id=\"attachment_2189\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2189\" class=\"wp-image-2189 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png\" alt=\"\" width=\"800\" height=\"254\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-300x95.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-768x244.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2189\" class=\"wp-caption-text\">Make sure the “Value” field has the correct column for the information you want the map to display.<\/p><\/div>\n<p>5. Click the “Preview” tab at the top to go back to your map and style it.<br \/>\n\u2022 Look under <strong>Regions Layer<\/strong> to customize colors, style the numbers (add $ sign), and more.<br \/>\n\u2022 Look under <strong>Layout<\/strong> to change the font and background color if you want.<br \/>\n\u2022 Look under <strong>Header<\/strong> and <strong>Footer<\/strong> to add all the necessary text and source information. Note that changing the “Untitled” text in the top left is different from adding a title that will display on the actual map.<\/p>\n<p>6. Publish to get the link for submitting.<\/p>\n<p><span class=\"subhead\">Datawrapper<\/span><\/p>\n<p>1. Start a new map, then choose <strong>Choropleth<\/strong> and <strong>USA \u00bb States<\/strong>.<\/p>\n<p>2. Scroll to the bottom of the page and click <strong>Import your dataset<\/strong>.<br \/>\n\u2022 Click the text link to import a CSV file.<br \/>\n\u2022 The correct column should match automatically \u2014 if the second column has the state names, for instance, then the second callout rectangle should be blue.<br \/>\n\u2022 Do the same thing for selecting which column has the data you want to display.<\/p>\n<div id=\"attachment_2190\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2190\" class=\"wp-image-2190 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png\" alt=\"\" width=\"800\" height=\"352\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-300x132.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-768x338.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2190\" class=\"wp-caption-text\">The two stacked callout rectangles is a design flaw \u2014 there is one rectangle for each column, so the fourth one should be over on the right instead of stacked below.<\/p><\/div>\n<p>3. When your map is color-coded correctly, click the Visualize arrow above the map or the “Proceed” button at the very button to move on.<br \/>\n\u2022 Under <strong>Refine<\/strong>, change the colors, customize the tooltip hover information, and more.<br \/>\n\u2022 Under <strong>Annotate<\/strong>, add all the necessary text and source information.<\/p>\n<div id=\"attachment_2191\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2191\" class=\"wp-image-2191 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png\" alt=\"\" width=\"700\" height=\"290\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png 700w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip-300x124.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><p id=\"caption-attachment-2191\" class=\"wp-caption-text\">You can add any text or labels you want to contextualize the spreadsheet information.<\/p><\/div>\n<p>4. Publish to get the link for submitting.<\/p>\n<p><span class=\"header\">Comparing Tools<\/span><\/p>\n<p>Answer the following questions in a text document:<\/p>\n<p>1. Which tool did you like better for <strong>making the map<\/strong>, and why?<br \/>\n2. Which tool had the <strong>best final product<\/strong> from the perspective of someone viewing the map, and why?<br \/>\n4. Do you think this type of low-level interactivity on a map is useful?<\/p>\n<p><span class=\"header\">Extra Credit Opportunity!<\/span><\/p>\n<p>You can also make this same map in Tableau Public for <strong>5 extra credit points<\/strong>. <em>This is not required.<\/em> Follow the same instructions using your knowledge of Tableau.<\/p>\n<p>A couple of tips:<br \/>\n\u2022 Choose a “Text” data source for CSV files.<br \/>\n\u2022 Tableau may not recognize the states column as geographic data when you first import. Click the little icon in the top left of that column header and assign the correct geographic role.<br \/>\n\u2022 Remember to customize the Tooltip settings to change the hover information.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"277\" class=\"aligncenter size-full wp-image-2192\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png\" alt=\"\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png 500w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog-300x166.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>\n<p><span class=\"header\">Submitting Your Work<\/span><\/p>\n<p>Complete your assignment by submitting the following materials to Blackboard:<\/p>\n<ul>\n<li>Link for published Datawrapper map<\/li>\n<li>Link for published Flourish map<\/li>\n<li>Text document with written responses<\/li>\n<li>Optional for extra credit: Tableau map link<\/li>\n<\/ul>\n<p><em>Please double-check your links in a different web browser or when you are not logged in to make sure they are published publicly!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this assignment, you will use U.S. Census data about state statistics to create interactive maps using two different tools.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2177","post","type-post","status-publish","format-standard","hentry","category-assignments"],"_links":{"self":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/comments?post=2177"}],"version-history":[{"count":5,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions"}],"predecessor-version":[{"id":3329,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions\/3329"}],"wp:attachment":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/media?parent=2177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/categories?post=2177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/tags?post=2177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
The U.S. Census Bureau<\/a> is an important source of data at the national, state and local level in the United States. There is a census of all people in the U.S. every 10 years, which is mandated by the Constitution. But the Census Bureau is also responsible for a number of other surveys and information, including the American Community Survey.<\/p>\nCensus Reporter<\/strong> is an independent project for making U.S. Census data easier for journalists to browse and use. This assignment will use data downloaded from Census Reporter and mapped with Datawrapper and Flourish.<\/p>\n1. Browse Census Reporter to download a dataset.<\/p>\n\nGo to the Census Reporter page for income data: censusreporter.org\/topics\/income<\/a><\/li>\nClick on a code number for the data table you want to use. The instructions will use “Median Household Income” and you can choose that, or you can pick a different one.<\/li>\nIn the box that prompts you to type a location, start typing any state name and then select it. This will display the data for that state.<\/li>\nTo add all the other states, look for the “Add all states in…” link on the left and choose all of the U.S. states.<\/li>\n<\/ul>\nStart typing any state name, and make sure to choose the option labeled “state” over on the right in italics.<\/p><\/div>\nThis allows you to quickly add the exact same information for all other states.<\/p><\/div>\n2. As long as all 50 states are included in your data table, you can now download the data.<\/p>\n\nClick the download link in the top right and choose CSV.<\/li>\nThis will download a zip folder to your computer. Unzip the folder to extract the CSV file. You can rename it to a more descriptive name if you want.<\/li>\n<\/ul>\nCSV is a structured text file that we’re using in this instance because it’s accepted by all the different tools we want to use. It’s worth noting that one of the tools, Flourish, also accepts GeoJSON, which eliminates the step of matching up the geographies.<\/p><\/div>\n3. Don’t leave Census Reporter quite yet! If you scroll to the bottom of the page with the data you just downloaded, there is citation information that includes the precise description of this data. You’ll use this for your interactive maps, so either copy the citation or leave this page open.<\/p>\n\nThis tutorial video shows the process for downloading data and initial steps for creating a map:<\/p>\n<\/iframe><\/p>\n<p><span class=\"header\">Making Interactive Maps<\/span><\/p>\n<p>Now, display the income data on an interactive map. We’ll be using two web tools. They are free, but you will need to sign up for an account to save and submit your work:<\/p>\n<ul>\n<li>Flourish: <a href=\"https:\/\/flourish.studio\" target=\"_blank\" rel=\"noopener noreferrer\">flourish.studio<\/a><\/li>\n<li>Datawrapper: <a href=\"https:\/\/www.datawrapper.de\" target=\"_blank\" rel=\"noopener noreferrer\">www.datawrapper.de<\/a><\/li>\n<\/ul>\n<p>Both maps will display the same information, and you can make them in any order. Tips for each one are included below, but you are welcome to just try out the tools and see what happens.<\/p>\n<p>For both, make sure each map includes:<\/p>\n<ul>\n<li>A sequential color scale other than the default colors<\/li>\n<li>A descriptive headline that explains what is being shown<\/li>\n<li>The state name and the amount with a $ when you hover<\/li>\n<li>A subhead or text description pointing out an interesting fact (such as the highest or lowest, or how Washington compares).<\/li>\n<li>A data source that includes the full citation from Census Reporter<\/li>\n<\/ul>\n<p><span class=\"subhead\">Flourish<\/span><\/p>\n<p>1. Choose the template for <strong>US (states)<\/strong>.<\/p>\n<p>2. Make the Points Layer “disabled” to hide the unnecessary point data.<\/p>\n<div id=\"attachment_2187\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2187\" class=\"wp-image-2187 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png\" alt=\"\" width=\"800\" height=\"321\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-300x120.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-768x308.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2187\" class=\"wp-caption-text\">The Points Layer could of course be useful for other purposes, but we don’t have any relevant point data at the moment.<\/p><\/div>\n<p>3. Click the Data tab at the top and import your CSV file.<br \/>\n\u2022 Choose the option to <strong>Merge with current sheet<\/strong> to maintain the state shapes and Import Publicly.<br \/>\n\u2022 For the merge, select the columns that include state names.<\/p>\n<div id=\"attachment_2188\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2188\" class=\"wp-image-2188 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png\" alt=\"\" width=\"800\" height=\"373\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-300x140.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-768x358.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2188\" class=\"wp-caption-text\">The goal for merging is finding two columns with the same information so it’s clear how the other information should match up.<\/p><\/div>\n<p>4. For the map “Value” field, choose the column that represents the data you want to display. If you are using Median Household Income, for instance, it needs to be the column with values roughly in the 40,000-80,000 range.<\/p>\n<div id=\"attachment_2189\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2189\" class=\"wp-image-2189 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png\" alt=\"\" width=\"800\" height=\"254\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-300x95.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-768x244.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2189\" class=\"wp-caption-text\">Make sure the “Value” field has the correct column for the information you want the map to display.<\/p><\/div>\n<p>5. Click the “Preview” tab at the top to go back to your map and style it.<br \/>\n\u2022 Look under <strong>Regions Layer<\/strong> to customize colors, style the numbers (add $ sign), and more.<br \/>\n\u2022 Look under <strong>Layout<\/strong> to change the font and background color if you want.<br \/>\n\u2022 Look under <strong>Header<\/strong> and <strong>Footer<\/strong> to add all the necessary text and source information. Note that changing the “Untitled” text in the top left is different from adding a title that will display on the actual map.<\/p>\n<p>6. Publish to get the link for submitting.<\/p>\n<p><span class=\"subhead\">Datawrapper<\/span><\/p>\n<p>1. Start a new map, then choose <strong>Choropleth<\/strong> and <strong>USA \u00bb States<\/strong>.<\/p>\n<p>2. Scroll to the bottom of the page and click <strong>Import your dataset<\/strong>.<br \/>\n\u2022 Click the text link to import a CSV file.<br \/>\n\u2022 The correct column should match automatically \u2014 if the second column has the state names, for instance, then the second callout rectangle should be blue.<br \/>\n\u2022 Do the same thing for selecting which column has the data you want to display.<\/p>\n<div id=\"attachment_2190\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2190\" class=\"wp-image-2190 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png\" alt=\"\" width=\"800\" height=\"352\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-300x132.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-768x338.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2190\" class=\"wp-caption-text\">The two stacked callout rectangles is a design flaw \u2014 there is one rectangle for each column, so the fourth one should be over on the right instead of stacked below.<\/p><\/div>\n<p>3. When your map is color-coded correctly, click the Visualize arrow above the map or the “Proceed” button at the very button to move on.<br \/>\n\u2022 Under <strong>Refine<\/strong>, change the colors, customize the tooltip hover information, and more.<br \/>\n\u2022 Under <strong>Annotate<\/strong>, add all the necessary text and source information.<\/p>\n<div id=\"attachment_2191\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2191\" class=\"wp-image-2191 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png\" alt=\"\" width=\"700\" height=\"290\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png 700w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip-300x124.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><p id=\"caption-attachment-2191\" class=\"wp-caption-text\">You can add any text or labels you want to contextualize the spreadsheet information.<\/p><\/div>\n<p>4. Publish to get the link for submitting.<\/p>\n<p><span class=\"header\">Comparing Tools<\/span><\/p>\n<p>Answer the following questions in a text document:<\/p>\n<p>1. Which tool did you like better for <strong>making the map<\/strong>, and why?<br \/>\n2. Which tool had the <strong>best final product<\/strong> from the perspective of someone viewing the map, and why?<br \/>\n4. Do you think this type of low-level interactivity on a map is useful?<\/p>\n<p><span class=\"header\">Extra Credit Opportunity!<\/span><\/p>\n<p>You can also make this same map in Tableau Public for <strong>5 extra credit points<\/strong>. <em>This is not required.<\/em> Follow the same instructions using your knowledge of Tableau.<\/p>\n<p>A couple of tips:<br \/>\n\u2022 Choose a “Text” data source for CSV files.<br \/>\n\u2022 Tableau may not recognize the states column as geographic data when you first import. Click the little icon in the top left of that column header and assign the correct geographic role.<br \/>\n\u2022 Remember to customize the Tooltip settings to change the hover information.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"277\" class=\"aligncenter size-full wp-image-2192\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png\" alt=\"\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png 500w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog-300x166.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>\n<p><span class=\"header\">Submitting Your Work<\/span><\/p>\n<p>Complete your assignment by submitting the following materials to Blackboard:<\/p>\n<ul>\n<li>Link for published Datawrapper map<\/li>\n<li>Link for published Flourish map<\/li>\n<li>Text document with written responses<\/li>\n<li>Optional for extra credit: Tableau map link<\/li>\n<\/ul>\n<p><em>Please double-check your links in a different web browser or when you are not logged in to make sure they are published publicly!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this assignment, you will use U.S. Census data about state statistics to create interactive maps using two different tools.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2177","post","type-post","status-publish","format-standard","hentry","category-assignments"],"_links":{"self":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/comments?post=2177"}],"version-history":[{"count":5,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions"}],"predecessor-version":[{"id":3329,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions\/3329"}],"wp:attachment":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/media?parent=2177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/categories?post=2177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/tags?post=2177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Census Reporter<\/strong> is an independent project for making U.S. Census data easier for journalists to browse and use. This assignment will use data downloaded from Census Reporter and mapped with Datawrapper and Flourish.<\/p>\n1. Browse Census Reporter to download a dataset.<\/p>\n\nGo to the Census Reporter page for income data: censusreporter.org\/topics\/income<\/a><\/li>\nClick on a code number for the data table you want to use. The instructions will use “Median Household Income” and you can choose that, or you can pick a different one.<\/li>\nIn the box that prompts you to type a location, start typing any state name and then select it. This will display the data for that state.<\/li>\nTo add all the other states, look for the “Add all states in…” link on the left and choose all of the U.S. states.<\/li>\n<\/ul>\nStart typing any state name, and make sure to choose the option labeled “state” over on the right in italics.<\/p><\/div>\nThis allows you to quickly add the exact same information for all other states.<\/p><\/div>\n2. As long as all 50 states are included in your data table, you can now download the data.<\/p>\n\nClick the download link in the top right and choose CSV.<\/li>\nThis will download a zip folder to your computer. Unzip the folder to extract the CSV file. You can rename it to a more descriptive name if you want.<\/li>\n<\/ul>\nCSV is a structured text file that we’re using in this instance because it’s accepted by all the different tools we want to use. It’s worth noting that one of the tools, Flourish, also accepts GeoJSON, which eliminates the step of matching up the geographies.<\/p><\/div>\n3. Don’t leave Census Reporter quite yet! If you scroll to the bottom of the page with the data you just downloaded, there is citation information that includes the precise description of this data. You’ll use this for your interactive maps, so either copy the citation or leave this page open.<\/p>\n\nThis tutorial video shows the process for downloading data and initial steps for creating a map:<\/p>\n<\/iframe><\/p>\n<p><span class=\"header\">Making Interactive Maps<\/span><\/p>\n<p>Now, display the income data on an interactive map. We’ll be using two web tools. They are free, but you will need to sign up for an account to save and submit your work:<\/p>\n<ul>\n<li>Flourish: <a href=\"https:\/\/flourish.studio\" target=\"_blank\" rel=\"noopener noreferrer\">flourish.studio<\/a><\/li>\n<li>Datawrapper: <a href=\"https:\/\/www.datawrapper.de\" target=\"_blank\" rel=\"noopener noreferrer\">www.datawrapper.de<\/a><\/li>\n<\/ul>\n<p>Both maps will display the same information, and you can make them in any order. Tips for each one are included below, but you are welcome to just try out the tools and see what happens.<\/p>\n<p>For both, make sure each map includes:<\/p>\n<ul>\n<li>A sequential color scale other than the default colors<\/li>\n<li>A descriptive headline that explains what is being shown<\/li>\n<li>The state name and the amount with a $ when you hover<\/li>\n<li>A subhead or text description pointing out an interesting fact (such as the highest or lowest, or how Washington compares).<\/li>\n<li>A data source that includes the full citation from Census Reporter<\/li>\n<\/ul>\n<p><span class=\"subhead\">Flourish<\/span><\/p>\n<p>1. Choose the template for <strong>US (states)<\/strong>.<\/p>\n<p>2. Make the Points Layer “disabled” to hide the unnecessary point data.<\/p>\n<div id=\"attachment_2187\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2187\" class=\"wp-image-2187 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png\" alt=\"\" width=\"800\" height=\"321\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-300x120.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-768x308.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2187\" class=\"wp-caption-text\">The Points Layer could of course be useful for other purposes, but we don’t have any relevant point data at the moment.<\/p><\/div>\n<p>3. Click the Data tab at the top and import your CSV file.<br \/>\n\u2022 Choose the option to <strong>Merge with current sheet<\/strong> to maintain the state shapes and Import Publicly.<br \/>\n\u2022 For the merge, select the columns that include state names.<\/p>\n<div id=\"attachment_2188\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2188\" class=\"wp-image-2188 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png\" alt=\"\" width=\"800\" height=\"373\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-300x140.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-768x358.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2188\" class=\"wp-caption-text\">The goal for merging is finding two columns with the same information so it’s clear how the other information should match up.<\/p><\/div>\n<p>4. For the map “Value” field, choose the column that represents the data you want to display. If you are using Median Household Income, for instance, it needs to be the column with values roughly in the 40,000-80,000 range.<\/p>\n<div id=\"attachment_2189\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2189\" class=\"wp-image-2189 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png\" alt=\"\" width=\"800\" height=\"254\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-300x95.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-768x244.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2189\" class=\"wp-caption-text\">Make sure the “Value” field has the correct column for the information you want the map to display.<\/p><\/div>\n<p>5. Click the “Preview” tab at the top to go back to your map and style it.<br \/>\n\u2022 Look under <strong>Regions Layer<\/strong> to customize colors, style the numbers (add $ sign), and more.<br \/>\n\u2022 Look under <strong>Layout<\/strong> to change the font and background color if you want.<br \/>\n\u2022 Look under <strong>Header<\/strong> and <strong>Footer<\/strong> to add all the necessary text and source information. Note that changing the “Untitled” text in the top left is different from adding a title that will display on the actual map.<\/p>\n<p>6. Publish to get the link for submitting.<\/p>\n<p><span class=\"subhead\">Datawrapper<\/span><\/p>\n<p>1. Start a new map, then choose <strong>Choropleth<\/strong> and <strong>USA \u00bb States<\/strong>.<\/p>\n<p>2. Scroll to the bottom of the page and click <strong>Import your dataset<\/strong>.<br \/>\n\u2022 Click the text link to import a CSV file.<br \/>\n\u2022 The correct column should match automatically \u2014 if the second column has the state names, for instance, then the second callout rectangle should be blue.<br \/>\n\u2022 Do the same thing for selecting which column has the data you want to display.<\/p>\n<div id=\"attachment_2190\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2190\" class=\"wp-image-2190 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png\" alt=\"\" width=\"800\" height=\"352\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-300x132.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-768x338.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2190\" class=\"wp-caption-text\">The two stacked callout rectangles is a design flaw \u2014 there is one rectangle for each column, so the fourth one should be over on the right instead of stacked below.<\/p><\/div>\n<p>3. When your map is color-coded correctly, click the Visualize arrow above the map or the “Proceed” button at the very button to move on.<br \/>\n\u2022 Under <strong>Refine<\/strong>, change the colors, customize the tooltip hover information, and more.<br \/>\n\u2022 Under <strong>Annotate<\/strong>, add all the necessary text and source information.<\/p>\n<div id=\"attachment_2191\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2191\" class=\"wp-image-2191 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png\" alt=\"\" width=\"700\" height=\"290\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png 700w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip-300x124.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><p id=\"caption-attachment-2191\" class=\"wp-caption-text\">You can add any text or labels you want to contextualize the spreadsheet information.<\/p><\/div>\n<p>4. Publish to get the link for submitting.<\/p>\n<p><span class=\"header\">Comparing Tools<\/span><\/p>\n<p>Answer the following questions in a text document:<\/p>\n<p>1. Which tool did you like better for <strong>making the map<\/strong>, and why?<br \/>\n2. Which tool had the <strong>best final product<\/strong> from the perspective of someone viewing the map, and why?<br \/>\n4. Do you think this type of low-level interactivity on a map is useful?<\/p>\n<p><span class=\"header\">Extra Credit Opportunity!<\/span><\/p>\n<p>You can also make this same map in Tableau Public for <strong>5 extra credit points<\/strong>. <em>This is not required.<\/em> Follow the same instructions using your knowledge of Tableau.<\/p>\n<p>A couple of tips:<br \/>\n\u2022 Choose a “Text” data source for CSV files.<br \/>\n\u2022 Tableau may not recognize the states column as geographic data when you first import. Click the little icon in the top left of that column header and assign the correct geographic role.<br \/>\n\u2022 Remember to customize the Tooltip settings to change the hover information.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"277\" class=\"aligncenter size-full wp-image-2192\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png\" alt=\"\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png 500w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog-300x166.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>\n<p><span class=\"header\">Submitting Your Work<\/span><\/p>\n<p>Complete your assignment by submitting the following materials to Blackboard:<\/p>\n<ul>\n<li>Link for published Datawrapper map<\/li>\n<li>Link for published Flourish map<\/li>\n<li>Text document with written responses<\/li>\n<li>Optional for extra credit: Tableau map link<\/li>\n<\/ul>\n<p><em>Please double-check your links in a different web browser or when you are not logged in to make sure they are published publicly!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this assignment, you will use U.S. Census data about state statistics to create interactive maps using two different tools.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2177","post","type-post","status-publish","format-standard","hentry","category-assignments"],"_links":{"self":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/comments?post=2177"}],"version-history":[{"count":5,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions"}],"predecessor-version":[{"id":3329,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions\/3329"}],"wp:attachment":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/media?parent=2177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/categories?post=2177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/tags?post=2177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
1. Browse Census Reporter to download a dataset.<\/p>\n
Start typing any state name, and make sure to choose the option labeled “state” over on the right in italics.<\/p><\/div>\n
This allows you to quickly add the exact same information for all other states.<\/p><\/div>\n
2. As long as all 50 states are included in your data table, you can now download the data.<\/p>\n
CSV is a structured text file that we’re using in this instance because it’s accepted by all the different tools we want to use. It’s worth noting that one of the tools, Flourish, also accepts GeoJSON, which eliminates the step of matching up the geographies.<\/p><\/div>\n
3. Don’t leave Census Reporter quite yet! If you scroll to the bottom of the page with the data you just downloaded, there is citation information that includes the precise description of this data. You’ll use this for your interactive maps, so either copy the citation or leave this page open.<\/p>\n\n
This tutorial video shows the process for downloading data and initial steps for creating a map:<\/p>\n
<\/iframe><\/p>\n<p><span class=\"header\">Making Interactive Maps<\/span><\/p>\n<p>Now, display the income data on an interactive map. We’ll be using two web tools. They are free, but you will need to sign up for an account to save and submit your work:<\/p>\n<ul>\n<li>Flourish: <a href=\"https:\/\/flourish.studio\" target=\"_blank\" rel=\"noopener noreferrer\">flourish.studio<\/a><\/li>\n<li>Datawrapper: <a href=\"https:\/\/www.datawrapper.de\" target=\"_blank\" rel=\"noopener noreferrer\">www.datawrapper.de<\/a><\/li>\n<\/ul>\n<p>Both maps will display the same information, and you can make them in any order. Tips for each one are included below, but you are welcome to just try out the tools and see what happens.<\/p>\n<p>For both, make sure each map includes:<\/p>\n<ul>\n<li>A sequential color scale other than the default colors<\/li>\n<li>A descriptive headline that explains what is being shown<\/li>\n<li>The state name and the amount with a $ when you hover<\/li>\n<li>A subhead or text description pointing out an interesting fact (such as the highest or lowest, or how Washington compares).<\/li>\n<li>A data source that includes the full citation from Census Reporter<\/li>\n<\/ul>\n<p><span class=\"subhead\">Flourish<\/span><\/p>\n<p>1. Choose the template for <strong>US (states)<\/strong>.<\/p>\n<p>2. Make the Points Layer “disabled” to hide the unnecessary point data.<\/p>\n<div id=\"attachment_2187\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2187\" class=\"wp-image-2187 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png\" alt=\"\" width=\"800\" height=\"321\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-300x120.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/5-flourish-points-768x308.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2187\" class=\"wp-caption-text\">The Points Layer could of course be useful for other purposes, but we don’t have any relevant point data at the moment.<\/p><\/div>\n<p>3. Click the Data tab at the top and import your CSV file.<br \/>\n\u2022 Choose the option to <strong>Merge with current sheet<\/strong> to maintain the state shapes and Import Publicly.<br \/>\n\u2022 For the merge, select the columns that include state names.<\/p>\n<div id=\"attachment_2188\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2188\" class=\"wp-image-2188 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png\" alt=\"\" width=\"800\" height=\"373\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-300x140.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/6-flourish-merge-768x358.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2188\" class=\"wp-caption-text\">The goal for merging is finding two columns with the same information so it’s clear how the other information should match up.<\/p><\/div>\n<p>4. For the map “Value” field, choose the column that represents the data you want to display. If you are using Median Household Income, for instance, it needs to be the column with values roughly in the 40,000-80,000 range.<\/p>\n<div id=\"attachment_2189\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2189\" class=\"wp-image-2189 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png\" alt=\"\" width=\"800\" height=\"254\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-300x95.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/7-flourish-values-768x244.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2189\" class=\"wp-caption-text\">Make sure the “Value” field has the correct column for the information you want the map to display.<\/p><\/div>\n<p>5. Click the “Preview” tab at the top to go back to your map and style it.<br \/>\n\u2022 Look under <strong>Regions Layer<\/strong> to customize colors, style the numbers (add $ sign), and more.<br \/>\n\u2022 Look under <strong>Layout<\/strong> to change the font and background color if you want.<br \/>\n\u2022 Look under <strong>Header<\/strong> and <strong>Footer<\/strong> to add all the necessary text and source information. Note that changing the “Untitled” text in the top left is different from adding a title that will display on the actual map.<\/p>\n<p>6. Publish to get the link for submitting.<\/p>\n<p><span class=\"subhead\">Datawrapper<\/span><\/p>\n<p>1. Start a new map, then choose <strong>Choropleth<\/strong> and <strong>USA \u00bb States<\/strong>.<\/p>\n<p>2. Scroll to the bottom of the page and click <strong>Import your dataset<\/strong>.<br \/>\n\u2022 Click the text link to import a CSV file.<br \/>\n\u2022 The correct column should match automatically \u2014 if the second column has the state names, for instance, then the second callout rectangle should be blue.<br \/>\n\u2022 Do the same thing for selecting which column has the data you want to display.<\/p>\n<div id=\"attachment_2190\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2190\" class=\"wp-image-2190 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png\" alt=\"\" width=\"800\" height=\"352\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data.png 800w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-300x132.png 300w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/8-dw-match-data-768x338.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-2190\" class=\"wp-caption-text\">The two stacked callout rectangles is a design flaw \u2014 there is one rectangle for each column, so the fourth one should be over on the right instead of stacked below.<\/p><\/div>\n<p>3. When your map is color-coded correctly, click the Visualize arrow above the map or the “Proceed” button at the very button to move on.<br \/>\n\u2022 Under <strong>Refine<\/strong>, change the colors, customize the tooltip hover information, and more.<br \/>\n\u2022 Under <strong>Annotate<\/strong>, add all the necessary text and source information.<\/p>\n<div id=\"attachment_2191\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2191\" class=\"wp-image-2191 size-full\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png\" alt=\"\" width=\"700\" height=\"290\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip.png 700w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/9-dw-tooltip-300x124.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><p id=\"caption-attachment-2191\" class=\"wp-caption-text\">You can add any text or labels you want to contextualize the spreadsheet information.<\/p><\/div>\n<p>4. Publish to get the link for submitting.<\/p>\n<p><span class=\"header\">Comparing Tools<\/span><\/p>\n<p>Answer the following questions in a text document:<\/p>\n<p>1. Which tool did you like better for <strong>making the map<\/strong>, and why?<br \/>\n2. Which tool had the <strong>best final product<\/strong> from the perspective of someone viewing the map, and why?<br \/>\n4. Do you think this type of low-level interactivity on a map is useful?<\/p>\n<p><span class=\"header\">Extra Credit Opportunity!<\/span><\/p>\n<p>You can also make this same map in Tableau Public for <strong>5 extra credit points<\/strong>. <em>This is not required.<\/em> Follow the same instructions using your knowledge of Tableau.<\/p>\n<p>A couple of tips:<br \/>\n\u2022 Choose a “Text” data source for CSV files.<br \/>\n\u2022 Tableau may not recognize the states column as geographic data when you first import. Click the little icon in the top left of that column header and assign the correct geographic role.<br \/>\n\u2022 Remember to customize the Tooltip settings to change the hover information.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"277\" class=\"aligncenter size-full wp-image-2192\" src=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png\" alt=\"\" srcset=\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog.png 500w, https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/10-tableau-geog-300x166.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>\n<p><span class=\"header\">Submitting Your Work<\/span><\/p>\n<p>Complete your assignment by submitting the following materials to Blackboard:<\/p>\n<ul>\n<li>Link for published Datawrapper map<\/li>\n<li>Link for published Flourish map<\/li>\n<li>Text document with written responses<\/li>\n<li>Optional for extra credit: Tableau map link<\/li>\n<\/ul>\n<p><em>Please double-check your links in a different web browser or when you are not logged in to make sure they are published publicly!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this assignment, you will use U.S. Census data about state statistics to create interactive maps using two different tools.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2177","post","type-post","status-publish","format-standard","hentry","category-assignments"],"_links":{"self":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/comments?post=2177"}],"version-history":[{"count":5,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions"}],"predecessor-version":[{"id":3329,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/posts\/2177\/revisions\/3329"}],"wp:attachment":[{"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/media?parent=2177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/categories?post=2177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/murrowcourses.com\/graphics\/wp-json\/wp\/v2\/tags?post=2177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/1-add-geog.png\")
![\"\"](\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/2-add-states.png\")
![\"\"](\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/3-download-csv.png\")
![\"\"](\"https:\/\/murrowcourses.com\/graphics\/wp-content\/uploads\/2019\/06\/4-keep-citation.png\")
\n