Evaluating student achievement with a relational database

Commercial database programs such as dBase and Paradox, although developed originally for business applications, are versatile and powerful tools that can be used for an academic purpose such as evaluating student performance. They can be used to write and store test questions, assemble and print classroom or on-line laboratory tests, and calculate grades, test statistics, and so forth. Databases are flexible, unlike textbook “ancillary” test bank programs that are inextricably bound to the strictly linear format and brief shelf life of specific textbook editions. A prototypical relational database program is described, with which an instructor can produce tests based on generic terms adapted from Boneau’s (1990) study of psychological literacy, as well as on behavioral learning objectives adapted from Bloom’s (1956) taxonomy of educational objectives. As a relational database, the program integrates terms, objectives, questions, tests, and test scores, and avoids unnecessary data duplication and waste of computer storage space.