So your project is now complete and your questionnaire results are all in. What now?
Before using your questionnaire data, you will should check the responses for mistakes – for instance where certain boxes are left empty, or multiple members of a group have completed questionnaires (meaning spend may be double-counted). This section will outline some common examples of occasions when you will need to ‘clean’ the data, as well as tips on how to do so. Please note, that in order to begin tidying up your data, all responses will need to be in a spreadsheet. If you used a paper survey, please see below for advice on getting your responses into a spreadsheet.
Tidying up the responses
If you decided to use paper questionnaires for your research (as opposed to online questionnaires) it is strongly advised that you spend some time inputting the questionnaire results into a spreadsheet. This will ensure that your responses are easy to sort, filter and count up before putting into the relevant calculator.
Please note that for online questionnaires, the results are automatically inserted into a spreadsheet for you so you can skip this part and work through the pages above.
We have created some example Excel spreadsheets which you can use to organise your responses; they contain some example results in red to show you how you could input your data.
Click here to download the example for Economic Impact only - Events
Click here to download the example for Economic Impact only – Activities
Click here to download the example for Social Return only