CODE 55406 ACADEMIC YEAR 2022/2023 CREDITS 3 cfu anno 1 CHIMICA E TECNOLOGIA FARMACEUTICHE 8451 (LM-13) - GENOVA LANGUAGE Italian TEACHING LOCATION GENOVA SEMESTER 1° Semester TEACHING MATERIALS AULAWEB OVERVIEW The course aims to provide the tools necessary for the management and processing of data, especially of chemical data that students get in the lab. The course consists of lectures and computer exercises. During the lectures, the teacher explains the various functionality of Microsoft Excel or Open Office Calc and, during exercises, students try to solve specific problems with the help of the teacher. AIMS AND CONTENT LEARNING OUTCOMES The main objective of the course is to present the use of spreadsheets for making the most common techniques of data analysis. Particular emphasis will be given to those mathematical and statistical tools that students will have to apply during their course of study, especially in laboratory work. AIMS AND LEARNING OUTCOMES To use Excel to organize, manage data tables, matrices in order to extract from them the useful information for the purposes of the problem. TEACHING METHODS The course consists of lectures and exercises that take place in a computer room. During the lectures the teacher will address the theory while at the computer exercises each student can put into practice the knowledge acquired. During the exercises, each student is provided with the text of a problem (in a Word document) and related data in Excel. The problem is briefly described by the teacher and then the students have at their disposal at least an hour to try to solve it. Finally, the problem is carried out by the teacher and commented. SYLLABUS/CONTENT Excel worksheet: Definition of cells, rows and columns. Data entry. Cell formatting. Inserting / deleting rows and columns. Data manipulation. Order data. Standard and automatic filter. Paste- Special function. Spreadsheet as a calculator. Definition of elementary operations (addition, subtraction, division and multiplication) and combined (percentage difference, etc.). Mathematical functions (minimum, maximum, mean, standard deviation) and other functions. Relative cell references, absolute, and mixed. Creating and customizing graphics. Using the help function. Statistics section: Definition of random experiments. Population and sample. Statistical sample and its properties. Distribution of frequencies and probabilities. Calculation by Excel of statistical indices (mean, median, mode) and dispersion (variance, standard deviation, coeff. of variation). Construction of frequency histograms. TEACHERS AND EXAM BOARD RICCARDO LEARDI Exam Board RICCARDO LEARDI (President) CRISTINA MALEGORI MONICA CASALE (Substitute) PAOLO OLIVERI (Substitute) LESSONS Class schedule The timetable for this course is available here: Portale EasyAcademy EXAMS EXAM DESCRIPTION The exam is held by a mathematical-statistical calculation to the computer using the processor Open Office 3.4.1. The test shall cover the syllabus taught during the lectures and its average duration is 45-60 minutes in the presence of the teacher. The drawings and any necessary corrections are discussed with the students involved. Exam schedule Data appello Orario Luogo Degree type Note 12/04/2023 09:30 GENOVA Scritto 19/06/2023 14:00 GENOVA Scritto 06/07/2023 09:00 GENOVA Scritto 21/07/2023 15:00 GENOVA Scritto 05/09/2023 14:00 GENOVA Scritto 30/01/2024 15:00 GENOVA Scritto 19/02/2024 15:00 GENOVA Scritto