Transcript Slide 1

Social Science
Data Bases
Humboldt State University
May 6, 2011
May 6, 2011
www.ssric.org
1
Sponsors
College of Arts, Humanities and Social Sciences
http://www.humboldt.edu/cahss/
and the
http://www.ssric.org
May 6, 2011
www.ssric.org
2
Presenters
 Stephanie
Burkhalter, Politics,
Humboldt State University
[email protected]
 John L. Korey, Political Science,
Cal Poly Pomona
[email protected]
 Josh Meisel, Sociology,
Humboldt State University
[email protected]
May 6, 2011
www.ssric.org
3
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
May 6, 2011
www.ssric.org
4
The Council
 Annual

student research conference
April 29, San Jose State
http://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_institut
e
May 6, 2011
www.ssric.org
5
SSRIC
http://www.ssric.org
May 6, 2011
www.ssric.org
6
Workshop Agenda
 Overview
 Data



of the SSRIC
Archives
ICPSR
Field
Roper
 Teaching
with Data
 Brainstorming Your Ideas
 Other Data
 Your
May 6, 2011
Feedback
www.ssric.org
7
Social Science Databases
 The
California State University subscribes
to social science databases to support



teaching
research
administration
 Available
to campuses by annual
subscription
May 6, 2011
www.ssric.org
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
May 6, 2011
www.ssric.org
9
Social Science Databases
 Inter-university
Consortium for Political
and Social Research (ICPSR)
 Field
Poll
 Census
Data
 Roper
Center for Public Opinion
Research
May 6, 2011
www.ssric.org
10
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
May 6, 2011
www.ssric.org
11
ICPSR
Inter-university Consortium for
Political and Social Research
http://www.icpsr.org
May 6, 2011
www.ssric.org
12
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
May 6, 2011
www.ssric.org
13
ICPSR
Teaching
May 6, 2011
www.ssric.org
14
ICPSR
May 6, 2011
www.ssric.org
15
ICPSR
May 6, 2011
www.ssric.org
16
Using ICPSR Direct
 Locate
the study
 Select
the data for download
 Download
 Import
May 6, 2011
the data
the data for statistical analysis
www.ssric.org
17
Find and Analyze Data
Find data
Analyze data online
Topical archives
May 6, 2011
www.ssric.org
18
Searching for Data
•Type in key words
(e.g., gun control)
•Click search
Search terms are not
case sensitive if all
lower case
May 6, 2011
www.ssric.org
19
Search Results
Sort by time
period (newest)
Click on link
May 6, 2011
www.ssric.org
20
Downloading the data
View study description
Download all files
May 6, 2011
www.ssric.org
21
Agree to the Terms of Use
May 6, 2011
www.ssric.org
22
Saving the Files
May 6, 2011
www.ssric.org
23
Select Files and Place Them
Where You Want to Save Them
May 6, 2011
www.ssric.org
24
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
May 6, 2011
www.ssric.org
25
Open the sav File in SPSS
May 6, 2011
www.ssric.org
26
Explore ICPSR
May 6, 2011
www.ssric.org
27
The Field Poll
May 6, 2011
www.ssric.org
28
The Field (California) Poll
 Established
in 1947
 Independent,
Mervin Field
non-partisan
survey of California public
opinion
 Wide
range of political and social
topics
http://www.field.com
 Multiple
polls each year
May 6, 2011
www.ssric.org
29
Accessing Field Data
 Set
up your browser
 Find
polls and data sets
 Download
May 6, 2011
data sets
www.ssric.org
30
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
May 6, 2011
www.ssric.org
31
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.
May 6, 2011
www.ssric.org
32
Searching Polls with UCDATA
 Uses
SDA
 Does
not include last couple of years
 Gives
you the frequency distributions of
the variables you select
May 6, 2011
www.ssric.org
33
UC Data
http://ucdata.berkeley.edu
Click on Field Polls
May 6, 2011
www.ssric.org
34
Field Polls on UCDATA
Click on search
May 6, 2011
www.ssric.org
35
Searching
I selected 2000’s
May 6, 2011
www.ssric.org
36
Keywords
Enter gun control
May 6, 2011
www.ssric.org
37
Search Results
Click View
May 6, 2011
www.ssric.org
38
Results from SDA
May 6, 2011
www.ssric.org
39
Downloading the Data
Click Download
May 6, 2011
www.ssric.org
40
Choosing the File
Double click cal0003 since you
want to download that folder
Note that this is
directory view
May 6, 2011
www.ssric.org
41
Saving the Files
May 6, 2011
www.ssric.org
42
Select the Folder
May 6, 2011
www.ssric.org
43
Open the Data in SPSS
2
1
May 6, 2011
www.ssric.org
44
Other Field Resources
 SSRIC
Field Poll Guide
 Field
News Releases and California
Opinion Indexes
May 6, 2011
www.ssric.org
45
Explore Field
May 6, 2011
www.ssric.org
46
10 MINUTE BREAK!
May 6, 2011
www.ssric.org
47
The Roper Center for
Public Opinion Research
May 6, 2011
www.ssric.org
48
http://www.ropercenter.uconn.edu
Roper
Express
iPoll
Roper
Explorer
May 6, 2011
www.ssric.org
49
Searching for Data Sets
Hover over
Quick Links
Then click “Search
for Datasets”
May 6, 2011
www.ssric.org
50
Sign In
May 6, 2011
www.ssric.org
51
Sign In
May 6, 2011
www.ssric.org
52
Searching for Data Sets

Specify
 Keywords
 Date range
 Country
May 6, 2011
www.ssric.org
53
Searching for Data Sets
Enter
Search
Terms
Click on
“Search”
May 6, 2011
www.ssric.org
54
Search Results
Download Data
Examine Questions
Online Analysis
May 6, 2011
www.ssric.org
55
Dataset Abstract
Study
Description
Download
Data
May 6, 2011
www.ssric.org
56
Downloading the Files
Click on
“Download Dataset”
Click on
SPSS portable file
May 6, 2011
www.ssric.org
57
Downloading the Files
May 6, 2011
www.ssric.org
58
What if nothing is available?

Some documentation and/or data sets are not available on-line. If you are
interested in one of these, email the survey number and the title to:
Ed Nelson at [email protected]
May 6, 2011
www.ssric.org
59
View Questions in iPOLL
May 6, 2011
www.ssric.org
60
Get Question Details
May 6, 2011
www.ssric.org
61
Question Details
May 6, 2011
www.ssric.org
62
Online Analysis
May 6, 2011
www.ssric.org
63
Run Analysis
May 6, 2011
www.ssric.org
64
Analysis - Results
May 6, 2011
www.ssric.org
65
More About iPOLL

Data base of over 500,000 questions

Includes frequency distributions allowing students to do
trend analysis online

You will not need a user name or password from oncampus, since the CSU will be IP authenticated. You
will be prompted for your email address
May 6, 2011
www.ssric.org
66
Log in to iPOLL
May 6, 2011
www.ssric.org
67
Searching iPOLL
 Search
 Click
for keyword
on Boolean or Wildcard for help
 Let’s
search for relig% (note: % is the
wildcard)
 Select
 Use
May 6, 2011
the topic of religion
date from 1/1/2000 to today’s date
www.ssric.org
68
Search
May 6, 2011
www.ssric.org
69
Results
May 6, 2011
www.ssric.org
70
Instructional Resources
Click here
Then choose one of
these
May 6, 2011
www.ssric.org
71
Fundamentals of Polling
May 6, 2011
www.ssric.org
72
Analyzing Polls
May 6, 2011
www.ssric.org
73
Teaching Tools
May 6, 2011
www.ssric.org
74
Other Roper Resources
 SSRIC
May 6, 2011
Roper Guide
www.ssric.org
75
Explore Roper
May 6, 2011
www.ssric.org
76
Teaching with Data
Online Resources

Survey Documentation and Analysis (SDA)

Teachingwithdata.org

ICPSR Teaching and Learning Resources
May 6, 2011
www.ssric.org
77
Survey Documentation and Analysis
(SDA)
 Overview
 What
http://sda.berkeley.edu/
is online analysis?
 Available
SDA data sets
 Available
Statistical procedures
 Using
May 6, 2011
SDA
www.ssric.org
78
What is Online Analysis?
 “Online
data analysis" refers to the ability
to perform statistical analysis using special
Web-based software as an alternative to
downloading data into a statistical
package on your computer.
May 6, 2011
www.ssric.org
79
Data sets used in SDA Analysis

From the SDA main page, click on Archive Tab
to see a list of datasets available through
Website, for example:



General Social Survey (GSS) Cumulative Datafile
(1972-2010)
American National Election Survey (ANES)
Cumulative Datafile (1948-2004).
U.S. Census microdata (PUMS)

List of other sources for SDA data sets:
(http://www.csulb.edu/library/eref/datasets.html)
May 6, 2011
www.ssric.org
80
Available Statistical Procedures in SDA
 Frequencies
and cross-tabulation
 Comparison of means
 Correlation matrix
 Comparison of correlations
 Multiple regression
 Logit/Probit regression
May 6, 2011
www.ssric.org
81
Using SDA-Quick Tables
Political party identification by race

Quick Tables have variables pre-set for
illustration purposes

Click on GSS Cumulative Datafile 1972-2010
Quick Tables

Click on Politics and Voting by Background
Variables

Political party will appear in the first box; in the
second box change gender to race
May 6, 2011
www.ssric.org
82
Using SDA-Quick Tables, cont.

Below race, next to “Limit the table to a certain
year or decade” scroll through the drop-down
selection and select 2010

Under “Chart Options” choose Bar Chart

Choose yes by clicking on the box next to “show
percents”

Click on Create the Table
May 6, 2011
www.ssric.org
83
Using SDA: Analysis

Click on GSS 1972-2008 Cumulative Data File

The default page appears for Frequencies/
Crosstabs

Other types of Analysis (e.g. comparison of
means and regression) can be accessed
through the Analysis tab in top left corner
May 6, 2011
www.ssric.org
84
Using SDA: Crosstabs
Does intensity of religious affiliation determine
views of pornography laws?

In the Search box above the list of variables,
enter RELITEN, then click Go
 On the next screen, click on the link for
RELITEN; this will place it in the Selected box on
the main crosstabs page
 Once RELITEN is in the Selected box, click on
View next to that box to read the question
 Below the Selected box on the main page, click
on Col to bring RELITEN to the column box on
righthand analysis section
May 6, 2011
www.ssric.org
85
Using SDA: Crosstabs





Repeat this procedure for the variable
PORNLAW
Since PORNLAW is the dependent variable,
once PORNLAW is in the Selected Box click on
Row
Under Table Options, check Summary statistics
and Question text (Color coding should already
be checked)
Under Chart Options, click on Pie chart in the
drop down menu
Click on Run the Table
May 6, 2011
www.ssric.org
86
May 6, 2011
www.ssric.org
87
May 6, 2011
www.ssric.org
88
Teachingwithdata.org

Overview: www.teachingwithdata.org

NSF-funded project to help instructors increase
quantitative literacy of students in a range of
social science disciplines

Under Data Resources under Tables & Figures
click on Exercises with Data

Return to the main page and search for
resources by discipline or subject.
May 6, 2011
www.ssric.org
89
ICPSR Teaching and Learning
Resources

Log-in to your ICPSR account

Click on Teaching & Learning

Click on link for On-line learning center

At the next screen, click on Browse by Subject

Scroll down and click on partisanship and then
on partisanship again. A “Data-driven learning
guide” should pop up
May 6, 2011
www.ssric.org
90
ICPSR Teaching and Learning
Resources

Return to the main Teaching & Learning page

Scroll down to Web-based Instructional Modules
and choose Voting Behavior in the 2008
Election, then click again on the icon for 2008
election.

This is a complete module on the 2008
American National Election Survey (ANES) with
integrated data analysis exercises using SDA
May 6, 2011
www.ssric.org
91
ICPSR Teaching and Learning
Resources
 Explore
the module by completing
Exercise 1, Part A with your knowledge of
SDA
May 6, 2011
www.ssric.org
92
Other Workshops
May 6, 2011
www.ssric.org
93
Workshops on SPSS
 SPSS



Creating SPSS data file
Transforming data
Descriptive statistics
 SPSS




– introductory workshop
– intermediate workshop
Crosstabulations
Using means
Correlation and regression
Charts
May 6, 2011
www.ssric.org
94
Workshop on Online
Statistical Analysis
 SDA
(Survey Documentation and
Analysis)

Requires no site license

Extremely easy to learn


Excellent for classes where you want to introduce
students to statistical analysis
Tools available – frequencies, crosstabulations,
correlation and regression
May 6, 2011
www.ssric.org
95
Workshop on Data in
the Classroom
 Statistical





literacy – issues and examples
Causality
Experimental and survey design
Unintentional consequences
Sampling and statistical inference
Change over time
 Where
May 6, 2011
do we get the data?
www.ssric.org
96