352-0501/02 – Aplied Informatics (AI)
| Gurantor department | Department of Control Systems and Instrumentation | Credits | 4 |
| Subject guarantor | doc. Ing. Marek Babiuch, Ph.D. | Subject version guarantor | doc. Ing. Marek Babiuch, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2021/2022 | Year of cancellation | |
| Intended for the faculties | FS | Intended for study types | Follow-up Master |
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:
Recommended literature:
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
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction