Skip to main content
Skip header

Modelling of Geological Objects

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code541-0052/03
Number of ECTS Credits Allocated5 ECTS credits
Type of Course Unit *Choice-compulsory type B
Level of Course Unit *First Cycle
Year of Study *Second Year
Semester when the Course Unit is deliveredSummer Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
STA22doc. RNDr. František Staněk, Ph.D.
Summary
In this course selected mathematical techniques in geosciences in connection with information technology development will be studied. The basics of
algorithmization of the selected problems with their consecutive program realization using the programming language VBA within the MS Excel
environment will be learned. The other problems studied are: the methodology of mathematical data processing in geosciences; the basic properties of
natural objects and modeling of these objects; exploration analysis of geodata; the basics of geostatistics; interpolation of a function; etc.
Learning Outcomes of the Course Unit
The first part of this course is dedicated to selected mathematical techniques in geosciences in connection with information technology development. These problems can arise from other courses as well as from practice. The basics of algorithmization of the selected problems with their consecutive program realization using the VBA programming language within the MS Excel environment will be taught. The main emphasis lays in explanation of fundamental principles of selected numerical methods and of their general properties. The students learn how to decide which procedure is a suitable tool for solving a specific problem. An important ingredient of the course is algorithmic implementation of the selected basic numerical methods.
The second part of the course deals with the methodology of mathematical data processing in geosciences; the basic properties of natural objects and modelling of these objects, exploratory data analysis, the basics of geostatistics, interpolation of a function and with the way in which to understand these notions from both theoretical and practical points of view. The basic methods of collecting and analysing geo-data are introduced. The students are taught how to use these general methods to solve the problems arising from other courses of their study and from practice.
Course Contents
1. Mathematical techniques in geosciences in connection with information technology development.
2. The basics of algorithmization of the selected problems with their consecutive program realization using the VBA programming language within the MS Excel.
3. Fundamental principles of selected numerical methods I.
4. Fundamental principles of selected numerical methods II.
5. Fundamental principles of selected numerical methods III.
6. Methodology of mathematical data processing in geosciences I.
7. Methodology of mathematical data processing in geosciences II.
8. Basic properties of natural objects and modelling of these objects.
9. Exploratory data analysis I.
10. Exploratory data analysis II.
11. The basics of geostatistics.
12. Interpolation of a function I.
13. Interpolation of a function II.

Recommended or Required Reading
Required Reading:
JACOBSON, R.: Microsoft Excel 2000/Visual Basic for Applications. Fundamentals. Microsoft Press, 1999.
WEBSTER, R., OLIVER, M. A.: Geostatistics for Environmental Scientists. 2nd ed. Statistics in practice. Wiley, 2007.
ARMSTRONG, M.: Basic Linear Geostatistics. Berlin, Springer, 1998.
DECKER, D.: GIS Data Sources. New York, Wiley, 2001.
BOHÁČ, Z., ČASTOVÁ, N.: Základní numerické metody. VŠB-TU Ostrava, 1997, 2004.
ČERNÝ, J.: Excel 2000, 2002, 2003, záznam úprava a programování maker, Grada 2004.
JEŽEK, J.: Geostatistika a prostorová interpolace. Karolinum, 2015.
WEBSTER, R., OLIVER, M. A.: Geostatistics for Environmental Scientists. 2nd ed. Statistics in practice. Wiley, 2007.
Recommended Reading:
JACOBSON, R.: Microsoft Excel 2000/Visual Basic for Applications. Fundamentals. Microsoft Press, 1999.
WEBSTER, R., OLIVER, M. A.: Geostatistics for Environmental Scientists. 2nd ed. Statistics in practice. Wiley, 2007.
ARMSTRONG, M.: Basic Linear Geostatistics. Berlin, Springer, 1998.
DECKER, D.: GIS Data Sources. New York, Wiley, 2001.
ŠŤASTNÝ, Z.: Matematické a statistické výpočty v Microsoft Excelu. Computer Press, 1999.
LAURENČÍK, M.: Programování v Excelu 2007 a 2010 - záznam, úprava a programování maker, Grada 2011.
SCHEJBAL, C.: Úvod do geostatistiky. VŠB-TU Ostrava, 1996.
ARMSTRONG, M.: Basic Linear Geostatistics. Berlin, Springer, 1998.
Planned learning activities and teaching methods
Lectures, Tutorials, Project work
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
Credit and ExaminationCredit and Examination100 (100)51
        CreditCredit33 17
        ExaminationExamination67 18