Excel透视表在电大教务管理信息系统中的应用

The Excel PivotTable's Application in the Educational Administration Management Information System of the Radio and TV University

本文展示了Excel透视表结合SQL Server2000的使用技术,如何利用广播电视大学教务管理信息系统数据资源,为教务、教学管理提供科学的统计分析依据。

This paper introduces the usage technique of Excel PivotTable and SQL Server2000,and how to use the data resources of the Educational Administration Management Information System of the Radio and TV University. Thus it puts forward scientific statistic analysing evidence for educational administration and teaching management.