Course unit code:
A422T1_4B
Course unit title:
Spreadsheet and Database Systems for Data Processing
Mode of completion and Number of ECTS credits:
Class req (2 credits)
Course supervisor:
Ing. Ľuboš Čirka, PhD.
Learning outcomes of the course unit:
Students know the fundamentals of creating and using databases in Microsoft Access. They are able to design and create basic database objects (tables, forms, queries, and reports). Students have learned basic SQL statements for creating queries. They have knowledge of the principles of database normalization. Students can treat numerical, text, and other data in tables of MS Excel. They are able to design and use Pivot Tables and Pivot Charts.
Prerequisites for registration:
none
Course contents:
Recommended or required reading:
Basic:
  • MASLAKOWSKI, M. Naučte se MySQL za 21 dní. Praha : Computer Press, 2001. 478 s. ISBN 80-7226-448-6.
  • CHURCHER, C. Beginning Database Design: From Novice to Professional. New York: Apress, 2012. 252 s. ISBN 978-1-4302-4209-3.
  • HERNANDEZ, M J. Návrh databází. Praha : Grada Publishing, 2006. 408 s. ISBN 80-247-0900-7.
  • LEVIE, R D. Advanced Excel for Scientific Data Analysis. Oxford : Oxford University Press, 2004. 615 s. ISBN 0-19-515275-1.
  • LIENGME, B V. A guide to microsoft Excel for scientists and engineers. London : Arnold, 1997. 207 s. ISBN 0-340-69265-0.
Recommended:
  • BELKO, P. Access 2013: Podrobná uživatelská příručka, Computer Press, 2015. 392 s. ISBN: 978-80-251-4125-0.
Planned learning activities and teaching methods:
Contact teaching: exercises – 26 h Contactless teaching: preparation for exercises – 24 h
Assesment methods and criteria:
The final grade consists of an evaluation of two assignments or tests, 50 points each. The final grade is given by the Study rules of the STU. To obtain credits for the subject, the student has to reach at least 56% of the maximum number of points.
Language of instruction:
Slovak, English
Facebook / Youtube

Facebook / Youtube

RSS