Digital Library NAES of Ukraine

Using spreadsheets as learning tools for computer simulation of neural networks

- Semerikov, Serhiy O. (orcid.org/0000-0003-0789-0272), Teplytskyi, I.O., Yechkalo, Yu.V. (orcid.org/0000-0002-0164-8365), Markova, Oksana (orcid.org/0000-0002-5236-6640), Soloviev, V.N. and Kiv, A.E. (2020) Using spreadsheets as learning tools for computer simulation of neural networks SHS Web of Conferences (75). pp. 1-14. ISSN 2261-2424

[thumbnail of shsconf_ichtml_2020_04018.pdf] Text
shsconf_ichtml_2020_04018.pdf - Published Version

Download (2MB)

Abstract

The article substantiates the necessity to develop training methods of computer simulation of neural networks in the spreadsheet environment. The systematic review of their application to simulating artificial neural networks is performed. The authors distinguish basic approaches to solving the problem of network computer simulation training in the spreadsheet environment, joint application of spreadsheets and tools of neural network simulation, application of third-party add-ins to spreadsheets, development of macros using the embedded languages of spreadsheets; use of standard spreadsheet add-ins for non-linear optimization, creation of neural networks in the spreadsheet environment with-out add-ins and macros. The article considers ways of building neural network models in cloud-based spreadsheets, Google Sheets. The model is based on the problem of classifying multi-dimensional data provided in “The Use of Multiple Measurements in Taxonomic Problems” by R. A. Fisher. Edgar Anderson’s role in collecting and preparing the data in the 1920s-1930s is discussed as well as some peculiarities of data selection. There are presented data on the method of multi-dimensional data presentation in the form of an ideograph developed by Anderson and considered one of the first efficient ways of data visualization.

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.9 ІКТ ( Application-oriented computer-based techniques )
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: 24 Apr 2020 20:26
Last Modified: 30 Apr 2020 12:29
URI: https://lib.iitta.gov.ua/id/eprint/720076

Downloads

Downloads per month over past year

Actions (login required)

View Item View Item