We describe how students explore materials science concepts using animated interactive spreadsheets. An engaging pedagogy is created in the classroom using spreadsheets in a way that initially camouflages mathematical complexity, which can later be revealed and taught. Use of off-the-shelf spreadsheet software, including freeware makes these spreadsheets universally available.
This is a preview of subscription content, access via your institution.
Buy single article
Instant access to the full article PDF.
Tax calculation will be finalised during checkout.
Materials Science Excelets are available for download at http://academic.pgcc.edu/~ssinex/excelets/matsci_excelets.htm (accessed November 2010).
D. Gabel, Educational Horizons 81 (2), 70–76 (2003).
S.A. Sinex, Scientific and Algebraic Thinking: Visualizing with Interactive Excel and Nested Styrofoam Cups, in On-Line Proceedings of the 34th Annual Conference of the American Mathematical Association of Two-Year Colleges in Washington, DC (2008). [Online] Available: http://www.amatyc.org/Events/conferences/2008DC/proceedings2008/sinex1.pdf (accessed November 2010).
S.A. Sinex, Chemical spreadsheet investigations: Empowering student learning of concepts via camouflaged mathematical exploration, in Using Computers in Chemical Education Newsletter, Fall 2007 issue (2007). [Online] Available: http://academic.pgcc.edu/~ssinex/UCCEN_F07/UCCEN_F07.pdf. (accessed November 2010).
S.A. Sinex and J.B. Halpern, Discovery learning tools in materials science: Concept visualization with dynamic and interactive spreadsheets, in Proceedings of the Materials Research Society Symposium: Materials Education, vol. 1233, 91–96 (2010).
About this article
Cite this article
Scott, A.S., Joshua, B.H. Fostering a Conceptual Understanding in Undergraduate Materials Education: A Multivariable Animated Spreadsheet Approach. MRS Online Proceedings Library 1320, 408 (2011). https://doi.org/10.1557/opl.2011.637