Nov 21, 2019   3:41 p.m. Elvíra
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 title: Informatics 1
Course unit code: B1-I1_C
Mode of completion and Number of ECTS credits: Classified fulfillment of requirements (2 credits)
Name of lecturer: doc. RNDr. Zuzana Krivá, PhD. (instructor, lecturer, person responsible for course) - slovak, english
RNDr. Peter Smrek, PhD. (examiner, instructor, lecturer) - slovak, english
Learning outcomes of the course unit:
Basics of work with MS Excel program. Solving of statistical models with MS Excel program.
Prerequisites and co-requisites: none
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.

Planned learning activities and teaching methods: lectures/ excersices
Assesment methods and criteria: graded credit
Language of instruction: Slovak, English
Work placement(s): There is no compulsory work placement in the course unit.

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

Type of output: