Informatics

Garant předmětu:

Přednášející:

Cvičící:

Předmět zajišťuje:

institut ekonomických studií

Anotace:

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)

Požadavky:

13 continuous homework assignments from each exercise

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

Osnova přednášek:

Osnova cvičení:

Cíle studia:

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.

Studijní materiály:

Poznámka:

Další informace:

Pro tento předmět se rozvrh nepřipravuje

Předmět je součástí následujících studijních plánů:

• Economics and Management 2019/20 (povinný předmět)