Vestnik of Orenburg State Pedagogical University. Electronic Scientific Journal.2016. № 3(19). P. 205—212
13.00.00 PEDAGOGIC SCIENCES
UDC 372.85
Suvorova Mariya Aleksandrovna, Candidate of Pedagogic Sciences
Yaroslavl State Pedagogical University named after K. D. Ushinskiy
FORMING SOME CONCEPTS OF PROBABILITY THEORY WITH STUDENTS WHEN MODELING RANDOM EVENTS IN MS Excel ENVIRONMENT
Abstract
The article discusses the basic principles of modeling random events in a simulation environment of Excel. Modeling by students provides visibility of essential properties, hidden connections and relations. Based on the simulation modeling, the author introduces a number of important concepts of probability theory, namely the classical definition of probability, the number of favorable outcomes of the test, the total number of outcomes, the concept of the law of big numbers (in particular, Bernoulli’s theorem). A man obtaining the information on his own assimilates and learns it better.
Key words
Modeling, model, probability, productive activity, reproductive activity, Monte Carlo simulation.
1. Afanasyev V. V., Alekseev V. N., Tikhomirov S. A. Rabota s odarennymi det’mi po matematike [Working with gifted children in mathematics]. Yaroslavl’, YaGPU im. K. D. Ushinskogo Publ., 2011. 132 p. (In Russian)
2. Afanas’ev V. V., Suvorova M. A. Shkol’nikam o veroyatnosti v igrakh. Vvedenie v teoriyu veroyatnostei dlya uchashchikhsya 8—11 klassov [On probability in games for schoolchildren. Introduction to the theory of probability for pupils of 8—11]. Yaroslavl’, Akademiya razvitiya Publ., 2006. 192 p. (In Russian)
3. Gmurman V. E. Teoriya veroyatnostei i matematicheskaya statistika : ucheb. posobie dlya vuzov. 9-e izd., ster. [Theory of Probability and Mathematical Statistics]. Moscow, Vysshaya shkola Publ., 2003. 479 p. (In Russian)
4. Dalinger V. A. Informatsionnye tekhnologii v obuchenii uchashchikhsya teorii veroyatnostei i matematicheskoi statistike [Information technology in teaching the theory of probability and mathematical statistics to students]. Sovremennye problemy nauki i obrazovaniya — Modern problems of science and education, 2012, no. 3. Available at: http://www.science-education.ru/ru/article/view?id=6574. (In Russian)
5. Dalinger V. A. Izbrannye voprosy informatizatsii shkol’nogo matematicheskogo obrazovaniya / nauch. red. M. P. Lapchik. 2-e izd., stereotip. [Selected problems of informatization of school math education / science editor M. P. Lapchik. 2nd ed., stereotype]. Moscow, Flinta Publ., 2011. 150 p. (In Russian)
6. Gnedenko B. V. Kurs teorii veroyatnostei : ucheb. 8-e izd., ispr. i dop. [The course in probability theory]. Moscow, Editorial URSS Publ., 2005. 448 p. (In Russian)
7. Kulikova O. V. Imitatsionnoe modelirovanie nezavisimykh povtornykh ispytanii sredstvami MathCad v uchebnom protsesse vuza [Simulation of independent retest by MathCad means in the educational process of high school]. Sovremennye problemy nauki i obrazovaniya — Modern problems of science and education, 2013, no. 3. Available at: http://www.science-education.ru/ru/article/view?id=9346. (In Russian)
8. Pan’gina N. N., Pan’gin A. A. Statisticheskoe modelirovanie: metod Monte-Karlo [Statistical modeling: Monte Carlo method]. Komp’yuternye instrumenty v obrazovanii, 2002, no. 5. (In Russian)
9. Suvorova M. A., Lichak L. A., Bytev D. O. Laboratornyi praktikum po kursu teorii veroyatnostei i matematicheskoi statistiki. Metodicheskie ukazaniya k laboratornym rabotam [Laboratory course in probability theory and mathematical statistics. Methodical instructions to laboratory works]. Yaroslavl’, YaGTU Publ., 2002. 20 p. (In Russian)