Skip to main content
Skip header

Technical Data Processing Methods

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code342-3343/01
Number of ECTS Credits Allocated1 ECTS credits
Type of Course Unit *Compulsory
Level of Course Unit *First Cycle
Year of Study *Second Year
Semester when the Course Unit is deliveredWinter Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
S1I95Ing. Jaromír Široký, Ph.D.
Summary
Learning Outcomes of the Course Unit
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.
Course Contents
Import and data export
Data sorting
Forms
Summary
Pivot table
Regressions
API
Analytic tools
Macro programming
Recommended or Required Reading
Required Reading:
http//:www.fme.vutbr.cz/opory/ZI_BS.pdf
lms.vsb.cz
ORVIS W. J.: Microsoft Excel pro vědce a inženýry. Praha: Computer Press. 1996.ss. 498. ISBN8 0-85896-49-4
ŠEDA, M.: Zpracování informací. VUT Brno. [online] http//:www.fme.vutbr.cz/opory/ZI_BS.pdf
ZAPLATÍLEK, K., DOŇAR, B.: MATLAB pro začátečníky. Praha: BEN. 2003. 144 s. ISBN 80-7300-095-4
Recommended Reading:
http//:www.fme.vutbr.cz/opory/ZI_BS.pdf
lms.vsb.cz
ORVIS W. J.: Microsoft Excel pro vědce a inženýry. Praha: Computer Press. 1996.ss. 498. ISBN8 0-85896-49-4
ŠEDA, M.: Zpracování informací. VUT Brno. [online] http//:www.fme.vutbr.cz/opory/ZI_BS.pdf
ZAPLATÍLEK, K., DOŇAR, B.: MATLAB pro začátečníky. Praha: BEN. 2003. 144 s. ISBN 80-7300-095-4
Planned learning activities and teaching methods
Tutorials
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
CreditCredit