Data processing systems
Academic Year 2023/2024 - Teacher: SALVATORE PASQUALEExpected Learning Outcomes
Course Structure
Required Prerequisites
Attendance of Lessons
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 biomedical field.
Textbook Information
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
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.
Powerpoint: 60 minutes
1. Create a new presentation by inserting a footer header for all slides with your surname and student number as well as the date.
2. Save the presentation with your last name to your computer desktop.
3. Create the 1st index slide with a uniform orange colored background and title and text layout, inserting your surname, first name and student number in the title. Add a numbered list of 4 points respectively Audiology, Physiology, Anatomy and Informatics which point to the next 2nd, 3rd, 4th and 5th slides respectively.
4. Create the 2nd slide with a uniform light green background. The slide contains, under the title Audiology, a table of 2 columns and 3 rows with a label at the top, containing the main characteristic for 2 different types of hearing aids. Insert a rectangle at the top left with a link to slide 1.
5. Create the 3rd slide with a uniform light gray background. The slide contains under the title Physiology on the right a 3D exploded pie chart and on the left a bulleted list of 3 points containing various human physiological mechanisms as desired. Insert a hexagon at the top left with a link to slide 1.
6. Create the 4th slide with a uniform light blue background. The slide contains under the title Anatomy on the left a numbered list of 5 different human organs/systems and on the right a photo or image of anatomy. Insert a cylinder at the top left with a link to slide 1.
7. Create the 5th slide with a uniform light yellow background. The slide contains, under the title Computer Science, a pie chart with a breakdown of the various operating systems used (e.g. Windows, Linux, MacOS) with % a vs. Pleasure. Insert a moon at the top left with a link to slide 1.
8. Apply a slow transition effect of your choice to all slides upon mouse click.
Access: 60 minutes
1. A healthcare company wants to monitor the statistics of healthcare service provision in the area. Each citizen is associated with records for each healthcare service performed. Create a database relating to such an archive consisting of two tables made up as follows:
CITIZENS
Citizen Code - Surname - Name - Birthdate - Sex - Living (yes/no)
PERFORMANCE
CodPrestazione - Type - Date - Cost - Citizen
2. Save the file to your desktop naming it with your last name.
3. Create an appropriate relationship between the 2 tables.
4. Create a single form for both tables.
5. Insert a combo box for the Type field (Medical Examination, Surgery, Hospitalization, Clinical Analysis, Drugs, Other).
6. Enter 2 different citizens each with at least 3 services each.
7. Create a query between the two tables that reports for each citizen only the total costs of the services provided.
8. Create a report containing the average costs of each service for each citizen.
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.