Course: Informatics and Computational Technology and Statistical Data Processing

» List of faculties » FZS » ULZ
Course title Informatics and Computational Technology and Statistical Data Processing
Course code ULZ/UINVT
Organizational form of instruction Seminary
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
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.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester