I am trying to improve my experience creating quizzes in a online gradebook course management software called D2L. This software has a CSV template for importing quizzes. The template has many types of questions, with specific rows and text for each question type. I only use three question types. I am fairly certain that if I can get started with a macro for one of the types, I can figure out the rest. The way I currently do this is when I want to add a question to the quiz, I copy the rows including two blank lines at the bottom from my template and then Insert Copied Cells where I want the question to appear. That works fine, but I know it can be faster.
I imagine my workflow will be to select the row where I want to insert these populated rows, and then run the macro.
This is a screen shot of the data in Excel.
6AD0513F-F71F-4378-998E-EAAEB72A8C22_4_5005_c.jpeg
This is the data in CSV form:
NewQuestion,MC,,,
QuestionText,This is the question text for MC1,,,
Option,0,This is the correct answer,,
Option,0,This is incorrect answer 1,,
Option,0,This is incorrect answer 2,,
Option,0,This is partially correct,,
Feedback,This is the feedback text,,,
,,,,
,,,,
Bookmarks