545-0291/07 – Information Technology Application in Economic Practice I. (AVT I)
| Gurantor department | Department of Economics and Control Systems | Credits | 6 |
| 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 | winter |
| | Study language | Czech |
| Year of introduction | 2019/2020 | Year of cancellation | 2022/2023 |
| 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 outputs of research, simple economic analysis with spread sheet and and results presentation with PowerPoint.
Teaching methods
Lectures
Tutorials
Summary
The subject concerns modern working processes in Microsoft Office and their application to written outputs of research, presentation and economic analysis 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. The course is completed by a written exam.
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.
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 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
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction