Using spreadsheets as learning tools for neural network simulation

- Semerikov, Serhiy O. (orcid.org/0000-0003-0789-0272), Teplytskyi, I.O. (orcid.org/0000-0002-9416-3630), Yechkalo, Yu.V. (orcid.org/0000-0002-0164-8365), Markova, Oksana (orcid.org/0000-0002-5236-6640), Soloviev, V.N. (orcid.org/0000-0002-4945-202X) and Kiv, A.E. (orcid.org/0000-0002-0991-2343) (2022) Using spreadsheets as learning tools for neural network simulation Ukrainian Journal of Educational Studies and Information Technology, 3 (10). pp. 42-68. ISSN 2521-1234

Text admin,+4+-+Semerikov+et+al+-+42-68.pdf - Published Version Download (1MB)

Abstract

The article supports the need for training techniques for neural network computer simulations in a spreadsheet context. Their use in simulating artificial neural networks is systematically reviewed. The authors distinguish between fundamental methods for addressing the issue of network computer simulation training in the spreadsheet environment, joint application of spreadsheets and tools for neural network simulation, application of third-party add-ins to spreadsheets, development of macros using embedded languages of spreadsheets, use of standard spreadsheet add-ins for non-linear optimization, creation of neural networks in the spreadsheet environment without add-ins, and оn the article, methods for creating neural network models in Google Sheets, a cloud-based spreadsheet, are discussed. The classification of multidimensional data presented in R. A. Fisher's "The Use of Multiple Measurements in Taxonomic Problems" served as the model's primary inspiration. Discussed are various idiosyncrasies of data selection as well as Edgar Anderson's participation in the 1920s and 1930s data preparation and collection. The approach of multi-dimensional data display in the form of an ideograph, created by Anderson and regarded as one of the first effective methods of data visualization, is discussed here.

Item Type:	Article
Keywords:	computer simulation, neural networks, spreadsheets, neural computing, early network models, Anderson's Iris, cloud-based learning tools
Subjects:	Science and knowledge. Organization. Computer science. Information. Documentation. Librarianship. Institutions. Publications > 00 Prolegomena. Fundamentals of knowledge and culture. Propaedeutics > 004 Computer science and technology. Computing. Data processing > 004.4 Software > 004.4`2/`6 Special auxiliary numbers for software > 004.4`2 Software development tools Science and knowledge. Organization. Computer science. Information. Documentation. Librarianship. Institutions. Publications > 00 Prolegomena. Fundamentals of knowledge and culture. Propaedeutics > 004 Computer science and technology. Computing. Data processing > 004.9 ІКТ ( Application-oriented computer-based techniques ) > 004.94 Simulation Science and knowledge. Organization. Computer science. Information. Documentation. Librarianship. Institutions. Publications > 3 Social Sciences > 37 Education > 37.01/.09 Special auxiliary table for theory, principles, methods and organization of education
Divisions:	Institute for Digitalisation of Education > Department of the Cloud-Вased Systems of ICT in Education
Depositing User:	Сергій Олексійович Семеріков
Date Deposited:	06 Jan 2023 18:01
Last Modified:	06 Jan 2023 18:01
URI:	https://lib.iitta.gov.ua/id/eprint/733777

Downloads

Actions (login required)

View Item