COMPUTER SCIENCE - BASE
Course unit partition: Cognomi L-Z

Academic year 2024/25
2° year of course -
Professor
Riccardo PECORI
Academic discipline
()
Field
Ambito aggregato per crediti di sede
Type of training activity
hours
of face-to-face activities
credits
hub: PARMA
course unit
in

Course unit partition: COMPUTER SCIENCE - BASE

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

• Informatics and computer science
• 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]

2030 agenda goals for sustainable development

- - -