Unit MATHS FOR DATA MANAGEMENT

Course
Digital tools for the buildings, environment and territory sustainable management
Study-unit Code
A002889
Curriculum
In all curricula
Teacher
Marco Cantarini
CFU
9
Course Regulation
Coorte 2023
Offered
2023/24
Type of study-unit
Obbligatorio (Required)
Type of learning activities
Attività formativa integrata

BASICS OF COMPUTER SCIENCE AND DATA MANAGEMENT

Code A002891
CFU 6
Teacher Giacomo Ortali
Teachers
  • Giacomo Ortali
Hours
  • 54 ore - Giacomo Ortali
Learning activities Base
Area Formazione informatica, matematica e statistica di base
Academic discipline ING-INF/05
Type of study-unit Obbligatorio (Required)
Language of instruction Italian
Contents The course aims to provide knowledge and basic computer skills.
Reference texts - Lecture notes from the teacher;
- Andrew S. Tanenbaum, Architettura dei calcolatori, un approccio strutturale, Pearson Italia Spa, 2006.
- Tony Gaddis, Starting Out with Python (No REVEL or MyLab Programming), 2021.
- Paolo Azteni et al, Basi di dati, McGraw-Hill, 2a edizione, 1999.
Educational objectives Basic knowledge of computer science such as computer architecture, information representation, Von Neumann machine; introduction to the Python language; knowledge of basic notions of data representation models and database query languages.
Prerequisites None
Teaching methods Lectures in the classroom with exercises
Learning verification modality The exam includes a written test with six exercises. The duration of the test is two hours and the exam is aimed at verifying that the student correctly applies the acquired knowledge. The evaluation is in 30/30 and will have a weight of 2/3 on average with the evaluation of the other module.
Extended program - Outline of computer architectures and information representation: binary representation and Von Neumann machine;
- Programming languages: introduction to the Python language;
- Data representation models: relational model;
- Query languages of databases: introduction to the SQL language and examples of queries.

BASICS OF NUMERICAL MATHS

Code A002890
CFU 3
Teacher Marco Cantarini
Teachers
  • Marco Cantarini
Hours
  • 27 ore - Marco Cantarini
Learning activities Base
Area Formazione informatica, matematica e statistica di base
Academic discipline MAT/05
Type of study-unit Obbligatorio (Required)
Language of instruction Italian
Contents The course aims to provide basic mathematics notions and skills.
Reference texts Cristina Marcelli, Analisi Matematica 1, Pearson, 2019.
Educational objectives Knowledge of basic concepts such as functions, limits, derivatives and integrals and ability to apply these concepts in the study of functions.
Prerequisites None
Teaching methods Lectures in the classroom with exercises
Learning verification modality The exam includes a written test with four exercises, one of which is theoretical. The duration of the test is one hour and the exam is aimed at verifying the correct application of the knowledge acquired and the knowledge of fundamental theoretical concepts. The evaluation is in 30/30 and will have a weight of 1/3 on average with the evaluation of the other module.
Extended program - Basic properties of real numbers;
- Functions: definition, properties and elementary functions.
- Limits: definition, limits of sequences and functions, operations, common limits;
- Continuity and differentiability: definitions, points of discontinuity, properties of continuous functions, derivation, points of non-derivability, derivative elementary functions, rules of derivation.
- Applications of differential calculus: fundamental theorems, scheme for the study of functions, optimization problems.
- Integrals: definition, properties, immediate integrals, integration by parts, integration by substitution, division between polynomials.
Condividi su