Forum Discussion

sts110277's avatar
sts110277
Copper Contributor
Aug 08, 2023
Solved

List test questions in EXCEL and export to Forms

Dear colleagues,

I have 3 questions.

(1) Is it possible to export a question pool (i.e., questions and answer choices) listed in EXCEL to generate a Forms quiz?

(2) On Forms, Is it possible to have Forms randomly select a few questions, and not every question, from this EXCEL list to use as a quiz?

(3) Is it possible to randomize the questions Forms picks up, so that every student would have the same number of questions, but answer different quesiton from the quesion pool?

For instance, I have a quesion pool of about 250 questions and I want to make a Forms quiz. However, I would like the quiz to be 50 questions and would like every student to work on different and random questions.

Hope this makes sense.

Thanks in advance,

Steve

2 Replies

Resources