Skip to main content
Skip header
Terminated in academic year 2022/2023

Information Technology Application in Economic Practice I.

Type of study Bachelor
Language of instruction Czech
Code 545-0291/07
Abbreviation AVT I
Course title Information Technology Application in Economic Practice I.
Credits 6
Coordinating department Department of Economics and Control Systems
Course coordinator RNDr. Radmila Sousedíková, Ph.D.

Subject syllabus

1) Word, principles of text document writing, advanced methods (working with sections and styles)
2) Word, working with tables, graphical modification, figure inserting and modification, equations writing
3) Word, advanced methods (captions of tables and figures, footnotes, cross-reference captions, creating a table of content and figures)
4) Word, mail merge, use of database record
5) Instructions for Bachelor's thesis writing, bibliographic citation
6) Excel, advanced methods, spread sheet use in economic practice (graph creation and modification , trend analysis
7) Excel, working with databases (creating tables, filters, creating subtotals and totals)
8) Financial analysis with Excel
9) Investment project efficiency with Excel
10) Debt amortization with Excel
11) Smoothing of stock prices time series with excel
12) Presentation with PowerPoint
13) Web page creating

E-learning

The learning management system Moodle (lms.vsb.cz) is used for communication beyond full-time teaching, through which communication is enabled not only between the teacher and students, but also between students themselves.

Literature

BUCKI, Lisa et al. Learning Microsoft Office 2010. Upper Saddle River, N.J.: Pearson/Prentice Hall, 2011. ISBN 978-0135108383 

Advised literature

SHELLY Gary and Misty VERMAAT. Microsoft Office 2010: Introductory. Andover: Cengage Learning, 2010.ISBN 9781439078389 .