A Generic Tool for Generating and Assessing Problems Automatically using Spreadsheets

Maria Assumpció Rafart Serra, Andrea Bikfalvi, Josep Soler Masó, Jordi Poch Garcia

Abstract


A myriad of higher education degrees including science, engineering, business and economics could integrate activities using spreadsheet into the teaching-learning process. In the present article, we aim to introduce and describe a new tool that generates, individually assigns, corrects, provides feed-back and grades exercises and activities using spreadsheets all completely automatically. The system’s versatility means it can be applied in a range of areas of knowledge and subjects including mathematics, statistics, physics, accounting and economics, among others. It is usable for both formative and summative assessment based on students’ answers, providing them with the corresponding feed-back and/or the resultant grades. The proposed solution has been developed and implemented at the University of Girona (Spain) and forms part a wider family of tools that aim to contribute to the continuous improvement of higher education.

Keywords


automatic grading; automatic feed-back; Excel; spreadsheets; formative assessment; summative assessment; higher education

Full Text:

PDF


Copyright (c) 2018 Maria Assumpció Rafart Serra, Andrea Bikfalvi, Josep Soler Masó, Jordi Poch Garcia


International Journal of Emerging Technologies in Learning. ISSN: 1863-0383
Creative Commons License SPARC Europe Seal
Indexing:
Web of Science ESCI logo Engineering Information logo INSPEC logo DBLP logo ELSEVIER Scopus logo EDiTLib logo EBSCO logo Ulrich's logo Google Scholar logo Microsoft® Academic SearchDOAJ logo