This study examined using Excel spreadsheets to teach statistics elements in a school mathematics course. Compared to other software packages, the advantages of using Excel in school mathematics have been determined. Basic information about Excel was shown, and information was given about its current use in teaching statistics. The school mathematics course determined the kind of statistical calculations that can be made. Statistics have a special place in school mathematics. It is covered in the mathematics textbooks of grades 5-11 of the general education school. In grades 5-6, they are given subtopics as an introduction to statistics; in grades 7-11, they are considered a separate section. The issue of digital technologies in teaching statistics is often discussed in textbooks. The digital tool MS Excel is used in mathematics textbooks for the 7th grade, 8th grade, and 11th grade of general education schools in the Republic of Kazakhstan to make statistical reports. 11th grade in elementary schools of algebra and analysis in the subject: main and sample sets, basic statistical means (sample mean, arithmetic mean, median, mode), discrete and interval frequency tables, statistical diagrams (frequency polygon, histogram), and discrete get acquainted with the concepts of quantitative characteristics of the selection of random variables. In this article, we have given tasks and instructions for making calculations using the Excel spreadsheet for the topics mentioned in the 11th-grade Algebra and Analysis Beginnings textbook. It has been shown that all statistical reports at the school level can be produced using Excel. MS Excel was used to create a frequency table, calculate fundamental statistical mean values, and create a frequency polygon, and a histogram was shown with concrete examples.
USE OF EXCEL IN TEACHING ELEMENTS OF STATISTICS IN SCHOOL MATHEMATICS COURSE
Published December 2024
84
53
Abstract
Language
English
How to Cite
[1]
Iskakova, M., Toleugaliyeva, S., Karzhaubay, A. and Diyarova, L. 2024. USE OF EXCEL IN TEACHING ELEMENTS OF STATISTICS IN SCHOOL MATHEMATICS COURSE. Bulletin of Abai KazNPU. Series of Physical and mathematical sciences. 88, 4 (Dec. 2024), 99–105. DOI:https://doi.org/10.51889/2959-5894.2024.88.4.010.