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

Gurantor departmentDepartment of Applied InformaticsCredits3
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantordoc. RNDr. Ivo Martiník, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation2020/2021
Intended for the facultiesEKFIntended for study typesMaster, Follow-up Master
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+3

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. Basic services, applications and protocols on the Internet. 2. Internet Web Browser as a basic accesspoint - sync extensions, setting rules. 3. Install applications and services in the online environment - security and management of online applications. 4. Google applications - rules when working with a text editor and creating forms. 5. Google applications - email, calendar, and information sharing within the team. 7. Google sites - a single place for the presentation and share content. 8. Working with data and formulas in online applications with a focus on Business Intelligence. 9. Creating new criteria and indicators formation. 10. Working with the rules and their application to the Indicators. 11. Graphical presentation of indicators and calculated elements. 12. Individual work on projects. 13. Individual work on projects. 14. Evaluation and assessment exercises.

Conditions for subject completion

Full-time form (validity from: 2013/2014 Winter semester, validity until: 2020/2021 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation Credit   3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2017/2018 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (N6208) Economics and Management (6208T037) Management P Czech Ostrava 1 Choice-compulsory study plan
2017/2018 (N6202) Economic Policy and Administration (6210T004) European Integration P Czech Ostrava 1 Choice-compulsory study plan
2017/2018 (N6202) Economic Policy and Administration (6202T010) Finance P Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (N6208) Economics and Management (6208T062) Marketing and Business P Czech Ostrava 1 Choice-compulsory study plan
2016/2017 (N6202) Economic Policy and Administration (6202T010) Finance P Czech Ostrava 2 Choice-compulsory study plan
2016/2017 (N6202) Economic Policy and Administration (6210T004) European Integration P Czech Ostrava Choice-compulsory study plan
2016/2017 (N6208) Economics and Management (6208T037) Management P Czech Ostrava 1 Choice-compulsory study plan
2016/2017 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (N6208) Economics and Management (6208T037) Management P Czech Ostrava 1 Choice-compulsory study plan
2015/2016 (N6202) Economic Policy and Administration (6210T004) European Integration P Czech Ostrava Choice-compulsory study plan
2015/2016 (N6202) Economic Policy and Administration (6202T010) Finance P Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (N6208) Economics and Management (6208T037) Management P Czech Ostrava 1 Choice-compulsory study plan
2014/2015 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (N6202) Economic Policy and Administration (6202T010) Finance P Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (N6202) Economic Policy and Administration (6210T004) European Integration P Czech Ostrava Choice-compulsory study plan
2013/2014 (N6208) Economics and Management (6208T037) Management P Czech Ostrava 1 Choice-compulsory study plan
2013/2014 (N6208) Economics and Management (6208T037) Management (00) Management P Czech Ostrava 1 Choice-compulsory study plan
2013/2014 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2013/2014 (N6202) Economic Policy and Administration (6202T010) Finance P Czech Ostrava 2 Choice-compulsory study plan
2013/2014 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2012/2013 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2012/2013 (N6208) Economics and Management (6208T037) Management (00) Management P Czech Ostrava 1 Choice-compulsory study plan
2012/2013 (N6202) Economic Policy and Administration (6202T040) Regional Development (00) Regional Development P Czech Ostrava Choice-compulsory study plan
2012/2013 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2011/2012 (N6208) Economics and Management (6208T037) Management (00) Management P Czech Ostrava 1 Choice-compulsory study plan
2011/2012 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2011/2012 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2010/2011 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2010/2011 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (N6208) Economics and Management (6208T011) Economics and Law in Business P Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (M6208) Business and Management (6208T011) Economics and Law in Business P Czech Ostrava 5 Choice-compulsory study plan
2006/2007 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan
2005/2006 (N6202) Economic Policy and Administration (6202T010) Finance (00) Finance P Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
Subject block without study plan - EKF - P - cs 2018/2019 Full-time Czech Optional EKF - Faculty of Economics stu. block

Assessment of instruction



2017/2018 Winter
2016/2017 Winter
2015/2016 Winter
2014/2015 Winter
2012/2013 Winter
2009/2010 Winter