Business Informatics (in English)

Syllabus

Thematic definition of lectures: 1. Definition of the terms informatics, applied informatics, business informatics. Content of enterprise informatics, its functions, support of business processes. Definition of business informatics applications. Definition of personal informatics applications and their use in business practice. 2. Data, information, knowledge - definitions, properties. Entropy, degree of information. Information life cycle. Economic information. Providing the manager with information - types of information, sources of information. Big data. 3. Cybernetics. Systems theory - elements, links, environment, system goal. Classification of systems. System analysis and synthesis, guidance of processes in the system. Algorithm - properties, requirements, techniques for writing algorithms. 4. Information and communication technologies in the knowledge society - characteristics of ICT, classification, current developments in ICT, electronic data interchange. 5. Knowledge society - digital agenda for Europe, information society measurement indicator system, main objectives and benefits. Digital literacy, digital divide. Informatization in the Slovak Republic. ICT Development Index - country comparison. 6. Computer system, structure of computer system. General parameters characterizing the performance of computers. Intelligent devices with connectivity and their use in business practice. Supercomputers. 7. Basic layers of information and communication technologies in the enterprise - hardware layer, basic software layer, application software layer. Hardware layer - technical means, peripheral devices. Basic software layer - Software resources and their use. Classification of software - basic and means supporting personal informatics. Operating systems, database systems, means of communication, middleware, utilities. Office systems - word processors and spreadsheets, database systems for end users, graphics systems, communication systems. 8. Application software layer. Business information system. Importance of IS in enterprise management IS application architecture. Transaction systems. Decision support systems. Expert systems. Executive information systems. 9. Systems of ERP category - Enterprise Resource Planning - meaning, focus, support of internal and external processes. Modular structure and examples of systems according to the size of the enterprise. Development trends in the ERP application market. 10. Database processing - data base, database system, database models. Relational database systems. Designing a data base. OLTP and OLAP technologies. Data warehouses. 11. Communication and communication services - process and forms of communication. Basic types of computer networks. Transmission protocols. Online communication services. Internet and Intranet. Virtualization and cloud computing - forms and distribution models, cloud services. 12. Malware - malware categories, malware lifecycle phases, malware typology and malware protection phases. Protection in terms of enterprise hardware and software security and user activities. Anti-virus programs. 13. Security of information and communication technologies. Computer crime - object and subject. Legislative regulation in the field of ICT technical security, software and data protection and privacy. Thematic definition of exercises: 1. Definition of the use of software applications from the category of office systems with a focus on the use of MS Excel in business practice. Skills training focused on advanced orientation in the MS Excel environment, addressing cells in and using them in MS Excel calculations and functions, applying tools for creating series and sequences, working with multiple worksheets in the creation of calculation formulas. 2. Use of basic aggregation functions, rounding functions in solving problems, basic logic functions and their application in solving economic problems. 3. Use of category of logic functions, their combinations, nested functions. Basic principles of applying search functions. Application of functions in solving a set of related economic problems. 4. Use of logic functions in combination with functions working with constraints. Application of functions in solving a complex economic problem. Principles of creating and displaying data through graphs. 5. Use of text and date functions. Application of functions to the solution of sub-problems with an economic focus. 6. Principles of working with a simple database in the MS Excel environment by applying database filtering - automatic, custom, extended filter, use of functions in filtered tables, principles of using database functions. 7. Sequence of creation of pivot tables and contingency charts and their importance in business data analysis. Data aggregation. Use of functions and creation of new calculation fields in contingency tables. Filtering and other modifications of contingency tables and charts. 8. Characteristics of basic concepts used in financial functions. Principles of the use of financial functions and their application in solving economic problems with a focus on the calculation of principal, annuity, interest. 9. The use of financial functions to calculate the future value of a deposit at regular and varying payments, at constant interest rates, at a series of compound interest rates, to calculate the present value of a deposit. 10. Application of statistical functions. Functions of descriptive statistics, position indicators, variability, calculation of correlation coefficients. Scatter Plot. 11. Use of the Analytical Tool add-in - functions of descriptive statistics, skewness, skewness. T-test. Histogram. 12. One-factor Anova - sequence of steps, interpretation of results. Regression analysis in Excel - sequence of steps, interpretation of results. 13. Creating and editing complex documents in a text editor - creating and using custom styles, generating table of contents, lists of tables and charts, using other tools to automate repetitive activities, e.g. object descriptions, cross-references. Principles and use of mass correspondence. Integration of MS Office applications, imports and exports.