Fostering a Conceptual Understanding in Undergraduate Materials Education: A Multivariable Animated Spreadsheet Approach

Abstract

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.

References

  1. 1.

    Materials Science Excelets are available for download at http://academic.pgcc.edu/~ssinex/excelets/matsci_excelets.htm (accessed November 2010).

  2. 2.

    D. Gabel, Educational Horizons 81 (2), 70–76 (2003).

    Google Scholar 

  3. 3.

    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).

    Google Scholar 

  4. 4.

    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).

  5. 5.

    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).

    Google Scholar 

Download references

Author information

Affiliations

Authors

Corresponding author

Correspondence to A. Sinex Scott.

Rights and permissions

Reprints and Permissions

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

Download citation