ABSTRACT
In this paper the author presents the automated tool for submitting and assessing assignments, particularly those that must be completed using spreadsheet processors. The author creates a system of tools based on Google free cloud-based applications such as Forms, Spreadsheets and AppScript. The tool implements a wide set of simple tests and calculates the final mark for the assignment based on the results of these tests. It can automatically check if the observed spreadsheet has the expected structure and if the values are as expected. The tool can also be used for self-assessment purposes by the students, without the correct values for the assignment being uncovered. The assessment tool is a part of a wider workflow including distribution of the templates and instructions for the lessons in a course. The system had been tested for 1 year in courses with a total count of students - 82. It had been introduced as an optional channel for submitting the assignments. Nevertheless, most of the students in the course preferred using this automated system for submitting their assignments. The most significant limitations include its strict structure limiting the students to find their own way to get the correct answer. Another significant disadvantage - the system has only one deployment option - as a cloud-based set of documents and scripts, relying on free services, provided by Google Inc., and it is fully dependent on the provider's policies for these services. The tool presented in the article is free to copy, use, and modify by teachers and researchers.
- Paul Blayney and Mark Freeman. 2004. Automated formative feedback and summative assessment using individualised spreadsheet assignments.Google Scholar
- Sébastien Combéfis. 2022. Automated Code Assessment for Education: Review, Classification and Perspectives on Techniques and Tools. Software. 1, 1 (2022), 3–30. DOI: https://doi.org/10.3390/software1010002.Google ScholarCross Ref
- Marc Fisher, Gregg Rothermel, Darren Brown, Mingming Cao, Curtis Cook and Margaret Burnett. 2006. Integrating Automated Test Generation into the WYSIWYT Spreadsheet Testing Methodology. ACM Trans. Softw. Eng. Methodol. 15, 2 (Apr. 2006), 150–194. DOI: https://doi.org/10.1145/1131421.1131423.Google ScholarDigital Library
- Olena Gulesha, Viktor Bahriy, Mykhailo Pyshnyi and Maryna Romaniukha. 2019. Automated Testing as A Learning Assessment Tool for University Students. (2019), 609–629.Google Scholar
- Ian Robert Hamilton. 2009. Automating formative and summative feedback for individualised assignments. Campus-Wide Information Systems. 26, 5 (Jan. 2009), 355–364. DOI: https://doi.org/10.1108/10650740911004787.Google ScholarCross Ref
- Keith Hekman. 2019. Automated Grading of Microsoft Excel Spreadsheets. American Society for Engineering Education. Paper ID #26804Google Scholar
- Douglas M. Kline and Thomas N. Janicki. 2003. Enhancing Economics and Finance Learning through Automated Grading of Spreadsheet Exercises.Google Scholar
- Karina Melnyk and Natalia Borysova. 2020. CHAPTER V. IT-EDUCATION Automated system for students’ knowledge testing. July (2020).Google Scholar
- Zhanna V. Smirnova. 2020. Automated Knowledge Management through E-Testing. International Journal of Advanced Trends in Computer Science and Engineering. 9, 3 (Jun. 2020), 3256–3260. DOI: https://doi.org/10.30534/ijatcse/2020/120932020.Google ScholarCross Ref
- Rebecca Smith, Terry Tang, Joe Warren and Scott Rixner. 2017. An automated system for interactively learning software testing. Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE. Part F1286, (2017), 98–103. DOI: https://doi.org/10.1145/3059009.3059022.Google ScholarDigital Library
- Peter Summons, Christine Bruff, Jo Coldwell and Frans Henskens. 1997. Automating assessment and marking of spreadsheet concepts. ACM International Conference Proceeding Series. Part F1293, January (1997), 178–184. DOI: https://doi.org/10.1145/299359.299385.Google ScholarDigital Library
Index Terms
- Automated tool for assessment of spreadsheet type assignments: This paper presents a free cloud-based automated tool for collecting and assessing the spreadsheet type assignments.
Recommendations
Automated Assessment of Programming Assignments
CSERC '13: Proceedings of the 3rd Computer Science Education Research Conference on Computer Science Education ResearchThis is a position paper in which I argue that massive open online programming courses can benefit by the application of automated assessment of programming assignments.
I gathered success factors and identified concerns related to automatic assessment ...
Feedback on Student Programming Assignments: Teaching Assistants vs Automated Assessment Tool
Koli Calling '23: Proceedings of the 23rd Koli Calling International Conference on Computing Education ResearchExisting research does not quantify and compare the differences between automated and manual assessment in the context of feedback on programming assignments. This makes it hard to reason about the effects of adopting automated assessment at the expense ...
Nifty Assignments
SIGCSE '15: Proceedings of the 46th ACM Technical Symposium on Computer Science EducationA great CS assignment is a delight to all, but the path to one can be most roundabout. Many CS students have had their characters built up on assignments that worked better as an idea than as an actual assignment. Assignments are hard to come up with, ...
Comments