Program Overview

PRINCIPLES OF DATA PROCESSING AND ANALYSIS

Course Overview

The course aims at learning how to access, model, and manipulate (textual) data by providing concepts of object-oriented programming (Python scripts) and an introduction to data interchange files and databases.

Course Details

• Code: 98920
• Academic Year: 2025/2026
• Credits: 5 cfu anno 1 SAFE TRANSPORT AND LOGISTICS ENGINEERING 11920 (LM-26 R) - GENOVA
• Scientific Disciplinary Sector: ING-INF/05
• Language: English
• Teaching Location: GENOVA
• Semester: 2ｰ Semester
• Modules: This course is a module of ICT FOR TRANSPORT AND LOGISTICS
• Teaching Materials: AULAWEB

Aims and Content

Learning Outcomes

The course aims to provide students with the necessary IT tools to collect, store, manage, and analyze data to be used in the context of transport and logistics systems, with particular emphasis on the development of methodologies to make such systems more efficient, sustainable, and safe.

Aims and Learning Outcomes

At the end of the course, students are able to:

• Abstract informal specifications to design algorithms
• Implement and validate small Python scripts
• Understand, use, and modify code produced by others
• Retrieve information present in relational databases
• Write SQL queries

Teaching Methods

The course is articulated in 45 hours of lectures held in the INFAL2 laboratory. Due to the practical nature of the course, some practical classes are provided during the course; in addition, each theoretical lesson ends with exercises of the concepts introduced.

Syllabus/Content

• Python Fundamentals:
  • Introduction to programming
  • Variables
  • Conditional flow
  • Loops
  • Collections
  • Functions
  • Overview on Object-Oriented Programming
  • Read - Write files
  • Data-interchange formats
• Database Introduction:
  • Entities and keys
  • Relationships
  • From ER to table
• SQL Principles:
  • Single-table queries
  • Multi-table queries
  • Multiset operation and "group by"
  • DB connection to Python scripts

Recommended Reading/Bibliography

All the slides and additional exercise material used during the lectures will be available on AulaWeb. In general, the notes taken during the lectures and the material on AulaWeb are sufficient to prepare for the exam.

Teachers and Exam Board

Exam Board

• FABIO LAVAGETTO (President)
• IGOR BISIO
• KATIA LUPINETTI (President Substitute)

Lessons

Lessons Start

The timetable for this course is available on the Portale EasyAcademy.

Exams

Exam Description

The exam is composed of two parts:

1. A quiz part (10 questions - multiple choices - in 20 minutes) will test the database and SQL knowledge of the students, 1 point for each correct answer will be assigned (no penalty for wrong answers is foreseen).
2. A lab project (2 hours) where students should demonstrate their ability to access data from CSV files, manipulate file content to extract some information, and save the results. Both parts are delivered on AulaWeb. Both parts should be sufficient to pass the exam (6 right answers for the quiz and a grade of 18 for the lab). The final grade is given by the weighted average of the two parts (30% the quiz and 70% the lab).

Assessment Methods

The quiz aims to test the knowledge for accessing information in relational databases and the comprehension of SQL queries; while the lab project tests the acquired scripting knowledge. Students with learning disorders ("Disturbi Specifici di Apprendimento", DSA) will be allowed to use specific modalities and supports that will be determined on a case-by-case basis in agreement with the delegate of the Engineering courses in the Committee for the Inclusion of Students with Disabilities.