I have 62 questionnaires with raw data and they're all been filled out by hand
by my participants and now it's time to enter all this data into Excel. Let me
show you how I do it. The first thing I do, is to put a unique, consecutive
identification number on top of each questionnaire. The next step is to start Excel.
In Excel, my first row, is where I put my headers.
The second row, is where I put the first respondent. The columns are my variables.
My very both my first column header, is ID. The first respondent has
the identification number 1. My next header, is q4, which stands for "question one".
My respondents could select one out of three responses. I code these 1, 2 & 3.
In this example, the respondent selected the first one so I will cold this with the digit 1.
In question 2, they could select multiple responses, if they wanted.
In Excel, I give each response its own column: q2a, q2b and q2c.
If the participant has checked the box, I will write the code "1", otherwise
I will write a "2". In this concrete example, the respondent has
selected the first alternative, left the second one blank, and selected the
third. Consequently, I will put a "1" q2a, a "2" in q2b, and a "1" in q2c.
Let's move on! The header for question 3 is q3, of course.
I designed this question as a ranked scale, as you can see, with the steps 1 through 5.
The respondent has marked the second scale step, which means that I enter
the digit "2". OK, the next question is number 4. I coded this dichotomous question
with the digit "1" for Yes and "2" for No.
In this example, I write a "2".
Question 5 is an open-ended question.
I need two columns in Excel for this to work. In q5a, I enter the
written reply from each respondent verbatim and in the next column, q5b, I will
later categorize the responses, i. e. interpret and code them with digits.
I talk more about this in another of my tutorial videos.
Question 6, as you can see, is a semantic differential.
For this respondent, I coded it with the digit "1".
OK, that is the end of the first questionnaire.
Let us do the second one together.
Q1 is coded with the digit "2".
Q2a is coded with the digit "2", q2b with the digit "1", and q2c with the digit "2".
Question 3, is is coded with a "5".
Question 4 is coded with .... [cat is interfering]
... with the digit "1".
For question 5, I just type in whatever the respondent has written by hand.
Question 6 is coded with the digit "3".
OK.
That concludes the second questionnaire.
I will continue now, and enter the rest of these raw data.
However, there is no need for you to watch all that. I am going to end the video now.
If you enjoyed the video, please leave a Like and/or Subscribe.
In my next video, I will show you how I transform all these data into professionally looking figures and tables.
Until then, have a nice day. Bye bye!