Skip to main content
Skip header
Close

Searching

Information Technology Application II

Type of study Bachelor
Language of instruction Czech
Code 545-0157/01
Abbreviation AVTII
Course title Information Technology Application II
Credits 3
Coordinating department Department of Economics and Control Systems
Course coordinator RNDr. Radmila Sousedíková, Ph.D.

Subject syllabus

1. Word, principles of creating text documents, advanced techniques (working with sections, use of styles)
2. Word, working with tables, graphic editing, inserting and editing images, writing formulas in text
3. Word, advanced techniques (titles of tables and figures, footnotes, cross-references, generation of content, list of tables and figures)
4. Word, editing of documents processed by word processors - standard ČSN 01 6910 (2014)
5. Instructions for Bachelor's thesis writing – work organization, structure and range of thesis
6. Instructions for Bachelor's thesis writing – formal requirements
7. Excel, graph creation and modification – application to technical and production indicators of mining company
8. Excel, trend analysis of technical and production indicators of mining company
9. Excel, mining company financial analysis – horizontal and vertical analysis
10. Excel, mining company financial analysis – financial ratio calculation
11. Excel, investment project efficiency in mining company
12. Excel, financial investment in mining company
13. Excel, smoothing of time series of mining company stock prices

E-learning

The Moodle Learning Management System (lms.vsb.cz) is used for external communication of the teacher with students outside the class-room, as well as for communication among the students themselves.

Literature

MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0.
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-0 .
LAMBERT, Joan. Microsoft Office 2019 Step by Step. Microsoft Press U.S., 2018. ISBN 9781509307685 .
LAMBERT, Joan. Microsoft Word 2019 Step by Step. Microsoft Press U.S., 2019. ISBN 978150930587.

Advised literature

WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9 .
LAMBERT, Joan. Microsoft Word 2016 Step by Step. Microsoft Press, 2015. ISBN 9780735699236 .
MELTON, Beth et al. Microsoft Office Professional 2013: Step by Step. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669413 .
MURRAY, Katherine. Microsoft Office Professional 2013. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669321 .


back to search page