|
Lecturer(s)
|
-
Filipi Zbyněk, PhDr. Ph.D.
-
Benediktová Lenka, Mgr. Ph.D.
|
|
Course content
|
Document template and styles in connection with the use of mail merge options for biologists. Non-text and automatic elements in text documents for biologists (diagrams, pictures, links, etc.). Collaboration of multiple biologists in creating a text document. Completion of a pre-printed text document for biologists (typographic principles, spelling, etc.). Table data analysis, addressing, counting operations, formulas, functions for biologists. Search operations and work with text values in tables for biologists. Options and ways to view, format and conditionally format tabular data, Sort, filter, and table data summaries for biologists. Representation of table data and graphs for biologists. Forms and their work with a direct link to the use of spreadsheets and calculators for biologists. Using templates in presentations for biologists. Work with internal and external objects in presentations for biologists. Presentation and interactive whiteboard.
|
|
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. |
| 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. |
| 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. |
| 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 |
| E-learning |
| Individual study |
| Seminar classes |
| Lecture with visual aids |
| Skills demonstration |
| Competences |
|---|
| Individual study |
| Skills demonstration |
| E-learning |
| Lecture with visual aids |
| Interactive lecture |
| Seminar classes |
| assessment methods |
|---|
| Knowledge |
|---|
| Test |
| Skills demonstration during practicum |
| Continuous assessment |
| Skills |
|---|
| Continuous assessment |
| Skills demonstration during practicum |
| Test |
| Competences |
|---|
| Skills demonstration during practicum |
| Continuous assessment |
| Test |
|
Recommended literature
|
-
Calc Guide: Working with Spreadsheets.
-
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.
-
Holzner, S. a N. Holzner. Google Docs 4 everyone. Indianapolis, 2009. ISBN 07-897-3936-4.
-
LAURENČÍK, Marek. Excel - pokročilé nástroje: funkce, marka, databáze, kontingenční tabulky, prezentace, příklady. Praha, 2016. ISBN 978-80-247-5570-0.
-
Navrátil, P. a M. Jiříček. OpenOffice.org Calc. Kralice na Hané: Computer Media, 2007. ISBN 978-80-86686-74-5.
-
OČENÁŠEK, Vladimír et al. Řešené příklady pro MS Excel 2013: podle konceptu European Computer Driving Licence - Advanced (profesionální uživatelské znalosti a dovednosti). Praha, 2015. ISBN 978-80-87994-55-9.
-
Pecinovský, J. 333 tipů a triků pro Microsoft Excel 2013: [sbírka nejužitečnějších postupů a řešení]. Brno: Computer pess, 2014. ISBN 978-80-251-4130-4.
-
Pírková, Kateřina. Microsoft Office Word 2007 : podrobná uživatelská příručka. Vyd. 1. Brno : Computer Press, 2007. ISBN 978-80-251-1571-8.
|