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

Practice of Implementing Differentiated Calculation Exercise with Excel and VBA

作　　者：冷学礼[1] 邱燕[1] 宋占龙[1] 袁学良[1] LENG Xueli;QIU Yan;SONG Zhanlong;YUAN Xueliang(Shandong University School of Energy and Power Engineering,Jinan Shandong 250061,China)

机构地区：[1]山东大学能源与动力工程学院,山东济南250061

出　　处：《信息与电脑》2024年第17期166-170,共5页Information & Computer

基　　金：山东省本科教学改革研究重点项目“新能源科学与工程专业复合型人才培养模式研究与实践”(项目编号:220604903212736);山东大学教育教学综合改革重点项目“能源动力类新工科专业交叉复合型人才培养模式研究”(项目编号:2023Z15)。

摘　　要：课后作业是巩固大学知识学习、训练思维能力的重要环节。针对当前工科各课程计算作业中方法步骤基本固定的特点,本文开发了一款基于Excel文档的VBA程序,它能够实现同一作业题目下的数据差异化处理,促进了对学生在训练环节中,以自信、自立、自强为基础的独立思考和分析解决问题能力的核心素养的培养,并且为课程教师了解学生真实学业水平及公平、科学地考核平时成绩提供了有益借鉴。Post-course homework is an important part of consolidating university knowledge learning and training thinking ability.In view of the current characteristics of the basic fixed method steps in the calculation assignments of engineering courses,this paper develops a VBA program based on Excel document,which is able to realize the differentiated processing of data under the same assignment topic,promote the cultivation of the core quality of independent thinking and analytical problem solving ability based on self-confidence,self-reliance and self-improvement of the students in the training session,and provide useful reference for the course teachers to understand the real academic level of the students and assess the regular grades in a fair and scientific way.It also provides useful reference for course instructors to understand the real academic level of students and assess their regular grades in a fair and scientific way.

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

分 类 号：TP273.4[自动化与计算机技术—检测技术与自动化装置]