•  
  •  
 

Abstract

The paper gives three examples of numeric modeling with spreadsheets in secondary school (age 15+) physics and biology − free fall in the air, animal population, and damped oscillation. The aim is to introduce the reader to numeric modeling. The simplest numeric methods are used − Euler’s, and the finite difference method. The models enable student to experiment with the inputs and investigate the behavior of the systems.

Distribution License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

benacka_animal_population_rev.xls (141 kB)
benacka_animal_population_revised

benacka_damped_oscillation_rev.xls (146 kB)
benacka_damped_oscillation_revised.xls

benacka_free_fall_rev.xls (254 kB)
benacka_free_fall_revised.xls

Share

COinS