ECTS
ECTS Course Catalogue
Course details
Course code: ICSS10128o16Semester: 2016/2017 summer
Name: Informatics
Major: Safety Engineering
Study Type: first cycle
Course type: compulsory
Study Semester: 2
ECTS points: 3
Hours (Lectures / Tutorials / Other): 15 / 15 / 0
Lecturer: dr Jan Jełowicki
Language of instruction: Polish
Learning outcomes: Knowledge • knows properties of information and data; understands how the information is stored, transmitted and performed; • knows basic rules for data access management and data integrity verification; • knows how relational database systems work and how to design a database; • knows network application protocols and rules for addressing network resources; • understands client‒server model of network services; • knows how to filter data streams. Skills • can acquire data from database systems using query language; • can design typical relational database for specified purpose; • can analyze sequence of measurement data in order to detect outlying point and averaged values; • can verify integrity of message or data file; • can identify elements of URL syntax; • is self-conscious when using different network protocols; • can prepare text and tabular data for presentation in WWW services; • can adapt existing simple script generating reports from a database for own purposes. Social competences • understand role of information flow in contemporary society; • understands necessity for access to current information; • knows importance of formal information access control and formal information verification; • can collaborate with other people.
Competences:
Prerequisites: information technology
Course content: Concept of information. Methods for storing information. Data compression. Data integrity. Detection and correction of errors. Architecture of computer systems. Von Neumann’s machine. Running processes. Mass storing devices. Filesystems. Data access control in filesystems. File attributes. Access Control Lists. Basic types of data. Data formats. Database management systems. Acquiring data from relational databases. Logical design of relational database. Normal forms of database schemes. Computer networks. Network addressing schemes. Network communication protocols. Network traffic filtering. Information on programming languages. Client‒server architecture. Selected application network protocols. Using http servers. Elements of signal analysis.
Recommended literature: 1. Michael J. Hernandez: Bazy danych dla zwykłych śmiertelników. Mikom 2004 2. Włodzisław Duch: Fascynujący świat programów komputerowych. Wydawnictwo Nakom 1997; http://www.fizyka.umk.pl/~duch/books-fsk/FSPK 3. Piotr J. Durka: Cyfrowy świat: jak to działa. Wydawnictwo Adamantan 2004. http://brain.fuw.edu.pl/~durka/KIC 4. Jerzy Szabatin: Przetwarzanie sygnałów. 2003. Typescript, http://www.ise.pw.edu.pl/~szabatin/ps.pdf (supplemental material) 5. Jan Jełowicki: Materiały do zajęć z informatyki. 2000–2012; http://karnet.up.wroc.pl/~jasj/cwiczenia (supplemental material) 6. Documentation of selected standards and systems.
Assessment methods: Actual activity, practical test on SQL, group project, individual project, final knowledge test.
Comment: