352-0302/02 – 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 graduate
Study languageCzech
Year of introduction2007/2008Year of cancellation2010/2011
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAB75 doc. Ing. Marek Babiuch, Ph.D.
FOJ74 Ing. David Fojtík, Ph.D.
JAN795 Ing. Patrik Janečka
KOC55 doc. Ing. Petr Kočí, Ph.D.
KOP208 Ing. Milan Kopp
KUL74 Ing. Jiří Kulhánek, Ph.D.
LOS032 Ing. Jaroslav Los, Ph.D.
OSA003 Ing. Petr Osadník
SMU78 Ing. Pavel Smutný, Ph.D.
SPU037 Ing. Miloslav Spurný
STA481 Ing. Petr Staníček
VOJ164 Ing. Tomáš Vojtek
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 1+2
Part-time 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

Kontrola je zajištěna e-learningem. Student je povinen odevzdat na závěr cvičení výsledek své práce.

E-learning

Předmět je veden s podporpou e-learningu. Všechny studijní materiály jsou zpřístupněny a uvedeny v jednotlivých studijních týdnech. Hodnocení je realizováno formou testů v e-learningu.

Other requirements

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

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100 (100) 0 3
        Project Project 35  0 3
        Written exam Written test 60  0 3
        Other task type Other task type 5  0 3
Mandatory attendence participation:

Show history

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

Show history
Part-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100 (100) 0 3
        Project Project 35  0 3
        Written exam Written test 60  0 3
        Other task type Other task type 5  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
2010/2011 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2010/2011 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2010/2011 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2010/2011 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2009/2010 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2009/2010 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering P Czech Ostrava 1 Compulsory study plan
2009/2010 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2009/2010 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2009/2010 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2008/2009 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2008/2009 (B2341) Engineering P Czech Ostrava 1 Choice-compulsory study plan
2008/2009 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering P Czech Šumperk 1 Choice-compulsory study plan
2007/2008 (B2341) Engineering (2341R999) Bachelor Mechanical Engineering (00) Bachelor Machanical Engineering P Czech Ostrava 1 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2010/2011 Winter
2009/2010 Winter