Information Technology Skills

Knowledge and understanding        

The COMPUTER AND TELEMATICS SKILLS program, borrowed from the COMPUTER LAB, covers topics that provide students with the skills they need to use the main office software tools confidently and effectively. It involves the study and in-depth analysis, including through laboratory exercises, of the main word processing and spreadsheet software.

Further in-depth study is provided in the processing of digital images and knowledge of the main software tools required by the Digital Administration Code (CAD).

Ability to apply knowledge and understanding

At the end of the course, students will be able to use electronic computers through software tools that also allow the sharing of data and information, with an awareness of the practices and precautions that must be adopted in order to operate safely.

Independent judgment.

At the end of the course, students will be able to independently identify the computer that best meets their needs for producing and sharing digital images, as well as for processing spreadsheets, taking into account security practices in accordance with the European GDPR Regulation.

Communication skills.                  

At the end of the course, students will have mastered the digital tools and technologies for the secure processing of data and information in an administrative context. They will be able to discuss the HW and SW structure of computers and their secure use, including in the production of multimedia content, particularly images.

Learning skills.

At the end of the course, students will be able to independently expand their knowledge of computer science by studying reference texts and reading articles in specialized journals.

Lectures supported by slides provided by the instructor (available on the Studium Web Portal) and classroom exercises illustrating the most commonly used software.

Not mandatory.

However, it is recommended during laboratory exercises.

•  Basic concepts: defines the fundamental concepts and skills relating to hardware and software components, the use of devices, file creation, and network sharing management.

•  Digital images: this training course develops knowledge and skills related to the acquisition and processing of images in digital format. It covers how to view images using the main output devices, as well as the different file formats in which they can be stored.

• Browsing: defines the fundamental concepts and skills related to web browsing, effective information search, online communication, and email.

•  IT security: defines the fundamental concepts and skills related to the ability to understand the main concepts underlying the safe use of ICT in everyday life and to use relevant techniques and applications to maintain a secure network connection, use the Internet safely, and manage data and information appropriately.

• Spreadsheets: defines the basics of organizing, analyzing, and visualizing data, starting with basics such as formatting and simple formulas up to pivot tables and advanced functions (IF, VLOOKUP). It includes practical laboratory exercises offering basic or advanced courses in business data management, often aimed at ICDL certification or professional training.

Introduzione ai sistemi informatici (5th Edition)

di Donatella Sciuto, Giacomo Buonanno, Luca Mari

2014, pp 340 Pages

ISBN-10: 88-386-6832-9

ISBN-13: 978-88-386-6832-6

Informatica Moderna: dal Bit alla Pubblica amministrazione digitale– Apogeo

di Luciano Manelli

Edizione 2018, pp 240 Pages

ISBN-108891629901

ISBN-13978-8891629906

The exam consists of a laboratory test (compulsory) and an oral test (preparatory). The written test, lasting 1 hour and 50 minutes, consists of creating and/or modifying digital documents using Microsoft Word and Excel software. The practical test is considered passed if the candidate has successfully produced the digital documents required by the exam. Those who pass the practical test must complete the exam with the oral test.

Learning assessment may also be carried out online, should conditions require it.

·        A che cosa si riferisce l'acronimo AGID?   

·        A norma del d.lgs. 82/2005, a quanti soggetti può essere riferita una firma digitale? 

·        Cosa garantisce la Posta Elettronica Certificata?

·        A quale Regolamento Europeo si fa riferimento per la Protezione dei Dati?

·        Cosa si intende per Phishing?

·        In Excel, cosa sono i Riferimenti Relativi e Assoluti?

·        In Excel, cosa serve la funzionalità “Convalida Dati”

Quali sono le differenze nei files di immagine Jpeg e Gif?

PROVA PRATICA:

Nel file “prova.xls”, applicare le funzioni Conta.SE, Somma.SE e formattare le celle opportunamente   secondo le istruzioni ivi presenti

Realizzare un documento di testo in formato Word secondo le istruzioni presenti nel file “Testo.txt”