MS Word Template for Importing Quiz

Hello,

I have 7.200 multiple-choice (ABCDE) questions, already used in a Moodle website. There is only one correct answer for each question. I wanted to import these questions into WordPress and, as an import method is still missing for Wp-Adv-Quiz, I decided to develop my own “primitive” way of doing this.

As I stated, each test consists of 80 multiple-choice questions (ABCDE) with only one correct answer. Therefore, the template is also for 80 questions (Download here). Next. I converted all 80 questions into a table – this was easy because of Moodle formatting. Then, manually, I copied and pasted each field for “Question”, “Choice A”, etc. into the relevant columns in the template. (To test how this works yourself, you can try the sample file – all questions are the same.) Of course, you should delete the first row in both tables (words in red) before you start the copy-paste task.

There are a couple of things to do in the question file. All quotations marks (” “) should be removed or replaced with apostrophes (‘ ‘). All instances of / should be replaced with \/. Also, it is very important that all items (question, choice ABCDE, and whether they are correct or not) appear in correct columns in the table. Also, the “title” column can be left blank or you might want to add separate titles for each question one by one – unless you already have question titles in your question table.

Then, on the template file, I converted the table into a text with tabstops. The rest is easy. You remove all tabstops and all paragraph ends.

Next, you need to convert this into a “json” file. I found “jsonformatter.org” to be quite useful for this purpose – if there is a mistake in the text, this is displayed. One typical mistake I had in two files was that the “false” script had not been added to three questions beforehand (so “correct”, was marked as a mistake in that website). Once the text is converted, you should download the file and change its extension from .txt to .json. Now you can import these questions into WordPress with WP-Adv-Quiz.

You might find these steps unnecessarily long, but I have already imported six tests – 480 questions – in a few hours and this is much shorter than when I might have attempted to add these questions one by one.

If you intend to use the template, you can add or remove as many rows as you want – but DO NOT remove the very LAST row. Also, you can remove one or more of the choices – you might have only ABCD, for example – but, once again, make sure that you do not accidentally delete the very last column with script on it.

• This topic was modified 4 months, 1 week ago by Hakan Gür. Reason: Writing mistakes