Automatic Grading of Spreadsheet and Database Skills

Abstract

Executive SummaryGrowing enrollment in distance education has increased student-to-lecturer ratios and, therefore, increased the workload of the lecturer. This growing enrollment has resulted in mounting efforts to develop automatic grading systems in an effort to reduce this workload. While research in the design and development of automatic grading systems has a long history in computer education, only a few attempts have been made to automatically assess spreadsheet and database skills. This paper has three purposes: (1) to describe the design of an assessment in the Information Systems course at the Open Polytechnic to assess students' spreadsheet and database skills, (2) to describe the development of an automatic grading system to assess spreadsheet and database skills, and (3) to compare automatic with manual marking to determine if automatic grading system is a feasible method of reducing workload.The automatic grading system we developed uses Excel's user-defined functions to automatically check whether a feature or a function has been used. Since the outcomes from user-defined functions are scrambled, students verify their own answers by entering the results from these functions into an online quiz. As a result, there is no need for the lecturer to download, open, and check the actual software application. The system recognizes correct answers from these scrambled inputs and allocates marks. This system is integrated into the Moodle learning management platform and linked to the students' academic record database.The main difference between the automated grading system for the assessment of spreadsheet and database skills described in this paper and existing systems is that the latter systems require the actual software application to be submitted for marking. The system described in this paper does not require markers to handle the application. Instead, it automatically checks the application while students are working on it, but grading is not performed until students answer specific quiz questions.Practical experience with the automatic grading system has shown that the system significantly decreases turnaround time for the grading of assignments, while providing instant feedback to students on the correctness of their answers. At the same time, the system reduces the workload of the lecturer, freeing lecturers from administration and the time-consuming tasks of checking individual aspects of the spreadsheet and database applications. This allows them to allocate time to student support and other more creaMaterial published as part of this publication, either on-line or in print, is copyrighted by the Informing Science Institute. Permission to make digital or paper copy of part or all of these works for personal or classroom use is granted without fee provided that the copies are not made or distributed for profit or commercial advantage AND that copies 1) bear this notice in full and 2) give the full citation on the first page. It is permissible to abstract these works so long as credit is given. T...

Improving the learning experience of business subjects in engineering studies using automatic spreadsheet correctors

“…Tsai and Wardell (2006) in their paper described an approach that utilizes Excel macros to help instructors to enhance and assess their students' learning. Kovacic and Green (2012) developed a method to assess and automatically grade students' spreadsheet and database skills. The solution is exclusively oriented to prove the degree to which students have mastery of spreadsheets.…”

Point Cloud-Based Automatic Assessment of 3D Computer Animation Courseworks

“…For instance, software solutions have been used to automatically grade computer science entrance examinations [29] and to assess basic abilities in the use of office automation tools [7]. Similarly, the mastery of advanced learning outcomes has been automatically evaluated in the areas of computer programming [6], [12], [30], [31], security [11], control systems [8], formal logic [9], digital logic [10], and databases [32].…”

XML-based e-assessment system for Office skills in open learning environments

“…This history, elaborated by many authors as an example of the recent ones by Jordan (2013) as well as Lahtonen and Isomöttönen (2012), shows that many assessment systems have been developed for many knowledge domains, such as mathematics, programming languages, and free text. However, a few attempts have led to sufficient grading systems for automated assessment of IT skills, especially for Office skills (Kovacic and Green 2012) despite the significant need identified. In general, there are two strategies for automated assessment of Office skills (Zhu and Shen 2013; Tang and Chen 2008).…”

“…This fact has resulted in an increasing effort to develop automated grading systems in order to achieve these objectives. Although the research in the design of automated assessment systems has a long history in many educational domains (Lahtonen and Isomöttönen 2012), only a few attempts have been established to develop automated assessment systems for IT skills, and Office skills in particular (Kovacic and Green, 2012).…”