After completing this module, students will be able to handle important work-related skills that are also relevant for the practical semester. They can use the Scrum process model to manage projects and work in corresponding Scrum teams. They master techniques for the professional creation of scientific documents, can prepare data in a targeted manner and visualise their findings in an appealing way using modern presentation tools.
This course deals with the general handling of MS Office products and gives specifically an introduction to the main functions of MS-Excel. Topics include input methods, formulas, chart depictions and search functions. Basic knowledge about the programming in VBA are also taught. These methods will also be used for macro skripts in MS-Word.
Afterwards, the students have learned how to solve typicals problems efficiently with these today's standard programs.
Exercises, programs with solutions and online documentation.
Practical assignment in a computer laboratory.
This lecture deals with the general handling of MS Office products and specifically provides an introduction to the most important functionalities of MS Excel. Students learn, for example, how to use input methods, formulae, diagrams and search functions. Basic knowledge of programming under VBA is also taught. These are then used to create macro scripts in MS Word.
The focus is on the efficient use of MS Office products. Participating students are then able to quickly solve typical tasks.
Lecture notes
The course consists of a lecture (50%) and supervised practical exercises (50%).