运用Excel软件剖析电路中的非线性问题

Using Excel Software to Analyze the Nonlinear Problems in the Circuit

在新课程理念下,加强学生与社会以及生活之间的联系成为各科教师教学的主要目标。电路是我们日常生活中十分常见的一个事物,我们在生活中见到的电路大多包含热敏电阻以及光敏电阻等,因为它们之间存在非线性关系,因此几乎无法通过公式法来进行处理,从而导致学生在遇到此类问题时无从下手,只能被迫放弃。而随着Excel软件的普及,这种问题便得到了有效的解决。为此本篇文章就简单阐述了如何通过Excel软件来解决物理电路中的非线性问题,同时直观以及形象地证明了在高中阶段电学实验里的滑动变阻器不同接法的器材选择原则。

Under the new curriculum concept,strengthening the connection between students and society as well as life has become the main goal of teachers in all subjects.Circuit is a very common thing in our daily life.Most of the circuits we see in our life include thermistors and photoresistors,etc.Because there is a nonlinear relationship between them,it is almost impossible to deal with them by formula method,thus causing students to have no way to deal with such problems and have to give up.