Just putting one of my questionnaires into excel for my dissertation so it makes the data collection and calculation a bit easier and i've run into a bit of a problem.
I've made a table whereby the participant has to answer a question as a level of agreement in one of 5 categories.
All of the time | Most of the time | Some of the time | Rarely | Never
This is how it is scored :-
5 = all of the time
4 = most of the time
3 = some of the time
2 = rarely
1 = never
and for some questions the scoring is reversed so you would get 1 for all of the time, and 2 for most of the time.
Now my question is, is there a way in which I can make it so that when the participant puts the 'x' in which ever box they chose for each question, that then puts the score for that question into another summary table which i've setup? Basically so that as the person goes through the questionnaire it gets their score adds it to the table and then when they've finished it tots the score up for me.
Am i right in thinking I would somehow have to label each cell as having a value then if an 'x' is put in the cell it will add that value into the running total?
Don't know if i've made sense really, but i'm pretty sure it can be done but my Excel skills extend as far as GCSE level whereby I can only remember how to do the adding and multiplying bits lol.
I've made a table whereby the participant has to answer a question as a level of agreement in one of 5 categories.
All of the time | Most of the time | Some of the time | Rarely | Never
This is how it is scored :-
5 = all of the time
4 = most of the time
3 = some of the time
2 = rarely
1 = never
and for some questions the scoring is reversed so you would get 1 for all of the time, and 2 for most of the time.
Now my question is, is there a way in which I can make it so that when the participant puts the 'x' in which ever box they chose for each question, that then puts the score for that question into another summary table which i've setup? Basically so that as the person goes through the questionnaire it gets their score adds it to the table and then when they've finished it tots the score up for me.
Am i right in thinking I would somehow have to label each cell as having a value then if an 'x' is put in the cell it will add that value into the running total?
Don't know if i've made sense really, but i'm pretty sure it can be done but my Excel skills extend as far as GCSE level whereby I can only remember how to do the adding and multiplying bits lol.
