SylabUZ
Course name | Object-oriented programming |
Course ID | 06.9-ZiIP-ANG-D-08_20 |
Faculty | Faculty of Engineering and Technical Sciences |
Field of study | Management and Production Engineering |
Education profile | academic |
Level of studies | Second-cycle studies leading to MSc degree |
Beginning semester | winter term 2020/2021 |
Semester | 1 |
ECTS credits to win | 3 |
Course type | obligatory |
Teaching language | english |
Author of syllabus |
|
The class form | Hours per semester (full-time) | Hours per week (full-time) | Hours per semester (part-time) | Hours per week (part-time) | Form of assignment |
Class | 15 | 1 | 9 | 0,6 | Credit with grade |
Laboratory | 15 | 1 | 9 | 0,6 | Credit with grade |
Lecture | 15 | 1 | 9 | 0,6 | Credit with grade |
Familiarize with the object-oriented approach to system analysis and design, developing skills in using a modern programming environment to creation of simple elements of the IT system.
Computer skills.
Lecture
Reminder of the basic concepts: algorithm, programming language, low level language, high level language, programming, program. Basic information about object-oriented programming, VBA objects in Excel. Analysis of a simple function created in the VBA environment.
Basic elements of the object model. The object as an element of the real world and its model. Object components: attributes and methods. Object classes. Object-oriented approach to system description. Analysis of the object-oriented application model in VBA. Implementation of the sample program using objects available in the VBA environment.
Modules, procedures and functions. Passing parameters by value and reference. Using the exception mechanism to handle errors in the program.
Object-event model of the program. The used of objects events to automate operations carried out in the application.
Class form modules. Class definition syntax. Definition of fields and properties. Definition of procedural and functional methods. Method arguments passed by value and reference. The process of creating and removing objects. References to objects and their components. Design, implementation and testing of an example class. Creating add-ons
Exercises
Example function in a VBA environment. Selected Excel objects, property references. Assignment instruction, arithmetic operators, standard functions.
References to data , performing calculations and displaying results in Excel worksheets cells. Using the exception handling mechanism to catch errors in the designed programs.
Modules, procedures and functions. Passing parameters by value and reference.
Form class structure, fields and methods. Defining procedural and functional methods. Passing parameters by value and reference, examples of applications. Creating and deleting objects.
Laboratory
Introduction to VBA in Excel. Creating macros using the recording mechanism. Creating toolbars with an individual set of functions. Analysis of the macro codes. Creating your own modules containing functions that perform simple calculations.
Form controls in VBA, user interface design, properties window, event definition.
Implementation of programs based on tasks completed as part of the exercises:
Lecture: a conventional lecture
Exercises: problem tasks, case analysis, individual work
Laboratory: practical classes in the computer laboratory
Outcome description | Outcome symbols | Methods of verification | The class form |
Lecture: a positive result of the assessment via a written test
Exercises: a positive final assessment, based on grades from tests and oral answers
Laboratory: a positive result of the assessment based on final test
Final rating: the arithmetical mean of grades from individual types of classes.
Modified by dr inż. Grzegorz Pająk (last modification: 27-04-2020 11:40)