545-0340/06 – Informatics in Economics (IE)

Gurantor departmentDepartment of Economics and Control SystemsCredits5
Subject guarantorIng. Igor Černý, Ph.D.Subject version guarantorIng. Igor Černý, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2013/2014Year of cancellation
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
CER25 Ing. Igor Černý, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 6+6

Subject aims expressed by acquired skills and competences

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

Teaching methods

Lectures
Individual consultations
Tutorials

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.

Compulsory literature:

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 literature:

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.

Way of continuous check of knowledge in the course of semester

Regular feedback on the progress of knowledge during the current term is provided by presentation of semester project, knowledge checks and written exam.

E-learning

Pro komunikaci nad rámec prezenčně realizovaných soustředění je používán learning management systém Moodle (lms.vsb.cz), prostřednictvím kterého je umožněna komunikace nejen mezi vyučujícími a studenty, ale také mezi studenty navzájem.

Další požadavky na studenta

There are no additional requirements for students.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

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

Conditions for subject completion

Full-time form (validity from: 2014/2015 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33  17
        Examination Examination 67  34
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2014/2015 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33  17
        Examination Examination 67  34
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan
2019/2020 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 1 Compulsory study plan
2019/2020 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 1 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan
2014/2015 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 1 Compulsory study plan
2014/2015 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner