数据处理软件在误差理论教学中的运用

Application of data processing software in error theory teaching

数据和计算量大是误差理论与数据处理课程教学中存在的主要问题之一。微软的Excel具有易学易用、数据处理功能丰富的特点,引入Excel可以提高课程教学的质量。本文简述了用Excel进行数据处理时常用的功能,并给出了3个课堂实例及相关的公式与操作方法。实例表明,用Excel辅助误差理论教学使学生从繁杂的计算中解脱出来,将注意力集中于数据处理的理论与方法。

Large amount of data and calculation quantity is one of the key problems in error theory and data processing teaching. With excellent property of being easy to learn and use, microsoft excel has powerful data processing function. Introducing Excel in teaching can improve the teaching effect significantly. The paper introduces functions that can be used frequently in data processing. The procedures and operation methods of three typical examples are presented. The examples show that excel-aided education can make students pay more attention to the fundamental and method of the data processing instead of complicated data and computation.