Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2022/2023

European Computer Driving Licence 1

The course is not on the list Without time-table
Code Completion Credits Range Language
18ESPG1 Z 2 0+2 Czech
Lecturer:
Tutor:
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:
Further information:
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2023-02-02
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet25048705.html