ULGATLA022 Informatics II

Faculty of Philosophy and Science in Opava
Summer 2020
Extent and Intensity
1/2/0. 2 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Petr Janík (lecturer)
Ing. Petr Janík (seminar tutor)
Guaranteed by
Ing. Petr Janík
Centrum interdisciplinárních studií – Faculty of Philosophy and Science in Opava
Timetable
each even Thursday 9:45–11:20 H4
  • Timetable of Seminar Groups:
ULGATLA022/A: Tue 16:25–18:00 H4, P. Janík
ULGATLA022/B: Tue 18:05–19:40 H4, P. Janík
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
  • LAURENČÍK, Marek. Excel 2013 : práce s databázemi a kontingenčními tabulkami. Praha, 2014. ISBN 978-80-247-5003-3. info
  • PÍSEK, Slavoj. Access 2013 : podrobný průvodce. Praha, 2013. ISBN 978-80-247-4746-0. info
  • PECINOVSKÝ, Josef. Excel 2013: podrobný průvodce. Praha, 2013. ISBN 978-80-247-4729-3. info
  • BARILLA, Jiří. Microsoft Excel 2013: podrobná uživatelská příručka. Brno, 2013. ISBN 978-80-251-4114-4. info
  • ŠIMEK, Tomáš. Office 2013: podrobný průvodce. Praha, 2013. ISBN 978-80-247-4731-6. info
  • PECINOVSKÝ, Josef. Excel a Access 2010: efektivní zpracování dat na počítači. Praha, 2011. ISBN 978-80-247-3898-7. info
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
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 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2021, Summer 2022, Summer 2023, Summer 2024.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2020/ULGATLA022