• DE
  • EN
  • Login
Logo

Faculty of Geosciences
FB5
Faculty of
Geosciences
FB5
    ⌂
  • Faculty
  • Studies
  • Research
  • Organization
  • Public
  • Internal
    • Students
    • Prospective Students
    • Prospective Students
    • Pupils
    • Pupils
    • PhD Students
    • Visitors
    • Employees
☰
  • DE
  • EN
  • Login
Studies
  • 8 Reasons for Studying in Bremen
  • Bachelor Program Geowissenschaften
  • Bachelor Program Marine Geosciences
    • Course Introduction
    • Application for winter semester
    • Application for summer semester
    • Orientation Week
    • Start in
      summer semester
    • Programme structure
    • Courses
    • Field Education
    • Professional Internship
    • Bachelor thesis
    • Thesis
    • Examinations
    • Best Thesis Award
  • Bachelor Program Natural Sciences for Sustainability
  • Master Program Applied Geosciences
  • Master Program Marine Geosciences
  • Master Program Materials Chemistry and Mineralogy
  • Geosciences as Minor Subject
  • International Exchange
  • Doctorate in Geosciences
  • Quality Management
  • Studies 2012
  • ⌂
  • Studies
  • Bachelor Program Marine Geosciences
    • Course Introduction
    • Application for winter semester
    • Application for summer semester
    • Orientation Week
    • Start in summer semester
    • Programme structure
    • Courses
    • Field Education
    • Professional Internship
    • Bachelor thesis
    • Thesis
    • Examinations
    • Best Thesis Award
  • Courses
  • ⌂
  • Studies
  • B.Sc. Marine Geosciences
    • Course Introduction
    • Application for winter semester
    • Application for summer semester
    • Orientation Week
    • Start in summer semester
    • Programme structure
    • Courses
    • Field Education
    • Professional Internship
    • Bachelor thesis
    • Thesis
    • Examinations
    • Best Thesis Award
  • Courses

Data Processing with EXCEL

Lecturers: Gerhard Bartzke, Tilo von Dobeneck

Content:

Data Processing with Spreadsheets: Basic Principles, Data Types, EXCEL Syntax
Import data: convert ASCII to EXCEL formats, format, calibrate and sort data
Visualize data: Select, apply and optimize EXCEL diagram types
Calculate with case-dependence: conditional, logical, and information functions in EXCEL
Select and analyze data: Search, reference and statistics functions in EXCEL
Process geodata sets with EXCEL: Develop adapted solution strategies


Competences:

- numerically and logically process, statistically analyze and graphically display geoscientific data using EXCEL spread-sheet calculation
- develop individual solution strategies for specific tasks in geoscientific data processing and implement suitable algorithms with basic and advanced EXCEL functions


Assessment:

Invidual EXCEL coursework/homework

Exam Form:

assignment

Literature:

1) Own course material and exercise files "EXCEL for Geos" #1 - #6 (Download Stud.IP)
2) Online information on EXCEL

Contents:

1st Day: Data Processing with Spreadsheets: Basic Principles, Data Types, EXCEL Syntax
2nd Day: Import data: convert ASCII to EXCEL formats, format, calibrate and sort data
3rd Day: Visualize data: Select, apply and optimize EXCEL diagram types
4th Day: Calculate with case-dependence: conditional, logical, and information functions in EXCEL
5th Day: Select and analyze data: Search, reference and statistics functions in EXCEL
6th Day:
7th Day:
8th Day:
9th Day:
10th Day:
11th Day:
12th Day:
13th Day:
14th Day:


Teaching Aids:

Notebook-Pool, Tabellenkalkulation mit Excel

back
Basic Data
VAK-Number

05-BMG-GS1-1


Study Program

Bachelor Marine Geosciences


Module Name

Digital Competences


Course Type

block course (BK)


Second Year of Study

1.5 CP

1.5 SWS

Summer Term


Course Language

German and English


Contact Person
­

Marine Geophysics

Prof. Dr. Tilo von Dobeneck

GEO 4120R

Phone: +49 421 218 - 65311

dobeneck@uni-bremen.de

Marine Geophysics

Prof. Dr. Tilo von Dobeneck

GEO 4120R

Phone: +49 421 218 - 65311

dobeneck@uni-bremen.de
Lecturer

­

Prof. Dr. Tilo von Dobeneck

GEO 4120

Phone: +49 421 218 - 65311

dobeneck@uni-bremen.de

Prof. Dr. Tilo von Dobeneck

GEO 4120

Phone: +49 421 218 - 65311

dobeneck@uni-bremen.de
­

Dr. Gerhard Bartzke

MARUM2 3010

Phone: +49 421 218 - 65870

gbartzke@marum.de

Dr. Gerhard Bartzke

MARUM2 3010

Phone: +49 421 218 - 65870

gbartzke@marum.de
back
☰
Contact

Faculty of Geosciences

University of Bremen
Klagenfurter Str. 2-4

28359 Bremen
Germany

Legal Notice
Data Privacy