Course detail

Information Processing

FSI-BZIAcad. year: 2010/2011

The course provides an introduction to information processing. It deals with the following topics: data acquisition and sensors, data organisation, data processing in database systems, DBS architecture, relations and data models, fundamentals of SQL (Structured Query Language), data analysis using spreadsheets and advanced math software, proper presentation of data using charts, graphics and reports.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

Ing. Radek Poliščuk, Ph.D.

Department

Institute of Automation and Computer Science (ÚAI)

Learning outcomes of the course unit

The course familiarises students with theoretical and practical aspects of data processing. It will provide them with tools necessary for efficient selection of solutions for data acquisition, database and presentation applications.

Prerequisites

Successful completion of the course "Information Processing" is conditional on basic knowledge of common IT usage, as tought on secondary schools. Lectures may be partialy based on 1IN topics, taught at winter semester.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

The course-unit credit is awarded on condition of attendance in seminars and having passed the given tasks and tests.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

The course aims to acquaint the students with basic methods of work with technical data and usage of computers, required for praxis of nowadays mechanical engineers.

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

Since the attendance at seminars is required, it will be checked systematically by the seminar teacher using e-learning presentation tests. If a student misses a seminar, an excused absence can be compensated for via make-up topics of exercises.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997.
Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003.
Pokorný, J.: Konstrukce databázových systémů. Skriptum ČVUT FEL, Praha, 1999.
Pokorný, J.: Visual Basic pro aplikace Accessu 2000. Kopp, České Budějovice, 2000.
Viescas, J.: Mistrovství v Microsoft Access 2000. Computer Press, Praha, 2000.

Recommended reading

Pokorný, J., Halaška, I.: Databázové systémy.
Pokorný, J.: Visual Basic pro aplikace Accessu 2000.

Classification of course in study plans

  • Programme B3901-3 Bachelor's

    branch B-PDS , 1 year of study, summer semester, compulsory
    branch B-MTI , 1 year of study, summer semester, compulsory

  • Programme B2341-3 Bachelor's

    branch B-S1R , 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. Radek Poliščuk, Ph.D.

Syllabus

1. Introduction, data and information, data types in IT, data acquisition in mechanical engineering, classes of electronic sensors.
2. Historical and contemporary data acquisition methods, data formats and architectures, data structures and methods of work wit heterogenous data.
3. Principles of relational database function, data normalization, sequentional data processing - sorting and filtering.
4. Problematics and solutions for data redundancy and inconsistency in multi-user data access, files and distributed databases, reasons for client-server schema of work, database definition and manipulation languages and a common database application interfaces.
5-6. SQL: Selections, ordering, aggregations, unions, output transformation, sub-queries, basic action and data definition queries.
7. Spreadsheets: reasons for work with tabular data, usage of formulas on data in order to obtain the required information, analytical tools, common principles of preparation of textual and graphical outputs.
8-10. Software for advanced data processing - LabVIEW, basic methods for analysis of numerical data, work with errors in numerical data files.
11. Basic methods for image processing: Bitmap and vector graphics, scanning and basic data manipulation techniques, common functions of bitmap and vector graphics editors, OCR.
12. Basic typographical rules for creation of protocols and printouts, reasons for usage of implicit styles, rather than explicit "in place" formatting in modern text editors.
13. Finalization of course.

Computer-assisted exercise

22 hod., compulsory

Teacher / Lecturer

Ing. Jiří Kovář, Ph.D.
Ing. Daniel Zuth, Ph.D.
Ing. Petr Šoustek, Ph.D.
Ing. Jan Richter, Ph.D.
Ing. Jana Košíková, Ph.D.

Syllabus

1. ÚAI laboratories: Electronical sensors for data acquisition, industrial data acquisition using PLC and PC
3. Microsoft Access 2003 - desktop database environment, creation of data tables
4. Microsoft Access 2003 - relational databases in access
5. Microsoft Access 2003 - SQL
6. Microsoft Access 2003 - Column and Table Aliases, data and application management
7. Microsoft Excel spreadsheet – formulas, sorting, pivot tables, charts
8-10. Practical examples of analytical applications - LabVIEW
11. Creation of complex text document (Microsoft Word, OpenOffice.org)
12-13. course credits.