CODE  64186 

ACADEMIC YEAR  2022/2023 
CREDITS 

LANGUAGE  Italian 
TEACHING LOCATION 

SEMESTER  2° Semester 
TEACHING MATERIALS  AULAWEB 
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 CalcOpen Office and during the exercises the students try to solve specific problems with the help of the teacher.
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 mathematicalstatistical tools that students will have to apply during their course of study, especially in laboratory activities.
Learn how to use Excel to organize, manage data tables and extract from them the necessary information for the purpose of the problem.
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.
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.
Office hours: Appointment by email: monica.casale@unige.it.
MONICA CASALE (President)
RICCARDO LEARDI
PAOLO OLIVERI (Substitute)
Second semester
All class schedules are posted on the EasyAcademy portal.
The exam is carried out solely by means of a mathematicalstatistical calculation on the computer using the computer Excel. The test focuses on the program carried out during the lectures and its average duration is 4560 minutes in the presence of the teacher. The papers and any corrections are discussed with the students concerned
Date  Time  Location  Type  Notes 

12/04/2023  09:30  GENOVA  Compitino  
19/06/2023  14:00  GENOVA  Compitino  
06/07/2023  09:30  GENOVA  Compitino  
21/07/2023  15:00  GENOVA  Compitino  
05/09/2023  14:00  GENOVA  Compitino 