1 / 76

An Introduction to the Social Science Databases

An Introduction to the Social Science Databases. Workshop Agenda. Overview Data Archives ICPSR Field Roper Survey Documentation and Analysis Teaching Resources Depository Site for Instructional Materials & Information Lunch Individual Questions and Help. Online Workshop Resources.

woods
Download Presentation

An Introduction to the Social Science Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. An Introduction to the Social Science Databases

  2. Workshop Agenda • Overview • Data Archives • ICPSR • Field • Roper • Survey Documentation and Analysis • Teaching Resources Depository • Site for Instructional Materials & Information • Lunch • Individual Questions and Help

  3. Online Workshop Resources • This PowerPoint Presentation • List of URLs Used

  4. SSRICSocial Science Research & Instructional Councilhttp://www.ssric.org

  5. SSRIC • Oldest CSU discipline council • Founded in 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

  6. SSRIC • Sponsors an annual spring student research conference (at CSU EB in 2007, was at CSUN in 2006) • Sponsors travel to ICPSR summer workshops in Ann Arbor, Michigan. See http://www.icpsr.com/training/summer/index.html • Works with Field Research • Allocates question credits to California Field Poll • Selects a faculty fellow

  7. Social Science Databases • The California State University subscribes to a number of social science databases to support • Teaching • Research • Administration • Available to campuses by annual subscription

  8. 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 representatives:http://www.ssric.org/reps

  9. Social Science Data Bases • Inter-university Consortium for Political and Social Research (ICPSR) • Field Poll • Roper Center

  10. Proxy Servers* • On-campus access to data bases is IP authenticated. • For off-campus access to ICPSR and Roper, check with your campus SSRIC representative. If available on your campus, works just like library data bases such as J-Stor or Lexis-Nexis Academic Universe. • At CSULB, go to http://www.csulb.edu/library/eref/eref.html

  11. Survey Documentation and Analysis (SDA) Program • Written at UC Berkeley • Used by ICPSR and others-- referred to as DAS (Data Analysis System) • Data files must be converted to SDA format before use. ICPSR has converted a number of data sets in their topical archives into SDA format and are converting more.

  12. Example: The GSS Using SDA Go to SDA Homepage:http://ucdata.berkeley.edu:7101/new_web/SDA/ and click on “SDA.”

  13. Example: GSS Using SDA • Click on “SDA Archive” • Click on “GSS Cumulative Datafile 1972-2004 – Full Analysis” • Click on “Open Extra Codebook Window” • Click on “Codebook by Year of Interview” • Browse to find variables

  14. Go to SDA Archive

  15. Choose Dataset

  16. Open Codebook Window

  17. Choose Codebook

  18. Find Variables

  19. Start Analysis • Click on “Frequencies or crosstabulation (with charts) • Click on “Start”

  20. Set Up and Run Analysis • Enter selections, and “Run the Table”

  21. Statistical Procedures • Frequencies • Crosstabs • Comparison of means • Correlation matrix • Comparison of correlations • Multiple regression

  22. What Else Can You Do? • Recode (temporarily) • Use control variables • Use filter variables • Use weight variable • Subset and download data

  23. SDA Instructional Resources • At UC Berkeley) • Online Help Files for SDA Users • Some Other Data Archives That Use SDA • An Intro Stats Class Using SDA (Losh, Florida State) • How to Download SDA GSS Data and Import to SPSS (Stipak, Portland State)

  24. Sources of Data for SDA at ICPSR(http://www.icpsr.com) • SETUPS: Voting Behavior — the 2004 Election • Special Topic Archives sponsored by agencies external to ICPSR • Focus on specific subject areas such as aging and crime • Provide information on data that ICPSR holds and other data sets external to ICPSR • Includes data that can be analyzed online using SDA/DAS

  25. National Archive of Computerized Data on Aging (NACDA) • http://www.icpsr.com/NACDA/ • Funded by the National Institute on Aging

  26. National Archive of Criminal Justice Data (NACJD) • http://www.icpsr.com/NACJD/ • Funded by the Bureau of Justice Statistics and the National Institute of Justice

  27. Substance Abuse and Mental Health Data Archive(SAMHDA)* • http://www.icpsr.com/SAMHDA/ • Funded by the Office of Applied Studies, Substance Abuse and Mental Health Administration

  28. ICPSR • Primary social science data archive for the U.S. • Founded in 1962, CSU joined in 1972 • Currently over 500 member institutions worldwide • Services • Vast data archive accessible via web engine (ICPSR Direct) • Summer program • Instructional resources

  29. ICPSRhttp://www.icpsr.com

  30. Using ICPSR Direct • Locate the data you want to download • Click on Data Access & Analysis • Type in the key words, choose other options, and search

  31. Using ICPSR Direct Too many studies?

  32. Using ICPSR Direct • Advanced Search

  33. Using ICPSR Direct • Advanced Search

  34. Selecting the Study to Download • For each study, you will see links to description, downloads, and related literature • Click on “download” • Select the study you want to download

  35. Downloading the Data • You will be asked for your email address and your password • If you don’t have a password, click on “create account” and create one. You will be asked to complete a brief form the first time you use ICPSR Direct • If you forget your password, you can request that a new one be emailed to you

  36. Downloading the Data • Select the files to download under Step 2 by clicking on the box or boxes • Select Step 3. Add to Data Cart • Select Step 4. Review Data Cart

  37. Downloading the Data If all is OK, click on “Download Data Cart” Save

  38. Downloading the Data If using WinZip extract files to a directory

  39. Downloading the Data Find and open file in SPSS.

  40. Downloading the Data Find and open Syntax file in SPSS a little differently. (Note lengthy path)

  41. Syntax Files • ASCII + SPSS syntax file = SPSS system file. • Need to modify “File Handle” and “Save Outfile” commands.

  42. FILE HANDLE Command FILE HANDLE DATA / NAME="data-filename" LRECL=225.   would become: FILE HANDLE DATA / NAME="C:\Temp\5268001\ICPSR_04131\DS0001_ABC_News_Pennsylvania_Poll,_September_2004__\04131-0001-Data.txt " LRECL=225.

  43. SAVE OUTFILE Command SAVE OUTFILE="spss-filename.sav". would become: SAVE OUTFILE= "C:\Temp\5268001\ICPSR_04131\DS0001_ABC_News_Pennsylvania_Poll,_September_2004__\04131-0001-Data.sav".

  44. SPSS Syntax • FILE HANDLE OURDATA / NAME = 'samplespss.data‘ LRECL = 30. • DATA LIST FILE=OURDATA /1 OVERALL 1-2 PRODUCTV 3-4 COOPRATV 5-6 INITIATV 7-8 ABSENTEE 10-12 EMPLOYID 14-18 APTITUDE 20-23 • INIRATNG 25-28 (A). • VAR LABELS OVERALL 'EMPLOYEES OVERALL RATING BY SUPERVISOR' • /PRODUCTV 'EMPLOYEES PRODUCTIVITY RATING' • /COOPRATV 'EMPLOYEES COOPERATIVITY RATING' • /INITIATV 'EMPLOYEES INITIATIVITY RATING' • /ABSENTEE '# DAYS ABSENT FROM WORK' • /APTITUDE 'SCORE ON APTITUDE TEST' • /INIRATNG 'INITIAL RATING BY PERSONNEL DEPT'. • VALUE LABELS OVERALL TO INITIATV 1 'POOR' 2 'FAIR' 3 'GOOD' 4 'VERY GOOD' 5 'EXCELLENT‘. • RECODE PRODUCTV INITIATV (1,2=1) (3=2) (4,5=3). • CROSSTABS TABLES=PRODUCTV BY INITIATV • /STAT=CHISQ. • FINISH.

  45. FOR MORE INFORMATION • http://www.icpsr.umich.edu/help/newuser.html#05 • http://www.ssric.org/data/icpsr_direct#syntax

  46. Other ICPSR Resources • SSRIC ICPSR Guide • ICPSR Data Use Tutorial • Social Science Variables Database • Bibliography of Data-Related Literature • Ilona Einowski's article on ICPSR Direct

  47. YOUR TURN • Download SPSS portable file for ICPSR Study #4242 (2003 Japanese Social Survey) • Open in SPSS

  48. YOUR TURN • Search for datasets on a topic of your choosing • Download after lunch

  49. The Field Poll

More Related