DATA ANALYSIS WITH COMPUTER TOOLS

DATA ANALYSIS WITH COMPUTER TOOLS

_
iten
Last update 03/07/2020 17:41
Code
64186
ACADEMIC YEAR
2020/2021
CREDITS
3 credits during the 3nd year of 8452 Pharmacy (LM-13) GENOVA
LANGUAGE
Italian
TEACHING LOCATION
GENOVA (Pharmacy)
semester
2° Semester
Teaching materials

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.

The frontal teaching can be carried out remotely via computer.

 

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

Ricevimento: Every day, by appointment.

Exam Board

MONICA CASALE (President)

RICCARDO LEARDI (President)

PAOLO OLIVERI

CRISTINA MALEGORI

LESSONS

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.

The frontal teaching can be carried out remotely via computer.

 

LESSONS START

On March 9,  at h. 10:00 - Team ‘Analisi dei Dati per FARMACIA- 2021’ with code:

xztbkrt

ORARI

L'orario di tutti gli insegnamenti è consultabile su EasyAcademy.

EXAMS

Exam description

The exam is held by a mathematical-statistical calculation to the computer using the processor Open Office. 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

Date Time Location Type Notes
27/01/2022 09:00 GENOVA Scritto
14/02/2022 09:00 GENOVA Scritto