Course detail

Information Technology II

FAST-CU01Acad. year: 2010/2011

Modern operating systems, configuration and administering, computer networks, resources sharing, security, viruses and hacking.
Data management systems from the viewpoint of users, basics of relational databases, data modelling and manipulating, query languages and query design.
Spreadsheets - data and engineering calculations, optimizing, contingent tables, data source linking.
Heterogenous data stores, modern trends in data analysis, data and dependency mining, inverse solution problem.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Basics of algorithmization and object oriented programming.
Working skills of programming in Visual Basic for Applications.

Prerequisites

Using of operation system, basics of using spreadsheets, basics of numerical analysis and optimization.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Requirements for successful completion of the subject are specified by guarantor’s regulation updated for every academic year.

Course curriculum

1. Windows configuration and administering
2. security and access controlling
3. network infrastructure, resource sharing tools
4. basics of data modelling, main database management systems
5-6. model design, process of database normalization
7-8. data manipulation, views, indexes, queries
9-10. Spreadsheet: Data manipulations
11-13. Spreadsheets: Engineering calculations, samples solution

Work placements

Not applicable.

Aims

Advanced utilization of computers for engineering practice.
Comprehensive theoretical knowledge of computer science and database problematics.

Specification of controlled education, way of implementation and compensation for absences

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Not applicable.

Recommended reading

WIRTH, Nicolas: Algoritmy a štruktúry údajov. Alfa Bratislava, 1988. (CS)
Knuth, D. E.: Fundamental Algorithms. Third Edition.. Addison-Wesley, 1997. (EN)
KRÁL, Martin: Excel VBA. Computer Press, 2010. EAN 9788025123584. (CS)
HALVORSON, Michael: Microsoft Visual Basic. Computer Press, 2010. EAN 9788025131466. (CS)

Classification of course in study plans

  • Programme N-P-C-SI Master's

    branch S , 1. year of study, summer semester, compulsory
    branch S , 1. year of study, summer semester, compulsory

  • Programme N-P-E-SI Master's

    branch S , 1. year of study, summer semester, compulsory

  • Programme N-P-C-SI Master's

    branch S , 1. year of study, summer semester, compulsory
    branch S , 1. year of study, summer semester, compulsory

  • Programme N-K-C-SI Master's

    branch S , 1. year of study, summer semester, compulsory

  • Programme N-P-E-SI Master's

    branch S , 1. year of study, summer semester, compulsory
    branch S , 1. year of study, summer semester, compulsory

  • Programme N-K-C-SI Master's

    branch S , 1. year of study, summer semester, compulsory
    branch S , 1. year of study, summer semester, compulsory
    branch S , 1. year of study, summer semester, compulsory

  • Programme N-P-E-SI Master's

    branch S , 1. year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hours, obligation not entered

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Exercise

26 hours, obligation not entered

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.