352-0339/01 – Praktické programování ve VBA (PPvVBA)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits2
Subject guarantorIng. David Fojtík, Ph.D.Subject version guarantorIng. David Fojtík, Ph.D.
Study levelundergraduate or graduateRequirementOptional
Year2Semesterwinter + summer
Study languageCzech
Year of introduction2010/2011Year of cancellation
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FOJ74 Ing. David Fojtík, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 0+2
Combined Graded credit 8+4

Subject aims expressed by acquired skills and competences

The primary goal of the subject is by the creation of useful features and tools (that simplify the work in MS Office) to acquaint students with practical programming.

Teaching methods

Tutorials
Project work

Summary

The subject closely follows the compulsory subject Technical computing, where students acquired a basic knowledge of algorithms. Acquired knowledge are expanding by practical skills to apply through VBA (Visual Basic for Application). Graduates will thus be able to use the programming options of MS Office products to solve various tasks from practice.

Compulsory literature:

FOJTÍK, D. Programovací techniky. [online] dostupý z WWW <URL http://vyuka.fs.vsb.cz>

Recommended literature:

ČERNÝ, J. Excel 2000–2007 - záznam, úprava a programování maker. Praha: Grada Publishing, a.s., 2008. ISBN 978-80-247-2305-1 MICROSOFT. Microsoft Development Network Library (MSDN). [online], dostupný z WWW <URL http://msdn.microsoft.com/library> POKORNÝ, J. KVOCH, M. Programování ve Visual Basicu 6.0. České Budějovice: Kopp, 1999. ISBN 80-7232-044-0.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Topics: • Practical Algorithms in VBA to solve programming problems in MS Excel. • Basics and principles of object-oriented programming (the concept of class, interfaces, properties, methods, etc.). • MS Excel object model (work with objects, collections, and the interaction between MS Office) • Event-driven programming - expanding the user interface. • An introduction to modern programming language Visual Basic.. NET

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2010/2011 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R003) Transport Machinery and Material Handling P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment P Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (40) Design of Machines and Equipment P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (60) Industrial Design P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (20) Production Machines and Equipment P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (70) Earth, Mining and Building Machines P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3907R004) Energy Management P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R040) Industrial Engineering P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R013) Robotics (70) Robotics P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology P Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering (2301R023) Technical Diagnostics, Service and Management (70) Technical Diagnostics, Repairs and Maintenance P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3904R016) Environmental Engineering (70) Environmental Engineering P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3708R028) Transport Technology (20) Surface Transport P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3901R003) Applied Mechanics P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering P Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment (10) Transport Equipment and Technology P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R003) Transport Equipment and Technology P Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3907R009) Operation of Energy Equipment P Czech Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner