Data Processing Systems

Academic Year 2023/2024 - Teacher: SALVATORE PASQUALE

Expected Learning Outcomes

At the end of the course, the student will complete his skills in the field of Office Automation with the mastery of spreadsheets, presentation tools and database management. He will also learn about conscious use of the Internet and its potential / dangers. The basics of artificial intelligence will also be introduced.

Course Structure

Dialogue lessons and guided computer exercises.

Required Prerequisites

Know how to use Microsoft office automation environments and know the main functions and operating characteristics of the Internet.

Attendance of Lessons

Required.

Detailed Course Content

Excel spreadsheets: tables, operations and expressions, statistical, mathematical and lookup functions, graphs, conditional formatting.

Powerpoint presentations: use and development of the application, management of text, tables, graphs, organization charts, drawings, multimedia files and external links, animations and reviews.

Data Stores in Access: Understand and organize a database, tables, records and fields, relationships, basic operations, queries, forms, and reports.

Security and Privacy on the Internet: online life, big data, privacy, cloud, social networks, commercial value of internet users, threats and precautions, cookies, WiFi networks, passwords, legal protections, advertising, spam and hoaxes.

Artificial intelligence: artificial neural units, neural networks, machine learning and deep learning, backpropagation networks, learning and execution, applications of AI also in the enviromental field.

Textbook Information

INFORMATICA DI BASE 7ed Mc Graw Hill 2021
Dennis Curtin, Kim Foley, Kunal Sen, Cathy Morin, Agostino Marengo, Alessandro Pagano
ECDL Quick Start Guide – Spreadsheets Syllabus 5.0
ECDL Quick Guide – Presentation Syllabus 5.0
ECDL Quick Start Guide - Using Databases Syllabus 5.0
PDF slides provided by the teacher.

Learning Assessment

Learning Assessment Procedures

The theoretical-practical mastery of the course contents will be assessed.

Examples of frequently asked questions and / or exercises

Excel: 60 minutes

Calculate mean, median, standard deviation, maximum and minimum, trend line, line graph, histograms, radar, pie, scatter-plot.

Network security

What does the type of advertising that Google offers us depend on?

What is “data mining”?

Do you know any organization that can process and resell your data?

How can you publish your CV to find potential employers?

What is Heartbleed?

How can you protect yourself from spamming?

Artificial intelligence

· Describe some applications of AI in the biomedical field.

· Schematicize and describe the learning mechanism in an artificial neural network.

VERSIONE IN ITALIANO

Corso di laurea in

Scienze Ambientali e Naturali