广西计算机等级考试成绩实例分析

Analysis of Examples from Guangxi Computer Rank Examination

在全国高校计算机考试(广西考区)中,考试成绩以Excel表格的形式按高校进行分类储存。作者采用Excel Link连接Excel和Matlab软件,利用Matlab强大的数据计算和可视化能力对Excel中的数据进行分析处理。分析结果显示,广西各高校计算机基础教学水平逐步提高,考试命题质量趋于稳定。数据处理过程具有普适性,可作为区内各高校考试成绩分析的参考。

The examination results of common computer test（Guangxi area） store in the form of Excel sheets which are classified by each university. In order to take advantages of powerful data processing and visualization abilities from Matlab to analyze and process data stored in Excel,the author uses the tool of Excel Link to connect Excel and Matlab software. The results showed that the level of universities＇ basic computer teaching gradually improves and the quality of examination questions incline to sta- ble. The method of data processing is universal,which could act as the reference of university＇s exams grade analysis.