tag:blogger.com,1999:blog-8709043686400122912024-02-20T06:44:34.356-08:00Census 2010 Boot Camp for JournalistsElliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-870904368640012291.post-83757186907373839892014-01-28T10:48:00.004-08:002014-01-28T11:49:08.550-08:00Links<a href="http://www.census.gov/">The Census Bureau</a><br />
<a href="http://www.census.gov/main/www/feeds.html">RSS Feeds from the Census Bureau</a><br />
<a href="http://censusprojectblog.org/">The Census Project Blog</a><br />
<a href="http://censusscope.org/">CensusScope</a><br />
<br />Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-36055162330188222782012-10-11T10:38:00.000-07:002014-01-28T10:38:50.680-08:00DropBox<h3 id="a065464" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
DropBox: Age x Sex for Zip Codes</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Here's the <a href="http://www.psc.isr.umich.edu/dis/census/DEC_10_SF1_QTP2.zip" style="color: #8fabbe;">file</a>.</div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-83858000002346079572010-12-16T10:44:00.000-08:002014-01-28T11:40:33.999-08:00Refresher<h3 id="a059533" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
E-Tutorials</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The following are two video tutorials that illustrate use of some of the tools that we covered in the McCormick workshop. The audio on these may be dicey so they will likely be replaced.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>American FactFinder Example:</strong><br />
This example walks a user through selecting a Geographic Comparison Table; downloading the data; and opening it up in Excel. If you know how to download/open in Excel, just stop watching at that point.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
[<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Exercise1_MeasuringPoverty.pdf" style="color: #8fabbe;">Poverty Hot Spots Guide</a>]<br />
[<a href="http://www.psc.isr.umich.edu/dis/census/webinars/web1/PovertyHotSpots.mp4" style="color: #8fabbe;">Poverty Hot Spots E-Tutorial (mp4)</a>]<br />
[<a href="http://www.youtube.com/watch?v=Fi2XP4dw93w" style="color: #8fabbe;">Poverty Hot Spots E-Tutorial (YouTube)</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>PDQ-Explore example: </strong><br />
This example illustrates a query that is not available in American FactFinder; how to produce the query in PDQ-Explore; with some digressions about PUMA definitions and weighting.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
[<a href="http://www.psc.isr.umich.edu/dis/census/webinars/web1/PDQ60.mp4" style="color: #8fabbe;">PDQ Age 60+ E-Tutorial (mp4)</a>]<br />
[<a href="http://www.youtube.com/watch?v=Gpz4KPkFAPIPDQ" style="color: #8fabbe;">Age 60+ E-Tutorial (YouTube)</a>]</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/e-tutorials.html" style="color: #8fabbe;">08:45 AM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/e-tutorials.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/e-tutorials.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a059530" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Another "Introduction to the Census"</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
This was a presentation by Farley and Neidert for an ICPSR webinar on censuses around the world. The USA presentation occurs at about the 45 minute mark. You can choose to watch it or just snag the slides.<br />
<br />
[<a href="http://www.icpsr.umich.edu/files/ICPSR/datafair/CensusSlides_USA.pptx" style="color: #8fabbe;">ppt</a>]<br />
[<a href="http://www.icpsr.umich.edu/files/ICPSR/datafair/Census%20Changes%20Around%20the%20World.wmv" style="color: #8fabbe;">Video of session</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Original Source is from <a href="http://www.icpsr.umich.edu/icpsrweb/ICPSR/datafair/program.jsp" style="color: #8fabbe;">ICPSR's Social Science Data Fair</a></div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/another_introdu.html" style="color: #8fabbe;">08:44 AM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/another_introdu.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/another_introdu.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a059532" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
PDQ Explore Exercises: Poverty Focus</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong><em>PDQ-Explore Exercises</em></strong><em><br />[Microdata]</em><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farexamples1.pdf" style="color: #8fabbe;">Using the ACS, 2008</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farexaples2.pdf" style="color: #8fabbe;">Using several years of the ACS</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Health_Insurance_Coverage.pdf" style="color: #8fabbe;">Who has Health Insurance Coverage?</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/DataInTheNews.pdf" style="color: #8fabbe;">Using PDQ-Explore to Examine Newsworthy Issues</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farptr09-1.pdf" style="color: #8fabbe;">Complex Queries Using "Pointer" items</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/CPSExamples.pdf" style="color: #8fabbe;">Using the Current Population Survey</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong><em>Additional PDQ-Explore Examples</em></strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farex2.pdf" style="color: #8fabbe;">Using data from Census 2000</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farex3.pdf" style="color: #8fabbe;">Using ACS and Census data</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/farex4-4.pdf" style="color: #8fabbe;">Looking at change over time</a><br />
<strong><br /><em>Additional Resources for PDQ-Explore</em></strong><br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/CPI.doc" style="color: #8fabbe;">Indexing for Cost of Living</a><br />
<a href="https://ctools.umich.edu/access/content/group/34a72eab-daa4-4d14-80e0-9150727aed6c/Assignments/Selected%20IPUMS%20variables.txt" style="color: #8fabbe;">Variable Names across the Census, CPS, and IPUMS</a><br />
<a href="http://usa.ipums.org/usa/" style="color: #8fabbe;">IPUMS-USA website</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="https://usa.ipums.org/usa/doc.shtml" style="color: #8fabbe;">Guide to Variables</a><br />
Selected variables from IPUMS with PUMS, ACS, and CPS equivalent names<br />
<a href="https://usa.ipums.org/usa-action/menu" style="color: #8fabbe;">Register to use IPUMS</a><br />
(required for making an extract)</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="https://usa.ipums.org/usa/resources/instruct.pdf" style="color: #8fabbe;">Instructions for using the IPUMS Data Extraction System</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://usa.ipums.org/usa/extract_instructions.shtml" style="color: #8fabbe;">Instructions for opening data on PC</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong><em>Making an Extract of the ACS 3-year data from IPUMS</em></strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/IPUMS.ppt" style="color: #8fabbe;">[ppt] </a><a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/IPUMS.pdf" style="color: #8fabbe;">[pdf]</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/IPUMS.pdf" style="color: #8fabbe;"></a><a href="http://www.psc.isr.umich.edu/dis/acs/handouts/usa_00087.dat.gz" style="color: #8fabbe;">Extract</a><br />
(zipped)<br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/ipums_2009.dat" style="color: #8fabbe;">Extract</a><br />
(not zipped)<br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/IPUMS_sas" style="color: #8fabbe;"><br />SAS program</a> <a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/lisan_umich_edu_078.do" style="color: #8fabbe;">Stata program</a> <a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/lisan_umich_edu_078.sps" style="color: #8fabbe;">SPSS program</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://usa.ipums.org/usa/acs_multyr.shtml" style="color: #8fabbe;">FAQ on 3-year ACS data</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://usa.ipums.org/usa/acsincadj.shtml" style="color: #8fabbe;">Note about income items in 3-year data</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_explore_exe.html" style="color: #8fabbe;">08:41 AM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_explore_exe.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_explore_exe.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a059535" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
PDQ Software: Updates</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
This is a newer version of the data (all the 2008 microdata files). We will have the 2009 1-year data available shortly. The 3-year and 5-year data will not be available until 2011.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The following is a link to the PDQ-Explore software that you used during the workshop. You will need to download the zip file to the C:\ drive on your PC.<br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/pdq2009.zip" style="color: #8fabbe;">PDQ-Explore</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
As a reminder of what you need to do to get started, here is the introduction to Using PDQ-Explore, which includes some technical notes.<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/pdq-explore.ppt" style="color: #8fabbe;"><br />Introduction to PDQ-Explore</a><br />
<a href="http://www.psc.isr.umich.edu/dis/acs/dataextraction/UsingPDQ.html" style="color: #8fabbe;"><br />Guides to PDQ Explore</a><br />
There are about 10 guides that describe in quite a bit of detail how to do many of the procedures covered in the class. If you find you need a reminder, check these out. You will need to scroll down the page to see the guides.</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_software_up.html" style="color: #8fabbe;">08:28 AM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_software_up.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2010/12/pdq_software_up.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a059531" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
American FactFinder: Examples and Exercises</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>American FactFinder Exercises</strong><br />
[Summary data]<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/AmericanFactFinder_Intro.pdf" style="color: #8fabbe;">Introduction to American FactFinder</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Exercise1_MeasuringPoverty.pdf" style="text-decoration: underline;">Unusual Poverty HotSpots</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Exercise2_CensusTracts.pdf" style="text-decoration: underline;">Not Ready for Prime Time: zip codes and census tracts</a><a href="https://www.blogger.com/blogger.g?blogID=870904368640012291" style="text-decoration: underline;"><br /></a><a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Excercise3_DownloadLimits.pdf" style="text-decoration: underline;">Not Ready for Prime Time: bulk downloads of zip code data</a><a href="https://www.blogger.com/blogger.g?blogID=870904368640012291" style="text-decoration: underline;"><br /></a><a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/Exercise4_DealingWithDelays.pdf" style="color: #8fabbe;">Dealing with Delays: What to do with a 2011 Release of Zip code data</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.cleveland.com/poverty/plaindealer/index.ssf?/poverty/more/college12.html" style="color: #8fabbe;">"College town 'poverty' exposed: Low-income students help win grant money"</a><br />
Stephen Koff and Bill Sloat | Cleveland Plain Dealer<br />
September 17, 2006</div>
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/IPUMS.pdf" style="color: #8fabbe; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px;"></a><br />
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong><em>Data from the Summary File Exercises</em></strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/npc2010/PDF/poverty.xls" style="color: #8fabbe;">Poverty rates for places</a> [Excel]<br />
<a href="https://ctools.umich.edu/access/content/group/34a72eab-daa4-4d14-80e0-9150727aed6c/Assignments/Vacancy2000_censustracts.xls" style="color: #8fabbe;">Vacancy data for Cleveland census tracts (Census 2000)</a> [Excel]<br />
<a href="https://ctools.umich.edu/access/content/group/34a72eab-daa4-4d14-80e0-9150727aed6c/Assignments/MedianIncome2000_zipcodes.xls" style="color: #8fabbe;">Median Income for zip codes (Census 2000)</a> [Excel]</div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-40798207214795694472009-11-25T10:40:00.000-08:002014-01-28T11:44:45.188-08:00Geography Extras<h3 id="a054050" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Aggregate Data: PUMA to County conversion</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The ACS provides annual data, but the geographic scope of these data is limited because of the 65,000+ population requirement. Less than 900 counties meet this cutpoint. One solution to this is to produce a PUMA-based query and then use a crosswalk to map PUMAs to counties.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>PUMA to County Widget [PDQ-Explore output]</strong><br />
This widget takes output from PDQ-Explore and converts PUMA-based characteristics to county-based characteristics</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/data/resource/detail/1527" style="color: #8fabbe;">Link</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>PUMA to County Widget [American FactFinder output]</strong><br />
This widget takes output from American FactFinder and converts PUMA-based characteristics to county-based characteristics</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/data/resource/detail/1528" style="color: #8fabbe;">Link</a></div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/11/aggregate_data.html" style="color: #8fabbe;">05:16 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/11/aggregate_data.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/11/aggregate_data.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h2 style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
November 24, 2009</h2>
<h3 id="a054037" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Creating County Level Statistics from Microdata Files</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Normally one would use tabular data to produce county-level statistics. However, sometimes the measure one wants is not available in tabular data and/or the county is not populous enough for county-based measures, e.g., ACS population limits.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The following document describes how one can produce county level data from PUMAs:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/gis/Creating%20county%20level%20statistics%20from%20microdata%20files.pdf" style="color: #8fabbe;">Creating County Level Statistics from Microdata Files</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Here are the links to the executable program, the crosswalk, and instructions:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/gis/p2c.exe" style="color: #8fabbe;">Program</a> [p2c.exe]<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/gis/p2c.equ" style="color: #8fabbe;">Crosswalk</a> [p2c.equ]<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/gis/p2c.pdf" style="color: #8fabbe;">Guide to p2c</a> [p2c.pdf]</div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-89147175352822029432009-10-26T10:33:00.000-07:002014-01-28T11:44:55.854-08:00Class Assignments<h3 id="a053449" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Class Blog</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Participants will make a blog entry as part of this workshop. If preferred, this can be done as a joint project among several participants. To gain access to the blog, please send a message to Lee Ridley <a href="mailto:ljridley@umich.edu" style="color: #8fabbe;"></a>(ljridley@umich.edu).<br />
<br />
Instructions for making an entry into the blog are below:<br />
<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/BloggerHowTo.pdf" style="color: #8fabbe;">Writing in Blogger</a></div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/class_blog.html" style="color: #8fabbe;">08:15 AM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/class_blog.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/class_blog.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h2 style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
October 24, 2009</h2>
<h3 id="a053461" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
American FactFinder Exercises</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Choose the exercises below that interest you - either by topic or by the geography they cover:<br />
<br />
<strong>Exercises</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Measuring%20poverty.pdf" style="color: #8fabbe;">Measuring Poverty: Which cities have the highest poverty rates in 2008?</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/ACS%20Data%20Quality.pdf" style="color: #8fabbe;">Warning: ACS Data Quality</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Not%20ready%20for%20prime%20time_tracts.pdf" style="color: #8fabbe;">Census Tracts: Using data from the 2000 census to examine vacancy in the Cleveland metro area</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Download%20limits_zipcodes.pdf" style="color: #8fabbe;">Bulk downloads of zip code data to examine racial differences in median income in the United States</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Signifianceof1yeareconchangeACS.pdf" style="color: #8fabbe;">Testing Significance of Economic Change in a State or Metropolitan Area</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Testing1yearchangedownload.pdf" style="color: #8fabbe;">Downloading Data for all Places in a State to Look at Economic Change</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Extras</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Excel%20Tip%20Sheet.pdf" style="color: #8fabbe;">Excel Tip Sheet</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.cleveland.com/poverty/plaindealer/index.ssf?/poverty/more/college12.html" style="color: #8fabbe;">"College town 'poverty' exposed"</a><br />
Stephen Koff and Bill Sloat | Cleveland Plain Dealer<br />
September 17, 2006<br />
<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Looking%20at%20Poverty%20with%20ACS2007.pdf" style="color: #8fabbe;">Looking at Poverty with ACS Summary Data</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Exercises from a Quantitative Reasoning Class</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Looking%20at%20Current%20Events%20circa%202005.pdf" style="color: #8fabbe;">Looking at Current Events</a> (circa 2005)<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Guide%20to%20Looking%20at%20Current%20Events%20Exercise.pdf" style="color: #8fabbe;">Guide to Looking at Current Events</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Data%20Consultant%20circa%202007.pdf" style="color: #8fabbe;">Data Consultant</a> (circa 2007)<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Guide%20to%20Data%20Consultant%20Exercise.pdf" style="color: #8fabbe;">Guide to Data Consultant</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/A03_Iraq%20War%20Deaths.xls" style="color: #8fabbe;">Excel file</a> [A03 Iraq War Deaths.xls]</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_factfi.html" style="color: #8fabbe;">02:00 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_factfi.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_factfi.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h2 style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
October 20, 2009</h2>
<h3 id="a053851" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
PDQ Exercises</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/farexampl.pdf" style="color: #8fabbe;">Six Examples presented by Ren Farley</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PDQ.pdf" style="color: #8fabbe;"></a><a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PDQ.pdf" style="color: #8fabbe;">PDQ Examples from the Seeded Scenarios</a></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-76454594538351084582009-10-26T10:31:00.000-07:002014-01-28T11:45:11.513-08:00Agenda and Participants<h3 id="a053469" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/AgendaOct26.pdf" style="color: #8fabbe; font-size: x-small; line-height: 15px;">Workshop Agenda</a></h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Most of the presentations and handouts are available electronically. Look for links to these under <a href="http://psc2010bootcamp.blogspot.com/2014/01/class-presentations-and-handouts.html" style="color: #8fabbe;">Class Presentations and Handouts</a>.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PARTICIPANTS.pdf" style="color: #8fabbe;">Workshop participants</a><br />
This includes the contact information for the participants as well as the instructors. Send corrections to <a href="mailto:lisan@umich.edu" style="color: #8fabbe;">lisan@umich.edu</a>.</div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-9884975686832652672009-10-23T10:41:00.000-07:002014-01-28T10:42:05.457-08:00PDQ Explore<h3 id="a053458" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Using PDQ Explore</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
PDQ Explore is software that allows users to create and analyze queries across millions of records in seconds, and quickly refine and adjust those queries interactively.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Getting Started with PDQ</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Explore.pdf" style="color: #8fabbe;">Using PDQ Software</a> <em>Technical requirements, installation and a few example queries</em><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/readme.pdf" style="color: #8fabbe;">PDQ-Explore installation (readme file)</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdqhelp.pdf" style="color: #8fabbe;">PDQ Help</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>PDQ Software</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq/PDQ.zip" style="color: #8fabbe;">Zip file</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Note: The contents of the zip file should be put in C:\Program Files\pdq</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq" style="color: #8fabbe;">Directory link</a> (download specific files):<br />
explore.exe, EXPLORE.INI, ipacs08.pdqCodebook, and ipacs08.pdqCustomItems</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
These files should be downloaded to c:\Program Files\pdq. Direct links to these files are below:<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq/explore.exe" style="color: #8fabbe;">explore.exe</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq/EXPLORE.INI" style="color: #8fabbe;">EXPLORE.INI</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq/ipacs08.pdqCodebook" style="color: #8fabbe;">ipacs08.pdqCodebook </a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdq/ipacs08.pdqCustomItems" style="color: #8fabbe;">ipacs08.pdqCustomItems</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>PDQ Explore Guides</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note01.pdf" style="color: #8fabbe;">Basic Query Window</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note02.pdf" style="color: #8fabbe;">Saving and Exporting Your Work</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note03.pdf" style="color: #8fabbe;">Displaying Your Results in the Expert Query Window</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note04.pdf" style="color: #8fabbe;">Universe Selection: Using Comparison Operators</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note05.pdf" style="color: #8fabbe;">Cross-Tabulations: One- Two- or Three-Way Tables</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note06.pdf" style="color: #8fabbe;">Summary Statistics: Means, Standard Deviations and Ranges</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note07.pdf" style="color: #8fabbe;">Quantiles and Medians</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note08.pdf" style="color: #8fabbe;">Simple Recoding Using Arithmetic Operators</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note09.pdf" style="color: #8fabbe;">Weighted Data</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note010.pdf" style="color: #8fabbe;">Recoding with Custom Item Window</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note011.pdf" style="color: #8fabbe;">Obtaining Correlations</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Note012.pdf" style="color: #8fabbe;">Extracting Data for Statistical Analysis</a></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-1684439708468167732009-10-20T10:45:00.000-07:002014-01-28T11:45:26.536-08:00Seeded Scenarios<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The purpose of these examples is to show one how to use Census and/or ACS data to describe characteristics of communities or populations, broad demographic changes relevant for the nation or a community, and the consequences of political power and federal funds.<br />
<br />
Click on one of the topics below for an introduction to the topic, background/reference articles, links to ready-made tables/figure/maps, and introductory shells for independent analysis of the issues:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Census Logistics</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/seeded_apportionmentx.pdf" style="color: #8fabbe;">Apportionment</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Operations.pdf" style="color: #8fabbe;">Census 2010 Operations, Planning, and Challenges</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Outreach.pdf" style="color: #8fabbe;">Outreach</a><br />
<br />
<strong>Demographic Change</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PopGrowth.pdf" style="color: #8fabbe;">Population Growth/Loss</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Boomerang.pdf" style="color: #8fabbe;">Boomerang Kids</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/LFScenario.pdf" style="color: #8fabbe;">Labor Force change</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Family.pdf" style="color: #8fabbe;">Family and Household Structure</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Cohabitation.pdf" style="color: #8fabbe;">Same-Sex Couples/Cohabitation </a><br />
<br />
<strong>Population Profiles</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Immigrants.pdf" style="color: #8fabbe;">Immigrants</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_Race.pdf" style="color: #8fabbe;">Race</a></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-41817577040793240872009-10-20T10:35:00.000-07:002014-01-28T11:45:38.495-08:00Class Presentations and Handouts<h3 id="a053411" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Workshop Presentations: Wednesday</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Below are links to the lectures presented at the workshop. On occasion, there were handouts associated with a presentation. These are listed under the presentation.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Major Demographic Trends and the Use of Census Data by the American Media</strong><br />
<em>Bill Frey, University of Michigan and The Brookings Institution</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Bill_bootcamp_slides.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Bill_bootcamp_slides.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>What Makes a Good Story?</strong><br />
<em>Paul Overberg, USA Today</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>The History of the American Census and Controversies about Recent Enumerations</strong><br />
<em>Ren Farley, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/CensusHistpowerpointOct.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/CensusHistpowerpointOct.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Additional Resources:<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Census_Bibliography.pdf" style="color: #8fabbe;">Annotated Bibliography of Books and Reports Pertaining to the Decennial Census</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/SupremeCourt.pdf" style="color: #8fabbe;">Supreme Court Cases Relevant to the Census</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/20090917-crs-census-memo.pdf" style="color: #8fabbe;">Analysis of Whether Unauthorized Aliens Must be Included in the Census (Congressional Research Service)</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Making_Sausage.pdf" style="color: #8fabbe;">Congressional Efforts to Control the Census and the Census Bureau</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>The American Community Survey: A Comprehensive Source of Information about Social, Economic, and Demographic Change</strong><br />
<em>Lisa Neidert, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/ACS%20Overview.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/ACS%20Overview.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Additional Resources:<br />
<a href="http://www.census.gov/acs/www/Downloads/handbooks/ACSMediaHandbook.pdf" style="color: #8fabbe;">ACS Compass Product: What the Media Needs to Know</a><br />
<a href="http://www.census.gov/acs/www/UseData/Compass/handbook_def.html" style="color: #8fabbe;">Link to all the ACS Compass Products</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Making Sense of Census Geography</strong><br />
<em>Lisa Neidert, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/UnderstandingGeo_Oct2009.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/UnderstandingGeo_Oct2009.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Additional Resources:<br />
<a href="http://www.psc.isr.umich.edu/dis/census/freybrookings.pdf" style="color: #8fabbe;">Tracking Metropolitan America into the 21st Century: A Field Guide to the New Metropolitan and Micropolitan Definitions</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Guide_to_Census.pdf" style="color: #8fabbe;">A Guide to State and Local Census Geography</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Using CensusScope to Understand the Changing Landscape in the United States</strong><br />
<em>Bill Frey and J.P. Dewitt, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/censusscope_bootcamp_presentation-28OCT2009.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/censusscope_bootcamp_presentation-28OCT2009.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Introduction to American FactFinder</strong><br />
<em>J.P. DeWitt and Lisa Neidert, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/factfinder_bootcamp_presentation2.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/factfinder_bootcamp_presentation2.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Additional Resources:<br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/ACS_Data_Products_LJN.ppt" style="color: #8fabbe;">An Introduction to Summary Products (and American FactFinder)</a><br />
[shortened version of a Census Bureau presentation]<br />
<a href="http://www.psc.isr.umich.edu/dis/acs/handouts/ACS_DataProd_LJN.pdf" style="color: #8fabbe;">Presentation Notes</a><br />
[shortened version of a Census Bureau presentation]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Accessing and Working with 2008 American Community Survey (ACS) Data</strong><br />
<em>Cynthia Davis Hollingsworth, Census Bureau</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Census_2010_ACS.wmv" style="color: #8fabbe;">wmv</a>] [<em>presented at the ICPSR OR annual meetings</em>]</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen.html" style="color: #8fabbe;">02:04 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h2 style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
October 12, 2009</h2>
<h3 id="a053459" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Workshop Presentations: Thursday</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Below are links to the lectures presented at the workshop. On occasion, there were handouts associated with a presentation. These are listed under the presentation.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Hands-on exercises with American FactFinder and CensusScope</strong><br />
<strong>Exercises</strong><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Measuring%20poverty.pdf" style="color: #8fabbe;">Measuring Poverty: Which cities have the highest poverty rates in 2008?</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/ACS%20Data%20Quality.pdf" style="color: #8fabbe;">Warning: ACS Data Quality</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Not%20ready%20for%20prime%20time_tracts.pdf" style="color: #8fabbe;">Census Tracts: Using data from the 2000 census to examine vacancy in the Cleveland metro area</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Download%20limits_zipcodes.pdf" style="color: #8fabbe;">Bulk downloads of zip code data to examine racial differences in median income in the United States</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Signifianceof1yeareconchangeACS.pdf" style="color: #8fabbe;">Testing Significance of Economic Change in a State or Metropolitan Area</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Testing1yearchangedownload.pdf" style="color: #8fabbe;">Downloading Data for all Places in a State to Look at Economic Change</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong><a href="http://www.psc.isr.umich.edu/dis/workshop/references/Lowenthal.pdf" style="color: #8fabbe;">Census Outreach - Complete Count Issues</a></strong><br />
<em>Terri Ann Lowenthal, Census Project and Funders Census Initiative</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Using PDQ Software and the Integrated Public Use Microdata<br />Series (IPUMS)</strong><br />
<em>Albert Anderson, Public Data Queries and Ren Farley, University of Michigan</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Explore.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/PDQ_Explore.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Additional Resources<br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/readme.pdf" style="color: #8fabbe;">PDQ-Explore installation (readme file)</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/farexampl.pdf" style="color: #8fabbe;">Six Examples presented by Ren Farley</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PDQ.pdf" style="color: #8fabbe;"></a><a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PDQ.pdf" style="color: #8fabbe;">PDQ Examples from the Seeded Scenarios</a><br />
<a href="http://www.psc.isr.umich.edu/dis/workshop/references/pdqhelp.pdf" style="color: #8fabbe;">PDQ Help</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Hands-on exercises using microdata (with PDQ and IPUMS)</strong><br />
Please find examples to try/expand in the <a href="http://www.psc.isr.umich.edu/dis/workshop/references/farexampl.pdf" style="color: #8fabbe;">Six Examples</a> document or the <a href="http://www.psc.isr.umich.edu/dis/workshop/references/Seeded_PDQ.pdf" style="color: #8fabbe;">PDQ Examples from the Seeded Scenarios</a>.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Informal Question and Answer Session: Data collection strategies in the ACS and the decennial census</strong><br />
<em>Mick Couper, University of Michigan</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Project work</strong><br />
<em>[users choose which room to work in; may shift back and forth]</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Aggregate Data: Room 150A</strong><br />
<em>American FactFinder and CensusScope<br />Helpers: DeWitt, Frey, Neidert, Somerman</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Microdata: Room 150B</strong><br />
<em>PDQ Explore; IPUMS-Census/ACS and IPUMS-CPS<br />Helpers: Anderson, Briske, and Farley</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Paul Overberg will be available for consultation across rooms</strong></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Adjourn</strong><br />
<em>Participants who wish to do so, may continue to work in the labs. Staff will be available to assist you.</em></div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen_1.html" style="color: #8fabbe;">03:58 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen_1.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/workshop_presen_1.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h2 style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
October 08, 2009</h2>
<h3 id="a053475" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Workshop Presentations: Friday</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Below are links to the lectures presented at the workshop. On occasion, there were handouts associated with a presentation. These are listed under the presentation.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Congressional Apportionment</strong><br />
<em>Lisa Neidert, University of Michigan<br />[hands-on exercise with Census Estimates data and web tool]</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>The Changing Demographics of the Nation as We Look Forward<br />to the 2010 Census</strong><br />
<em>Barbara Bryant, Research Scientist Emerita<br />Ross School of Business, University of Michigan<br />Director, 1990 Census, Bureau of the Census</em><br />
[<a href="http://www.psc.isr.umich.edu/dis/workshop/references/BryantB.ppt" style="color: #8fabbe;">ppt</a>] [<a href="http://www.psc.isr.umich.edu/dis/workshop/references/BryantB.pdf" style="color: #8fabbe;">pdf</a>]</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Ten things you should know about the Census <em>Robert Groves, Director, Bureau of the Census</em></strong></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Story Board: Describe blog entry</strong><br />
<em>Participants</em></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Working Lunch</strong><br />
Speakers:<br />
<em>Paul Overberg, USA Today<br />Bill Frey, University of Michigan and Brookings</em></div>
<strong style="color: #336600; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 22.399999618530273px;"></strong><br />
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; font-weight: normal; line-height: 15px; margin-bottom: 10px; text-align: left;">
<strong>Project work</strong><br />
<em>Participants will work with staff on their own projects. These can be<br />based on the Seeded Scenarios or an independent project. Tools can<br />include:<br />o Apportionment Tool<br />o CensusScope-based story<br />o Stories based on Census 2000 or ACS data drawn from American<br />FactFinder<br />o Analyzing census, ACS, or CPS data using PDQ</em></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-61972800426523200012009-10-13T10:45:00.000-07:002014-01-28T11:45:44.468-08:00Segregation Indices<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Researcher/University-based Resources:<br />
<a href="http://www.censusscope.org/segregation.html" style="color: #8fabbe;">CensusScope: Segregation Indices</a><br />
<a href="http://mumford.albany.edu/census/data.html" style="color: #8fabbe;">Lewis Mumford Center</a><br />
<a href="http://web.archive.org/web/20080501114304/http://trinity.aas.duke.edu/~jvigdor/segregation/" style="color: #8fabbe;">Segregation Dataset: 1890-2000(Cutler, Glaeser,and Vigdor)</a> (Note: The original site is no longer maintained by Duke University; this is an archive of the site - with the data still available - collected in 2008 by the <a href="http://www.archive.org/web/web.php" style="color: #8fabbe;">Internet Archive</a>.)<br />
<a href="http://enceladus.isr.umich.edu/race/racestart.asp" style="color: #8fabbe;">Racial Residential Segregation Indices for Counties and Metropolitan Areas: Census 2000</a></div>
<br />
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15px; margin-bottom: 10px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Resources from the Census Bureau (1980-2000):<br />
<a href="http://www.census.gov/hhes/www/housing/housing_patterns/gettable_msa.html" style="color: #8fabbe; text-decoration: underline;">Segregation Index Table Maker</a><br />
<a href="http://www.census.gov/hhes/www/housing/housing_patterns/papertoc.html" style="color: #8fabbe; text-decoration: underline;">Racial and Ethnic Residential Segregation in the United States</a><br />
<a href="http://www.census.gov/hhes/www/housing/resseg/pdf/censr-3.pdf" style="color: #8fabbe; text-decoration: underline;">Racial and Ethnic Segregation in the United States: 1980-2000 (Census Bureau) [pdf]</a></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0tag:blogger.com,1999:blog-870904368640012291.post-48497532227784382612009-10-13T10:42:00.000-07:002014-01-28T11:45:53.507-08:00Questionnaires<h3 id="a053283" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Justification for Questions included in the Census and ACS</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<strong>Submission of Subjects for the 2010 Decennial Census Program</strong><br />
Section 141 (f) of the Census Act requires that not later than 3 years before the next census, the subjects to be included on that census be submitted to Congress. The contents of this notebook [link below] describe the subjects that will be asked on the 2010 Census and the American Community Survey, including proposed new subjects, as well as the subject that will be dropped because it is no longer required by federal agencies.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The Census Act also requires that not later than two years before the Census date, the questions to be included in the next census be submitted to Congress. A document that meets that requirement for the 2010 Decennial Census will be submitted to Congress by <em>March 31, 2008</em>.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
In advance of providing the subjects to be included on the next census to Congress, the U.S. Census Bureau asked federal agencies to provide information on their data needs, so that only necessary data are collected, as opposed to data that could be acquired by other means. The Office of Management and Budget facilitates the process to validate current uses of census data, determine unnecessary subjects and questions, and identify new subjects for which questions are required.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.census.gov/acs/www/Downloads/operations_admin/Final_2010_Census_and_American_Community_Survey_Subjects_Notebook.pdf" style="color: #8fabbe;">Subjects Planned for the 2010 Census and the American Community Survey: Federal Legislative and Program Uses</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.census.gov/acs/www/about_the_survey/questions_and_why_we_ask/" style="color: #8fabbe;">Question by Question Fact Sheets</a><br />
Information on the origin of each question, how long the question has been in use, a description of how the federal government uses the data and how those uses translate into community benefits.</div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/justification_f.html" style="color: #8fabbe;">03:34 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/justification_f.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/justification_f.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a053281" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
American Community Survey (ACS) Questionnaires</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Here are links to the 2009 ACS questionnaire - in the field right now:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
English: <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2009/Quest09.pdf" style="color: #8fabbe;">Questionnaire</a> | <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2009/Guide09.pdf" style="color: #8fabbe;">Instruction Guide</a><br />
Spanish: <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2009/Quest09SP.pdf" style="color: #8fabbe;">Questionnaire</a> | <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2009/Guide09SP.pdf" style="color: #8fabbe;">Instruction Guide</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Group Quarters: <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2009/Quest09GQ.pdf" style="color: #8fabbe;">Questionnaire</a> | <a href="http://www.census.gov/acs/www/Downloads/questionnaires/2012/Guide12GQ.pdf" style="color: #8fabbe;">Instruction Guide</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
For links to questionnaires for previous years and/or changes across questionnaires:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.census.gov/acs/www/SBasics/SQuest/SQuest1.htm" style="color: #8fabbe;">http://www.census.gov/acs/www/SBasics/SQuest/SQuest1.htm</a></div>
<div class="posted" style="border-top-color: rgb(153, 153, 153); border-top-style: solid; border-top-width: 1px; color: #999999; font-family: Verdana, Arial, sans-serif; font-size: x-small; margin-bottom: 25px; padding: 3px;">
Posted by lisan at <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_commun.html" style="color: #8fabbe;">03:27 PM</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_commun.html#comments" style="color: #8fabbe;">Comments (0)</a> | <a href="http://mblog.lib.umich.edu/McCormick/archives/2009/10/american_commun.html#trackbacks" style="color: #8fabbe;">TrackBack</a></div>
<h3 id="a053280" style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: small; line-height: 22.399999618530273px; margin: 0px 0px 10px; padding: 0px;">
Census 2010 Questionnaires</h3>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
Here is a link to two versions of the 2010 Census questionnaire:</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.census.gov/2010census/pdf/2010_Questionnaire_Info.pdf" style="color: #8fabbe;">English</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
<a href="http://www.census.gov/2010census/pdf/2010_Bilingual_Questionnaire_Info.pdf" style="color: #8fabbe;">Bilingual (English/Spanish)</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
The bilingual questionnaire will be sent to 13.5 million households. For further information:<br />
<br />
<a href="http://2010.census.gov/partners/materials/inlanguagemaps.php" style="color: #8fabbe;">http://2010.census.gov/partners/materials/inlanguagemaps.php</a></div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
If a respondent calls the telephone questionnaire assistance phone number located on the back of their English form, they may request a questionnaire in Spanish, Chinese (Simplified), Vietnamese, Korean, or Russian.</div>
<div style="color: #666666; font-family: Verdana, Arial, sans-serif; font-size: x-small; line-height: 15px; margin-bottom: 10px;">
There are <strong>Be Counted</strong> forms available in these five non-English languages in local libraries and other public locations across the country. Here are links to sample questionnaires in these additional languages:<br />
<br />
<a href="http://2010.census.gov/partners/pdf/langfiles/Example_Spanish.pdf" style="color: #8fabbe;">Spanish</a><br />
<a href="http://2010.census.gov/partners/pdf/langfiles/Example_Chinese.pdf" style="color: #8fabbe;">Chinese (Simplified)</a><br />
<a href="http://2010.census.gov/partners/pdf/langfiles/Example_Vietnamese.pdf" style="color: #8fabbe;">Vietnamese</a><br />
<a href="http://2010.census.gov/partners/pdf/langfiles/Example_Korean_6pg.pdf" style="color: #8fabbe;">Korean</a><br />
<a href="http://2010.census.gov/partners/pdf/langfiles/Example_Russian_6pg.pdf" style="color: #8fabbe;">Russian</a></div>
Elliot Evanhttp://www.blogger.com/profile/05721817527749316318noreply@blogger.com0