Data Processing  1 - Applied Computing in Civil Engineering 1 Group B (ILV)


Course lecturer:


 Jörg Störzel

Course numberB1.00000.40.441
Course codeEDV1
Semester of degree program Semester 4
Mode of delivery Presencecourse
ECTS credits1,5
Language of instruction German

The students have basic knowledge and skills in digital data processing needed for visualization and solving of general engineering tasks. Those acquired skills can be applied by implementing engineering use cases in Excel worksheets.

Digital data processing and visualisation using MS Excel und Visio:
Theoretical basics:Input-Processing-Output (+Storage) Model (knowing as IPO+S)Data types and the different ways to process, visualise and storage them First steps into algorithm and their visualisation
Practising by MS Excel:Document management on the basis of meta dataSpreadsheet processingData input, analyse and visualisationArithmetical data operationsUsage of Built-In-FunctionsText data processingTime data operationsLogical operations: comparing/combining and their application in algorithm (conditions)Development of extensive Excel worksheets to automate data processing
Practising by MS Visio:Creation of technical sketches respectively figuresVisualization of algorithm and process via flowcharts

Giessen, Saskia; Nakanishi, Hiroshi (2010): Excel 2010, Formeln und Funktionen; Poing: Franzis-Verl.Fleckenstein, Jens; Fricke, Walter; Georgi, Boris (2006): Excel, Das Zauberbuch; München: Markt & Technik.Held, Bernd; Schels, Ignatz (2004): Excel - geheime Tricks; München: Markt & Technik.Georgi, Boris; Fricke, Walter; Fleckenstein, Jens (2008): Excel - das Rätselbuch; München: Markt & Technik.Kolberg, Michael (2007): Office 2007 Kompakt, komplett, kompetent; München: Markt & Technik.Martin, René (2007): Berechnungen in Excel, Zahlen, Formeln und Funktionen; 4. Aufl.; München: HanserSchels, Ignatz (2005): Excel - Formeln und Funktionen, 400 Beispiele mit Praxislösungen selbst programmieren; München: Markt & Technik.Mewes, Wolfram E. (2010): Excel 2010 Profiwissen; München: Addison-Wesley. (Video-Tutorial)Curio, Johannes (2011): Die Excel 2010 Schulung; München: Markt & Technik. (Video-Tutorial)Martin, René (Composer) (2010): Microsoft Visio 2010 - das Handbuch; Unterschleißheim: Microsoft Press.Martin, René (2010): Visio 2010, Umfassend, praxisorientiert, leicht verständlich; München: Addison Wesley. (Video-Tutorial)

Seminars in small classes (max. 20 attendants) with practice works on computers

Accredited seminar papers and written examination