Step 1: Modify the Google Spreadsheet Template
- Make a copy of this template. (You'll need to sign-in with your Google account.)
- Edit the data on the Key tab.
- Assign each possible outcome a number in the Key column.
- Give each possible outcome a name in the Category column.
- Give each possible outcome a text Description.
- Optional: Assign a Color (either name or HTML code) to an outcome.
- Edit the questions on the Questions tab.
- Type "Q" to indicate a question in the Key column. Enter the question in the Text column.
- Type a number corresponding to one of your defined outcomes in the Key column. Enter a multiple choice option in the Text column.
- Edit the settings in the Options tab.
- quiz name: enter a name for your quiz
- shuffle questions: enter 'yes' or 'no'
- shuffle choices: enter 'yes' or 'no'
- intro text: edit the instructions for your quiz
- Do not edit any cell with a blue background. Do not change the order of the worksheets (tabs).
Step 2: Publish Your Spreadsheet
- Go to File, Share, Publish to web, then click Publish.
Step 3: Get Your Flippity.net Link
- Click on the Get the Link Here tab of the template (at the bottom).
- Click on the Flippity.net link to test out your quiz.
Step 4: Bookmark and Share
- Share the Flippity.net link with anyone you want to take your assessment.
Frequently Asked Questions
How is the Self Assessment scored?
- Flippity simply adds up the number of times each key number is selected and presents the corresponding result as a percentage of questions asked.
- If your key has only two possible outcomes, results are presented on a continuum.
- If your key has more than two outcomes, results are presented as individual percentage scales.
- Since multiple options may be selected for each question, it is possible results will add up to more than 100%.
How do I use pictures in my Self Assessment?
- In the appropriate cell, type [[Image: followed by the URL (address) of a picture you find on the web followed by ]].
- e.g. [[Image:https://upload.wikimedia.org/wikipedia/en/f/f0/Cheers_intro_logo.jpg]]
- URLs must end in ".gif", ".png", ".jpg", ".jpeg", or ".webp".
- You cannot use Google Drive to store your images.
- You can use Google Drawings. Use the "Publish to the web…" link.
- You may include text before or after the image.
- Images are automatically resized to 200 pixels high for questions and 100 pixels high for answer options.
- Smaller images load quicker.
- (Be sure you have the legal right to use each image
How do I use YouTube videos in my Self Assessment?
- In the appropriate cell, type [[ followed by YouTube's "Share this video" link followed by ]].
- e.g. [[https://youtu.be/kwFvJog2dMw]]
- You may include text before or after the video.
How many questions can I have in my Self Assessment?
- Theoretically there is no limit, but the more questions you have the slower it will load and the more likely you are to run into trouble.
- (You should be able to give a 50 question quiz without problems.)
How do I make changes to my Self Assessment?
- Make sure Automatically republish when changes are made is checked, then go ahead and make changes to your Google Spreadsheet.
- Your changes will automatically be reflected, no need to get a new link.