Excel操作题自动阅卷系统的设计往往采用RTF、VBA方式,但效果并不理想,针对这种情况提出了一种基于Office Open XML格式和Python语言,使用开源库Openpyxl、Element Tree及自编类解析Excel文件的操作题自动阅卷评分系统的方法,总结了Offi...Excel操作题自动阅卷系统的设计往往采用RTF、VBA方式,但效果并不理想,针对这种情况提出了一种基于Office Open XML格式和Python语言,使用开源库Openpyxl、Element Tree及自编类解析Excel文件的操作题自动阅卷评分系统的方法,总结了Office Open XML格式的Spread sheet ML标记语言的常用标记及作用,其次设计了自动阅卷流程,细化为格式解析、格式保存和格式对比量化评分三个阶段,并将格式解析分解为Openpyx l解析、Element Tree解析两个步骤,解决了解析中容错的自定义问题。经过测试,使用该方法能可靠地实现Excel 2010版本操作题的自动阅卷。展开更多
At present, with the continuous development of technologies such as the Internet, big data, and artificial intelligence, smart campuses in universities are being rapidly constructed. Improving the informatization leve...At present, with the continuous development of technologies such as the Internet, big data, and artificial intelligence, smart campuses in universities are being rapidly constructed. Improving the informatization level of administrative management work is also an important content. The collaborative office work in multiple departments requires more standardized, convenient, intelligent, and secure office systems. In response to this issue, this article analyzes the optimization and construction process of collaborative office systems based on the development of university informatization, summarizes the operational results, and explores the prospects of smart office.展开更多
基金supported by the National Natural Science Foundation of China (Nos.62175100 and 41790463)the National Key R&D Program of China (No.2018YFC1503200)+1 种基金the Spark Program of Earthquake Sciences of CEA (No.XH22015A)the Special Fund of the Institute of Geophysics,China Earthquake Administration (No.DQJB19B25)。
文摘At present, with the continuous development of technologies such as the Internet, big data, and artificial intelligence, smart campuses in universities are being rapidly constructed. Improving the informatization level of administrative management work is also an important content. The collaborative office work in multiple departments requires more standardized, convenient, intelligent, and secure office systems. In response to this issue, this article analyzes the optimization and construction process of collaborative office systems based on the development of university informatization, summarizes the operational results, and explores the prospects of smart office.
