•  
  •  
 

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.

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