Course detail

Application Software

FP-APVAcad. year: 2022/2023

The course focuses mainly on creating projects and programs in the Visual Basic for Application development environment of MS Excel. The content of the course is teaching the VBA programming language in the MS EXCEL environment in order to acquire basic knowledge and principles of programming and skills in creating simple form programs or custom functions.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

Ing. Bernard Neuwirth, Ph.D., MSc

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

Students will know theoretically and practically the philosophy of creating simple and more complex applications based on knowledge of general and modern programming techniques and algorithms, including knowledge of a specific development tool.

Prerequisites

Basic knowledge of MS Excel from secondary school and high school curriculum

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course is taught in the form of lectures, which are in the nature of an explanation of the basic principles and theory of the discipline. The exercises are based on practical practice of the lectures and on voluntary consultations to solve a specific problem on a given project.

Assesment methods and criteria linked to learning outcomes

In order to obtain a classified credit, it is necessary to obtain at least 50 points out of a total of 100 points for the semester project in VBA MS Excel. The project assignment will be published the second week of the semester.

Course curriculum

1. Truth table, ASCII, Number systems, conversion between number systems. Introduction excel, formatting, functions, stacked and combined functions, filtering, sorting data.
2. Creating, modifying and using graphs, contingency tables.
3. Introduction to VBA, forms, sheet and workbook event procedures.
4. ActiveX controls
5. Objects, methods, properties, events, Range, Offset and Cells properties.
6. Variables, constants, working with variant data type, finding the variable data type
7. Structured variables, interfacing with ActiveX controls
8. Conditions, branching
9. Cycles with a constant number of repetitions, with a control condition at the beginning and end of the cycle, cycles of elements of a set or collection (for each in)
10. Procedures, functions, modules, overloading
11. Error handling techniques
12. Working with files, prints
13. Final consultation on projects

Work placements

Not applicable.

Aims

The main goal is to learn programming techniques with the support of current development tools in the creation of user programs or more complex projects.

Specification of controlled education, way of implementation and compensation for absences

Lectures (even week) are optional, exercises in the even week are compulsory - practicing the material presented in the lecture, exercises in the odd week are optional, so called consultation exercises, designed to solve a specific problem related to the solution of the semester project or practiced material.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

BARILLA, J. Microsoft Excel 2013: Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2013. 496 s. ISBN 978-80-251-4114-4.
FORSTOVÁ Lenka, VBA Excel v příkladech + CD, Computer media, 2010, ISBN 978-80-7402-042-1.
Lambert, Joan. MOS 2016 Study Guide for Microsoft Excel. 1st ed. Redmond: Microsoft Press, 2016. 192 p. ISBN 978-0735699434
MYŠÁK, M. Kontingenční tabulky a grafy: Výukový průvodce. 1. vyd. Brno: Computer Press, 2013. 224 s. 978-80-251-4113-7.

Recommended reading

Not applicable.

Elearning

eLearning: currently opened course

Classification of course in study plans

  • Programme BAK-MIn Bachelor's 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

doc. Ing. Vít Novotný, Ph.D.

Syllabus

  1. Subject guide , number systems, decision table
  2. Introduction to VBA, forms, sheet and workbook event procedures, ActiveX controls
  3. Objects, methods, properties, events, Range, Offset and Cells properties, simple data types
  4. Structured variables, interfacing with ActiveX controls, conditions, branching
  5. Loops, conditions, branching, error handling
  6. Procedures, functions, modules, files

Exercise

26 hod., optionally

Teacher / Lecturer

Ing. Dominik Hromada
Ing. Petr Dydowicz, Ph.D.

Syllabus

  1. Repetition from high school: functions of MS Excel, filtering, sorting, number systems
  2. Project assignment, MS Excel charts
  3. Introduction to VA, forms, sheet and workbook event procedures, ActiveX controls
  4. Consultation exercises
  5. Objects, methods, properties, events, Range, Offset and Cells properties, simple data types
  6. Consultation exercises
  7. Structured variables, interfacing with ActiveX controls, conditions, branching
  8. Consultation exercises
  9. Loops, conditions, branching, error handling
  10. Consultation exercises
  11. Procedures, functions, modules, files
  12. Consultation exercises
  13. Consultation exercises

Elearning

eLearning: currently opened course