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

2024

Закрытый доступ Метаданные (CSL-JSON)
DOI 10.51889/2959-5894.2024.88.4.010
Достоверность данных 70 средняя
Как считается эта оценка

Складывается из проверяемых признаков самой записи: есть ли у статьи DOI, сколько независимых источников подтвердили её данные, заполнены ли обязательные поля и насколько свежо последнее подтверждение. Снижают оценку расхождения между источниками и отсутствие идентификатора. Значение от 80 означает, что запись опубликована без дополнительной проверки; от 60 до 79 — что она опубликована с пониженной достоверностью и ручная проверка желательна. Запись, выверенную редактором вручную, пересчёт не опускает ниже 90. Это оценка наших данных о статье, а не оценка самой статьи.

Аннотация

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.