<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Multimedia &#187; Data &#124; Multimedia</title>
	<atom:link href="http://christinemckenna.com/multimedia/?cat=11&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://christinemckenna.com/multimedia</link>
	<description></description>
	<lastBuildDate>Mon, 05 Oct 2020 16:11:10 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.5</generator>
		<item>
		<title>Math Review</title>
		<link>http://christinemckenna.com/multimedia/?p=18124</link>
		<comments>http://christinemckenna.com/multimedia/?p=18124#comments</comments>
		<pubDate>Fri, 15 Nov 2019 14:49:30 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Data]]></category>

		<guid isPermaLink="false">http://christinemckenna.com/multimedia/?p=18124</guid>
		<description><![CDATA[Exercise #1: Numbers We Need to Know &#8220;Million, billion, trillion … all big numbers. A trillion is just a bigger number, right? True … but it may be bigger than you think. A million is hard enough to imagine, much less a billion. We need some perspective on what these &#8230;]]></description>
				<content:encoded><![CDATA[<p><strong>Exercise #1: Numbers We Need to Know</strong></p>
<p>&#8220;Million, billion, trillion … all big numbers. A trillion is just a bigger number, right? True … but it may be bigger than you think. A million is hard enough to imagine, much less a billion. We need some perspective on what these unimaginable numbers really mean.&#8221; &#8212; <a href="http://ihtd.org/festivalguide/resources/how-much-is-a-trillion-dollars/" target="_blank">If I Had a Trillion Dollars</a></p>
<p>Q: How many millions are there in a trillion?</p>
<p>Q: If you were a star newsanchor earning $1 million, how many years would it take you to earn $1 billion?</p>
<p><iframe src="https://www.youtube.com/embed/rrNdSwY4lI4" height="360" width="640" allowfullscreen="allowfullscreen" frameborder="0"></iframe></p>
<p>Task:</p>
<p>1) Identify a number that you believe is important for a New York journalist to know, roughly, by heart. Don&#8217;t reveal the number. The class will first attempt to identify it.</p>
<p>2) Once the class has responded, put that number in context. For example, if you were talking about population you might give a sense of growth by offering a number from an earlier decade.</p>
<p>3) Cite the source for your number and why you believe it is credible.</p>
<p><strong>Exercise #2: Harper&#8217;s Index</strong></p>
<p>Review the numbers presented in your edition of the Harper&#8217;s Index handout and identify one number or set of numbers which you think is particularly revealing. Explain why and whether it/they might be worthy of a more in-depth exploration.</p>
<p><strong>Exercise #3<br />
</strong><a href="https://docs.google.com/forms/d/e/1FAIpQLSe_hsM1EpWAu5flX8KdQMECDfaLiAJ8eL_9DR5d5Y9KN309Ug/viewform">Operations order</a><br />
<a href="https://docs.google.com/forms/d/e/1FAIpQLSfW5Wi-872ZAbdHb0zGz1svK0VUvaHfZQrmLQXBQO2Us4MSOQ/viewform">Percent</a><br />
<a href="https://docs.google.com/forms/d/e/1FAIpQLSeA3Gr3qyV-Hn_ZEtrK7iZXFQ2jdGHeABSM2qPKrfbw_vrzNA/viewform">Mean, Mode, Median<br />
</a><a href="https://docs.google.com/forms/d/e/1FAIpQLSfSfnHpmZCq9TbCc7JyuArP-ytq6fAhEaJYI3zWXUDuIzLtiQ/viewform" target="_blank">Math for Journalists Quiz</a></p>
]]></content:encoded>
			<wfw:commentRss>http://christinemckenna.com/multimedia/?feed=rss2&#038;p=18124</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Numeracy for Journalists</title>
		<link>http://christinemckenna.com/multimedia/?p=18524</link>
		<comments>http://christinemckenna.com/multimedia/?p=18524#comments</comments>
		<pubDate>Fri, 01 Nov 2019 00:41:42 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Data]]></category>

		<guid isPermaLink="false">http://christinemckenna.com/multimedia/?p=18524</guid>
		<description><![CDATA[I. Numeracy for Journalists: Percent, percent change, rate, median, mean, normalization Percent Pizza Hut overwhelming contributed to Republicans number / total number x 100 = percent A percent is part of one hundred, or part of a whole. Percents describe relationships between two numbers that, when used literally, might lack &#8230;]]></description>
				<content:encoded><![CDATA[<h3>I. Numeracy for Journalists: Percent, percent change, rate, median, mean, normalization</h3>
<p><strong>Percent</strong></p>
<p><a href="http://www.vox.com/2015/3/14/8207747/pi-day-pie-charts" target="_blank"><img class="aligncenter size-full wp-image-12178" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/piechart.png" alt="piechart" width="484" height="433" /></a><br />
Pizza Hut <a href="http://www.bloomberg.com/news/features/2015-03-03/junk-food-s-last-stand-the-pizza-lobby-is-not-backing-down" target="_blank">overwhelming contributed to Republicans</a></p>
<p><strong>number / total number x 100 = percent</strong></p>
<p>A percent is part of one hundred, or part of a whole. Percents describe relationships between two numbers that, when used literally, might lack context or be hard to understand. To write, &#8220;Jane Brown received 7,542 votes out of a total of 12,165&#8243; may be accurate, but the relationship between the numbers is more clear and meaningful when the percent tool is used: &#8220;Jane Brown received 62 percent of the vote.&#8221;</p>
<p><img class="aligncenter size-full wp-image-12179" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/Fox-News-pie-chart-620x465.0.png" alt="Fox-News-pie-chart-620x465.0" width="620" height="465" /></p>
<p>Percent of total can show you patterns or disparities in sets of numbers. For example, if you have a data set that tells you that state employees got a total of $3.5 million in raises this year, and you know the governor&#8217;s salary for this year and for last year, you can figure out what percent of the total in raises given out went to the governor. You can then compare that with the percent of total that was awarded in raises to, say, clerks at the unemployment office. Thus, by calculating percent of total for a category of numbers, such as salaries, you will identify each employee&#8217;s or each department&#8217;s share of the budget &#8220;pie.&#8221; In fact, a pie chart can help you analyze these data or illustrate your news report.</p>
<p><strong>Percent Change</strong></p>
<p>To calculate the percent change:</p>
<h3>new number &#8211; original number / original number × 100 = percent change</h3>
<p>1) (New &#8211; old) / old = decimal value<br />
2) Decimal value x 100 = percent change</p>
<p>If your answer is a negative number then this is a percentage decrease.</p>
<p><strong>Rate</strong></p>
<h3>total events / total population x &#8220;per&#8221; value = rate</h3>
<p>For the &#8220;per&#8221; value, choose a round number like 100 or 1,000 or 100,000 or even 1 million, depending on the size of the population. &#8212; Poynter U: Math for Journalists</p>
<p><img class="aligncenter size-full wp-image-12146" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/murderrates.jpg" alt="murderrates" width="481" height="309" /></p>
<p>Rate is a very handy math tool when you want to make a comparison between quantities of two things <em>that are not alike</em>. Let&#8217;s take an example: murder rates in U.S. cities in a given year. What do we need to know to apply the rate tool to this sort of data? Since murders happen to people, we&#8217;ll need to obtain (1) city population in that year and, (2) number of murders in that city in that year. Most data about homicide is published as the rate per 100,000 residents, which allows us to make meaningful comparisons. &#8220;Per capita&#8221; is Latin, &#8220;for each head.&#8221;</p>
<div style="margin-bottom: 5px;"><img class="aligncenter size-full wp-image-14256" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/02/heatmap.png" alt="heatmap" width="500" height="542" /></div>
<p><strong>Normalization vs. Absolute numbers examples</strong></p>
<p><a href="http://www.nydailynews.com/new-york/nyc-crime/daily-news-analysis-reveals-crime-rankings-city-subway-system-article-1.1836918" target="_blank">Crime in the subway</a></p>
<p><a href="http://www.nydailynews.com/new-york/nyc-crime/daily-news-analysis-reveals-crime-rankings-city-subway-system-article-1.1836918" target="_blank"><img class="aligncenter size-full wp-image-12024" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/subway.jpg" alt="subway" width="637" height="730" /></a></p>
<p><a href="https://eagereyes.org/basics/putting-data-into-context"><img class="aligncenter size-full wp-image-12011" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/numberofcrimeincidents.jpg" alt="numberofcrimeincidents" width="727" height="580" /></a></p>
<p>&#8220;The difference between the total and the per–100,000 number is important not just because it changes the picture. It’s the much more interesting number. The total number of crimes means nothing for the individual. What is much more relevant is how many crimes happen per person, because that provides a much closer estimate of each individual’s risk of becoming a victim. Number 2, 125th St, has over six times the rate per 100,000, and number 5, Broadway Junction, has almost ten times the rate (but less than half the total number) compared to Times Square.&#8221;</p>
<p>Daily riders are a good first step when looking at the subway crime data, but there are caveats. The analysis would be much better with more, and more fine-grained, data. How should two cities be compared? Is population the right metric? What about GDP?  &#8212; &#8220;Putting Data into Context&#8221;</p>
<p><a href="http://www.nytimes.com/2013/04/14/education/edlife/new-york-and-seattle-compete-for-data-science-crown.html" target="_blank">NYTimes: Geek Appeal &#8211; NY vs Seattle</a></p>
<p>Seattle 139 Starbucks in 2013 but New York had 271 85,000 IT workers in Seattle, compared to 168,400 in NYC</p>
<p><a href="http://www.thefunctionalart.com/2014/03/the-danger-of-not-adjusting-for.html" target="_blank">Adjusting for inflation</a></p>
<p><img class="aligncenter size-full wp-image-12014" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/pay.jpg" alt="pay" width="640" height="397" /></p>
<p>Generally, if dollar values differ over time by three years or more, a cost-of-living adjustment should be calculated to ensure inflation has been accounted for and the comparisons being made are fair. Change in cost of living adds incredibly useful and accurate depth to news reports.</p>
<p><a href="http://data.bls.gov/cgi-bin/cpicalc.pl" target="_blank"><img class="aligncenter size-full wp-image-12141" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/cpi.jpg" alt="cpi" width="371" height="207" /></a></p>
<p>You can use an automatic Web calculator to adjust for inflation. Just plug in the dollar amount ($1) and the year (1913) and poof, your answer — what that dollar was worth in 2012 — shows up on the screen. There are a <a href="http://www.bls.gov/data/#calculators">few calculators</a> on the Bureau of Labor Statistics website. If you plug in the $1 and enter 1913 as your starting point, the calculator will tell you that the 1913 dollar was worth $23.19 in 2012.</p>
<p><img class="aligncenter size-full wp-image-12142" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/formula.jpg" alt="formula" width="414" height="89" /></p>
<p>&#8211; Poynter U: Math for Journalists</p>
<p><strong>Ratio</strong></p>
<p>Ratio is a way of explaining how two similar things relate. Ratios crop up in daily life all the time — in recipes, measurements — and in journalism in stories on elections, sports, education, health and much more. For instance, in a city council race, Candidate Brown got 75,347 votes and Candidate Smith only got 24,994, you could accurately tell your audience that Candidate Brown won by a ratio of 3-to-1. That means that, for every vote that Smith got, Brown got 3 votes.</p>
<p>Order is important in expressing a ratio. If you were in a class that had 5 men and 15 women, you could say that the ratio of men to women was 5-to-15. Or that the ratio of women to men was 15-to-5 or reduce it to 3-to-1. But it&#8217;s crucial to keep the objects you are counting or measuring in the correct order.</p>
<p>Ratios are easily confused with fractions and percents, but the numbers mean very different things. For example, if candidate A won an election by a 5:4 margin, that does not mean that candidate A got 4 out of 5 votes. It means that for every 4 votes that candidate B got, candidate A received 5. So, candidate A got 5 out of every <strong>9</strong> votes, or about 55 percent. &#8212; Poynter U: Math for Journalists</p>
<p><strong>Distribution</strong> &#8212; <a href="http://www.robertniles.com/stats/stdev.shtml" target="_blank">Robert Niles &#8220;Stats Guide&#8221;</a></p>
<p>A normal distribution of data means that most of the examples in a set of data are close to the &#8220;average,&#8221; while relatively few examples tend to one extreme or the other. Let&#8217;s say you are writing a story about nutrition. You need to look at people&#8217;s typical daily calorie consumption. Like most data, the numbers for people&#8217;s typical consumption probably will turn out to be normally distributed. That is, for most people, their consumption will be close to the mean, while fewer people eat a lot more or a lot less than the mean.</p>
<p><strong>Standard Deviation</strong> &#8212; <a href="http://www.robertniles.com/stats/stdev.shtml" target="_blank">Robert Niles &#8220;Stats Guide&#8221;</a></p>
<p><a href="http://www.robertniles.com/stats/stdev.shtml" target="_blank"><img class="aligncenter size-full wp-image-12130" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/standarddeviation.jpg" alt="standarddeviation" width="616" height="395" /></a></p>
<p>If you are comparing test scores for different schools, the standard deviation will tell you how diverse the test scores are for each school. Let&#8217;s say Springfield Elementary has a higher mean test score than Shelbyville Elementary. Your first reaction might be to say that the kids at Springfield are smarter. But a bigger standard deviation for one school tells you that there are relatively more kids at that school scoring toward one extreme or the other. By asking a few follow-up questions you might find that, say, Springfield&#8217;s mean was skewed up because the school district sends all of the gifted education kids to Springfield. Or that Shelbyville&#8217;s scores were dragged down because students who recently have been &#8220;mainstreamed&#8221; from special education classes have all been sent to Shelbyville.</p>
<p><strong>Margin of Error</strong> <a href="http://www.robertniles.com/stats/stdev.shtml" target="_blank">Robert Niles &#8220;Stats Guide&#8221;</a></p>
<p>The margin of error in a sample = 1 divided by the square root of the number of people in the sample.</p>
<p>You&#8217;ve probably heard that term — &#8220;margin of error&#8221; — a lot before. Reporters throw it around like a hot potato — like if they linger with it too long (say, by trying to explain what it means), they&#8217;ll just get burned. That&#8217;s because many reporters have no idea what a &#8220;margin of error&#8221; really represents.</p>
<p>If a poll has a margin of error of 2.5 percent, that means that if you ran that poll 100 times — asking a different sample of people each time — the overall percentage of people who responded the same way would remain within 2.5 percent of your original result in at least 95 of those 100 polls.</p>
<p><strong>Math for specific story types</strong></p>
<p><img class="aligncenter size-full wp-image-12148" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/typesofstories.jpg" alt="typesofstories" width="536" height="668" /></p>
<p>Source: Poynter U: Math for Journalists</p>
<p><a href="http://www.nytimes.com/interactive/2015/08/28/nyregion/eighth-grade-math-questions.html" target="_blank"><img class="aligncenter size-full wp-image-12073" style="color: #800000;" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/mathtest.jpg" alt="mathtest" width="640" height="350" /></a></p>
<p>Calculate Percentages</p>
<p>https://percentagecalculator.net/</p>
<p><strong>Sources:</strong></p>
<p><a href="https://www.newsu.org/courses/math-for-journalists" target="_blank">Poynter U: Math for Journalists</a><br />
<a href="http://www.robertniles.com/stats/" target="_blank">Robert Niles Stats</a><br />
Data journalism handbook<br />
<a href="http://onlinejournalismblog.com/2011/07/07/the-inverted-pyramid-of-data-journalism/" target="_blank">The process: The inverted pyramid of data journalism</a><br />
Finding Stories in Spreadsheets</p>
<p><strong>Data &amp; Numeracy Resources</strong></p>
<p><a href="https://www.newsu.org/courses/math-for-journalists" target="_blank">Math for Journalists: Help with Numbers</a><br />
<a href="http://www.interhacktives.com/2012/12/28/a-beginners-pre-guide-to-data-journalism/" target="_blank">Beginner’s Pre-Guide to Data Journalism</a><br />
<a href="http://onlinejournalismblog.com/2015/06/24/data-journalism-isnt-just-a-technical-skill-its-a-cultural-one-too/" target="_blank">Data Journalism Isn’t Just a Technical Skill – It’s a Cultural One Too</a><br />
<a href="http://datajournalismhandbook.org/1.0/en/" target="_blank">The Data Journalism Handbook</a><br />
<a href="https://dl.dropboxusercontent.com/u/56427375/Census%20data%20for%20reporting%20Feb%202015%20.pdf" target="_blank">Mining Census Data for Reporting</a><br />
<a href="https://www.census.gov/content/dam/Census/programs-surveys/acs/about/ACS_Information_Guide.pdf" target="_blank">American Community Survey Guide</a><br />
<a href="https://www.census.gov/content/dam/Census/library/publications/2008/acs/ACSMediaHandbook.pdf" target="_blank">A Compass for Understanding and Using American Community Survey Data</a><br />
<a href="https://www.census.gov/acs/www/guidance/which-data-tool/" target="_blank">Which Data Tool Should I Use?</a><br />
<a href="http://www.journalism.cuny.edu/research-center/community-district-resources-nyc-gov/" target="_blank">Community District Resources &amp; NYC.gov</a><br />
<a href="http://www.pewsocialtrends.org/interactives/multiracial-timeline/" target="_blank">How Census Race Categories Have Changed Over Time</a><br />
<a href="http://ire.org/blog/on-the-road/2012/12/12/case-why-journalists-should-learn-statistics/" target="_blank">IRE: A Case for Why Journalists Should Learn Statistics</a><br />
<a href="http://journalistsresource.org/tip-sheets/foundations/math-for-journalists#sthash.aNXtCPd5.dpuf" target="_blank">Math Basics for Journalists: Working with Averages and Percentages</a><br />
<a href="http://www.poynter.org/news/media-innovation/25284/why-math-matters/" target="_blank">Why Math Matters</a><br />
<a href="http://www.cracked.com/article_20318_the-5-most-popular-ways-statistics-are-used-to-lie-to-you.html" target="_blank">5 Ways Statistics Are Used to Lie to You Every Day<br />
</a><a href="https://www.dailywritingtips.com/10-rules-for-writing-numbers-and-numerals/" target="_blank">10 Rules for Writing Numbers and Numerals<br />
</a><a href="https://www.poynter.org/news/writing-numbers" target="_blank">Poynter: Writing With Numbers<br />
</a><a href="http://www.word-mart.com/html/number_and_numeral_writing_tip.html" target="_blank">Number and Numeral Writing Tips</a></p>
]]></content:encoded>
			<wfw:commentRss>http://christinemckenna.com/multimedia/?feed=rss2&#038;p=18524</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Mapping: Tools &amp; Exercises</title>
		<link>http://christinemckenna.com/multimedia/?p=18533</link>
		<comments>http://christinemckenna.com/multimedia/?p=18533#comments</comments>
		<pubDate>Sun, 05 May 2019 11:19:29 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Data]]></category>

		<guid isPermaLink="false">http://christinemckenna.com/multimedia/?p=18533</guid>
		<description><![CDATA[Various tools for mapping stories]]></description>
				<content:encoded><![CDATA[<h3>I. Mapping Tools</h3>
<p><a href="https://support.google.com/fusiontables/answer/2571232?hl=en" target="_blank">Google Fusion</a><br />
<a href="http://christinemckenna.com/interactive/wp-content/uploads/2014/10/googlefusion.png" target="_blank"><img class="alignnone size-large wp-image-11205" src="http://christinemckenna.com/interactive/wp-content/uploads/2014/10/googlefusion-1024x862.png" alt="googlefusion" width="660" height="555" /></a></p>
<p><a href="https://storymap.knightlab.com/" target="_blank">Storymaps JS</a></p>
<p><a href="https://storymap.knightlab.com/" target="_blank"><img class="alignnone size-large wp-image-11207" src="http://christinemckenna.com/interactive/wp-content/uploads/2014/10/storymapjs-1024x765.png" alt="storymapjs" width="660" height="493" /></a></p>
<p><a href="http://storymaps.arcgis.com/en/" target="_blank">Story Map &#8211; ArcGIS</a></p>
<p><a href="http://storymaps.arcgis.com/en/" target="_blank"><img class="alignnone size-full wp-image-11211" src="http://christinemckenna.com/interactive/wp-content/uploads/2014/10/esri.jpg" alt="esri" width="640" height="370" /></a></p>
<p><a href="https://www.mapbox.com/" target="_blank">MapBox</a></p>
<p><a href="https://www.mapbox.com/" target="_blank"><img class="alignnone size-large wp-image-11206" src="http://christinemckenna.com/interactive/wp-content/uploads/2014/10/mapbox-1024x618.png" alt="mapbox" width="660" height="398" /></a></p>
<h3>II. Exercise: Point map</h3>
<p>Geocoding is just a fancy term for the process of converting a location to latitude and longitude coordinates. <a href="http://support.google.com/fusiontables/bin/answer.py?hl=en&amp;answer=1012281&amp;topic=2573808&amp;ctx=topic">Google Fusion Tables automatically geocodes addresses</a>, although you may have to provide some help to specify locations that it can’t find or figure out. There’s also a daily limit to the number of geocodings it can do for you.</p>
<p>1) Go to NYC Open Data and download this file: <a href="https://data.cityofnewyork.us/Housing-Development/Projects-in-Construction-Map/dzgh-ja44">https://data.cityofnewyork.us/Housing-Development/Projects-in-Construction-Map/dzgh-ja44</a></p>
<p>2) In your Google documents/Google drive home page, select Create &gt; New &gt; Table to create a new Google Fusion Table.</p>
<p><a href="http://google.com"><img class="aligncenter size-full wp-image-12873" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/googlefusion.jpg" alt="googlefusion" width="533" height="453" /></a></p>
<p dir="ltr">3) Choose the CSV file you just downloaded to your computer and click Next.</p>
<p>4) Google uploads the XLS file and shows you a preview of the fields.</p>
<p><img class="aligncenter size-full wp-image-15739" src="http://christinemckenna.com/interactive/wp-content/uploads/2017/11/import.jpg" alt="" width="640" height="443" />5) Click Next to create your new Google Fusion Table. Information highlighted in yellow, indicates that it has not yet been geocoded.<br />
<img class="aligncenter size-full wp-image-15740" src="http://christinemckenna.com/interactive/wp-content/uploads/2017/11/projectsinconstruction.jpg" alt="" width="640" height="324" /></p>
<p>&nbsp;</p>
<p dir="ltr">6) As with all spreadsheets, columns contain specific kinds of data. Sometimes it’s numeric data, sometimes it’s text, sometimes it’s a date. In some cases, you will want to make sure that Google knows that the Location column contains location data. In this file, there is a latitude and longitude provided so that is not necessary for the mapping.</p>
<p dir="ltr">7) Now, simply choose Map of Latitude.</p>
<p dir="ltr">8) Go to Change Info Window and uncheck all but the relevant data.</p>
<p>9) Go to Change Map Feature Styles &gt; Buckets. Select 5 and the column Construction Award. Be sure to click &#8220;Use this range&#8221;</p>
<p>10) Edit the numbers on the key so that they are rounded. Round up at the end to 100,000,000.</p>
<p>11) Click on &#8220;Automatic Legend,&#8221; Show Marker Legend and select a location for the key.</p>
<p><iframe src="https://fusiontables.google.com/embedviz?q=select+col12+from+1T1O6k--RFGtBU7RJcqdnOjLOkTla_6jQIkSL_HTX&amp;viz=MAP&amp;h=false&amp;lat=40.72894336553131&amp;lng=-73.86957144921877&amp;t=1&amp;z=11&amp;l=col12&amp;y=2&amp;tmplt=2&amp;hml=TWO_COL_LAT_LNG" width="640" height="480" frameborder="no" scrolling="no"></iframe></p>
<p><a href="https://fusiontables.google.com/data?docid=1T1O6k--RFGtBU7RJcqdnOjLOkTla_6jQIkSL_HTX#map:id=3" target="_blank">Link to map</a></p>
<h3>III. Exercise: Boundary data, shapefiles and KML files</h3>
<p><a href="http://shpescape.com/"><img class="aligncenter size-full wp-image-12871" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/sh2.jpg" alt="sh2" width="640" height="385" /></a></p>
<p>Displaying areas on maps requires a bit more information. If you want to color the different NY neighborhoods shades of red, depending on their population size, then you need to provide Google Fusion Tables with the boundary information for those neighborhoods.</p>
<p>Google Fusion Tables requires the boundary information be in the form of a KML file. A KML file (<a href="http://en.wikipedia.org/wiki/Kml">Keyhole Markup Language</a>) is simply a text file that has vector information structured like an XML document. Vectors describe the points and paths of any shape in coordinates so it can be plotted on a map. Google Earth uses KML files.</p>
<p>Where do you get KML files for boundaries that you need? Fortunately, many common political boundaries (states, congressional districts, school districts, etc.) are available online from many diverse sources.</p>
<p>Some may be provided by local governmental agencies, such as the <a href="http://www.nyc.gov/html/dcp/html/bytes/dwndistricts.shtml">New York Department of City Planning</a>. Others may be provided by the federal government or specific organizations (the UN, <a href="http://www.census.gov/cgi-bin/geo/shapefiles2010/main">Census</a>), and still others you may be able to find online in the <a href="http://www.google.com/fusiontables/search">Google Fusion Tables Public Search</a>.</p>
<p>However, the geographic data is not always in the KML format. A common format for geographic data is the <a href="http://en.wikipedia.org/wiki/Shapefile">Shapefile</a>, which is used by commercial GIS software applications such as <a href="http://www.esri.com/software/arcgis/arcview">ArcviewGIS</a>, or its open-source version, <a href="http://www.qgis.org/">QGIS</a>. A shapefile comes in a .zip package, and when unpacked, there are multiple files that describe the geography. Fortunately, you can fairly easily translate shapefiles to KML files for use in Google Fusion Tables. One online tool you can use is <a href="http://shpescape.com/" target="_blank">Shape Escape</a>.</p>
<p><a href="http://shpescape.com/" target="_blank"><img class="aligncenter size-full wp-image-12870" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/shapeescape.jpg" alt="shapeescape" width="627" height="430" /></a>Download the boundary data for the <a href="http://www1.nyc.gov/site/planning/data-maps/open-data/dwn-nynta.page">Neighborhood Tabulation Areas</a> from the NYC Department of City Planning. You’ll get a zip file called, “nynta_17.zip”. Go to <a href="http://shpescape.com/" target="_blank">Shape Escape</a>. Upload the zipped file.</p>
<p><img class="aligncenter size-full wp-image-12869" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/nyad.jpg" alt="nyad" width="640" height="384" /></p>
<h3>IV. Exercise: Mapping de Blasio&#8217;s Supporters in NYC</h3>
<p>1) Find the de Blasio contributions CSV file you saved last week. Review it to make sure you don&#8217;t have any Grand Totals or other random data and that your top row is your column labels.</p>
<p>2) Upload it to Google Fusion tables.</p>
<p style="text-align: center;"><img class="aligncenter size-full wp-image-12877" style="border: 1px solid black;" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/newfusiontable.jpg" alt="newfusiontable" width="539" height="467" /></p>
<p><img src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/deblasiorownames.jpg" alt="deblasiorownames" width="770" height="527" /></p>
<p>3) Delete the zip code 083 in Central Park by clicking on the trash can in the first row of the de Blasio file.</p>
<p>4)  If you haven&#8217;t already, <strong><a href="http://christinemckenna.com/interactive/wp-content/uploads/2013/11/NYCShapeFiles.zip" target="_blank">Download zip file of NYC boundary files</a> </strong>and find the NYC_zipcode.kml. Upload it to Google Fusion Tables.</p>
<p>5) Merge it with the de Blasio boundary file.<br />
<img class="aligncenter size-full wp-image-12878" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/mergeselectatable.jpg" alt="mergeselectatable" width="640" height="408" />6)  Match the zip code columns.</p>
<p><img class="aligncenter size-full wp-image-12880" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/confirmsourcezip.jpg" alt="confirmsourcezip" width="476" height="468" /></p>
<p><img class="aligncenter size-full wp-image-12891" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/mergetablecreated.jpg" alt="mergetablecreated" width="303" height="203" /></p>
<p>7)  Click on Map of geometry. It should look something like this.<img class="aligncenter size-full wp-image-12881" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/mergeofzipcodesanddeb.jpg" alt="mergeofzipcodesanddeb" width="640" height="372" /></p>
<p>8) Change info window</p>
<p>Click on Tools &gt; Change Map &gt; Change info window. Uncheck everything but zip code and check amount and contributor.</p>
<p><img class="aligncenter size-full wp-image-12892" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/changeinfowindow.jpg" alt="changeinfowindow" width="640" height="497" /></p>
<p>9) Change map styles</p>
<p>Now you need to modify the map features.  Go to Tools &gt; Change Map &gt; Change feature styles</p>
<p><img class="aligncenter size-full wp-image-12884" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/changecolorsbettersix.jpg" alt="changecolorsbettersix" width="598" height="539" /></p>
<p>We are going to use Polygon &gt; Fill color &gt; Buckets &gt;</p>
<p>- Select 6 buckets.<br />
- In Column select &#8220;Amount&#8221;<br />
- Next &#8220;use this range&#8221;<br />
-Select the six shades of red from light to dark<br />
- Modify the numbers by rounding them off.</p>
<p>10) Add a legend. Select a location, rename the title.</p>
<p><img class="aligncenter size-full wp-image-12887" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/legend.jpg" alt="legend" width="599" height="548" /></p>
<p>It should look something like this.</p>
<p><img class="aligncenter size-full wp-image-12889" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/finaldeblasiomap.jpg" alt="finaldeblasiomap" width="640" height="399" /></p>
<p>11) Publish and get the embed code for the map</p>
<p><img class="aligncenter size-full wp-image-12888" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/embedtable.jpg" alt="embedtable" width="597" height="330" /></p>
<h3>VI. Exercise: Asthma Rates in NYC</h3>
<p><a href="https://www.dropbox.com/s/pr62853bvjx17ec/DataFiles.zip?dl=0" target="_blank">DOWNLOAD THIS FOLDER OF DATA</a></p>
<p><a href="http://www.health.ny.gov/statistics/ny_asthma/hosp/zipcode/map.htm"><img class="aligncenter size-full wp-image-10053" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/11/dischargemap.jpg" alt="dischargemap" width="640" height="405" /></a></p>
<p>1. We are going to create the data by combining borough data from health statistics. 2008-2010 Hospital Discharge Rates for Asthma, by NYC ZIP codes:<br />
<a href="http://www.health.ny.gov/statistics/ny_asthma/hosp/zipcode/map.htm">http://www.health.ny.gov/statistics/ny_asthma/hosp/zipcode/map.htm</a></p>
<p>FYI:  To assemble the data set click on each county (Queens, Kings, Bronx, Richmond, Manhattan).</p>
<p><a href="http://www.health.ny.gov/statistics/ny_asthma/hosp/zipcode/bronx.htm" target="_blank"><img class="aligncenter size-full wp-image-10052" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/11/healtdata.jpg" alt="healtdata" width="560" height="380" /></a>Click on TOTAL TABLE, and copy and paste each table into a new Excel file. The result will be all the zip codes for NYC showing asthma discharges, population, and rates.</p>
<p>Note the footnote!</p>
<p>* &#8211; Data is suppressed for confidentiality purposes if there are less than 3 discharges per ZIP code or if the average annual population in each ZIP code contains less than 33 people.<br />
+ &#8211; Less than or equal to 10 discharges, therefore rate may not be stable (RSE&gt;30%).</p>
<p>You can deal with the footnote in the map itself (you can filter out all the discharges less or equal to 10). Delete all the asterisks and Plus symbols from the spreadsheet.</p>
<p>2. Upload the completed CSV. It is here HospitalAsthmaDischarge.csv in your folder. You can also find it <a href="https://dl.dropboxusercontent.com/u/56069701/hospital_asthma_discharge.csv." target="_blank">here</a>.</p>
<p>3. Go to File &gt; Merge and merge the Hospital Asthma data with the zip code file we uploaded earlier.  Or you can paste this URL into the field at the bottom of the box.: https://www.google.com/fusiontables/DataSource?docid=1uUkL6MvZTpsG-Zjl6o43zVaoCLmjCPpCzOWxB00</p>
<p><img class="aligncenter size-full wp-image-16360" src="http://www.christinemckenna.com/interactive/wp-content/uploads/2013/11/mergewithurl.jpg" alt="mergewithurl" width="640" height="414" /></p>
<p>4. Click on the &#8220;Map of Geometry&#8221; tab on the upper-right hand side of the table. This should display the map.</p>
<p style="text-align: center;"><img class="aligncenter size-full wp-image-16362" style="border: 1px solid black;" src="http://www.christinemckenna.com/interactive/wp-content/uploads/2013/11/tools.jpg" alt="tools" width="466" height="294" /></p>
<p>5. Then click on the  &#8220;Change Feature Styles&#8221;. If it is not visible, click on Tools &gt; Change Map.  Click on Polygon fill. Next, navigate to the &#8220;Bucket&#8221; tab on the right. Then, choose Divide by 4 buckets. Next, select the &#8220;Rate&#8221; from the pulldown menu next to &#8220;Column.</p>
<p style="text-align: left;">6. Underneath the Rate, you will see a range of numbers and a link to &#8220;use this range.&#8221; Click on that link. Next go and round up the numbers to 0-25, 25-50, 50-75, 75-97.1. Hit &#8220;save&#8221;</p>
<p><img class="aligncenter size-full wp-image-16363" src="http://www.christinemckenna.com/interactive/wp-content/uploads/2013/11/changemapfeaturestyles.jpg" alt="changemapfeaturestyles" width="580" height="530" /></p>
<p>7. In this study, some information was not usable due to confidentiality concerns. For example, in instances where there were very few hospital cases of asthma (any less than 10)</p>
<p>8. To eliminate this odd data, we are going to restrict our map to discharges greater than 10. So, go to Filter&gt;2008-2010 discharges. Next insert 11 &#8211; 2261</p>
<p style="text-align: center;"><img class="aligncenter wp-image-10049" style="border: 1px solid black;" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/11/asthmarates.jpg" alt="asthmarates" width="640" height="411" /></p>
<p>9. Next we are going to tidy up the info window. Go to Tools &gt; Change Info Window. Uncheck all but the following.</p>
<p><b>ZIP Code:</b> {ZIP Code}<br />
<b>2008-2010 discharges:</b> {2008-2010 discharges}<br />
<b>2008-2010 population:</b> {2008-2010 population}<br />
<b>Rate:</b> {Rate}</p>
<p><img class="aligncenter size-full wp-image-16365" src="http://www.christinemckenna.com/interactive/wp-content/uploads/2013/11/changeinfowindow.jpg" alt="changeinfowindow" width="628" height="482" /></p>
<p>10. Add a map legend by going to Tools&gt; Change Map Tools &gt; Automatic Legend. Select &#8220;Polygon fill&#8221;</p>
<p><img class="aligncenter size-full wp-image-16366" src="http://www.christinemckenna.com/interactive/wp-content/uploads/2013/11/legend.jpg" alt="legend" width="466" height="432" /></p>
<h3>VI. Exercise: Stop and Frisk<br />
<img class="alignnone size-large wp-image-10017" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/11/rate.jpg" alt="rate" width="640" height="363" /></h3>
<p><span style="color: #000080;"><strong>Use Google Fusion Maps to Try and Answer Some of These Questions</strong></span></p>
<p>1) Identify your data sets and what you want to illustrate. Example: I am going to show the number of 2011 stop and frisk incidents by police precinct. I am also going to include a racial breakdown of these stops.</p>
<p>Data source: <a href="http://christinemckenna.com/interactive/checklist-google-fusion-tables/2011_reasonable_suspicion_encounters/" rel="attachment wp-att-8111">NYPD &#8211; 2011 Reasonable Suspicion Encounters </a></p>
<p>2) Prepare your data and locate the appropriate shapefiles, depending on the geographical parameters of your graphic: borough, community district, precinct, block etc.</p>
<p>Data set: <a href="http://christinemckenna.com/interactive/checklist-google-fusion-tables/reasonablesuspicionstops/" rel="attachment wp-att-8114">Reasonable Suspicion Stops </a><a href="http://christinemckenna.com/interactive/checklist-google-fusion-tables/2011_reasonable_suspicion_encounters/" rel="attachment wp-att-8111">(CSV, comma separated values)<br />
</a>Precinct boundaries: <a href="http://christinemckenna.com/interactive/checklist-google-fusion-tables/nycpoliceprecincts/" rel="attachment wp-att-8116">NYC Police Precincts</a></p>
<p>3) Upload your data sets to Google Fusion Tables.</p>
<p>4) Click on Reasonable Suspicion Stop. Go to edit&gt;merge</p>
<p><img class="aligncenter size-full wp-image-8127" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/02/merge.jpg" alt="merge" width="417" height="400" /></p>
<p>5) Select Police Precincts</p>
<p><img class="aligncenter size-full wp-image-8128" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/02/selectamerge.jpg" alt="selectamerge" width="566" height="400" /></p>
<p>6) Confirm that the correct row is selected for the titles.</p>
<p><img class="aligncenter size-full wp-image-8129" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/02/columnnames.jpg" alt="columnnames" width="640" height="375" /></p>
<p>7) Make sure that they both are synced to Precinct</p>
<p>8) Click on Map View, then under Tools, select Change Info Window Layout</p>
<p><img class="aligncenter size-full wp-image-8130" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/02/changeinfopulldown.jpg" alt="changeinfopulldown" width="521" height="400" /></p>
<p>9) Delete all information except for the precinct number, the number of stops, the population and stops for black and Latinos.</p>
<p><img class="aligncenter size-full wp-image-8133" src="http://christinemckenna.com/interactive/wp-content/uploads/2013/02/changeinfowindow.jpg" alt="changeinfowindow" width="535" height="400" /></p>
<p>10) Now, in the Tools menu, select Change Map Styles. Here you are going to select Fill color &gt; Buckets. Select five buckets and the column should be Reasonable Stops. Once you select that, it will show you the range of numbers and ask if you want to use that data set. This will spread the data evenly over the five buckets. You can adjust it to make the statement you wish to make. In this case, we want to round up the numbers, with 31,005 as the final bucket.</p>
<p><img class="aligncenter size-full wp-image-12895" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/changemapfeatures.jpg" alt="changemapfeatures" width="593" height="548" /></p>
<p><img class="aligncenter size-full wp-image-12896" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/mergestop.jpg" alt="mergestop" width="640" height="402" /></p>
<h3>Analysis</h3>
<p>- How do the absolute numbers compare to the normalized?</p>
<p>- Example. Check out the top two precincts for stop and frisk, the 73rd and the 75th, in terms of absolute numbers. By this measure, they fall into the same dark shade of red, but when you normalize the data they are quite different.</p>
<p>- Use filters to determine what precincts have a disproportionate number of stops for minorities.</p>
<p>A precinct where a disproportionate number of African Americans are stopped:</p>
<p><img class="aligncenter size-full wp-image-12899" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/aa.jpg" alt="aa" width="640" height="436" /></p>
<p>A precinct where a disproportionate number of Latinos are stopped:<img class="aligncenter size-full wp-image-12898" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/latino.jpg" alt="latino" width="640" height="396" /></p>
<p>Other information found in the 2011 report. How could this data be used to further illuminate the stop and frisk topic?</p>
<p>Top crime suspected reason during stop.<br />
All known suspects<br />
Known violent crime suspects<br />
Radio runs<br />
Total crime complaints<br />
Arrests and criminal court summonses issued</p>
<h3>Things to consider:</h3>
<p>- What biases may exist in your data source? Crosscheck these with a neutral expert. You might also consider the opposing point of view. In the case of stop and frisk, the NYCLU has been working on this issue, what does its data say?</p>
<p>- If you are entering data yourself, double-check all of your work to make sure you haven&#8217;t make errors.</p>
<p>- Use your common sense. Does something seem unrealistic? If so, maybe the math is wrong.</p>
<p>&nbsp;</p>
<p>F<a href="http://fusion-tables-api-samples.googlecode.com/svn/trunk/FusionTablesLayerWizard/src/index.html" target="_blank">Fusion Tables Layer Wizard</a></p>
<p><a href="http://fusion-tables-api-samples.googlecode.com/svn/trunk/FusionTablesLayerWizard/src/index.html"><img class="aligncenter size-full wp-image-13082" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/fusionlayers.jpg" alt="fusionlayers" width="640" height="422" /></a></p>
<h3>Student Examples:</h3>
<p><a href="http://fms-mckenna.2013.journalism.cuny.edu/2013/12/08/new-york-city-lottery-by-the-numbers/" target="_blank">Lottery<br />
</a><a href=" http://fms-mckenna.2013.journalism.cuny.edu/2015/01/19/hunger-and-food-stamps-in-new-york-city/" target="_blank">Hunger and Food Stamps<br />
</a><a href="http://www.mfahey.com/TabbedMaps.html" target="_blank">Illegal Occupancy<br />
</a><a href="http://fms-mckenna.2013.journalism.cuny.edu/2013/11/25/complainers-and-unemployment/" target="_blank">311 Complaints<br />
</a></p>
]]></content:encoded>
			<wfw:commentRss>http://christinemckenna.com/multimedia/?feed=rss2&#038;p=18533</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Steps to Creating a Data Feature</title>
		<link>http://christinemckenna.com/multimedia/?p=18194</link>
		<comments>http://christinemckenna.com/multimedia/?p=18194#comments</comments>
		<pubDate>Fri, 25 Jan 2019 18:45:35 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Data]]></category>

		<guid isPermaLink="false">http://christinemckenna.com/multimedia/?p=18194</guid>
		<description><![CDATA[How to conceive and execute your data story]]></description>
				<content:encoded><![CDATA[<p>#1 Seek inspiration: find a topic and report, what data is relevant?<br />
#2 Find the data: review available sources, perform searches<br />
#3 Download, clean, and organize the data<br />
#4 Interview and analyze the data: show change over time, identify patterns, make comparisons, investigate outliers, personalize with databases<br />
#5 Execution: What type of format or visualization is best suited to your story: charts, maps, interactive graphics.</p>
<p><em>Source: <a href="http://carlvlewis.net/jaxdotcom/datavisualization_jaxdotcom.pdf" target="_blank">Carl V Lewis</a></em></p>
<p><a href="http://onlinejournalismblog.com/2011/07/07/the-inverted-pyramid-of-data-journalism/" target="_blank">Another process: The inverted pyramid of data journalism</a></p>
<p><a href="http://onlinejournalismblog.com/2011/07/07/the-inverted-pyramid-of-data-journalism/" target="_blank"><img class="aligncenter size-full wp-image-12071" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/inverted.jpg" alt="inverted" width="460" height="512" /></a></p>
<h4>Step #1: Seek Inspiration</h4>
<p>- Reporting on a story<br />
- Breaking news<br />
- News folo<br />
- Browsing data sets</p>
<p><a href="http://www.cloudred.com/labprojects/nyctrees/" target="_blank">An Interactive Visualization of NYC Street Trees</a></p>
<p><a href="http://www.cloudred.com/labprojects/nyctrees/" target="_blank"><img class="aligncenter size-full wp-image-12118" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/treesofnewyork.jpg" alt="treesofnewyork" width="640" height="348" /></a></p>
<p>Using data provided by NYC Open Data, this visualization shows the variety and quantity of street trees in all five New York City boroughs.</p>
<h4>Step #2: Find Relevant Data</h4>
<p><a href="http://www1.nyc.gov/site/planning/data-maps/nyc-population.page" target="_blank"><img class="aligncenter wp-image-12095 size-full" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/popdatanyc.jpg" alt="popdatanyc" width="594" height="532" /></a><a href="https://docs.google.com/document/d/1Uo2O1WFFXj-Zf7senF-ENjAURnU_JWO43dVF0vddnUE/edit"><strong>CUNY J-school List of Data Sources</strong><br />
</a>This is a very thorough, constantly updated, list of data sources.</p>
<p><a href="https://docs.google.com/document/d/1Uo2O1WFFXj-Zf7senF-ENjAURnU_JWO43dVF0vddnUE/edit"><img class="aligncenter size-full wp-image-15179" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/10/migueldata.jpg" alt="migueldata" width="700" height="461" /></a>Government (city, county, state and national) and nonprofits<br />
- <a href="https://data.cityofnewyork.us/" target="_blank">NYC Open Data NYC</a><br />
- <a href="http://maps.nyc.gov/census/" target="_blank">NYC Factfinder</a><br />
- <a href="http://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml" target="_blank">Census/ACS &#8211; American Factfinder</a><br />
- <a href="http://www.data.gov/" target="_blank">Data.gov: U.S. data portal</a><br />
- <a href="http://data.worldbank.org/" target="_blank">World Bank</a><br />
- <a href="http://data.un.org/" target="_blank">United Nations</a></p>
<p><strong>Data collections, portals, hubs</strong></p>
<p><a href="http://dataportals.org/" target="_blank"><img class="aligncenter size-full wp-image-12150" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/dataportals.jpg" alt="dataportals" width="640" height="347" /></a>- <a href="http://dataportals.org/" target="_blank">DataPortal.org: Data portals around the world</a><br />
- <a href="http://www.guardian.co.uk/world-government-data" target="_blank">Guardian World Government Data</a><br />
- <a href="http://thedatahub.org/" target="_blank">The Data Hub</a><br />
- <a href="http://censusreporter.org/" target="_blank">Census Reporter</a></p>
<p><a href="http://censusreporter.org/" target="_blank"><img class="aligncenter size-full wp-image-12124" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/censusreporter.jpg" alt="censusreporter" width="640" height="301" /></a><br />
<a href="https://docs.google.com/spreadsheets/d/1wZhPLMCHKJvwOkP4juclhjFgqIY8fQFMemwKL2c64vk/edit#gid=0">Data is Plural &#8211; Collection of interesting data sets for journalists</a></p>
<p><strong>Searching for data using Google </strong></p>
<p><a href="http://datajournalismhandbook.org/1.0/en/getting_data_0.html#sthash.WfsnrVL6.dpuf" target="_blank">Tips from the Data Journalism Handbook</a></p>
<p>When searching for data, make sure that you include both search terms relating to the content of the data you’re trying to find as well as some information on the format or source that you would expect it to be in. Google and other search engines allow you to search by file type. For example, you can look only for spreadsheets (by appending your search with ‘filetype:XLS filetype:CSV’), geodata (‘filetype:shp’), or database extracts (‘filetype:MDB, filetype:SQL, filetype:DB’). If you’re so inclined, you can even look for PDFs (‘filetype:pdf’).</p>
<p>You can also search by part of a URL. Googling for ‘inurl:downloads filetype:xls’ will try to find all Excel files that have “downloads” in their web address (if you find a single download, it’s often worth just checking what other results exist for the same folder on the web server). You can also limit your search to only those results on a single domain name, by searching for, e.g. ‘site:agency.gov’.</p>
<p>Another popular trick is not to search for content directly, but for places where bulk data may be available. For example, ‘site:agency.gov Directory Listing’ may give you some listings generated by the web server with easy access to raw files, while ‘site:agency.gov Database Download’ will look for intentionally created listings.</p>
<p><strong>Data formats</strong><br />
.CSV: CSV stands for Comma Separated Values &#8211; this means that the value in each column is separated by a comma like so: Name, Date of birth, Address. When the spreadsheet software opens this, it replaces each comma with a new column.<br />
.TSV: Tab Separated Values &#8211; values are separated by tabs<br />
Fixed width: values are separated by spaces<br />
.XLS: Excel document<br />
XML: Extensible markup language &#8211; values arranged using open/closing tags like HTML<br />
JSON: Used for exporting data for use in Web javascript<br />
PDF: If data is in PDF, there are tools to extricate it like <a href="http://tabula.technology/" target="_blank">Tabula</a>.<br />
.KML or .SHP: Geographic data</p>
<h4>Step #3: Download data, import into Excel, clean</h4>
<p>Many data sets can be downloaded in Excel or CSV formats.  NYC Open Data allows you to filter out the data sets for particular information.</p>
<p><a href="https://data.cityofnewyork.us/videos/popup#basic-filtering" target="_blank">Watch NYC Open Data &#8211; Video Guides</a></p>
<p><a href="https://data.cityofnewyork.us/videos/popup#basic-filtering" target="_blank"><img class="aligncenter size-full wp-image-12612" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/videoguides.jpg" alt="videoguides" width="640" height="345" /></a></p>
<p>At its most basic, a spreadsheet acts as a calculator. They can add, subtract, divide, and multiply, and through a combination of those can calculate averages, proportions, rates, and various other things which can provide an insight into the data. One of the most common of those stories is about change. Change is, almost by definition, newsworthy, and an integral part of storytelling. When things change, it makes the news. &#8212; Finding Stories with Spreadsheets, Paul Bradshaw</p>
<p><a href="https://docs.google.com/document/d/1NGJXjcqJOckyQfwzAXn1f5Oi2-AKWaO51qxmKo3wNIA/edit">All about Excel with exercises by Miguel Paz</a></p>
<p><a href="https://docs.google.com/document/d/1Uo2O1WFFXj-Zf7senF-ENjAURnU_JWO43dVF0vddnUE/edit"><img class="aligncenter size-full wp-image-15181" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/10/excel.jpg" alt="excel" width="724" height="421" /></a></p>
<p>EXERCISE: Intro to Cleaning Data</p>
<p><a href="http://multimedia.journalism.berkeley.edu/tutorials/cleaning-data/" target="_blank"><img class="aligncenter size-full wp-image-12066" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/excelmain_1.jpg" alt="excelmain_1" width="620" height="359" /></a><strong>Formulas</strong></p>
<p>- Calculations are called formulas in Excel and other spreadsheet software<br />
- A formula begins with an equals operator: =<br />
- Formulas are most likely to use cell references like A2 or B300.</p>
<p><strong>Functions</strong></p>
<p>Functions are words that have special meanings in Excel and other spreadsheet software. They are shortcuts for a series of instructions. Functions are always followed by parentheses containing the ingredients it needs. These are called arguments (specifically) or parameters (in general). The function for adding up a series of cells is called SUM. =SUM(A1:A5) or =SUM(A:A) or =SUM(A1:B500) or =SUM(1:1)</p>
<p>- SUM: Add all these figures up’<br />
- AVERAGE: Calculate an average for these figures<br />
- COUNT: Count how many numbers I have in this column</p>
<p>Resource: <a href="http://christinemckenna.com/interactive/spreadsheets-excel/" target="_blank">Excel Spreadsheet Basics</a></p>
<p><a href="http://christinemckenna.com/interactive/spreadsheets-excel/" target="_blank"><img class="aligncenter size-full wp-image-12110" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/references1.jpg" alt="references" width="640" height="449" /></a></p>
<p><a href="http://multimedia.journalism.berkeley.edu/tutorials/cleaning-data/" target="_blank">Workflow &#8211; Tutorial: Intro To Cleaning Data, Len de Groot</a></p>
<p>- If importing CSV, retain leading zeros<br />
- Make sure data was imported properly and column data matches the column headers<br />
- Save a copy immediately<br />
- Delete blank rows within the data<br />
- Consolidate Column headers to a single row<br />
- Format all integer columns to eliminate commas<br />
- Find and replace special characters (&amp;, ! , ~, etc) When in doubt, replace with a space, under-stroke or hyphen<br />
- Check spelling (especially in columns you plan to Join)<br />
- Check capitalization (especially in columns you plan to Join)<br />
- Check abbreviations (especially in columns you plan to Join)<br />
- Keep totals from original data to check against. This ensures data is not lost.<br />
- Manipulate data in columns last.<br />
- Delete what you don’t need</p>
<h4>Step #4: Interview and Analyze Data</h4>
<p><img class="aligncenter size-full wp-image-12126" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/deductive.jpg" alt="deductive" width="640" height="421" /></p>
<p>Interviewing data is very much like interviewing human sources — your goal is to find patterns that generate additional interview questions or story ideas.</p>
<p>- How much has something changed?<br />
- Who or where experienced the most change? Who changed the least?<br />
- Which company or person got the most money?<br />
- What is typical &#8211; and who stands out the most as being atypical?<br />
- How often does a name appear? Where?<br />
- How much was spent in total on something?</p>
<p>&#8211; Finding Stories with Spreadsheets, Paul Bradshaw</p>
<p><strong>How reliable, credible is the data set?</strong></p>
<p>- Where did the data come from?<br />
- Have the data been peer-reviewed?<br />
- How were the data collected?<br />
- If the data come from a survey, for example, you want to know that the people who responded to the survey were selected at random.<br />
- Is it a &#8220;self-selected sample?&#8221; People who feel really passionately about one side often flood a web site poll, skewing the results from what they would have been had you polled only a random sample of people in the community.<br />
- Have results been cherry-picked? This is the social-science equivalent of gerrymandering, where you draw up a legislative district so that all the people who are going to vote for your candidate are included in your district and everyone else is scattered among a bunch of other districts. (See <a href="http://www.nytimes.com/2015/09/06/public-editor/awash-in-data-thirsting-for-truth.html" target="_blank">Awash in Data, Thirsting for Truth</a>.)<br />
- When in doubt, plot the subjects of a study on map and look for yourself to see if the boundaries make sense.<br />
- Are the numbers taken out of context? The example of weather reports citing the number of fender benders on the road in a snow storm. How do these numbers compare to a sunny day?<br />
- <a href="http://christinemckenna.com/interactive/ten-foundational-quantitative-reasoning-questions/" target="_blank">10 Foundational Quantitative Reasoning Questions</a></p>
<p>Once you have spent some time answering these questions, you should consult an expert who is familiar with both the subject and the data set.</p>
<p>- Have I got things right?<br />
- Am I missing information missing?<br />
- Where should I be looking?<br />
- How would you evaluate this data?</p>
]]></content:encoded>
			<wfw:commentRss>http://christinemckenna.com/multimedia/?feed=rss2&#038;p=18194</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Visualizing Data</title>
		<link>http://christinemckenna.com/multimedia/?p=18319</link>
		<comments>http://christinemckenna.com/multimedia/?p=18319#comments</comments>
		<pubDate>Wed, 16 Jan 2019 00:59:08 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Data]]></category>

		<guid isPermaLink="false">http://christinemckenna.com/multimedia/?p=18319</guid>
		<description><![CDATA[A review of data storytelling]]></description>
				<content:encoded><![CDATA[<p><strong>Hans Rosling&#8217;s 200 Countries, 200 Years, 4 Minutes &#8211; The Joy of Stats</strong><br />
<iframe src="https://www.youtube.com/embed/jbkSRLYSojo" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p>
<p>Another excellent data viz video: <a href="http://www.ted.com/talks/david_mccandless_the_beauty_of_data_visualization/transcript?language=en" target="_blank">Ted Talk- David McCandless: The beauty of data visualization</a></p>
<h4>A. Insight from Edward Tufte</h4>
<p><a href="http://www.amazon.com/dp/0961392118/?tag=googhydr-20&amp;hvadid=76262677399&amp;hvpos=1t1&amp;hvexid=&amp;hvnetw=g&amp;hvrand=1247559112493360204&amp;hvpone=40.89&amp;hvptwo=&amp;hvqmt=b&amp;hvdev=c&amp;ref=pd_sl_23ax9s6p45_b&amp;tag=donations09-20"><img class="aligncenter size-full wp-image-12541" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/envisioning-information.jpg" alt="envisioning-information" width="640" height="428" /></a></p>
<p>Tufte is the author of &#8220;<a href="http://www.amazon.com/The-Visual-Display-Quantitative-Information/dp/0961392142" target="_blank">The Visual Display of Quantitative Information</a>&#8221; and &#8220;<a href="http://www.amazon.com/dp/0961392118/?tag=googhydr-20&amp;hvadid=76262677399&amp;hvpos=1t1&amp;hvexid=&amp;hvnetw=g&amp;hvrand=1247559112493360204&amp;hvpone=40.89&amp;hvptwo=&amp;hvqmt=b&amp;hvdev=c&amp;ref=pd_sl_23ax9s6p45_b&amp;tag=donations09-20" target="_blank">Envisioning Information</a>.&#8221; He has been called &#8220;The Leonardo da Vinci of data,&#8221; by the New York Times and &#8220;The Galileo of graphics,&#8221; by Business Week.</p>
<p><img class="aligncenter size-full wp-image-12542" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/principlesofgraphicalexcellence.jpg" alt="principlesofgraphicalexcellence" width="433" height="195" /></p>
<p>1. Above all else, show the data</p>
<p>2. Induce the viewer to think about the substance rather than about methodology, graphic design, the tech of graphic production, or something else.</p>
<p>3. Avoid distorting the data, reflect balance, a proportion, a sense of relevant scale and eliminate &#8220;chart-junk.&#8221;</p>
<p><img class="aligncenter size-full wp-image-12603" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/foxobamacare.jpg" alt="foxobamacare" width="570" height="338" /></p>
<p>4. Present many numbers in a small space.</p>
<p>A map of the Napoleon&#8217;s Grande Armée&#8217;s advance and retreat into Russia</p>
<div id="attachment_12522" class="wp-caption aligncenter" style="width: 670px"><a href="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/Minardlg1.jpg"><img class=" wp-image-12522" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/Minardlg-1024x488.jpg" alt="Minardlg" width="660" height="314" /></a><p class="wp-caption-text">Charles Joseph Minard was a French civil engineer that created what Tufte calls, &#8220;The greatest statistical graphic ever drawn.&#8221; The graphic displays six different sets of data: latitude, longitude, direction of movement, time, temperature, and size of the army.</p></div>
<p>5. Make large datasets coherent.</p>
<p>6. Encourage the eye to compare different pieces of data.</p>
<p>7. Reveal data at several levels of detail, from a broad overview to the fine structure.</p>
<p>8. Serve a reasonably clear purpose: description, exploration, tabulation, or decoration.</p>
<p>9. Use words, numbers and drawings together.</p>
<p>&#8220;Lousy graphics omit context, bury critical information, cherry-pick data to advance a cause and heap on “chartjunk’’—a Tufteism (and there are many) for the smiley faces, irrelevant numbers and other doodads that distract us from grasping evidence, thinking about it and drawing smart conclusions.&#8221; &#8212; <a href="http://alumni.stanford.edu/get/page/magazine/article/?article_id=32152" target="_blank">Intelligent Designs </a></p>
<h4>B. Selecting the right visualization for your data set</h4>
<p>What is your goal? Show change over time, identify patterns, make comparisons, investigate outliers, personalize with databases.</p>
<p>- How much has something changed?<br />
- Who or where experienced the most change? Who changed the least?<br />
- Which company or person got the most money?<br />
- What is typical – and who stands out the most as being atypical?<br />
- How often does a name appear? Where?<br />
- How much was spent in total on something?</p>
<p><em>– Finding Stories with Spreadsheets, Paul Bradshaw</em></p>
<p><strong>Tables</strong><br />
<a href="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/PeriodicTableMuted.png" target="_blank"><br />
Periodic Table</a></p>
<p><a href="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/PeriodicTableMuted.png"><img src="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/PeriodicTableMuted-1024x576.png" alt="PeriodicTableMuted" width="660" height="371" class="alignnone size-large wp-image-18328" /></a></p>
<p><a href="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/periodic_table_of_storytelling_by_computersherpa-d3d6rdj.jpg" target="_blank">Periodic Table of Storytelling</a></p>
<p><a href="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/periodic_table_of_storytelling_by_computersherpa-d3d6rdj.jpg"><img src="http://christinemckenna.com/multimedia/wp-content/uploads/2016/11/periodic_table_of_storytelling_by_computersherpa-d3d6rdj-1024x968.jpg" alt="periodic_table_of_storytelling_by_computersherpa-d3d6rdj" width="660" height="623" class="alignnone size-large wp-image-18324" /></a></p>
<p><strong>Charts</strong></p>
<p><a href="http://www.gapminder.org/world/#$majorMode=chart$is;shi=t;ly=2003;lb=f;il=t;fs=11;al=30;stl=t;st=t;nsl=t;se=t$wst;tts=C$ts;sp=5.59290322580644;ti=2013$zpv;v=0$inc_x;mmid=XCOORDS;iid=phAwcNAVuyj1jiMAkmq1iMg;by=ind$inc_y;mmid=YCOORDS;iid=phAwcNAVuyj2tPLxKvvnNPA;by=ind$inc_s;uniValue=8.21;iid=phAwcNAVuyj0XOoBL_n5tAQ;by=ind$inc_c;uniValue=255;gid=CATID0;by=grp$map_x;scale=log;dataMin=194;dataMax=96846$map_y;scale=lin;dataMin=23;dataMax=86$map_s;sma=49;smi=2.65$cd;bd=0$inds=;modified=60 "><img class="aligncenter size-full wp-image-12526" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/gapminder1.jpg" alt="gapminder" width="640" height="476" /></a></p>
<p><strong>Graphics</strong></p>
<p><a href="http://www.nytimes.com/interactive/us/family-trees.html#index" target="_blank"><img class="aligncenter size-full wp-image-12550" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/interactivetree1.jpg" alt="interactivetree1" width="640" height="465" /></a></p>
<p>&nbsp;</p>
<h4>C. What chart is best for your story?</h4>
<p><strong>Kurt Vonnegut on the Shapes of Stories</strong><br />
<iframe src="https://www.youtube.com/embed/oP3c1h8v2ZQ" width="640" height="480" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p>
<p><a href="http://extremepresentation.typepad.com/files/choosing-a-good-chart-09.pdf" target="_blank">Choosing a good chart</a></p>
<p>What is your goal: to compare? to show the parts of a whole? to show a range? to illustrate a relationship?</p>
<p><a href="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/chartsuggestions.jpg"><img class="aligncenter size-full wp-image-12530" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/chartsuggestionssm.jpg" alt="chartsuggestionssm" width="640" height="487" /></a><br />
<a href="https://github.com/ft-interactive/chart-doctor/blob/master/visual-vocabulary/Visual-vocabulary.pdf">FT: Visual Vocabulary</a><br />
<a href="https://github.com/ft-interactive/chart-doctor/blob/master/visual-vocabulary/Visual-vocabulary.pdf"><img class="aligncenter size-full wp-image-15280" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/ft3.jpg" alt="ft3" width="1004" height="773" /></a><br />
<a href="http://paldhous.github.io/NICAR/2016/infodesign.html">NICAR: Choosing a Chart/Information Design</a></p>
<p><strong>Bar chart: comparing data across categories</strong></p>
<p>Bar charts are  especially effective when you have numerical data that splits nicely into different  categories so you can quickly see trends within your data.<strong><br />
</strong></p>
<p><a href="http://www.nytimes.com/interactive/2011/02/04/business/aging-population.html" target="_blank">The Aging of America</a></p>
<p><a href="http://www.nytimes.com/interactive/2011/02/04/business/aging-population.html" target="_blank"><img class="aligncenter size-full wp-image-12562" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/aging.jpg" alt="aging" width="614" height="423" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2014/09/03/us/the-race-gap-in-americas-police-departments.html" target="_blank">The Race Gap in America’s Police Departments</a></p>
<p><a href="http://www.nytimes.com/interactive/2014/09/03/us/the-race-gap-in-americas-police-departments.html" target="_blank"><img class="aligncenter size-full wp-image-12557" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/cops.jpg" alt="cops" width="640" height="206" /></a></p>
<p>&nbsp;</p>
<p><a href="https://podio.com/site/creative-routines" target="_blank">Daily Routines of Famous Creative People</a></p>
<p><a href="https://podio.com/site/creative-routines"><img class="aligncenter size-full wp-image-14417" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/routines-of-creative-people-infographic.png" alt="routines-of-creative-people-infographic" width="936" height="1689" /></a></p>
<p><a href="http://www.pewresearch.org/next-america/#Two-Dramas-in-Slow-Motion" target="_blank">Two Dramas in Slow Motion</a></p>
<p><a href="http://www.pewresearch.org/next-america/#Two-Dramas-in-Slow-Motion"><img class="aligncenter size-full wp-image-15299" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/pyramid.jpg" alt="pyramid" width="611" height="573" /></a></p>
<p><strong>Column Chart</strong><br />
<a href="http://graphics.wsj.com/job-market-tracker/" target="_blank"><img class="aligncenter size-full wp-image-14938" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/08/unemployment.jpg" alt="unemployment" width="640" height="377" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2015/08/28/world/europe/countries-under-strain-from-european-migration-crisis.html" target="_blank">Which Countries Are Under the Most Strain in the European Migration Crisis?</a><br />
<a href="http://www.nytimes.com/interactive/2015/08/28/world/europe/countries-under-strain-from-european-migration-crisis.html" target="_blank"><img src="http://christinemckenna.com/interactive/wp-content/uploads/2015/08/refugee.jpg" alt="refugee" width="640" height="340" /></a></p>
<p>&#8220;Germany has received more applicants than any other European Union nation, with more than 154,000 migrants seeking asylum from January to June, up from 68,000 in the same period last year. When adjusted for population, Hungary and Sweden are among the top recipients.&#8221;&#8211; NYTimes.com</p>
<p><a href="http://www.bloomberg.com/politics/articles/2015-07-28/here-s-our-tally-of-donald-trump-s-wealth" target="_blank">Bloomberg: Based on an analysis that included the candidate&#8217;s 92-page personal financial disclosure form, his wealth is closer to $2.9 billion.</a></p>
<p><a href="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/donaldvalue.jpg" target="_blank"><img class="aligncenter size-full wp-image-13121" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/donaldvalue.jpg" alt="donaldvalue" width="743" height="582" /></a><br />
<strong><a href="http://www.theatlantic.com/politics/archive/2015/01/the-language-of-the-state-of-the-union/384575/" target="_blank">The Language of the State of the Union</a><br />
<a href="http://www.theatlantic.com/politics/archive/2015/01/the-language-of-the-state-of-the-union/384575/" target="_blank"><img src="http://christinemckenna.com/interactive/wp-content/uploads/2015/08/stateofunion.jpg" alt="stateofunion" width="640" height="499" /></a></strong></p>
<p>&#8220;An interactive chart reveals how the words presidents use reflect the twists and turns of American history.&#8221; &#8211; Atlantic Monthly</p>
<p><a href="http://www.nytimes.com/interactive/2014/upshot/buy-rent-calculator.html" target="_blank">Is It Better to Rent or Buy?</a><br />
<a href="http://www.nytimes.com/interactive/2014/upshot/buy-rent-calculator.html?rref=upshot&amp;abt=0002&amp;abg=0" target="_blank"><img src="http://christinemckenna.com/interactive/wp-content/uploads/2015/08/rentorbuy.jpg" alt="rentorbuy" width="640" height="373" /></a></p>
<p>&#8220;The choice between buying a home and renting one is among the biggest financial decisions that many adults make. But the costs of buying are more varied and complicated than for renting, making it hard to tell which is a better deal. To help you answer this question, our calculator takes the most important costs associated with buying a house and computes the equivalent monthly rent.&#8221; &#8212; NYTimes.com</p>
<p><strong>Line charts: change or trends over a period of time</strong></p>
<div data-canvas-width="571.671">
<p>Line charts connect individual numeric data points. The result is a simple, straightforward way to visualize a sequence of values. Their primary use is to displaytrends over a period of time.</p>
<p>Examples: stock price change over a five-year period, website page views during a month, revenue growth by quarter.<br />
<a href="http://www.bloomberg.com/dataview/2014-04-17/how-americans-die.html" target="_blank">Bloomberg: How Americans Die</a></p>
<p><a href="http://www.bloomberg.com/dataview/2014-04-17/how-americans-die.html" target="_blank"><img class="aligncenter size-full wp-image-12531" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/howamericansdie.jpg" alt="howamericansdie" width="640" height="367" /></a></p>
<p><strong>Gun deaths vs. terrorism deaths</strong></p>
<p><a href="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/deathscausedbyterrorismguns.jpg" target="_blank"><img class="aligncenter size-full wp-image-13114" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/deathscausedbyterrorismguns.jpg" alt="deathscausedbyterrorismguns" width="605" height="342" /></a></p>
<p><a href="http://www.theguardian.com/news/datablog/2015/sep/18/angela-merkel-10-years-germany-chancellor-economy-cdu" target="_blank">Angela Merkel: 10 years in 10 charts</a></p>
<p><a href="http://www.theguardian.com/news/datablog/2015/sep/18/angela-merkel-10-years-germany-chancellor-economy-cdu" target="_blank"><img class="aligncenter size-full wp-image-13126" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/unemploymentrate.jpg" alt="unemploymentrate" width="659" height="490" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2014/09/14/sunday-review/unplanned-pregnancies.html" target="_blank">NYT: How Likely Is It That Birth Control Could Let You Down?</a></p>
<p>For every 100 women, the number who will have an unplanned pregnancy over a given number of years.</p>
<p><a href="http://www.nytimes.com/interactive/2014/09/14/sunday-review/unplanned-pregnancies.html" target="_blank"><img class="aligncenter size-full wp-image-12553" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/birthcontrol.jpg" alt="birthcontrol" width="696" height="350" /></a></p>
<p><a href="http://projects.fivethirtyeight.com/reddit-ngram/?keyword=burning_man.sxsw.coachella&amp;start=20071015&amp;end=20150831&amp;smoothing=10">How The Internet* Talks</a><br />
<a href="http://projects.fivethirtyeight.com/reddit-ngram/?keyword=burning_man.sxsw.coachella&amp;start=20071015&amp;end=20150831&amp;smoothing=10"><img class="aligncenter size-large wp-image-15293" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/internettalks-1024x664.jpg" alt="internettalks" width="660" height="428" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2015/05/28/upshot/you-draw-it-how-family-income-affects-childrens-college-chances.html" target="_blank">You Draw It: How Family Income Predicts Children’s College Chances</a></p>
<p><a href="http://www.nytimes.com/interactive/2015/05/28/upshot/you-draw-it-how-family-income-affects-childrens-college-chances.html"><img class="aligncenter size-full wp-image-14971" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/08/drawyourline.jpg" alt="drawyourline" width="640" height="426" /></a></p>
<p><a href="http://www.pewresearch.org/fact-tank/2016/01/27/the-demographic-trends-shaping-american-politics-in-2016-and-beyond/sdt-next-america-03-07-2014-0-09-600x582/"><img class="attachment-large size-large" src="http://assets.pewresearch.org/wp-content/uploads/sites/12/2016/01/SDT-next-america-03-07-2014-0-09-600x582.png" alt="The Young/Old Voting Gap, 1972-2012" width="600" height="582" /></a></p>
<p><strong>Pie charts: show relative proportions – or percentages</strong></p>
<p>Pie charts should be used to show relative proportions – or percentages – of information. That’s it. Despite this narrow recommendation for when to use pies, they are made with abandon. As a result, they are the most commonly mis-used chart type.<br />
If you are trying to compare data, leave it to bars or stacked bars. Don’t ask your viewer to translate pie wedges into relevant data or compare one pie to another. Key points from your data will be missed and the viewer has to work too hard.</p>
<p>Examples: percentage of budget spent on different departments, response categories from a survey, breakdown of how Americans spend their leisure time.</p>
<p><a href="http://www.washingtonpost.com/news/wonkblog/wp/2014/01/15/40-charts-that-explain-the-world/" target="_blank">40 charts that explain the world</a></p>
<p><a href="http://www.washingtonpost.com/news/wonkblog/wp/2014/01/15/40-charts-that-explain-the-world/" target="_blank"><img class="aligncenter size-full wp-image-12569" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/religion.jpg" alt="religion" width="308" height="371" /></a><br />
<strong>Area chart: line chart meets pie chart</strong></p>
<p><a href="http://www.nytimes.com/interactive/2015/01/06/upshot/how-nonemployed-americans-spend-their-weekdays-men-vs-women.html" target="_blank">How Non-employed Americans Spend Their Weekdays </a></p>
<p><a href="http://www.nytimes.com/interactive/2015/01/06/upshot/how-nonemployed-americans-spend-their-weekdays-men-vs-women.html" target="_blank"><img class="aligncenter size-full wp-image-12551" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/nonemployed.jpg" alt="nonemployed" width="640" height="354" /></a></p>
<p><a href="http://www.pewresearch.org/fact-tank/2016/01/27/the-demographic-trends-shaping-american-politics-in-2016-and-beyond/ft_16-01-25_nextamerica_1965_20651/"><img class="attachment-large size-large" src="http://assets.pewresearch.org/wp-content/uploads/sites/12/2016/01/FT_16.01.25_NextAmerica_1965_20651.png" alt="The Changing Face of America, 1965-2065" width="420" height="430" /></a></p>
<p><a href="http://money.cnn.com/interactive/economy/diversity-millennials-boomers/">How Diverse is Your Generation?</a><br />
<a href="http://money.cnn.com/interactive/economy/diversity-millennials-boomers/"><img class="aligncenter size-large wp-image-15260" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/boomer-1024x572.jpg" alt="boomer" width="660" height="369" /></a></p>
<p><a href="http://flowingdata.com/2015/09/15/who-earned-a-higher-salary-than-you/" target="_blank">Who Earned a Higher Salary Than You?</a></p>
<p><a href="http://flowingdata.com/2015/09/15/who-earned-a-higher-salary-than-you/" target="_blank"><img class="aligncenter size-full wp-image-13127" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/highersalary.jpg" alt="highersalary" width="640" height="329" /></a></p>
<p><strong><br />
Scatter plot: investigate the relationship between different variables<br />
</strong></p>
<div data-canvas-width="521.985">Examples: Male versus female likelihood of having lung cancer at different ages, technology early adopters’ and laggards’ purchase patterns of smart phones, shipping costs of</div>
<div data-canvas-width="319.443">different product categories to different regions</div>
<p><strong> </strong></p>
<p><a href="http://www.washingtonpost.com/wp-srv/special/national/police-staffing/" target="_blank">WashPost: Where police forces don&#8217;t resemble the community</a><a href="http://www.washingtonpost.com/wp-srv/special/national/police-staffing/" target="_blank"><img class="aligncenter size-full wp-image-12565" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/policeforcecommunity.jpg" alt="policeforcecommunity" width="639" height="374" /></a></p>
<p><strong>Bubble chart: show the concentration of data along two axes<br />
</strong><br />
Bubbles are not their own type of visualization but instead should be viewed as a technique to accentuate data on scatter plots or maps. People are drawn to using bubbles because the varied size of circles provides meaning about the data.</p>
<p><a href="http://www.informationisbeautiful.net/visualizations/snake-oil-supplements/" target="_blank">Snake Oil Supplements?</a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/snake-oil-supplements/" target="_blank"><img class="aligncenter size-full wp-image-12532" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/snakeoilbubble.jpg" alt="snakeoilbubble" width="640" height="349" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2012/05/13/business/student-debt-at-colleges-and-universities.html?ref=multimedia" target="_blank">Student Debt at Colleges and Universities Across the Nation</a></p>
<p><a href="http://www.nytimes.com/interactive/2012/05/13/business/student-debt-at-colleges-and-universities.html?ref=multimedia" target="_blank"><img src="http://christinemckenna.com/interactive/wp-content/uploads/2014/03/debt.jpg" alt="debt" width="640" height="481" /></a></p>
<p>&#8220;The average amount of debt that students have at graduation has increased at a vast majority of colleges and universities in the United States, according to data compiled by an advocacy group, the Institute for College Access and Success. The data on student debt is self-reported by the schools, and many institutions don’t participate. Other figures, like graduation rates, come from the Education Department.&#8221; &#8212; NYTimes</p>
</div>
<p><a href="http://www.nytimes.com/interactive/2016/06/10/upshot/voting-habits.html">The Voting Habits of Americans Like You</a></p>
<p>The electorate is increasingly divided by race, education, gender and generation, and these fissures could grow even wider in the 2016 election. Below, new estimates of turnout and support for more than 8,000 different groups.</p>
<p><a href="http://www.nytimes.com/interactive/2016/06/10/upshot/voting-habits.html"><img class="aligncenter size-full wp-image-14973" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/08/voterslikeyou.jpg" alt="voterslikeyou" width="640" height="348" /></a><br />
<a href="http://www.informationisbeautiful.net/visualizations/the-hollywood-insider/">Hollywood Insider: Movies</a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/the-hollywood-insider/"><img class="aligncenter size-large wp-image-15295" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/hollywood-1024x564.jpg" alt="hollywood" width="660" height="364" /></a><br />
<a href="http://flowingdata.com/2015/12/15/a-day-in-the-life-of-americans/">A Day in the Life of Americans</a><br />
<a href="http://flowingdata.com/2015/12/15/a-day-in-the-life-of-americans/"><img class="aligncenter size-large wp-image-15296" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/daylife-1024x661.jpg" alt="daylife" width="660" height="426" /></a></p>
<div data-canvas-width="571.671">
<p><strong>Histogram chart: understanding the range of your data</strong><br />
Histograms show distributions of variables whereas bar charts compare variables.</p>
<div data-canvas-width="562.4865000000002">Use histograms when you want to see how your data are distributed across groups.</div>
<div data-canvas-width="543.273">Say, for example, that you’ve got 100 pumpkins and you want to know how many</div>
<div data-canvas-width="549.297">
<p>weigh 2 pounds or less, 3-5 pounds, 6-10 pounds, etc.</p>
</div>
<p><a href="http://www.nytimes.com/interactive/2015/02/17/upshot/what-do-people-actually-order-at-chipotle.html?_r=0" target="_blank"><img class="aligncenter size-full wp-image-12566" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/chipotle.jpg" alt="chipotle" width="640" height="353" /></a></p>
<p><strong>Treemap: Showing hierarchical data as a proportion of a whole<br />
</strong></p>
<div data-canvas-width="544.8059999999998">Looking to see your data at a glance and discover how the different pieces relate</div>
<div data-canvas-width="554.4615000000002">to the whole? Then treemaps are for you. These charts use a series of rectangles,</div>
<div data-canvas-width="578.4720000000002">nested within other rectangles, to show hierarchical data as a proportion to the whole.</div>
<p><strong> </strong></p>
<p><a href="http://www.nytimes.com/packages/html/newsgraphics/2011/0119-budget/index.html?hp" target="_blank">Obama Budget</a></p>
<p><a href="http://www.nytimes.com/packages/html/newsgraphics/2011/0119-budget/index.html?hp" target="_blank"><img class="aligncenter size-full wp-image-12548" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/obamabudget1.jpg" alt="obamabudget1" width="640" height="327" /></a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/the-billion-dollar-gram/" target="_blank">Billion Dollar Gram</a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/the-billion-dollar-gram/" target="_blank"><img class="aligncenter size-full wp-image-12534" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/billiondollargramsm.jpg" alt="billiondollargramsm" width="640" height="445" /></a></p>
<p><strong>Heat map: compare data across categories using color<br />
</strong></p>
<p><a href="http://www.nytimes.com/interactive/2012/06/11/sports/basketball/nba-shot-analysis.html?_r=0" target="_blank">Where the Heat and the Thunder Hit Their Shots</a></p>
<p><a href="http://www.nytimes.com/interactive/2012/06/11/sports/basketball/nba-shot-analysis.html?_r=0" target="_blank"><img class="aligncenter size-full wp-image-12535" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/heatmap.jpg" alt="heatmap" width="640" height="407" /></a></p>
<p><strong>Flow Charts: illustrating flow or process<br />
</strong><br />
<a href="http://www.nytimes.com/interactive/2012/11/02/us/politics/paths-to-the-white-house.html" target="_blank">512 Paths to the White House</a><br />
Select a winner in the most competitive states below to see all the paths to victory available for either candidate.</p>
<p><a href="http://www.nytimes.com/interactive/2012/11/02/us/politics/paths-to-the-white-house.html" target="_blank"><img class="aligncenter size-full wp-image-12560" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/obamawin.jpg" alt="obamawin" width="640" height="397" /></a><strong>Data Visualizations<br />
</strong></p>
<p><a href="http://fivethirtyeight.com/features/our-47-weirdest-charts-from-2015/">FiveThirtyEight: 47 Weirdest Visualizations</a></p>
<p><a href="http://fivethirtyeight.com/features/our-47-weirdest-charts-from-2015/"><img class="aligncenter size-large wp-image-15241" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/enten-mccann-datalab-trump1-1024x654.png" alt="enten-mccann-datalab-trump1" width="660" height="422" /></a><a href="http://www.theguardian.com/us-news/ng-interactive/2015/oct/02/mass-shootings-america-gun-violence" target="_blank"><br />
994 mass shootings in 1,004 days: this is what America&#8217;s gun crisis looks like</a></p>
<p><a href="http://www.theguardian.com/us-news/ng-interactive/2015/oct/02/mass-shootings-america-gun-violence" target="_blank"><img class="aligncenter size-full wp-image-13119" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/guardian.jpg" alt="guardian" width="640" height="511" /></a></p>
<p><a href="http://www.slate.com/blogs/the_slatest/2015/10/06/syrian_conflict_relationships_explained.html" target="_blank">Syrian Conflict Explained</a></p>
<p><a href="http://www.slate.com/blogs/the_slatest/2015/10/06/syrian_conflict_relationships_explained.html"><img class="aligncenter size-full wp-image-14414" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/syrian-war-relationships.png" alt="syrian-war-relationships" width="1130" height="712" /></a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/best-in-show-whats-the-top-data-dog/" target="_blank"><img class="aligncenter size-large wp-image-13123" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/10/dogs-1024x718.jpg" alt="dogs" width="660" height="462" /></a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/best-in-show-whats-the-top-data-dog/" target="_blank">The Best in Show &#8211; the ultimate data dog</a><br />
Dog data</p>
<p>&#8220;We examined dogs on intelligence, longevity, genetic ailments and other markers to create a “data-score” and then plotted it against public popularity of various breeds, according to the American Kennel Club.&#8221;</p>
</div>
<p><a href="http://www.informationisbeautiful.net/visualizations/who-old-are-you/" target="_blank">Who Old Are You?</a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/who-old-are-you/"><img class="size-full wp-image-14432 alignnone" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/whooldareu.jpg" alt="whooldareu" width="640" height="499" /></a></p>
<p><a href="http://www.informationisbeautiful.net/visualizations/the-internet-of-things-a-primer/" target="_blank">The Internet of Things</a></p>
<h3><a href="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/internetofthings.jpg"><img class="aligncenter size-full wp-image-14424" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/internetofthings.jpg" alt="internetofthings" width="640" height="504" /></a></h3>
<p>Propublica Workman&#8217;s Compensation</p>
<p><a href="http://projects.propublica.org/graphics/workers-compensation-benefits-by-limb#"><img class="aligncenter size-full wp-image-14422" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/03/limbquiz.jpg" alt="limbquiz" width="640" height="383" /></a>&#8220;If you suffer a permanent injury on the job, you’re typically entitled to compensation for the damage to your body and your future lost wages. But depending on the state, benefits for the same body part can differ dramatically.&#8221;</p>
<p><a href="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/problems-1.jpg"><img class="aligncenter size-full wp-image-15292" src="http://christinemckenna.com/interactive/wp-content/uploads/2016/11/problems-1.jpg" alt="problems" width="343" height="709" /></a></p>
<p><a href="http://www.theguardian.com/world/interactive/2012/may/08/gay-rights-united-states" target="_blank">Gay rights in the US, state by state</a><br />
<a href="http://www.theguardian.com/world/interactive/2012/may/08/gay-rights-united-states" target="_blank"><img src="http://christinemckenna.com/interactive/wp-content/uploads/2015/08/gayrights.jpg" alt="gayrights" width="640" height="406" /></a></p>
<p>&#8220;Gay rights laws in America have evolved to allow — but in some cases ban — rights for gay, lesbian and transgender people on a range of issues, including marriage, hospital visitation, adoption, housing, employment and school bullying. The handling of gay rights issues vary by state and follow trends by region.&#8221; &#8212; Guardian</p>
<p><strong>WaPo: Top Secret America</strong><br />
<a href="http://projects.washingtonpost.com/top-secret-america/network/#/overall/most-activity/" target="_blank"><img src="http://christinemckenna.com/newsdesign/wp-content/uploads/2011/01/topsecretus.gif" alt="" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2011/11/09/us/ows-grid.html" target="_blank">Public opinion of OWS</a></p>
<p><a href="http://www.nytimes.com/interactive/2011/11/09/us/ows-grid.html" target="_blank"><img src="http://christinemckenna.com/newsdesign/wp-content/uploads/2011/11/Picture-21.png" alt="" width="640" height="500" /></a></p>
<p><a href="http://www.nytimes.com/interactive/2010/02/26/sports/olympics/20100226-olysymphony.html" target="_blank">Fractions of a Second: An Olympic Musical</a><br />
At the Olympics, the blink of an eye can be all that separates the gold medalist from the 10th-place finisher. In some events, this is obvious. But in others, with athletes racing one by one, the closeness of the race is harder to perceive.</p>
<p><a href="http://www.nytimes.com/interactive/2010/02/26/sports/olympics/20100226-olysymphony.html" target="_blank"><img title="alpine" src="http://christinemckenna.com/newsdesign/wp-content/uploads/2012/08/alpine.jpg" alt="" width="640" height="225" /></a></p>
<div data-canvas-width="571.671">
<h4>D. Elements of a Chart</h4>
<p><a href="http://lamivo.com/tipsheets/anatomy_chart.pdf" target="_blank"><img class="aligncenter size-full wp-image-12537" src="http://christinemckenna.com/interactive/wp-content/uploads/2015/09/anatomy.jpg" alt="anatomy" width="522" height="477" /></a></p>
<p><strong>Resources:</strong><br />
<a href="http://www.informationisbeautiful.net/data/">Information is Beautiful</a><br />
<a href="http://www.thefunctionalart.com/" target="_blank">The Functional Art<br />
</a><a href="http://thedailyviz.com/">The Daily Viz</a><br />
<a href="http://kpq.github.io/chartsnthings//">chartsnthings</a><br />
<a href="http://infographicsnews.blogspot.com/">Infographics news</a><br />
<a href="http://flowingdata.com/">Flowing Data</a><br />
<a href="http://www.amazon.com/Visualize-This-FlowingData-Visualization-Statistics/dp/0470944889?tag=donations09-20" target="_blank">Visualize This: The FlowingData Guide to Design, Visualization, and Statistics<br />
</a><a href="http://www.amazon.com/Street-Journal-Guide-Information-Graphics/dp/0393072959?tag=donations09-20" target="_blank">The Wall Street Journal Guide to Information Graphics: The Dos and Don&#8217;ts of Presenting Data, Facts, and Figures<br />
</a><a href="http://schoolofdata.org/handbook/courses/sort-and-filter/" target="_blank">Google Spreadsheets</a><br />
<a href="http://schoolofdata.org/handbook/courses/the-math-you-need-to-start/" target="_blank">Basic math</a><br />
<a href="http://schoolofdata.org/handbook/courses/gentle-introduction-exploring-and-understanding-data/" target="_blank">Pivot table lesson</a></p>
</div>
]]></content:encoded>
			<wfw:commentRss>http://christinemckenna.com/multimedia/?feed=rss2&#038;p=18319</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
