Investigating Transformations in the Cartesian Plane Using Spreadsheets

Authors: D. Allison, A. Didenko, G. Miller

Abstract:

The link between coordinate transformations in the plane and their effects on the graph of a function can be difficult for students studying college level mathematics to comprehend. To solidify this conceptual link in the mind of a student Microsoft Excel can serve as a convenient graphing tool and pedagogical aid. The authors of this paper describe how various transformations and their related functional symmetry properties can be graphically displayed with an Excel spreadsheet.

Keywords: Mathematics education, Microsoft Excel spreadsheet, technology.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1056354

References:

[1] R.M. Reis, Development of Educational Software, International Journal of Education and Information Technologies, Vol. 1, Iss. 3 (2007), pp. 167-171.
[2] R. Fang, H.J. Yang, H.L. Tsai, C.J. Lee and D. Li, The Digital Instrument Support Teacher-s Instructional Innovation, International Journal of Education and Information Technologies, Vol. 1, Iss. 4 (2007), pp. 215-222.
[3] R. Fang, H.J. Yang, H.L. Tsai, C.J. Lee, T. Tsai and D. Li, A Type of Technological Course with using Information Technology, International Journal of Education and Information Technologies, Vol. 1, Iss. 4 (2007), pp. 181-187.
[4] I.I. Siller-Alcala, R. Alcantara-Ramirez, J. Jaimes-Ponce and J.P. Vaca- Pliego, How to link theory and practice of control engineering: Practices in real time and simulation, International Journal of Education and Information Technologies, Vol. 1, Iss. 2 (2007), pp. 114-120.
[5] O.V. Vejar, Implementation of Schooling Based on Technologies for Communication and Information in the Subject Physics II, Distance Learning, Multimedia and Video Technologies, 8th WSEAS International Conference on Multimedia, Internet and Video Technologies/8th WSEAS International Conference on Distance Learning and Web Engineering, University of Cantabria, Santander, Spain, 2008, pp. 61-66.
[6] H. Z. Poor, Administration of Faculties by Information and Communication Technology and Its Obstacles, International Journal of Education and Information Technologies, Vol. 2, Iss. 1 (2008), pp. 24- 30.
[7] R. Matusu, J. Vojtesek and T. Dulik, Technology-Enhanced Learning Tools in European Higher Education, Distance Learning, Multimedia and Video Technologies, 8th WSEAS International Conference on Multimedia, Internet and Video Technologies/8th WSEAS International Conference on Distance Learning and Web Engineering, University of Cantabria, Santander, Spain,2008, pp. 51-54.
[8] H.M. El-Bakry and N. Mastorakis, Realization of E-University for Distance Learning, Distance Learning, Multimedia and Video Technologies, 8th WSEAS International Conference on Multimedia, Internet and Video Technologies/8th WSEAS International Conference on Distance Learning and Web Engineering, University of Cantabria, Santander, Spain,2008, pp. 17-31.
[9] http://www.nctm.org/standards/content.aspx?id=26809
[10] M. Kathleen Heid and G.W. Blume (Editors) (2008), Research on Technology and the Teaching and Learning of Mathematics: Volume 1. Information Age Publishing, Inc., Charlotte, NC, USA, 978-1-931576- 19-2.
[11] J. Baker and S. Sugden (2003), Spreadsheets in Education - The First 25 Years, Spreadsheets in Education (eJSiE): Vol. 1: Iss. 1, Article 2
[12] A. Didenko, D. Allison, S. Steward, Using technology to forge the link between formal mathematical definitions and related problem-solving techniques, 3rd Annual Conference for Middle East Teachers of Science, Mathematics and Computing, Abu Dhabi, UAE, pp.119-126, 2006.
[13] A. Didenko, G. Miller, Algebraic and linear algebraic algorithms with EXCEL, 3rd Annual Conference for Middle East Teachers of Science, Mathematics and Computing, Abu Dhabi, UAE, 2006, p.4.
[14] Gary Miller, Andriy Didenko, David Allison, Orthonormalization by Spreadsheet, 6th UAE MATHDAY Conference, PI, Abu Dhabi, UAE, 2008.-3pp.
[15] A. Didenko, D. Allison, and G. Miller, Graphing Parametric Curves Using Spreadsheets, 34th Conference on Applications of Mathematics in Engineering and Economics - AMEE 2008, M. Todorov, Ed. New York: American Institute of Physics, 2008, pp. 187-195.
[16] A. Didenko, D. Allison and G. Miller, Using Spreadsheets as Graphing Tools, 6th UAE Mathday Conference, The Petroleum Institute, Abu Dhabi, UAE, 2008.
[17] A. Didenko, D. Allison, Using Microsoft Excel as a tool for teaching calculus to engineering students, 3rd International Conference on Mathematical Sciences (ICM-2008), UAE University, Al Ain, UAE, 2008.
[18] A. Didenko, D. Allison, G. Miller, The Technology of Drawing a Straight Line, 7th UAE Mathday, Sharjah University, Sharjah, UAE, 2009, p.19
[19] A. Didenko, D. Allison, G. Miller, Graphing Polar Equations Using Spreadsheets, 6th WSEAS International Conference on Engineering Education, Rodos, Greece, 2009, 108-110.
[20] A. Didenko, D. Allison, G. Miller, Exploring Polar Equations with Interactive Spreadsheets, International Journal of Education and Information Technologies, Issue 2, Volume 4, 2010, 57-64.
[21] A. Didenko, D. Allison, G. Miller, Exploring Taylor Polynomials Using Spreadsheets, International Conference on Interactive Computer Aided Learning, Villach, Austria, 2009, 99-102.
[22] A. Didenko, D. Allison, G. Miller, Computer Aided Teaching of Engineering Mathematics, International Journal of Arts and Sciences 4(2): pp.146-157, 2011.
[23] A. Didenko, D. Allison, G. Miller, A pedagogical software tool to explore the effects of symmetry operations on graphs, International Journal of Arts and Sciences, vol. 4, no. 11, pp.35-45, 2011.
[24] J. Hornsby, M.L. Lial and G.K. Rockswold, A Graphical Approach to Precalculus, Boston, AddisonWesley, 2007.