(QB)2, or the “Question Bank Quick Builder,” is a Google Sheet Add-on developed at UCLA’s Humanities Technology to reduce the labor for instructors creating digital assessments. By translating text content from a properly formatted spreadsheet into XML, (QB)2 makes it much easier for instructors to create Moodle quizzes.
Instructors can write their questions and answers in plain text, all visible and editable on a single page, which cuts down question creation time and reduces the risk of duplicate or improperly formatted questions. As it is Google based, (QB)2 handles non-western characters easily.
Once complete, (QB)2 transforms this content into an XML document, which the instructor can then easily import into Moodle to build their quizzes.
This tool was developed by the following team at UCLA
- Lillian Hawasli, Humanities Instructional Programmer
- Thomas Garbelotti, Humanities Instructional Technology Manager
- Benjamin Niedzielski, Research and Instructional Technology Consultant
- Amy Zhao, Student Programmer
- Jakin Wang, Student Programmer
- Rockford Mankini, Student Programmer
You can install (QB)2 from the G-Suite Marketplace, or install directly from the Google Sheet by going to Add-Ons > Get add-ons from within an existing Google sheet.
You can set up the spreadsheet template by going to Add-ons > (QB)² – Question Bank Quick Builder > Set up (QB)2 spreadsheet.
Alternatively, you can make a copy our (QB)2 templates. To save a copy of the file in your Google Drive, choose: File > Make a copy.
Step by step video tutorials can be found here
- How to set up (QB)2: https://www.youtube.com/watch?v=J7Pf7bRklSw
- How to use (QB)2 – Spreadsheet: https://www.youtube.com/watch?v=TaZI7H-0J5Y
- How to use (QB)2 – Guided Sidebar: https://www.youtube.com/watch?v=pDoDLcDc9D0
- Export your questions from (QB)2, and import into UCLA’s CCLE: https://www.youtube.com/watch?v=Jp4nb2g_xM4
- Export your questions from (QB)2, and import into other Moodle (Vanilla) instances: https://www.youtube.com/watch?v=XU0IxTE9gMs
- Export your questions from Moodle (or CCLE), and import into (QB)2: https://www.youtube.com/watch?v=6KjIL-GrgH4
© 2020 The Regents of the University of California