SylabUZ

Generate PDF for this page

Object-oriented programming - course description

General information
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
Course information
Semester 1
ECTS credits to win 3
Course type obligatory
Teaching language english
Author of syllabus
  • dr inż. Grzegorz Pająk
  • dr inż. Iwona Pająk
Classes forms
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

Aim of the course

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.

Prerequisites

Computer skills.

Scope

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.

Teaching methods

Lecture: a conventional lecture

Exercises: problem tasks, case analysis, individual work

Laboratory: practical classes in the computer laboratory

Learning outcomes and methods of theirs verification

Outcome description Outcome symbols Methods of verification The class form

Assignment conditions

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.

Recommended reading

  1. DeMarco J., Pro Excel 2007 VBA, Springer, 2008,
  2. Kofler M., Definitive Guide to Excel VBA, Springer, 2003,
  3. Morgado F., Programming Excel with VBA, Springer, 2016,
  4. Walkenbach J., Excel Vba Programming For Dummies, John Wiley &Sons; 4 edition, 2015.

Further reading

  1. Booch G., Rumbaugh J., Jacobson I., The Unified Modeling Language User Guide, Addison-Wesley Professional, 2 edition, 2005,
  2. Walkenbach J., Excel 2013 Bible, Wiley, 1 edition, 2018

Notes


Modified by dr inż. Grzegorz Pająk (last modification: 04-05-2021 11:29)