|
Lecturer(s)
|
-
Steinberger Libor, Mgr.
-
Čmielová Darina, Mgr. Ph.D.
-
Ženková Alžběta, Mgr.
|
|
Course content
|
Course outline: 1. Basic typographic rules in text documents 2. Document template and styles. 3. Non-text elements in text documents (graphs, diagrams, pictures, etc.). 4. Automatic elements in text documents (citations, footnotes, index, headers and footers, links in the document, table of contents and subtitles). 5. Collaboration of multiple authors in the creation of a text document and work in the cloud. 6. Finalization of the text document before printing. 7. Forms and their creation with direct connection to spreadsheets and calculators. 8. File formats of tabular data, import and export of tabular data. Options and methods of displaying, formatting and conditional formatting of tabular data. 9. Sorting, filtering and summaries of tabular data. Addressing, numerical operations, formulas, mathematical functions, value generation. 10. Functions for operations with text values in tables. Functions for searching table data. 11. Working with date and time. 12. Graphical (re)presentation of tabular data, types of graphs and principles for their use. 13. Pivot tables and pivot charts.
|
|
Learning activities and teaching methods
|
- Preparation for formative assessments (2-20)
- 20 hours per semester
- Preparation for comprehensive test (10-40)
- 30 hours per semester
- unspecified
- 30 hours per semester
- Contact hours
- 52 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| basic work in a text editor, including simple editing. |
| basic work in a spreadsheet calculator, including simple table formatting. |
| Skills |
|---|
| process and edit text using basic text editor tools. |
| work with files and perform basic operations with them (creating, copying, renaming, etc.). |
| process simple calculations in a spreadsheet calculator. |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| The student understands the functionality and use of a text editor and spreadsheet calculator. Based on the processed data, it can decide which of the applications to use. |
| learning outcomes |
|---|
| Knowledge |
|---|
| processing and appropriate formatting of text in a text editor. |
| work with text elements in a text document and use automation. |
| commonly used typographic principles. He knows where or find the necessary information. |
| principles used in acquiring, viewing, organizing, formatting, analyzing, representing and storing tabular data in one commercial and several freely available software tools. |
| principles used in acquiring, viewing, organizing, formatting, analyzing, representing and storing tabular data in one commercial and several freely available software tools. |
| Skills |
|---|
| process data effectively using software tools known as spreadsheets to verify the principles of tabular data processing using practical. |
| to verify the principles of tabular data processing using practical examples, thanks to which they will master work procedures leading to the effective use of the mentioned type of software within the study of a teaching field or a combination of fields and subsequently in teaching practice. |
| use the supported modules and functions of the selected program for tabular data processing to find the optimal solution to partial problems arising from the discussed topic. |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| The student can process a text document, including the necessary formatting, including compliance with stylistic and typographic principles.Furthermore, it can process the presented data in a spreadsheet, using functions and formulas effectively. |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture with visual aids |
| E-learning |
| Self-study of literature |
| Task-based study method |
| Discussion |
| Skills |
|---|
| Lecture with visual aids |
| Discussion |
| Self-study of literature |
| E-learning |
| Practicum |
| Competences |
|---|
| Lecture with visual aids |
| Practicum |
| Skills demonstration |
| E-learning |
| assessment methods |
|---|
| Knowledge |
|---|
| Skills demonstration during practicum |
| Continuous assessment |
| Test |
| Skills |
|---|
| Skills demonstration during practicum |
| Continuous assessment |
| Test |
| Competences |
|---|
| Skills demonstration during practicum |
| Continuous assessment |
| Test |
|
Recommended literature
|
-
Bártek, Květoslav; Kubrický, Jan. Pokročilé použití MS Excel při tvorbě elektronických výukových materiálů. 1. vydání. 2015. ISBN 978-80-244-4559-5.
-
Klatovský, K. Excel 2021 / 365 nejen pro školy. Computer Media. 2023.
-
Klatovský, K. Word 2021 / 365 nejen pro školy. Computer Media. 2023.
-
Knytl, Martin, Křivánková, Lucie. Typografie a odborný text, Průvodce pro zpracování nejen závěrečných prací. Hradec Králové, 2022.
-
Široký, Jan. Psaní a prezentace odborných textů. Vydání první. 2019. ISBN 978-80-7502-340-7.
|