Automated testing of databases and spreadsheets - the long and the short of it

ABSTRACT

Our introductory Information System subjects include the teaching and assessment of skills in word processing, spreadsheets, and databases. Having made pleasing progress with the automated generation and marking of the spreadsheet tests, we found that our move to automate the database testing highlighted some important distinctions between the two. In essence, spreadsheet testing is comparable to short-answer test and database to long-answer test, which require a markedly different approach.

REFERENCES

• 1: Peter Summons , Jo Coldwell , Christine Bruff , Frans Henskens, Automated assessment and marking of spreadsheet concepts, Proceedings of the 2nd Australasian conference on Computer science education, p.178-184, July 1997, The Univ. of Melbourne, Australia [doi>10.1145/299359.299385]
• 2: Summons, P.F., Bruff, C., Simon and Coldwell, J. Automated Assessment: Reflections on the Past and the Promise of the Future. Proceedings of the 3rd Annual NSW Syrnposium on Information Technology and Information Systems SITIS '98, University of NSW, Sydney, February 1998.
• 3: Summnns, P.F., Bruff, C., Simon and Coldwell, J. Automated Assessment and Management Project. Computers and Advanced Technology in Education - CATE '98, Cancun, Mexico, May 1998.
• 4: Peter Summons , Simon, Authentication strategies for online assessments, Proceedings of the 3rd Australasian conference on Computer science education, p.101-105, July 08-10, 1998, The University of Queensland, Australia [doi>10.1145/289393.289408]
• 5: Summons, P.F., Coldwell, J. and Bruff, C. 1998 National Teaching Development Grant- Indna'dual Automated Assessment and Marking Management Package. Committee for University Teaching and Stuff Development (htlp://services.canberra.edu.au/ CUTSD/announce/1998Indv. html#Newcastle) 1997.