INFORMATION PROCESSING SYSTEMS

Università degli Studi
"G. d'Annunzio"

Chieti - Pescara

Error message

User error: Failed to connect to memcache server: druportbe01:11211 in dmemcache_object() (line 415 of /production/drupal/dim_prod/drupal/d7cl4/prod/unich/releases/7/web/sites/all/modules/contrib/memcache/dmemcache.inc).

General Module

Course Sheet

Course code:

TL11A1D

Academic Year of enrolment:

2019

Year of supply:

2019/2020

Type of Course:

Characterising

Degree:

Course of 1st Cycle Degree in BIOMEDICAL LABORATORY TECHNIQUES

Disciplinary Sector:

Data Processing Systems

Is part of:

PHYSICS AND INFORMATICS SCIENCES

Location:

CHIETI

Credits:

Programme Year:

Professor and Collaborators:

Dott. DI CARLO PIERO

Cycle:

First semester

Obligatory attendance:

Yes

Hours of classroom activity:

Individual study hours:

Prerequisites:

No prerequisites

Objectives

The course aims to provide an introduction to the basics of using spreadsheets for data management and analysis.

Contents

Spreadsheets and Database. Basic statistics analysis using excel.

Extended Syllabus

Introduction to spreadsheets
The excel sheet
Enter, save and print data
Automatic data entry
Cell formatting
Mathematical formulas with excel
The functions of excel
Create and edit charts
Absolute and relative references in formulas and functions
Logic functions (SE, E, OR, XOR, NON)
Nested logical functions
Linear regression
Order data
Pivot tables
Database functions
Links between different sheets
Links between different files.

Recommended Bibliography

Fabrizio Cattadori Appunti di Informatica

Lecturer’s course materials

Teaching Methods

Fontal lectures, lab activity and classroom exercises

Evaluation methods

Verification of learning:

Computer practice test of knowledge of the basic functions of excel.
Oral examination.

Contacts/More Information

E-mail: piero.dicarlo@unich.it
Student reception hours: Tuesday from 15:00 to 17:00 at DISPUTER, building ex-Lettere 3rd floor

Università degli Studi
"G. d'Annunzio"

Chieti - Pescara

Aree

Error message