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...
This paper reports initial research results on the relationship between student learning styles and academic achievement in a distance education computing course with Internet-based student support. The learning styles of students in a computer concepts class were evaluated and classified according to the Felder-Soloman Learning Style Index. We have identified statistically significant differences in performance between different learner types, i.e. groups of students with different learning preferences. The best course performance in both course components: in-course assessment and final examination was identified in students with reflective, sensing, verbal and global learning preferences. One possible explanation of this result might be that the current teaching styles and distance learning environment (course material and online student support) gives an advantage to this type of learner. To test this hypothesis we are planning changes in the learning environment and methodology to cater for a variety of student learning styles. We can then test if academic achievement has been improved by comparing it with the results presented in this paper.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.