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

Gurantor departmentDepartment of Applied InformaticsCredits3
Subject guarantordoc. RNDr. Ivo Martiník, Ph.D.Subject version guarantordoc. RNDr. Ivo Martiník, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation
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. At the same time, student should master the basics of managing a team of collaborators and sharing data in a team using OneDrive, Forms, Teams, Yammer, etc.

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. At the same time, student should master the basics of managing a team of collaborators and sharing data in a team using OneDrive, Forms, Teams, Yammer, etc.

Compulsory literature:

WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889. 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.

Recommended literature:

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. ALEXANDER, Michael, Dick KUSLEIKA a John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, [2019]. ISBN 9781119514787.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

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)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation Credit  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.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