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).
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.