#
Impact of a Spreadsheet Exploration on Secondary School Students’ Understanding of Statistical Graphs
Article

## Yingkang Wu, Mathematics Department, East China Normal University, China ; Khoon Yoong Wong, Mathematics and Mathematics Education Academic Group, National Institute of Education, Nanyang Technological University, Singapore

JCMST Volume 26, Number 4, ISSN 0731-9258 Publisher: Association for the Advancement of Computing in Education (AACE), Waynesville, NC USA

## Abstract

This case study investigated the impact of a spreadsheet (EXCEL) exploration on the understanding of statistical graphs among twenty Singapore secondary school students of average ability. Four EXCEL templates were constructed to allow students to explore four aspects of statistical graphs: zero in scale, effect of different scales, size pictogram, and cumulative line graph. The exploration was guided with questions and interactive feedback embedded in the templates. The students worked in pairs and took a pre- and post-test about statistical graphs. Pair discussion, field notes, and online entries captured by macros were analyzed, resulting in the identification of an isolated approach and a relational approach used by these students in their EXCEL exploration. Three quarters of the students showed gain scores in the post-test, suggesting positive impacts of this exploration on students' understanding of statistical graphs. The findings suggest further effort to extend the use of spreadsheet to other statistics and mathematics topics. Several areas for further research are discussed.

## Citation

Wu, Y. & Wong, K.Y. (2007). Impact of a Spreadsheet Exploration on Secondary School Students’ Understanding of Statistical Graphs. Journal of Computers in Mathematics and Science Teaching, 26(4), 355-385. Waynesville, NC USA: Association for the Advancement of Computing in Education (AACE). Retrieved November 22, 2019 from https://www.learntechlib.org/primary/p/23527/.

© 2007 Association for the Advancement of Computing in Education (AACE)

### Keywords

## References

View References & Citations Map- Ainley, J. (1995). Re-viewing graphing: Traditional and intuitive approaches. For the Learning of Mathematics, 15(2), 10-16.
- Ainley, J., Nardi, E., & Pratt, D. (1999). Constructing meaning for formal notation in active graphing. In I. Scwank (Ed.), Proceedings of the ﬁ rst conference of the European society for research in mathematics education. Osnabrueck: Forschungsinstitut fuer Mathematikdidaktik. Retrieved December 3, 2002, from http://www.fmd.uni-osnabrueck.de/ebooks/erme/cerme1-proceedings/
- Ausubel, D.P. (1968). Educational psychology: A cognitive view. New York: Holt, Rinehart and Winston.
- Baker, J.E., & Sugden, S.J. (2003). Spreadsheets in education: The ﬁ rst 25 years. Spreadsheets in Education, 1(1), 18-43. Retrieved September 7, 2004, from http://www.sie.bond.edu.au/articles/1.1/bakersugden.pdf Behr, M., & Harel, G. (1990). Students’ errors, misconceptions, and cognitive conﬂ ict in application of procedures. Focus on Learning Problems in Mathematics, 12(3/4), 75-84.
- Bell, A. (1993). Principles for the design of teaching. Educational Studies in Mathematics, 24(1), 5-34.
- Ben-Zvi, D. (2000). Toward understanding the role of technological tools in statistics learning. Mathematical Thinking and Learning, 2(1/2), 127-155.
- Ben-Zvi, D., & Friedlander, A. (1997). Statistical thinking in a technological environment. In J.B. Garﬁ eld & G. Burrill (Eds.), Research on the role of technology in teaching and learning statistics: Proceedings of the 1996 IASE roundtable conference (pp. 54-64). Voorburg, The Netherlands: International
- Carpenter, T.P., & Lehrer, R. (1999). Teaching and learning mathematics with understanding. In E. Fennema & T.A. Romberg (Eds.), Mathematics classrooms that promote understanding (pp. 19-32). Mahwah, NJ: Lawrence Erlbaum.
- Castle, R. (2002). Using interactive visualization to develop statistical understanding. In B. Phillips (Ed.), Proceeding of the Sixth International Conference on Teaching Statistics (ICOTS 6). [CD version]
- Davies, N. (2002). Ideas for improving learning and teaching of statistics. In P. Kahn& J. Kyle (Eds.), Effective learning& Teaching in mathematics& Its applications (pp. 175-193). London: Kogan Page.
- Davis, R.B., Maher, C.A., & Noddings, N. (1990). Introduction: Constructivist views on the teaching and learning of mathematics. In R.B. Davis, C.A. Maher, & N. Noddings (Eds.), Constructivist views on the teaching and learning of mathematics (pp. 1-3). Reston, VA: National Council of Teachers
- Fernandez, G.C.J., & Liu, L.P. (1999). A technology-based teaching model that stimulates statistics learning. Computers in the Schools, 16(1), 173-191.
- Goos, M. (2002). Understanding metacognitive failure. Journal of Mathematical Behavior, 21, 283-302.
- Harper, S.R. (2004). Students’ interpretation of misleading graphs. Mathematics Teaching in the Middle School, 9(6), 340-343.
- Huff, D. (1982). How to lie with statistics. New York: W.W. Norton& Company.
- Hughes, M., & Greenhough, P. (1995). Feedback, adult intervention, and peer collaboration in initial Logo learning. Cognition and Instruction, 13(4), 525-539.
- Jackson, D.F., Edwards, B.J., & Berger, C.F. (1993). Teaching the design and interpretation of graphs through computer-aided graphical data analysis. Journal of Research in Science Technology, 30(5), 483-501.
- Jaworski, B. (1994). Investigating mathematics teaching: A constructivist enquiry. London: Falmer Press.
- Kerslake, D. (1981). Graphs. In K.M. Hart (Ed.), Children’s understanding of mathematics: 11-16 (pp. 120-136). London: John Murray.
- Lenton, G., Stevens, B., & Illes, R. (2000). Numeracy in science: Pupils’ understanding of graphs. School Science Review, 82(299), 15-23.
- Li, K.Y., & Shen, S.M. (1992). Students’ weakness in statistical projects. Teaching Statistics, 14(1), 2-8.
- McDonald, J.L. (1988). Integrating spreadsheets into the mathematics classroom. The Mathematics Teacher, 81(8), 615-622.
- Nash, J.C., & Quon, T.K. (1996). Issues in teaching statistical thinking with spreadsheets. Journal of Statistics Education, 4(1). Retrieved from December 20, 2001, from http://www.amstat.org/publications/jse/v4n1/nash.html
- Ng, V.M., & Wong, K.Y. (1999). Using simulation on the Internet to teach statistics. Mathematics Teacher, 92(8), 729-733.
- Oerter, R. (1992). The zone of proximal development for learning and teaching. In F.K. Oser, A. Dick, & J. Patry (Eds.), Effective and responsible teaching: The new synthesis (pp. 187-202). San Francisco: Jossey-Bass.
- Steffe, L.P. (1990). Inconsistencies and cognitive conﬂ ict: A constructivist’s view. Focus on Learning Problems in Mathematics, 12(3/4), 99-109.
- Tufte, E.R. (1983). The visual display of quantitative information. Cheshire, CT: Graphics Press.
- Von Glasersfeld, E. (1996). Learning and adaptation in constructivism. In L. Smith (Ed.), Critical readings on Piaget (pp. 22-27). London: Routledge.
- Vygotsky, L.S. (1978). Mind in society: The development of higher psychological processes. Cambridge, MA: Harvard University Press.
- Wainer, H. (1992). How to display data badly. Reprinted in R.L. Weber (Ed.), Science with a smile (pp. 252-278). Bristol, UK: Institute of Physics Publishing.
- Watson, J.M., & Moritz, J.B. (2001). Developing of reasoning associated with pictographs: Representing, interpreting, and predicting. Educational Studies in Mathematics, 48(1), 47-81.
- Wong, K.Y. (1997). EXCEL mathematics: Using templates. Unpublished training manual. Brunei Darussalam: Universiti Brunei Darussalam.
- Wu, Y. (2005). Statistical graphs: Understanding and attitude of Singapore secondary school students and the impact of a spreadsheet exploration. Unpublished doctoral dissertation. National Institute of Education, Nanyang Technological University, Singapore. Notes

These references have been extracted automatically and may have some errors. Signed in users can suggest corrections to these mistakes.

Suggest Corrections to References## Cited By

View References & Citations Map-
### STEM Academy: MIddle school students learn about graphing using technology tools

#### Angelia Reid-Griffin & Kelli Slaten, UNC Wilmington, United States

Society for Information Technology & Teacher Education International Conference 2014 (Mar 17, 2014) pp. 2947–2951

These links are based on references which have been extracted automatically and may have some errors. If you see a mistake, please contact info@learntechlib.org.