Building a quiz with Smartsheet

Sisey

Hi, I'm building a quiz of 100 questions for 20 students and I want 25 questions out of the 100 to be randomly selected for each student.

Is there a way I can go about the random selection? Thank you.

Ric T

Hi @Sisey, cool idea, but to my knowledge there isn't a randomize function for Smartsheet without the help of a third party software. A bit of an overkill, but you could:

1. create 20 forms, one for each student
2. if you have conditional logic for your forms, you can create a field where when they enter their name (or another unique identifier like their student number), the 25 random questions will appear. You'll need to use a third party website (https://www.random.org/lists/) or app to generate the 25 questions before building your 20 forms.

It's a long-winded approach, but it can be done!

Cheers,

Ric

NickStaffordPM

No way to randomize questions selection like what Ric said above. That being said if you did randomize ahead of time, I have created this explaination on how to create a quiz in Smartsheet and have it automaticallyt generate the scores by student, this may also be helpful!

So you would need to have two columns for every question

1. The question the user answers via a form
2. A column that has an IF statement determinig if the correct answer was selected for Question 1. If so, input value of 1, if not, input value of 0

Have the questions answered in a form, so as they come in, the answers are translated into numbers you can add/divide. Then you will use sheet summaries to add all columns that have the 1 / 0 and you can divide by the total number of questions asked.

You would need to have a Sheet Summary Metric for every student you wanted to calculate a result for. You could then pull everything into a Sheet Summary Report and view the information there or in a Dashboard.

If your question is to long for the actual column title, create column titles like Question 1, Question 2, etc.. and use the Display text on the form to inlcude the longer question.

Let me know if you have any additional questions or concerns.