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

Gurantor department	Institute of Transport	Credits	1
Subject guarantor	Ing. Jaromír Široký, Ph.D.	Subject version guarantor	Ing. Jaromír Široký, Ph.D.
Study level	undergraduate or graduate	Requirement	Compulsory
Year	2	Semester	winter
		Study language	Czech
Year of introduction	2017/2018	Year of cancellation	2022/2023
Intended for the faculties	FS	Intended for study types	Bachelor

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
S1I95	Ing. Jaromír Široký, Ph.D.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Credit	0+2
Part-time	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

Other requirements

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, validity until: 2022/2023 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Credit	Credit			3

Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Form	Study language	Tut. centre	Year	Type of duty
2020/2021	(B2341) Engineering	(2301R003) Transport Equipment and Technology	P	Czech	Ostrava	2	Compulsory	study plan
2020/2021	(B2341) Engineering	(2301R003) Transport Equipment and Technology	K	Czech	Ostrava	2	Compulsory	study plan
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 name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

2019/2020 Winter

2018/2019 Winter

2017/2018 Winter