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

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.

training in informatics, spreadsheets, information technologies, school student