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

European Computer Driving Licence 2

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
18ESPG2 Z 2 0+2 Czech
Lecturer:
Vladimír Jarý, Zuzana Petříčková
Tutor:
Vladimír Jarý, Zuzana Petříčková
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:
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-09-22
For updated information see http://bilakniha.cvut.cz/en/predmet25050405.html