CVS quiz import format
-
Hello, could someone please, provide me with a sample cvs file I can modify to BULK import questions to a quiz. I tried creating one from a youtube video but luck. Thanks in advanced. I am attaching the THING i created.
Quiz Title,Quiz description,Write your questions here,Answer Required (0/1),Randomize (0/1),Marks,Show Marks (0/1),Description (Optional),Answer Option1,Upload Image (ID),Answer option view format (1-Text/2-Image/3-both),Answer Option2,Upload Image (ID),Answer option view format,Answer Option3,Upload Image (ID),Answer option view format,Answer Option4,Upload Image (ID),Answer option view format,Answer Option5,Upload Image (ID),Answer option view format,Correct Answer Exam 1,Exam 1 description,A 46-year-old female had a previous biopsy that indicated positive malignant margins anteriorly on the right side of her neck. A 0.5 cm margin was drawn out and a 15 blade scalpel was used for full excision of an 8 cm lesion. Layered closure was performed after the removal. The specimen was sent for permanent histopathologic examination. What are the CPT® code(s) for this procedure?,1,0,8,1,Exam 1 description optional,A. 11626,,1,"B. 11626, 12004-51",,,"C. 11626, 12044-51",,1,"D. 11626, 13132-51, 13133",,,,,,3 ,,,,,,,,,,,"C. 11626, 12044-51",,,,,,,,,,,, ,,,,,,,,,,,"D. 11626, 13132-51, 13133",,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,
-
It’s not a perfect CSV I think, we can’t easily modify the CSV since it have no header. You need to export a sample quiz (with question, answer, and settings) and then duplicate & modify the values.
For example, the True/False question, has this structure of CSV: (total 3 lines except the first line [settings])
settings,"Quiz Title","",0,minutes,,3,80,10,,question_pagination,sorting,,200
question,"Quiz question","<p>Description</p>",true_false,,1.0,1,1,1,1,"Quiz Explanations"
answer,"True",,1,0,true,0
answer,"False",,0,0,false,0
(The answer is True)Generally, the structure for one CSV is like this:
settings,,,,
question,,,,, >question 1
answer,,,,
answer,,,,
question,,,,, >question 2
answer,,,,
answer,,,,
question,,,,, >question 3
answer,,,,
answer,,,,
....and so on....
And every question type have their own structure. Make sure you export all type of question you need.
To edit, you can use Excel formula, like this:
=”settings,””Quiz number “&A1&” – My Quiz Title””,””””,0,minutes,,3,80,10,,question_pagination,sorting,,200″
The topic ‘CVS quiz import format’ is closed to new replies.
