以EXCEL与VBA编程实现计算作业数据差异化的实践.pdfVIP

信息与电脑

电子通信技术InformationComputer2024年第17期

以EXCEL与VBA编程实现计算作业数据差异化的实践

冷学礼邱燕宋占龙袁学良*

（山东大学能源与动力工程学院，山东济南250061）

摘 要：课后作业是巩固大学知识学习、训练思维能力的重要环节。针对当前工科各课程计算作业中方法步骤基本

固定的特点，本文开发了一款基于Excel文档的VBA程序，它能够实现同一作业题目下的数据差异化处理，促进了对

学生在训练环节中，以自信、自立、自强为基础的独立思考和分析解决问题能力的核心素养的培养，并且为课程教师了

解学生真实学业水平及公平、科学地考核平时成绩提供了有益借鉴。

关键词：作业技术创新；差异化布置；EXCEL编程

中图分类号：TP273.4   文献标识码：A   文章编号：1003-9767（2024）17-166-05

PracticeofImplementingDifferentiatedCalculationExercise

withExcelandVBAProgramming

*

LENGXueli,QIUYan,SONGZhanlong,YUANXueliang

(ShandongUniversitySchoolofEnergyandPowerEngineering,JinanShandong250061,China)

Abstract:Post-coursehomeworkisanimportantpartofconsolidatinguniversityknowledgelearningandtraining

thinkingability.Inviewofthecurrentcharacteristicsofthebasicfixedmethodstepsinthecalculationassignmentsof

engineeringcourses,thispaperdevelopsaVBAprogrambasedonExceldocument,whichisabletorealizethedifferentiated

processingofdataunderthesameassignmenttopic,promotethecultivationofthecorequalityofindependentthinkingand

analyticalproblemsolvingabilitybasedonself-confidence,self-relianceandself-improvementofthestudentsinthetraining

session,andprovideusefulreferenceforthecourseteacherstounderstandtherealacademiclevelofthestudentsandassess

theregulargradesinafairandscientificway.Italsoprovidesusefulreferenceforcourseinstructorstounderstandthereal

academiclevelofstudentsandassesstheirregulargradesinafairandscientificway.

Keywords:innovationinhomeworktechniques;differen