QuestionBaker
Board Regular
- Joined
- Apr 12, 2019
- Messages
- 106
- Office Version
- 365
- Platform
- Windows
Tl dr; I am trying to make a question bank where one of the question is match the following and I want to randomly select them to form an assignment.
I am trying to make question bank in excel so that I can hand out a separate assignment sheet to each student. There are different types of questions like fill in the blank, translate the sentence or write the opposite of the word etc. I've been able to randomize most of the questions barring few eg. Match the Following.
Finally I want to generate a match the following question that is randomly selected from the a sheet called MtF (which stands for Match the following which has all question and their matches in the correct order), its correct answer is also selected and then they are randomly shuffled. I should be should be able to add as many questions and answer in MtF as I want and also increase number of questions I can give to the students.
Context: I am trying to create custom assignment for students that we teach as a part of CSR activity and I want to randomize them so that they do not cheat and try and solve on their own.
Thanks
QuestionBaker
I am trying to make question bank in excel so that I can hand out a separate assignment sheet to each student. There are different types of questions like fill in the blank, translate the sentence or write the opposite of the word etc. I've been able to randomize most of the questions barring few eg. Match the Following.
Finally I want to generate a match the following question that is randomly selected from the a sheet called MtF (which stands for Match the following which has all question and their matches in the correct order), its correct answer is also selected and then they are randomly shuffled. I should be should be able to add as many questions and answer in MtF as I want and also increase number of questions I can give to the students.
Context: I am trying to create custom assignment for students that we teach as a part of CSR activity and I want to randomize them so that they do not cheat and try and solve on their own.
Thanks
QuestionBaker