About this paper

Appears in:
Pages: 8831-8836
Publication year: 2019
ISBN: 978-84-09-08619-1
ISSN: 2340-1079
doi: 10.21125/inted.2019.2198

Conference name: 13th International Technology, Education and Development Conference
Dates: 11-13 March, 2019
Location: Valencia, Spain

LEARNING BIOPHYSICS THROUGH THE IMPLEMENTATION OF NUMERICAL MODELS IN SPREADSHEETS

N. Machado1, S. Branco1, M. Baptista2

1Escola Superior de Tecnologia da Saúde de Lisboa - IPL (PORTUGAL)
2Instituto de Educação Universidade de Lisboa (PORTUGAL)
Computer-based modelling tools allow students to try their own theories in a way that is easily tested by comparison with physical known results.

An alternative is to implement this type of modelling in spreadsheets such as Microsoft Excel, Open Office CALC, Google SHEETS. This type of software has the limitation of being visually less appealing when compared with others developed specifically for simulations, such as STELLA, MODELLUS, or STARLOGO, but on the other hand its implementation does not require prior knowledge of a programming language, or about complex mathematical software, which would be an obstacle to the learning in itself. Also the learning of the use of this computer tool can be an added value for the personal and professional development of the students involved.

This article presents an experience of application of development of simulations in a discipline of Biophysics. The simulators to be implemented by the students are related to the mechanics of breathing, the blood circulation and the propagation of nerve impulses. All simulations were completely developed in Microsoft Excel spreadsheets.

At the end of each of the four activities, a questionnaire was used to measure the progression of motivation during the semester, with a final questionnaire regarding the set of activities developed. From the results of these questionnaires we can see that there is a very slight positive progression in the perception of the importance of the topics covered, and in the methodology used.
@InProceedings{MACHADO2019LEA,
author = {Machado, N. and Branco, S. and Baptista, M.},
title = {LEARNING BIOPHYSICS THROUGH THE IMPLEMENTATION OF NUMERICAL MODELS IN SPREADSHEETS},
series = {13th International Technology, Education and Development Conference},
booktitle = {INTED2019 Proceedings},
isbn = {978-84-09-08619-1},
issn = {2340-1079},
doi = {10.21125/inted.2019.2198},
url = {http://dx.doi.org/10.21125/inted.2019.2198},
publisher = {IATED},
location = {Valencia, Spain},
month = {11-13 March, 2019},
year = {2019},
pages = {8831-8836}}
TY - CONF
AU - N. Machado AU - S. Branco AU - M. Baptista
TI - LEARNING BIOPHYSICS THROUGH THE IMPLEMENTATION OF NUMERICAL MODELS IN SPREADSHEETS
SN - 978-84-09-08619-1/2340-1079
DO - 10.21125/inted.2019.2198
PY - 2019
Y1 - 11-13 March, 2019
CI - Valencia, Spain
JO - 13th International Technology, Education and Development Conference
JA - INTED2019 Proceedings
SP - 8831
EP - 8836
ER -
N. Machado, S. Branco, M. Baptista (2019) LEARNING BIOPHYSICS THROUGH THE IMPLEMENTATION OF NUMERICAL MODELS IN SPREADSHEETS, INTED2019 Proceedings, pp. 8831-8836.
User:
Pass: