A generic tool for generating and assessing problems automatically using spreadsheets

Abstract

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 feedback 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

The authors are grateful for the financial support from the University of Girona (Spain) MPCUdG2016/093 and MPCUdG2016/024. This work has also been funded in part by grants from the Spanish Government (No. TIN2016-75866-C3-3-R) and from the Catalan Government (No. 2017-SGR-1101)