|
Lecturer(s)
|
-
Čmielová Darina, Mgr. Ph.D.
-
Žejdl Vít, PhDr. Ph.D.
-
Řezníček Ondřej, PhDr. Ph.D.
-
Dolejš Tomáš, Mgr. Ph.D.
-
Krahula Petr, Ing.
|
|
Course content
|
- File formats of spreadsheet data, import and export of spreadsheet data. - Forms and their creation with a direct link to spreadsheets and calculators. - Options and ways of displaying, formatting, and conditional formatting of spreadsheet data. - Sort, filter and summaries of table data. - Addressing, counting operations, formulas, mathematical functions, generating values. - Functions for text value operations in tables. - Search function of table data. - Graphic presentations, type of graphs and charts, and policies for their use. - Pivot tables and pivot charts. - Principles of using spreadsheets and calculators modules and add-ons. - Table data analysis, analysis tools of spreadsheet. - Statistical processing of spreadsheet data. - Principles of use and creation of macros, programmable modules of spreadsheet and calculators.
|
|
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 |
| 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 |
| Seminar classes |
| Individual study |
| Skills demonstration |
| E-learning |
| Lecture with visual aids |
| Competences |
|---|
| Lecture with visual aids |
| Skills demonstration |
| E-learning |
| Individual study |
| 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 |
| Test |
| Continuous assessment |
|
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.
-
Cuesta, Hector. Analýza dat v praxi. 1. vydání. 2015. ISBN 978-80-251-4361-2.
-
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. První vydání. 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.
|