基于Office Open XML的Excel操作题自动阅卷系统的实现
Automatic Grading System for Excel Manipulation Questions Based on Office Open XML
李渝翔 1杨庆昆 2张雷3
作者信息
- 1. 楚雄北浦中学,云南 楚雄 675000
- 2. 楚雄市教师培训中心,云南 楚雄 675000
- 3. 楚雄州教育体育科学研究所,云南 楚雄 675000
- 折叠
摘要
Excel操作题自动阅卷系统的设计往往采用RTF、VBA方式,但效果并不理想,针对这种情况提出了一种基于Office Open XML格式和Python语言,使用开源库Openpyxl、Element Tree及自编类解析Excel文件的操作题自动阅卷评分系统的方法,总结了Office Open XML格式的Spread sheet ML标记语言的常用标记及作用,其次设计了自动阅卷流程,细化为格式解析、格式保存和格式对比量化评分三个阶段,并将格式解析分解为Openpyx l解析、Element Tree解析两个步骤,解决了解析中容错的自定义问题.经过测试,使用该方法能可靠地实现Excel 2010版本操作题的自动阅卷.
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 com-mon tags and their functions in the Spread sheet ML markup language of the Office Open XML format.Fur-thermore,an automated grading workflow is designed,which is divided into three stages:format parsing,for-mat 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 han-dling during parsing.Testing demonstrated that this method enables reliable automated grading of Excel 2010 problem-solving questions.
关键词
Office/Open/XML/Excel操作题/自动阅卷Key words
Office Open XML/Excel manipulation question:automatic grading引用本文复制引用
出版年
2024
NETL
NSTL
万方数据