205-0301/02 – Computer Engineering (TEIN)

Gurantor department	Office of Information Technology	Credits	3
Subject guarantor	Mgr. Lenka Jurčíková, Ph.D.	Subject version guarantor	Mgr. Lenka Jurčíková, Ph.D.
Study level	undergraduate or graduate	Requirement	Compulsory
Year	1	Semester	winter
		Study language	Czech
Year of introduction	2014/2015	Year of cancellation
Intended for the faculties	FAST	Intended for study types	Bachelor, Follow-up Master

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
JUR64	Mgr. Lenka Jurčíková, Ph.D.
VAL76	Ing. Pavel Valíček, Ph.D.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Graded credit	0+2
Part-time	Graded credit	0+12

Subject aims expressed by acquired skills and competences

Through computer technology to solve examples from engineering practice. Apply attained knowledge in a particular software task of building fields. Using software to sort, categorize, compare and illustrate the data. Meet with the concept of algorithm, a solution of the algorithm of construction practice and use it in a programming language.

Teaching methods

Lectures
Tutorials
Project work

Summary

The main content of this course is to work with PC skills necessary for construction practice, including the creation of algorithms and programming fundamentals. Emphasis is placed on the basics of typography, automatic generation of text fields, edit and change the look of text books, including a large graphic elements. In the field of Engineering explains the concept of algorithms, basic programming, use spreadsheet functions to create graphs, sorting and evaluating the collected data, programming is used to create macros in Visual Basic. All findings are applied to the task of building practice examples of specific applications.

Compulsory literature:

http://office.microsoft.com/en-us/office-online-help/get-started-at-office-com-HA101785172.aspx http://mdg.vsb.cz/M/

Recommended literature:

http://office.microsoft.com/en-us/office-online-help/get-started-at-office-com-HA101785172.aspx http://mdg.vsb.cz/M/

Additional study materials

Study supports in the EduDocs system

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

At least 70% attendance at the exercises. Absence, up to a maximum of 30%, must be excused and the apology must be accepted by the teacher (the teacher decides to recognize the reason for the excuse).

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1st Logging into the school's internal network, write to the LMS, network drives, basic principles of networking, basic e-mail. Fundamentals of typography, editing text, including a large graphic elements. 2nd Working with text larger scale, especially for creating tables, writing and editing mathematical formulas and symbols through the Equation Editor, inserting objects, rules for the use of graphics, categorization, creation of active content, all through a text editor, the highest version. 3rd Basics spreadsheet highest version. Principles of developing active rasters using internal commands and formulas, formatting, grids, creation, editing and use of lines to practical problems. 4th Matrix in a spreadsheet - addition, matrix multiplication, inverse and transpose of a matrix, determinant calculation. 5th Creating different types of graphs for the purpose of solving practical problems and to present results of the work, solving problems of geotechnical engineering and building materials, functions and formulas spreadsheet highest version, especially statistical functions. 6th Classification and evaluation of experimental data in connection with applications for further processing. 7th Programming and algorithm - concept flow chart creation process simple algorithms, an overview of programming languages. 8th Algorithms more complex processes, conditions, loops, 9th Structures, arrays. 10th The programming language - Visual Basic, introduction, basics, types of variables, basic commands, the structure of programs. 11th Macros, simple recording, editing, programming new ones. 12th Submission and evaluation of the semester. 13th Verification of knowledge based on written tests and final evaluation.

Conditions for subject completion

Part-time form (validity from: 2014/2015 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Graded credit	Graded credit	100	51	3

Mandatory attendence participation: At least 70% attendance at the exercises. Absence, up to a maximum of 30%, must be excused and the apology must be accepted by the teacher (the teacher decides to recognize the reason for the excuse).

Show history

Conditions for subject completion and attendance at the exercises within ISP: 1. Passing all tasks 2. Achieving a minimum of 51 points

Show history

Occurrence in study plans

Academic year	Programme	Form	Study language	Tut. centre	Year	Type of duty
2025/2026	(N0732A260003) Civil Engineering - Building Structures	K	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260003) Civil Engineering - Building Structures	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	K	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260007) Civil Engineering - Building Environment	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260011) Civil Engineering - Transport Constructions	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260013) Civil Engineering - Building and Industry Construction	K	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260013) Civil Engineering - Building and Industry Construction	P	Czech	Ostrava		Optional	study plan
2025/2026	(N0732A260015) Civil Engineering - Municipal Engineering	K	Czech	Ostrava	1	Optional	study plan
2025/2026	(N0732A260015) Civil Engineering - Municipal Engineering	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260003) Civil Engineering - Building Structures	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	K	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260007) Civil Engineering - Building Environment	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260011) Civil Engineering - Transport Constructions	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260013) Civil Engineering - Building and Industry Construction	K	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260013) Civil Engineering - Building and Industry Construction	P	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260003) Civil Engineering - Building Structures	K	Czech	Ostrava		Optional	study plan
2024/2025	(N0732A260015) Civil Engineering - Municipal Engineering	K	Czech	Ostrava	1	Optional	study plan
2024/2025	(N0732A260015) Civil Engineering - Municipal Engineering	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260003) Civil Engineering - Building Structures	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	K	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260007) Civil Engineering - Building Environment	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260011) Civil Engineering - Transport Constructions	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260013) Civil Engineering - Building and Industry Construction	K	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260013) Civil Engineering - Building and Industry Construction	P	Czech	Ostrava		Optional	study plan
2023/2024	(N0732A260015) Civil Engineering - Municipal Engineering	K	Czech	Ostrava	1	Optional	study plan
2023/2024	(N0732A260015) Civil Engineering - Municipal Engineering	P	Czech	Ostrava		Optional	study plan
2022/2023	(B0732A260001) Civil Engineering	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260003) Civil Engineering - Building Structures	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	K	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260015) Civil Engineering - Municipal Engineering	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260015) Civil Engineering - Municipal Engineering	K	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260007) Civil Engineering - Building Environment	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260011) Civil Engineering - Transport Constructions	P	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260013) Civil Engineering - Building and Industry Construction	K	Czech	Ostrava		Optional	study plan
2022/2023	(N0732A260013) Civil Engineering - Building and Industry Construction	P	Czech	Ostrava		Optional	study plan
2021/2022	(B0732A260001) Civil Engineering	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260015) Civil Engineering - Municipal Engineering	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260003) Civil Engineering - Building Structures	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260003) Civil Engineering - Building Structures	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260005) Civil Engineering - Geotechnics and Underground Engineering	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260007) Civil Engineering - Building Environment	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260007) Civil Engineering - Building Environment	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260009) Civil Engineering - Building Materials and Diagnostics of Structures	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260011) Civil Engineering - Transport Constructions	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260011) Civil Engineering - Transport Constructions	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260013) Civil Engineering - Building and Industry Construction	P	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260013) Civil Engineering - Building and Industry Construction	K	Czech	Ostrava		Optional	study plan
2021/2022	(N0732A260015) Civil Engineering - Municipal Engineering	K	Czech	Ostrava		Optional	study plan
2019/2020	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2019/2020	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan
2018/2019	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan
2018/2019	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2017/2018	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2017/2018	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan
2016/2017	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2016/2017	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan
2015/2016	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2015/2016	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan
2014/2015	(B3607) Civil Engineering	P	Czech	Ostrava	1	Compulsory	study plan
2014/2015	(B3607) Civil Engineering	K	Czech	Ostrava	1	Compulsory	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction