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

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

在化学动力学和化学反应工程等课程的实验教学中,涉及到无法积分的一阶微分动力学方程组,通常需要编程方法求解。采用数值积分和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.