...
Category – this is fed from the Categories tab. Categories are the main way Moodle organizes questions within a question bank. Enter your category here, and use the pull down arrow in the Question Bank tab to choose the category you want to place the question in. If you specify a category, all subsequent rows will fit into that category until a new one is entered. Upon adding your questions to Moodle, if the category does not yet exist, it will be created automatically.
Forward slash ( / ) can be used in the category column to specify sub-categories
Type – this is fed from the hidden QuestionTypes tab and is pre-populated with the question types (QB)2 supports. These are the types of questions from which you can choose.
The type of question chosen will automatically change the Value/Group/Answer format for that question
Question/Description – the actual question the student responds to.
Value/Group/Answer – This is a multipurpose field.
Upon adding question to Moodle, the answer choices will be randomized by default.
Currently accommodates up to 6 responses. Format of this field will change (drop down or free text) depending on the question type selected.
Value is the percentage (fraction) of points that the response will earn.
If you desire to give partial credit for an answer, the fraction column to the right of the answer can be adjusted accordingly.
Example: 100 = full credit, 50 = half credit, 0 = none. These are tied directly to the answer to the left of each fraction column.
Group allows for answer option groupings, for question types like dragdrop and missingwords.
Answer is mainly used for matching question type where the correct answer is set
Questions can be sorted by any of these fields alphabetically by rightclicking the top of the column (for Questions/Description, column C) and clicking either Sort sheet A → Z or Sort sheet Z → A (pictured below).
...
Question Types
Multiple Choice:
One answer should be the correct one; set value to 100.
The rest of the answers can be set to 0 or partial values such as 25 or 50 depending on if you want to allow partial credit for some answers.
Short Answer:
One answer should be the correct one; set value to 100.
The rest of the answers can be set to 0 or partial values such as 25 or 50 depending on if you want to allow partial credit for wrong answers.
True / False:
Only answer options should be TRUE and FALSE
One fraction has to be set to 100 and the other 0
Ordering:
Place answers in correct order
Value/Group/Answers do not need to be set for any answer
Default grading of answers is set to Absolute Position
PoodLL Recording:
Value/Group/Answers do not need to be set
Essay:
Value/Group/Answers do not need to be set
Matching:
The correct matching answer option needs to be set in each Value/Group/Answer field to the right of each Answer column
Drag & Drop into Text:
Groups of answer choices need to be set for each blank in the Question/Description, associated with a number. (Ex: For every [[1]] there’s a [[2]].)
The first answer per Group to appear from left to right will be considered the correct answer
Missing Words:
Groups of answer choices need to be set for each blank in the question, associated with a number. See previous for example of Question/Description format.
The first answer per Group to appear from left to right will be considered the correct answer
Cloze:
Question and answers are to be written in the Question/Description column.
Answers are indicated between 2 carets (^) or double square brackets ([[ and ]]).
Multichoice: write out the options separated by a comma, the first listed is the correct answer (ex: Phoenix: ^Arizona, California^ Sacramento [[California, Arizona]] )
Shortanswer: write out the answer between the two carets (^) or double square brackets ([[ and ]]). This is not case sensitive (ex: the capital of France is ^Paris^ and the capital of Germany is [[Berlin]].)
Value/Group/Answers do not need to be set
Description:
Value/Group/Answers do not need to be set
Multiple Answer
Used similarly to multiple choice but, At least one answer needs to be correct, and the total point values of all the correct answers need to add up to 100
...
If you want the questions imported under question categories for a specific category, on the import page under General, unselect Get context from file.
...
If you want the questions imported to an already existing category, this category must be specified in the spreadsheet before import. Do not count on Import category option under General to do this for you.
For example, if you want your questions to be imported under Question categories for ‘Category: Humanities’ in the Default for Humanities category, make sure on the spreadsheet before exporting to XML file, to specify category “Default for Humanities” or “Default for Humanities / subcategory name”, and on the import page to unselect Get context from file before import.
Offline Spreadsheet
...
Moodle Backup Import
If you decide to backup a course, you can get a quick summary of the course in Google Documents through our backup import. To get the backup, go to the admin panel and click “backup” under Settings & backup.
...
Proceed with the backup as instructed, choosing whatever sections you want to keep in the backup. The final result will be a file with approximately the format of backup-moodle2-coursename.mbz. In order to reach the XML backup file, you will need to unzip the .mbz file. 7Zip is a free tool that can do this relatively easily (read more here: https://moodle.org/mod/forum/discuss.php?d=350148). Once unzipped, you’ll find a file named “moodle_backup.xml”, which we will use for the import.
For the import tool, access (QB)2 and select Import from… > Moodle Backup XML [BETA]. Then import the file as you would a normal import.
...
The end result should be a document somewhat like this!
...
Caveats
The Moodle Backup XML file cuts off some of the longer titles that summarize the course activities.
Images and other metadata aren’t parsed entirely correctly, as that’s what remains in the XML file (for example, the “{%: Description}” in the image).
Canvas (QTI XML) Export
Exporting from Sheets to Canvas XML works the same way as exporting from Sheets to Moodle XML.
Go to "Add-ons > (QB)² - Question Bank Quick Builder > Export To… > QTI XML (Canvas) [BETA]" to open the sidebar.
Make sure the Question Bank sheet is the sheet you are viewing.
If desired, click “Advanced Options.”
Here, you can disable the default setting of shuffling the order of answer choices within Canvas.
Once the spreadsheet is set up correctly based on documentation and all questions are ready, click “Export" to download a zip file with the necessary XML files, and import into Canvas!
There are two important caveats.
The Dragdrop and Cloze questiontypes are not supported.
Pooddlrecording is replaced with the essay type, as there is no equivalent in Canvas.
Feedback is not supported.
Unsupported features are automatically removed from the quiz during export (with notification to the user).
Importing QTI XML to Canvas
The following instructions are to import a QTI .zip file from the Question Bank Quick Builder (QB^2) into Bruin Learn.
Navigate to the existing course where you with to import the question bank.
Under Home, select to Import Existing Content, located on the right side of the screen.
...
3. Under content type, select QTI .zip for the file type. Then choose the QTI XML (Canvas) BETA file you
exported from the Question Bank Quick Builder.
...
4. Start Import
5. Next, navigate to the Quizzes section in the left-hand navigation menu.
6. Create a new Classic Quiz.
...
7. Select the Questions tab in the newly created quiz and then select “Find Questions”. This will open up a
separate window where you can scroll through your existing Question Banks.
...
8. Click on “View Course Question Banks” in the upper right corner of the new window. This will navigate
you to the full list of your courses question banks.
...
9. Scroll until you find a Question Banks titled “No Name”. This is the newly imported question bank. For
reasons we are not sure of, it will import as “No Name” even if you try to import to a newly created or
already existing question bank.
...
10. Now you can rename the question bank accordingly.
...
NOTE: An alternative way to get to your Questions Banks in Bruin Learn Classic Quizzes it to navigate to the Quizzes section in the left-hand navigation menu. Then click on the three vertical dots to the right of the “+ Quiz” button and from the drop-down menu, select “Manage Question Banks”. This will bring you to your question banks list.
...
Below is for New Quizzes, DO NOT USE THIS!
Navigate to an existing course
Go to Quizzes
Create a quiz (make sure to select “New Quiz” as the quiz type), and once created, click the menu on the top right and then Import Content.
Upload the ZIP file that you downloaded on export
The quiz questions are now imported!
You can also import the questions into a question bank, then select the questions you want to import into the quiz that way. More info on that here: https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-questions-from-a-QTI-package-into-an-item-bank/ta-p/966
Offline Spreadsheet
Google Sheets is great, but the main disadvantage it presents for writing question banks is that you will need an internet connection to use it. If you would like to write your questions offline, visit (QB)² - Writing Questions in Excel
Blocked App? Accessing a Local Copy
We are currently working with Google Support in order to resolve the Blocked App issue many if you may be experiencing. In the meantime you can use a version of the tool by going to this sheet:
File > Make a copy, and save a copy of it in your google drive.
A local copy of the tool will be copied over as well.
It may take a moment to load the tool, but once its loaded, you can go to Add Ons > (QB)² - Question Bank Quick Builder [LOCAL VERSION] and use the app like usual
You may have to authorize the app when trying to navigate the tool
...
You may also get this message:
...
Do not be alarmed by this message. This version of the tool only lives on the spreadsheet you copied. It is not the live tool. Click on Advanced, then click on Go to (QB)² - Question Bank Quick Builder [LOCAL VERSION]
Support
For any questions, bug reports, or suggestions for improvements please email us at support@humnet.ucla.edu
...
Current Version
Release: Version 45.21.1
Released on: 11 05/1714/20202021
Copyright © 2020 2021 The Regents of the University of California.