Importing from Excel

Importing from Excel

wót Joe Griffin -
Anzahl Antworten: 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 traurig

Joe
Als Antwort auf Joe Griffin

Re: Importing from Excel

wót 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
Als Antwort auf colin melville

Re: Importing from Excel

wót 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
Als Antwort auf Joe Griffin

Re: Importing from Excel

wót 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

Als Antwort auf Joe Griffin

Re: Importing from Excel

wót Howard Miller -
Nutzerbild von Core developers Nutzerbild von Documentation writers Nutzerbild von Particularly helpful Moodlers Nutzerbild von Peer reviewers Nutzerbild von 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 lächelnd