Importing from Excel

Importing from Excel

by Joe Griffin -
Number of replies: 5
I'm just starting on this activity module. I have a spreadsheet with over 350 MCQ. Is there a way I can import these or do I have to re-type them all sad

Joe
Average of ratings: -
In reply to Joe Griffin

Re: Importing from Excel

by colin melville -
thoughtful Easiest way would be to create a word document with GIFT tags. This can be linked to your spreadsheet using mail merge to convert to GIFT format. You will still need to edit each question to show correct answers, but if there is a single correct answer this should not take long. big grin
In reply to colin melville

Re: Importing from Excel

by Joe Griffin -
Thanks Colin. Can you tell me where I can find out more about the GIFT tags and how to do what you suggested? Can't find anything in Word help on GIFT.

Joe
In reply to Joe Griffin

Re: Importing from Excel

by Roger Purdie -

Joe - here is the link to the GIFT doco.

I only started to use GIFT last week myself and it's very simple and saves a lot of time (as you can work outside Moodle a lot faster).

http://moodle.org/file.php/5/moddata/forum/121/18730/gift_documentation.html

In reply to Joe Griffin

Re: Importing from Excel

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Did any application in particular generate the Excel file? If it is common enough it may be worth writing an import routine - especially if you would be happy to test it smile