• May 03, 2016 News! IJIET Vol. 5, No. 10 has been indexed by EI (Inspec).   [Click]
  • Mar 13, 2017 News!Vol. 7, No. 5 has been indexed by Crossref.
  • Mar 10, 2017 News!Vol. 7, No. 5 issue has been published online!   [Click]
General Information
    • ISSN: 2010-3689
    • Frequency: Bimonthly (2011-2014); Monthly (Since 2015)
    • DOI: 10.18178/IJIET
    • Editor-in-Chief: Prof. Dr. Steve Thatcher
    • Executive Editor: Ms. Nancy Y. Liu
    • Abstracting/ Indexing: EI (INSPEC, IET), Electronic Journals Library, Google Scholar, Crossref and ProQuest
    • E-mail: ijiet@ejournal.net
Editor-in-chief
Prof. Dr. Steve Thatcher
University of South Australia, Australia
It is my honor to be the editor-in-chief of IJIET. The journal publishes good papers which focous on the advanced researches in the field of information and education technology. Hopefully, IJIET will become a recognized journal among the scholars in the filed of information and education technology.
IJIET 2016 Vol.6(6): 435-440 ISSN: 2010-3689
DOI: 10.7763/IJIET.2016.V6.728

ICT Integrated Learning: Using Spreadsheets as Tools for e-Learning, A Case of Statistics in Microsoft Excel

Nchimunya Chaamwe and Langstone Shumba
Abstract—The integration of ICTs in the teaching and learning curricula is the apparent goal for initiatives to improve education in schools. Most Schools however, look for specialised educational software and hardware to achieve this integration. This paper proposes the use of a widely readily available tool to achieve the same integration that other specialized tools would achieve. Over the years the application area for spreadsheets has multiplied. It is software that is becoming more pronounced in the teaching and learning of pupils and students. A Spreadsheet can be used as a powerful learning tool for both primary and secondary school pupils. Spreadsheets offer concrete ways to explore abstract concepts in mathematics and other subjects. Spreadsheets contain a variety of formulas, which can be used in teaching mathematics. These formulas can be generalized, so that students can see how the outcome is changed when one of the variables is altered. Apart from using ready-made formulas pupils can make up their own formulas to manipulate numbers. This paper proposes the use of Ms Excel in the teaching and learning of statistics in secondary schools. This paper demonstrates the ability for Ms Excel to teach almost all the topics in secondary school statistics.

Index Terms—Information and communication technology (ICT), Microsoft Excel (MS Excel), spreadsheets, statistics.

The authors are with Copperbelt University, Zambia (e-mail: nchimunya2009@gmail.com, lshumba2001@yahoo.com).

[PDF]

Cite: Nchimunya Chaamwe and Langstone Shumba, "ICT Integrated Learning: Using Spreadsheets as Tools for e-Learning, A Case of Statistics in Microsoft Excel," International Journal of Information and Education Technology vol. 6, no. 6, pp. 435-440, 2016.

Copyright © 2008-2016. International Journal of Information and Education Technology. All rights reserved.
E-mail: ijiet@ejournal.net