545-0157/01 – Information Technology Application II (AVTII)
Gurantor department | Department of Economics and Control Systems | Credits | 3 |
Subject guarantor | RNDr. Radmila Sousedíková, Ph.D. | Subject version guarantor | RNDr. Radmila Sousedíková, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 3 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2020/2021 | Year of cancellation | |
Intended for the faculties | HGF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Generating knowledge concerning modern working processes in Microsoft Office, application to written professional text, simple economic analysis with spread sheet in raw-materials industry.
Teaching methods
Lectures
Tutorials
Summary
The subject concerns modern working processes in Microsoft Office and their application to written professional text, presentation and economic analysis in raw-materials industry with spreadsheet.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Regular feedback on the progress of knowledge during the current term is provided by two semester projects and presentation. The course is completed by a written test.
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.
Other requirements
There are no additional requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.