Informatics

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Institute of Economic Studies

Synopsis:

Students have an advanced understanding of the Excel environment and the ability to complete tasks independently after competing this course. They know and demonstrate the correct application of the principal features of MS Excel. Students create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually as well as advanced formulas, such as data analysis and business intelligence, PivotTables, etc. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices and data-entry logs.

•Create and manage worksheets and workbooks (Create worksheets and workbooks, Navigate in worksheets and workbooks, Format worksheets and workbooks, Customise options and views for worksheets and workbooks, Configure worksheets and workbooks for distribution)

•Manage data cells and ranges (Insert data in cells and ranges, Format cells and ranges, Summarise and organise data)

•Create tables (Create and manage tables, Manage table styles and options, Filter and sort a table)

•Perform operations with formulas and functions (Summarise data by using functions, Perform conditional operations by using functions, Format and modify text by using functions)

•Create charts and objects (Create charts, Format graphic elements, Insert and format objects)

•Apply custom data formats and layouts (Apply custom data formats and validation, Apply advanced conditional formatting and filtering, Create and modify custom workbook elements, Prepare a workbook for internationalisation)

•Create advanced formulas (Apply functions in formulas, Look up data by using functions, Apply advanced date and time functions, Perform data analysis and business intelligence, Troubleshoot formulas, Define named ranges and objects)

•Create advanced charts and tables (Create advanced charts, Create and manage PivotTables, Create and manage PivotCharts)

Requirements:

13 continuous homework assignments from each exercise

1 test on the basis of assignments - solving practical tasks on a computer

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

In the digitized world of the 21st century, it should be a matter of course that the student is able to search, sort and critically evaluate information. He or she needs to be able to take advantage of the opportunities of the digital environment, which in the current environment can be included in the cross-cutting professional competencies needed for the performance of work, which are not exclusively related to a particular profession. The course of Informatics aims to equip students with a sufficient set of transferable digital competencies, with emphasis on the main principles of digital technologies, the use of effective applications of digital technologies to obtain relevant information needed in all areas of training future economists.

Study materials:

LAMBERT, Joan. MOS Study Guide for Microsoft Excel Exam MO-200, 1st Edition, Microsoft Press Store by Pearson, 2020, ISBN 978-0-13-662715-9.

McFEDRIES, Paul. MOS Study Guide for Microsoft Excel Expert Exam MO-201, 1st Edition, Microsoft Press Store by Pearson, 2020, ISBN 978-0-13-662752-4.

LAMBERT, Joan. MOS 2016 study guide for Microsoft Excel: Microsoft Office Specialist exam 77-727. Redmond: Pearson Education, 2017. ISBN 978-0-7356-9943-4.

MCFEDRIES, Paul. MOS 2016 study guide for microsoft excel expert. Indianapolis, IN: Microsoft Press, 2016. ISBN 978-0-7356-9942-7, LAMBERT, Joan. MOS 2013. study guide for Microsoft Excel. Redmond, Wash.: Microsoft Press, 2013. ISBN 978-0-7356-6920-8.

DODGE, Mark. MOS 2013 study guide for Microsoft Excel Expert. Redmond, Wash.: Microsoft Press, 2013. ISBN 978-0-7356-6921-5.

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

• Economics and Management 2019/20 (compulsory course)