Course: Office Applications - Office

« Back
Course title Office Applications - Office
Course code KID/PKOFP
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Míča Ondřej, Ing.
  • Greiner Karel, doc. Ing. Ph.D.
  • Drvota Zdeněk, Ing.
  • Panuška Ivan, Mgr.
  • Rejsek Ondřej, Ing.
Course content
Using editor Word. Basic typography and formatting documents. Styles and templates. Margins and page setup, sections. Tables. Using fields. Working with graphics and charts. Cross-references, captions, and bookmarks. Tables of contents, index, and tables of figures. Equation editor. Mail merge. Sharing information with other people. Using forms, form fields, document protection. Using spreadsheet Excel. Cells, formulas, functions. Working with workbook and worksheet. Circular reference. Validating cell entries. Charts and graphics. Using lists, filtering and sorting data. PivotTable and PivotChart reports. Analyzing data. Solver, what-if analysis, scenarios, statistical analysis tools. Forms, workbook and worksheet protection, data sharing. Macros.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration, Projection, Skills training
Learning outcomes
The main goal of the discipline is to familiarise students with the advanced methods of creating documents with text editor MS Word, and working and analyzing data with spreadsheet MS Excel.
After finishing this course student knows most of features of text editor Microsoft Word and spreadsheet Microsoft Excel in addition to programming in Visual Basic language.
Prerequisites
Basic knowledge of Microsoft Windows, Word and Excel is assumed.

Assessment methods and criteria
Written examination

Process of the exam and other information see document available from the information system STAG.
Recommended literature
  • BARILLA, Jiří, Pavel SIMR a Květuše SÝKOROVÁ. Microsoft Excel 2016. Podrobná uživatelská příručka. Brno, 2016. ISBN 978-80-251-4838-9.
  • Greiner, K. Textové editory a tabulkové procesory - přednášky a cvičení.
  • Pecinovský, J. Word 2013. Podrobná uživatelská příručka. Brno, 2013. ISBN 978-80-251-3831-1.


Study plans that include the course