352-0321/01 – Programming Techniques (PrT)

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
Year2Semestersummer
Study languageCzech
Year of introduction2001/2002Year 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 is to teach students how to practically create a basic computer algorithm. The second goal is to teach students to use the programming capabilities of Microsoft Excel to solve various problems in practice. Students will learn the basics of the programming language Microsoft Visual Basic and methodology development in the macro environment (VBA), Visual Basic for Application.

Teaching methods

Tutorials
Project work

Summary

The course acquaints students with the basic principles of programming. Mostly deals with very basic elements of programming languages​​, thus the essence of variables, loops, branching program, diversification program functions and subroutines, etc. The lessons are only using a very popular programming language, Microsoft Visual Basic, and it mainly used as a macro language in MS Office (VBA - Visual Basic for Application). Students are familiar with the versatility of this language and its practical application to create additional functionality in MS Office. Subject of your song is suitable not only for future professionals in the field, but for all intensive users of advanced applications that will reveal the possibility of extending the offer or automate frequently repeated actions using VBA. The study of this subject is appropriate and recommended subjects precursor Information Technology, Computer Science, Databases and the Internet in undergraduate degree programs and courses operating systems and programming, special programming techniques, Information Technology, Introduction to Computer Science Master's degree program. (business objects guaranteed by the Department 352).

Compulsory literature:

POKORNÝ, J. KVOCH, M. Programování ve Visual Basicu 6.0. České Budějovice: Kopp, 1999. ISBN 80-7232-044-0. WALKENBACH, J. Microsoft Excel 2000 a 2002 Programování ve VBA. Praha : Computer Press, 2001, 736 s. ISBN 80-7226-547-4 FARANA, R. & KAČMÁŘ, D. Vybrané algoritmy zpracování informací. Ostrava, Skriptum VŠB TUO, 1998, 134 s. ISBN 80-7078-398-2. MICROSOFT. Microsoft Development Network Library (MSDN). Dokumentace online, dostupný též na http://msdn.microsoft.com/library MICROSOFT. Microsoft Visual Basic 6.0 Příručka programátora, Praha : Computer Press, 2003, 852 s. ISBN 80-7226-154-1.

Recommended literature:

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:

To complete this course are required no previous articles or knowledge, but instead is required for programming of interest and a curiosity and student autonomy. The content of teaching is as follows: 1.t Developmental language environment, working wi. the project, basic concepts 2. Available data types, variable declarations, and general operations with 3. Debugging of programs, logical expressions and branching using IF-THEN 4. Branching program using a Select Case and the use of cycles (For Do-Loop) 5. Create your own subroutines and functions, Part I 6. Creation of subroutines and functions II - completion, use the functions available 7. Written work I. Field and user data type (structure) 8. Introduction to object oriented programming, using objects and collections, events, etc. 9. MS Excel object model, enter the program 10. Examples of custom macros and functions in MS Excel 11. Processing of exceptions 12. Working with Files 13. Introduction to the visual development of applications 14. Written Work II, Credits

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 K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R003) Transport Machinery and Material Handling K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment K Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering (2302R007) Hydraulics and Pneumatics K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (20) Production Machines and Equipment K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2302R010) Design of Machines and Equipment (70) Earth, Mining and Building Machines K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3907R004) Energy Management K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R040) Industrial Engineering K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R013) Robotics (70) Robotics K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering (2301R023) Technical Diagnostics, Service and Management (70) Technical Diagnostics, Repairs and Maintenance K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3904R016) Environmental Engineering (70) Environmental Engineering K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3708R028) Transport Technology (20) Surface Transport K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering K Czech Šumperk 2 Optional study plan
2010/2011 (B2341) Engineering K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R002) Transport Equipment (10) Transport Equipment and Technology K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (3907R009) Operation of Energy Equipment K Czech Ostrava 2 Optional study plan
2010/2011 (B2341) Engineering (2301R003) Transport Equipment and Technology K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering P Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3901R003) Applied Mechanics P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R003) Transport Machinery and Material Handling P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (40) Design of Machines and Equipment P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (20) Production Machines and Equipment P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3907R004) Energy Management P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R013) Robotics (70) Robotics P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (60) Industrial Design P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology P Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (2301R040) Industrial Engineering P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3904R016) Environmental Engineering (70) Environmental Engineering P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R023) Technical Diagnostics, Service and Management (70) Technical Diagnostics, Repairs and Maintenance P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3708R028) Transport Technology (20) Surface Transport P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (70) Earth, Mining and Building Machines P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment P Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering P Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering K Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment K Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (2302R003) Transport Machinery and Material Handling K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R007) Hydraulics and Pneumatics K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (20) Production Machines and Equipment K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (70) Earth, Mining and Building Machines K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3907R004) Energy Management K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R013) Robotics (70) Robotics K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Šumperk 2 Optional study plan
2009/2010 (B2341) Engineering (2301R040) Industrial Engineering K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3904R016) Environmental Engineering (70) Environmental Engineering K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (2301R023) Technical Diagnostics, Service and Management (70) Technical Diagnostics, Repairs and Maintenance K Czech Ostrava 2 Optional study plan
2009/2010 (B2341) Engineering (3708R028) Transport Technology (20) Surface Transport K Czech Ostrava 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Šumperk 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 2 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Šumperk 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 2 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Šumperk 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 2 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Šumperk 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 2 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 2 Optional study plan
2004/2005 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2004/2005 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2003/2004 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2003/2004 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan
2002/2003 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty P Czech Ostrava 2 Optional study plan
2002/2003 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner