Course detail

MS Excel Application Development

FP-VtaPAcad. year: 2017/2018

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

4

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

The course contains lectures that explain basic principles, problems and methodology of the discipline, and exercises that promote the practical knowledge of the subject presented in the lectures.

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)
Michael Schwimmer, Melanie Breden : Excel 2007 VBA Velká kniha řešení, Computer Press, Praha 2009, ISBN: 9788025126981 (CS)

Recommended reading

D.F.Scott Velká kniha programování v Microsoft Office 2000, Computer Press, Brno 2000, ISBN: 8072262408 (CS)

Classification of course in study plans

  • Programme BAK-KME Bachelor's

    branch BAK-MME , 2. year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Petr Dydowicz, Ph.D.

Syllabus

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

Computer-assisted exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Petr Dydowicz, Ph.D.

Syllabus

Topics 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