| Course Unit Code | 545-0340/06 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| CER25 | Ing. Igor Černý, Ph.D. |
| Summary |
|---|
Subject is concerned with applications in business informatics, with management, evaluation of effectiveness and safety of information systems and ICT. It presents fundamental terms and definitions used in informatics. From practical point of view subject is focused on use of numerical systems and creation of simple applications in database system of MS ACCESS.
|
| Learning Outcomes of the Course Unit |
|---|
Student shows knowledge:
of the importance of basic concepts and definitions of enterprise informatics,
of fundamentals of database systems and basic applications in the enterprise informatics,
of fundamentals of management, of effectiveness assessment and of safety of enterprise information systems
Student can:
describe the individual applications in the enterprise informatics
Student is able to:
transfer number systems and encode numbers
create a simple applications in MS ACCESS database system |
| Course Contents |
|---|
Outline of lectures
1) Basic terms and definitions of the informatics
2) Numeral systems, their conversions and coding
3) Basic components and classification of the computers
4) Classification of software
5) Database systems
6) SQL and its application of database management
7) Specification of enterprise informatics and its life cycle
8) Infrastructural enterprise applications
9) Enterprise resource planning
10) Applications of the external relationships management
11) Applications of the business intelligence in enterprise informatics
12) Management of the enterprise informatics
13) Effectiveness of the information systems
14) Safety of the information systems and of the communication technologies
Outline of exercises
1) Conception of the database structure in MS ACCESS
2) Design of the tables, data types and formats
3) Design of the relational database in MS ACCESS
4) Design of the concrete databases according to instructions
5) Retrieval, sorting and filter of the data
6) Conception of the queries
a. Selective queries
b. Selective queries with making calculations in the query
c. Action queries
i. Updating queries
ii. Deleting queries
iii. Creating queries
iv. Appending queries
d. Parametric queries
e. Cross queries
7) Design of the forms in MS ACCESS
8) Design of the reports in MS ACCESS
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| Vercellis, C. Business intelligence : data mining and optimization for decision making.1st ed. Great Britain, Chichester: Wiley, 2009.417p.ISBN 978-0-470-51138-1. |
Černý, I. Informatika v ekonomice-studijní opora. 2018.108 s. Dostupné z: https://lms.vsb.cz/pluginfile.php/783408/mod_resource/content/1/Informatika%20v%20ekonomice-studijn%C3%AD%20opora.pdf
Gál, L.; Pour, J.; Šedivá, Z. Podniková informatika. 2. přepracované a aktualizované vydání. Praha: Grada Publishing, a.s., 2009. 496 s.
Novotný, O. Řízení výkonnosti podnikové informatiky. Praha: Professional Publishing, 2010. 275 s.
Vercellis, C. Business intelligence : data mining and optimization for decision making.1st ed. Great Britain, Chichester: Wiley, 2009.417p.ISBN 978-0-470-51138-1.
|
| Recommended Reading: |
|---|
| Hillard, R. Information-driven business: how to manage data and information for maximum advantage.1st ed.USA,Hoboken: Wiley,2010.216 p.ISBN 978-0-470-62577-4. |
Dohnal, J. Řízení vztahů se zákazníky: procesy, pracovníci, technologie. Praha: Grada Publishing, a.s., 2002. 161 s.
Novotný, O.; Pour, J.; Slánský, D. Business Intelligence-Jak využít bohatství ve vašich datech.Praha: Grada Publishing, a.s., 2005. 254 s.
Sodomka, P.; Klčová, H. Informační systémy v podnikové praxi. Brno: Computer press, 2010. 501 s.
Učeň, P. Metriky v informatice: jak objektivně zjistit přínosy informačního systému. Praha: Grada Publishing, 2001. 139 s.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Individual consultations, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Exercises evaluation and Examination | Credit and Examination | 100 (100) | 51 |
| Exercises evaluation | Credit | 33 | 17 |
| Examination | Examination | 67 | 34 |