OO Serves the People Survey Responses | http://bit.ly/ooserves-results
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
AB
1
Hello, wily data ninja!
2
Here are instructions on how to clean-up the Survey Monkey results of the OO Serves the People.
3
Step 1:Find your records
4
Open Survey Monkey sheet
5
Locate Data Ninja column A with your first name (purple-colored text)
6
These are your records!
7
8
Step 2: Recode Schools
9
Scroll to the last column, CW, for schools (purple-colored text)
10
Recode the open-ended responses using the following: 0 none, 1 public K-12, 2 public college, 3 public grad school, 4 private K-12, 5 private college, 6 private grad school
11
You may need to Google the schools, to see if they are public or private
12
Enter the new value into column CX for RECODED SCHOOLS
13
14
Step 3: DONE!Recode Zip Codes
15
Locate column BR for zip codes (purple-colored text)
16
Recode zip codes into cities in column BS for RECODED ZIPS
17
USPS has a good zip code lookup:
18
https://tools.usps.com/go/ZipLookupAction_input
19
20
Step 4: DONE!Recode Year Born to Age
21
Locate column BP for year born (purple-colored text)
22
Recode into age in 2012 in column BQ for RECODED AGE
23
24
Step 5: Recode Missing Responses
25
Look through all columns for the record
26
Replace any missing values with 0 for missing response
27
28
Step 6: Recode "Other" responses into multiple choice answers
29
Look through all columns with open-ended answers (blue-colored text)
30
See if you can recode their open-ended answers into one of the multiple choice answers provided
31
32
Step 7: Identify Categories for Concerns and Visions
33
Locate open-ended responses for top three concerns (columns X-Z) and top three visions for OO community center (AA-AC)
34
See if you can identify broader categories that the open-ended answers fit into
35
Enter categories into columns AD--AI for CATEGORIZED CONCERNS & CATEGORIZED VISIONS
36
37
Resources:
38
Face to face survey version: http://bit.ly/ooservesthepeople
39
Survey Monkey version: http://bit.ly/ooservespeople-surveymonkey
40
Survey results: http://bit.ly/ooserves-results
41
Outline for OO Serves the People report: http://bit.ly/ooservespeople
42
Occupy Research General Survey (for reference): http://occupyresearch.wikispaces.com/surveys
43
44
Thursday, 3/29 call at 8PM to CLARIFY CALL THINGS
45
Call-in number:1 (800) 617-4268
46
PIN: PIN: 22988982
47
Look for an invite to a Google Hangout from Yvonne, yvonnegrapher@gmail.com
48
Call Yvonne if you have any questions: 646-321-5710
Loading...
 
 
 
Start Here!
Data
Survey Monkey
CONCERNS
CONCERNS_CODES
VISION
VISION_CODES
Community Center
Analysis
Data Cleaning Sheet