Perspectivas do uso de Planilhas Eletrônicas no Ensino de Estatística

Palavras-chave: Estatística, Planilha Eletrônica, Simulação

Resumo

Muitos professores acreditam que uma planilha eletrônica fornece um melhor ambiente educacional para ensinar estatística em nível elementar. A planilha eletrônica pode ser uma ferramenta facilitadora para o aluno, permitindo que particione os cálculos para que possa entender conceitos estatísticos. Este trabalho tem como objetivo apresentar um panorama geral do uso de planilhas eletrônicas, em especial a planilha eletrônica Microsoft Excel® no ensino de Estatística através de um conjunto de trabalhos que tratam do referido tema, bem como a possibilidade do uso da planilha eletrônica para simulação com o emprego de imagens.  Os resultados do levantamento realizado evidenciam diversas possibilidades para o desenvolvimento de atividades no campo do ensino da Estatística, desde os mais simples, com uso de medidas sintéticas e gráficos, até o uso de experimentos e modelagem. Não há um consenso sobre o uso de planilhas eletrônicas para ensino de Estatística e críticas são comuns, no entanto, diversas aplicações e atividades, em especial, a facilidade de desenvolver simulações, podem contribuir para a o processo de ensino-aprendizagem.

Downloads

Não há dados estatísticos.

Referências

AGEEL, M.I. Spreadsheets as a Simulation Tool for Solving Probability Problems. Teaching Statistics, v. 24, n. 2, p. 51 – 54, 2002.

ARGANBRIGHT, D. The Electronic Spreadsheet and Mathematical Algorithms. The College Mathematical Journal, v. 15, p. 148—157, 1984.

ASMAT, A.; SAMSUDIN, S. S.; WAHID, S. N. S. Learning statistics course using computer aided software: a case study among furniture technology students. International Journal of Modern Trends in Social Sciences, v. 3, n. 11, p. 99 – 106, 2020.

BARR, G. D.; SCOTT, L. Teaching statistics in a spreadsheet environment using simulation. Spreadsheets in Education, v. 4, n. 3, p. 1–16, 2011.

BARRETO, H. Why Excel? The Journal of Economic Education, v. 46, n.3, p. 300–309, 2015.

BELL, P.C. Teaching Business Statistics with Microsoft Excel. INFORMS Transactions on Education, v. 1, n. 1, p. 18–26, 2000.

BERNABEU, C. B. Joint ICMI/IASE Study: teaching statistics in school mathematics. challenges for teaching and teacher education. Cuadernos de Investigación y Formación en Educación Matemática, n. 10, p. 221–229, 2012.

CAÑADAS, G. R.; BATANERO, C. D.; CARMEM Y ROA, R. Psychology Students’ Understanding of The Chi-Squared Test. Statistique et Enseignement, v. 3, n. 1, p. 3–8, 2012.

CHAAMWE, N.; SHUMBA, L. ICT Integrated Learning: Using Spreadsheets as Tools for e-Learning, A Case of Statistics in Microsoft Excel. International Journal of Information and Education Technology, v. 6, n. 6, p. 435 – 440, 2016.

CHANCE, B.; ROSSMAN, A. Using simulation to teach and learn statistics. ICOTS 7 2006, Salvador, Bahia.

CHANDRAKANTHA, L. Simulation using excel data tables in teaching introductory statistics. Journal of Computing Sciences in Colleges, v. 29, p. 29–34, 2014.

CHRISTIE, D. Resampling with Excel. Teaching Statistics. v. 26, n. 1, p. 9 – 14, 2004.

CLAYTON, H. R., SANKAR, C. S. Using Spreadsheets to Enhance Learning in the Affective Domain for Undergraduate Statistics Students. INFORMS Transactions on Education, v. 10, n.1, p. 10-17, 2009.

DOANE, D, P. Using Simulation to Teach Distributions. Journal of Statistics Education, v. 12, n. 1, p. 1-16, 2004.

DULLER, C. Teaching Statistics with Excel a Big Challenge for Students and Lecturers. Austrian Journal of Statistics, v. 37, n. 2, p. 195 – 206, 2008.

FORBES, S., CHAPMAN J., HARRAWAY, J., STIRLING, D.; WILD, C. Use of Data Visualisation in the Teaching of Statistics: A New Zealand Perspective. Statistics Education Research Journal, v. 13, n. 2, p. 187 – 201, 2014.

FREI, F. Uso interativo de planilha eletrônica para o ensino de Estatística: O caso do valor de p. Educação Matemática Pesquisa, v. 21, n. 2, 187 – 201, 2019.

HAUBEN, M. A visual aid for teaching the Mann–Whitney U formula. Teaching Statistics, v. 40, n. 2, p. 60 – 63, 2018.

HUNT, N. Individualized Statistics Coursework Using Spreadsheets. Teaching Statistics, v. 29 n. 2, p. 38–43, 2007.

IHAKA, R. R: Past and future history. In Proceedings of Interface 98, 1998. Disponível em http://www.stat.auckland.ac.nz/~ihaka/downloads/Interface98.pdf. Acessado em: 15 de janeiro de 2020.

JOHNSON, D. G.; JOHN, J. A. Use of Demonstrations and Experiments in Teaching Business Statistics. Journal of Applied Mathematics and Decision Sciences, v. 7, n. 2, p. 93 –103, 2003.

JONES, K. Using spreadsheets in the teaching and learning of mathematics: A research bibliography. MicroMath, v. 21, n. 1, p. 30 – 31, 2005.

KAUL, A. History of Microsoft Excel 1978 – 2013 [Infographic]. Excel Trick. 2013. Disponível em: https://www.exceltrick.com/others/history-of-excel/. Acesso em: 10 de fevereiro de 2020.

LESSER, L. M. Teaching statistics for engagement beyond classroom wall. 9th International Conference on Teaching Statistics, (2014). Disponível em https://iase-web.org/icots/9/proceedings/pdfs/ICOTS9_7A2_LESSER.pdf. Acesso em: 08 de janeiro de 2020.

LOFLAND, C. L.; OTTESEN, R. The SAS versus R debate in industry and academia. Paper presented to the SAS Global Forum 2013, San Francisco, CA.

LOPES, C. E.; SOUZA, A. C.; SOUZA, L. O.; MENDONZA, L. O. O campo de pesquisa da educação Estatística brasileira demarcado pela diversidade temática. REnCiMa, v. 9, n. 2, p. 1– 4, 2018.

MARTIN, D. A Spreadsheet Tool for Learning the Multiple Regression F-test, t-tests, and Multicollinearity. Journal of Statistics Education, v. 16, n. 3, p. 1 – 44, 2008.

MCCULLOUGHA, B.D.; WILSON, B. On the accuracy of statistical procedures in Microsoft Excel 2003. Computational Statistics & Data Analysis, v. 49, p. 1244 – 1252, 2005.

MÉLARD G. On the accuracy of statistical procedures in Microsoft Excel 2010. Computational Statistics, v. 29, 2014.

MOEN, D. H.; POWELL, J. E. Illustrating the Central Limit Theorem Through Microsoft Excel Simulations. College Teaching Methods & Styles Journal, v. 1, n. 2, p. 35 – 46, 2005.

NASH, J.C. Teaching statistics with Excel 2007 and other spreadsheets. Computational Statistics and Data Analysis, v. 52, p. 4602 – 4606, 2008.

NASH, J. C.; QUON, K. T. Issues in teaching statistical thinking with spreadsheets. Journal of Statistics Education, v. 4, n. 1, p. 27 – 33, 1996.

OZGUR, C.; DOU, M.; LI, Y.; ROGERS, G. Selection of statistical software for data scientists and teachers. Journal of Modern Applied Statistical Methods, v. 16, n. 1, p. 753 – 774, 2017.

PACE, L. A.; BARCHARD, K. A. Using a spreadsheet programme to teach introductory statistics: reducing anxiety and building conceptual understanding. International Journal of Innovation and Learning, Inderscience Enterprises Ltd, v. 3, n. 3, p. 267 – 283, 2006.

PROCTOR, J. L. SPSS vs. excel: Computing software, criminal justice students, and statistics. Journal of Criminal Justice Education, v. 13, n. 2, p. 433 – 442, 2002.

PRVAN, T.; REID, A.; PETOCZ, P. Statistical Laboratories Using Minitab, SPSS and Excel: A Practical Comparison. Teaching Statistics, v. 24, n. 2, p. 68 – 75, 2002.

QUINTELA-DEL-RÍO, A.; FRANCISCO-FERNÁNDEZ, M. Excel Templates: A Helpful Tool for Teaching Statistics. The American Statistician, v. 71, p. 317 – 325, 2017.

RAMESH, N. The role of Minitab in teaching and learning statistics. MSOR Connections, v. 9, n. 3, p. 9 – 13, 2009.

SALEHI, M. Using MS Excel in Teaching Design of Experiment. International Journal of Education and Learning Systems, v. 1, p. 93 – 98, 2016.

ŠEBJAN, U.; TOMINC, P. Impact of support of teacher and compatibility with needs of study on usefulness of SPSS by students. Computers in Human Behavior, v. 53, p. 354 – 365, 2015.

SCHWAB-MCCOY, A. The State of Statistics Education Research in Client Disciplines: Themes and Trends Across the University. Journal of Statistics Education, v. 27, n. 3, p. 253–264,2019.

SPINELLI, M.A. The use of technology in teaching business statistics. Journal of Education for Business, v. 77, n. 1, p. 41 – 45, 2001.

STURION, L.; CARVALHO, A. A. A.; Reis, M. C.; ROCHA, Z. F. D. C. As dificuldades dos professores de Estatística na utilização de tecnologias midiáticas. REnCiMa, v. 9, n.4, p. 78 – 93, 2018

SUTHERLAND, S.; RIDGWAY, J. Interactive visualizations and statistical literacy Statistics. Education Research Journal, v. 16, n. 1, p. 26 – 30, 2017.

TAYLOR, C. C. Using R to teach statistics. Proceedings of the Tenth International Conference on Teaching Statistics (ICOTS10, July, 2018), Kyoto, Japan. International Statistical Institute ICOTS10 (2018). Avaliado em https://iase-web.org/icots/10/proceedings/pdfs/ICOTS10_C155.pdf. Acessado em: 03 de dezembro de 2020.

WARNER, C. B.; MEEHAN, M. A. Microsoft Excel as a tool for teaching basic statistics. Teaching of Psychology, v. 28, n. 4, p. 295 – 298, 2001.

Publicado
2021-02-24
Como Citar
FREI, F. Perspectivas do uso de Planilhas Eletrônicas no Ensino de Estatística. Revista de Ensino de Ciências e Matemática, v. 12, n. 1, p. 1-16, 24 fev. 2021.
Seção
Artigos Gerais