Question formats: Microsoft Word table format (wordtable)
Moodle2Word is a plugin that allows quiz questions to be exported from Moodle into a Word file. The Word file can then be used to quickly review large numbers of questions (either online or in print), or to prepare paper tests (where the answers and feedback are hidden).
Moodle2Word also supports importing questions from structured tables in Word, directly into the Moodle question database. The tables support all the question components (stem, answer options, option-specific and general feedback), as well as embedded images and equations. All the main question types are supported except for Numerical and Calculated.
The Cloze question syntax is particularly useful, as it does not require any knowledge of the arcane Moodle syntax; instead, use bold for drop-down menu items, and italic for fill-in text fields. See attached screenshot for an example.
Word templates to go with the plugin can be downloaded from the demonstration website www.Moodle2Word.net, and are available for Word 2002/XP, 2003, 2007 and 2010 (Windows), and Word 2004/2011 (MacOSX). The Windows templates also support a simple question preview facility, and a facility to upload questions from within Word.
- You need Moodle Administrator rights to install the plug-in.
- You also need read/write access to the /question/format folder in your Moodle installation.
- Check that your Moodle installation supports XSLT (for exporting) and CURL (for importing). Log in as Administrator, go to Site Administration -> Server -> PHP info, and view the PHP configuration. Look for the package details for 'curl' and for 'xsl'. If they are not present, then you will need to re-configure PHP and re-start the server.
- To enable XSLT and/or CURL on your Windows Moodle server, open your PHP configuration file (e.g. d:\winmoodle2\server\php\php.ini) and uncomment the lines containing "extension=php_xsl.dll" and "extension=php_curl.dll" by removing the semi-colon before them, if present.
- For more reliable export to Word, ensure that the PHP Tidy extension is enabled, by uncommenting the "extension=php_tidy.dll" line in the PHP ini file (Windows).
Installation instructions (within Moodle)
- Download the PHP source code Zip file for your Moodle version (click on the Download link above) to your local computer, and note its' location.
- Log in to your Moodle server as Administrator, and go to Site Administration > Plugins > Install add-ons.
Click on the link "Install add-on from ZIP file", and in the Plugin type drop-down field, select "Question import/export format (qformat)". Moodle should then tell you if the folder is writable. If it isn't, you will need to fix it before proceeding.
(Note that for reasons unknown, installing this plugin by clicking on the "Install add-ons from the Moodle plugins directory" button won't work.)
- Click on the "Choose a file..." button in the "ZIP package" field, and select the downloaded Zip file, then check the "Acknowledgement" box, and click the "Install add-on from the ZIP file" button.
- Moodle validates the package and displays the results. Click on the "Install add-on!" button.
- Moodle displays the list of plugins to be installed. Click the "Upgrade Moodle database now" button.
- Moodle should display a success page, and redirect you back to the Administration page.
- Go to any course, and select a question bank that contains at least 1 question.
- Use the Moodle Question Export page to export a Word file. You should see a new item in the File format list, 'Microsoft Word table format'. Select this item, and choose any question category containing some questions.
- You should see the list of question names, and be prompted to save or open a Word file, or else you should click on the link at the bottom of the page.
- If you see the error message "You need the XSLT library installed in PHP to save this Word file" (xsltunavailable in non-English installations), then your Moodle configuration is not configured to support exporting to Word format, and you will need to update it. See this forum thread.
- Regardless of whether the export to Word facility works, use the web-based facility to import a Word file. You should see a new item in the File format list, 'Microsoft Word table format'. Select this item, and choose any Word file, it doesn't matter what format.
- You will be redirected to the registration page, and prompted to register your installation. Most fields are filled in automatically, but you must choose a password.
- Submit the form, and you should see a "Registration successful" message in a few moments. You will then be redirected back to the question import page.
- Install the appropriate Word template (guest login required) on your PC, and create a question file. Use the question import form to upload and convert the Word file.
- If all goes well, your questions should be imported into your course. If not, send me an email at firstname.lastname@example.org and I will try to help you out.
- After you complete the registration process successfully, you will be able to import questions in Word tables into Moodle.
- There is no limit to the number of questions that can be exported into Word format.
- When Cloze questions are exported into Word format, the Cloze notation is used for word placeholders, not the nice formatting (bold/italic) used when importing questions.
- The Word to Moodle question import facility converts a maximum of 5 questions in a single Word file by default. Register the plugin after installation to increase this limit to 10 questions. You may purchase an annual subscription (€200) to remove this limitation on your own Moodle site. To avoid any charge, just use the www.Moodle2Word.net website to import unlimited numbers of questions, then export them as XML files, and import the XML file into your own Moodle site.