Can someone please tell me if the following concept is currently available, potentially possible, or precluded by structural assumptions in Moodle?
Rather than constructing individual quizzes, I think it should be possible to build various kinds of drills followed by tests, all of which are drawn programmatically from databases.
Imagine, for example, a database of birds that includes fields like <common name>, <scientific name>, <audio file of call>, <image of male>, <image of female>. Imagine that the database consists of 1000 birds, and the ornithology students are expected to master all the data it contains.
Drill and Test templates could be designed that give data with some fields (e.g., <call> and <image>s) and ask for (and validate against) <common name>. Another template might give <common name> and ask for (and validate against) <scientific name>.
Individual drills or tests based on those templates would give limited numbers of questions filtered by certain fields. E.g., Drill 1 consisting of 50 birds whose field is listed as <Unit> = 1. Drill 2 would programmatically load items where <Unit> ≤ 2. Etc.
A Test could be assembled by stipulating: Question 1 uses Template X and record id Y.
Such a module would be applicable to a wide variety of fields and would allow much more rapid drill and test design. Faculty could input the database to Excel, save as .csv, and upload to db.
Again, suggestions as to feasibility and how to get it done if it is feasible would be much appreciated. Thanks.