Chapter 11: Microsoft Excel: A promising tool for teaching basic descriptive statistics in initial teacher-training institutions
- Alton Dewa(author)
Export Metadata
| Title | Chapter 11: Microsoft Excel: A promising tool for teaching basic descriptive statistics in initial teacher-training institutions |
|---|---|
| Contributor | Alton Dewa(author) |
| DOI | https://doi.org/10.4102/aosis.2022.BK376.11 |
| Landing page | https://books.aosis.co.za/index.php/ob/catalog/book/376 |
| License | https://creativecommons.org/licenses/by-nc-nd/4.0/ |
| Copyright | Judah P. Makonye and Nokulunga S. Ndlovu (eds.). Licensee: AOSIS (Pty) Ltd. The moral right of the authors has been asserted. |
| Publisher | AOSIS |
| Publication place | Durbanville, Cape Town, South Africa |
| Published on | 2023-02-28 |
| Long abstract | Technology has permeated today’s society. The education sector is also not spared and, of late, has witnessed technology becoming increasingly available or integrated into teaching and learning in trying to enhance concepts taught as it has the capability of simulating and uncovering hidden concepts. This study is qualitative and used a purposive sampling method to establish the extent to which education mathematics lecturers in two schools of education in the Gauteng province of South Africa use Microsoft Excel in the teaching of descriptive statistics. The availability of computing devices in schools of education does not reflect those preservice teachers majoring in Mathematics who are exposed to learning statistics at FET phase. Microsoft Excel is a product of the Microsoft Office suite and is available on all computing devices. However, participating education mathematics lecturers indicated that they are facing challenges in teaching statistics using Microsoft Excel because of limited knowledge and skills. Freire’s CP approach was adopted as it focuses on empowering students to be full participants and co-creators of knowledge based on their own experiences. The method thus bails out students from the ‘banking system model’, which considers teachers (in this case lecturers) as the fountain of knowledge to be independent thinkers. In essence, Microsoft Excel has the potential to augment the teaching of basic descriptive statistics and may be used for performing data analysis by preservice teachers studying at the FET phase. The study concludes by discussing the reasons for not using Microsoft Excel in teaching and learning basic descriptive statistics, the potential benefits and the value it may add to the subject content. Finally, the study recommends that the Mathematics curriculum planners should tap the opportunities Microsoft Excel offers in speeding up the understanding of descriptive statistics and provide necessary training if possible. |
| Print length | 18 pages |
| Language | English (Original) |
| THEMA |
|
| BIC |
|
| Keywords |
|
| Funding |
Contributors
Alton Dewa
(author)Alton Dewa is a lecturer at the Wits School of Education’s Division of Educational Information Engineering Technology. He mostly lectures computer programming languages, as well as networking and computer architecture. His research focus is on integrating IT into mathematical education. He also enjoys using computer programming applications, such as Java, Python and Delphi, to solve mathematical problems. He has conducted a great deal of Microsoft Excel training, especially on the data analysis tool in Microsoft Excel (using Data Analysis ToolPak), SQL Server and Power Business Intelligence. He is well-versed in the use of learning management systems, such as Ulwazi (also known as Canvas). His research articles aim to persuade Mathematics teachers to utilise Microsoft Excel to teach descriptive statistics in Mathematics and urge schools to integrate computer science into their curriculum. Artificial intelligence (AI) has had such amazing results in industry and medicine that he believes it is important for the education sector to consider including AI in the school curriculum. His top objective and dream is to train teachers who can effectively apply Microsoft Excel and use computer tools to solve mathematical problems in classrooms.
