155-0357/03 – Information Support for Managers (IPM)

Gurantor departmentDepartment of Applied InformaticsCredits5
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory type B
YearSemestersummer
Study languageCzech
Year of introduction2019/2020Year of cancellation2023/2024
Intended for the facultiesEKFIntended for study typesFollow-up Master, Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 1+2

Subject aims expressed by acquired skills and competences

The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.

Teaching methods

Tutorials

Summary

The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.

Compulsory literature:

FERRARI, Alberto a Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5. WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889.

Recommended literature:

ALEXANDER, Michael, Dick KUSLEIKA a John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, [2019]. ISBN 9781119514787. RUSSO, Marco a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond, Washington: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

There are not additional requirements for students.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. History of the Internet - milestones, famous persons. 2. How Internet / Intranet works - main services, applications, protocols, network topology - comparison and modern trends. 3. Cloud Computing I. - history, concepts, characteristics, service models. 4. Cloud Computing II. - architecture, deployment models, security and privacy. 5. Social intranet - techniques and systems in team work. 6. Visualizing Data and Information - Communicating Information Clearly and Efficiently. 7. Web design - main rules, typography, graphics, accessibility rules.

Conditions for subject completion

Full-time form (validity from: 2019/2020 Winter semester, validity until: 2023/2024 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 45  25
        Examination Examination 55  15 3
Mandatory attendence participation: Credit: - attendance at the seminars is not required, - processing of project according to the required structure and its defense, - test, - obtaining at least 23 points out of 45. Exam: - oral - questions from the given topics in LMS Moodle.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Credit: - attendance at the seminars is not required, - processing of project according to the required structure and its defense, - test, - obtaining at least 23 points out of 45. Exam: - oral - questions from the given topics in LMS Moodle.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2020/2021 (N0413A050014) Economics and Management (S03) Economics and Law in Business P Czech Ostrava Choice-compulsory type B study plan
2019/2020 (N0413A050014) Economics and Management (S03) Economics and Law in Business P Czech Ostrava Choice-compulsory type B study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2020/2021 Summer
2019/2020 Summer