A Generic Tool for Generating and Assessing Problems Automatically using Spreadsheets

Authors

DOI:

https://doi.org/10.3991/ijet.v13i10.7689

Keywords:

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

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.

Downloads

Published

2018-10-26

How to Cite

Rafart Serra, M. A., Bikfalvi, A., Soler Masó, J., & Poch Garcia, J. (2018). A Generic Tool for Generating and Assessing Problems Automatically using Spreadsheets. International Journal of Emerging Technologies in Learning (iJET), 13(10), pp. 23–41. https://doi.org/10.3991/ijet.v13i10.7689

Issue

Section

Papers