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

2024

Closed access Metadata (CSL-JSON)
DOI 10.51889/2959-5894.2024.88.4.010
Data confidence 70 medium
How this score is calculated

It is built from checkable properties of the record itself: whether the article has a DOI, how many independent sources confirmed its data, whether the required fields are filled in, and how recent the latest confirmation is. Disagreement between sources and a missing identifier lower it. A value of 80 or above means the record was published without further checking; 60 to 79 means it is published at reduced confidence, with a manual check advisable. A record verified by an editor by hand is never pushed below 90 by a recalculation. This scores our data about the article, not the article itself.

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 tomake 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), anddiscrete 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.