This article describes how to parse a xml file with SBA questions and create an examination from this sets of questions

TABLE OF CONTENTS


1. Parse Xml-file for questions

  • Open moodle parser moodle-to-excel%20(1).htm (in Chrome)
  • Select an Xml file by clicking the Choose file button
  • Go to single best answer tab
  • Click download excel file, by clicking button Download Excel

2. Ortrac import excel file with sba questions

  • Start ortrac in a web browser
  • Go to Question banking/My questions
  • Click the button Excel import
  • Match the columns:
    • Stem
    • Option 1 - N
    • Answer key
  • First row is header: Yes
  • Import as: Draft (or Published)
  • Available for... select Course
  • Click the Perform Import button

3. Review with examiner

  • Go to the Question banking/Browse
  • In the Include section, select the button Add filter and select Available for... and select the actual <course>
  • Click on a question to review it
  • Click the button Edit to edit the question
  • Click the Save button

4. Publish question (if Draft selected above)

  • Go to the Question banking/My questions
  • In the Include section, select the button Add filter and select Available for... and select the actual <course>
  • Mark all questions by clicking the checkbox for each question
  • Under the section Selected questions, click the button Publish

5. Center setup (more than 1 center)

  • Go to Course/<course occasion>
  • Go to Orzone Tools
  • Go to Centres
  • Click the button Add centre
  • Give the centre a <name>
  • Click the button Save
  • Add more centers if needed (name and Save)

6. Publish course occasion

  • Go to Course/<course occasion>
  • Go to Settings
  • Click the button Publish event

7. Exam setup

  • Go to Course/<course occasion>
  • Go to Exam
  • Click the button Add segment and select Exam
  • Click on the Exam bar:
  • Add a <name>
  • Add a <description>
  • Select no Prerequisite 
  • Click the button Save

8. Exam details

  • Click the button Edit exam
    • Start time: Scheduled start and add <your local time zone> (per center)
    • Duration: <hours & minutes>
    • Question order: Random
    • Feedback: Correct answers
    • Password to start: <startcode 4-6 numbers or letters, in combination>
    • Password to stop: <startcode 4-6 numbers or letters, in combination>
    • Grading scale: Pass/Fail (default)
    • Passmark: 60% (default)
    • Click the Save button

9. Exam layout

  • Click the button/bar Exam layout
  • Numbers of questions: <add the actual number of questions>
  • Click the Save button

10. Add question writer(s)

  • Go to the tab Tasks & roles
  • Go to the dropdown menu Question writers and select extra question writer (creator is question writer per default)
  • Click the tab Questions to work with the selection of questions for the exam

11. Add questions

  • Click the tab Questions 
  • Click the Auto select button
  • Mark all the question by the checkboxes and click the Submit questions

12. Add Students

  • Click the tab Students 
  • Click the Add Student buttons
    • Manually (for a few extra)
    • Import from the course (all/selection)
    • Import from Excel
  • Fix the login code for student, first part of email

13. Publish course occasion

  • Go to Course/<course occasion>
  • Go to Settings
  • Click the button Publish event

14. Publish exam

  • Click the tab Info
  • Click the Publish exam

15. Changes in a published exam

  • Unpublish exam
  • Unpublish questions
  • Change the questions
  • Submit questions
  • Publish exam