Jun 17, 2019   7:20 a.m. Adolf
Academic information system

Course syllabus B1-I1_C - Informatics 1 (FCE - WS 2019/2020)

     Information sheet          ECTS          Syllabus          

     Slovak          English          

University: Slovak University of Technology in Bratislava
Faculty: Faculty of Civil Engineering
Course unit code: B1-I1_C
Course unit title: Informatics 1
Mode of delivery, planned learning activities and teaching methods:
lecture1 hour weekly (on-site method)
seminar1 hour weekly (on-site method)

Credits allocated: 2
Recommended semester/trimester: Civil Engineering - bachelor (compulsory), 3. semester
Civil Engineering (in english language) - bachelor (compulsory), 3. semester
Level of study: 1.
Prerequisites for registration: none
Assesment methods:
passing the final test
Learning outcomes of the course unit:
Basics of work with MS Excel program. Solving of statistical models with MS Excel program.
Course contents:
• Introduction to Excel. Working with booklets, sheets and windows, files, and documents. Working with references, creating formulas and automatic calculations.

• Inserting features, reviewing technical features, creating custom features. Drawing graphs. Solving equations. Newton's method.

• Descriptive statistics. Frequency tables and histograms. Analytical tools.

• Macros, Excel controls, dials, sliders, list fields.

• Regression analysis.
Recommended or required reading:
CHESTER, T. Excel 7 pro Windows 95. Praha : Grada, 1996. 812 p. ISBN 80-7169-314-6.
KRIVÁ, Z. Information Technology I: Excel basics for engineers. Bratislava : STU v Bratislave, 2012. 64 p. ISBN 978-80-227-3661-9.

Language of instruction: english or english and slovak
Courses evaluation:
Assessed students in total: 47

4,3 %17,0 %21,3 %17,0 %40,4 %0 %
Name of lecturer(s): doc. RNDr. Zuzana Krivá, PhD. (instructor, lecturer, person responsible for course) - slovak, english
RNDr. Peter Smrek, PhD. (examiner, instructor, lecturer) - slovak, english
Last modification: 28. 2. 2019
Supervisor: doc. RNDr. Zuzana Krivá, PhD. and programme supervisor

Last modification made by Ing. Peter Korčák on 02/28/2019.

Type of output: