You are allowed to use a digital form such as a Google Form to create your Phase 2 questionnaire. Be careful to “self-mark” to ensure that you fulfil all the requirements of the PAT. To do this, unfortunately at this stage, you must still create a form in Microsoft Word as per the requirements and then recreate it digitally as a Google Form.
In this post:
- Creating a new Google Form
- Setting up your Form
- Adding questions
- Form settings
- Fulfilling the PAT requirements
- Distributing your Questionnaire
- Viewing responses
- Changing questions
- Downloading your data
1. Creating a new Google Form
Navigate to your Google Drive. Create a new folder in your Drive. Create your Form using the Add button. If you do not work in Google Drive, open Google Forms in your browser (Chrome works best) and create a new Form. There is no need to save your work, it is auto-saved for you.
2. Setting up your Form
Put yourself in the shoes of a person who receives a link to your questionnaire: unlike a survey where you are present to explain the nature of your research, you will not have an opportunity to give background information to the respondent. With this in mind:
- A sensible, descriptive title to your Form (it should include your topic), for example:
- Grade 10: Fake News Questionnaire
- Grade 11: Internet of Things Questionnaire
- Grade 12: Questionnaire: Building a Resilient Future – ICT in a time of crisis
- Add a short introductory passage at the top of your questionnaire explaining:
- who you are (name & school)
- what the questionnaire is for (your Grade 12 Computer Applications Technology project)
- what you are using their data for (statistical analysis)
- that you will not make their private information public (you will not include their name, surname or e-mail address in your project)
- Add fields for Name, Surname & E-mail address, but do NOT make them Required
- You could even provide a link to POPIA!
- Click and type a name for your Form (include your surname at the beginning of the name)
- Click and type a title for your Form
- Add a description and/or message to your form
- Click the plus icon to add a question to the Form
- Select a question type
- Click and type your question label
- Set the question to required if appropriate
- You cannot save — your work is automatically saved
- Click the Customise Theme button to change the colour and design elements of your form
- Click the Preview button to view the form & test it at any time
3. Adding questions
Add questions for each piece of information you need to collect by clicking on the plus button in the floating vertical menu on the right of the screen. Each question has a number of settings much in the same way that you can apply properties to fields in Microsoft Access.
You can add a Section to separate your biographical questions from your topic questions.
Questions types & Validation
If you set Name, Surname and E-mail fields as Required you might put some people off due to privacy concerns. The same goes for setting the Form to automatically collect e-mail addresses. Consider leaving these as optional.
Pay attention to settings for required answers and validation of answers.
Use checkboxes and radio buttons correctly. If you have a closed question that requires only one selection from the options offered, remember that a radio button control only allows one option to be selected so you do not need to add an instruction such as “Select one answer only”.
4. Form settings
- Activate the General settings tab
- Do not select Collect emails as this forces respondents to provide an e-mail address
- Do not Restrict users in Wittedrift High School and its trusted organisations as this will prevent anyone who is not signed in with a Wittedrift School account from accessing your Form
- Do not activate Limit to 1 response as this requires the repondent to provide an e-mail address
- Do not activate Edit after submit
- Do not activate See summary charts and text responses
- Activate the Presentation tab
- Activate the Show progress bar option if your Form has multiple sections so that the Progress bar shows while the Respondent is completing the questionnaire (this is completely optional).
- Do not activate the Shuffle the question order
- Do not activate the Do not Show link to submit another response options
- Add a custom message at Confirmation message to thank the respondent upon completion of the Form
Do not activate any of the settings on the Quizzes tab.
5. Fulfilling the PAT requirements
Invite your Educator to complete the Google Form by clicking the “Send” button and entering their e-mail address. Also, add your Educator to the Google Form as a collaborator. That way they have access to the Form for the purpose of assisting you and of course marking the finished work
Save (“print”) your finished Google Form as a PDF as evidence of your work: in Chrome use the CTRL + P keyboard-combination to print the Form to a PDF. Export the Google Form results to a Google Sheet and share that Sheet with your Educator.
6. Distributing your Questionnaire
Click the Settings button to open the Send options panel (the panel has three tabs: Email, Link, Embed HTML) :
- Do not select the Collect emails option
- On the Email tab
- Add multiple e-mails addresses in the To field
- Add a meaninful Subject for the subject field of the e-mail
- Add a short Message to appear in the e-mail body (optional)
- Do not use the option Include form in email
- Add your teacher as a collaborater
- Use the Facebook & Twitter options if you have accounts
- Click the Send button to send the e-mail(s)
- Use the Shorten URL option if you would like to
- Click the Copy button to copy the link to your Form to the Clipboard
7. Viewing responses
Click on the Responses tab of your Form. There are a number of options for viewing the responses you have received. You can view responses at any time.
8. Changing questions
So you have been watching those responses rolling in: MAGIC! But you asked the question: “What are your favourite three flavours of ice-cream?” (you even offered the option for the respondent to add their own option) and you keep seeing people adding the same flavour that you don’t have in your options. You missed one.
No problem: add that flavour to your options now!
What you CAN’T do is make changes like adding or removing an entire question (or even just removing an option for a question) or any other major changes.
Unsure? Drop me a line!
9. Downloading your data
If at any stage during the process of creating your Google Form you thought it was not worth the effort, this step is for you! Once you have collected enough responses:
- Click on the Responses tab of your Form.
- Click on the button to change the Form from “Accepting responses” to “Not accepting responses”.
- Click on the green Create spreadsheet button.
- Use the default option Create a new spreasheet
- Click on the Create button
A Google Sheet populated with all your data will open in a new tab.
- Download the Google Sheet data
- Select the File menu
- Select the Download option
- Select the Microsoft Excel (.xlsx) option
Save the workbook in your Phase 2 folder. Name it something meaningful (example: add the word “downloaded” to the existing name.
Next step: Phase 2 Excel analysis
Check out the totally amazing JotForm Form Builder for an alternative to Google Forms!