CODE 64186 2023/2024 3 cfu anno 3 FARMACIA 8452 (LM-13) - GENOVA Italian GENOVA 2° Semester AULAWEB

## OVERVIEW

The course aims to provide the necessary computer tools for the management and processing of data, especially chemical data that students will get in laboratory exercises. The course is divided into lectures and computer exercises. During the lectures, the teacher illustrates the various features of Microsoft Excel or Calc-Open Office and during the exercises the students try to solve specific problems with the help of the teacher.

## AIMS AND CONTENT

### LEARNING OUTCOMES

The aim of the course is to present the use of spreadsheets for the performance of the most common data analysis techniques. Particular emphasis will be given to those mathematical-statistical tools that students will have to apply during their course of study, especially in laboratory activities.

### AIMS AND LEARNING OUTCOMES

Learn how to use Excel to organize, manage data tables and extract from them the necessary information for the purpose of the problem.

### TEACHING METHODS

The course is divided into lectures and exercises that take place in turn in the computer room. During the lectures the theory is addressed while during the computer exercises is given to each student to put into practice the acquired knowledge. During the tutorials each student is provided with the text of a problem on Word document and its data on Excel sheet. The problem is briefly described by the teacher and then the students have at least an hour to try to solve it. In the end the problem is dealt with by the teacher and commented.

### SYLLABUS/CONTENT

Excel worksheet: Definition of cells, rows and columns. Data matrices. Formatting cells. Inserting/deleting rows and columns. Block panes. Data manipulation. Sort data option. Standard and automatic filter option. Special paste function. Spreadsheet as a calculator. Definition of elementary operations (sum, subtraction, division and multiplication) and combined (percentage difference, etc.). Mathematical functions (minimum, maximum, mean, standard deviation) and other functions. Relative, absolute and mixed cell references. Creating and customizing charts. Using the help function.
Statistical part. Definition of random experiments. Population and sample. Statistical sample and its properties. Frequency distribution and probability. Calculation by Excel of statistical indices of location (arithmetic, median, fashion), and dispersion (variance, standard deviation, coeff. of variation). Construction of frequency histograms on spreadsheet.

## TEACHERS AND EXAM BOARD

### Exam Board

MONICA CASALE (President)

CRISTINA MALEGORI

PAOLO OLIVERI (Substitute)

## LESSONS

Second semester

### Class schedule

The timetable for this course is available here: Portale EasyAcademy

## EXAMS

### EXAM DESCRIPTION

The exam is carried out solely by means of a mathematical-statistical calculation on the computer using the computer Excel. The test focuses on the program carried out during the lectures and its average duration is 45-60 minutes in the presence of the teacher. The papers and any corrections are discussed with the students concerned

### Exam schedule

Data Ora Luogo Degree type Note
01/04/2024 09:30 GENOVA Compitino
24/06/2024 09:30 GENOVA Compitino
11/07/2024 09:30 GENOVA Compitino
25/07/2024 09:30 GENOVA Compitino
13/09/2024 09:30 GENOVA Compitino
31/01/2025 09:30 GENOVA Compitino
20/02/2025 09:30 GENOVA Compitino