Course detail

Data Processing

FP-BzdKAcad. year: 2019/2020

The course is understanding the nature of the data from various sources and to gain knowledge allowing them to analyze and process skills, including presentation in an appropriate form for management decision support.

Learning outcomes of the course unit

Learning outcomes - general competencies:
The skills associated with the use and treatment of information.
The ability of analysis and synthesis, application knowledge in practice, solve problems independently
Industry-specific competencies:
Students understand the principles of data acquisition, gain knowledge of data processing in information systems and their adaptation for presentation.

Prerequisites

Knowledge of working with MS Office.

Co-requisites

Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

KŘÍŽ, J. Zpracování dat. Učební text. VUT v Brně, fakulta podnikatelská.(bude vydáno v září 2015).
BARILLA, J. Microsoft Excel 2013 :podrobná uživatelská příručka. Brno: Computer Press, 2013. 1. vyd. 496 s. ISBN 978-80-251-4114-4.
CONOLLY, T., C. BEGG a R. HOLOWCZAK. Mistrovství – Databáze : Profesionální průvodce tvorbou efektivních databází. 1.vyd. Brno: Computer Press, 2009. 584 s. ISBN 978-80-251-2328-7.
LACKO, L. Jak vyzrát na SQL Server 2008. Brno: Computer Press, 2009. 469 s. ISBN 978-80-251-2101-6.

Planned learning activities and teaching methods

The course contains lectures that explain basic principles, problems and methodology of the discipline, and exercises.

Assesment methods and criteria linked to learning outcomes

Within the framework of the combined study, students will work on selected assignments from the subject's subject matter content based on listed topics. To control the processing of work and consultations, e-learning is used in which students have at their disposal electronic materials, including control tests. The subject is finished by processing and defending a separate project.

Language of instruction

Czech

Work placements

Not applicable.

Course curriculum

The course focuses on the principles and methods of data collection and processing in information systems and their adaptation for presentation.

Topics of the lectures:
Character data from various sources, search options
Database tables, attributes, data types
Handling tables and records, views and reports
Working with data in MS Excel
Power Pivot, data analysis tool
Decision support systems
Data aggregation and analysis (OLAP)

The workout is required continuous training, exercises are designed to process jobs based on the source data files and results presentation.

Aims

The aim is understanding the nature of the data from various sources and to gain knowledge allowing them to analyze and process skills, including presentation in an appropriate form for management decision support.
Learning outcomes - general competencies:
The skills associated with the use and treatment of information.
The ability of analysis and synthesis, application knowledge in practice, solve problems independently
Industry-specific competencies:
Students understand the principles of data acquisition, gain knowledge of data processing in information systems and their adaptation for presentation.

Specification of controlled education, way of implementation and compensation for absences

Attendance at lectures is not compulsory.

Classification of course in study plans

  • Programme BAK-KS Bachelor's

    branch BAK-EPM-KS , 1. year of study, summer semester, 3 credits, compulsory

Type of course unit

 

Guided consultation in combined form of studies

16 hours, optionally

Teacher / Lecturer

eLearning