European Computer Driving Licence 2

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Software Engineering

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:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

• BS Matematické inženýrství - Matematické modelování (elective course)
• BS Matematické inženýrství - Matematická fyzika (elective course)
• BS Matematické inženýrství - Aplikované matematicko-stochastické metody (elective course)
• BS Informatická fyzika (elective course)
• BS Aplikace softwarového inženýrství (elective course)
• BS Aplikovaná informatika (elective course)
• BS jaderné inženýrství B (elective course)
• BS Jaderné inženýrství C (elective course)
• BS Dozimetrie a aplikace ionizujícího záření (elective course)
• BS Experimentální jaderná a částicová fyzika (elective course)
• BS Inženýrství pevných látek (elective course)
• BS Diagnostika materiálů (elective course)
• BS Fyzika a technika termojaderné fúze (elective course)
• BS Fyzikální elektronika (elective course)
• BS Jaderná chemie (elective course)