Information sheet ECTS Syllabus
Course syllabus B1-I1_C - Informatics 1 (FCE - WS 2019/2020)
|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|
|• 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:|
|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.