MTestM is an exam creator application that allows you to create, take and share exams. Creating an exam has never been easier. You can add different types of questions on an Excel spreadsheet.

1. Create a spreadsheet in Excel

The spreadsheet should conform to the below general format. You cannot change the labels for the exam and the column headers for the questions.

Common column headers and their aliases are as follows:

2. Enter the basic information for the exam

The basic information for the exam includes the title, description, and answering duration. These fields are optional. Field descriptions are as follows:

• Title: The title of the exam.
• Description: Descriptive information about the exam, providing additional context or background.
• Duration: The answering time limit in minutes, used to restrict the exam duration.

3. Enter a single-choice question

• Question: The main content or stem of the question.
• Option: The answer choices or alternatives for the question.
• Answer: The correct option. Use A, B, C, D, or 1, 2, 3, 4 to specify the correct answer.
• Explanation: An optional field used to explain why the selected answer is correct. This explanation will only be shown to the exam taker after they have answered the question.
• Point: The score awarded for a correct answer. If the answer is incorrect, the score will be 0.

The type for choice questions can be set to "choice" or "c", or it can be left unset for automatic detection by the system.

Please note that the choice options are shuffled by default. If you want to keep the order of all choices fixed, set the Type to "ordered choice", "fixed choice", "oc", or "fc".

This is how the question is displayed in the app.

4. Enter a multiple-choice question

The answer to a multiple-choice question consists of multiple options. You can separate the options using symbols like commas or spaces, such as "A,B,C" or "B D". Alternatively, you can input them without any separators, such as "ABC" or "BD".

Full points are awarded only if all correct options are selected. No points are given for incorrect or partially correct answers.

This is how the question is displayed in the app.

5. Enter a fill-in-the-blank question

A fill-in-the-blank question can have one or more blanks. For each blank, you need to provide the correct answer and optionally assign a score.

The answers and scores can be provided in multiple columns or in a single column. If using a single column, separate the correct answer and score with "^^"

The Type for fill-in-the-blank questions can be set to "blank", "fill in blank", "b", or "fib", or it can be left unset for automatic detection by the system.

This is how the question is displayed in the app.

The answers for fill-in-the-blank questions are not case-sensitive by default. If case sensitivity is required, set the Type to "case sensitive blank" or "cb".

If a blank has multiple correct answers, you can separate them using "||" or "|||". For example, the following blank has multiple correct answers.

6. Enter an unordered fill-in-the-blank question

An unordered fill-in-the-blank question means that the answers do not need to follow a specific order. For example, if the correct answers are {"100", "200", "300"}, then responses like {"300", "100", "200"} or {"200", "300", "100"} are all considered correct.

The Type for this question should be set to "unordered blank" or "unb". If the answers are case-sensitive, set the Type to "unordered casesensitive blank".

This is how the question is displayed in the app.

7. Enter a true/false question

The answer for a true/false question can be "t", "f", "y", or "n".

The Type can be set to "true false" or "tf", or it can be left unset for automatic detection by the system.

This is how the question is displayed in the app.

8. Enter a one-or-more-choice question

A one-or-more-choice question is similar to a multiple-choice question, where one or more of the given options are correct. However, unlike a multiple-choice question, a one-or-more-choice question awards points even if only one correct option is selected. Incorrect answers earn no points.

For this question type, there are two scoring values:

• point1: The score awarded for selecting all correct options.
• point2: The score awarded for selecting some correct options.

The Type for this question should be set to "one or more choice" or "omc". Please note that the choice options are shuffled by default. If you want to keep the order of all choices fixed, set the Type to "ordered one or more choice", "fixed one or more choice", "oomc", or "fomc".

9. Enter a spelling correction question

A spelling correction question requires identifying and correcting spelling, grammatical, or other errors in a sentence. Each question can include up to 20 sentences that need correction, which should be entered in the options column.

The Type for this question can be set to "spelling correction", "spell correction", or "correction".

This is how the question is displayed in the app.

10. Add a Section

If there are many questions, you can add sections to organize them into groups.

Each section should occupy a single row. The section title should be entered in the section column, and the section content should be entered in the question column.

11. Add Images

If a question includes images, you can insert the images into the Excel file. Here are the specifics:

• If the question stem contains an image, add a new question column and place the image in the newly added column.
• If the explanation contains an image, add a new explanation column and place the image in the newly added column.
• If the options contain images, directly place the images into the options column.

Important Notes:

• Ensure that the images are placed inside individual cells and do not span across multiple cells.
• Avoid mixing text and images in the same cell.
• Please note that only the App supports importing Excel files with embedded images. The Web version does not currently support this feature.

You can click the below button to download the template files and add your own questions in the file.