Self Assessment Instructions

Google Sheets

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 Link

  • Click on the Get the Link Here tab of the template (at the bottom).
  • Click on the link to test out your quiz.

Step 4: Bookmark and Share

  • Share the 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:]]
    • 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. [[]]
    • 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.