Skip to main content Skip to main navigation menu Skip to site footer
Bulletin of Abai KazNPU. Series of Physical and mathematical sciences

USE OF EXCEL IN TEACHING ELEMENTS OF STATISTICS IN SCHOOL MATHEMATICS COURSE

Published December 2024

84

53

M. Iskakova+
Abai Kazakh National Pedagogical University, Almaty
https://orcid.org/0000-0001-7368-7518
A. Karzhaubay+
Abai Kazakh National Pedagogical University, Almaty
L. Diyarova+
Caspian University of Technology and Engineering named after Sh. Yessenov, Aktau
https://orcid.org/0000-0002-4563-1098
Abai Kazakh National Pedagogical University, Almaty
##plugins.generic.jatsParser.article.authorBio##
×

M. Iskakova

Institute of Mathematics, Physics and Informatics.

Candidate of Pedagogical Sciences, Associate University Professor. 

Narxoz University, Almaty
##plugins.generic.jatsParser.article.authorBio##
×

S. Toleugaliyeva

Educational program "Economics".

Senior lecturer

Abai Kazakh National Pedagogical University, Almaty
##plugins.generic.jatsParser.article.authorBio##
×

A. Karzhaubay

7М01501-Математика

Caspian University of Technology and Engineering named after Sh. Yessenov, Aktau
##plugins.generic.jatsParser.article.authorBio##
×

L. Diyarova

Candidate of Physical and Mathematical Sciences, Associate Professor of the Higher Attestation Commission of the Republic of Kazakhstan

Abstract

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.

pdf (Қазақ)
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.