Training student staff to work in a recreation facility is an important step to ensure that customer service, risk management, and job skills are all communicated effectively to the employees. Though much of the training we require is more effective when conducted in person, there are some parts that can be conducted just as effectively through an online venue. Sometimes, combining online information with in person training is even better! If students can receive the information first through an online venue, more time can be spent in person on the practical application of the information.
If we decide to provide training information online to our student staff, it is important that they understand the training before continuing on to the practical application. After students complete an online training session, we can test understanding using a Google quiz. The following provides step-by-step instructions for creating and using Google quizzes.
First, create a Google form using quiz questions you have written that are based on the training you provided. If you have never created a Google form before, you can find step-by-step instructions here. Most types of questions will work as long as there is an exact answer expected. For example, multiple choice questions work well, but an essay answer using a paragraph box may not be appropriate, since correct answers may differ slightly from the answer key. It would also be a good idea to select “Required” for each question so that students don’t inadvertently skip a question.
Once you have created your Google form, you can convert it to a quiz. In the upper right-hand corner of the form you will see a “gear” icon, which will take you to the “Settings” menu. Select “QUIZZES” from the menu.
You will then have the option to make the form a quiz by sliding the first button to the right. If you want your students to have immediate feedback on their quiz results, select “Immediately after each submission” under the Release Grade option. You can also select which options you would like your students to see. If students will need to retake the training if they don’t meet the minimum score, you may want to show which answers they missed, but not the correct answers. These options are up to you to either check or uncheck.
Next, you will need to create an answer key so that student submissions will be automatically scored. Click on the first question in the quiz. You will now see a link at the bottom called “ANSWER KEY.” Click on that link.
You will then be able to choose the correct answer, and set the point value for that question.
Continue to select the correct answer and choose the point value for all subsequent questions. Once you complete this step, you will want to set up a confirmation message so that students can see their score after they submit their answers. Click the “Settings” icon at the top of the page, and select “PRESENTATION.” Then type in a “confirmation message” that directs students on how to find their score, and instructs them on what to do if they did not earn the minimum score to pass the quiz. Once you have typed the confirmation message, select “SAVE.”
When students complete the quiz and submit their answers, they will receive a confirmation screen containing a link they can select to view their score. Below is an example based upon the confirmation message that was set in the above image.
You will now want to choose how to collect quiz responses. Select the “RESPONSES” menu item at the top of your quiz.
A screen will appear that contains a spreadsheet icon. Click on the icon.
You will be prompted to select a response destination. I would recommend selecting the “Create a new spreadsheet” option.
The new spreadsheet that will collect all of your quiz responses will open on the screen. The spreadsheet will show the name of the student who submitted the response, the day and time the response was submitted, their score, and the answers they selected for each question.
If you have determined the minimum score necessary for students to pass the quiz, you can easily see if a student has failed by using “conditional formatting.” Conditional formatting allows you to create a rule where if a certain condition exists, then the formatting in that cell will be different from all the other cells. On the top menu, select “Format,” then “Conditional formatting…”.
A box will pop up on the right side of the spreadsheet that you will use to create rules for formatting your spreadsheet. First, select the range of cells for the formatting. In this case, you want to format the column that contains the quiz scores.
Next, choose the condition for formatting the cells. The default selection is “Cell is not empty.” You can change this condition by clicking on the arrows beside this option.
A drop down list appears with choices for formatting. Since you want to be alerted if a student fails the quiz, select “Less than.”
Once “Less than” is selected, you can insert the minimum value needed for a passing grade. In this case, students must score at least 80% in order to pass the quiz. After you determine the formatting condition, you can choose the style you want to use. The default formatting style is to make the cell green. If you would rather use a different color, then select the arrow beside “Default” to bring up other formatting choices.
I would like failed scores to show up as red, so I have selected “Custom format.” I then have the ability to fill the cell with a red color if the score is below 80%. Select “Done” when finished.
Now let’s say that Joe Schmoe and Famous Amos have both taken the quiz. They submit their quiz answers and receive a confirmation message with the link they can choose to view their results. Below are samples of what each will see. Joe has scored 100/100, or 100% and Famous Amos has scored 60/100, or 60%. Famous Amos will need to retake the training and quiz.
The spreadsheet contains both students’ results, including when they took the quiz, their score, and which answers they missed. As you can see, since Famous Amos scored less than 80%, the cell containing his score is red.
Using Google quizzes and spreadsheets with conditional formatting can help you to complete training processes, especially when you have a large student employee staff, limited time for in person training, or when you need to hire new students in the middle of a semester. You can then follow up the training with practical applications.
Disclaimer: As of October 28, 2016, the steps listed above are, to the best of my knowledge, the ones needed to create and use a quiz in Google forms and to set conditional formatting in the responses spreadsheet. Google occasionally updates their Google Drive, Sheets, Forms, etc., and sometimes when this happens, old documents don’t work the same way with the new updates.