If you are part of a large Moodle site with lots of quizzes, and if you have access to the database, please could you execute the query:
SELECT questionsperpage, shufflequestions, count(*) FROM mdl_quiz GROUP BY questionsperpage, shufflequestions
Save the results as CSV, and attach them here. Thinking about part of the new UI in Moodle 2.0, it would be really helpful to know what the more common options are.
Thanks for your help.
'0';'0';'36'
'0';'1';'240'
'1';'0';'6'
'1';'1';'142'
'2';'1';'3'
'3';'0';'1'
'3';'1';'3'
'4';'0';'1'
'4';'1';'4'
'5';'1';'2'
'0';'1';'240'
'1';'0';'6'
'1';'1';'142'
'2';'1';'3'
'3';'0';'1'
'3';'1';'3'
'4';'0';'1'
'4';'1';'4'
'5';'1';'2'
(Formatting fixed by Tim Hunt - original submission Friday, 6 March 2009, 03:12 PM)
"0";"0";"211"
"0";"1";"170"
"1";"0";"4"
"1";"1";"6"
"2";"0";"1"
"4";"0";"1"
"5";"0";"6"
"5";"1";"1"
"6";"1";"1"
"10";"1";"2"
"23";"1";"1"
"0";"1";"170"
"1";"0";"4"
"1";"1";"6"
"2";"0";"1"
"4";"0";"1"
"5";"0";"6"
"5";"1";"1"
"6";"1";"1"
"10";"1";"2"
"23";"1";"1"
and another....
"0";"0";"191"
"0";"1";"112"
"1";"0";"10"
"1";"1";"2"
"4";"1";"1"
"0";"0";"191"
"0";"1";"112"
"1";"0";"10"
"1";"1";"2"
"4";"1";"1"
And some more records in the attached CSV file.
Cheers,
Shane.
Cheers,
Shane.
"0";"0";"3013"
"0";"1";"557"
"1";"0";"24"
"1";"1";"20"
"2";"0";"3"
"3";"0";"10"
"3";"1";"8"
"4";"0";"2"
"4";"1";"1"
"5";"1";"8"
"6";"0";"2"
"7";"1";"1"
"9";"0";"4"
"10";"0";"5"
"10";"1";"4"
"15";"1";"1"
Source
"0";"1";"557"
"1";"0";"24"
"1";"1";"20"
"2";"0";"3"
"3";"0";"10"
"3";"1";"8"
"4";"0";"2"
"4";"1";"1"
"5";"1";"8"
"6";"0";"2"
"7";"1";"1"
"9";"0";"4"
"10";"0";"5"
"10";"1";"4"
"15";"1";"1"
Source
Don't know what your definition of 'lots of quizzes' is, but maybe this helps anyway:
'0';'0';'134'
'0';'0';'134'
0;0;124
0;1;35
1;0;982
1;1;35
2;0;279
2;1;1
3;0;19
4;0;63
4;1;3
5;0;17
5;1;2
6;0;10
6;1;4
7;0;1
7;1;5
8;0;12
8;1;1
9;0;7
10;0;30
10;1;8
11;0;3
15;0;2
50;0;2
20;0;3
25;0;2
27;0;1
30;0;1
0;1;35
1;0;982
1;1;35
2;0;279
2;1;1
3;0;19
4;0;63
4;1;3
5;0;17
5;1;2
6;0;10
6;1;4
7;0;1
7;1;5
8;0;12
8;1;1
9;0;7
10;0;30
10;1;8
11;0;3
15;0;2
50;0;2
20;0;3
25;0;2
27;0;1
30;0;1
"0";"0";"15"
"1";"0";"4"
"4";"0";"1"
Joseph
"1";"0";"4"
"4";"0";"1"
Joseph
"0";"0";"177"
"0";"1";"23"
"1";"0";"2"
"2";"0";"4"
"5";"0";"5"
"5";"1";"17"
"0";"1";"23"
"1";"0";"2"
"2";"0";"4"
"5";"0";"5"
"5";"1";"17"
"0";"0";"47"
"0";"1";"87"
"1";"0";"4"
"1";"1";"27"
"2";"1";"8"
"3";"1";"5"
"4";"1";"1"
"10";"1";"8"
"0";"1";"87"
"1";"0";"4"
"1";"1";"27"
"2";"1";"8"
"3";"1";"5"
"4";"1";"1"
"10";"1";"8"
Wow! Thanks everyone. That is data on 16 399 quizzes in under 24 hours.
Scores so far:
About one quiz in 4 uses shufflequestions. (This varies a lot between different Moodle sites, the average was at one in 7 for a long time, then the latest data knocked it back to 4, so the last few thousand quizzes were more shuffled than not.)
The most popular values for questions per page were:
82% All on one page.
10.4% 1
2.2% 10
2.1% 2
1.0% 5
0.8% 3
0.7% 4
0.2% 6
0.1% 8
There were some very funny numbers in there. Can anyone suggest why you might want exactly 27 questions per page?
Feel free to keep posting more numbers. I will go on adding them up.
Scores so far:
About one quiz in 4 uses shufflequestions. (This varies a lot between different Moodle sites, the average was at one in 7 for a long time, then the latest data knocked it back to 4, so the last few thousand quizzes were more shuffled than not.)
The most popular values for questions per page were:
82% All on one page.
10.4% 1
2.2% 10
2.1% 2
1.0% 5
0.8% 3
0.7% 4
0.2% 6
0.1% 8
There were some very funny numbers in there. Can anyone suggest why you might want exactly 27 questions per page?
Feel free to keep posting more numbers. I will go on adding them up.
"0";"0";"1388"
"0";"1";"46"
"1";"0";"13"
"1";"1";"3"
"2";"0";"6"
"3";"0";"11"
"3";"1";"1"
"4";"0";"1"
"5";"0";"14"
"10";"0";"1"
"10";"1";"1"
"0";"1";"46"
"1";"0";"13"
"1";"1";"3"
"2";"0";"6"
"3";"0";"11"
"3";"1";"1"
"4";"0";"1"
"5";"0";"14"
"10";"0";"1"
"10";"1";"1"
not so many, but what the heck
"0","0","42"
"0","1","23"
"6","1","2"
"0","0","42"
"0","1","23"
"6","1","2"
"0";"0";"21"
"0";"1";"47"
"1";"1";"1"
"8";"0";"1"
"10";"0";"1"
"10";"1";"1"
"15";"1";"1"
"16";"0";"1"
"35";"1";"1"
"0";"1";"47"
"1";"1";"1"
"8";"0";"1"
"10";"0";"1"
"10";"1";"1"
"15";"1";"1"
"16";"0";"1"
"35";"1";"1"
0 0 257
0 1 124
1 0 7
1 1 16
2 0 2
2 1 1
3 0 3
3 1 9
4 0 2
4 1 8
5 0 14
5 1 5
6 0 2
6 1 1
7 1 2
8 0 2
8 1 1
9 1 1
10 0 8
10 1 15
21 0 1
31 0 1
50 0 1
0 1 124
1 0 7
1 1 16
2 0 2
2 1 1
3 0 3
3 1 9
4 0 2
4 1 8
5 0 14
5 1 5
6 0 2
6 1 1
7 1 2
8 0 2
8 1 1
9 1 1
10 0 8
10 1 15
21 0 1
31 0 1
50 0 1
Thanks everyone. To give you the up-to-date summary numbers they are now:
Out of 22207 quizzes syrveyed, 5733 use shufflequestions, which is still about one in four.
And the popular numbers of questions per page are
84% single page
8.3% 1
2.4% 10
1.7% 2
1.2% 5
0.8% 3
0.7% 4
0.2% 6
0.1% 8
0.5% other
Out of 22207 quizzes syrveyed, 5733 use shufflequestions, which is still about one in four.
And the popular numbers of questions per page are
84% single page
8.3% 1
2.4% 10
1.7% 2
1.2% 5
0.8% 3
0.7% 4
0.2% 6
0.1% 8
0.5% other
"0","0","230"
"0","1","43"
"1","0","5"
"1","1","47"
"3","1","2"
"5","0","3"
"5","1","5"
"6","0","2"
"7","0","3"
"8","0","2"
"8","1","1"
"9","0","1"
"10","0","84"
"10","1","13"
"11","0","3"
"12","0","2"
"15","0","1"
"20","0","2"
"0","1","43"
"1","0","5"
"1","1","47"
"3","1","2"
"5","0","3"
"5","1","5"
"6","0","2"
"7","0","3"
"8","0","2"
"8","1","1"
"9","0","1"
"10","0","84"
"10","1","13"
"11","0","3"
"12","0","2"
"15","0","1"
"20","0","2"
"0";"0";"96"
"0";"1";"1548"
"1";"0";"15"
"1";"1";"918"
"2";"1";"10"
"3";"0";"31"
"3";"1";"5"
"4";"1";"31"
"5";"0";"8"
"5";"1";"144"
"6";"1";"6"
"7";"1";"131"
"10";"0";"2"
"10";"1";"210"
"11";"1";"4"
"12";"1";"3"
"13";"1";"1"
"15";"1";"6"
"20";"1";"16"
"21";"1";"1"
"25";"1";"20"
"33";"1";"1"
"35";"1";"1"
"48";"1";"1"
"49";"1";"1"
"50";"1";"35"
"0";"1";"1548"
"1";"0";"15"
"1";"1";"918"
"2";"1";"10"
"3";"0";"31"
"3";"1";"5"
"4";"1";"31"
"5";"0";"8"
"5";"1";"144"
"6";"1";"6"
"7";"1";"131"
"10";"0";"2"
"10";"1";"210"
"11";"1";"4"
"12";"1";"3"
"13";"1";"1"
"15";"1";"6"
"20";"1";"16"
"21";"1";"1"
"25";"1";"20"
"33";"1";"1"
"35";"1";"1"
"48";"1";"1"
"49";"1";"1"
"50";"1";"35"