Google Sheets is an online program that allows users to create quick surveys or quizzes which are integrated with the Google Drive app as the central storage system. Like all Google applications, the easiest way to open the App is through the Google home page (www.google.com). In the top right hand corner, there will be an icon that I refer to as the Google waffle because it has three rows of three cubes resembling a waffle. This is a quick way to access any native Google app. It does not work for apps that are not created by Google.
Clicking on the Google waffle, opens up a list of Google Apps that are available on your user account. If the app that you are looking for does not show up, it is possible that it is on a secondary page. Click on More at the bottom of the selection. Additional apps will display.
It is possible to rearrange the order of the Apps in a fashion that is more convenient for your usage. Simply drag the icon (click and hold on it with your mouse/trackpad) and move it to the desired spot. It is possible to move apps from the lower section to the upper section.
Open Google Forms by clicking on the icon. Another way to navigate to Google Forms is by typing the website in directly (forms.google.com). It is also possible to bookmark the Forms homepage as a shortcut.
The Forms start screen will resemble the photo above (Google has modified the Forms home screen slightly recently). On the left hand corner, there are three horizontal bars. Clicking this will allow you to quickly navigate to other Google Apps such as sheets, slides and forms. Next to that is the Forms search bar which allows you to quickly find a previously created document simply by typing in the name or a keyword that might be contained in the document. On the right hand side of the screen is the Google Waffle similar to the Google home page. Two icons over from that is your Google Account avatar identifying the account that is being used. Below that are a variety of templates that can be used to create forms for various purposes. Clicking on the up and down arrows next to Template Gallery opens up additional templates. To create a blank document from scratch, click on the Blank document that has the '+' symbol on it. Below this section are a list of recent documents that have been opened (not shown). This list can be further filtered by owner or by action last performed and files can be portrayed in a list or a grid view.
Start by opening a blank form.
The Google Forms page has a simple interface devoid of long toolbars and menus unlike most of the other Google Apps.
Start by creating a title for your form at the top part of the newly created form (highlighted in blue). This then becomes the default file name (top left hand corner) although a different name can be assigned manually. As with all google tools, changes are saved automatically after every change. Frequently used forms can be Starred making them easier to find.
On the top right hand corner is the very basic Forms Toolbar that applies changes universally to the entire form. The three tools available are:
1. Theme Options
2. Preview Form
3. User Settings
To the immediate right of the toolbar is the Send button used to distribute the completed form/quiz to participants.
To the right of every question is a toolbar that will customize that specific question. The current form is in the Question view. Clicking on the Responses tab will open up any responses that have been received for the form.
Forms can be distinguished from one another through colour. If using Forms for quizzes, this may be an easy way to differentiate quizzes between subject areas. There are a variety of "stock" colour choices as well as the option to customize a colour using the palette tool. There is also the ability to distinguish between background colours or to upload a picture for the header as well as adjust the font style.
The Preview button opens the form in a separate tab to show what the live form would look like. The previewed form is fully functional and users can test out the answers by clicking on them. Submitting the form will create a response.
There are three separate tabs in the Settings box: General, Presentation and Quizzes:
The General Settings tab relates to user interaction with the distributed form/quiz. In this section, the owner has the option of collecting email addresses or making the quiz anonymous. If checked, there is the option of sending a receipt to the person completing the form notifying them of their submission. Note that there is no verification process to ensure that emails entered are actually legitimate or not.
The next option limits submitters to one response and therefore requires them to sign in using an email address. However, once again there is no validation process and it is possible to use an illegitimate email.
The last two options provide options after submission of the form: the first allows the submitter to edit their work afterwards and the last provides submitters to see the results.
The Presentation Settings tab allows users to configure what is viewed while the form is being filled out. The three options are:
Finally, it is possible to configure the confirmation message that is shown once the form is submitted.
The Quizzes Settings tab allows the user to convert the form into a quiz by selecting the first button. This does two things:
Quizzes can be further configured so that the grade is either shown to respondents once they have submitted or at a later date (requires email registration). Finally, the quiz can be configured so that respondents can see questions that were missed, correct, and/or point values.
Further information on creating a quiz will be outlined further down in on this page.
A form consists of a series of questions. Questions are relatively consistent in that they usually take the form of a question or a statement. However, question can be embellished by adding an image or a video to accompany it. The variety lies in the types of answers that can be selected. These include:
*this answer style has additional options of only allowing specific file types (document, spreadsheet, PDF, video, presentation, drawing, image or audio), specifying how many files can be uploaded (1, 5 or 10), and the maximum file size (1mb, 10mb, 100mb, 1gb or 10gb). For this last option, the user may wish to change how much total storage can be uploaded to the form (total from all participants)
Some questions have additional options attached to them. Specifically,
At the bottom of each question there is the option of either duplicating the question or deleting it. There is also a toggle switch that makes the question either mandatory or optional to answer. On the top of the question is a movement symbol which allows reordering of questinos simply by dragging them to another spot. On the side of each question lies the question toolbar consisting of five actions:
When the form is completed, it can be sent to respondents in a variety of ways:
Clicking the vertical ellipses in the top right hand corner of the Forms page will open up some universal options including: