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 2021/2022 |
| 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 | - | - | Credit with grade |
| Laboratory | 15 | 1 | - | - | Credit with grade |
| Lecture | 15 | 1 | - | - | 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.
Lectures
L01. Introduction to object-oriented programming in Visual Basic for Applications: the concept of class and object, object-event model of the application on the example of Excel, object structure - methods and properties, basic Excel objects, data types, modifying object properties, using assignment statements, introduction to defining macros.
L02. Basics of programming in Visual Basic for Applications: creating modules, defining macros of procedure and function types, passing parameters by value and reference, standard functions and procedures, defining and using variables, arithmetic operators and standard functions, exception handling.
L03-04. Form classes in VBA, implementation of decision blocks and processing of collections of objects: defining form modules, objects representing elements of user interface, properties, methods and events of forms controls, design of interface, IF…THEN statement syntax, relational and logical operators, FOR...EACH statement syntax, object collection processing.
L05. Advanced use of standard VBA objects, interaction with Word objects: creating personalized charts, modifying properties of VBA objects, generating reports in Word format based on data collected in Excel sheets.
L06: Events of Excel objects, add-ins: the concept of events in object-oriented programming, Application, Workbook, Worksheet and Range object events, defining event methods in the Visual Basic for Application, using events to automate selected activities, distribution of VBA code as add-ins, modification of the Excel interface from the program code.
L07: Final test.
Exercises
E01-02. Defining VBA procedures using properties and methods of the basic Excel objects, assignment statement, arithmetic operators, and standard and sheet functions.
E03. Defining events of the form object using a conditional statement.
E04. Defining events of the form object using an looping statement for processing collections of objects.
E05. Using standard VBA objects to create personalized charts.
E06. Defining event procedures to automate selected activities.
E07. Final test.
Laboratory
L01: Recording and editing of macros in the environment of Visual Basic for Excel, using the debugger to track the program progress and detect errors.
L02: Implementation of simple VBA macros using the properties and methods of basic Excel objects, assignment statement, arithmetic operators and standard functions.
L03: Implementation of form class, user interface design, event implementation.
L04: Implementation of form events using conditional and looping statements.
L05. Implementation of personalized charts using standard VBA objects.
L06. Generating reports based on data collected in Excel spreadsheets by interacting with Word objects.
L07. Final test.
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 result of the assessment via a written test
Laboratory: completion of laboratory tasks, assessment of the test conducted at the computer.
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.
Modified by dr inż. Grzegorz Pająk (last modification: 04-05-2021 11:29)
