Data Stripping Sheet Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Guide to Data Stripping Sheets
2
What it's for: A data stripping sheet is a tool for quicker analysis of qualitative data, especially by staff who haven't done much qualitative analysis before. It won't be right for every project - it works best when you are happy with more structure, and it means that you are less likely to get surprising findings. Decide whether it is right for your project.
3
How to use it: First, decide on your columns. These are usually the relevant demographic variables, then the questions. Then paste all of your interview data into the relevant columns. Finally, at the bottom of each column, write a sentence or two of analysis on the general trends observed in the data, and on what variation you observed. These are useful notes when you come to decide the findings, and they are not final.
4
An example: In the sample data below, we have recorded Gender, Age and Location, and then the answers to each question, for six interviews. We have then recorded brief analytical thoughts at the bottom of each column. (This data is made up).
5
Variation: You can add a column at the end which summarises a whole interview if you read across. You can also keep adding rows for different analytical questions - for instance, you can add a separate row for gender, or for 'implications for the programme'.
6
Credit: This tool has been developed by Tom Wein. tomweinresearch.me. Please use and adapt for any purpose, with credit.
7
8
Interview CodeTranscript URLGenderAgeLocationWhat is your favourite TV show? Why?Do you use the internet? What for?
9
I1F37MombasaI love Shamba Shape Up. It's just so useful, I have got so many good tips.I prefer to use the internet on my phone, mainly for checking weather and prices.
10
I2M21KilifiI only really watch the news. But not often, mostly I don't watch TV.I get to an internet cafe when I can afford it, just to watch videos and chat.
11
I3F42MombasaShamba Shape Up is the best show on TV, I always catch itI try to hear the news, and get information about weather and prices.
12
I4F18Mombasa[Laughs] I don't have time for such things, I just use my phone to watch videos insteadAll the time, I think I am addicted. I watch every new music video that gets released. Mayonde is the best!
13
I5M55MombasaShamba Shape Up is so entertaining, the presenters are very charismaticNot really. My son uses it for work, and sometimes I ask him questions about prices and football.
14
I6M27KilifiI guess I watch CSI the most, it's the most exciting showMy parents bought me my own laptop for study, and I can't get off Netflix!
15
General trend:Shamba Shape Up is the most popular show. Reasons given included its entertaining presenters and its valuable tips. The only other TV show mentioned was CSI. A minority did not watch TV at all.Respondents mentioned two main purposes for internet use: getting information about weather and prices, and viewing entertaining content.
16
Variation:Older respondents were keen on Shamba Shape Up, while those who did not watch TV were younger. There was no clear difference by gender or location.Those using the internet for entertainment tended to be younger, while those using it for information tended to be older. There was no clear difference by gender or location.
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...
Main menu