METHODS FOR CONSTRUCTING AND IMPLEMENTING A DIGITAL GEOINFORMATION MODEL USING MS EXCEL IN A SCHOOL INFORMATICS COURSE

Abstract

The article describes a methodology for teaching the technology of constructing a geoinformation model using MS Excel. This methodology is built taking into account the Federal State Educational Standard of Secondary General Education and the requirements provided for in the implementation of the approximate educational program of the course "Informatics" along the line "Modeling and Formalization". The authors proposed a laboratory work, within which the students, firstly, learn the new capabilities of the MS Excel package, associated with the use of Power Query and 3D Maps technologies; secondly, they get the initial skills in processing "raw" data in real time; thirdly, they learn the modeling process, in fact, without going beyond the competence of the school informatics course. In general, the laboratory work describes the technology of geoinformation modeling of real processes and has great variability, and therefore can be easily adapted for research and visualization of other updated data. The format for describing the methodology for performing laboratory work is presented in the form of the traditional Key-by-Key technology, which is widely used in obtaining professional competencies in the field of information technology.