Lecturer(s)
|
-
Pavlík Pavel, PhDr. Ph.D.
-
Dvořáčková Olga, Mgr. Ph.D.
|
Course content
|
Seminars 1. Modification of bachelor / master thesis - basic rules, format, structure of work (page format, format of paragraphs and headings). (2 hours) 2. Modification of bachelor / master thesis - definition of styles, links, content generation. (2 hours) 3. Citation standards and their use in scientific work. (2 hours) 4. Creating an online electronic data collection questionnaire. (2 hours) 5. MS Excel - creating and editing tables, styles, format. (2 hours) 6. MS Excel - definition of formulas. (2 hours) 7. MS Excel - function definition. (2 hours) 8. MS Excel - creating and editing graphs, styles, format. (2 hours) 9. MS Excel - working with data, filtering and sorting data, importing and exporting user data. (2 hours) 10. Descriptive statistics. Graphical presentation of data. (2 hours) 11. Chi square test. Pivot tables. (2 hours) 12. t tests, ANOVA. Nonparametric tests. (2 hours) 13. Correlation and regression. (2 hours) 14. Repetition. (2 hours)
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming)
|
Learning outcomes
|
After completing this course, students should be able to use modern information and communication technology in their future field and be able to process and analyze statistical data in practice.
|
Prerequisites
|
Conditioning subjects: 0
|
Assessment methods and criteria
|
Student performance assessment, Test
Requirements for granting the colloquium: 90% attendance at seminars, teaching activity, test
|
Recommended literature
|
-
Havránek, J., Vurm, V., Záškodný, P., Žižková, R. Základy zdravotnické statistiky.
-
Hendl, Jan. Přehled statistických metod : analýza a metaanalýza dat. Třetí, přepracované vydání. Praha : Portál, 2009. ISBN 978-80-7367-482-3.
-
Lasák, P. Jak na Excel.
-
Navarrů, M. Excel 2016. Podrobný průvodce uživatele. Praha: Grada, 2016. ISBN 978-80-271-0193-1.
-
Stránský, M., Dvořáčková, O., Kajanová, A.. Metodologie výzkumu v oblasti sociálních věd.
|