342-3343/01 – Technical Data Processing Methods (MZTD)

Gurantor departmentInstitute of TransportCredits1
Subject guarantorIng. Jaromír Široký, Ph.D.Subject version guarantorIng. Jaromír Široký, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2017/2018Year of cancellation
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
S1I95 Ing. Jaromír Široký, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+2
Combined Credit 0+6

Subject aims expressed by acquired skills and competences

Aim of article is apprise student with method and practice by processing and presentation date in electronic version. Graduate is able a process data in Excel inclusive an analysis and macro programming.

Teaching methods

Tutorials

Summary

Předmět je zaměřen na metody a postupy zpracování dat za pomocí možností tabulkových procesorů. Předmět je zaměřen na postupy importu a exportu dat, jejich třídění, fitrování. Dále se studenti naučí vytvářet kontingenční tabulky a další prezentace dat. Studenti se seznámí s možnostmi digitalizace grafických průběhů dat. Předmět je uzavřen základy analýzy a úprav zaznamenaných procedur výpočtů.

Compulsory literature:

http//:www.fme.vutbr.cz/opory/ZI_BS.pdf lms.vsb.cz

Recommended literature:

http//:www.fme.vutbr.cz/opory/ZI_BS.pdf lms.vsb.cz

Way of continuous check of knowledge in the course of semester

Samostatné zpracování zadání

E-learning

lms.vsb.cz

Další požadavky na studenta

Basic of Excel. Independent approach to solving task.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Import and data export Data sorting Forms Summary Pivot table Regressions API Analytic tools Macro programming

Conditions for subject completion

Full-time form (validity from: 2017/2018 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit Credit  
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2017/2018 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit Credit  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2341) Engineering (2301R003) Transport Equipment and Technology P Czech Ostrava 2 Compulsory study plan
2019/2020 (B2341) Engineering (2301R003) Transport Equipment and Technology K Czech Ostrava 2 Compulsory study plan
2018/2019 (B2341) Engineering (2301R003) Transport Equipment and Technology P Czech Ostrava 2 Compulsory study plan
2018/2019 (B2341) Engineering (2301R003) Transport Equipment and Technology K Czech Ostrava 2 Compulsory study plan
2017/2018 (B2341) Engineering (2301R003) Transport Equipment and Technology P Czech Ostrava 2 Compulsory study plan
2017/2018 (B2341) Engineering (2301R003) Transport Equipment and Technology K Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner