How do I import a test bank from Cengage into Moodle? [Moodle version 3.2]

Each publisher has different methods. These steps below are for Cengage to Trinity’s Moodle 3.2, as of January 2018.

Note: you can click on any image to view a larger version of the image.

  1. Login to your existing account on Cengage.com.
  2. Select the textbook in question.
  3. Scroll down to the “Access Instructor Resources” section and click on the link for the “Instructor Companion Site.”
  4. NOTE: In theory, you should be able to click the “Test banks” link under the “Book Resources” (instead of the chapter resources) section and download the full test bank there. However, as of January 2018, none of these files would import properly into Trinity’s Moodle, so these steps are the workaround for that.
  5. From the drop-down menu at the top of the page, select the chapter whose questions you wish to download.
  6. With the chapter selected, click on the link for the “Test bank Blackboard/D2L/Canvas/Moodle” in the left column.
  7. With the screen displaying all of the test bank downloads for that chapter, click on one of the zip files to download that section. NOTE: Each web browser downloads files in a slightly different way. These instructions are in Google Chrome.
  8. Once the file is downloaded, open Moodle. Login and go to the main page for the course into which you wish to import these questions.
  9. From the main page of your course, click on the gray ‘edit’ gear wheel in the upper right corner.
  10. From the drop-down menu which appears, click on the “More…” option at the bottom.
  11. On the “Course Settings” page, scroll down to the “Question bank” settings section.
  12. Click on the “Import” link in the “Question bank” section.
  13. Then on the “Import” page, under the “File format,” select the “Blackboard” option.
  14. Under the “Import questions from file” section, drag the downloaded, zipped file and drop it in the dotted box.
    NOTE: You can also click on the “Choose a file…” button and search for the file to upload this way too. The drag-and-dropping simply saves time.
  15. Once the file is displayed, click the “Import” button.
  16. The system will parse out any questions from the zipped file. If there are a lot of questions, the import parsing will take longer than if there are only a few questions.
  17. Once the questions are successfully parsed out, you will see two green notifications at the top of the page, with the beginning of all of the questions displayed underneath them.
    NOTE: If there’s an error, you will received a red highlighted message instead.
  18. Once all of the questions are parsed out, scroll down to the very bottom of the page and click the “Continue” button.
  19. This will bring you to the imported questions as they are in the “Question bank.”
  20. You can edit the individual question, copy the question, preview the question, and delete the question with the icons to the right of the “Question” column.
  21. To get back tot he “Import” page and import the next downloaded, zipped file, click the “Import” tab at the top of the main section.

Once your questions are imported, the icon to the left of the “Question” column will indicate what type of question it is.

A small piece of paper indicates an “Essay” question type. These questions would be manually graded b the instructor.

Two side by side dots indicate a “True/False” question type.

Three dots with lines after them stacked vertically indicate a “Multiple Choice” question type.