Quiz

a new version of the Excel to Moodle XML question exporter is available.
You can now add hints for the questions and the choices, using automatically generated <cite> tags. More info in the manual.

It's still not optimised for Moodle 2.0 as we have not upgrade yet, and I haven't been able to look further into that, but I hope to be able to do that soon...

Two available files: Office 2010 and Office 2003 (haven't tested that one though)

You can download them here:

http://moodle.org/mod/glossary/view.php?id=2741&mode=entry&hook=8061

Ok, as the entry in the exchange course remains hidden for some reason, and just to summarise the system, I'm adding a longer post to the thread.

For those who just want the latest version, here are the DL links:

Download links:
version 2.0.1
version 2.0.1 with possibility to import from 1.3.4 (see below)

I'll probably have to move them soon...If so, I'll add a post with the new links.

Those files are intended to create questions in Excel and export them as Moodle.XML format. I added the possibility to add hints in version 2.0, and fix a stupid bug for shuffle answer default value in 2.0.1...

As some colleagues had done quite a lot of questions this way and had kept the Excel files, I've made a different version that makes it possible to import questions from a version 1.3.x of the excel file, so you can add hints without having to copy/paste all the info.

Here are a few features, more details in the manual in the zip file:
- Supports Multiple Choice, Short Answer, Matching, Ordering and True/False
- Up to 250 questions per question type, up to 10 answers for MC & SA, 20 for matching, 25 items for Ordering.
- Supports HTML in Question Text and all Feedback cells.
- Easily convert Multiple Choice questions in Short Answer questions and the other way around.
- Supports non-English characters and excel line breaks (true UTF-8 export)
- Possibility to automatically add <nolink> tags to prevent auto-linking to glossaries in quizzes.
- Define grades
- Before export, all questions are checked for errors (grades, question name, etc... ) to ensure Moodle compatibility. Errors are explained.
- Manual included
- possibility to add "hints" on the questions (all) and the choices (MC & Matching) (see manual for more info)
- option to hide/unhide feedback & hint fields if you don't want to use them.

I'll try and keep an eye on the thread, so if you have any question/suggestion, or notice any bugs, please post them here.

Hi

I have lost track of this discussion. Sorry for the lack of replies/Updates;

Here is a link to a dropbox folder with the latest versions of the file.

https://www.dropbox.com/sh/d85dfvtb4fo3t06/AABuifGGrmsvoLiywEpKmi6qa?dl=0

You'll find

- one zip file with what I called the "simple hints" version

- one zip file with "CSS hints"

PLEASE bear in mind the hints in those 2 versions DO NOT correspond to the hints system in Moodle. Read the manual for more info;

I am currently working on a new version of the file, which exports formatting (bold, italics, underlined, colours), real moodle hints and tags. It's progressing well (SA & MCQ are done) but I still need to work on Matching and TF, update the manual and improve the layout... We have quite a few things to finish at work at the moment so that might have to wait until.. early August (I hope).

I have included the latest development version as is ("°°NewMacro_XLtoMDL_IN_DVT_...). I'll replace it in the folder as I make progress with it; At the moment, only SA and MC work. I have deleted the "without links to glossaries" option as that can now be sorted with filters in the quizzes.

Tags are NOT exported as I get an error when I try to import XL with question tags into Moodle on our production site. 

Feel free to use it, change it.. I have commented the code as much as possible;

HTH