Course Unit Code | 541-0052/03 |
---|
Number of ECTS Credits Allocated | 5 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 delivered | Summer Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| STA22 | doc. 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 Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Credit and Examination | Credit and Examination | 100 (100) | 51 |
Credit | Credit | 33 | 17 |
Examination | Examination | 67 | 18 |