Ateneo - UPO

Module 1: Computer Essentials
- Computers and Devices
-- Information Technology
-- Hardware
-- Software and Licensing
- Using Windows
-- Starting and Closing a Session
-- Desktop, Icons, Settings
-- Desktop and Icons
-- Control Panel
-- File Management
--- Files and Folders
--- Organizing Files and Folders
--- Compressing and Uncompressing Files (Zip / Unzip)

Module 1.1: Online Essentials
- Browsing the Web
-- Using the Browser
-- Tools and Settings
-- Bookmarks
-- Access Security
- Using Email
-- Sending Email
-- Receiving Email
-- Tools and Settings (Signature, Auto-Reply, Forwarding)
-- Using Webmail
- Using Cloud File Storage and Sharing Platforms
-- Google Drive
-- WeTransfer

Module 2: Word Processing
- Creating a Document
-- Insert text
-- Select, edit
- Formatting
-- Format text
-- Format a paragraph
-- Use styles
- Objects
-- Create a table
-- Format a table
-- Graphic objects
- Mail merge
-- Setup
-- Results and prints
- Preparing to print
-- Setup
-- Check and print

Module 3: Spreadsheets
- Create a spreadsheet
-- Cells
--- Insert, select
--- Edit, reorder
--- Copy, move, delete
- Manage spreadsheets
-- Rows and columns
-- Worksheets
- Formulas and functions
-- Arithmetic formulas
-- SUM, AVERAGE, MIN, MAX, IF, COUNTIF, COUNTA functions
- Formatting
-- Numbers and dates (TODAY, DATE, DAYS)
- Contents
-- Alignment, borders, and effects graphs
- Graphs
-- Creating
-- Editing

Module 4: presentation
- Developing a presentation
-- Presentation views
-- Slides
-- Slide masters
- Texts
-- Text management
-- Formatting
-- Lists
-- Tables
- Pages
-- Using and organizing pages
- Graphic objects
-- Inserting and editing images, shapes, and smartart
- Animations
Invia commenti

VII edition (February 2021)
by A. Marengo (edited by), Alessandro Pagano (edited by)

Publisher: McGraw-Hill Education; 7th edition (February 8, 2021)

Language: Italian

ISBN-10: 8838698767

ISBN-13: 978-8838698767

Module 1
Understand key concepts in information technology, computers, devices, and software.
Work effectively on your 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 distribution.
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, reorder, and copy, move, and delete data.
Edit rows and columns in a worksheet.
Copy, move, delete, and rename worksheets appropriately.
Create mathematical and logical formulas using standard spreadsheet functions, use best practices for creating formulas; recognize errors in formulas. Format numbers and text in a spreadsheet.
Choose, create, and format graphics to communicate information meaningfully.

Module 4
Work with presentations and save them in different formats.
Understand different presentation views and when to use them; choose between different slide and drawing layouts.
Insert, edit, and format text in presentations.
Recognize proper methods for assigning unique titles to slides.
Choose, create, and format graphics to communicate information meaningfully.
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, notes, video lessons and exercises will be provided on the DIR page of the course.
The reference software will be MS Windows 8 or 10,11, MS Word, MS Excel, MS PowerPoint.
To access the laboratory, it is necessary to know your UPO user (the same as your email).

DIR course page with notes and exercises for the academic year 2024/2025 (Degree in LAW): https://www.dir.uniupo.it/course/view.php?id=20122

Students with physical disabilities, Learning Disabilities or Special Education Needs can request specific services and tools via the Staff Sviluppo e Coordinamento Carriere e Servizi alle Studentesse e agli Studenti, consulting the University webpage: https://www.uniupo.it/en/services/servicesstudents-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 science qualification without taking the exam, you must 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).

The topics covered in the course are found in chapters 2 to 6 (inclusive), 9, 10 and 14 of the textbook.
The chapters above cover more topics than the course; always refer to the DIR page for the specific parts to study.
The book does not contain the PowerPoint module, the notes on that topic are found in DIR.

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