342-0576/01 – Methods of Engineering Data Processing (IMZD)

Gurantor departmentInstitute of TransportCredits2
Subject guarantorIng. Jaromír Široký, Ph.D.Subject version guarantorIng. Jaromír Široký, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation
Intended for the facultiesFSIntended for study typesFollow-up Master
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+8

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

E-learning

Další požadavky na studenta

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 Analytic tools Macro programming

Conditions for subject completion

Combined form (validity from: 1960/1961 Summer semester, validity until: 2015/2016 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation Credit 85 (85) 0
        Project Project 85  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology K Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport P Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport P Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (40) Air Transport P Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (10) Rail Transport K Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (20) Road Transport K Czech Ostrava 1 Compulsory study plan
2009/2010 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2008/2009 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2008/2009 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2008/2009 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (40) Air Transport P Czech Ostrava 1 Compulsory study plan
2007/2008 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2007/2008 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2007/2008 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (40) Air Transport P Czech Ostrava 1 Compulsory study plan
2006/2007 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2006/2007 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan
2005/2006 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology P Czech Ostrava 1 Compulsory study plan
2005/2006 (N2301) Mechanical Engineering (2301T003) Transport Equipment and Technology (30) Transport Technology K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner