Course detail

Office Applications

FP-KA_2Acad. year: 2012/2013

The course focuses on the following topics: application of knowledge acquired in the courses “Algorithmization and Programming Techniques” and “Fundamentals of PC” to the area of creating macros and supporting programmes in MS office environment, especially in MS Excel. Fundamentals of object programming in Visual Basic for Application (VBA) environment.

Language of instruction

Czech

Number of ECTS credits

Mode of study

Not applicable.

Guarantor

Ing. Petr Dydowicz, Ph.D.

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

Students will be made familiar with theoretical and practical knowledge of philosophy of creating simple as well as more sophisticated applications on the basis of knowledge of general programming techniques and algorithms including knowledge of concrete development tool (VBA). Their knowledge can be applied to elaboration of semester projects in other courses.

Prerequisites

1. Competence in PC (theoretical and practical)
2. Competence in MS DOS and MS Windows XP operating systems.
3. Competence in MS Office, especially MS Excel, MS Word,
4. Competence in algorithmization issues
5. Competence in basic programming techniques

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

Conditions for awarding the course-unit credit:
1. Delivery of semester work regarding - project
2. Active participation in seminars will be assessed by the teacher.
3. Tests covering the topics corresponding to the acquired theoretical knowledge and creation of easy application

Form of examination: Combined, composed of two parts:
1. Written part – creation of concrete application
2. Practical oral part - the written test may be possibly followed by an oral examination if necessary

Course curriculum

Topics of lectures are the following:
- Creation of macros in MS Excel
- Development environment VBA
- Basic terminology
- Object oriented programming
- Forms, dialogues,
- Use of API
- Procedures, functions, modules
- Structure, structured programming, managerial structures
- Work with files
- Error correcting techniques
- Debugging, optimization and documentation of the programme

Work placements

Not applicable.

Aims

The main objective of the course is to provide students with the theoretical as well as practical fundamental knowledge necessary for creating simple user programmes and macros in MS Excel environment by means of development Visual Basic for Application (VBA) tool.

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

Control of results of independent work on assigned tasks. In case of absence from seminars, the teacher can set elaboration of an additional task

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Walkenbach John : Microsoft Excel 2000&2002 – programování ve VBA, Computer Press, Praha 2001, ISBN: 80-7226-547-4 (CS)

Type of course unit

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. Petr Dydowicz, Ph.D.

Syllabus

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

Ing. Dagmar Řešetková, Ph.D.
Ing. Petr Dydowicz, Ph.D.
Ing. Zdeněk Brož, Ph.D.

Syllabus

Topics of lectures are the following:
- Creation of macros in MS Excel and MS Office
- Development environment VBA
- Basic terminology
- Object oriented programming
- Forms, dialogues,
- Use of API
- Procedures, functions, modules
- Structure, structured programming, managerial structures
- Work with files
- Error correcting techniques
- Debugging, optimization and documentation of the programme

VUT

Faculties

University Institutes

Parts

Office Applications

Type of course unit