Skip to main content
Skip header
Close

Searching

Computer practical

Type of study Bachelor
Language of instruction Czech
Code 545-0144/01
Abbreviation PP
Course title Computer practical
Credits 2
Coordinating department Department of Economics and Control Systems
Course coordinator Ing. Jiří Švub, Ph.D.

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.

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.

Literature

LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021.ISBN 9780137564354 .
LAMBERT, Joan. Microsoft Word Step by Step (Office 2021 and Microsoft 365). Pearson Education, 2023.ISBN 978-0-13-752272-9 .
LAMBERT, Joan. Microsoft PowerPoint 2016 Step by Step. Microsoft press, 2015. ISBN 978-0735697799 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2023. ISBN 978-0-7897-5958-0 .

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 .
IBARRA, Luis Fernando. Simulation and statistics with Excel: an introduction to business students. Boca Raton: CRC Press, Taylor & Francis Group, 2024. ISBN 978-1-032-69876-2.
MUIR, Nancy. Microsoft PowerPoint 2013 Plain & Simple. Microsoft Press, 2013.ISBN 978-0735669369 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-0 .


back to search page