|
Lecturer(s)
|
-
Benediktová Lenka, Mgr. Ph.D.
|
|
Course content
|
1. Document template and styles related to the use of mass mailing options for biologists. 2. Non-text and automatic elements in text documents for biologists (diagrams, images, links, etc.). 3. Collaboration of several biologists in the creation of a text document. 4. Work in the cloud. 5. Completion of a text document with a pre-press check for biologists (typographic principles, spelling, principles for editing documents). 6. Analysis of tabular data, addressing, numerical operations, formulas, functions for biologists. 7. Search operations and work with text values in tables for biologists, sorting, filtering and summaries of tabular data for biologists. 8. Representation of tabular data and graphs for biologists. 9. Forms, their creation and use for questionnaire surveys. 10. Use of templates in presentations for biologists. Work with internal and external objects in presentations for biologists. 11. Presentation skills and principles of good presentation. 12. Preparation of the poster. Preparation of professional and scientific text (bachelor's, diploma theses, professional text). 13. Information sources and work with them, citation standards.
|
|
Learning activities and teaching methods
|
Lecture with practical applications, E-learning, Skills demonstration, Seminar classes, Individual study, Lecture with visual aids
- Contact hours
- 26 hours per semester
- Practical training (number of hours)
- 26 hours per semester
- Preparation for formative assessments (2-20)
- 10 hours per semester
- Preparation for comprehensive test (10-40)
- 20 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| explain basic concepts related to the creation of tables on the computer. |
| The student knows the basic movement in the text editor. |
| Skills |
|---|
| create and manipulate folders and files. |
| perform basic editing a spreadsheet. |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| explain the principles used in acquiring, viewing, organizing, formatting, analysis, representation and storing tabular data in one of several commercial and freely available software tools. |
| know the principles of editing a text document and its formatting. |
| know the principles of effective presentation and its presentation (presentation skills). |
| Skills |
|---|
| to process the data efficiently using software tools known as spreadsheets. |
| check processing principles tabular data on practical examples, thanks to which you will learn workflows leading to effective use of this type of software in the study of the teaching field or a combination of sectoral and subsequently in teaching practice. |
| use supported modules and functions chosen spreadsheet program for data processing for finding optimal solutions to specific problems arising from the discussed topic. |
| format the document according to the specified requirements, including working with non-textual elements. |
| work with citation standards. |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture with visual aids |
| E-learning |
| Skills demonstration |
| Individual study |
| Interactive lecture |
| Seminar classes |
| Skills |
|---|
| Interactive lecture |
| Seminar classes |
| Individual study |
| Skills demonstration |
| E-learning |
| Lecture with visual aids |
| Competences |
|---|
| E-learning |
| Interactive lecture |
| Seminar classes |
| Lecture with visual aids |
| Individual study |
| Skills demonstration |
| assessment methods |
|---|
| Knowledge |
|---|
| Test |
| Skills demonstration during practicum |
| Continuous assessment |
| Skills |
|---|
| Test |
| Continuous assessment |
| Skills demonstration during practicum |
| Competences |
|---|
| Test |
| Skills demonstration during practicum |
| Continuous assessment |
|
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.
-
Klarovský Karel. Power Point nejen pro školy. Computer Media, 2016. ISBN 978-807402-251-7.
-
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.
|