Itamar Tzadok

The standard way in recent versions is to backup the quiz activity without user data and then restore it to the course 'adding data to existing course'.

Actually Moodle has a highly flexible solution (or workaround) for that. It is the core database activity and it allows for creating interfaces for various tasks including creating import code in XML and other formats. That's the only kind of finishing I can appreciate in a project because it is an open-ended finishing which allows me to write my own ends. See an example of such an interface below. At the top is the list view of the database activity. You can select which items to process and then create the import XML code which you then dump into a txt file and import. At the bottom of the image is how one of these questions looks like in the question bank. I use this approach mainly for non-standard questions where Excel formulas cannot do the job, but I've also built such interfaces for standard MC questions so as to allow a colleague to fix typos in her hundreds of MC questions more efficiently. I usually write the basic data in Excel, upload it to the database where I use scripts to process the data and create the questions' code and then I import the questions into the questions bank. Once such an interface is ready it can be used by anyone to create or update questions, it can be easily transferred from one Moodle course to another or placed in a repository course site and of course it can be easily tailored to specific requirements.

You can export a few such questions to see what the XML of these questions looks like.

It should be in the gradebook, 'Choose an action' -> 'Categories and items', where you can edit the hierarchical structure of the categories and items and thereby determine the order of display in the grader report.

Write a few such questions in Moodle, then export them in one of the available formats (personally I like Moodle XML). If the export file can be used to import the questions back to Moodle (I haven't tried yet with this question type) you can construct an excel sheet to create the questions code in the chosen format which you can then import.