Excel软件在酸碱滴定分析教学中的应用  

Application of Excel software tool in acid-base titration teaching

作　　者：岳宣峰[1] 张延妮[2] 卢樱[1] 张志琪[1] 

机构地区：[1]陕西师范大学化学与材料科学学院,陕西西安710062 [2]陕西师范大学生命科学学院,陕西西安710062

出　　处：《计算机与应用化学》2006年第11期1153-1155,共3页Computers and Applied Chemistry

基　　金：陕西师范大学博士创新基金教育部科技重点项目(01156)

摘　　要：通过对一元强碱滴定同浓度一元强酸及弱酸滴定曲线的绘制步骤,介绍其在绘制酸碱滴定曲线中的应用；通过求解高次方程从而实现对二元弱酸石酸pH的计算,介绍其在计算某些复杂酸碱体系pH值时的应用。利用Microsoft Excel软件绘制滴定曲线,免去了大量数据的输入及复杂计算,简便、快速；利用其计算复杂酸碱体系的pH,其便利是传统逐步逼近法无可比拟的。The application of Excel software in plotting titration curve was introduced through plotting the titration curve of strong base to strong acid and weak acid of the same concentration ; the application of Excel in calculating the pH of complex system was also introduced through solving equation of higher degree to obtain the pH of tartaric acid. Plotting titration curve with the aid of Excel is quick and simple because of avoiding the input of numerous data and complex calculation ; as to the convenience of calculating the pH of complex system, adopting conventional method of stepwise approach cannot be parallel to adopting Excel.

关 键 词：EXCEL软件 酸碱滴定分析 应用 

分 类 号：TQ015.9[化学工程]