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.

[Poverty Hot Spots Guide]
[Poverty Hot Spots E-Tutorial (mp4)]
[Poverty Hot Spots E-Tutorial (YouTube)]

PDQ-Explore example:
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.

[PDQ Age 60+ E-Tutorial (mp4)]
[Age 60+ E-Tutorial (YouTube)]

Posted by lisan at 08:45 AM | Comments (0) | TrackBack

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

Posted by lisan at 08:44 AM | Comments (0) | TrackBack

PDQ Explore Exercises: Poverty Focus

PDQ-Explore Exercises

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
IPUMS-USA website

Guide to Variables
Selected variables from IPUMS with PUMS, ACS, and CPS equivalent names

Register to use IPUMS

(required for making an extract)

Instructions for using the IPUMS Data Extraction System

Instructions for opening data on PC

Making an Extract of the ACS 3-year data from IPUMS
[ppt] [pdf]

(not zipped)

SAS program
Stata program SPSS program

FAQ on 3-year ACS data

Note about income items in 3-year data

Posted by lisan at 08:41 AM | Comments (0) | TrackBack

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.

Posted by lisan at 08:28 AM | Comments (0) | TrackBack

American FactFinder: Examples and Exercises

American FactFinder Exercises
[Summary data]
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]

Posted by lisan at 08:27 AM | Comments (0) | TrackBack