In this section we suggest how you could set up the event / activity / simplified questionnaires in an online format. In our example, we have used the Google docs application because it is free of charge and so open to everyone that has access to the internet. However, there are other web applications such as Surveymonkey which allow you to create online questionnaires and which you may choose to use instead.
Guide to creating an online questionnaire
Step 1 – create new form
In Google docs, go to the ‘create new’ tab and select create new ‘form’.
Step 2 – open the Word version of the questionnaire
Open the Word version of the event questionnaire so you are ready to copy and paste question text into the Google form.
Step 3 – give your questionnaire a title
Give your Google form a title. In this example, we have called ours ‘Post-event questionnaire’. You may also choose to add some information text below the title; for example, we inserted the following text: “Thanks for taking the time to fill in this questionnaire – it shouldn’t take longer than 5 minutes to complete. All answers will be treated as confidential”.
Step 4 – add questions
To add questions, click on the ‘Add items’ button and then select the type of question you want to add from the list (Text/ Paragraph text/ Multiple choice etc).
Tip: Google docs adds the first couple of sample question templates for you, so you only need to use the ‘Add items’ tab once you run out of sample question templates.
Now copy and paste the question text into the ‘Question Title’ / ‘Help Text’ boxes, along with the label text (in the case of ‘Grid’ questions) or option text (in the case of ‘Multiple choice’ or ‘Choose from a list’ questions). Click the ‘Done’ button to finishing editing questions. Click ‘Save’ regularly to save your questionnaire.
Tip: You can go back and edit questions at any time - just hover your cursor over the question you want to edit, and click the edit (pencil) button to start editing.
Here is our recommendation of what type of question to use for each question in the event questionnaire:
Use the drop-down menu to select 5 columns
1 = Strongly agree
2 = Agree
3 = Neither agree or disagree
4 = Disagree
5 = Strongly disagree
1 = I enjoyed myself
2 = The event was well-organised
3 = The event was of a high quality
4 = I gained new knowledge / skills
5 = This event has made me more likely to attend similar events in future
6 = This event has made me more likely to participate in the kinds of activities on show at the event in future
See question 2 for column labels
1 = More so than before, I think there is a strong sense of community in the area
2 = More so than before, I think the area is a good place for arts and culture
3 = More so than before, I think the area is a good place for events and festivals
4 = More so than before, I think the area is a good place for sport
Tip: To avoid copying out the same text each time, we recommend you use the ‘duplicate’ function (to make a copy of Question 2) and just amend the Question Title and Row labels for Question 5.
Option 1 = Yes
Option 2 = No
Option 3 = Not applicable – I live locally
Three separate questions needed. We suggest you make the first question - “When you attended [..] own home?” - Multiple choice.
We suggest you reword the second question slightly so that it reads “If yes – where did you stay?” and we have made it Multiple choice.
We also recommend you add a third (Text) question which reads “If you answered ‘Other’ accommodation for the last question, please describe where you stayed?”.
Seven separate questions needed. We suggest you make the first four questions (relating to spend on local travel / food and drink / merchandise / accommodation) Text questions.
We recommend that you make the fifth question relating to ‘Other purchases’ a Paragraph text question to give respondents enough space to describe what they bought.
Make the sixth and seventh questions (relating to how many people the expenditure was for / how many days respondents’ spent at the event) Text questions.
Option 1 = Male
Option 2 = Female
Option 1 = Under 16
Option 2 = 16-24
Option 3 = 25-34
Option 4 = 35–44
Option 5 = 45-54
Option 6 = 55-64
Option 7 = 65-74
Option 8 = 75+
Two separate questions needed.
Make the first “Do you consider [..] conditions” Choose from a list. Option 1 = Yes / Option 2 = No.
Then make the second “If yes [..] below” a Text question.
Make the first (White British – Chinese options) Multiple choice.
Option 1 = White British
Option 2 = White Irish
Option 3 = White European
Option 4 = Mixed (White and Black Caribbean)
Option 5 = Mixed (White and Black African)
Option 6 = Mixed (White and Asian)
Option 7 = Mixed (Asian and Black)
Option 8 = Asian – Indian
Option 9 = Asian – Pakistani
Option 10 = Asian – Bangladeshi
Option 11 = Black Caribbean
Option 12 = Black African
Option 13 = Chinese
Make the second (Other ethnic backgrounds) a Text question.
If our guidance is up to scratch, we think your Google docs post-event questionnaire should end up looking something like this:
Step 5 – email the questionnaire
To email the questionnaire to others, click the ‘Email this form’ button, add the email addresses of your participants and then click ‘Send’.
Tip: We recommend that you opt not to ‘include form in email’ (to avoid giving people the option of printing off the questionnaire and completing it by hand).
Step 6 – view the results of the questionnaire
To view the results of the questionnaire, click the ‘See responses’ button and opt for Spreadsheet.
You will now be taken to a spreadsheet which contains all your questionnaire results.
Tip: you can go back to the original questionnaire (to edit / send it to more people etc) any time by clicking on the ‘Form’ tab at the top of the page and selecting ‘Edit form’.
Step 7 – prepare to analyse the results of the questionnaire
Once all the results are in, we recommend that you export the results of the questionnaire into Excel. To do this, go to ‘File’ and then select ‘Download as’ > Excel.
Step 8 – analyse your questionnaire results
For guidance on how to analyse the results of the questionnaire go to the Data Analysis Guide