An Integrated Learning System for First-Year University Students
with Automated Grading Modules for Typewriting, Microsoft Excel Spreadsheets and Word Documents
Abstract
This paper describes an integrated learning system for first-year students to learn basic computer skills, including automated grading modules for typewriting and MS-Excel files and MS-Word files. The system aims to relieve teachers’ workloads to grade many MSExcel and MS-Word files. It also provides immediate feedback and has a mechanism to prevent students from submitting copied files.
In addition, this paper describes the time to grade typewriting, MS-Excel, and MSWord files. It computes the students’ average normalized gain by using the operational records of the system in our university in 2021. The average normalized gain shows the variation between students’ computer skills decreased. These results, therefore, indicate the effectiveness of the system.
References
Kazunori Iwata and Yoshimitsu Matsui. Implementation of an automated grading system for microsoft excel spreadsheets and word documents. In Tokuro Matsuo, editor, Proceedings of 11th International Congress on Advanced Applied Informatics, volume 81 of EPiC Series in Computing, pages 289–302. EasyChair, 2021.
Kevin Matthews, Thomas Janicki, Ling He, and Laurie Patterson. Implementation of an Automated Grading System with an Adaptive Learning Component to Affect Student Feedback and Response Time. Journal of Information Systems, 23:71–84, 06 2012.
Moodle. https://moodle.org.
Edmodo. https://new.edmodo.com.
Blackboard. https://www.blackboard.com.
Keith Hekman. Automated Grading of Microsoft Excel Spreadsheets. In 2019 ASEE Annual Conference & Exposition, Tampa, Florida, June 2019. ASEE Conferences. https://strategy.asee.org/32135.
Douglas Kline and Thomas Janicki. Enhancing Economics and Finance Learning through Automated Grading of Spreadsheet Exercises. JOURNAL OF ECONOMICS AND FINANCE EDUCATION, 2(2):23–29, 01 2003.
Todd L. Cherry and Larry V. Ellis. Does Rank-Order Grading Improve Student Performance?: Evidence from a Classroom Experiment. International Review of Economics Education, 4(1):9–19, 2005.
Eugene W Myers. An O(ND) difference algorithm and its variations. Algorithmica, 1(1):251–266, 1986.
Sun Wu, Udi Manber, Eugene W. Myers, and Webb Miller. An O(NP) Sequence Comparison Algorithm. Inf. Process. Lett., 35:317–323, 1990.
PhpSpreadsheet. https://github.com/PHPOffice/PhpSpreadsheet.
parse_ini_file – Parse a configuration file. https://www.php.net/manual/en/function.parse-ini-file.php.
Ecma International. ECMA-376, Office Open XML file formats, 5th edition. https://www.ecma-international.org/publications-and-standards/standards/ecma-376/.
The ElementTree XML. https://docs.python.org/3/library/xml.etree.elementtree.html.
Structure of a WordprocessingML document. https://docs.microsoft.com/en-us/office/open-xml/structure-of-a-wordprocessingml-document.
Richard R. Hake. Interactive-engagement versus traditional methods: A six-thousandstudent survey of mechanics test data for introductory physics courses. American Journal of Physics, 66:64–74, 1998.
