635-0815/01 – Computer Application (AVT)

Gurantor departmentDepartment of Thermal EngineeringCredits6
Subject guarantorprof. Dr. Ing. René PyszkoSubject version guarantorprof. Dr. Ing. René Pyszko
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2004/2005Year of cancellation
Intended for the facultiesFMTIntended for study typesFollow-up Master
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 Credit and Examination 1+3
Combined Credit and Examination 16+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. 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

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

Full-time form (validity from: 2012/2013 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 30  16
        Examination Examination 70  35
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2012/2013 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 30  16
        Examination Examination 70  35
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2015/2016 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2015/2016 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2014/2015 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2014/2015 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2013/2014 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2013/2014 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2012/2013 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2012/2013 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2011/2012 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2011/2012 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2010/2011 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2010/2011 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2009/2010 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2009/2010 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2008/2009 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2008/2009 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2007/2008 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2007/2008 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2006/2007 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2006/2007 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan
2005/2006 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics K Czech Ostrava 2 Compulsory study plan
2005/2006 (N2109) Metallurgical Engineering (2109T025) Thermal Engineering and Industrial Ceramics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
FMMI 2013/2014 Full-time Czech Compulsory 601 - Study Office stu. block
FMMI 2012/2013 Full-time Czech Compulsory 601 - Study Office stu. block
FMMI_ECTS 2011/2012 Full-time Czech Compulsory 600 - Faculty of Materials Science and Technology - Dean's Office stu. block