使用Excel求解动力学微分方程组参数的教学实践  

Teaching practice on solution of parameters for kinetic differential equations using Excel software

作　　者：葛华才[1] 李映伟[1] 华婷婷[1] 

机构地区：[1]华南理工大学化学与化工学院,广东广州510640

出　　处：《实验室科学》2017年第1期97-100,共4页Laboratory Science

基　　金：广东省级精品教材建设项目(项目编号:201402);华南理工大学教研项目(2015)和研究生教研项目(项目编号:yjzk2014003)

摘　　要：在化学动力学和化学反应工程等课程的实验教学中,涉及到无法积分的一阶微分动力学方程组,通常需要编程方法求解。采用数值积分和Excel的"规划求解"功能,通过使计算的浓度的相对偏差平方和最小的方法求解动力学参数,完全无需编程。讨论了时间间隔和方程参数初值的选取等问题。经多年的教学实践表明,该方法通俗易懂,学生容易掌握。In some experimental courses such as chemical kinetics and chemical reaction engineering,first-order differential kinetic equations often needed to be solved by programming. The numerical method and solver of Excel software were used to solve the parameters of these equations by minimizing the sum of squares of relative deviation of the calculated concentrations without programming. The choices of the time interval and parameters were discussed. The teaching practice indicated that this method was easy to understand and learn for students.

关 键 词：微分动力学方程 数值解 EXCEL 实验教学 

分 类 号：O643[理学—物理化学]