基于Office Open XML的Excel操作题自动阅卷系统的实现

楚雄师范学院学报 ›› 2024, Vol. 39 ›› Issue (3): 116-122.

基于Office Open XML的Excel操作题自动阅卷系统的实现

李渝翔¹, 杨庆昆², 张雷³

1.楚雄北浦中学,云南楚雄 675000;
2.楚雄市教师培训中心,云南楚雄 675000;
3.楚雄州教育体育科学研究所,云南楚雄 675000

收稿日期:2023-12-18 出版日期:2024-05-20 发布日期:2024-06-05
作者简介:李渝翔（1973–）,男,高级教师、信息系统项目管理师,研究方向为信息技术教育、研究与软件开发。E-mail：1098882908 @qq.com,Tel. 18908787556

Automatic Grading System for Excel Manipulation Questions Based on Office Open XML

LI Yuxiang¹, YANG Qingkun², ZHANG Lei³

1. Beipu Middle School, Chuxiong, Yunnan Province 675000;
2. Chuxiong Teachers Training Center, Chuxiong, Yunnan Province 675000;
3. Institute of Educational Physical Education Science of Chuxiong Yi Autonomous Prefecture, Chuxiong, Yunnan Province 675000

Received:2023-12-18 Online:2024-05-20 Published:2024-06-05

摘要/Abstract

摘要： Excel操作题自动阅卷系统的设计往往采用RTF、VBA方式,但效果并不理想,针对这种情况提出了一种基于Office Open XML格式和Python语言,使用开源库Openpyxl、Element Tree及自编类解析Excel文件的操作题自动阅卷评分系统的方法,总结了Office Open XML格式的Spread sheet ML标记语言的常用标记及作用,其次设计了自动阅卷流程,细化为格式解析、格式保存和格式对比量化评分三个阶段,并将格式解析分解为Openpyx l解析、Element Tree解析两个步骤,解决了解析中容错的自定义问题。经过测试,使用该方法能可靠地实现Excel 2010版本操作题的自动阅卷。

关键词: Office Open XML, Excel操作题, 自动阅卷

Abstract: Excel automated grading systems for problem-solving questions often rely on RTF and VBA approaches, but their effectiveness is far from satisfactory. To address this issue, a method based on the Office Open XML format and Python language, utilizing open-source libraries such as Openpyxl, Element Tree, along with custom classes for Excel file parsing, has been proposed. This method presents a summary of common tags and their functions in the Spread sheet ML markup language of the Office Open XML format. Furthermore, an automated grading workflow is designed, which is divided into three stages: format parsing, format saving, and format comparison for quantitative scoring. The format parsing stage is further broken down into two steps-Openpyx l parsing and Element Tree parsing-that can effectively address custom error handling during parsing. Testing demonstrated that this method enables reliable automated grading of Excel 2010 problem-solving questions.

Key words: Office Open XML, Excel manipulation question: automatic grading

中图分类号:

TP311.52

李渝翔, 杨庆昆, 张雷. 基于Office Open XML的Excel操作题自动阅卷系统的实现[J]. 楚雄师范学院学报, 2024, 39(3): 116-122.

LI Yuxiang, YANG Qingkun, ZHANG Lei. Automatic Grading System for Excel Manipulation Questions Based on Office Open XML[J]. Journal of Chuxiong Normal University, 2024, 39(3): 116-122.