|
Lecturer(s)
|
-
Greiner Karel, doc. Ing. Ph.D.
-
Drvota Zdeněk, Ing.
-
Brebera David, Mgr.
|
|
Course content
|
Introduction to the Word text editor. Styles and templates, page setup, document sections. Tables, using fields, equation editor. Working with graphics. Working with a large document. More text editor options. Introduction to the Excel spreadsheet, working with formulas. Working with workbook, circular reference, Validating cell entries. Charts and graphics. Working with data lists. PivotTable and PivotChart reports. Analytical tools. More spreadsheet options.
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Demonstration, Projection, Skills training
- Participation in classes
- 20 hours per semester
- Home preparation for classes
- 26 hours per semester
- Term paper
- 74 hours per semester
- Preparation for a credit (assessment)
- 74 hours per semester
|
|
Learning outcomes
|
To familiarise students with the creating documents with Microsoft Word text editor, and using of Microsoft Excel spreadsheet.
After finishing this course student knows most of features of text editor Microsoft Word and spreadsheet Microsoft Excel in addition to working with forms and programming in Visual Basic language.
|
|
Prerequisites
|
Basic knowledge of Microsoft Windows is assumed.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation
For the course and conditions for granting credit, see the document available from the information system STAG.
|
|
Recommended literature
|
-
Barilla, Jiří. Microsoft Excel 2016 . Brno: Computer Press, 2016. ISBN 978-80-251-4838-9.
-
Greiner, K. Textové editory a tabulkové procesory - přednášky a cvičení.
-
Pecinovský, Josef. Microsoft Word 2013 . Brno: Computer Press, 2013. ISBN 978-80-251-3831-1.
-
Pecinovský, Josef. Office 2019 . Praha: Grada Publishing, 2019. ISBN 978-80-247-2303-7.
|