Can you merge and randomise multiple question banks?
Here's my dilemma. I'm making a quiz. Each question requires the user to pick from 3 different options. My stakeholders want to customise the ratio of questions with specific answers (e.g. 20% should be answer A, 30% answer B, and 50% answer C). Also, they want a bank of questions available for each answer, so the game will be different each time.
So my idea was, create 3 banks of questions, 1 for each answer (A,B,C) with 10 questions in each.
Bank A draws 2 questions from 10 that all have A as the answer.
Bank B draws 3 questions from 10 that all have B as the answer.
Bank C draws 5 questions from 10 that all have C as the answer.
Now I have 10 questions and the answers all fit my requested ratios, but I want to randomise them in the order they appear (e.g. the order might be A,C,B,C,B,C,A,B,C,C instead of A,A,B,B,B,C,C,C,C,C which is what it's like now).
Is this possible?
The only thing I can think of to get round it is make multiple question banks with the agreed ratio mix in each, and then use a random number variable to get them to a unique bank, but when my stakeholders say 'I want 30% of A instead of 20%' (which is an inevitability) it's more rework than I care to do!
Any assistance/remedy to this would be marvellous!