Spreadsheet and Database Systems for Data Processing
Mode of delivery, planned learning activities and teaching methods:
seminar – 2 hours weekly (on-site method)
Credits allocated:
2
Recommended semester:
Process Control – bachelor (full-time, attendance method), 4. semester Process Control (remedial) – bachelor (full-time, attendance method), 6. semester
Level of study:
1.
Prerequisites for registration:
none
Assesment methods:
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.
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.