Corso di Laurea Magistrale Interateneo in Geografia e Scienze Territoriali (LM-80)

The ECDLGIS Preparation Laboratory aims to prepare the student to face all the topics listed in the AICA Syllabus for passing the ECDLGIS. Specialist certification called "European Computer Driver License - Geographic Information System " ECDL GIS certification is aimed at:
- Those who wish to demonstrate to have a robust knowledge of basic principles governing the GI techniques and their basic use through a specific software;

- Those who wish to have evidence that GIS users have certificated basic competences.

In the Italian reality in particular, the certification is aimed at:

• to those who wish to have official national and international recognition of their skills in the GIS sector in general and in the basic use of a specific software;

• to schools and study programs that intend to provide students with an additional one professional and technical competence and a recognized professional qualification for entering the world of work;

• to public and similar bodies that require objective certification of the basic knowledge and operational skills of their employees employed in various capacities and with various tasks in the use of GIS and territorial data;
• to private companies operating in various sectors, from that of GIS to that of technological networks, which intend to make use of personnel with an objective definition of knowledge.

This laboratory allows you to take the first two modules of the GIS certification, the overall passing of which leads to the achievement of the certification.

The first two modules are theoretical.

More precisely, the topics covered are:

Module 1- Cartographic representation: Verify the knowledge of cartographic representation in GIS, starting from the fundamentals of geodesics, topography and cartography.

Module 2 - GIS Systems: Verify the knowledge of GIS components, from raster data to vector data, to the process of modeling reality in territorial information systems, to the concept of topology, to spatial analysis

AICA syllabus

Module 1

1.1 General concepts 1.1.1 Shape of the earth, physical surface and reference surfaces 1.1.1.1 To know which are the shapes with which the earth is approximated and to know the relative dimensional parameters.
1.1.1.2 Know what is meant by the earth's surface, geoid surface, ellipsoidal surface, local sphere.
1.1.2 Reference systems and datums 1.1.2.1 Know what planimetric datums and datums are altimetric.
1.1.2.2 Know what are the fundamental aspects of planimetric reference systems (ellipsoid of rotation, point of emanation, deviation from the vertical).

1.1.2.3 Know what are the fundamental aspects of altimetric reference systems, know the meaning of orthometric height and ellipsoidal height.

1.1.3 Coordinates on curved and flat support 1.1.3.1 Know the meaning of latitude, longitude and altitude above sea level.

1.1.3.2 Know the fundamental aspects and the differences between the different coordinates on a curved support (spherical, ellipsoidal, geoidic, astronomical, geocentric coordinates).

1.2 Classification of 1.2.1 Classification by type of 1.2.1.1 Know the meaning of equivalent, compliant, equidistant card.

1.2.2 Classification by scale of representation 1.2.2.1 Know the meaning of very large, large, medium, small and very small scale.

1.2.2.2 (*) Know, with reference to the scale, the meaning of technical map, topographic, chorographic map, geographical map and cadastral map.

1.2.3 Classification by type of projection 1.2.3.1 Know the differences between projections perspectives and projections for development.

1.2.3.2 Know the main types of projections.

1.2.4 Classification by genesis 1.2.4.1 Know the meaning of detected maps and derived maps.

1.2.4.2 Know the concept of cartographic generalization.

1.2.5 Classification by content 1.2.5.1 Know the difference between basic cards and cards thematic.

1.2.5.2 Knowing how to distinguish the information contents of the basic and thematic maps.

1.2.6 Classification by use 1.2.6.1 Knowing how to distinguish the different types of cartography with respect to use.

1.3 International cartography, European cartography and national cartography 1.3.1 Cartography international 1.3.1.1 Know the fundamental aspects of the UTM (Universal Transverse Mercator) system.

1.3.1.2 Know the fundamental aspects of the WGS84 system.

1.3.2 European cartography 1.3.2.1 Know the fundamental aspects of the ETRF89 system.

1.3.2.2 Know the fundamental aspects of the UTM ED50 system (ellipsoid and orientation).

1.3.3 National cartography (*) 1.3.3.1 Know which are the cartographic organs of the State.

1.3.3.2 Know the fundamental aspects of cadastral cartography (ellipsoid, orientation, Cassini-Soldner and Gauss-Boaga cartographic representation, fiducial points), cutting of the cartography.

1.3.3.3 Know the fundamental aspects of "Roma40 Gauss-Boaga" cartography (ellipsoid, orientation, conformal cartographic representation of Gauss), cutting of the cartography.

1.3.3.4 Know the fundamental aspects of the Italian cartography UTM ED50 (system of reference: ellipsoid, orientation, coordinates and map cutting).

1.3.3.5 Know what is meant by IGM95 network.

1.3.3.6 Know what is meant by Regional Technical Charter (CTR).

1.3.4 Transformation and conversion of cartographic coordinates 1.3.4.1 Know the meaning of the term Coordinate Conversion.

1.3.4.2 Know the meaning of the term Coordinate Transformation.

1.3.5 Metric and positioning elements, quoted points, isoipse 1.3.5.1 Knowing how to operate at different scales of representation, such as measurements of lengths, of surfaces.

1.3.5.2 Know how the quotas are represented (quoted points and isoipse).

1.4 Data quality 1.4.1 Fundamental aspects 1.4.1.1 Know the meaning of the terms Completeness, Logical Consistency, Positional Accuracy, Temporal Accuracy, Thematic Accuracy, Lineage.

1.4.2 Metadata for map data 1.4.2.1 Know what metadata is and what aspects it should primarily contain.

1.4.2.2 Know what the metadata standards are for geographic information.

1.5 Digital Elevation Models 1.5.1 Digital Elevation Models 1.5.1.1 Know what Digital Elevation Models are, and how they are built.

1.6 Global Positiong System (GPS) 1.6.1 Global Positiong System (GPS) 1.6.1.1 Know the operating principle of the Global Positioning System (GPS) and its use within GIS (SIT).

Module 2: GIS

2.1 Introduction to GIS (SIT) 2.1.1 Concepts and basic knowledge 2.1.1.1 Know the term and concept of GIS (SIT).

2.1.1.2 Know what differentiates GIS (SIT) from Information Systems in general.

2.1.1.3 Know the main application areas of GIS (SIT).

2.1.1.4 Know and be able to distinguish the components of a GIS (SIT).

2.1.1.5 Know the main functions of a GIS (SIT).

2.1.2 Peripherals and characteristic file types in GIS (SIT) 2.1.2.1 Know the specific input peripherals used in GIS (SIT) and the salient technical characteristics that differentiate them (where applicable depending on the device: resolution, accuracy, range colors, connection methods, management and use).

2.1.2.2 Recognize the most common file types used in GIS (SIT) and which category they belong to (vector or raster).

2.1.3 Data and data sources in GIS (SIT) 2.1.3.1 Knowing how to distinguish the types of data used in GIS (SIT).

2.1.3.2 Recognize the main data sources usable in GIS (SIT), such as: remote sensing data, Cadastre, paper and digital maps, socio-economic data.

2.1.3.3 Know the concept of spatial data.

2.1.3.4 Knowing how to identify the various types of attributes (such as nominal, ordinal, interval, ratio or ratio).

2.1.3.5 Know the main types of geographic data formats (such as coverage, geodatabase,

shapefile, grid, dxf, dwg, geotiff, GML).

2.1.4 The scale in GIS (SIT) 2.1.4.1 Knowing the concept of scale in GIS (SIT).

2.1.5 Georeferencing 2.1.5.1 Know the concept of georeferencing.

2.1.5.2 Know how to georeference raster data.

2.1.5.3 Know how a raster data georeferencing file works (World File).

2.2 The Data Model 2.2.1 Reality Modeling 2.2.1.1 Know what the data model is.

2.2.1.2 Learn about the process of creating a data model.

2.2.1.3 Know the concepts of conceptual model, logical model, physical model.

2.2.2 Continuous and discrete representation of Reality 2.2.2.1 Knowing the representation of reality through the Vector Model.

2.2.2.2 Knowing the representation of reality through the Raster Model.

2.2.3 Topology 2.2.3.1 Know the concept of topology.

2.2.3.2 Know the concepts of adjacency, connectivity and "definition of area" (Containment).

2.2.3.3 Knowing how to distinguish the terms spaghetti vector data structure (or CAD) and topological vector data structure.
2.2.3.4 Know the topological relationships of raster data (essentially based on the concept of adjacency / proximity).
2.3 DBMS 2.3.1 DBMS and GIS (SIT) 2.3.1.1 Know what a DBMS is.
2.3.1.2 Know the logical structures of DBMS in GIS (SIT).
2.3.1.3 Know the main operations on the data contained in a DBMS (selection, insertion, updating, elimination).
2.4 Data analysis 2.4.1 Spatial analysis 2.4.1.1 Know the typical spatial analyzes on raster data.
2.4.1.2 Know the typical spatial analyzes on vector data on a single information layer.
2.4.1.3 Know the typical spatial analyzes on vector data on multiple information layers
2.4.1.4 Knowing how to distinguish the procedures for calculating distances and areas in the vector and raster model.
2.4.2 Analysis based on attributes 2.4.2.1 Know the process of selecting objects according to attributes.
2.4.2.2 Know the usefulness of relationships and links between tables.
2.4.2.3 Know the main elements of statistics, such as concepts of mean, standard deviation, least squares, standard deviation.
2.4.2.4 Knowing how to distinguish the main classification methods (such as quantiles, standard deviation, natural interruptions).
2.5 Thematic cartography 2.5.1 The thematic representation 2.5.1.1 Knowing how to define the term thematic map.
2.5.1.2 Knowing how to list the fundamental elements of a thematic map.
2.5.1.3 Knowing how to distinguish the types of thematic maps (such as choropletes, isopletes, proportional symbols, density of points).
2.5.1.4 Understand the terms of quantitative and qualitative maps.

This course will be based on traditional lessons. Detailed information will be provided by the teacher mostly based on the public health recommendations.

Sample Test at the end of the laboratory To obtain the certification it is necessary to purchase a - Skill Card - on which the exams passed will be recorded.

The exams take place in presence except as provided by the Rectoral Decrees available at the following link https://www.unito.it/ateneo/gli-speciali/coronavirus-aggiornamenti-la-comunita-universitaria/disposizioni-chi-studia-e