Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

European Computer Driving Licence 1

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
18ESPG1 Z 2 0+2 Czech
Lecturer:
Jaromír Kukal, Zuzana Petříčková, Lucie Tylová
Tutor:
Jaromír Kukal, Zuzana Petříčková, Lucie Tylová
Supervisor:
Department of Software Engineering
Synopsis:

Spreadsheet calculators are an important tool, especially for students and graduates in Software engineering in economics. The winter semester introduces the students also into other office tools. The accent is put on advanced functions of MS Excel (names, functions and expressions, pivot table and graph). Next, the VBA language will be introduced and macros and user functions will be addressed.

Requirements:
Syllabus of lectures:

1.Introduction into office applications

2.Word processors: basic functionalities

3.Text processors: advanced typographic topics

4.Presentations: introduction, fundamentals

5.Presentations: advanced techniques

6.Introduction into spreadsheets

7.Charts, pivot table, pivot chart

8.Functions: mathematical and logical

9.Functions: reference and database

10.Functions: text and date

11.VBA programming: macros, introduction

12.VBA programming: user functions

13.VBA programming: events

14.VBA programming: work with the spreadsheet.

Syllabus of tutorials:

1.Introduction into office applications

2.Word processors: basic functionalities

3.Text processors: advanced typographic topics

4.Presentations: introduction, fundamentals

5.Presentations: advanced techniques

6.Introduction into spreadsheets

7.Charts, pivot table, pivot chart

8.Functions: mathematical and logical

9.Functions: reference and database

10.Functions: text and date

11.VBA programming: macros, introduction

12.VBA programming: user functions

13.VBA programming: events

14.VBA programming: work with the spreadsheet.

Study Objective:

To introduce the students to MS Office, especiallz to MS Excel in the relation to their study program. The students shall learn about VBA and be able to use it (macros, functions, forms).

Study materials:

Key references:

[1] J. Walkenbach: Excel 2007 VBA Programming For Dummies, Wiley Publishing, 2007

Note:
Time-table for winter semester 2019/2020:
Time-table is not available yet
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2019-12-15
For updated information see http://bilakniha.cvut.cz/en/predmet25048705.html