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 graduateRequirementCompulsory
Year2Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation2020/2021
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
Part-time 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

Other requirements

no more requirements

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

Part-time form (validity from: 1960/1961 Summer semester, validity until: 2011/2012 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 30 (30) 0 3
                Project Project 20  0 3
                Other task type Other task type 10  0 3
        Examination Examination 70 (70) 0 3
                Oral Oral examination 70  0 3
Mandatory attendence participation:

Show history

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

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.Zaměření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

Assessment of instruction



2009/2010 Winter