1. SylabUZ
2. Wydział Mechaniczny
3. semestr zimowy 2023/2024
4. Management and Production Engineering - pierwszego stopnia z tyt. inżyniera
5. Programming Techniques

Wygeneruj PDF dla tej strony

Programming Techniques - opis przedmiotu

Cel przedmiotu

Familiarize with modern tools and techniques of application development, developing the ability to use a high-level language to solve simple engineering problems.

Wymagania wstępne

Zapisz zmiany

Basic computer skills.

Zakres tematyczny

Lecture

L01. Introduction to programming: algorithm, programming language, programming, program, application model in Visual Basic for Application, basic application components, references to Excel components, reading and assigning values.

L02. Fundamentals of programming in Visual Basic: standard data types, variable declarations, assignment statement, arithmetic operators and standard functions, defining procedural and function macros, passing parameters, handling exceptions.

L03. Program flow control: graphical notation of algorithms, syntax of IF…THEN…ELSE and ELSEIF instructions, logical type, relational and logical operators.

L04. Iterative FOR statements: processing VBA collections, syntax of the FOR … EACH statement, optimization of programs using iterative statements, FOR … NEXT statement.

L05. Iterative DO…LOOP statements: syntax of DO…WHILE, DO…UNTIL statements, examples of iterative algorithms with unknown number of repetitions, selection of the right iterative instruction to solve a specific task.

L06. Advanced elements of VBA - events and add-ons: the concept of events in programming, the use of events to automate frequently performed operations, distribution of VBA code as add-ons.

L07. Final test.

Laboratory

L01. Recording and editing macros in Visual Basic for Excel.

L02. Implementation of simple macros using Range elements and assignment statement.

L03. Running macros in the Visual Basic environment, using the debugger to track the program and detect errors.

L04. Implementation of simple macros using variables and operators as well as standard and worksheet functions.

L05-06. Implementation of procedures and functions, passing parameters.

L07. Use of the exception handling mechanism to handle errors.

L08-09. Implementation of algorithms using conditional statement.

L10-11. Implementation of algorithms processing ranges using the FOR…EACH statement.

L12. Implementation of algorithms processing ranges using the FOR…NEXT statement.

L13. Use events to automate frequently performed operations.

L14. Summary and repetition of the learned VBA elements.

L15. Final test.

Metody kształcenia

Lecture: a conventional lecture

Laboratory: practical classes in the computer laboratory

Efekty uczenia się i metody weryfikacji osiągania efektów uczenia się

Opis efektu	Symbole efektów	Metody weryfikacji	Forma zajęć

Warunki zaliczenia

Lecture: a positive result of the assessment via a written test

Laboratory: the condition for passing the laboratory is to pass all laboratory tasks and a positive grade in the final test

Final grade: the condition for passing the course is to pass all its forms, the final grade for the course is the arithmetic mean of the grades for individual forms of classes

Literatura podstawowa

1. Alexander M., Walkenbach J., Excel VBA Programming for Dummies,  For Dummies, 2018.
2. DeMarco J., Pro Excel 2007 VBA, Apress, 2008.
3. Jelen B., Haselier R. G., Syrstad T., Microsoft Excel 2019 VBA und Makros, Dpunkt.Verlag GmbH, 2019.
4. Korol J., Microsoft Excel 2019 Programming by Example with Vba, XML, and ASP, Mercury Learning & Information, 2019.
5. Morgado F., Programming Excel with VBA: A Practical Real-World Guide, Apress, 2016.

Literatura uzupełniająca

1. Elite Tech Academy, EXCEL VBA: A Step by Step Guide to Learn EXCEL VBA Programming for Absolute Beginners, Independently published, 2019.
2. Kofler M., Definitive Guide to Excel VBA, Apress, 2003.
3. Williams D. A., Excel Macros: The Ultimate Beginner's Guide to Learn Excel Macros Step by Step, Independently published, 2019.

Uwagi

Zmodyfikowane przez dr inż. Grzegorz Pająk (ostatnia modyfikacja: 03-05-2023 12:25)