Versions Compared

Key

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

...

  1. Start off by writing the categories in for the questions in the Categories sheet. Here, we will make two quizzes, a midterm, and a final, but it can be anything.

  2. Choose a category and question type for your question on the Question Bank page. Here, we are doing a short answer for the midterm.

    1. If the category doesn’t show up, right click the “Question Bank” tab at the bottom of the page and click “Unhide” in order to unhide the category sheet. Then write in the new category as you would in (QB)².

      Image Added
  3. Write in the question, answers, and corresponding point values. In this case, we asked “What unit (equivalent to 4 inches) is used to measure the height of horses? The answer is “Hands”, and any other answer will result in zero points awarded (though partial credit could be given by changing any particular answer’s value to something above zero).

    1. Repeat until you are done writing questions!

...

  1. Save the spreadsheet and go back to your Google Sheets.

    1. Open the spreadsheet by clicking: File > Open


      Then drag the file into the box in order to open it.

  2. Set up the spreadsheet again by going to the menu above the spreadsheet like we’ve done before (except now there will be data in the spreadsheet).

    1. Add-ons > (QB)² > Question Bank Quick Builder > Set up (QB)² spreadsheet

    2. Image Added

      You will receive a warning about resetting the spreadsheet. This is okay, since the only thing that will be overwritten are the headers in the spreadsheet. Click Ok.

    3. Image Added

      The reason for this is that there is currently a bug where the dropdown menus for the categories column won’t link up with the categories sheet. Resetting the spreadsheet quickly fixes this.

  3. You are done! Now that you have loaded your spreadsheet, you can export it as an XML the same was as you normally would with (QB)².