Home/ Majors directory/Computer Technologies and Systems for Publishing and Printing Industry/Automation Processing of Text and Graphic Information
Automation Processing of Text and Graphic Information
Major: Computer Technologies and Systems for Publishing and Printing Industry
Code of subject: 7.186.01.O.001
Credits: 5.00
Department: Publishing Information Technologies
Lecturer: PhD, Associate Professor, Kynash Yu.E.
Semester: 1 семестр
Mode of study: денна
Завдання: The study of an educational discipline involves the formation and development of the competencies of students:
general competences:
1. Ability to communicate in a foreign language.
2. Ability to make informed decisions.
3. The ability to evaluate and ensure the quality of performed works
professional competences:
1. The ability to comprehensively evaluate the influence of the environment of the functioning of technological and production processes for the improvement of product parameters.
2. The ability to determine the main functions and areas of improvement of production support, to develop measures of operational and prospective management, forecasting and planning of production.
3. The ability to develop and implement new technological processes, in particular resource- and energy-saving technologies, and types of products in the field of publishing and
polygraphy, to optimize production processes in accordance with the set requirements.
4. Ability to organize activities and effectively manage institutions/units in the field of publishing and printing.
Learning outcomes: As a result of studying the academic discipline, the student must be able to demonstrate the following learning outcomes:
1. To be responsible for the development of professional knowledge and practices, evaluation of the strategic development of the team, formation of an effective personnel policy
2. Make effective decisions on issues of publishing and printing, including in difficult and unpredictable conditions; predict their development and market conditions; determine the factors affecting the achievement of set goals, in particular, consumer requirements; analyze and compare
alternatives; assess risks and likely consequences of decisions.
3. Communicate freely orally and in writing in Ukrainian and one of the foreign languages (English, German, Italian, French, Spanish)
when discussing professional issues, research and innovations in the field of publishing and printing and related problems.
4. To develop and implement projects of publishing and printing industries and their engineering and technical support systems, taking into account engineering, legal, economic, environmental and social aspects,
to carry out their informational and methodical support.
5. Carry out computer design of individual components of the technological process.
6. To carry out research and/or carry out innovative activities in order to obtain new knowledge and create new technologies and products in the field of publishing and printing and in wider multidisciplinary contexts
7. Build and research models of technological processes of publishing and printing, evaluate their adequacy, determine the limits of applicability.
8. Apply modern experimental and mathematical methods, information technologies and specialized software for research and development in the field of publishing and printing.
As a result of studying the academic discipline, the student must be able to demonstrate the following program learning outcomes:
1. Knowledge that will provide the ability to analyze and critically consider problems and tasks in the field of computer technologies, publishing systems and printing industries.
2. Knowledge and understanding of scientific principles underlying the development and use of computer technologies and information publishing systems;
3. Specialized conceptual knowledge, which includes modern scientific achievements in the field of professional activity or field of knowledge and is the basis for original thinking and conducting research;
4. To apply effective forms of professional and interpersonal communication in a team to perform tasks in professional activities.
5. To ensure the quality of printed and electronic publications, packaging, multimedia information products and other types of publishing and printing products.
6. Prepare and operate data for
design, management and implementation of production and technological processes for the production of publishing and printing, multimedia, packaging products;
7. Manage the processes of preparation, substantiation, implementation, organization and control of the production of electronic multimedia publications, use knowledge of modern technologies for their production.
8. Design and develop interactive media and their individual elements, develop multimedia content,
design and implement the design of original layouts
multimedia publications
9. Knowledge and understanding of the basics of analysis and assessment of problems and tasks, the solution of which contributes to increasing the efficiency of the use of information resources in the field of printing and multimedia.
10. Use modern information sources of the national and international level to assess the state of study of the object of research and the relevance of the scientific problem.
11. The ability to formulate and improve an important research problem, to collect the necessary information for its solution, and to formulate conclusions that can be defended in a scientific context.
Required prior and related subjects: Prerequisites:
• Object Oriented Programming;
Associated and following academic disciplines:
• Repositories of data of multimedia systems
• Intelligent data analysis
• Computer support of multimedia information systems
Summary of the subject: The educational discipline "Automation of text and graphic information processing" covers modern technologies and software tools for automating the processing of text and graphic information. Work with standard Visual Basic and Visual C# control elements, collections of elements, creation of general-purpose and contextual menus, toolbars, dialogs, development of custom dialog windows, work with strings, processing of information in databases, creation and use of macros for the MS environment is considered. Office.
Опис: Topic 1. Modern technologies and software tools for automating the processing of text and graphic information.
Topic 2. Project structure. Form and its properties. Form display.
Topic 3. Standard control elements of Visual C# and Visual Basic. Working with text. Control elements for decision making. Special purpose control elements. Work with several control elements. Work with element collections.
Topic 4. The concept of events and the order of their occurrence. Event processing.
Topic 5. Creation of general purpose and contextual menus. Toolbars. Dialogues. Development of custom dialog boxes.
Topic 6. Variables, namespaces, data types, operators, documentation tools and preprocessor directives.
Topic 7. Differences between classes and structures. Pass by value and pass by reference. Method overloading. Constructors. Partial classes and static classes.
Topic 8. Inheritance. Types of inheritance. Implementation inheritance. Access modifiers. Interfaces.
Topic 9. Overview of generalizations. Generalized classes, interfaces, structures, methods.
Topic 10. Arrays and tuples.
Topic 11. Operations and reduction. Implementation of custom actions. Operation overload.
Topic 12. Lambda-expression delegates and events.
Topic 13. Methods of processing collections of elements.
Topic 14. Integrated query language. Traditional queries using lists. Advanced methods. LINQ query operations. Parallel LINQ. Expression trees.
Topic 15. Errors and exceptions.
Topic 16. Automation of task processing in Microsoft Office using macros.
Assessment methods and criteria: Current control (40%): written reports on laboratory work, calculation and graphic work, oral survey
Final control (60%, examination control): testing, oral survey
Критерії оцінювання результатів навчання: The maximum score in points is 100;
Current control (laboratory work) – 25;
Current control (calculation and graphic work) – 15.
Examination control (written component) – 50.
Examination control (oral component) – 10.
Recommended books: 1. Mark J. Price. C# 10 and .NET 6 – Modern Cross-Platform Development: Build apps, websites, and services with ASP.NET Core 6, Blazor, and EF Core 6 using Visual Studio 2022 and Visual Studio Code. Packt Publishing, 6th edition, 2021.- 824 p.
2. Ian Griffiths. Programming C# 10. O'Reilly Media, 1st edition. 2022.- 1332 p.
3. Andrew Stellman, Jennifer Greene. Head First C#: A Learner's Guide to Real-World Programming with C# and .NET Core. O'Reilly Media, 4st edition. 2021.- 800 p.
4. Mark Reed. C#: 3 books in 1 - The Ultimate Beginner, Intermediate & Advanced Guides to Master C# Programming Quickly with No Experience (Computer Programming). Kindle Edition. 2022.- 427 p.
5. Andrew Troelsen, Phil Japikse. Pro C# 10 with .NET 6: Foundational Principles and Practices in Programming. Apress, 11st edition. 2022.- 1705 p.
6. Adam Seebeck. C# Fundamentals – C# 10 and .NET 6 using Visual Studio 2022: Course in a book. unQbd, 4th edition. 2021.- 277 p.
7. Michael Alexander. Excel VBA Programming For Dummies. Pearson, 1st edition, 2018.- 416 p.
8. Michael Alexander. Excel Macros for Dummies. Pearson, 2st edition, 2017.- 312 p.
9. Bill Jelen, Tracy Syrstad. Microsoft Excel VBA and Macros. Microsoft Press, 1st edition, 2022.- 640 p.
10. Jelen Bill, Syrstad Tracy. Microsoft Excel 2019 VBA and Macros. Microsoft Press, 1st edition, 2018.- 624 p.
11. John Michaloudis, Bryan Hong. 101 Ready To Use Microsoft Excel Macros. Kindle Edition, 2019.- 532 p.
12. Dick Kusleika, Michael Alexander. Excel 2019 Power Programming with VBA. Wiley, 1st edition, 2019.- 739 p.
13. Mike Van Niekerk. VBA Automation for Excel 2019 Cookbook: Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications. Packt Publishing, 1st edition, 2020.- 362 p.
14. Richard Mansfield. Mastering VBA for Microsoft Office 365. Sybex, 4st edition, 2019.- 900 p.
15. Julitta Korol. Microsoft Access 2019 Programming by Example with VBA, XML, and ASP. Mercury Learning and Information, 2019.- 1383 p.
16. Ben Beitler. Microsoft Access: VBA Programming. Kindle Edition. 2018.- 475 p.
http://msdn.microsoft.com/en-us/vbasic