How to analyse questionnaire responses
If the group used an online survey, the software will automatically collate the data – someone will just need to download the data, for example as a spreadsheet.
If the group used a paper questionnaire, someone will need to manually transfer the responses from the questionnaires into a spreadsheet. Put each question number as a column heading, and use one row for each person’s answers. Then assign each possible answer a number or ‘code’.
Go through each respondent’s questionnaire in turn, adding in the codes. Enter this data into a spreadsheet. See below for an example of what this might look like.