28. 1. 2020  1:46 Alfonz
Akademický informačný systém

Sylabus predmetu B1-I1_C - Informatics 1 (FCE - WS 2019/2020)

     Informačný list          ECTS          Sylabus          

     Slovenčina          Angličtina          

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: 59

5,1 %18,6 %22,0 %15,3 %37,3 %1,7 %
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.

Typ výstupu: