Learning objectives
• Limits and opportunities of Information Technologies in the context in which they are
applied.
• Reprocess the reality by transporting the data on computer in order to analyze and
interpret them, developing deductions and reasoning over them, with the aid of
graphical representations, knowingly using the calculation tools and the opportunities
offered by specific IT applications, in particular the spreadsheet.
Prerequisites
none
Course unit content
• Hardware: brief introduction on computer architecture and its basic components.
• Basic functions of an operating system.
• Utility software and application software: the spreadsheet.
Full programme
Logical-functional structure of a computer
• Basic components of a modern computer.
• The input and output unit (I / O).
• Central processing unit (CPU).
• Main memory and secondary (or mass) memory:
◦ The main memory devices
◦ Units of measurement of memory capacity (bit, byte, Kb, ...)
Introduction to Operating systems
• General features of an operating system
• Operating system startup and shutdown operations
• The User Interface
• Management and organization of files and folders
• The software
Software and spreadsheet
• The main functions
• The main software and the main licenses
• Cells and data format
◦ Cells, rows, columns and sheets
◦ Set the data format
◦ Use automatic filling
◦ Formatting: themes, color, style, borders, alignments
• Tables
◦ Set up the table
◦ Simple and composed orders
◦ Automatic filters
• Formulas and references
◦ The arithmetic operators for the construction of calculation formulas: + - * /
◦ Use of relative, absolute and mixed references in the formulas
◦ Basic automatic functions (sum, min, max, avg, count.if, ...)
◦ Text functions (left, right, concatenate, ...)
◦ Simple logic functions (function if)
◦ Importing data from different formats (eg text)
• Charts
◦ Create a chart
◦ Types of basic chart (histogram, bars, pie, lines)
◦ Change the chart options
• Print
◦ Set the options for printing worksheets: layout, print area, headers and footers,
printing of background grids, etc.
Bibliography
The portal with the material will be given during the firsts lessons.
Online guides:
https://help.libreoffice.org
https://support.office.com/en-us/excel
Books:
INFORMATICA DI BASE, ISBN: 9788838615375
IL FOGLIO ELETTRONICO PER ECONOMIA, ISBN: 9788838662553
Teaching methods
• Lecture
• Dialectic
• Practise
Assessment methods and criteria
Practical and theoretical examination on the whole program.
Moreover, the verification of learning can consider the support of ongoing tests during the
course, which will be individually evaluated and which will contribute to the final result.
Other information
The emails for the prof. must have the object [CLEM1819]
