Sep 15, 2019   8:25 a.m. Jolana, deň pracovného voľna - Sedembolestná Panna Mária
Academic information system

Course syllabus N422T0_4B - Spreadsheet and Database Systems for Data Processing (FCFT - SS 2015/2016)

     Information sheet          ECTS          Syllabus          

     Slovak          English          

University: Slovak University of Technology in Bratislava
Faculty: Faculty of Chemical and Food Technology
Course unit code: N422T0_4B
Course unit title: Spreadsheet and Database Systems for Data Processing
Mode of delivery, planned learning activities and teaching methods:
laboratory/construction practice2 hours weekly (on-site method)

Credits allocated: 2
Recommended semester/trimester: Biotechnology - bachelor (optional), 2. semester
Chemical Engineering - bachelor (optional), 2. semester
Chemistry, Medical Chemistry and Chemical Materials - bachelor (optional), 2. semester
Level of study: 1.
Prerequisites for registration: none
Assesment methods:
Students will write 2 quizzes during the semester. The sum of points for the quizzes is 100. Students will successfully pass the quizzes if they earn at least 56 points. Students are graded as follows: A 92–100 points, B 83–91 points, C 74–82 points, D 65–73 points, E 56–64 points.
Learning outcomes of the course unit:
Students know fundamentals of creating and using of 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 have knowledge of treatment of numerical, text, and other data in tables of MS Excel. They are able to design and use Pivot Tables and Pivot Charts.
Course contents:
Introduction to relational databases
MS Access and MySQL
Database design
Database normalization (1NF, 2NF, 3NF, ...)
Table creation (fields, data types, indexes, field properties, update)
Forms and their elements
Basics of SQL
Simple practical application using database
Data processing in a spreadsheet editor (MS Excel)
Data processing function
Pivot tables and pivot charts
Recommended or required reading:
KOFLER, M. Mistrovství v MySQL 5. Brno : Computer Press, 2007. 805 p. ISBN 978-80-251-1502-2.
MASLAKOWSKI, M. Naučte se MySQL za 21 dní. Praha : Computer Press, 2001. 478 p. ISBN 80-7226-448-6.
LIENGME, B V. A guide to microsoft Excel for scientists and engineers. London : Arnold, 1997. 207 p. ISBN 0-340-69265-0.
LEVIE, R D. Advanced Excel for Scientific Data Analysis. Oxford : Oxford University Press, 2004. 615 p. ISBN 0-19-515275-1.
STINSON, C. -- DODGE, M. Mistrovství v Microsoft Office Excel 2007. Brno : Computer Press, 2008. 936 p. ISBN 978-80-251-1980-8.
ŠEDOVÁ, H. Access 2007 nejen pro školy. ČR: Computer Media, 2010. 192 p. ISBN 978-80-7402-038-4.
CHURCHER, C. Beginning Database Design: From Novice to Professional. New York: Apress, 2012. 252 p. ISBN 978-1-4302-4209-3.
MACDONALD, M. Access 2007: The Missing Manual. 1005 Gravenstein Higway North, Sebastopol, CA 95472: O'Reilly Media, 2006. 752 p. ISBN 978-0-596-52760-0.

Language of instruction: slovak or english
Courses evaluation:
Assessed students in total: 50

74,0 %26,0 %0 %0 %0 %0 %
Name of lecturer(s): Ing. Ľuboš Čirka, PhD. (examiner, instructor, lecturer, person responsible for course) - slovak, english
Ing. Juraj Števek, PhD. (examiner, instructor, lecturer) - slovak, english
Last modification: 15. 12. 2015
Supervisor: Ing. Ľuboš Čirka, PhD. and programme supervisor

Last modification made by Ing. Tomáš Molnár on 12/15/2015.

Type of output: