For almost 10 years we are using quizzes based on calculated questions (WEBCT) to improve the learning of students in analytical and physical chemistry courses. The calculated questions are similar to those found at the end of the textbook chapters. They are submitted to the students as homeworks, each question in a separate quizz because the students are less confuse by the partial and total submit procedures. If they failed to have a good response, they can submit either once or two times where they get a new version (new values) of the question. During a course they must do from 50 to 100 different questions and a little part of the total note (10%) is related to the completion of the questions.
We have found that the groups who have those problems, have significant higher notes in the regular examinations. We will migrate to Moodle next year so we are working on the following plan to improve the handling of calculated questions in Moodle.
- Importing calculated questions from WEBCT. The actual module is not working.
Moodle 1.6 importing WEBCT calculated question - Importing and exporting calculated questions from moodle. This is not implemented in the various import-export modules. We are working on the XML moodle format.Should we use the backuplib.php functions to export and import in XML Moodle Format?A modification to be able to select the questions to export have been proposed
or save_question_options($question), a bottleneck to import calculated questions - Improving the handling of calculated questions:
- Extending the complexity of calculated questions. The calculations for the answer is limited to a one line equation which greatly limit the usefulness of calculated questions and probably explain why so few teachers use them. We have developp an excel spreadsheet that allows to use all the calculation capacities of excel to generate the values and the anwer. The anwer is imported in moodle as an additional parameter.
Extending calculated questions with a spreasheet