Academic year 2016-2017: Faculty of Medicine - English Section
Study Guide
Formulas
Recommended reading for those who are new in using Microsoft Excel:
Microsoft Excel 2010 all-in-one for dummies
Active participation
Course materials
Week 1
:
Introduction
&
Statistics Glossay
Week 2
:
Fundamental concepts
&
International Classification of Diseases
Week 3
:
Introduction in statistics
&
Requests for first optional homework
Week 4
:
Descriptive statistic I
Week 5
:
Descriptive statistic II
Week 6
:
Probabilities and their medical applications
Week 7
:
Repetitive events & Ransom effects
Week 8
:
Probability distributions & Confidence intervals
Week 9
:
Testing hypothesis I
Week 10
:
Testing hypothesis II
Week 11
:
Testing hypothesis III
Week 12
:
Internet of Things
Week 13
:
Correlation and Regressions
Week 14
:
Recap & About theoretical exam
Statistical problems by examples
Quantity of information
Population & Samples
Variables
Extra-Variables
Tables & Figures
Descriptive statistics
Probabilities
Summary statistic
Confidence intervals
Tests on means
Tests on frequencies
Practical activities materials
Week 1:
Skills assessment
&
Didactic
&
Internal
Rules
Week 2: Microsoft Word by Examples:
Requests
&
Supplementary activity
-
CentralityMeasures.docx
-
CentralityMeasuresFinal.pdf
-
image.jpg
-
Hints
Week 3: Searcing medical information & PowerPoint:
Requests
&
Supplementary activity
-
Hints
&
Bad example
(images) -
Bad slides and how cand could be improved
-
Free PowerPoint Templates by Example
Week 4: Microsoft Excel - Formulas and Functions:
Requests
&
Supplementary activity
-
Hints
&
Additional Hints
Week 5: Microsoft Excel - Charts:
Requests
&
Supplementary activity
-
Hints
Week 6: Descriptive Statistics:
Requests
&
DBPain.xls
-
C_WMean.xls
-
Hints
-
BD_SuppAP05.xls
Week 7: Probabilities & contingency tables:
Requests
-
Probabilities.xls
-
Hints
-
Supplementary exercises
Week 8: Point Estimators & Confidence Intervals:
Requests
-
Nebiv.xlsx
-
Hints
-
Supplementary exercises
Week 9: Statistical Tests I - Means:
Requests
-
Anemia.xlsx
-
Hints
-
Supplementary exercises
Week 10: Statistical Analysis of Medical Data I:
Requests
-
CholDB.xls
Week 11: Statistical Tests II - Frequencies:
Requests
-
Nebivolol.xlsx
-
Hints
-
Supplementary exercises
Week 12: Correlations and Regressions:
Requests
-
CorReg.xls
-
Hints
Week 13: Statistical Analysis of Medical Data II:
Requests
&
DB_Hyper.xls
Practical exam: by Examples:
Example
-
Problems by example
&
Antro.xlsx