1.3k likes | 1.32k Views
This workshop provides an overview of accessing and analyzing data from social science databases like ICPSR, Field Poll, and Roper. Learn how to locate, download, and analyze data for your research projects.
E N D
Social ScienceData Bases CSU Dominguez Hills April 15, 2011 CSU Dominguez Hills
Sponsored by http://www.ssric.org CSU Dominguez Hills
Presenters John L. Korey, Political Science, Cal Poly Pomona jlkorey@csupomona.edu Eugene J. Turner, Geography, CSU Northridge eugene.turner@csun.edu CSU Dominguez Hills
Workshop Agenda Overview of the SSRIC Data Archives ICPSR Field Census Roper Other Data Other Workshops Your Feedback CSU Dominguez Hills
SSRIChttp://www.ssric.org CSU Dominguez Hills
The Council Oldest CSU affinity group (since 1972) Representatives from CSU campuses meet three times per year Negotiates with data providers for access to data Promotes use of data analysis in research and teaching CSU Dominguez Hills
The Council Annual student research conference April 29, San Jose Statehttp://www.ssric.org/participate/src Sponsors travel to ICPSR summer workshops in Ann Arbor, Michigan http://www.ssric.org/participate/icpsr_summer Field Poll Faculty Fellowship (deadline April 15) http://www.ssric.org/participate/field_institute CSU Dominguez Hills
Social Science Databases The California State University subscribes to social science databases to support teaching research administration Available to campuses by annual subscription CSU Dominguez Hills
Social Science Databases Assistance from the SSRIC Note: SSRIC members are not staff data consultants or technical assistance providers, but we will do what we can to help students, faculty, and staff to access data Campus representativeshttp://www.ssric.org/reps CSU Dominguez Hills
Inter-university Consortium for Political and Social Research (ICPSR) Field Poll Census Data Roper Center for Public Opinion Research Social Science Databases CSU Dominguez Hills
Accessing the data bases On-campus access to data bases is IP authenticated Off-campus access Field: not available Roper: uses library as proxy server -- works just like other library data bases ICPSR: first time, uses library proxy server, after that, you can access from anywhere but you must reauthenticate every 6 months CSU Dominguez Hills
ICPSR http://www.icpsr.org Inter-university Consortium for Political and Social Research CSU Dominguez Hills
ICPSR Primary social science data archive for the U.S. Founded in 1962; CSU joined in 1972 Over 600 member institutions worldwide Services Vast data archive accessible via the web (ICPSR Direct) Summer program Instructional resources CSU Dominguez Hills
ICPSR Teaching CSU Dominguez Hills
ICPSR CSU Dominguez Hills
ICPSR CSU Dominguez Hills
Using ICPSR Direct Locate the study Select the data for download Download the data Import the data for statistical analysis CSU Dominguez Hills
Find and Analyze Data Find data Analyze data online Topical archives CSU Dominguez Hills
Searching for Data • Type in key words • (e.g., gun control) • Click search Search terms are not case sensitive if all lower case CSU Dominguez Hills
Search Results Sort by time period (newest) Click on link CSU Dominguez Hills
Downloading the data View study description Download all files CSU Dominguez Hills
Agree to the Terms of Use CSU Dominguez Hills
Saving the Files CSU Dominguez Hills
Select Files and Place Them Where You Want to Save Them CSU Dominguez Hills
What’s in the File? Look in the layers of subfolders until you find the DS0001 folder It will include the: Codebook (pdf file) Questionnaire (pdf file) SPSS file (in this case, it’s a .sav file) Other files CSU Dominguez Hills
Open the sav File in SPSS CSU Dominguez Hills
Other Types of Files you Might Encounter • SPSS portable (.por) files • Will work on all platforms • Tell SPSS to look for a .por file • Raw data (ASCII) file with SPSS syntax (.sps) file • You’ll have to create your own .sav file • See next slide • Raw data file with only a codebook • You’ll have to create your own syntax file • SPSS Intro workshop discusses how to do this CSU Dominguez Hills
What’s a Syntax File? A syntax file is a set of commands to convert a raw ASCII data file into an SPSS system file ASCII + SPSS syntax file = SPSS system file For More Information: http://www.ssric.org/data/icpsr_direct#syntax CSU Dominguez Hills
Other ICPSR Resources SSRIC ICPSR Guide ICPSR Data Use Tutorial Social Science Variables Database CSU Dominguez Hills
The Field Poll CSU Dominguez Hills
The Field (California) Poll Established in 1947 Independent, non-partisan survey of California public opinion Wide range of political and social topics Multiple polls each year Mervin Field http://www.field.com CSU Dominguez Hills
Accessing Field Data Set up your browser Find polls and data sets Download data sets CSU Dominguez Hills
Setting up your browser Requires setting passive FTP access Can set up browser for folder view or FTP directory view See the instructions for details: http://www.ssric.org/data/field_polls You will only need to do this once for your browser and user account CSU Dominguez Hills
Finding Polls Find the poll number Field Poll Archives (http://field.com/fieldpollonline/subscribers/) American Public Opinion Index Check with your library for printed and/or microfiche versions The CALPOLL window Accessible via UCData You will be using the poll number to select the data set for download. CSU Dominguez Hills
Searching Polls with UCDATA Uses SDA Does not include last couple of years Gives you the frequency distributions of the variables you select CSU Dominguez Hills
UC Datahttp://ucdata.berkeley.edu Click on Field Polls CSU Dominguez Hills
Field Polls on UCDATA Click on search CSU Dominguez Hills
Searching I selected 2000’s CSU Dominguez Hills
Keywords Enter gun control CSU Dominguez Hills
Search Results Click View CSU Dominguez Hills
Results from SDA CSU Dominguez Hills
Downloading the Data Click Download CSU Dominguez Hills
Choosing the File Double click cal0003 since you want to download that folder Note that this is directory view CSU Dominguez Hills
Saving the Files CSU Dominguez Hills
Select the Folder CSU Dominguez Hills
Open the Data in SPSS 2 1 CSU Dominguez Hills
Other Field Resources SSRIC Field Poll Guide Field News Releases and California Opinion Indexes CSU Dominguez Hills
The U. S. Census of Population and Housing CSU Dominguez Hills
U. S. Census Collections Construction Transportation For. Trade Housing Business Governments Agriculture Mineral Indus. Manufacturing Population 1800 1850 1900 1950 1990 1787 – Framers of Constitution – Needed to resolve 2 Issues How to deal with apportionment of power for House How to assess taxes land value, persons? CSU Dominguez Hills
Census of Population and Housing Began in 1790 U. S. marshals went to each household Continuing fight over additional social and housing questions – cost 1960 – Most questions in sample questionnaire, Beginning of mailouts and digital tabulation CSU Dominguez Hills