| |
 |
UNIVERSITY OF BUCHAREST
FACULTY OF PHYSICS Guest
2024-11-22 1:41 |
 |
|
|
|
Conference: Bucharest University Faculty of Physics 2012 Meeting
Section: Educational Physics
Title:
A Special Spreadsheet as Expert Assistant for the Study of the Gravitational Pendulum
Authors:
I.GRIGORE(1), H.V. TOMA(2), T. FERENER-VARI(2), Daniela STOICA(3)
Affiliation:
(1)"Lazar Edeleanu" National College, Ploiesti, Romania
(2)"Mihai Viteazul" National College, Ploiesti, Romania
(3)"Ion Luca Caragiale" National College, Ploiesti, Romania
E-mail
grigore_nl@yahoo.com
Horia_TOMA_CD@yahoo.com
tonio_fv07@yahoo.com
prof_dana_stoica@yahoo.com
Keywords:
gravitational pendulum
Abstract:
We have created a special spreadsheet, which is an expert assistant. If the user input a value of the measured time and the error of that value is big, the program shows immediately a false value of the constant of gravity. To obtain such a behavior it is necessary a virtual data acquisition and analysis before the input of the real data. At the beginning of the experiment all the values of the time from the central matrix of the spreadsheet are calculated by the code of the program and the computerized analyze of those virtual data gives the correct value of the constant of gravity. When the user replaces the code of the cells with real data he or she can see the change in the the value of g. If a value produces a big change of g that value must be replaced. Our software minimize twice the sum of the square errors during the experiments made to obtain the constant of gravity by using the gravitational pendulum. The spreadsheet is created for a series of experiments. Each experiment corresponds to a length of the pendulum. The number of the independent variables is 2. The dependent variables are: the number of the oscillations and the length of the gravitational pendulum. The dependent variable is the measured time. Its values are spread in the central matrix. The column of the number of oscillations is in the left side of the central matrix and the line which shows the length of the pendulum is above that matrix. A column of the central matrix corresponds to a length of the pendulum. At the end of each such a column it is shown a value of the period of the pendulum obtained by using the function SLOPE.
|
|
|
|