PRACTICAL METHODS OF ORGANIZING INTERDISCIPLINARY STUDYING IN THE FIELD OF BIOLOGY AND CHEMISTRY
DOI: 10.23951/1609-624X-2018-8-231-237
The article provides practical examples of using an interdisciplinary approach to solving typical tasks in biology and new algorithmic approaches to determining the kinetic parameters of simple reactions in chemistry. It examines the appropriate methods to use the most common MS Excel toolkit to obtain more exact solutions of the considered tasks for the extended type values of the type of mathematical models of the desired parameters. Presents the teaching methods and practical examples of solving problems in the field of biology and chemistry which were implemented in the framework of an interdisciplinary approach, as well as their study of mathematics and computer science. The importance of interdisciplinary study with mathematical modeling of the processes that predict a change of state in biological and chemical systems is shown. These considerations contribute to the enhancement of knowledge and research, including when solving the problems by replacing numerical data with mathematical expressions. At the same time, problem analysis, solution methods, adequate assessment, visualization and interpretation of results are required. The presented practical approach effectively contributes to the implementation of the educational standard with the formation of graduates’ competencies, focused on the willingness to independently solve the research problems and self-development throughout the life.
Keywords: interdisciplinary studying, pedagogical activity, practical methods, MS Excel spreadsheets, mathematical models, population dynamics, predator-prey model, physical chemistry, rate constant, reaction order
References:
1. Bondarchuk I. S., Kurzina I. A., Bondarchuk S. S. Metodologiya resheniya zadach fizicheskoy khimii s pomoshch’yu Solver MS Excel [Methodology of solving tasks of physical chemistry with Solver MS Excel]. Vyssheye obrazovaniye segodnya – Higher Education Today, 2014, no. 9, pp. 22–24 (in Russian). URL: http://www.hetoday. org/magazine/2014/archive_09_14.html (accessed 1 October 2018).
2. Breshkovskaya K. Yu., Dekina E. V., Kuvyrtalova M. A. Metodologicheskiye osnovy mezhdistsiplinarnogo podkhoda k probleme prakticheskoy podgotovki studentov-bakalavrov v pedvuze [Methodological foundations of an interdisciplinary approach to the task of practical training of undergraduate students at the pedagogical institute]. Sovremennye problemy nauki i obrazovaniya – Modern problems of science and education, 2017, no. 6 (in Russian). URL: https://www.science-education.ru/ru/article/view?id=27163 (accessed 1 January 2018).
3. Belchik E. E., Vatlina L. P., Smirnov E. I. Ispol’zovaniye elektronnykh tablits Excel dlya resheniya raschetnykh zadach po khimii [The use of Excel spreadsheets for solving computational tasks in chemistry]. Yaroslavskiy pedagogicheskiy vestnik – Yaroslavl Pedagogical Bulletin, 2010, no. 4, pp. 77–82 (in Russian). URL: http://vestnik.yspu.org/releases/2010_pp4/20.pdf (accessed 1 October 2018).
4. Ozerov I. V., Orekhov F. S., Nesterenko A. M., Zlenko D. V., Terlova L. D., Khrushchev S. S. Uchebnyy kurs po programmirovaniyu na Python dlya resheniya biologicheskikh zadach [Educational course on programming in Python for solving biological tasks]. Tezisy XXII-y konferentsii «Matematika, komp’yuternoye obrazovaniye» [Abstracts of the XXII-th conference «Mathematics. Computer. Education»] (in Russian). URL: http://www.mce.su/rus/archive/sect195475/doc219030/ (accessed 1 January 2018).
5. Asayanova O. Yu., Ryasnaya-Bredikhina O. V. Master-klass: «Ispol’zovaniye planshetnykh tekhnologiy v uchebnom protsesse» [Master class: «The use of tablet technologies in the educational process»]. Tezisy XXII-y konferentsii «Matematika, komp’yuternoye obrazovaniye» [Abstracts of the XXII-th conference «Mathematics. Computer. Education»] (in Russian). URL: http://www.mce.su/us/archive/abstracts/mce22/sect57226/doc219235/ (accessed 1 January 2018).
6. Topazh A. G. Ispol’zovaniye sovremennykh vysokourovnevykh sred modelirovaniya mnogozadachnogo modelirovaniya (AnyLogic, ModelMaker i t. D.) dlya postroyeniya i analiza modeley ekosistem [Using modern high-level environments of multi-approach simulation modeling (AnyLogic, ModelMaker, etc.) for building and analyzing ecosystem models]. Tezisy XXII-y konferentsii «Matematika, komp’yuternoye obrazovaniye» [Abstracts of the XXII-th conference «Mathematics. Computer. Education»] (in Russian). URL: http://www.mce.su/rus/archive/sect195475/doc219248/ (accessed 1 January 2018).
7. Bondarchuk I. S., Fedorova V. A. Algoritmy identifikatsii kineticheskikh parametrov prostykh reaktsiy [Algorithms for identification kinetic parameters of simple reactions]. Sbornik nauchnykh trudov XI Mezhdunarodnoy konferentsii studentov i molodykh uchenykh «Perspektivy razvitiya fundamental’nykh nauk». Pod red. Ye.A. Vaytulevich [Prospects for the development of basic sciences: a collection of scientific papers of the XI International Conference of Students and Young Scientists. Ed. E. A. Vaytulevich]. Tomsk, TPU Publ., 2014, pp. 555–557 (in Russian).
8. Bondarchuk S. S., Bondarchuk I. S., Kurzina I. A., Fedorova V. A. Metod Solver MS Excel dlya resheniya zadach fizicheskoy khimii [Solver MS Excel Method for Solving Tasks in Physical Chemistry]. Materialy I Vserossiyskoy nauchno-metodicheskoy konferentsii «Povysheniye kvalifikatsii spetsialistov: elektronnoye obucheniye i otkrytyye obrazovatel’nyye resursy» [Materials of the I All-Russian Scientific and Methodological Conference “Level Training of Specialists: E-learning and Open Educational Resources]. Tomsk,TPU Publ., 2014, pp. 178–180 (in Russian).
9. Bondarchuk I. S., Zhukov I. A., Promakhov V.V . Identifikatsiya kineticheskikh parametrov metodom desorbtsii [Identification of the kinetic parameters by the desorption process]. Sbornik nauchnykh trudov XII Mezhdunarodnoy konferentsii studentov i molodykh uchenykh «Perspektivy razvitiya fundamental’nykh nauk» [Сollection of scientific works of XII International Conference of Students and Young Scientists “Prospects for the Development of Fundamental Sciences”]. Tomsk, TPU Publ., 2015, pp. 380–382 (in Russian).
10. Bondarchuk I. S/, Bondarchuk S. S., Borisov B. V. Identifikatsiya kineticheskikh tripletov po rezul’tatam derivatograficheskogo analiza [Identification of kinetic triplets by results of derivatographic analysis]. MATEC Web Conf., Tom 194, 01010 «Teplomassoperenos v sisteme teplovogo kontrolya tekhnicheskoy i tekhnologicheskoy energii» [MATEC Web Conf., vol. 194, 01010 «Heat and Mass Transfer in the Thermal Control System of Technical and Technological Energy»]. 2018, p. 4. (in Russian). URL: https://doi.org/10.1051/matecconf/201819401010 (accessed 1 February 2018).
11. Bondarchuk I. S., Zhukov I. A., Promakhov V. V., Vorozhtsov S. A. Identifikatsiya kineticheskikh parametrov tverdofaznymi reaktsiyami [Identification of the kinetic parameters by solid-phase reactions]. Materialy Mezhdunarodnoy nauchnoy konferentsii «Polifunktsional’nyye khimicheskiye materialy i tekhnologii» [Polyfunctional chemical materials and technologies: materials of the International Scientific Conference]. Tomsk, TSU Publ., 2015, pp. 34–37 (in Russian).
12. Bondarchuk I. S. Statisticheskiy podkhod dlya identifikatsionnykh parametrov geterogennykh kataliticheskikh reaktsiy [Statistical Approach for Identification Parameters of Heterogeneous Catalytic Reactions]. Materialy XV Mezhdunarodnoy konferentsii studentov, aspirantov i molodykh uchenykh «Perspektivy fundamental’nykh nauk i razvitiya» (Tomsk, 24-27 aprelya 2018 g.). Tom 3. Red. I.A. Kurzina, G.A. Voronovoya [Prospects of Fundamental Sciences and Development: Proceedings of the XV International Conference of Students, Postgraduates and Young Scientists (Tomsk, April 24–27, 2018), Vol. 3. Ed. I.A. Kurzina, G.A. Voronovoya]. Tomsk, TSU Publ., 2018. pp. 37–39 (in Russian). URL: http://sciencepersp.tpu.ru/Default_en.aspx (accessed 1 July 2018).
13. Bondarchuk I. S. Identifikatsiya parametrov geterogennykh kataliticheskikh reaktsiy so statisticheskim podkhodom [Identification of parameters of heterogeneous catalytic reactions with statistical approach]. Trudy XIX Mezhdunarodnoy nauchno-prakticheskoy konferentsii studentov i molodykh uchenykh «Khimiya i khimicheskaya tekhnologiya XXI veka» v chest’ professora L.P. Kuleva (Tomsk, 21–24 maya 2018 g.) [Chemistry and Chemical Technology of XXI century: Proceedings of the XIX International Scientific and Practical Conference of Students and Young Scientists in Honor of Professor L.P. Kulev (Tomsk, May 21–24, 2018)]. Tomsk, TPU Publ., 2018, pp. 261–262 (in Russian).
14. Riznichenko G. Yu. Matematicheskiye modeli v biofizike i ekologii [Mathematical models in biophysics and ecology]. Moscow-Izhevsk, Institute of Computer Science Publ., 2003, 184 p. (in Russian).
15. Bondarchuk S. S., Dolgin V. N., Perevozkin V. P. Matematicheskoye modelirovaniye populyatsionnoy ekologii. Uchebnoye posobiye [Mathematical modeling in population ecology. Study Guide]. Tomsk, TSPU Publ., 2006, 164 p. (in Russian).
16. Bondarchuk S. S., Bondarchuk I. S. Statisticheskaya obrabotka eksperimental’nykh dannykh v MS Excel: uchebnoye posobiye [Statistical processing of experimental data in MS Excel: study guide]. Tomsk, 2018, 433 p. (in Russian).
17. Perevozkin V. P., Bondarchuk S. S., Godovannaya I. G. Genetika. Rukovodstvo po laboratornym i prakticheskim zanyatiyam [Genetics. Guide to laboratory and practical classes]. Tomsk, TSPU Publ., 2009. 116 p. (in Russian).
18. Perevozkin V. P., Bondarchuk S. S., Gordeev M. I. Naseleniye-spetsificheskaya struktura malyariynykh komarov (Diptera, Culicidae) Prikaspiyskoy nizmennosti i Kumo-Manychskoy vpadiny [Population-specific structure of malaria mosquitoes (Diptera, Culicidae) of the Caspian lowland and the Kumo-Manych depression]. Meditsinskaya parazitologiya i parazitarnyye zabolevaniya, 2012, no.1, pp. 12–17 (in Russian).
19. Perevozkin V. P., Minich A. S., Bagautdinova G.T . Struktura naseleniya malyariynykh komarov v tsentral’noy Yevrope [Population-specific structure of malaria mosquitoes in central Europe]. Vestnik Tomskogo gosudarstvennogo pedagogicheskogo universiteta – Tomsk State Pedagogical University Bulletin, 2013, no. 8 (136), pp. 70–74 (in Russian). URL: http://vestnik.tspu.edu.ru/archive.html?year=2013&issue=8 (accessed 1 February 2018).
20. Perevozkin V. P., Bondarchuk S. S., Minich A. S. Cytogenetic analysis of the species composition and inversion structure of populations of malarial mosquitoes in the Astrakhan region. Russian Journal of Genetics, 2015, vol. 51, no. 8, pp. 791–798. URL: http://www.springer.com/biomed/human+genetics/journal/11177 (accessed 1 February 2018).
21. Perevozkin V. P., Bondarchuk S. S. Species specificity of acoustic signals of malarial mosquitoes of anopheles maculipennis complex, International Journal of Mosquito Research, 2015, vol. 2, no. 3, pp. 150–155. URL: http://www.dipterajournal.com/vol2issue3/pdf/2-2-14.1.pdf (accessed 1 February 2018).
22. Anisova T. L., Salpagarov S. I. Resheniye zadach fizicheskoy khimii s ispol’zovaniyem MS Excel [Solving tasks of physical chemistry using MS Excel] Sovremennye problemy nauki i obrazovaniya – Modern problems of science and education, 2012, no. 3 (in Russian). URL: www.scienceeducation.ru/103-6405 (accessed 10 October 2018).
23. Anisova T. L., Salpagarov S. I. Metod opredeleniya poryadka khimicheskoy reaktsii pri obrabotke eksperimental’nykh dannykh v Excel [Method for determining the order of a chemical reaction in the processing of experimental data in Excel]. Vestnik MGPU – Vestnik Moscow City Teachers Training University, 2013, no. 1 (11), pp. 127–132. (in Russian). URL: https://www.mgpu.ru/uploads/adv_documents/2534/1484828042-VestnikEstNauki1(11)2013.Pdf (accessed 1 February 2018).
24. Task definition and task solving with the help of «Search for Solution» add-in. URL: http:// office.microsoft.com/en-us/excel-help/HP010342416.aspx # BM7 (accessed 21 January 2018).
( 2.23 MB ) 
( 1.14 MB )
Issue: 8, 2018
Series of issue: Issue 3
Rubric: SCIENTIFIC REPORTS
Pages: 231 — 237
Downloads: 894