Preparation for successfully passing the Unified State Exam in computer science. Part 2 - course 34990 rub. from Specialist, training 48 ac. h., Date: January 27, 2024.

An experienced teacher, she has been preparing applicants to successfully pass entrance exams for more than 10 years, and in recent years she has also been brilliantly preparing high school students for the Unified State Exam in computer science. Attentive and demanding, she does not leave the slightest gap in knowledge. Her students successfully pass entrance exams in computer science to any university.
Lyudmila Pavlovna has extensive experience in teaching the following disciplines: “General computer literacy, Microsoft Office package”, “Algorithmization and programming”, “Programming in C/C++”, “Excel - professional level”, “Access - professional level".
Graduated from the Moscow State Institute of Electronics and Mathematics and currently works at Department of General Informatics of the Russian State University for the Humanities as an associate professor. Lyudmila Pavlovna has 16 years of teaching experience.
At the Russian State University for the Humanities she teaches classes at the humanities and technical faculties in the following courses: “Informatics”, “Information technologies”, “Fundamentals of algorithmization and programming”, “Programming in high-tech languages” level." He has extensive experience teaching computer science and ICT in college and specialized classes at the Russian State University for the Humanities.

Module 1. Means of access to information files. Development of programs using files (10 ac. h.)

• Opening a file. Programming language tools for opening a file.
• Programming language tools for writing information to a file and reading information from a file.
• Programming language tools for accessing a specific file entry and moving through the file.
• Closing the file. Programming language tools for closing a file.
• Implementation of algorithms for processing information files.

Module 2. Basic algorithms for processing character strings and their implementation in programs (10 ac. h.)

• Basic programming language tools for processing symbolic information and character strings.
• Basic algorithms for processing character strings and means of their implementation in programs.
• Implementation in string file processing programs.

Module 3. Tools for developing structured programs: procedures and functions. Recursive functions (4 ac. h.)

• Procedures and functions, purpose, development features.
• Formal and actual parameters of procedures and functions.
• Recursive functions, purpose, implementation features.
• Using procedures and functions in software development.

Module 4. Technologies for processing graphic and audio information (6 academ. h.)

• General classification of graphic editors by coding technologies, purpose, capabilities.
• Features of raster and vector graphics, graphic objects and operations on them.
• Basic audio coding technologies, creation and editing of digital audio recordings.

Module 5. Technologies for processing information in Excel spreadsheets (2 ac. h.)

• Modern technologies for processing information in spreadsheets.
• The principle of addressing, types and formats of data presentation.
• Editing data in an Excel spreadsheet.
• Methods for creating formulas, absolute and relative references.
• "Function Wizard", using functions of different categories, using nested functions.
• Logical functions, use of nested logical functions.
• Sorting information in Excel and using it.
• Filtering information in Excel, conditional filtering.
• Conditional formatting in Excel and its use.
• Visualize data using charts and graphs.
• Excel statistical functions and their use for data processing.
• Excel service functions, data export and import.
• Using the power of spreadsheets to process large information files.

Module 6. Database. DBMS as a means of developing IS databases. Their purpose, tools, capabilities (4 ac. h.)

• DBMS as a means of developing databases in AIS.
• DBMS classification, purpose, tools and capabilities.
• Classification of databases.
• Technologies for storing, searching and processing information in databases.
• Tools for generating queries to database information.
• Information presentation tools, forms and reports.

Module 7. Game strategies. Analysis of game strategies, game tree (8 ac. h.)

• Analytical approach to the analysis of gaming strategies
• Analyzing gaming strategies using Excel
• Software implementation of game strategy analysis

Module 8. Telecommunication technologies (4 ac. h.)

• Distributed computer networks, purpose, basic concepts.
• Basic principles of organization and functioning of computer networks.
• Global Internet network, history of development, basic protocols and network addressing.
• Internet service protocols, purpose, capabilities.
• Technologies for accessing information on the network, software for effective information retrieval.