Energy, Mobility and Environmental Management

Applied Computer Science I

Integrated course, 3.00 ECTS

 

Course content

This integrated course provides an introduction to using office software for handling larger datasets. Real-life measurement data are used to carry out data manipulations, calculations, evaluations and simple programming exercises. The structure and applications of databases will also be explained.

Learning outcomes

The student learn: Word:
Wh .: styles
Wh .: Automatic numbering of figures and tables Excel:
Wh .: Diagrams, formula creation, absolute / relative cell references, ...
Custom cell formatting
Special functions: for date / time, text manipulation, V-reference, ...
Multiple nested functions
Named cells, name manager
Excel as "" database "":
Dealing with large amounts of data
Sort and filter
Pivot tables
Web queries
Target value search
Scenario manager
Solver
VBA macro programming with Excel
Wh .: table of contents, figures, tables, references
Create and use your own document templates
Fields
Cross references
Create formulas
Access (database program):
Terms: database, data record, field
Create tables, set field names, data types, primary keys
Build queries with different criteria

Recommended or required reading and other learning resources / tools

Books: Mortimer: Chemie, Thieme Verlag; Atkins: Chemie einfach Alles, VCH –Verlag; Gumm/Sommer: Einführung in die Informatik, Oldenbourg Verlag; Vonhoegen: Excel 2016 - Der umfassende Ratgeber, Vierfarben; Timischl/Kaiser: Ingenieur-Mathematik, E. Dorner; Langemann/Sommer: So einfach ist Mathematik, Springer Spektrum; Rießinger: Mathematik für Ingenieure, Springer; Rooch: Statistik für Ingenieure; Springer Spektrum; Kreyszig: Advanced Engineering Mathematics, Wiley; Wagner/Reischl/Steiner: Einführung in die Physik, facultas.wuv
Journals:

Mode of delivery

1 ECTS lectures, 1 ECTS exercises

Prerequisites and co-requisites

Secondary school leaving level

Assessment methods and criteria

final exam