December 16, 2010
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.
American FactFinder Example:
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.
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.
Another "Introduction to the Census"
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.
[Video of session]
Original Source is from ICPSR's Social Science Data Fair
PDQ Explore Exercises: Poverty Focus
Using the ACS, 2008
Using several years of the ACS
Who has Health Insurance Coverage?
Using PDQ-Explore to Examine Newsworthy Issues
Complex Queries Using "Pointer" items
Using the Current Population Survey
Additional PDQ-Explore Examples
Using data from Census 2000
Using ACS and Census data
Looking at change over time
Additional Resources for PDQ-Explore
Indexing for Cost of Living
Variable Names across the Census, CPS, and IPUMS
PDQ Software: Updates
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.
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.
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.
Introduction to PDQ-Explore
Guides to PDQ Explore
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.
American FactFinder: Examples and Exercises
American FactFinder Exercises
Introduction to American FactFinder
Unusual Poverty HotSpots
Not Ready for Prime Time: zip codes and census tracts
Not Ready for Prime Time: bulk downloads of zip code data
Dealing with Delays: What to do with a 2011 Release of Zip code data
"College town 'poverty' exposed: Low-income students help win grant money"
Stephen Koff and Bill Sloat | Cleveland Plain Dealer
September 17, 2006
Data from the Summary File Exercises
Poverty rates for places [Excel]
Vacancy data for Cleveland census tracts (Census 2000) [Excel]
Median Income for zip codes (Census 2000) [Excel]