545-0144/01 – Computer practical (PP)
| Gurantor department | Department of Economics and Control Systems | Credits | 2 |
| Subject guarantor | Ing. Věroslav Holuša, Ph.D. | Subject version guarantor | Ing. Jiří Švub, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | winter |
| | 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
The course is focused on introducing students to the basics of working with Microsoft Office programs, which are essential for completing fundamental tasks in economic and technical practice. Students will learn the basics of working with MS Word, MS Excel, and MS PowerPoint, and will acquire skills in creating formatted texts, tables, and simple presentations.
Teaching methods
Individual consultations
Tutorials
Project work
Summary
The course provides an introduction to the use of MS Office programs. Students will learn how to navigate the user interface of individual programs, basic text formatting procedures, working with tables, creating simple graphs and presentations. The course emphasizes practical application in processing study materials and basic economic tasks. The course is the basis for a deeper understanding of individual programs.
Compulsory literature:
Recommended literature:
Additional study materials
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 the tests.
E-learning
For communication beyond the framework of in-person training camps, the Moodle learning management system (lms.vsb.cz) is used, through which communication is enabled not only between the teacher and students, but also between students.
Other requirements
Make out semester project in range 8 - 10 pages A4.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Preparation of a document in Word - document structure (size, margins, headers, footers, sections, paragraphs, fonts, styles, windows, navigation), edit of text, spelling, grammar, the mail merge.
2. Operation with tables (creation, automatic subtitling, calculations), citations, cross-references, indexes, footnotes, the equation editor.
3. Revision of the document-tracking changes, acceptance/rejection of the changes, comments, translations.
4. Preparation of the document in Excel - document structure (size, orientation, margins, header, footer), font, formatting, conditional formatting, windows.
5. Operations with the data in Excel - sorting, grouping, filtering, separation, summary, search.
6. Operations with tables and graphs, the equation editor.
7. Matrix calculations in Excel.
8. Operations with functions in Excel - financial functions.
9. Operations with functions in Excel - mathematical functions for economists.
10.Operations with functions in Excel - statistical functions (descriptive statistics, distribution function, probability density function).
11.Operations with functions in Excel – the search functions, the information functions and the text functions.
12.Operations with functions in Excel - database functions.
13.Operations with functions in Excel - logical functions.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction