Learning Stoichiometry with Spreadsheet Simulations

Andrés Raviolo^1,

¹Universidad Nacional de Río Negro. Bariloche. Argentina

Cite this paper

Andrés Raviolo. Learning Stoichiometry with Spreadsheet Simulations. World Journal of Chemical Education. 2019; 7(3):203-208. doi: 10.12691/WJCE-7-3-3

Abstract

The pedagogical role of simulations in the teaching of chemistry is discussed here, along with the contribution made by simulations designed with spreadsheets, and the possibility of these being created by the students themselves. A sequence of activities is presented for use in the teaching of stoichiometry by means of simple spreadsheets that have the scroll bar incorporated as an interactive resource. Using this method as an alternative to routine ways of doing exercises, students will become more motivated and active, setting up numerical simulations and answering questions like “What happens if…?” Simultaneous visualization of initial and final experimental quantities, and of the stoichiometric relation, makes it possible to deal with students’ alternative conceptions.

Keywords

stoichiometry, learning, teaching, simulation, spreadsheets, scroll bar

Copyright

This work is licensed under a Creative Commons Attribution 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by/4.0/

References

[1]	Suits, J. and Sanger, M. Pedagogic roles of animations and simulations in chemistry courses, ACS, Oxford University Press, Washington DC, 2013.
[2]	Stieff, M. and Ryan, S., Explanatory model for the research & development of chemistry visualizations, In J. Suits and M. Sanger (Ed.), Pedagogic roles of animations and simulations in chemistry courses, ACS, Oxford University Press, Washington DC, 2013, 15-41.
[3]	Wieman,C., Adams, W. and Perkins, K., “PhET: Simulations that enhance learning,” Science, 322, 682-683, 2008.
[4]	Rutten, N., Van Joolingen, W. and Van Der Veen, J., “The learning effects of computer simulations in science education,” Computers and Education, 58 (1), 136–153, 2012.
[5]	Rieber, L. P., Multimedia learning in games, simulations and microworlds, In The Cambridge Handbook of Multimedia Learning, Mayer, R. E., Ed., Cambridge University Press, New York, 2005, 549-567.
[6]	Renken, M., Peffer, M., Otrel-Cass, K., Girault, I. and Chiocarriello, A., Simulations as scafflolds in science education, Springer, New York, 2016.
[7]	Baker, J. and Sugden, S., “Spreadsheets in education – The first 25 years,” Spreadsheets in Education, 1(1), article 2, 2003.
[8]	Diamond, D. and Hanratty, V., Spreadsheet applications in chemistry using Microsoft Excel, Wiley Interscience, New York, 1997.
[9]	de Levie, R., How to use Excel in Analytical Chemistry and in general scientific data analysis, Cambridge Universty Press, Cabridge, 2004.
[10]	Frazer, M. and Servant, D., “Aspects of stoichiometry, where do students go wrong?” Education in Chemistry, 24, 73-75, 1987.
[11]	Mitchell, I. and Gustone, R., “Some student conceptions brought to the study of stoichiometry,” Research in Science Education, 14, 78-88, 1984.
[12]	Huddle, P. and Pillay, A., “An in-depth study of misconceptions in stoichiometry and chemical equilibrium at a South African University,” Journal of Research in Science Teaching, 23 (1), 65-77, 1996.
[13]	Arasasingham, R., Taagepera, M., Potter, F. and Lonjers, S., “Using knowledge space theory to access student understanding of stoichiometry,” Journal of Chemical Education, 81, 1517-1523, 2004.
[14]	Gauchon, L. and Méheut, M., “Learning about stoichiometry: from students` preconceptions to the concept of limiting reactant,” Chemistry Education Research and Practice, 8 (4), 362-375, 2007.
[15]	Pinto, G. and León, S., “Estequiometría i vida cuotidiana” [Stoichiometry and everyday life], EduQ, 3, 29-36, 2009.
[16]	Raviolo, A. and Lerzo, G., “Enseñanza de la estequiometría: uso de analogías y comprensión conceptual” [Teaching of stoichiometry: Analogies and conceptual understanding], Educación Química, 27, 195-204, 2016.
[17]	Rosenberg, R., “The spreadsheet,” Journal of Chemical Education, 62, 140-141, 1985.
[18]	Van Houten, J., “Chemistry on a spreadsheet,” Journal of Chemical Education, 65, A314-A315, 1988.
[19]	Collins, F. and Williams, C., “Management of first-year chemistry laboratories using spreadsheets”. Journal of Chemical Education, 72, A182-A183, 1995.
[20]	Zielinski, T. and Swift, M. (Ed.), Using computers in chemistry and chemical education, American Chemical Society, Washington DC, 1997.
[21]	Raviolo, A., “Re-creando simulaciones con la hoja de cálculo” [Re-creating simulations with spreadsheets], Educación Química, 23, 11-15, 2012a.
[22]	Raviolo, A., “Using a spreadsheet scroll bar to solve equilibrium concentrations,” Journal of Chemical Education, 89, 1411-1415, 2012b.