Excel在分析化学实验数据处理中的应用

Application of Excel for Dealing with Date in the Teaching of Analytical Chemistry Experments

数据处理是分析化学实验中必不可少的一个环节。将Excel应用于磺基水杨酸铁(Ⅲ)配合物的组成及稳定常数测定的数据处理。与我校传统的教学方法——坐标纸法相比,Excel法具有简便、快速、准确、降低主观误差的优势。结果表明,采用该方法的教学设计,能够有效促进学科融合,激发学生学习兴趣,提高学生综合素质。

Dealing with date plays a necessary part in analytical chemistry experiment.In this paper,excel was used to analytical the experiment date in the composition and stability constant determination of sulfosalicylic acid complex of Fe（Ⅲ）.Compared with the traditional teaching method―using the coordinate paper to analytical the date,excel had the advantages of simple,rapid,accurate,little subjective error.The results indicated that the subjects have been integrated with each other,the interesting and learning initiative was enhanced and the comprehensive quality was improved