Skip to content

Export tests

Whoever wants to back up, pass on, have reviewed or evaluate a test exports it from OpenOlat. What you export depends on what you need:

  • Course: the entire course with its tests, for example an exam course, see Export course.
  • Test learning resource: the test with all questions and its configuration, as a zip file, as a Word document or as exam sheets on paper, see Export test learning resource.
  • Questions: single questions to the question bank or as a file for another system, see Export single questions.
  • Results: the test statistics and the results of the participants, see Export test results.

Export course

Whoever wants to back up an entire course, for example an exam course, or import it into another OpenOlat exports it as a zip file. You start the export under:
Course > Administration > Export content

Owners of the course always find the menu item. Other authors only see it if the owners have allowed exporting in the tab "Share", see Access configuration.

Menu item Export content marked in the open Administration menu, which exports the entire course as a zip file

To the top of the page ^


Export test learning resource

A test learning resource contains all questions of a test including its configuration, for example the total number of points, and can be integrated into "Test" course elements. Whoever wants to back up the test without a course or import it into another OpenOlat exports the test learning resource as a zip file. You start the export in the administration of the test learning resource under:
Test > Administration > Export content

Here too, owners always find the menu item, other authors only if exporting is allowed in the tab "Share".

Menu item Export content marked in the open Administration menu, which exports the test learning resource as a zip file

Tip

Please note whether you have opened the administration of a course or of a test learning resource. In the course, the editor entry is called "Course editor", in the test learning resource "Test editor".

To the top of the page ^


Export to Word

Whoever wants to have a test reviewed before it is conducted exports it as a Word document. Additions and corrections can be easily noted in it. With Test > Administration > Export to Word OpenOlat downloads a zip file with two Word documents: one contains only the questions, the other also the solutions. Both state the title of the test, the passed cut value if the test defines one, the sections and every question with question type and score, each question on a page of its own. The menu item is available to owners of the test learning resource, learning resource managers and administrators.

Menu item Export to Word marked in the open Administration menu, which downloads the test as Word documents

To the top of the page ^


Export handwritten exams

Whoever conducts a test on paper creates print-ready exam sheets with serial number, solution sheet and, if desired, a cover sheet via Test > Administration > Export handwritten exams, see Test: Export handwritten exams.

To the top of the page ^


Export single questions

Whoever wants to use a question in further tests or exchange it with another system exports it individually. Questions in OpenOlat comply with the QTI standard (Question and Test Interoperability). This means they can also be transferred to other LMS (learning management systems) that use this standard. Conversely, OpenOlat imports questions in QTI format.

Export to pool

If a question from a test should also be available in the question bank, transfer it there from the test editor. In the test editor of the test learning resource, select the desired question and click on the icon with the 3 dots in the upper right corner. With "Export to pool" you transfer the question to the question bank. The entry appears if the question bank is enabled in your OpenOlat.

OpenOlat creates a new question with its own ID in the question bank. The question in the test and the question in the question bank are then independent of each other. How questions get from the question bank into a test is described under How do the questions get into a test?

Menu with three dots at the top right of the question with the entry Export to pool marked

Tip

This way, you also export an entire section with all its questions to the question bank. To do so, select the section on the left and click on the 3 dots.

To the top of the page ^


Export single questions from the pool

Whoever wants to pass on a single question or use it in another system exports it from the question bank as a zip file. Open the question in the question bank and select the entry "Export" under the icon "Share". The zip file can be imported into another OpenOlat or into another LMS that uses the QTI standard.

Share icon with the open entry Export marked, which exports the question as a zip file

To the top of the page ^


Export multiple selected single questions from the pool

Whoever wants to pass on, examine offline or archive several questions at once exports them together. Select the questions in the list of the question bank and click on "Export" above the list.

Three selected questions in the format IMS QTI 2.1 and the Export button above the list marked

In the dialog "Export" you choose the format in the step "Type": a Word file for offline exams including the master sheet, a QTI 2.1 test file for exchange with other compatible LMS or a ZIP file for exchange with other OpenOlat systems or for archiving. Word and QTI 2.1 can only be selected if at least one of the selected questions is in the format QTI 2.1; otherwise the list only offers the ZIP file. Which questions can be exported in the chosen format is shown in the step "Review" in the column "Can export".

Selection list Type with the three formats Word file for offline exams, QTI 2.1 test file for other LMS and ZIP file for other OpenOlat systems or archiving

To the top of the page ^


Export test results

You receive the results of a test in two ways: The test statistics show the evaluation directly in OpenOlat, the export of the test results delivers the results of the participants as a file for evaluating, printing or archiving.

Test Statistics

Whoever wants to know how a test turned out sees the key figures of the whole test and of each individual question in the test statistics. For a single test, use the button "Test Statistics" in the course element "Test". The button is available to coaches and owners. You find it under:
Course > Course element "Test" > Tab "Participants" > Button "Test Statistics"

You find the evaluation of all tests of the course under Course > Administration > Test statistics, see Test statistics.

Finding the Test Statistics button: course element Test in the course menu, tab Participants and button Test Statistics marked

With "Print" you print out the statistics or save them as a PDF file via the print dialog. With "Download raw data" you receive the raw data as an Excel file. If you expand the sections of the test on the left, you see the detailed statistics of each individual question.

Buttons Print and Download raw data, on the left the expandable section, on the right the key figures of the test and the score distribution chart

Test results of participants

Whoever wants to evaluate, print or archive the results of a test receives a zip file with all test results of all participants in the selected course element via the button "Export results". The button is available to coaches and owners. You find it under:
Course > Course element "Test" > Tab "Participants" > Button "Export results"

Finding the export of test results: course element Test in the course menu, tab Participants and button Export results marked

If you have selected individual participants in the list, the export only covers their results.

On the page "Export results", the row "Number of participants" shows how many persons the export covers. There you give the zip file a name and choose the variant for its contents under "Export":

  • "Standard": The zip file contains the detailed test results for each participant as an HTML document and an Excel file with the raw data.
  • "Advanced – with PDF": The zip file contains the same and additionally a PDF file with the detailed results for each participant. This variant can be selected if the PDF Service is enabled in the system administration.

OpenOlat suggests a name with variant and date, for example "Test results with PDF - all participants (10/1/2026)".

Variant "Advanced – with PDF" selected, below it the Additional option with both checkboxes, marked together with Name and the Start export button, so you see everything you set before the export

With the variant "Advanced – with PDF", the "Additional option" with one or two checkboxes appears below:

  • "Separate PDF file for each essay question" can be selected if the test contains essay questions. If it is activated, OpenOlat additionally places the answer to each essay question in the zip file as a separate PDF file.
  • "All PDF files in one folder" can be selected for every test. If it is activated, the PDF files with the detailed results of all participants are placed together in one folder of the zip file. How the files are named and where they are located is described under PDF files in the zip file.

With "Start export" OpenOlat generates the zip file containing the test results. As soon as the export is complete, OpenOlat notifies you by email.

The created zip files are listed below in the "Export history", each for 10 days. Unzip the zip file to access the individual files.

PDF files in the zip file

Whoever prints, files or passes on exported results can tell from the file name which person and which test a PDF file belongs to. The name is made up of these parts, each separated by an underscore:

  1. Last name of the participant. If no last name is recorded, it reads "anonym".
  2. First name of the participant.
  3. Title of the course element, shortened to 25 characters.
  4. Title of the test learning resource, shortened to 25 characters.
  5. A number that uniquely identifies the test attempt.

Spaces become underscores, umlauts are transcribed ("ü" becomes "ue"), other special characters are dropped. An example: Langenegger_Simone_Test_Demo_Test_Demo_Master_13730.pdf.

Where the PDF files are located in the zip file is determined by the option "All PDF files in one folder":

  • Off: Each PDF file is located in the folder of the participant, there in the subfolder of the respective attempt. The results of one person thus stay together.
  • On: All PDF files with the detailed results are located together in the folder "resultspdfs". This way, the results of all participants can be printed or passed on without searching the subfolders.

In both cases, the folders of the participants with the HTML document and the raw data remain, and the links in the HTML documents of the zip file lead to the respective PDF file. The PDF files from the option "Separate PDF file for each essay question" always stay in the folder of the participant.

The option "All PDF files in one folder" is only available for the export via the "Export results" button. The course archiving always places the PDF files in the folder of the participant, with the same structure of the file name.

Score columns in the Excel file

Whoever evaluates the results sees in the Excel file with the raw data which part of the points comes from the answer and which from a later correction. For each test run, the file contains these columns:

  • Score: the result of the test run.
  • Score (auto): the sum of the automatically calculated points.
  • Score (adjustments plus): the sum of all adjustments that add points.
  • Score (adjustments minus): the sum of all adjustments that deduct points, as a negative value, for example "-0.5".
  • Score (manual): the sum of the points awarded by hand for questions.

For each question, the column "Score" contains the score of the question. For automatically corrected questions, it is followed by the column "Adjustment" with the amount by which the points were adjusted. How an adjustment is made is described on the page Assessing tests. You receive the same Excel file in the test statistics via "Download raw data".

Sheet "Export information"

Whoever processes exported raw data further or stores it outside OpenOlat recognises from the sheet "Export information" which course and which course element the file comes from, and when and by whom it was created. The sheet is the last sheet in every Excel file with test results, whether the file comes from "Export results", from "Download raw data" in the test statistics or from the course archiving. It has the columns "Information" and "Value" and these rows:

Row Content
URL Link to the course element in the course. The link takes you from the file directly back to the test.
OpenOlat Version Version of OpenOlat with which the file was created.
Course title Title of the course.
Course reference Reference of the course. If the course has no reference, the ID of the course is shown here.
Course element title Title of the course element.
Course element ID Number of the course element. The same number is at the end of the URL. It identifies the course element unambiguously, even if its title changes later.
Export language Language of the person who started the export, as a written-out name, for example "German".
Exported Date and time of the export.
Exported by Name of the person who started the export. The row stays empty in archive files that OpenOlat creates itself, for example when deleting the test data in the course element with "Delete all data".

If the test does not belong to a course, for example in the test statistics of a standalone test learning resource, "URL", "Course title" and "Course reference" refer to the test learning resource. The rows "Course element title" and "Course element ID" are then missing.

Note

You also export test results via the archiving of the course under Course > Administration > Archiving & Reporting, see Archiving test results.

To the top of the page ^


Further information

Mentioned on this page
Access configuration >
Test: Export handwritten exams >
Creating Tests >
Test statistics >
External Tools: Overview >
Assessing tests >
Course Administration: Archiving & Reports >
Evaluate and manage tests >

Further
Course Element "Test" >
How do I proceed when I create a test? >
Test editor >
Test question types >
Configure test questions >
Configure tests >
Test: Settings >

To the top of the page ^