GE261 Geochemical data processing

Faculty of Science
Spring 2025
Extent and Intensity
1/1/0. 2 credit(s) (příf plus uk k 1 zk 2 plus 1 > 4). Recommended Type of Completion: z (credit). Other types of completion: zk (examination), k (colloquium).
In-person direct teaching
Teacher(s)
Mgr. Renata Čopjaková, Ph.D. (lecturer)
Guaranteed by
Mgr. Renata Čopjaková, Ph.D.
Department of Geological Sciences – Earth Sciences Section – Faculty of Science
Contact Person: Ing. Jana Pechmannová
Supplier department: Department of Geological Sciences – Earth Sciences Section – Faculty of Science
Prerequisites (in Czech)
!( PROGRAM(B-GE)|| PROGRAM(N-GE)|| PROGRAM(D-GE4)|| PROGRAM(D-GE))
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 32 student(s).
Current registration and enrolment status: enrolled: 0/32, only registered: 0/32, only registered with preference (fields directly associated with the programme): 0/32
fields of study / plans the course is directly associated with
Course objectives
The course is focused on the acquisition of theoretical and practical background of geochemical data processing (mineral and rock analyses) using mathematical and statistical methods and graphic presentation using Microsoft Excel GCDkit.
Learning outcomes
Student will be able to use basic mathematical and statistical methods on geochemical data (mineral and rock analyses) using Microsoft Excel a GCDkit and will be able to interpret them after completing the course. Student will be able to process the data graphically in the given programs and interpret them.
Syllabus
  • 1. Geological data, types of geological data. Major and trace elements in rocks and minerals and their use in geochemical interpretations. Graphical presentation, types of graphs used in geosciences, Normalisation of geochemical data. Calculations of major geochemical parameters in normalised graphs 2. Geochemistry of magmatic rocks; Classification diagrams of magmatic (extrusive and plutonic) rocks. 3. Description of univariate data. Random sampling. Distribution of data in the population - frequency distribution. Graphing the frequency distribution; Graphical presentation of univariate data 4. Basic types of frequency distributions in geology. Distributions - normal, log-normal, binomial, special types (t-, F, chi square distributions). Examples of geological phenomena and their frequency distributions. 5. Basic statistical parameters Median, quantiles, mode, range, arithmetic mean, geometrical mean,….and their use in geology. 6. Testing statistical hypotheses Basic terms and testing procedures. The main tests in geology. 7. Statistical description of relations between variables. Correlation analysis. Regression analysis and their use in geology and substitution in minerals, Graphical presentation of substitution in minerals.
Teaching methods
lectures and theoretical training, statistical functions in the Excel and geochemical data processing using GCDkit
Assessment methods
The final test of theoretical and practical knowledge (Excel, GCDkit)
Náhradní absolvování
yes
Language of instruction
Czech
Further Comments
The course can also be completed outside the examination period.
The course is taught annually.
The course is taught: in blocks.
The course is also listed under the following terms Spring 2021, Spring 2022, Spring 2023, Spring 2024.
  • Enrolment Statistics (Spring 2025, recent)
  • Permalink: https://is.muni.cz/course/sci/spring2025/GE261