Transparency-Sexism-Survey
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sheet NamePurposeDate Created
2
OverviewThis sheet. It's purpose is to explain the purpose of all sheets in this workbook3/20/2016
3
One ProjectThis is a reimagining of the entire survey as asking about one project: one where the person worked for at least half a year and was recent enough to be able to answer questions about the experience in detail. These questions are in review with Dr. Rice.3/23/2016
4
TODOsTo track todo items for Dr. Rice and Hoco
5
Possible QuestionsThis was my first draft of questions, which I then classified, prioritized, sorted and analyzed for redundancy and what it might reveal3/19/2016
6
DimensionsIn this sheet I analyzed how many questions fell into each of the dimensions I identified in the "Possible Questions" sheet. The idea was to find out which dimensions were under or over represented. I was surprised to discover a significant imbalance in the questions I created. I found I would have to create more questions in the "Antitransparency due Information Control" and "Exploiting Information as Currency" dimensions, and that Antitransparency due to social pressure as well as Transparency questions were both overrepresented. I think that probably means it is easy for me to formulate questions for the latter than the former and I have some more thinking to do.3/19/2016
7
Filtered QuestionsUsing the priorities set in the "Possible Questions" sheet and the count of questions by dimension I deleted all questions that fell outside a dimensions's priority cutoff to get the number of question in each dimension closer to 15, which I arbitrarily set as a decent number of question per dimension. 3/20/2016
8
Grouped and RefactoredIn this sheet the "Filtered Questions" have been refactored and sorted into groups, so that questions with a comment into such as "On how many projects you've worked..." appear together within their dimensions. The survey wouldn't be presented as groups of questions probably. They can't be completely randomized because some questions are in essence follow-up questions which must appear immediately after the question on which they depend. Also, some questions have normalized responses which must always be kept with their question.

This sheet also assigns short, unique names to the questions so they can be used as field names in a database and also so they can be quickly referred to unambiguously.
3/20/2016
9
Assertions to TestThese are things I wonder about whether they are true or not, and which the data from the responses might be able to lend credibility to, or refute.3/19/2016
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Overview
OneProject
Ranges
NormalizedScoring
Categories
Sections
TODOs
Possible Questions
Literature
Dimensions
Filtered Questions
Grouped and Refactored
Assertions to test
notes