Creation of Scripts and Macros for Economic Tasks

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department Děčín

Synopsis:

Fundamentals of VBA, functions and procedures, examples of their use. Forms and offers for user oriented applications, cooperation with other applications, solution to compatibility problems among different spreadsheet programs versions. Everything with the respect to economic tasks.

Requirements:

algorithmization, fundamentals of programming, spreadsheets programs fundamentals

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Acquisition of knowledge in the following fields: use of programming function in spreadsheet programs for data processing, interpretation, and presentation by the means of VBA with the respect to economic practise.

Study materials:

Jurák Z. a koletiv: Excel pro managment, ekonomy a podnikatele, Computer Media, 2006

Breden M., Schwimmer M.: Excel 2007 VBA Velká kniha řešení, Computer Press, 2009

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

• KOMBI studium od 13-14 (obor MED) (compulsory course)
• KOMBI studium od 12-13 (obor MED) (compulsory course)
• PRE oboru MED rozřazení od 13-14 (compulsory course)
• KOMBI studium od 11-12 (obor MED) (compulsory course)
• PRE oboru MED rozřazení od 12-13 (compulsory course)
• KOMBI studium od 13-14 (obor MED) skok do 2.r. (compulsory course)
• KOMBI studium od 14-15 (obor MED) (compulsory course)
• KOMBI studium od 12-13 (obor MED) skok (compulsory course)
• 1.r. KOMBI studium (od ZS 11-12), od 2.r. PRE MED studium dále (compulsory course)
• KOMBI studium od 13-14 (obor MED) skok do 3.r. (compulsory course)
• PRE oboru MED rozřazení od 14-15 (skok z 1. r.) (compulsory course)
• PRE oboru MED rozřazení od 14-15 (compulsory course)
• PRE oboru MED rozřazení od 12-13 (skokMelnikov) (compulsory course)
• KOMBI studium od 14-15 (obor MED) skok z 1.r. do 3.r. (compulsory course)
• PRE bak. studium oboru MED rozřazení od 15-16 (compulsory course)
• PRE bak. studium oboru MED rozřazení od 15-16, od 3.ročníku obor MED v KOMBI formě (compulsory course)