Skip to main content
Skip header
Close

Searching

Computer practical

Type of study Bachelor
Language of instruction English
Code 545-0144/02
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

The Moodle Learning Management System (lms.vsb.cz) is used to communicate beyond the scope of attendance at the conference, through which communication is made not only between the teacher and students, but also between the 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