European Computer Driving Licence 1

Lecturer:

Martin Plajner (gar.), Zuzana Reitermanová

Tutor:

Martin Plajner (gar.), Zuzana Reitermanová

Supervisor:

Department of Software Engineering in Economy

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 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: