European Computer Driving Licence

Lecturer:

Zuzana Reitermanová

Tutor:

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. Summer semester follows the winter semester with advanced VBA programming topics (charts, objects, graphical user interface, add-ins programming) and introduces some applications in economics, mathematics, operational research, and computer science.

Requirements:

Syllabus of lectures:

Syllabus of tutorials:

1.Revision from winter semester: clicking 15-game

2.User forms: two handed bandit

3.Class modules: class mortage, advanced event processing

4.Chart programming: von Koch's curve

5.Chart programming: transport network vizualization

6.Add-ins programming: HTML export

7.MS Excel as a database

8.Aplication in operational research: linear programming

9.Aplication in operational research: distribution problems

10.Aplication in statistics: one-demesional statistics

11.Aplication in statistics: correlation and reggresion

12.Aplication in operational research: multi-criterial decision making

13.Aplication in computer science: datamining

14.Aplication in computer science: code genearation in other language

Study Objective:

To provide deeper understandig about MS Excel and VBA possibilities with respect to software engineering in economics.

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: