INVARIANT PRACTICAL TASKS FOR WORK WITH ELECTRONIC SPREADSHEETS AT THE SECONDARY SCHOOL

Abstract


In article examples of practical jobs on creation and editing electronic spreadsheets for pupils of the main school are given. For fixing of knowledge and abilities of pupils on formatting of cells they are offered to create, for example, in the plate processor the table and to make its formatting on a sample which shall be brought to the computer monitor, is printed on a color printer and is laid out on the local area network in the form of the image. In the course of assimilation of data types jobs for determination and the explanation of data types to which different strings belong are offered school students. For assimilation of features of record of formulas school students are offered to write different mathematical expressions in the look suitable for use in electronic spreadsheets.Jobs reflect fundamental invariant approach to implementation of technology of operation with electronic spreadsheets as don’t depend on specific versions of computer programs. The provided jobs can be used in case of study of any plate processors. In training activity on the basis of use of invariant jobs there is a mastering the generalized methods of activities to numerical information that will allow to create a system view on use of information technologies and to consciously apply them to the solution of tasks.

About the authors

L I Kartashova

Moscow City Pedagogical University

Sheremetjevskaya str., 29, Moscow, Russia, 127521
Computer Science and Applied Mathematics Chair

I V Levchenko

Moscow City Pedagogical University

Sheremetjevskaya str., 29, Moscow, Russia, 127521
Computer Science and Applied Mathematics Chair

A E Pavlova

Moscow City Pedagogical University

Sheremetjevskaya str., 29, Moscow, Russia, 127521
Informatization of education Chair

References

Statistics

Views

Abstract - 346

PDF (Russian) - 43

Cited-By



Copyright (c) 2016 Карташова Л.И., Левченко И.В., Павлова А.Е.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

This website uses cookies

You consent to our cookies if you continue to use our website.

About Cookies