280.114 Computer Assisted Data Analysis
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2021S, VU, 4.0h, 5.0EC
TUWEL

Properties

  • Semester hours: 4.0
  • Credits: 5.0
  • Type: VU Lecture and Exercise
  • Format: Hybrid

Learning outcomes

After successful completion of the course, students are able to...

... process, analyse and visualise spatially and planning based data.
... process questions relevant for planning and to elaborate on them using adequate software.

Subject of course

The course is devided in two thematic sections.

First thematic section – spreadsheet analysis and data processing
The course is initially concentrating on practice-oriented transfer of knowledge about the application of spreadsheet softwares. The students get to know the different tools for analysis of planning based data by using the widespread software MS-Excel. On the basis of these functions and tools, can then be considered examples of planning based data acquisition, preparation, analysis and visualisation. The aim of the course is getting know different approaches to questions of content and answering these questions based on analysis and evaluation. The examination mode is based on two computer-based test. First interim test: Application of learned tools and functions. Second interim test: Processing questions of content independently and creatively

Second thematic section – analysis and visualisation of spatially based data
The second thematic section is about the preparation and analysis of spatially based data by using statistics software (SPSS) and geo-information software (QGIS). Related with the presented methods and software tools, the students have to analyse the accessibility of public transport stations in vienna. This task must be processed in groups of two. The examination mode is based on a report on results in form of spreadsheets, maps, diagrams and analysis texts.


Teaching methods

- practice-oriented introduction to the use of spreadsheet software through lectures
- Independent solving of exercises with the support of tutors
- project work

Mode of examination

Immanent

Additional information

Bring your own - if available - notebooks with working MS Excel.

Software downloads:
Microsoft Excel via TU.IT: http://www.sss.tuwien.ac.at/sss/ofc/
SPSS via TU.IT: http://www.sss.tuwien.ac.at/sss/sps/
QGIS: https://www.qgis.org/de/site/forusers/download.html (independent QGIS-Installation Version 3.16)

It is absolutely necessary to come to the preliminary discussion on 02. March 2020 at 16:30 at Hörsaal W4 ("Alte WU").

All necessary documents are available in TUWEL.

 

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Mon16:30 - 17:3001.03.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Kick-Off
Mon10:00 - 13:0008.03.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Grundlegende Konzepte 1
Mon10:00 - 13:0015.03.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Grundlegende Konzepte 2
Mon10:00 - 13:0022.03.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Diagramme
Mon10:00 - 13:0012.04.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Suchfunktionen
Mon09:45 - 13:0019.04.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Mehrfachoperation, Pivot & Datum
Mon10:00 - 13:0026.04.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Datenaufbereitung & Datenanalyse 1
Mon10:00 - 13:0003.05.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Datenaufbereitung & Datenanalyse 2
Mon10:00 - 13:0010.05.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Datenaufbereitung & Datenanalyse 3
Mon07:00 - 13:0017.05.2021 Skriptum Einheit 9: Selbststudium (kein Livestream!)SPSS: Grundfunktionen Selbststudium (kein Livestream!)
Mon10:00 - 13:0031.05.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Räumliche Analyse mit SPSS 1
Mon10:00 - 13:0007.06.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Räumliche Analyse mit SPSS 2
Mon10:00 - 13:0014.06.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Thematische Kartographie mit QGIS 1
Mon10:00 - 13:0021.06.2021 via ZOOM: https://tuwien.zoom.us/j/99446681097?pwd=Q0FuclkzUUVMcUV1dURQZ0dIVzJLdz09 (LIVE)Thematische Kartographie mit QGIS 2

Examination modalities

This course has an immanent mode of examination.

The examination mode for the first thematic block is based on two intermediate tests, each of which has to be solved independently on a computer at the EDV-Labor. Both tests have to be completed with a positive score. Basically, attendance at the intermediate tests is compulsory - please make a note on the dates early on! For proven excuses and those who haven't scored enough points on one of the two tests, there is a replacement test.

The examination mode for the second thematic block is based on a report on a spatial-analytical content-related question, which is elaborated in groups of two.

Detailed assessment criteria will be presented during the Kick-Off session and will then be available via TISS.

For all those students, who received a negative grade last year, but had a positive score on one of the two thematic blocks, we offer to credit this positively completed part from last year (but not from any other previous term). However, officially the whole course has to be taken again - thus, please register in TISS as usually and participate at the kick-off session - or write an email to Florian Pühringer latest until 02.03.2021 10 am!

Attention! This solution as a gesture of goodwill is set to end in SS2020.

Group dates

GroupDayTimeDateLocationDescription
Übungsbetreuung: EDV-Labor - FernzugriffMon14:00 - 17:0008.03.2021 - 28.06.2021 via Fernzugriff und Zoom - Siehe TUWELCDA Übungsbetreuung - Fernzugriff EDV-Labor
Übungsbetreuung: Eigener Laptop/PCMon14:00 - 17:0008.03.2021 - 28.06.2021 Zoom - Siehe TUWELCDA Übungsbetreuung - Übungsbetreuung: Eigener Laptop/PC

Course registration

Begin End Deregistration end
01.02.2021 15:00 08.03.2021 20:00 08.03.2021 23:59

Group Registration

GroupRegistration FromTo
Übungsbetreuung: EDV-Labor - Fernzugriff01.03.2021 17:0008.03.2021 13:00
Übungsbetreuung: Eigener Laptop/PC01.03.2021 17:0008.03.2021 12:00

Curricula

Study CodeObligationSemesterPrecon.Info
033 240 Spatial Planning Mandatory2. Semester

Literature

No lecture notes are available.

Previous knowledge

Basic knowledge on Microsoft Windows operating system.

Continuative courses

Language

German