Objectives

The main objective of this course is to provide the student with the theoretical foundations, supported by appropriate basic technical skills, in relation to the thematic area known as Information and Communication Technology (ICT). In particular, during the course, the student will have the opportunity to learn essential knowledge concerning: the development of new technologies (including, hardware architectures, operating systems, media manipulation, good practices in design, multimodal interfaces and information systems); the storage and management of data and information (including, the creation and manipulation of databases, descriptive models, data integrity and query languages); the semantic analysis of data (including, programming principles and artificial intelligence techniques); computer networks (including, topologies, models, architectures, cloud services, routing algorithms and security); and, finally, the creation of WEB sites and portals by popular Content Management Systems (CMSs).
Specifically, the main purposes of the proposed course can be detailed as follows:
1. At the end of the course, the student will have acquired the theoretical foundations related to the thematic area known as ICT. In particular, the student will have acquired full knowledge of the technological tools that are nowadays used in any corporate (e.g., company, factory, industry). Moreover, the student will have acquired full knowledge about the opportunities offered by the latest technologies to support specific application fields (e.g., manufacturing, management, commercial). In addition, the student will have acquired full knowledge about the ability to manage digital data and information in any working cycle. Finally, the student will have acquired adequate technical skills for the basic manipulation of both technological tools and related digital resources.
2. At the end of the course, the student will know how to relate with the most recent human-computer interfaces existing today; the student will also know how to relate with the most common tools that drive the current corporates (i.e., management information systems); the student, in addition, will know how to use the basic functionalities of some of the most widespread tools in the ICT field (i.e., database querying language, content management systems). Finally, the student will be also able to use the basic concepts and constructs for the deep data analysis (i.e., machine / deep learning, programming scripts in MATLAB).
3. At the end of the course, through group activities aimed to develop both a database and a mini-site for the management of a small enterprise, as well as, through additional teaching materials (e.g., sites, free digital documents), the student will have acquired adequate skills to autonomously select the most appropriate technological tools, the most appropriate information content, and the most effective type of data analysis for the solution of a specific case study.
4. At the end of the course, the student will be able to communicate, with appropriate language and updated with respect to the current state-of-the-art, the acquired skills and experiences in the ICT field.
5. At the end of the course, the student will have acquired both a basic technical skill and an excellent cultural baggage, to be able to continue the study of the acquired topics in an autonomous way.

Channels

1

DANILO AVOLA DANILO AVOLA   Teacher profile

Programme

The course is made up by 72 hours and it is divided into three modules (i.e., Module A, Module B, and Module C) each one made up by 24 hours. This division allows students to be focalized on the three main aspects of the thematic area known as Information and Communication Technology (ICT). In particular:

In Module A (24 hours), students are provided with basic knowledge concerning both the architectural aspects of computers (hardware and software) and the information management, with particular reference to the digital information, such as numerical data, images, and videos. Specifically, students are provided with basic knowledge about: the Von Neumann model (architectural principles, didactic model, numerical codes, basic components, processing cycle, firmware, drivers); operating systems (architectural principles, basic features, operation and management of layers, details on the kernel, examples of different operating systems, peripherals, applications, services); digital resources (features, text/hypertext, raster/vector images, videos, audio); usability (Nielsen and Norman principles); information systems (DSS, MIS, EDP); human-machine interaction (human-to-human communication, uni-modal/multi-modal communication).

In Module B (24 hours), students are provided with basic knowledge about the databases and their applications. Specifically, students are provided with basic knowledge about: databases (data and information features, computer systems, theoretical models, type of databases); the E/R model (features, E/R model elements, set theory, ennuples, attributes, domains, tabular forms); data integrity (features, functional dependencies, primary/secondary keys, over-keys, normal forms, case of studies); the E/R diagram (features, graphical representation of the elements, cardinality of the relationships, attribute types, simplified tabular representation, case of studies); the SQL language (features, creation and population of tables, manipulation of tables, creation of relationships, requests for data and information: Query).

In Module C (24 hours), students are provided with basic knowledge about computer networks and their applications. Specifically, students are provided with basic knowledge about: computer networks (general information, network elements (host, media, intermediate devices), connection types, main communication systems), network types (general, physical networks, logical networks), encapsulation and decapsulation (features, multiplexing, segmentation), ISO/OSI model and TCP/IP architecture (definitions, correlation with encapsulation/decapsulation), levels (level 1 (types of Media), level 2 (logical structure, MAC addresses, ARP protocol), level 3 (IP addressing, internet protocol, broadcast and collision domains), level 4 (ports, TCP, UDP), levels 5 up to 7 (features, applications , examples)); cloud service (definitions, examples); routing algorithms (definitions, protocols, architectures); security (features, malware, attacks, cryptography); CMS and WEB sites (general information, operating principles); graphical interfaces (features, principles of efficient design).

Adopted texts

MODULE A:
“Struttura e Progetto dei Calcolatori”, D.A. Patterson, J.L. Hennessy (5° Edizione, 2015).
Lecture notes written by the teacher related to the Module A (i.e., slides PowerPoint).

MODULE B:
“Basi di Dati”, di P. Atzeni, S. Ceri (McGraw-Hill Education, 2014).
Lecture notes written by the teacher related to the Module B (i.e., slides PowerPoint).

MODULE C:
“Reti di Calcolatori”, L.L Peterson, B.S. Davie, M. Dalpasso (3° Edizione, 2012).
Lecture notes written by the teacher related to the Module C (i.e., slides PowerPoint).

Bibliography

Bibliography references are Present at the end of each slide provided by the teacher.

Prerequisites

To learn the content of the course of study no special prerequisite is necessary, since it is delivered gradually: starting from the basics up to the most advanced concepts.

Study modes

The course, consisting of 72 hours, is divided into three modules, each one of 24 hours. In particular: -) Module A: Computer Architecture and Information Management. -) Module B: Databases and Applications. -) Module C: Computer Networks and Applications. The course is provided by lectures. The student is stimulated to learn by the use of attractive teaching material, such as: PowerPoint presentations, diagrams/graphics, animations, and videos. In addition, each lesson includes one or more references to additional teaching material (e.g., websites, simulators, documents in PDF format) that can be used by students as in-depth analysis of the covered topics. Within the 24 hours that make up each module, 7 hours are reserved for exercises/simulations performed by workgroups and 3 hours are reserved for the analysis of case studies illustrated by the teacher. The course is also supported by the participation of all students in a closed social group (Facebook) entirely managed by the teacher, by which students can expose doubts/solutions, find educational material, communicate with the teacher in continuous way. In consideration of the Covid-19 emergency and with reference to the evolution of governmental provisions and health authorities, the course or its parts may also be carried out remotely or in a mixed mode (in presence and at a distance), however ensuring on occasions in presence compliance with safety standards.

Exam modes

The evaluation of the students is performed by a written examination structures as follows:

-) 30 multiple choice questions (ten questions for each of the three modules that make up the course). The questions are referred both theoretical concepts and exercises to cross-check the students' ability to apply the acquired knowledge for the resolution of the various topics covered during the course.

-) 3 open questions (one question for each of the three modules that make up the course). The questions are focused on main concepts of the course, moreover they intend to assess, in subjective way, students' skills in solving technical/practical/descriptive problems.

In periods of emergency, such as that due to COVID-19 in the 2020/2021 Academic Year, following the indications of the University; exams can be moved to a digital platform such as Exam.net.

Exam reservation date start Exam reservation date end Exam date
28/12/2020 03/01/2021 11/01/2021
11/01/2021 17/01/2021 25/01/2021
25/01/2021 31/01/2021 08/02/2021
05/04/2021 11/04/2021 19/04/2021
03/05/2021 09/05/2021 07/06/2021
17/05/2021 23/05/2021 21/06/2021
31/05/2021 06/06/2021 05/07/2021
09/08/2021 15/08/2021 13/09/2021
06/09/2021 12/09/2021 11/10/2021
06/12/2021 12/12/2021 10/01/2022
01/01/2022 09/01/2022 24/01/2022

2

MARCO RAOUL MARINI MARCO RAOUL MARINI   Teacher profile

Programme

The course is made up by 72 hours and it is divided into three modules (i.e., Module A, Module B, and Module C) each one made up by 24 hours. This division allows students to be focalized on the three main aspects of the thematic area known as Information and Communication Technology (ICT). In particular:
In Module A (24 hours), students are provided with basic knowledge concerning both the architectural aspects of computers (hardware and software) and the information management, with particular reference to the digital information, such as numerical data, images, and videos. Specifically, students are provided with basic knowledge about: the Von Neumann model (architectural principles, didactic model, numerical codes, basic components, processing cycle, firmware, drivers); operating systems (architectural principles, basic features, operation and management of layers, details on the kernel, examples of different operating systems, peripherals, applications, services); digital resources (features, text/hypertext, raster/vector images, videos, audio); usability (Nielsen and Norman principles); information systems (DSS, MIS, EDP); human-machine interaction (human-to-human communication, uni-modal/multi-modal communication).
In Module B (24 hours), students are provided with basic knowledge about the databases and their applications. Specifically, students are provided with basic knowledge about: databases (data and information features, computer systems, theoretical models, type of databases); the E/R model (features, E/R model elements, set theory, ennuples, attributes, domains, tabular forms); data integrity (features, functional dependencies, primary/secondary keys, over-keys, normal forms, case of studies); the E/R diagram (features, graphical representation of the elements, cardinality of the relationships, attribute types, simplified tabular representation, case of studies); the SQL language (features, creation and population of tables, manipulation of tables, creation of relationships, requests for data and information: Query).
In Module C (24 hours), students are provided with basic knowledge about computer networks and their applications. Specifically, students are provided with basic knowledge about: computer networks (general information, network elements (host, media, intermediate devices), connection types, main communication systems), network types (general, physical networks, logical networks), encapsulation and decapsulation (features, multiplexing, segmentation), ISO/OSI model and TCP/IP architecture (definitions, correlation with encapsulation/decapsulation), levels (level 1 (types of Media), level 2 (logical structure, MAC addresses, ARP protocol), level 3 (IP addressing, internet protocol, broadcast and collision domains), level 4 (ports, TCP, UDP), levels 5 up to 7 (features, applications , examples)); cloud service (definitions, examples); routing algorithms (definitions, protocols, architectures); security (features, malware, attacks, cryptography); CMS and WEB sites (general information, operating principles); graphical interfaces (features, principles of efficient design).

Adopted texts

MODULE A:
“Struttura e Progetto dei Calcolatori”, D.A. Patterson, J.L. Hennessy (5° Edizione, 2015).
Lecture notes written by the teacher related to the Module A (i.e., slides PowerPoint).
MODULE B:
“Basi di Dati”, di P. Atzeni, S. Ceri (McGraw-Hill Education, 2014).
Lecture notes written by the teacher related to the Module B (i.e., slides PowerPoint).
MODULE C:
“Reti di Calcolatori”, L.L Peterson, B.S. Davie, M. Dalpasso (3° Edizione, 2012).
Lecture notes written by the teacher related to the Module C (i.e., slides PowerPoint).

Bibliography

Bibliography references are Present at the end of each slide provided by the teacher.

Prerequisites

To learn the content of the course of study no special prerequisite is necessary, since it is delivered gradually: starting from the basics up to the most advanced concepts.

Study modes

The course, consisting of 72 hours, is divided into three modules, each one of 24 hours. In particular: -) Module A: Computer Architecture and Information Management. -) Module B: Databases and Applications. -) Module C: Computer Networks and Applications. The course is provided by lectures. The student is stimulated to learn by the use of attractive teaching material, such as: PowerPoint presentations, diagrams/graphics, animations, and videos. In addition, each lesson includes one or more references to additional teaching material (e.g., websites, simulators, documents in PDF format) that can be used by students as in-depth analysis of the covered topics. Within the 24 hours that make up each module, 7 hours are reserved for exercises/simulations performed by workgroups and 3 hours are reserved for the analysis of case studies illustrated by the teacher. The course is also supported by the participation of all students in a closed social group (Facebook) entirely managed by the teacher, by which students can expose doubts/solutions, find educational material, communicate with the teacher in continuous way. In periods of emergency, such as that due to COVID-19 in the 2019/2020 Academic Year, following the indications of the University; lessons can be moved to a digital platform such as Meet.

Exam modes

The evaluation of the students is performed by a written examination structures as follows:
-) 30 multiple choice questions (ten questions for each of the three modules that make up the course). The questions are referred both theoretical concepts and exercises to cross-check the students' ability to apply the acquired knowledge for the resolution of the various topics covered during the course.
-) 3 open questions (one question for each of the three modules that make up the course). The questions are focused on main concepts of the course, moreover they intend to assess, in subjective way, students' skills in solving technical/practical/descriptive problems.
In periods of emergency, such as that due to COVID-19 in the 2019/2020 Academic Year, following the indications of the University; exams can be moved to a digital platform such as Exam.net.

Exam reservation date start Exam reservation date end Exam date
28/12/2020 03/01/2021 11/01/2021
11/01/2021 17/01/2021 25/01/2021
25/01/2021 31/01/2021 08/02/2021
05/04/2021 11/04/2021 19/04/2021
03/05/2021 09/05/2021 07/06/2021
17/05/2021 23/05/2021 21/06/2021
31/05/2021 06/06/2021 05/07/2021
09/08/2021 15/08/2021 13/09/2021
06/09/2021 12/09/2021 11/10/2021
06/12/2021 12/12/2021 10/01/2022
01/01/2022 09/01/2022 24/01/2022
Course sheet
  • Academic year: 2020/2021
  • Curriculum: Curriculum unico
  • Year: First year
  • Semester: First semester
  • SSD: INF/01
  • CFU: 9
Activities
  • Attività formative di base
  • Ambito disciplinare: Discipline semiotiche, linguistiche e informatiche
  • Lecture (Hours): 72
  • CFU: 9.00
  • SSD: INF/01