Microsoft Word File Import/Export (Question Format)

Question formats ::: qformat_wordtable
Maintained by Eoin Campbell
Import questions (including images and equations) from structured tables in a Word file (.docx format) into a course question bank, and also export questions to a Word file, allowing for round-trip editing.
Latest release:
4376 sites
1k downloads
183 fans
Current versions available: 6

This plugin allows quiz questions to be imported from a Word file into Moodle. You can quickly write lots of questions in structured Word tables far more easily than in Moodle directly. The plugin also imports tables, images, and equations (when created using the Microsoft Office Equation Editor, not MathType/Wiris or the old Equation 3.0 editor). Equations are converted into MathML on import and displayed using the MathJax filter. You can also export questions from the Moodle question bank into structured tables in Word. 

The table structure for each question supports all the question components (stem, answer options, option-specific and general feedback, hints, tags and question meta-data such as penalties, grades and other options). All the main question types except Numerical and Calculated questions are fully supported. Numerical and Calculated questions are exported, but cannot be imported.

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.

Language support

Exported questions are labelled in the language of the current Moodle user interface, and the spell-check language is also set to the correct language. Similarly, questions can be imported in the same language, not just English. Both left-to-right and right-to-left languages (such as Arabic and Hebrew) are supported.

Equation support (import only)

Equations written using the Microsoft Equation Editor in Word can be imported into Moodle as MathML. This MathML is rendered within Moodle using the MathJax filter. Note that MathML equations in questions are not exported in a usable way.

Supporting Word templates

Word templates to go with the plugin can be downloaded from the demonstration website www.Moodle2Word.net, and are available for Word 2007 and 2010 (Windows), and Word 2011 (MacOSX).

Installation

The plugin can be installed by a Moodle Administrator using the standard Moodle plugin installation process.

Pre-requisites

  • Check that your Moodle installation supports XSLT, and ideally HTMLTidy too. Log in as Administrator, go to Site Administration -> Server -> PHP info, and view the PHP configuration. Look for the package details for 'xsl'. If they are not present, then you will need to re-configure PHP and re-start the server.
  • To enable XSLT and HTMLTidy on a Windows Moodle server, open your PHP configuration file (e.g. d:\winmoodle2\server\php\php.ini on Windows) and uncomment the lines containing "extension=php_xsl.dll". and "extension=php_tidy.dll" by removing the semi-colon before them, if present.
  • On Linux platforms, you may need to create a symbolic link from the file , /etc/php5/apache2/mods-available/xsl.ini to , or /etc/php5/apache2/conf.d/20-xsl.ini. Change directory to /etc/php5/apache2/conf.d/, and use the command 'sudo ln -s ../../mods-available/xsl.ini 20-xsl.ini'. Alternatively, create a file /etc/php5/apache2/conf.d/xsl.ini containing the line
    extension=xsl.so
      

Configuration instructions

  1. Go to any course question bank that contains at least 1 question, and choose the Export option.
  2. The File format list should contain the new option 'Microsoft Word table format'. Select this item, and choose any question category containing some questions.
  3. You will be prompted to save or open a Word file. Save it. By default it should have a .doc suffix. If no suffix is provided, you must add it in yourself to ensure Word recognises the file format.
  4. 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 installation is not configured to support exporting to Word format, and you will need to update it. See this forum thread.
  5. To import questions from a Word file, open the file you just exported, and save it to Word 2010 (.docx) format. Then go to the Question Import form, and you should see a new item in the File format list, 'Microsoft Word table format'. Select this item, choose the Word file you saved, and import it.
  6. If all goes well, your questions in the file should be imported into your course. If not, send me an email at help@moodle2word.net and I will try to help you out. 

Limitations

  • The number of questions you can import in a single Word file is limited by the amount of memory allocated for processes on your Moodle server, but should be at least 1,000 questions or more.
  • When you export questions they are saved in an intermediate Word-compatible format in a file with a .doc suffix. You must then save the file to the standard Word format (with a .docx suffix). 

Using a Word template to create and edit questions

To edit existing questions using Word, first export them into Word. If you want to create new questions, you should install a custom Word template on your PC to assist you. You can download this template from the test website www.Moodle2Word.net. This template contains commands to create new questions by means of inserting a specific structured table for each type.

Screenshots

Screenshot #0

Contributors

Eoin Campbell (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Comments

  • Zonggen Zeng, Ningbo Polytechnic, Ningbo City, Zhejiang Province, China
    Tue, 5 Apr 2022, 10:25 PM
    help!!!
    when I import a *.docx from [Microsoft Word 2010 table format (wordtable)],I cannot import the docx files, I receive this information: The file you selected is not in UFT-8 character encoding. Microsoft Word 2010 table format (wordtable) files must use UTF-8.
    my version is:

    qformat_wordtable_moodle311_2022040400.zip
    booktool_wordimport_moodle311_2021083100.zip
    moodle version: 3.11.6+

    please help me ,please!!!
  • Eoin Campbell
    Tue, 5 Apr 2022, 11:18 PM
    Can you try importing the file to www.moodle2word.net (and see if it works. You need to register for an account first. If it doesn't, send me the Word file you are trying to import (to help at moodle2word.net)
  • Cobus van Loggerenberg
    Wed, 20 Apr 2022, 1:55 PM
    Hi Eoin, when I export to "printout for review" I see in the downloaded file that it does not start the answers from "a." but has a full-stop for the first answer then it follows with "a. b. c. etc.". Example
    . (0%) HPU
    a. (100%) Energy Meter
    b. (0%) VIP
    c. (0%) VIP Water
    d. (0%) Furnace Water
  • Eoin Campbell
    Wed, 20 Apr 2022, 7:33 PM
    Can you tell me the version of Moodle, Microsoft Word, and the plugin that you are using? Also, which particular question type is affected? I can't reproduce this problem with Multiple Choice or All-or-Nothing Multiple Choice questions.
  • Minh Nguyen Ba
    Mon, 9 May 2022, 11:01 AM
    We are using this plugin v3.9.4, and got issue when export question with equation to word file. The formulas in word file are in correct. How to fix this?
  • Eoin Campbell
    Tue, 10 May 2022, 5:45 PM
    The plugin doesn't support the export of equations back into Word at the moment.
  • moodle 調査用
    Wed, 20 July 2022, 1:38 PM
    Hello Eoin!
    I'm having problems with the multiple choice question.
    After importing questions, some questions doesn't show some parts of sentences or be attached unuseful link.
    My moodle version is 3.11.7+.
    Please help me.
    Thank you.
  • Eoin Campbell
    Wed, 20 July 2022, 11:16 PM
    It sounds like the formatting in the Word file may include a style name such as "Macro Comment" which is not converted. Send the Word file to me at help@moodle2word.net and I can take a look.
  • Stoyan Drenski
    Mon, 29 Aug 2022, 7:34 PM
    Dear Eoin, first of all thank You for this plugin which makes our life much easier! However I am stuck with an issue when trying to 'Export book to Microsoft Word'(Error message: 'XSLT transformation failed'). Going one step down to 'Export this Chapter to Microsoft Word' works for all but one Chapters of the same book. Trying to export this specific chapter of the book returns same error: 'XSLT transformation failed'. Please advise what else should I try? Thanks in advance.
  • Eoin Campbell
    Mon, 29 Aug 2022, 9:38 PM
    You could try editing the chapter of the book directly inside the Moodle editing interface and getting the editor to save it. There is probably some faulty HTML that is causing a problem, and the editor sometimes will automatically clean it up when it is saving it. If that doesn't work, turn on direct HTML editing (in the Atto toolbar, expand to include all icons, then click the very last icon in the 2nd row). Copy the raw HTML to an online cleanup tool like htmltidy.net to get it cleaned up, then paste it back into the book chapter.
  • Simone Mura
    Mon, 14 Nov 2022, 10:46 PM
    Hi Eoin,
    Is there any plans to translate the Moodle2Word Word template for portugues - Portugal?
    Thanks in advance
  • radiyanto dekaprasetya
    Wed, 7 Dec 2022, 8:07 AM
    help!!!
    when I import a *.docx from [Microsoft Word 2010 table format (wordtable)],I cannot import the docx files, I receive this information: The file you selected is not in UFT-8 character encoding. Microsoft Word 2010 table format (wordtable) files must use UTF-8.
    my version is: Moodle release (4.0)
  • Eoin Campbell
    Wed, 7 Dec 2022, 5:36 PM
    Hi radiyanto, Are you sure you selected a real Word file, and not a temporary lock file beginning with a ~ (tilde) character? This is an easy mistake. Another possibility is that you created the Word .docx using an application other than Microsoft Word (e.g. Google Docs). Send me the file and I can take a look.
  • Artech Artech
    Tue, 13 Dec 2022, 8:06 PM
    Hello Eoin, I wanted to ask whether right-to-left word templates are also available to download for this plugin?
    Thank you very much!
  • Eoin Campbell
    Thu, 15 Dec 2022, 12:34 AM
    Yes, I have some right-to-left templates that work, e.g. Chiness. What language do you want?
Please login to post comments