Lecturer(s)
|
-
Dvořáčková Olga, Mgr. Ph.D.
-
Tržil Milan, Ing.
|
Course content
|
1 seminar 2 hours - range 1. Modification of bachelor / master thesis - basic rules, format, structure of work (page format, format of paragraphs and headings). 2. Modification of bachelor / master thesis - definition of styles, links, content generation. 3. Citation standards and their use in scientific work. 4. Creating an online electronic data collection questionnaire. 5. MS Excel - creating and editing tables, styles, format. 6. MS Excel - definition of formulas. 7. MS Excel - function definition. 8. MS Excel - creating and editing graphs, styles, format. 9. MS Excel - working with data, filtering and sorting data, importing and exporting user data. 10. Descriptive statistics. Graphical presentation of data. 11. Chi square test. Pivot tables. 12. t tests, ANOVA. Nonparametric tests. 13. Correlation and regression. 14. Repetition
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming)
|
Learning outcomes
|
After having successfully completed the subject the student should be able to use information and communication technologies both in his/her future studies and career.
|
Prerequisites
|
Conditioning subjects: none
|
Assessment methods and criteria
|
Student performance assessment, Test
Requirement for grantinng the colloquium: 90% participation in tutorials, evaluation of active work at seminars, completion of an individual task; test
|
Recommended literature
|
-
Disman, M. Jak se vyrábí sociologická znalost. Praha: Karolinum, 2002. ISBN 978-80-246-0139-7.
-
Lasák. Jak na Exel (http://office.lasakovi.com/.
-
Navarrů, M. Excel 2016. Podrobný průvodce uživatele. Praha: Grada, 2016. ISBN 978-80-271-0193-1.
|