352-0302/01 – Computer Engineering (VT)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantordoc. Ing. Petr Kočí, Ph.D.Subject version guarantordoc. Ing. Petr Kočí, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2001/2002Year of cancellation2010/2011
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FOJ74 Ing. David Fojtík, Ph.D.
KOC55 doc. Ing. Petr Kočí, Ph.D.
SMU78 Ing. Pavel Smutný, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 1+2
Combined Graded credit 8+8

Subject aims expressed by acquired skills and competences

The main objective of the course is to teach Computer Science students to think of a computer in a way to use computer technology for the purpose of studies and in engineering practice. Another objective is the active use of computer networks FSNET and Internet / Intranet, as well as mastering an advanced text and graphics, spreadsheet and presentation programs used on the FS. After completing the course students should be able to use advanced tools for editing text (styles, automatic content, automatic numbering of images, ...), processing and presentation of data in a spreadsheet, using mathematics, logic and database functions (TREND, LINEST, IF, SELECT , Inversion, MMULT, ...). At the same time, students will be able to make a presentation on the need for defense. An important part of this course is the application of specific technical problems in the learning environment and focus on the ability of independent solutions of the subject and grasp of the issues.

Teaching methods

Summary

The course introduced students to the basic capabilities and the use of text, spreadsheets and graphics processors. Its aim is to spread knowledge students and competence in using personal computers, PC and their work in the computer FSNET network and Internet / Intranet, the basic user features operating systems with emphasis on OS Windows/Win95/WinNT, advanced work with text and graphics, spreadsheets. Basic procedures and algorithms their use for the use of simulation tools. The course is aimed at practical application of acquired skills in industry and administration.

Compulsory literature:

[1.] KOČÍ, P. Výpočetní technika 1. vyd. Ostrava, VŠB-TUO, 2007, 240s. ISBN 978-80-248-1515-2.

Recommended literature:

[1.] ŠATÁNEK, J. & FARANA, R. Integrované programové prostředky. Aplikace tabulkového procesoru MS-Excel. 1. vyd. Ostrava: KAKI, 1996. 104 s. Dostupný také z www http://www.fs.vsb.cz/books/Excel/Start.htm. ISBN 80-02-01103-1. [2.] VÍTEČKOVÁ, M. VOJÁČEK, M. FARANA, R. Aplikace počítačů v řízení. Zpracování textů na počítači. 1. vyd. Ostrava: KAKI, 1995. 59 s. ISBN 80-02- 01026-4. [3.] MATÚŠ, Z. Word : sbírka příkladů - 1. vyd.. - Praha : BEN, 2002. - 126 s. ISBN 80-7300-071-7 [4.] PECINOVSKÝ, J. PECH, J. Word 2000 : podrobný průvodce začínajícího uživatele - 1. vyd.. - Praha : Grada Publishing, 1999. - 239 s. : il. ISBN 80- 7169-869-5 [5.] GILPINOVÁ, R. Word 2000 : příprava textů s použitím Microsoft Word 2000 anebo Microsoft Office 2000 [překlad Pavel Kostecký]. - 1. české vyd.. - Bratislava : Príroda, 2001. - 64 s. : il. ISBN 80-07-00223-5 [6.] BŘÍZA, V. Word 2002 : podrobný průvodce pokročilého uživatele. - 1. vyd.. - Praha : Grada Publishing, 2002. - 215 s. : il. ISBN 80-247-0190-1 [7.] BŘÍZA, V. Word 2002 : podrobný průvodce začínajícího uživatele - 1. vyd.. - Praha : Grada Publishing, 2001. - 195 s. : il. ISBN 80-247-0157-X [8.] PERRY, G. Excel 2000 : odpovědi na nejčastějsí otázky - 1. vyd.. - Praha : Grada Publishing, 1999. - 251 s. : il. ISBN 80-7169-871-7 [9.] PECINOVSKÝ, J. Excel 2000 : podrobný průvodce začínajícího uživatele - 1. vyd.. - Praha : Grada PUBLISHING, 1999. - 256 s. : il. ISBN 80-7169-872-5 [10.] FRANCŮ, M. Excel 2000 : učebnice - 1. vyd.. - Brno : CCB, 1999. - 213 s. : il. ISBN 80-85825-42-2 [11.] KOŘÍNEK, M. Excel 2002 - 1. vyd.. - České Budějovice : Kopp, 2001. - 176 s. : il. ISBN 80-7232-156-0 [12.] PECINOVSKÝ, J. Excel 2002 - 1. vyd.. - Praha : Grada Publishing, 2001. - 132 s. : il. ISBN 80-247-0149-9 [13.] PECINOVSKÝ, J. Excel 2002 : podrobný průvodce pokročilého uživatele - 1. vyd.. - Praha : Grada Publishing, 2002. - 211 s. : il. ISBN 80-247-0184-7 [14.] PECINOVSKÝ, J. Excel 2002 : podrobný průvodce začínajícího uživatele - 1. vyd.. - Praha : Grada Publishing, 2001. - 220 s. : il. ISBN 80-247-0150-2

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:

The course aims to teach students in bachelor's degree program of study "Engineering" with the possibilities and the use of computer technology studies at the Technical University of Ostrava and in engineering practice. Learn how to use personal computers in a network FSNET, TUONET and Internet / Intranet, the basic characteristics of user operating systems with emphasis on Windows, an advanced text and graphics, spreadsheets and software tools used in other technical subjects at the Faculty. The course curricula are the foundations of algorithms. Furthermore, familiar with production and processing of technical reports (minutes of measurement), processing and interpretation of experimental data and computer-aided presentations.

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2010/2011 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2009/2010 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2008/2009 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2008/2009 (B2341) Engineering K Czech Třinec 1 Compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Šumperk 1 Choice-compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Ostrava 1 Choice-compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Uherský Brod 1 Choice-compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Třinec 1 Choice-compulsory study plan
2006/2007 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Šumperk 1 Compulsory study plan
2006/2007 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Ostrava 1 Compulsory study plan
2006/2007 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Uherský Brod 1 Compulsory study plan
2006/2007 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Třinec 1 Compulsory study plan
2005/2006 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Šumperk 1 Compulsory study plan
2005/2006 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Ostrava 1 Compulsory study plan
2005/2006 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Uherský Brod 1 Compulsory study plan
2005/2006 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Třinec 1 Compulsory study plan
2004/2005 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Ostrava 1 Compulsory study plan
2003/2004 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner