INFORMATIC ACTIVITIES

Rocco ROMANO INFORMATIC ACTIVITIES

0760200006
DIPARTIMENTO DI FARMACIA
EQF7
PHARMACEUTICAL CHEMISTRY AND TECHNOLOGY
2020/2021

OBBLIGATORIO
YEAR OF COURSE 1
YEAR OF DIDACTIC SYSTEM 2020
PRIMO SEMESTRE
CFUHOURSACTIVITY
324LESSONS
Objectives
KNOWLEDGE AND UNDERSTANDING: KNOW THE BASIC HARDWARE AND SOFTWARE ARCHITECTURE OF A COMPUTER; HAVE A BASIC KNOWLEDGE OF SPREADSHEETS WITH PARTICULAR REFERENCE TO EXCEL; BASIC KNOWLEDGE OF STATISTICS FOR THE ANALYSIS CARRIED OUT WITH SPREADSHEETS. KNOWLEDGE APPLIED AND UNDERSTANDING: BE ABLE TO APPLY THE STATISTICAL MODELS ELABORATED WITH EXCEL TO REAL CASES.
AUTONOMY OF JUDGMENT: FINDING THE MOST SIMPLE AND EFFECTIVE SOLUTIONS IN THE RESOLUTION OF PROBLEMS.
COMMUNICATION: ABILITY TO RE-PROCESS CONCEPTS WITH OWN WORDS REFORMULATING THEM WITH PRACTICAL EXAMPLES
LEARNING SKILLS: DEEPENING THE TOPICS USING SOFTWARE IN DIFFERENT CONTEXTS
Prerequisites
NONE
Contents
BASIC CONCEPTS OF INFORMATION TECHNOLOGY:
GENERAL CONCEPTS. USE OF THE COMPUTER AND FILE MANAGEMENT:
ELECTRONIC MICROSOFT EXCEL SHEET:
GENERAL CONCEPTS. CELLS. SPREADSHEET. FORMULAS AND FUNCTIONS. FORMAT. GRAPHICS. PREPARATION OF THE PRESS.
THE NATURE OF THE DATA AND STATISTICS; REVIEW THE DATA; GRAPHICAL REPRESENTATION OF DATA WITH EXCEL; CENTRAL TENDENCY AND DISPERSION INDICES; NORMAL DISTRIBUTION; CHANCE; ELEMENTS OF INFERENTIAL STATISTICS; COMPARE TWO GROUPS, THE T-TEST WITH EXCEL; MORE THAN TWO GROUPS: ONE-DIMENSIONAL ANOVA. APPLICATIONS WITH EXCEL
Teaching Methods
THE COURSE OF 3 CFU (24 HOURS) WILL TAKE PLACE WITH
LECTURES AND PRACTICE EXERCISES HELD IN THE COMPUTER TEACHING LABORATORY OF THE DEPARTMENT OF PHARMACY
Verification of learning
PRACTICE AND ORAL TEST. THE PRACTICAL TEST WILL CONSIST IN EXAMINING AND PROCESSING STATISTICAL DATA WITH EXCEL
Texts
COURSE LECTURE NOTES;
G. R. NORMAN, D. L. STREINER, BIOSTATISTICS, WHAT YOU WANTED TO KNOW ..., CASA EDITRICE AMBROSIANA
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2022-05-23]