How to pull random questions from a question bank into Google Forms

By Jake Marsh · Updated

To pull random questions from a question bank into Google Forms, give each question a Group (or Topic, Unit, Tag or Difficulty) in your bank, open the form, choose Extensions > Quizferry > Build from a question bank, and pick Random draw from the bank. Click Check, set how many questions to take from each group, and click Build. The Draw code makes the draw repeatable, and New code gives you another version.

What Google Forms does and doesn't do

Forms has Shuffle question order in its settings. It changes the order for each respondent, but everyone still answers every question in the form, and it works best without sections. Forms has no question pools, so drawing 10 of 40 questions has to happen before the questions go into the form. That's the part Quizferry does.

Steps

  1. Group the bank. In a sheet, add a Group column (Topic, Unit, Tag, Difficulty, Chapter or Standard work as the header too). In a Doc, add a Group: line under each question. Questions with no group are pooled by their section.
  2. Open the form and choose Extensions > Quizferry > Build from a question bank, then pick the bank.
  3. Choose Random draw from the bank under 2. Options.
  4. Click Check. Quizferry lists each group with how many questions it holds and asks how many to take from each.
  5. Set the counts. For example 4 from Vocabulary, 3 from Grammar and 3 from Reading for a 10-question quiz.
  6. Note the Draw code. The same bank and the same code always give the same questions, so you can rebuild this exact version later.
  7. Click Build. Export answer key to a new sheet saves the drawn questions and answers in form order, which is handy for a paper key.

Making versions A, B and C

VersionWhat to do
ABuild in the first form and note its code
BOpen a new blank form, pick the same bank from Recent..., choose Random draw, click New code, check the counts and build
CAnother blank form, New code, build

Write each version's code down with its name, so you can rebuild exactly that version later.

More ways to mix things up

  • Mix up question order within each section (fixed for everyone) shuffles once at build time, so a printed key still matches.
  • Mix up answer order shuffles the choices at build time and keeps "All of the above" last.
  • Turn on Google Forms' "Shuffle question order" sets the form's own per-respondent shuffle.
  • Shuffle answer order for each respondent, in the Finish step, sets Forms' own choice shuffle on every choice question.

What it costs

Quizferry's free trial covers 5 builds or 14 days, whichever comes first, with no card needed. Check and the draw preview are always free; each Build counts once. After that it's $9.99 a month or $99 a year per Google account. Install it from the Quizferry page.

Quizferry

Build a Google Forms quiz from a question bank sheet, a Doc or pasted text $9.99 a month or $99 a year per Google account.


Questions

Does each student get a different random set?

No. Each build draws one set into one form, so everyone who opens that form gets the same questions. For different sets, build versions into copies of the form with new codes and share a different link with each group.

Can I get the same random quiz again next year?

Yes. Keep the bank and the Draw code. Building with the same code gives the same questions.

What if I ask for more questions than a group has?

Check warns you and uses every question in that group instead. It also shows how many each group holds, so you can set the counts before building.

Can I weight harder questions?

Give them a higher value in the Points column. To control how many hard questions appear, put them in their own group, such as Difficulty: Hard, and set that group's count.


More Quizferry guides


More Google guides