| |
 |
UNIVERSITY OF BUCHAREST
FACULTY OF PHYSICS Guest
2024-11-23 17:46 |
 |
|
|
|
Conference: Bucharest University Faculty of Physics 2014 Meeting
Section: Physics Education
Title:
The study of the transient regime in electric circuits with Excel spreadsheets
Authors:
I. GRIGORE(1,2), Cristina MIRON(1), E.S. BARNA(1)
Affiliation:
1) University of Bucharest, Faculty of Physics, Bucharest-Magurele, Romania
2) "Lazar Edeleanu" Technical College, Ploiesti, Romania
E-mail
grigore_nl@yahoo.com
Keywords:
spreadsheets, electric circuits, capacitor, physics education
Abstract:
The present work focuses on the use of Excel spreadsheets in the study of the transient regime in electric circuits. Two relevant didactic tools, which have been created with the help of spreadsheets, are presented for the study of the transient regime in a circuit with resistance and capacity connected in series. With the aid of the first instrument we can simulate the charging and discharging of a capacitor. By changing the input data we can easily track how the charging and, respectively, the discharging curves change for the electric charge of the capacitor, the voltage across the capacitor and the current through the circuit. The significance of the time constant for the RC circuit is emphasized in graphs. The energetic characterization of the transient regime is done through a graph presenting the energy variation in time, from the capacitor, and the energy dissipated in the resistor. For a comparative analysis a graph is drawn, overlaying the curves of the time dependency in case of the capacitor voltage from three different RC circuits. The second tool has been conceived to process the data in the didactic experiment to study the process of discharging of a capacitor on a resistor. The voltage on the capacitor terminals measured during the discharging process is compared to the voltage calculated with the exponential variation law of the process. From the discharging curve we can determine the capacity of the capacitor and, thus, certain experimental results are presented. The two previously described tools prove the facilities offered by spreadsheets in conceiving interactive Physics lessons. On the one hand, the possibility to simulate some physical phenomena is highlighted; on the other hand, it is shown that spreadsheets can be successfully used in the processing of experimental data.
|
|
|
|