The article deals with one of the methods of overcoming the low quality level of training of former students, and now fi rst-year students, in the field of information technology through targeted training in programming languages with the help of practice-oriented projects. The implementation of the main didactic units in the form of a single project contributes to the development of pupils’ competences in searching, storing and processing information, forming and developing a creative approach to solving the set task. The article gives examples to illustrate the practical component of the work performed on the technology described in the article. The considered algorithm of the project method is successfully used by the author in the process of teaching disciplines in the fi eld of “Automation of technological processes and production”, “Management in technical systems” at the Moscow Technical University of Communications and Informatics, it can be also used in teaching high school students in the classroom of Informatics.

The tutorial discusses the basics of algorithmization and programming in Visual Basic for Applications (VBA), describes the action of linear, branching and cyclic structures. Much attention is paid to programming based on functions and procedures, processing one-dimensional and two-dimensional arrays, working with files. Examples of mathematical data processing, the use of spreadsheets for charting are given. In addition, the methods of creating macros, the principles of developing test programs based on various controls are considered. At the end of each Chapter there is a set of control questions and tasks. It has an applied orientation and meets the requirements of the Federal state educational standards of higher education of the last generation. It is intended for students of higher educational institutions studying under the programs of bachelor of technical specialties, it will also be useful for students of secondary professional educational institutions and schoolchildren in preparation for the Unified state exam on the discipline "Informatics and ICT".