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

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

作　　者：李渝翔 杨庆昆 张雷 LI Yuxiang;YANG Qingkun;ZHANG Lei(Beipu Middle School,Chuxiong,Yunnan Province 675000;Chuxiong Teachers Training Center,Chuxiong,Yunnan Province 675000;Institute of Educational Physical Education Science of ChuxiongYiAutonomous Prefecture,Chuxiong,Yunnan Province 675000)

机构地区：[1]楚雄北浦中学,云南楚雄675000 [2]楚雄市教师培训中心,云南楚雄675000 [3]楚雄州教育体育科学研究所,云南楚雄675000

出　　处：《楚雄师范学院学报》2024年第3期116-122,共7页Journal of Chuxiong Normal University

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

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

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]