GIS and Database Management Systems Field of study: Geography
Programme code: W2-S2GF19.2019

Module name: GIS and Database Management Systems
Module code: 04-GF-S2-1114
Programme code: W2-S2GF19.2019
Semester: summer semester 2020/2021
Language of instruction: English
Form of verification: course work
ECTS credits: 4
Description:
The course introduces students to the world of data bases and their application in the field of geosciences with emphasis on geology. Focus is placed on a good working knowledge of basics, especially input data file structure and how it is understood and visualized by geosciences software. Students participating in the course have an opportunity to familiarize themselves with geosciences data types, data sets, their static and dynamic interactions and with examples of software used in data management.
Prerequisites:
The course is provided in English therefore students attending it should be able to understand written and spoken English. Students should be able to communicate their thoughts and ideas in English as the course has an interactive character and discussion is a vivid part of educational process. Additionally, those wishing to participate in the course should be familiar with computer usage; being familiar with Excel or Calc would be helpful for a student but it is not a mandatory condition.
Key reading:
(no information given)
Learning outcome of the module Codes of the learning outcomes of the programme to which the learning outcome of the module is related [level of competence: scale 1-5]
The major educational outcome of this course is a solid understating of what is a geosciences data base, the way it works and its purpose. Students understand the very basics of operation of data bases (including preparation of simple files) and a relationships between data sets and data visualization. A few examples of applications in geosciences are provided, discussed and practiced. [04-GF-S2-1114_1]
 KGG2_W02 [3/5] KGG2_U01 [2/5] KGG2_U02 [3/5] KGG2_U03 [3/5] KGG2_U04 [2/5] KGG2_K01 [3/5]
Students know the general purpose and applicability of geosciences data bases. They understand the process of generating geological models. Students can prepare simple data base files and modify them in order to be readable by different software. Students can use data base and understand the relationship between data sets and the data visualization. Students are familiar with different types of geosciences data and understand how those data sets may be used in combination. Students understand and uses general English terminology associated with data bases in geosciences. [04-GF-S2-1114_2]
 KGG2_W02 [3/5] KGG2_U01 [2/5] KGG2_U02 [3/5] KGG2_U03 [3/5] KGG2_U04 [2/5] KGG2_K02 [3/5]
Type Description Codes of the learning outcomes of the module to which assessment is related
Short essay [04-GF-S2-1114_w_1]
Students will write a short essay in English (fixed number of pages) with text and figure(s). This will help students to exercise their skills in an art of formal scientific writing and provide an opportunity to utilize the knowledge they gathered during the lectures. Students will pick a topic of their essay from a few topics that the lecturer will provide.
 04-GF-S2-1114_1
Project [04-GF-S2-1114_w_2]
Students will do practical exercises with data bases in two or three different work modes: 1) every student works alone, 2) students work in small (two-three people) groups and 3) students work in larger groups (the applicability of mode 3 depends on the number of students).
 04-GF-S2-1114_2
Form of teaching Student's own work Assessment of the learning outcomes
Type Description (including teaching methods) Number of hours Description Number of hours
lecture [04-GF-S2-1114_fs_1]
The lecture part of this course will focus on theory of data bases with an emphasis on geological models and its different types. Examples of practical application of geosciences data in industry will be provided.
 10
Students will be encourage to further explore the topics discussed during the lectures. Students willing to further built on the information provided during the lecture and expand their knowledge will have an opportunity to do so by reaching to literature and rich online resources. The lecturer will provide some guidelines on ''where to look'' and which freeware software can be targeted as a potential educational aid.
 15 Short essay [04-GF-S2-1114_w_1]
laboratory classes [04-GF-S2-1114_fs_2]
Students work with computers.
 30
Students use software to prepare examples of simple geological models. Two methods are used: ''graphic'' and ''data-base-first'' in order to make students familiar with advantages of work with data bases. Students work with data bases -- they populate their own data base with data, visualize the data, they export and import the data, they work with various software. Students cooperate and exchange data/data sets.
 45 Project [04-GF-S2-1114_w_2]
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)