90 likes | 255 Views
US Census DataFerrett Introduction and Application. Jonathan Jacobs Oregon University System 541.346.5827. What is DataFerrett. Data mining and extraction tool Free, browser based Public use data files (cubed unit record data) Census Decennial Census 1980-2000
E N D
US Census DataFerrettIntroduction and Application Jonathan Jacobs Oregon University System 541.346.5827
What is DataFerrett • Data mining and extraction tool • Free, browser based • Public use data files (cubed unit record data) • Census Decennial Census 1980-2000 • Census American Community Survey 2004-2008 • Oregon population: 3,700,000. • ACS 2006-08 Sample size: 50,684 (1.4%) • Create customizable cross tabs • Any segment of the population • Demographic • Geographic
Using DataFerrett • http://dataferrett.census.gov/ REQUIREMENTS Allow pop-ups Need Java Runtime Security profile (optional)
Applying Data Ferrett • The issue: A priority for your institution is diversity of the student population. • Student body should have representation proportionally equal to the general population • Track progress towards that goal. • Have: Student population by race/ethnicity. • Need: Regional population by race/ethnicity.
Source: Census Generic Filter: Oregon Source: American FactFinder, ACS2006-08 DataFerrett Filter: AGE 18-24 PUMA: 00702 HISP: Hispanic RAC1P: Race Filter: AGE 18-24 HISP: Hispanic RAC1P: Race People reporting as Hispanic are excluded from other race categories. Source: US Census ACS 2006-08
Find Your Census PUMA • http://www.census.gov/geo/www/maps/puma5pct.htm • (or Google: census PUMA)
Live Demonstration Market Share of home region by Gender: What percentage of students in your area attend college? What percentage of those students attend your institution? • ELEMENTS NEEDED: • Data set used: Census ACS 2006-08 • Population filters: • Ages 18-24 • Area: Lane County (PUMA: 00701, 00702) • Population crosstabs • Sex • School enrollment