Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can set up the spreadsheet with the blank template automatically by going to "Add-ons > (QB)² - Question Bank Quick Builder > Set up (QB)² spreadsheet". This will create all sheets necessary for (QB)². (QuestionTypes and QuestionOptions are hidden sheets that do is a hidden sheet that does not need to be edited by the user.) This will also open up an interface to guide you through creating questions in a sidebar to the right of your spreadsheet.

Note

This does not delete any pre-existing sheets except for those with the same names, so please exercise caution and make sure there are no existing sheets called “Question Bank”, “Categories”, or “QuestionTypes”, or “QuestionOptions”, because those sheets will get replaced. Set up is not intended to replace your existing questions and categories, but you may lose some content if originally formatted incorrectly.

Another alternative is to save a copy of one of the files below in your Google Drive. To make a copy, open the file and choose: File > Make a copy. Both links can be accessed from "Add-ons > (QB)² - Question Bank Quick Builder > Documentation & Template".

...