University of Las Palmas de Gran Canaria (SPAIN)
About this paper:
Appears in: ICERI2010 Proceedings
Publication year: 2010
Pages: 4804-4810
ISBN: 978-84-614-2439-9
ISSN: 2340-1095
Conference name: 3rd International Conference of Education, Research and Innovation
Dates: 15-17 November, 2010
Location: Madrid, Spain
The purpose of the present paper is multifold. In the first place, a simple method enabling teachers to create multiple choice exams using Microsoft Excel is presented. The multiple choice questions are created making use of Excel functions and RExcel, a free addin for Excel that allows access to the statistics package R (one of the most powerful and the fastest-growing statistics program) from within Excel. Thus, if one runs the R code associated with the questions then the values and options of those multiple choice questions will change properly. This allows teachers to get recalculated questions for each new exam. In the second place, when the questions have been developed, a simple R program reads the multiple choice questions from Excel and also creates a LaTeX document which makes use of the EqExam package. The different options of this package are explained. Several examples which illustrate the potential of this method for making dynamics multiple choices tests are presented.
Multiple choice tests, R, LaTeX, Excel.