X
Guide: Preparing Your Excel for Moodle Question Types
Below are horizontal layout tables, each with one row for headers and one row for example data. Each row in your sheet = one question. Extra columns (Subquestion, Subanswer) if needed.
Multichoice
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Please choose the best answer: |
Background passage |
Which city is in France? |
Paris |
Berlin |
London |
Rome |
Madrid |
A |
[Male] The correct city is Paris |
Paris is the capital of France. |
Wordselect
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Highlight the correct words: |
|
We have [fruit1] and [fruit2] in the basket. |
Apple |
Banana |
Orange |
Mango |
Pineapple |
|
(Professor) The bracketed words are correct. |
fruit1=Apple, fruit2=Banana |
Correct Writing
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Type the sentence exactly: |
|
The library closes at 10 PM. |
|
|
|
|
|
|
(Student) The library closes at 10 PM ... |
Check the schedule for confirmation. |
True/False (with Not Mentioned)
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Decide if T, F, or N/A: |
|
The Atlantic Ocean is the largest ocean. |
TRUE |
FALSE |
NOT MENTIONED |
|
|
F |
(Male) The Pacific is bigger ... |
The correct answer is False. |
Short Answer
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Answer the question briefly: |
|
What is 2 + 2? |
|
|
|
|
|
4 |
(Teacher) It's a basic math fact. |
2+2=4 |
Drag & Drop into Text
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Fill the placeholders [[1]] [[2]]: |
|
He arrived at [[1]] by [[2]]. |
8 AM |
bus |
car |
train |
walk |
|
(Female) The placeholders are time & transport. |
He arrived at 8 AM by bus. |
Embedded (Cloze)
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Embedded answers in braces: |
|
He is {1:SHORTANSWER:=happy} now. |
|
|
|
|
|
|
(Male) The correct word is 'happy'. |
Just fill the word in braces. |
Ordering
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Arrange events in order: |
|
Place them from oldest to newest: |
Event 1 (oldest) |
Event 2 |
Event 3 (newest) |
|
|
|
(Historian) Keep the timeline in mind. |
1, 2, 3 in correct order. |
Select Missing Words
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
| Fill the missing words in brackets as dropdowns: |
|
The quick [color1] fox jumps over the [color2] dog. |
brown |
white |
black |
gray |
spotted |
|
(Male) 2 placeholders for color1 & color2 |
color1=brown, color2=white |
Matching
Use extra columns for subquestions and subanswers.
| Instruction |
Reading Text |
Question Text |
Choice A |
Choice B |
Choice C |
Choice D |
Choice E |
Correct Answer |
Script |
Solution |
Subquestion 1 |
Subanswer 1 |
Subquestion 2 |
Subanswer 2 |
| Match each country with capital: |
|
Match the following countries with capitals: |
|
|
|
|
|
|
(Teacher) Make sure to match each correctly. |
France=Paris, Germany=Berlin |
France |
Paris |
Germany |
Berlin |
Essay
| Instruction |
Reading Text |
Question Text |
Script |
Solution |
| Please write an essay on ... |
Background text or prompt |
Explain the concept of X in detail |
(Male) Provide additional comments here |
Sample solution or reference explanation |
Speaker tags ([Male], (Student), etc.) automatically split onto separate lines in the feedback.