基于VBA的数据分析处理研究——以宜宾电大网上教学管理数据分析处理为例  

Research on Data Analysis and Processing Based on VBA—— Taking the Data Analysis and Processing of Online Teaching Management of Yibin Radio and TV University as an Example

作　　者：严增凯 Yan Zengkai(Yibin Radio and TV University, Yibin Sichuan 644002, China)

机构地区：[1]宜宾广播电视大学

出　　处：《信息与电脑》2019年第14期155-158,165,共5页Information & Computer

摘　　要：2015年国家开放大学正式启用学习网,在教学管理上,十分依赖学习网报表系统中相关教师教学和学生学习的行为数据。以宜宾电大网上教学管理数据分析为例,深入研究如何利用VBA编程进行数据分析处理,得出基层电大运用VBA处理网上数据的方法,对比分析Excel表中借助VBA个性化编程的数据分析处理特点,提出关于基层电大网上教学管理的相关建议。In 2015, the National Open University officially launched the Learning Network. In terms of teaching management, it relies heavily on the data of teachers'teaching and students' learning behavior in the reporting system of the Learning Network. Taking the data analysis of online teaching management of Yibin Radio and TV University as an example, this paper deeply studies how to use VBA programming for data analysis and processing, obtains the method of using VBA to process online data in grass-roots Radio and TV University, compares and analyses the characteristics of data analysis and processing in Excel table with the help of VBA personalized programming, and puts forward the correlation of online teaching management in grass-roots Radio and TV University. Suggestions.

关 键 词：VBA EXCEL编程 数据分析处理 教学管理 

分 类 号：TP391.1[自动化与计算机技术—计算机应用技术]