Valery Vodovozov is a professor of Tallinn University of Technology, Estonia, from 1997. He educated at the Technical University of Vologda and received his PhD Degree in Electrical Engineering from St. Petersburg Electrotechnical University, Russia, where he works since 1976 as associate professor and senior researcher. His teaching includes electric drives, computer science, electronics, and programming of electromechanical and human informational systems. The scientific interests and major fields of research focus on the application of object-oriented technologies in industry and education.
Served as a visiting researcher in Scientific Research Laboratory of Ford Motor Company, USA, lectured at St. Petersburg Institute for Extra Professional Education, St. Petersburg University of Finance, St. Petersburg Customs Academy, and engaged in a number of courses on disciplines mentioned above in industrial and customs training centers.
Member of the professional associations - IEEE, International Institute of Informatics and Systemics (IIIS), Russian Society of Electric Drive Engineers, Estonian Society of M. H. Jacobi, Nordic Network for Electric Drives. Elected International Man of the Years 1999 and 2000 by the International Biographical Center of Cambridge. Included into Marquis "Who’s Who in the World", "Who’s Who in Science and Engineering" (1998-2010), and "Famous Russians" (Moscow, 1999-2000)
Valery Vodovozov is an author of monographs, inventions, brochures, and tutorial aids. More than 250 of his scientific works have been published in journals and papers of international conferences.
Monographs
V. Vodovozov, D. Vinnikov, and R. Jansikene, Elektriajamite elektroonsed susteemid (trans. from Engl.). Tallinn: TUT, 240 lk. (2008)
V. Vodovozov and D. Vinnikov, Electronic Systems of Motor Drive. Tallinn: TTU, 248 p. (2008)
V. Vodovozov and F. Chmilenko, Object-Oriented Programming on C++, St.Petersburg: ETU, 128 p. (2007)
V. Vodovozov and R. Jansikene, Electronic Engineering, Tallinn: TTU, 148 p. (2007)
V. Vodovozov and R. Jansikene, Power Electronic Converters, Tallinn: TTU, 120 p. (2006)
V. Vodovozov, Theory and Systems of Electric Drive, St.Petersburg: ETU, 306 p. (2004)
V. Vodovozov, Windows Programming, St.Petersburg: ETU, 98 p. (2004)
V. Vodovozov and A. Pozhidaev, Building of Applications for Windows, St.Petersburg: ETU, 72 p. (2004)
V. Vodovozov, Visual Basic for Applications, Moscow: Education and Computer Science, 160 p. (2003)
V. Vodovozov, Programming Course on C++, St.Petersburg: ETU, 164 p. (2003)
V. Vodovozov, Programming Technique (VBA, Pascal, C++), St.Petersburg: ETU, 202 p. (2001)
V. Vodovozov and A. Vodovozov, Introduction Into Computer Technique and Computer Technologies, Vologda: VoGTU, 181 p. (2001)
V. Vodovozov, Basics of Informational Technologies, Deaborn, MI, USA: SRL, 185 c. (2000)
V. Vodovozov, V. Osipov and A. Pozhidaev, Practical Introduction Into Informational Systems, St.Petersburg: Polycom, 275 p. (1995)
V. Vodovozov, B. Korovin and L. Rassudov, Microprocessor CNC Systems, St. Petersburg: Energoatomizdat, 256 p. (1994)
V. Vodovozov, V. Mjadzel and L. Rassudov, Robots in Shipbuilding Manufactures, St. Petersburg: Shipbuilding, 248 p. (1986)
Tutorial Aids
T. Jalakas, V. Vodovozov and D. Vinnikov, Power Electronics: Laboratory works, Tallinn: TUT Press, 30 p. (2008)
T. Jalakas, V. Vodovozov and D. Vinnikov, Electronics and Semiconductor Engineering: Laboratory works, Tallinn: TUT Press, 18 p. (2008)
T. Jalakas, V. Vodovozov and D. Vinnikov, Advanced Cource of Power Electronics: Laboratory works, Tallinn: TUT Press, 28 p. (2008)
V. Vodovozov and F. Chmilenko, C++ Programming: Laboratory Practice Cource, St.Petersburg: ETU, 40 p. (2007)
V. Vodovozov and A. Pozhidaev, Course Programming Using C++, St.Petersburg: ETU, 32 p. (2006)
V. Vodovozov, Automatic Control of DC Electric Drive: Laboratory Practice Course, St.Petersburg: ETU, 32 p. (2006)
V. Vodovozov, Motor Drive Design Using eDrive, St.Petersburg: ETU, 32 p. (2006)
V. Vodovozov, Steps of Visual Basic Programming. Moscow: Education and Computer Science, pp. 3-58 (2005)
V. Vodovozov, Visual Basic in Problems: From Simple to Complex. Moscow: Education and Computer Science, pp. 59-102 (2005)
V. Vodovozov, L. Kozlova, A. Kosarev, etc., Electric Drive Theory: Laboratory Practice Course, St.Petersburg: ETU, 44 p. (2005)
G. Sokolovsky, V. Vodovozov, V. Stasovsky and V. Putjkov, Electric Drives: Laboratory Practice Course, St.Petersburg: ETU, 44 p. (2004)
V. Vodovozov, Databases Administration in Microsoft Access, St. Petersburg: IDPO, 40 p. (2003)
V. Vodovozov, Programming and Beginning of Algorithmization, St.Petersburg: ETU, 32 p. (2003)
V. Vodovozov, Getting Starting in Programming, St.Petersburg: ETU, 28 p. (2003)
V. Vodovozov, Applied Programming in C++Builder, St.Petersburg: ETU, 96 p. (2002)
V. Vodovozov, Functions and Classes of C++, St.Petersburg: ETU, 63 p. (2000)
V. Vodovozov, Programming of Electrotechnical Problems on C++, St.Petersburg: ETU, 32 p. (1998)
V. Vodovozov and L. Vjaznikov, Basics of Numerical Control, Vologda: VPI, 118 p. (1995)
V. Vodovozov, Electric Drives for CNC Machines, St.Petersburg: ETU, 63 p. (1990)
Last Articles and Papers
V. Vodovozov and T. Lehtla, Educational Thesauri for Mastering Engineering Courses, 11th International Symposium "Topical Problems in the Eield of Electrical and Power Engineering. 2nd Doctoral School of Energy and Geotechnology", Parnu, Estonia, pp. 24 - 29 (2012)
V. Vodovozov, M. Egorov, Z. Raud and T. Lehtla, Inverters with Reduced Switching Losses for Industrial Applications, 9th IEEE International Conference on Industrial Informatics INDIN'2011, Caparica, Lisbon, Portugal, pp. 274 - 279 (2011)
V. Vodovozov and Z. Raud, Web-Based Learning Content Management System of Power Electronics, 16th Annual Scientific Conference on Web Technology, New Media, Communications and Telematics Theory, Methods, Tools and Applications EUROMEDIA'2011, London, UK, pp. 21 - 23 (2011)
Z. Raud and V. Vodovozov, Staff Training for Servicing Special Power Electronic Applications, 7th International Conference-Workshop "Compatibility and Power Electronics CPE 2011", Tallinn, Estonia, pp. 319-324 (2011)
M. Egorov and V. Vodovozov, Space Vector Modulation with Reduced Switching Losses for Motor Drive Inverters, 7th International Conference-Workshop "Compatibility and Power Electronics CPE 2011", Tallinn, Estonia, pp. 388-393 (2011)
V. Vodovozov and M. Egorov, Discontinuous Space Vector Modulation Technique for Motor Supply, International IEEE Conference EUROCON 2011, Lisbon, Portugal, paper 259 (2011)
Z. Raud and V. Vodovozov, Educational Thesaurus of Power Electronics, International IEEE Conference EUROCON 2011, Lisbon, Portugal, paper 249 (2011)
Z. Raud and V. Vodovozov, Curricula Scheduling using Educational Thesaurus, The 2011 World Congress on Computer Science and Information Technology WCSIT 2011, Cairo, Egypt, paper 092 (2011)
V. Vodovozov and T. Lehtla, Ways to Reduce Switching Losses in Motor Drive Inverters, 10th International Symposium "Topical Problems in the Field of Electrical and Power Engineering" and 2nd Doctoral School of Energy and Geotechnology, Parnu, Estonia, pp. 3 - 9 (2011)
Z. Raud, V. Vodovozov and T. Lehtla, Fllexible Curricula for e-Learning of SME Staff in Electronic Engineering, 9th IEEE/ACIS International Conference on Computer and Information Science ICIS 2010, Yamagata, Japan, pp. 384 - 388 (2010)
Z. Raud, V. Vodovozov and M. Egorov, A Toolbox to Design and Study Electric Drives, 14th International Power Electronics and Motion Control Conference EPE-PEMC 2010, Ohrid, Macedonia, pp. T5-142 - T5-148 (2010)
Z. Raud, V. Vodovozov and T. Lehtla, Engineering Education: Problems, Tendencies and Solutions, 9th International Symposium "Topical Problems in the Eield of Electrical and Power Engineering. 2nd Doctoral School of Energy and Geotechnology", Parnu, Estonia, pp. 166 - 173 (2010)
Z. Raud and V. Vodovozov, Virtual Lab to Study Power Electronic Converters, International Symposium on Power Electronics, Electrical Drives, Automation and Motion SPEEDAM 2010, Pisa, Italy, pp. 703-708 (2010)
Z. Raud and V. Vodovozov, Project-Based Collaborative Learning of Electrical Master Students, 1st Annual Global Engineering Education Conference EDUCON 2010, Madrid, Spain, pp. 1613-1619 (2010)
V. Vodovozov and Z. Raud, A Toolbox to Design and Study Mechatronic Systems, 29th IASTED International Conference on Modelling, Identification, and Control MIC 2010, Innsbruck, Austria, pp. 276 - 283 (2010)
V. Vodovozov, T. Lehtla and J. Laugis, Student Assessment in Engineering Education, 8th International Symposium "Topical Problems in the Eield of Electrical and Power Engineering. 2nd Doctoral School of Energy and Geotechnology", Parnu, Estonia, pp. 145 - 151 (2010)
Z. Raud, V. Vodovozov, T. Lehtla and E. Pettai, Simulation Tools to Study Power Electronics, 13th European Conference on Power Electronics and Applications EPE 2009, Barcelona, Spain, paper 0013 (2009).
V. Vodovozov, Z. Raud and D. Vinnikov, Model-Based Diagnosis of Power Converters, Technical Electrodynamics: Thematic issue, 38 - 43 (2009)
Z. Raud, V. Vodovozov, T. Jalakas and J. Laugis, Simulation Instruments to Study Power Electronics of Motor Drives, 6th International Conference on Compatibility and Power Electronics CPE 2009, Badajos, Spain, pp. 306 - 310 (2009)
V. Vodovozov and Z. Raud, An Object-Oriented Approach to Curriculum Design, 7th International Conference on Education and Information Systems, Technologies and Applications EISTA 2009, Orlando, USA, pp. 225 - 230 (2009)
Z. Raud and V. Vodovozov, Professional Thesaurus of Engineering Educational System, 2nd International Multi-Conference on Engineering and Technological Innovation IMETI 2009, Orlando, USA, 2009, 212 - 217 (2009)
V. Vodovozov and Z. Raud, Distance Control of Electric Drives and Power Converters via Internet: Concept of E-Laboratory, International IEEE Conference EUROCON 2009, St. Petersburg, Russia, pp. 804 - 809 (2009)
V. Vodovozov and Z. Raud, Simulation-Based Training in Engineering, 15th Annual EUROMEDIA Conference 2009, Bruges, Belgium, pp. 73 - 79 (2009)
I. Roasto, D. Vinnikov and V. Vodovozov, Simulation and Evaluation of Control Methods for the Rolling Stock Static Auxiliary Converter Based on Three-Level NPC Inverter Topology, IEEE Second International Conference on Power Engineering, Energy and Electrical Drives POWERENG, Lisbon, Portugal, pp. 593 - 598 (2009)
D. Vinnikov, I. Roasto and V. Vodovozov, Design Issues of Redundant Protection and Supervision System for the Special Purpose Power Converters, International Conference on Renewable Energy and Power Quality ICREPQ'09, Valencia, Spain, pp. 1 - 6 (2009)
J. Laugis, T. Lehtla and V. Vodovozov, Simulation in Learning Power Electronics, 7th International Symposium "Topical Problems in the Field of Electrical and Power Engineering", Doctoral School of Energy and Geotechnology, Narva-Joesuu, Estonia, pp. 83 - 88 (2009)
Z. Raud and V. Vodovozov, Active Learning in Electric Drives and Power Electronics, 7th International Symposium "Topical Problems in the Field of Electrical and Power Engineering", Doctoral School of Energy and Geotechnology, Narva-Joesuu, Estonia, pp. 63 - 68 (2009)
J. Laugis, T. Lehtla and V. Vodovozov, Distance Learning in Electrical Engineering, 6th International Symposium "Topical Problems in the Field of Electrical and Power Engineering", Doctoral School of Energy and Geotechnology, Kuressaare, Estonia, pp. 148 - 153 (2009)
M. Egorov, D. Vinnikov and V. Vodovozov, Analysis of State of the Art and Development Trends in Soft-Switched Half-Bridge DC/DC Converters, 6th International Symposium "Topical Problems in the Field of Electrical and Power Engineering", Doctoral School of Energy and Geotechnology, Kuressaare, Estonia, pp. 49 - 54 (2009)
V. Vodovozov and J. Laugis, Motor Drive Design Using Structured Query Language, Estonian Journal of Engineering, 14, pp. 334 - 344 (2008)
V. Vodovozov and Z. Raud, Model-Based Learning in Electric Drive Design, The 2008 European Simulation and Modelling Conference ESM'2008, Le Havre, France, pp. 355 - 359 (2008)
V. Vodovozov and J. Laugis, Expert System for Electric Drive Design, 13th International Power Electronics and Motion Control Conference EPE-PEMC 2008, Poznan, Poland, Paper 119 (2008)
V. Vodovozov and D. Vinnikov, Flexible Models of Electric Motor Drives, Òåõ÷íi÷íà Åëåêòðîäèíàìiêà, Kiiv, Ukraine, pp. 89 - 91 (2008)
V. Vodovozov, D. Vinnikov, J. Laugis and T. Lehtla, Interinstitutional Activity in Professional Training in Power Electronics, Òåõ÷íi÷íà Åëåêòðîäèíàìiêà, , Kiiv, Ukraine, pp. 58 - 61 (2008)
V. Vodovozov, E. Pettai and A. Auvaart, Design and Modelling of Electric Drive in Database Environment, IEEE International Symposium on Industrial Electronics ISIE'08, Cambridge, UK, Paper CD-000604 (2008)
J. Laugis and V. Vodovozov, Educational Collaboration in the Field of Power Electronics and Electromechanics, International Conference on International Education and Science Cooperation IESC 2008, St. Petersburg, Russia, pp. 243-245 (2008)
J. Laugis and V. Vodovozov, Motor Drive Design in Database Environment, 6th International Conference on Electrical Engineering ICEENG 2008, Cairo, Egypt, Paper EE018 (2008)
T. Jalakas, D. Vinnikov and V. Vodovozov, Development and Verification of Control and Protection Algorithms for the Special-Purpose High Power Converters, International Workshop ITELMS'2008, Panevezis, Lithuania (2008)
V. Vodovozov and J. Laugis, Universities Collaboration in Teaching Power Electronics, 12th European Conference on Power Electronics and Applications EPE 2007, Aalborg, Denmark, Paper 0011 (2007)
V. Vodovozov and J. Laugis, Object-Oriented Electric Drive Development Technology, The IEEE International Electric Machines and Drives Conference IEMDC'07, Antalya, Turkey, Paper AF000434 (2007)
V. Vodovozov and N. Petrov, An Environment for Electric Drives Selection, Adjusting, and Testing, 4th International Symposium "Topical Problems of Education in the Field of Electrical and Power Engineering", Kuressaare, Estonia. pp. 68-71 (2007)
V. Vodovozov, Projects Mastering with eDrive, 3rd International Symposium "Topical Problems of Education in the Field of Electrical and Power Engineering", Kuressaare, Estonia, pp. 68-71 (2006)
V. Vodovozov and E. Vodovozova, An Electric Drive for Artificial Ventilation of Lungs, V Summer Seminar on Nordic Network for Miltidisciplinary Optimised Electric Drives, Gdansk University of Technology, Gdansk, pp. 43-46 (2005)
V. Vodovozov, Nordic Network: A Glance from Russia, 2nd International Symposium "Topical Problems of Education in the Field of Electrical and Power Engineering", Kuressaare, Estonia. pp. 17-19. (2005)
V. Vodovozov and A. Loparev, Simulation Tools for Design and Testing of Electric Drives, 10th International Power Electronics and Motion Control Conference EPE-PEMC 2004, Riga, Latvia, paper DS 7.16 (2004)
V. Vodovozov, E. Vodovozova and A. Loparev, Laboratory Set-Up for Investigation of Servo Drives in Teaching and Training, IV Summer Seminar on Nordic Network for Multidisciplinary Optimized Electric Drives, Tallinn University of Technology, Tallinn, pp. 47-52 (2004)
V. Vodovozov and E. Vodovozova, Electric Drive Design: from Mathematical Model to Industrial One, III Summer Seminar on Nordic Network for Multidisciplinary Optimized Electric Drives, Warsaw University of Technology, Poland, pp. 48-51 (2003)
V. Vodovozov and E. Vodovozova, The Tools for Selection and Similation of Electric Drives, II Summer Seminar on Nordic Network for Multidisciplinary Optimized Electric Drives, Lappeenranta University of Technology, Finland, pp. 62-63 (2002)
V. Vodovozov and E. Vodovozova, Knoledge Estimation in Computer Learning Linguistics Systems, CAL2001 Conference "Learning Across the Ages - Looking Back and Looking Forwards", University of Warwick, UK (2001)
Software
eDrive - software for simulation and design of electric drives (1991 - 2010)
AVL - computer model of the system for artifical ventilation of lungs (2004)
ABC - test bed for teaching business English (1999)
BCD - tutorial on arrangement the computing workplace (1998)
Projects and Thesis
Research of advanced control and diagnostics systems for the high-power IGBT converters ETF8020, ETF, Tallinn (2009 - 2012)
Application of interdisciplinary and team and project based learning in master studies of electrical drives and power electronics, industry automation and mechatronics IN577, SA Innove, Tallinn (2008)
Energy saving and sustainable electrical power engineering SF0140009s08, SF, Tallinn (2008)
Development of a new laboratofy of power electronics IN7061, SA Innove, Tallinn (2007 - 2008)
Research on Mitsubishi Electric Servo Drives, St.Petersburg (2004)
Development and Research of the System for Distance Learning of Electric Drive in LabView Package, St.Petersburg (2001)
Development of the CNC System for the Optic Machinery, Sosnovy Bor (2001)
Development and Research of Transportation System for Ford Motor Company, Deaborn (2000)
Object-Oriented Technology for Educational Resources Optimization, St.Petersburg (2000)
Development and Research of Multimedia Tutorials for Foreign Languages Teaching, St.Petersburg (1999)
Development and Research of CNC System and Motor Drives for Industry Machines, Gatchina (1995)
Development and Research of CNC System for Space Shells Enterprise, Hotjkovo (1990)
Development and Research of Hardware and Software for Industry Microprocessor Control Systems, St.Petersburg (1988)
Development and Research of CNC System with Motor Drive for Space Bodies Construction, St.Petersburg (1985)
Development and Research of Motor Drive for Power Winding Machine WG500/1800 of BAER, St.Petersburg (1983)
Development and Research of Automatic Control System for Shipbuilding, St.Petersburg (1980)
Designing and Production of CNC System for Winding Machine of 6 Meters in Diameter, St.Petersburg (1979)
Development and Research of Interconnected Motor Drives for Programming Trajectory’s Moving Reproduction, Thesis. St.Petersburg (1979)
Inventions in Motor Drives and Control Systems
2036205 (1995); 94025169, 94025187, 94025143 (1994); 1576972, 1564588, 1554247, 1543514 (1990); 1488753 (1989); 1410831, 1383301 (1987); 1327059, 1236533, 1226505, 1223211, 1215089 (1986); 1187273, 1168900 (1985); 1125643, 1098096, 1095131(1984); 1023280, 1001011(1983); 983954, 954943, 951241, 926705, 903810, 903809 (1982)
Theory and Systems of Electric Drives (the cycle of lectures, series of labs, and the course project)
1. Electric Drive Arrangement
Energetics of electric drives (energetic model, energetic features, dynamic features, static features)
Mechanics of electric drive (forces of inertia and resistance, friction in mechanisms, mechanical transmissions, forces' and torques' reference, elastic mechanisms, gaps and clearances in mechanisms)
Selection and completing of electric drives (design algorithm, type selection, duty modes, motors' power calculation, optimization of speed modes)
2 General Purpose Electric Drives
Electric drives with squirrel cage induction motor (dynamic model of induction motor, steady state modes of induction drive, run-up modes of induction motor, soft starters, braking modes of induction motors, multispeed motors in electric drives, non-symmetrical modes of electric drives)
AC electric drives with rotor excitation (phase rotors’ AC electric drives, phase rotor machines' start-up and braking, multimachine electric drives, dynamic model of synchronous motor, duty modes of synchronous drive)
DC current electric drives (dynamic model of DC current electric drive, steady states of DC current electric drive, start-up modes of DC drives, braking modes of DC drives, DC drives’ control, electric drives with series excitation)
3 Electric Power and Informational Converters of Electric Drives
Electric power converters (power supply systems of electric motors, electric drive based on transistors, electric drive based on thyristors, thyristor electric drives’ features, control systems of thyristor converters, electric machines as converters in electric drives)
Informational converters (information conversion in electric drive, transfer functions and block diagrams of electric mechanisms, analog controllers, filters and sensors, pulse and code transducers, analog-digit and digital-analog transformation, digital filters and controllers, power supply of information converters)
Controllers’ design in electric drives (selection the structure of controllers, static precision providing, modulus control and standard settings, step-by-step correction of simple objects, step-by-step correction of complex objects, submissive control principle)
4 Precise Electric Drives
Electric drives of DC excitation (servomotor in electric drive, stepping electric drive, single-contour electric drive, path control systems, positioning)
Multiloop electric drives (two-contour adjustment drive, DC current electric drive with thyristor converter, two-zone adjustment systems, electric drive with elastic chains, servo-adjustment electric drives)
Automatic induction electric drives (scalar frequency adjustment, frequency-current adjustment, vector control, direct torque control)
Power Electronics (the cycle of lectures, exercises, labs, and tests)
Rectifiers (single- and three-phase half-wave, full-wave, and bridge)
Inverters (voltage source, current source, and resonant)
AC/AC Converters ac voltage regulators, direct frequency converters, and dc link converters)
DC/DC Converters dc voltage regulators, step-down choppers, step-up choppers, and universal choppers)
Utility Circuits (snubbers and clamps, gate and base drivers, and electromagnetic compatibility)
Experiments Using Electronics Workbench (rectifiers, ac converters, and choppers)
Questions (power electronic devices, rectifiers, inverters, and converters)
Electronics and Semiconductor Engineering (the cycle of lectures, exercises, labs, and tests)
Semiconductor Devices (semiconductors, diodes, transistors, thyristors)
Analog Electronics (circuit composition, amplifiers, supplies, and references)
Pulse and Digital Electronics (switching circuits and data converters)
Experiments Using Electronics Workbench (passive circuits, diode circuits, amplifiers, op amps, math converters, and pulsers)
Questions (electronic devices, amplifiers, switching circuits, and data converters)
C++ Programming on C++Builder for Engineers (the cycle of lectures, series of labs, and the course project)
Programming conceptions (data and objects, procedural programming, structural programming, modular programming, non-procedural programming)
Program designing (request for proposal, classification, object analysis, object decomposition, from code to application, debugging and optimization)
Microsoft Windows operation system (operation systems, windows and messages of Microsoft Windows, functioning of Microsoft Windows)
Introduction to visual programming (C++Builder’ IDE, C++Builder’ projects, VC Library, properties, events and methods, ownership and parentship)
Visual components (forms and frames, text components, button components, lists, data representation components, dialogs and menus)
Graphic tools of visual programming (canvas, graphic components, image processing)
Introduction to procedural programming (code editor, functions, expressions, form classes, events’ processing, graphics programming, exceptions, simple data types and statements, oei AnsiString)
Control structures (brunch statements, conditional statement, case statement, cycle statements, repetition statement, dialogs’ programming)
Introduction to structural programming (arrays, swapping and sorting, TStringList lists, structures and unions, dynamic data structures)
Introduction to modular programming (file exchange, DLL modules, database application architecture, databases connection, records access)
Object-oriented programming (encapsulation, constructors and destructors, frienf functions and classes, polymorphism, samples, inheritance, virtual functions and abstract classes)
Help systems (classification and compound, WinHelp thematic file, WinHelp projects,
Databases for Enginering Systems (the cycle of lectures and computer practice)
1. Databases
Introduction to databases (mathematic and computer science notations, types and classes)
Data models (database notion, databases designing stages, functional simulation, information logical simulation, data logical simulation, relational data model)
2. Sheets
Sheets design (sheets structure, keys and indexes, statements)
Sheet data processing (sheets export, sheets import, sheets connection, records processing, data search and replacing, filters)
Normalization (database structure, data scheme designing, main normal forms, topmost normal forms)
3. Queries
Queries to the single sheet (simple queries to the single sheet, queries properties, queries with functions and parameters, queries with calculations, group operations, queries with wizards)
Sheet change queries (active queries)
Multisheet queries (relational algebra of sheets with different structures, inner and external joints, relational algebra of sheets with equal structures, practical tasks of relational algebra)
SQL – Structural Query Language (about the language, selection queries, action queries)
4. Reports and forms
Reports (auto-reports and wizards, report designing, multi-sheet reports)
Forms (simple forms, form notion, simple form designing)
Multisheet forms (forms based on queries, submissive forms, join forms, data access pages)
5. Macros
Simple macros (base notion, simple macros, conditions in macros, macro commands)
Forms with macros (selective forms with submission, selective forms with lists, search forms, synchronous lists, storage control, complex forms studying)
6. VBA Programming in Microsoft Access
VBA program (program compound, procedural programming, variables and constants, file operations)
Microsoft Access objects model (object-oriented approach, control of sheets and queries, control of forms and reports, control elements of forms and reports)
VBA control structures (conditional statement, case statement, sycle and branch statements, repetition statements)
Data types (fundamental data types, static arrays, dynamic arrays, user data types)
7. Administering
User interface designing (start-up parameters, command line parameters, button forms, command buttons, user menus, toolboxes, context menus)
Databases file defense (database analysis, backup copying, database compression, database repair, database encrypting, password defense of database, VBA modules defense, data pages defense, MDE files, database dividing)
Common access to databases (access kinds, common access, replication, replica designing, particular replicas, replicas synchronization, replicas control)
Database user defense (workgroup, owner, user defense designing, defense wizard, user defense canceling, workgroup administrator, account records, rules distribution for users and groups, ownership granting)
VBA Programming for Engineers (the cycle of lectures and computer practice)
Macros and modules (macros recording, Visual Basic editor, Microsoft Access modules)
Procedures and functions (subprograms, VBA lexemes, variables and author’s constants, author’s functions, file operations)
Microsoft Word object model (Microsoft Word objects, Microsoft Word classes, selections control)
Microsoft Excel object model (Microsoft Word objects, Microsoft Excel classes, cells control)
Microsoft Access object model (Microsoft Word objects and classes, Microsoft Access forms and reports control)
Control Structures (control structures compound, conditional statement, case statement, cycle statement, transient statements, repetition statements)
Forms and reports programming (forms and documents features, control tools, design tools)
Data types (simple data types, static arrays, dynamic arrays, authors’ data types)
User interface programming (menus, button tools, start-up interface settings)
Basics of Informational Knowledges (computer practices)
1. Basics of Internet
Internet Organization (nets, global nets, modems, structure and functions of Internet)
Internet Explorer (user interface, Web-servers)
Search Systems (search servers, metasearch and address systems, file exchange)
Email (email organization, Microsoft Mail and News, Outlook Express, email through Internet, news groups and other communications)
Microsoft Outlook (Microsoft Outlook topologue, Inputs, Contacts, Dating, Problems, systematization and data search)
Microsoft FrontPage (contents of Microsoft FrontPage, Web site creation, Web texts and Web graphics, links, tables and forms, documents of HTML, documents style description in HTML)
Web site Publishing (publishing, registration)
2. Site Design in Dreamweaver
Texts (user interface, Web page and its properties, links)
Graphics (raster and vector images, graphics objects, active images)
Table design (tables, frames, free positioning elements)
HTML (language properties, tags, metas, CSS)
Web Site (basics, site registration in Dreamweaver, Files window, site publishing, assets, templates)
Web Programming (scripts, first steps in JavaScript, operators, functions, system classes and objects, events)
Forms (form classes, form objects, form creating with templates)
3. Photoshop Graphics
Documents and Instruments (Photoshop window, menu Image, color models, menu File)
Raster Graphics (selection, moving and filling, drawing, deleting)
Vector Graphics (contours, shapes, fonts, paragraphs)
Transformations (menu Edit, blocking, placing)
Color Management (color panels, measurement instruments, color correction, correction methods)
Layers (panel Layers, grouping, additional layers, effects and styles)
Filters (filter groups, imagination, distortions)
4. CorelDraw Graphics
User Interface of CorelDraw
Documents
Views
Contours
Object Organization
Filling
Texts
Effects
Rastering in CorelDraw