Investigating Transformations in the Cartesian Plane Using Spreadsheets
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.
[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.
[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.
@article{"International Journal of Engineering, Mathematical and Physical Sciences:51183", author = "D. Allison and A. Didenko and G. Miller", title = "Investigating Transformations in the Cartesian Plane Using Spreadsheets", 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.", volume = "7", number = "1", pages = "1-4", }
