G1161 Practical introduction to MS Office for geologists

Faculty of Science
Autumn 2024
Extent and Intensity
0/1/0. 1 credit(s). Type of Completion: z (credit).
In-person direct teaching
Teacher(s)
Mgr. Marek Lang, Ph.D. (lecturer)
Mgr. Jakub Haifler, Ph.D. (lecturer)
Guaranteed by
Mgr. Marek Lang, 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
Timetable
Mon 14:00–14:50 Gl,02011
Prerequisites
NOW( G0101 Occupational healt and safety ) && NOW( C7777 Handling chemical substances )
The course is suitable for students with little or no experience with MS Office programs.
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 20 student(s).
Current registration and enrolment status: enrolled: 1/20, only registered: 0/20
fields of study / plans the course is directly associated with
there are 24 fields of study the course is directly associated with, display
Course objectives
Aim of the course is to acquire basic skills for the creation of scientific texts and data visualization in the form of tables and simple charts through the practical examples.
Learning outcomes
After the course, students are able to:
name the basic requirements for the data processing;
apply these procedures to geological data;
create a scientific text that meets basic typographical principles.
Syllabus
  • Individual lectures are focused on direct application of the basic skills in MS Office programs (Excel, Word, PowerPoint) on presented data and text files. The course also includes examples of geological data analysis in more advanced programs.
  • Introduction to the course: Course organization, lecture schedule, conditions of completion, IT services at MU.
  • Excel I: Data import into a table – import of geological data from various sources (paper document, text file, software document) into a simple table and its modification (raw/column inserting, cell merging, data split into columns, data format, cell borders, cell fill).
  • Excel II: More complex tables and dot plot – creation of more complex tables including more time series (data filtering, calculation of a secondary data) and design of a simple dot plot (time series plotting and their formatting, change the chart type of time series, chart axis formatting, chart legend).
  • Excel III: Examples of other chart types - pie chart, column chart, line chart, histograms.
  • Word I: Scientific text I - text formatting (typeface, font sizes, font styles, font color, text alignment, text spacing, text highlighting), numbered and unnumbered lists, object inserting (table, hyperlink, picture, text box, comments).
  • Word II: Scientific text II - document formatting (paragraph format, heading styles, page numbering, document content, references).
  • PowerPoint: Presentation of scientific research - presentation outline, data presentation, inserting of various objects, animations.
  • Examples of more advanced analysis: Basic data analysis in Statistica (data import, correlation analysis, spectral analysis, box plots) and Matlab (contour diagram, pixel map).
  • Final discussion: Preparation of final document, consultation of problems from previous lectures.
Teaching methods
Practical examples with possibility of direct application of discussed issue to the presented data and text files.
Assessment methods
The course is completed by submission of a formatted document containing annotated outputs from individual lectures.
Language of instruction
Czech
Follow-Up Courses
Further Comments
Study Materials
The course is taught annually.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2024/G1161