Repository logo
 
Publication

Modelling based teaching with spreadsheet: a study in a health care course

2018-03Journal article Restricted access
Simple item page
dc.contributor.authorMachado, Nuno
dc.contributor.authorBaptista, Mónica
dc.date.accessioned2018-06-05T12:04:29Z
dc.date.available2018-06-05T12:04:29Z
dc.date.issued2018-03
dc.description.abstractComputer-based modeling tools allow students to express their theories in models that can be simulated. In this way, students can use their theories operationally, confronting themselves with the consequences of their ideas. The ability of students to form and express a mental model will be expanded if they are given an opportunity to become aware of their own mental model by expressing this same model and comparing it to other models, like a consensus model. The building of numerical models of biophysical phenomena, such as the mechanics of breathing, or blood circulation, has the potential for student motivation as well as long-term learning. Our theory is that by re-building well known numerical models of physiological phenomena students will have the opportunity to change their perceptions about the relevance of the contents addressed, simultaneously improving their learning in the topics covered and increasing their motivation in the basic science disciplines in their curricula. For the implementation of computer numerical models historically it was necessary to use some programming language, such as MATLAB, BASIC, C++, JAVA. With the development of computer science, it is now possible to these students ‘construc’ models of physical phenomena expressed through dedicated computer tools without necessarily having to do so in a programming language. As for example, we have STELLA, MODELLUS, or STARLOGO. There is also the possibility of using a spreadsheet such as Microsoft Excel, Open Office CALC, Google SHEETS, or others, as tools that allow students to express physical models. The current spreadsheets, even those available for free, are very powerful, having many integrated tools, in terms of calculation, and we can count on several other features, such as graphs of various types, buttons and other tools that allow interaction with the model, and databases that can be integrated into the spreadsheet. There are several advantages of using spreadsheets in science education due to its general access, through smartphones, tablet’s and computers, ease of implementation for the basic operations, and ease of the “debug” process, relative to other types of software. Also, it does not require prior knowledge of programming languages, or about complex mathematical software, which would an obstacle to the learning in itself. There is also the positive side effect of learning how to use a spreadsheet that is a plus in itself for the future professional’s. This paper will have a review of the state of the art of using spreadsheets in Modelling Based Learning. Also, it will be presented a study with first-year undergraduate students of a health care course, using Biophysical models historically very important in the physiology and medicine development.pt_PT
dc.description.versioninfo:eu-repo/semantics/publishedVersionpt_PT
dc.identifier.citationMachado N, Baptista M. Modelling based teaching with spreadsheet: a study in a health care course. In: INTED2018 Proceedings Papers – 12th International Technology, Education and Development Conference. Valencia:(Spain), March 05-07, 2018. p. 7289-95.pt_PT
dc.identifier.doi10.21125/inted.2018.1712pt_PT
dc.identifier.isbn978-84-697-9480-7
dc.identifier.urihttp://hdl.handle.net/10400.21/8563
dc.language.isoengpt_PT
dc.peerreviewedyespt_PT
dc.relation.publisherversionhttps://library.iated.org/view/MACHADO2018MODpt_PT
dc.rights.urihttp://creativecommons.org/licenses/by-nc-nd/4.0/pt_PT
dc.subjectPhysicspt_PT
dc.subjectBiophysicspt_PT
dc.subjectModelling based learningpt_PT
dc.subjectModelling based teachingpt_PT
dc.subjectSpreadsheetpt_PT
dc.titleModelling based teaching with spreadsheet: a study in a health care coursept_PT
dc.typejournal article
dspace.entity.typePublication
oaire.citation.endPage7295pt_PT
oaire.citation.startPage7289pt_PT
rcaap.rightsopenAccesspt_PT
rcaap.typearticlept_PT

Files

Original bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
Modelling based teaching with spreadsheet_a study in a health care course.pdf
Size:
183.42 KB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

ESTeSL - Artigos