基于VC++和VBA的Excel操作评分系统的研究与实现  

Research and Implementation of Excel Operation Scoring System Based on VC++and VBA

在线阅读下载全文

作  者:李玉艳 LI Yu-yan(Honghe Health Vocational College,Honghe 661100,China)

机构地区:[1]红河卫生职业学院,云南红河661100

出  处:《电脑知识与技术》2021年第14期58-59,共2页Computer Knowledge and Technology

摘  要:大学计算机基础是高职院校的一门公共必修基础课程。计算机一级考试是教育部门作为学生是否具备基本的计算机办公技能的衡量标准,而Excel上机操作便是该考试中的重点操作考核内容。为提升学生对Excel电子表格的操作能力和计算机等级一级考试的过关率,该文设计了一套基于VC++和VBA技术的Excel操作评分系统。该系统通过VC++实现人机对话,利用OLE技术实现Excel程序的调用,再利用VBA技术对Excel的各种对象属性进行了分析和成绩计算。该系统可以为同类高职院校的计算机教师提供开发参考。Basic Computer of College is a public compulsory basic course in higher vocational colleges.Computer Rank Examination Grade One is a standard to measure whether students have basic computer office skills for most colleges,in which,Excel operation is the important examination content.In order to improve students’operation ability to operate Excel spreadsheets and pass rate of Computer Rank Examination Grade One,this paper designs an Excel Operation Scoring System based on VC++and VBA technology.The system realizes man-machine interaction through VC++,uses OLE technology to call Excel program,and analyzes various object attributes of Excel and calculates scores by VBA technology.After the practical application in the author’s college,it shows that the system can improve students’Excel spreadsheets operation ability and pass rate of Computer Rank Examination Grade One.

关 键 词:VC++ VBA EXCEL 系统设计 操作评分 

分 类 号:G642[文化科学—高等教育学]

 

参考文献:

正在载入数据...

 

二级参考文献:

正在载入数据...

 

耦合文献:

正在载入数据...

 

引证文献:

正在载入数据...

 

二级引证文献:

正在载入数据...

 

同被引文献:

正在载入数据...

 

相关期刊文献:

正在载入数据...

相关的主题
相关的作者对象
相关的机构对象