Using a spreadsheet programme to teach introductory statistics: Reducing anxiety and building conceptual understanding

International Journal of Innovation and Learning

Volumn 3, Issue 3, 2006, Pages 267-283

  Pace, Larry A ^a   Barchard, Kimberly A ^b  

^a LOUISIANA TECH UNIVERSITY   (United States)

^b UNIVERSITY OF NEVADA   (United States)

Author keywords

Active learning; Education; Introductory statistics; Microsoft Excel; Spreadsheets; Statistics education

Indexed keywords

CURRICULUM; EDUCATIONAL DEVELOPMENT; SPREADSHEET; STATISTICAL CONCEPT;

EID: 33645962806     PISSN: 14718197     EISSN: 17408016     Source Type: Journal    
DOI: 10.1504/IJIL.2006.009222     Document Type: Article

References (40)

1. Anderson, J.R. (1995) 'ACT: s simple theory of complex cognition', American Psychologist, Vol. 51, pp.355-365.
2. Anzai, Y. and Simon, H.A. (1979) 'The theory of learning by doing', Psychological Review, Vol. 86, pp.124-140.
3. Baker, J. and Sugden, S. (2003) 'Spreadsheets in education: the first 25 years', Electronic Journal of Statistics in Education, Vol. 1, No. 1, pp.18-43.
4. Bandura, A. (1997) Self-efficacy: The Exercise of Control, New York: W.H. Freeman.
5. Bandura, A. (2004) 'Swimming against the mainstream: The early years from chilly tributary to transformative mainstream', Behaviour Research and Therapy, Vol. 42, pp.613-630.
6. Bartz, A. and Sabolik, M. (2001) 'Computer and software use in teaching the beginning statistics course' Teaching of Psychology, Vol. 28, No. 2, pp.147-149.
7. Butler, J. (1986) 'Spreadsheet tasks are worthwhile as teaching tools', Journalism Educator, Vol. 40, No. 4, pp.28-32.
8. Crocker, L. and Algina, J. (1986) Introduction to Classical and Modern Test Theory, New York: Holt, Rinehart & Winston.
9. Cronbach, L.J. (1951) 'Coefficient alpha and the internal structure of tests', Psychometrika, Vol. 16, pp.297-334.
10. Cronbach, L.J., Rajaratnam, N. and Gleser, G.C. (1963) 'Theory of generalizability: A liberalisation of reliability theory', British Journal of Statistical Psychology, Vol. 16, pp.137-163.
11. Davis, P. (1997) 'What computer skills do employers expect from recent graduates', T.H.E. Journal, Vol. 24, pp.74-76.
12. Dillon, K.M (1999) 'I am 95% confident that the earth is round: an interview about statistics with Chris Spatz', Teaching of Psychology, Vol. 26, pp.232-234.
13. Garfield, J., Hogg, B., Schau, C. and Whittinghill, D. (2002) 'First courses in statistical science: The status of educational reform', Journal of Statistics Education, Vol. 10, No. 2, Accessed at: www.amstat.org/publications/jse/v10n2/garfield.html
14. Hall, A.G. (1995) 'A workshop approach using spreadsheets for the teaching of statistics and probability', Computers in Education, Vol. 25, pp.5-12.
15. Kalem, S. and Fer, S. (2003) 'The effects of the active learning model on students' learning', teaching and communication, Educational Sciences: Theory & Practice, Vol. 3, pp.455-461.
16. Kazdin, A.E. (1974) 'Covert modeling, model similarity, and reduction of avoidance behavior', Behavior Therapy, Vol. 5, pp.325-340.
17. Kumar, S. (2004) 'Mobile communications: global trends in the 21st century', International Journal of Mobile Communications, Vol. 2, No. 1, pp.67-86.
18. Liang, H., Xue, Y, and Byrd, T. (2003) 'PDA usage in healthcare professionals: testing an extended technology acceptance model', International Journal of Mobile Communications, Vol. 1, No. 4, pp.372-389.
19. Lovett, M. and Greenhouse, J. (2000) 'Applying cognitive theory to statistics instruction', The American Statistician, Vol. 54, No. 3, pp.196-206.
20. McCollough, B.D. and Wilson, B. (1999) 'On the accuracy of statistical procedures in Microsoft Excel 97', Computational Statistics & Data Analysis, Vol. 31, pp.27-37.
21. Meichenbaum, D.H. (1971) 'Examination of model characteristics in reducing avoidance behavior', Journal of Personality and Social Psychology, Vol. 17, pp.298-307.
22. Michael, J.A. and Modell, H.I. (2003) Active learning in secondary and college science classrooms: A working model for helping the learner to learn, Mahwah, NJ: Lawrence Erlbaum.
23. Microsoft (2004) 'Description of improvements in the statistical functions in Excel 2003', Accessed at: http://support.microsoft.com/ default.aspx?scid=kb;en-us;828888
24. Minitab (2004) Minitab, Inc., State College, PA.
25. Muhlberger, R. (2004). 'Mobile devices as distributed database components for relocating applications', International Journal of Mobile Communications, Vol. 2, No. 3, pp.286-293.
26. Nash, J.C. and Quon, T.K. (1996) 'Issues in teaching statistical thinking with spreadsheets', Journal of Statistics Education, Vol. 4, No. 1, Accessed at: http://www.amstat.org/publications/jse/v4nl/nash.html
27. Pan, W. and Tang, M. (2004) 'Examining the effectiveness of innovative instructional methods on reducing statistics anxiety for graduate students in the social sciences', Journal of Instructional Psychology, Vol. 31, No. 2, pp.149-159.
28. Piava, E. (2003) 'Integrating different types of knowledge: an empirical investigation', International Journal of Innovation and Learning, Vol. 1, No. 1, pp.45-55.
29. SAS (2004) SAS Institute Inc., Cary, NC.
30. Sawitzki, G. (1994) 'Report on the reliability of data analysis systems', Computational Statistics and Data Analysis, Vol. 18, pp.289-301.
31. Sedlmeier, P. (2000) 'How to improve statistical thinking: Choose the task representation wisely and learn by doing', Instructional Science, Vol. 28, pp.227-262.
32. Seng, J. and Lin, S. (2004) 'A mobility and knowledge-centric e-learning application design method', International Journal of Innovation and Learning, Vol. 1, No. 3, pp.293-311.
33. Siau, K. and Shen, Z. (2003) 'Mobile communications and mobile services', International Journal of Mobile Communications, Vol. 1, Nos. 1/2, pp.3-14.
34. SPSS (2004) SPSS Inc., Chicago, IL.
35. Systat (2004) Systat Software Inc., Richmond, CA.
36. Tukey, J.W. (1977) Exploratory Data Analysis, Reading, MA: Addison-Wesley.
37. Ware, M.E. and Chastain, J.D. (1989) 'Computer-assisted statistical analysis: A teaching innovation?', Teaching of Psychology, Vol. 16, pp.222-227.
38. Warner, C.B. and Meehan, A.M. (2001) 'Microsoft Excel as a tool for teaching basic statistics', Teaching of Psychology, Vol. 28, No. 4, pp.295-298.
39. Wilson, J., Schwartz, J., McDermott, L. and Layman, J. (1985) 'Education in physics', Physics Today, Vol. 38, No. 1, pp.26-28.
40. Zhu, X. and Simon, H.A. (1987) 'Learning mathematics from examples and by doing', Cognition and Instruction, Vol. 4, pp.137-166.