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: денна
Learning outcomes: • be able to design software for data processing in computer systems and publishing and management systems; • learn the basics of procedural VBA to automate the processing of text and graphic information; • be able to carry out the development of functional applications in environments that support the work of VBA; • be able to create macros in MS Office package and in the environment Visual Studio
Required prior and related subjects: Prerequisites: • Fundamentals of Electronic Document Management; • Object Oriented Programming; • Tools for Designing Preprinting Preparation Systems.
Summary of the subject: The study of modern technology and software automation of text and graphic information. The work with standard controls Visual Basic, with collections of items, a menu of general purpose and context, toolbars, dialogs, development of custom dialogs, work with strings, processing information in databases, creating and using macros for medium MS Office.
Assessment methods and criteria: • written reports on laboratory work, oral examination, settlement and graphic work (40%) • final control (control measure, exam), written-oral form (60%)
Recommended books: 1. Уокенбах Д. Excel 2013: профессиональное программирование на VBA. K.: Диалектика, 2014 –960 с. 2. Слепцова Л.Д. Программирование на VBA в Microsoft Office 2010. Діалектика, 2010. – 432 с. 3. Ник Рендольф, Дэвид Гарднер, Майкл Минутилло, Крис Андерсен. Microsoft Visual Studio 2010 для профессионалов. Діалектика, 2011. – 1184 с.