352-0501/02 – Aplied Informatics (AI)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantordoc. Ing. Marek Babiuch, Ph.D.Subject version guarantordoc. Ing. Marek Babiuch, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2021/2022Year of cancellation
Intended for the facultiesFSIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAB75 doc. Ing. Marek Babiuch, Ph.D.
FOJ74 Ing. David Fojtík, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Part-time Credit and Examination 7+7

Subject aims expressed by acquired skills and competences

Students are able to explain the basic concepts of information theory, coding and cryptography. Students are able to describe basic algorithms for data retrieval and sorting and explain their time complexity. In database systems they are able to formulate SQL queries and work with databases from a specific programming language. They also know XML, validate XML documents and query XML data. They have an overview of markup languages, scripting languages and javascript.

Teaching methods

Lectures
Tutorials
Project work

Summary

Subject Applied Informatics is a fundamental subjects that shape the profile of graduates in the field of Information technology. Its aim is to familiarize students with the procedures of algorithms and data structures, problem solving, etc. Information obtained in this subject is the basis for the realization of applications in the related subjects of study.

Compulsory literature:

BABIUCH, M. Sylaby k předmětu Aplikovaná informatika. Ostrava: VŠB-TU Ostrava, 2019. Dostupný ze systému LMS. URL: http://www.lms.vsb.cz. FARANA, R. Metody kódování, šifrování a bezpečnosti dat. 1. vyd. Ostrava 2013. 156 s. ISBN 80-7078-398-2. FARANA R. Kapitoly ze základů informatiky. Ostrava : VŠB - Technická univerzita Ostrava, 2003, 106 s. ISBN: 80-248-0265-1. ZURAWSKI, R. The Industrial Information Technology Hanbook. Danvers, MA, U.S.A.: CRC Press LLC, 2005. ISBN 0-8493-1985-4.

Recommended literature:

LAURENČÍK, M. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. Průvodce. ISBN 978-80-271-0774-2. KALUŽA, Jindřich a Ludmila KALUŽOVÁ. Informatika. Praha: Ekopress, 2012. ISBN 978-80-86929-83-5. PLÁVKA, J. Algoritmy a zložitosť. Košice: TU Košice, 1998, 82 s. ISBN 80-7166- 026-4. ŠARMANOVÁ, J. Teorie zpracování dat. 1. vyd. Ostrava: VŠB-TU Ostrava, 1997, 106 s. ISBN 80-7078-491-1. VIRIUS, M. Základy algoritmizace. Praha: Vydavatelství ČVUT, 1995. 195 s. ISBN 80-01-01346-4. WIRTH, N. Algoritmy a štruktúry údajov. Bratislava: Alfa, 1989. 488 s. ISBN 80-05-00153-3. RAPHAEL, B. and I. F. C. SMITH. Engineering informatics: fundamentals of computer-aided engineering. 2nd ed. Chichester: Wiley, 2013. ISBN 978-1-119-95341-8. ZURAWSKI, R. The Industrial Information Technology Hanbook. Danvers, MA, U.S.A.: CRC Press LLC, 2005. ISBN 0-8493-1985-4. GROFF, J. R. and P. N. WEINBERG. Using SQL. Berkeley: McGraw-Hill/Osborne, c1990. ISBN 0-07-881524-X.

Way of continuous check of knowledge in the course of semester

Students work on credit project (20p), during the semester are verified by a point test (15p). The exam of the subject Applied Informatics is divided into practical and theoretical part (45p+20p).

E-learning

University LMS system available at www.lms.vsb.cz

Other requirements

The prerequisite of this course is knowledge of algorithmization and experience in the use of personal computer with Windows operating system. It is also assumed mathematical erudition at the level of a university student (completed bachelor degree).

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Fundamental of informatics, information theory, algorithms, flowcharts, computer numbers IEEE standard, data formats 2. Coding, code creation, construction of shortest codes, Huffman coding. 3. Linear systematic codes. Hamming code, Cyclic codes. 4. Data encryption, cryptography overview, past and present encryption, examples of AES, DES, RSA. 5. Time complexity of algorithms, data sorting algorithms. 6. Javascript.Language syntax, exaples of using. 7. Interpretation scripting languages ​​and languages ​​for statistical data processing. 8. XML language, namespace, validation of XML documents, XML schemas (XSD and DTD) 9. Editing and transformation of XML documents DOM, XPATH, XMLT. 10. Querying XML data, XML Query, Linq to XML, 11. Introduction to MS SQL Server, Structure, Users and Authorities, Introduction to Transact-SQL. 12. DMLS - querying SQL server - data mining, 13. Querying several tables, queries with subqueries, Introduction to creating stored procedures and functions of MS SQL server, 14. Credit.

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.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (N0714A270011) Control of Machines and Processes P Czech Ostrava 1 Compulsory study plan
2021/2022 (N0714A270011) Control of Machines and Processes K Czech Ostrava 1 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes K Czech Ostrava 1 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner