Themen der Lehrveranstaltung
• Data, Information and Knowledge • Why Data/Information Management is so important today • How computers represent numbers, text, images / colors, sound/music and video • Information systems: concepts, definition and main tasks • Information Systems and Strategic Management • ICT productivity paradox • Information Systems: classification • Issues with Managing the IS Infrastructure • Type of data • DMS • Data analysis and Business Intelligence • DataWarehouse, OLAP tools and Data Mining • Relational databases • Querying Databases using SQL language • SQL – selection queries • SQL – aggregation queries • SQL – Set operations • SQL – Sub Queries • SQL – Outer Joins

Propädeutische Lehrveranstaltungen
None

Unterrichtsform
Front-of-class teaching in standard classroom, Front-of-class teaching in computer lab with examples and exercises assigned in class, interactive exercises in standard classroom and in computer room held by teaching assistant.

Bildungsziele
ILO (Intended Learning Outcomes) ILO 1 Knowledge and understanding: ILO 1.1 basic knowledge of data management and computer programming for statistical and econometric analysis of socio-economic data; ILO 1.2 knowledge of the technical vocabulary of the subjects of this learning area; ILO 2 Ability to apply knowledge and understanding: ILO 2.1 ability to manage simple databases and carry out analysis of socio-economic data with the support of software; ILO 3 Making judgements ILO 3.1 Acquisition of the ability to make judgements and of the methodological tools useful for the critical analysis of data, sources, assumptions and implications of scientific practice, of the political, ethical and legal context within which economic phenomena are set and with which they interact ILO 4 Communication skills: ILO 4.1 Proficiency (oral and written) in Italian, German and English, including translation between these languages. Intercultural competence. Conceptual awareness, synthesis and written expression, in particular in the drafting of scientific or science-based documents ILO 5 Learning skills: ILO 5.1. Promotion of critical thinking and analytical skills that enable one to focus on complex problems in their long-term dynamics and in the variety of their implications, including ethical ones

Bildungsziele und erwartete Lernergebnisse (zus. Informationen)
Knowledge of data management tools and technologies

Art der Prüfung
Assessment is based on a written examination evaluating students’ knowledge and understanding of data management and data analysis concepts (ILO 1.1, ILO 1.2), their ability to apply knowledge to basic database management and data analysis tasks (ILO 2.1), and their capacity to critically evaluate data, methods, and contextual implications (ILO 3.1). The written format also assesses communication skills in English and the appropriate use of technical terminology (ILO 4.1), as well as critical thinking and learning skills through integrated and reflective questions (ILO 5.1). Practical test to assess the organisation, management and editing of data using SQL.

Bewertungskriterien
The grade is the weighted average of the evaluation of the theoretical part (40%) and the practical part (60%), with emphasis on optimal, efficient and extensible solutions. There is no difference in the assessment between attending and non-attending students. Both parts (theory and laboratory) must be passed.

Pflichtliteratur

Keine

Weiterführende Literatur

Keine

Weitere Informationen
None