635-0077/01 – Computer Application (AVT)

Gurantor departmentDepartment of Thermal EngineeringCredits4
Subject guarantorprof. Dr. Ing. René PyszkoSubject version guarantorprof. Dr. Ing. René Pyszko
Study levelundergraduate or graduateRequirementCompulsory
Year5Semestersummer
Study languageCzech
Year of introduction1999/2000Year of cancellation2009/2010
Intended for the facultiesFMTIntended for study typesMaster
Instruction secured by
LoginNameTuitorTeacher giving lectures
PYS30 prof. Dr. Ing. René Pyszko
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 0+3
Combined Graded credit 14+0

Subject aims expressed by acquired skills and competences

- to understand a function of coputer parts and systém software - to understand the principle of information storage in computers - to examine data correctsness - to find and validate a regression model - process and analyze time series - to undestand theory of databases and usage for measured data analysis - the student will know the formal and stylistic principles of writing technical reports"

Teaching methods

Lectures
Tutorials

Summary

Basic concepts of PC hardware and software. Usage of spreadsheets for measured data processing. Numeric derivative, integrating and filtering of time series, removing d.c. component, trend and outlying values. Mathematical, statistical, logical and searching functions. Regression analysis. Basics of databases, usage of database functions. Fundamentals of macros and object oriented programming. Formal, stylistic and technical requirements on writing technical report and final thesis. "

Compulsory literature:

"Accelerated testing : statistical models, test plans, and data analyses [Nelson, 1990] / Wayne Nelson. - New York : Wiley, c1990 - xiv, 601 s. : il. ISBN 0-471-52277-5 (váz.) Analysis of economic data / by Gary Koop. - 2nd ed.. - Chichester : Wiley, c2005 - xii, 241 s. : il. ISBN 0-470-02468-2 (brož.)978-0-470-02468-3 (chybné) Data processing : computers in action / Perry Edwards and Bruce Broadwell. - 2nd ed.. - Belmont : Wadsworth, c1982 - xv, 592 s. : il. ISBN 0-534-01063-6 (1/1) Linda F. Johnson: Microsoft Office Specialist: Excel 2003 Study Guide. Indianapolis: Wiley Publishing, 2006, 425 p., ISBN 13-978-0-4719-4002-X."

Recommended literature:

Data mining : practical machine learning tools and techniques / Ian H. Witten, Eibe Frank. - 2nd ed.. - San Francisco : Morgan Kaufmann, c2005 - xxxi, 524 s. : il. ISBN 0-12-088407-0 (brož.)978-0-12-088407-0 (chybné) Digital signal processing : a practical approach [Ifeachor, 1993] / Emmanuel C. Ifeachor, Barrie W. Jervis. - Wokingham : Addison-Wesley, 1993 - xxiii, 760 s. : il. ISBN 0-201-54413-X (váz.)"

Way of continuous check of knowledge in the course of semester

Practical solving problems: - creation of regression model - interpolation of data by Lagrange interpolation polynomial - trend removal of time series - fitration, derivation and integration of time series - selections from the database, the conditional selections"

E-learning

available in the pdf form

Další požadavky na studenta

none

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Fundamentals of computer hardware components. 2. Basics of computer software. 3. The principle of storing characters and numbers in a computers 4. The principle of saving graphics 5. Foundations of regression analysis 6. Used types of regression models 7. Basics of exploratory data analysis 8. Interpolation 9. Time series – sampling, filtration, derivation, integration 10. The basic concepts of the theory of signals, Fourier transformation 11. Use the database for the measurement and data processing 12. Principle of object programming, the Excel macros 13. The principles of writing technical reports"

Conditions for subject completion

Combined form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100 (100) 0
        Laboratory work Laboratory work 30  0
        Project Project 30  0
        Written exam Written test 30  0
        Other task type Other task type 10  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2008/2009 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2008/2009 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2007/2008 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2007/2008 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2007/2008 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2007/2008 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2006/2007 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2006/2007 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2006/2007 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2006/2007 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2005/2006 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2005/2006 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2005/2006 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2005/2006 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2004/2005 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2004/2005 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2004/2005 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2004/2005 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2003/2004 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2003/2004 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2003/2004 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2003/2004 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2002/2003 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2002/2003 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2002/2003 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2002/2003 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2001/2002 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2001/2002 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2001/2002 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2001/2002 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan
2000/2001 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika K Czech Ostrava 5 Compulsory study plan
2000/2001 (M2109) Metallurgical Engineering (2109T024) Thermal Engineering (01) Tepelná technika P Czech Ostrava 5 Compulsory study plan
2000/2001 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály K Czech Ostrava 5 Compulsory study plan
2000/2001 (M2109) Metallurgical Engineering (2109T020) Industrial Ceramics and Refractory Materials (02) Průmyslová keramika a žárovzdorné materiály P Czech Ostrava 5 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner