Ateneo - UPO

Module 1: computer essentials
- Computers and devices
-- Information Technologies
-- Hardware
-- Software and licenses
- Using Windows
- Starting and closing a session
-- Desktop, icons, settings
-- Desktop and icons
-- Control panel
-- File management
--- Files and folders
--- Organize files and folders
--- Compress and decompress files (zip / unzip)
Module 1.1: online essentials
- Web browsing
-- Using the browser
-- Tools and settings
-- Bookmarks
-- Access security
- Use of e-mail
-- Sending emails
-- Receiving emails
-- Tools and settings (signature, automatic reply, forwarding)
-- Use webmail
- Use Cloud-based file storage and sharing platforms
-- Google Drive
-- WeTransfer
Module 2: word processing
- Creating a document
-- Insert a text
-- Select, edit
- Formatting
- Format a text
- Format a paragraph
-- Use styles
- Objects
-- Create a table
-- Format a table
-- Graphic objects
- Mail merge
-- Setting
-- Results and prints
- Preparing to print
-- Setting
-- Check and print
Module 3: spreadsheets
- Create a spreadsheet
-- Cells
--- Insert, select
--- Edit, reorder
--- Copy, move, delete
- Spreadsheet management
-- Rows and columns
-- Worksheets
- Formulas and functions
-- Arithmetic formulas
- SUM, AVERAGE, MIN, MAX, IF, COUNTIF, COUNTIFVALUE functions
- Formatting
-- Numbers and dates (TODAY, DATE, DAYS)
- Contents
-- Alignment, borders and graphic effects
- Charts
-- Creation
-- Edit
Module 4: presentation
- Development of a presentation
-- Views of a presentation
-- Slides
-- Slide layouts
- Texts
- Text management
-- Formatting
-- Lists
-- Tables
- Pages
-- Use of pages and their organization
- Graphic objects
-- Inserting and editing images, shapes and smartart
- Animations

nformatica di base
VII edizione (febbraio 2021)
di A. Marengo (a cura di), Alessandro Pagano (a cura di)
Editore: McGraw-Hill Education; 7° edizione (8 febbraio 2021)
Lingua: Italiano
ISBN-10: 8838698767
ISBN-13: 978-8838698767

Module 1
Understand key concepts in information technology,
computers, devices, and software.
Work effectively on the computer desktop using icons and
windows
Understand storage concepts and use utility software
to compress and extract large files
Understand the importance of protecting data and devices from malware, and
the importance of backing up data
Module 2
Work with documents and save them in different file formats.
Create and edit small documents for sharing and
distributing.
Apply different formatting to documents to improve readability
before distribution; identify the best ways to
format.
Insert tables, pictures, and graphics into documents.
Prepare documents for mail merge.
Check and correct spelling errors before final printing.
Module 3
Work with spreadsheets and save them in different file formats.
Enter data into cells.
Select, rearrange, and copy, move, and delete data.
Modify rows and columns in a worksheet.
Copy, move, delete, and rename worksheets as appropriate.
Create mathematical and logical formulas using common spreadsheet functions, use best practices for creating formulas; recognize errors in formulas. Format numbers and text in a spreadsheet.
Choose, create, and format charts to communicate information in a meaningful way.
Module 4
Work with presentations and save them in different formats.
Understand different presentation views and when to use them; choose from different slide and drawing layouts.
Insert, edit, and format text in presentations.
Recognize good practices for assigning unique titles to slides.
Choose, create, and format charts to communicate information in a meaningful way.
Insert and edit images, manage images, objects, and drawings.
Apply animations and transition effects to presentations.

No previous knowledge and/or computer skills are required. The course can be accessed with minimal skills

In addition to the lessons attended in the laboratory, exercises will be provided on the DIR page of the course.
The reference software will be MS Windows 8, 10 or 11, MS Word, MS Excel,
MS PowerPoint.
To access the laboratory, it is necessary to know your UPO user
(the same as your email).

Students with physical disabilities, Learning Disabilities or Special Education Needs can request specific services and tools via reference office consulting the University webpage: https://www.uniupo.it/en/services/services-students-physical-or-learning-disabilities. Students with disabilities, learning disabilities or special education needs, once they have contacted the University Staff, can refer to the tutor in charge of the course to define the examination modalities, concerning academic aspects

Practical laboratory exam in a Windows environment lasting two hours:
- answer a quiz on hardware and software;
- write a document in Word;
- solve a spreadsheet in Excel;
- create a presentation in PowerPoint;
- send/share files in compressed mode (zip) via DIR and/or Google
Drive.
The use of your own notebook will be prohibited.
The use of paper and/or digital notes will be prohibited.
---------------------------------------------------
To receive the computer suitability without taking the exam, it is necessary to
have passed the following ICDL (formerly ECDL) exams:
- Computer Essentials;
- Online Essentials;
- Spreadsheets;
- Word Processing;
- Presentation.
Or, have obtained the ICDL Full Standard certification
(https://www.ecdl.it/ecdl-full-standard).

As an alternative to the reference text, an official guide for the full standard ICDL certification can be used

Ability to use a Windows system and individual productivity tools MS Office (Word, Excel, Powerpoint)