I have series of multiple choice quizzes in Microsoft word document. This can be changed to HTML or Excel document.
In glossary, I could change excel files to XML by using macro function in excel and I imported to Moodle.
Is there any way I can do the same kind of things with quizzes?
Have a look at...
http://moodle.org/mod/forum/discuss.php?d=19746
which converts to the GIFT import format (a simple text based format). There is a similar thing to do Excel to Moodle XML but I can't find it at the moment!
http://moodle.org/mod/forum/discuss.php?d=19746
which converts to the GIFT import format (a simple text based format). There is a similar thing to do Excel to Moodle XML but I can't find it at the moment!
Thanks. I went to
http://moodle.org/mod/forum/discuss.php?d=19746
And found the link
http://www.soberit.hut.fi/sprg/resources/moodle/GiftConverter.html
And the first instruction was following.
Is there any one tell me how to access toolbars so that I can proceed the process?
Thanks.
http://moodle.org/mod/forum/discuss.php?d=19746
And found the link
http://www.soberit.hut.fi/sprg/resources/moodle/GiftConverter.html
And the first instruction was following.
- Double click on the template and launch Microsoft Word
- Make sure the Moodle toolbar is visible: View -> Toolbars-> Moodle
- Make sure that the style area (See item 14 in the Figure 1) is visible
- Make sure the security settings of MS Word allow you to run the macros, select Tools->Macro->Security... -> Choose security level Medium.
Is there any one tell me how to access toolbars so that I can proceed the process?
Thanks.
Hi Elvis
I know that the thread has moved on from your first post, but if you are still looking for a way to do this through Excel, I will add my spreadsheet which I have been using for this. I have been using it for essay type questions, so it may need a little modification, but the principle is the same.
The first thing that I did was to create a quiz with a couple of questions and then exported it to Moodle XML. Then, viewing it in Notepad, I checked the fields and tags and put together a spreadsheet like the one attached. Basically, you just need to paste in values for the columns which have headings. Column U has the concatenation of all the tags and field values for those tags. Note that the first and last rows have the <quiz> tag to start and end the xml file.
Once you have completed it, copy the used cells in column U, move to another worksheet (in my case "Pasted Concatenations") and do a right-click, Paste Special, Values. This then takes all the formulas out and leaves the values. While this is all still highlighted, copy it and paste it into Notepad.
Add the line: <?xml version="1.0" encoding="UTF-8"?> at the top and Save As "MyQuizImport.xml" remembering to add in the .xml at the end otherwise it won't be recognised as an xml file. Once you have done this, you should be able to import it into Moodle without any problem.
I hope that helps
Peter