General Studies: Basic Digital Skills

Language: English
Lecturer: Dr. Marc Stockmeier

In this course you will create a template for your bachelor or master thesis. All steps will be worked on by all students on their own document in individual work or in groups.

1. Provide foundations for common language and basic knowledge

Start MS Word and customize user interface

• Basic privacy settings
• Different software views/document views
• Ribbon
• Help function

2. Create your own standard format template

• Font
• Line spacing
• Paragraph spacing

3. Preparation for the automatic creation of

• Table of Contents
• List of Figures
• List of tables

4. Customizing the style sheets for headings

5. T Charts and chart headings

• Create quick commands to create charts with chart header
• Customizing the style sheets

6. Figure and figure captions

• Creating quick commands for creating figures with figure captions
• Customizing the style sheets

7. Creating a title page

8. Footnotes 

• Customizing the style sheets
• General rules of typesetting footnotes

9. Literature management and bibliography

• Citation methods
• Manage Citations with Citavi (Attention: Apple users can only use Citaviweb)

Language: English
Lecturer: Dr. Marc Stockmeier

Part 1

• Powerpoint, simple basic terms
• The user interface
• Basics for creating presentations
  • Working with text (lists and tables)
  • Working with shapes
  • Working wits objects (tables from Excel, Graphics)

Part 2

• Create presentation
  • Important presets
• Master slides
• SmartArt and SmartArt tools
• Transitions and animations
• Using and adapting design templates

Part 3

• Link slides to each other
• Slide transitions
• Prepare and deliver presentations
• Printing of presentations, handouts and note pages
• Tools during the presentation

Part 4

• Creating a presentation on the individual field of study
• Short presentation of the individual participants 

Please note that the topics of the individual dates can be postponed depending on the needs of the participants. 

Language: English
Lecturer: Dr. Marc Stockmeier

Part 1

• Basics and basic functions
• Working with workbooks
• Design of workbooks (headers/footers)
• Formulas and functions
• Use of formulas
• Evaluating table data with simple functions (SUM, AVERAGE, NUMBER, ...)
• Overview and use of some functions

Part 2

• Formulas and functions
  • relative/absolute addressing
  • if/then links
  • SREFERENCE/REFERENCE

• Working with diagrams
  • Create diagrams
  • Diagram types
  • Labels
  • trend lines
  • Error bars

Part 3

• Data analysis with pivot charts
  • Pivot charts
  • Pivot diagrams

Part 4

• Evaluation of simple experiments/data sets with Excel

Please note that topics may be shifted depending on the needs of the participants.