ULGATL0022 Informatics II

Faculty of Philosophy and Science in Opava
Summer 2015
Extent and Intensity
1/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Petr Janík (lecturer)
Ing. Petr Musil (lecturer)
Ing. Marek Štencel (lecturer)
Ing. Petr Janík (seminar tutor)
Ing. Petr Musil (seminar tutor)
Ing. Marek Štencel (seminar tutor)
Guaranteed by
doc. RNDr. František Koliba, CSc.
Centrum interdisciplinárních studií – Faculty of Philosophy and Science in Opava
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to teach the students to work efficiently and be well informed of spreadsheet application available at the faculty. The students will get practical experience of solving economic tasks with emphasis on studied field, basic knowledge of relational databases, and large-scale data processing. At the same time the students will learn to create a simple database application using the software implemented at the faculty.
Syllabus
  • 1. Spreadsheet application (MS EXCEL)
    2. Solving economic tasks aimed at studied field in spreadsheet application MS EXCEL
    3. Theoretical definition of the database concept, philosophy of work in databases
    4. Database programme (MS ACCESS
Literature
    recommended literature
  • PÍSEK, S. Access 2010 podrobný průvodce začínajícího uživatele. ISBN 978-80-247-3653-2. info
  • PECINOVSKÝ, J. Excel v příkladech - řešené úlohy. Praha: Grada. info
  • BŘÍZA, V. Excel 2007. Praha: Grada. ISBN 978-80-247-1964-1. info
  • PECINOVSKÝ, J. Excel 2010 podrobný průvodce. ISBN 978-80-247-3496-5. info
  • PECINOVSKÝ, J. OpenOffice.org 2.0. Praha: Grada Publishing, 2006. ISBN 80-247-1016-1. info
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
* test (computer) in the extent of lectures and seminars
The course is also listed under the following terms Summer 2009, Summer 2010, Summer 2011, Summer 2012, Summer 2013, Summer 2014, Summer 2016, Summer 2017.
  • Enrolment Statistics (Summer 2015, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2015/ULGATL0022