8 Week Online Certificate Course on 'Data Interpretation Using MS-Excel and SPSS'

8 Week Online Certificate Course on

‘Data Interpretation Using MS-Excel and Statistical Package for Social Sciences (SPSS)’ 

Offered by
School of Social Sciences,
Swami Ramanand Teerth Marathwada University, Nanded
Sub-Campus, Latur. 

Introductory Video (Must Watch)

https://youtu.be/9lpxkdoVvyo

Syllabus and Other Details

https://drive.google.com/file/d/1PfAO0QFDKR0hu9Yt3uiEojWkkMIW0ldf/view?usp=sharing 

Link for Registration

https://forms.gle/dgEKT2WpnbMm2DdQ7 

(Proposed relaunch of certificate course in January 2023)

All Week-Wise Lectures

Week-1 (From --/--/---- to --/--/----) (Lecture 0 to Lecture 4)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

1

Lect 0

Introduction
to Course

English

 

 

 

Marathi

 

 

 

1

Lect 1

Basic
Vocabulary

English

 

 

 

Marathi

 

 

 

1

Lect 2

Introduction to
Variables & Data

English

 

 

 

Marathi

 

 

 

1

Lect 3

Measurement
of Scale

English

 

 

 

Marathi

 

 

 

1

Lect 4

Introduction
to Statistical
Techniques

English

 

 

 

Marathi

 

 

 

 

Live Session-1

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-1

Last Date and Time of Submission: --/--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-2 (From --/--/---- to --/--/----) (Lecture 5 to Lecture 9)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

2

Lect 5

Introduction
to MS-Excel

English

 

 

 

Marathi

 

 

 

2

Lect 6

Data Cleaning
in MS-Excel

English

 

 

 

Marathi

 

 

 

2

Lect 7

Coding

English

 

 

 

Marathi

 

 

 

2

Lect 8

Introduction
to SPSS

English

 

 

 

Marathi

 

 

 

2

Lect 9

Basic Functions
in SPSS and
MS-Excel

English

 

 

 

Marathi

 

 

 

 

Live Session-2

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-2

Last Date and Time of Submission: --/--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-3 (From --/--/---- to --/--/----) (Lecture 10 to Lecture 14)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

3

Lect 10

Frequency Tables
in MS-Excel
& SPSS

English

 

 

 

Marathi

 

 

 

3

Lect 11

Cross Tables in
MS-Excel & SPSS

English

 

 

 

Marathi

 

 

 

3

Lect 12

Stem & Leaf
Display Using
MS-Excel & SPSS

English

 

 

 

Marathi

 

 

 

3

Lect 13

Visualization of
Categorical Data
(Nominal & Ordinal)

English

 

 

 

Marathi

 

 

 

3

Lect 14

Visualization of
Numerical
Data-Histogram

English

 

 

 

Marathi

 

 

 

 

Live Session-3

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-3

Last Date and Time of Submission: --/--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-4 (From --/--/---- to --/--/----) (Lecture 15 to Lecture 19)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

4

Lect 15

Reading and
Interpretation
of Table Output
in SPSS

English

 

 

 

Marathi

 

 

 

4

Lect 16

Reading and
Interpretation
of Chart Output
in SPSS

English

 

 

 

Marathi

 

 

 

4

Lect 17

Descriptive
Statistics:
Numerical Treatment
in MS-Excel
and SPSS

English

 

 

 

Marathi

 

 

 

4

Lect 18

Central Tendencies:
Meaning

English

 

 

 

Marathi

 

 

 

4

Lect 19

Reading and
Interpretation of
Central Tendencies

English

 

 

 

Marathi

 

 

 

 

Live Session-4

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-4

Last Date and Time of Submission: --/--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-5 (From --/--/---- to --/--/----) (Lecture 20 to Lecture 24)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

5

Lect 20

Meaning of
Partition
Values

English

 

 

 

Marathi

 

 

 

5

Lect 21

Reading and
Interpretation of
Partition Values

English

 

 

 

Marathi

 

 

 

5

Lect 22

Meaning of
Dispersion

English

 

 

 

Marathi

 

 

 

5

Lect 23

Reading and
Interpretation of
Dispersion Values

English

 

 

 

Marathi

 

 

 

5

Lect 24

Meaning, Reading
and Interpretation
of Skewness and
Kurtosis

English

 

 

 

Marathi

 

 

 

 

Live Session-5

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-5

Last Date and Time of Submission: --/--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-6 (From --/--/---- to --/--/----) (Lecture 25 to Lecture 29)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

6

Lect 25

Introduction
to Inferential
Statistics

English

 

 

 

Marathi

 

 

 

6

Lect 26

Introduction
to Hypothesis
Testing

English

 

 

 

Marathi

 

 

 

6

Lect 27

One sample
t-test

English

 

 

 

Marathi

 

 

 

6

Lect 28

Independent
Samples t-test

English

 

 

 

Marathi

 

 

 

6

Lect 29

Dependent (paired)
samples t-test

English

 

 

 

Marathi

 

 

 

 

Live Session-6

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-6

Last Date and Time of Submission: -- /--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-7 (From --/--/---- to --/--/----) (Lecture 30 to Lecture 34)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

7

Lect 30

One-Way ANOVA

English

 

 

 

Marathi

 

 

 

7

Lect 31

Two-Way ANOVA

English

 

 

 

Marathi

 

 

 

7

Lect 32

Chi-Square Test

English

 

 

 

Marathi

 

 

 

7

Lect 33

Correlation

English

 

 

 

Marathi

 

 

 

7

Lect 34

Partial Correlation

English

 

 

 

Marathi

 

 

 

 

Live Session-7

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-7

Last Date and Time of Submission: -- /--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Week-8 (From --/--/---- to --/--/----) (Lecture 35 to Lecture 39)

Week

Lecture

Topic

Language

Video Link

PPT Link

Text script Link

8

Lect 35

Simple Linear
Regression

English

 

 

 

Marathi

 

 

 

8

Lect 36

Multiple Linear
Regression

English

 

 

 

Marathi

 

 

 

8

Lect 37

Test of Reliability:
Cronbach Alpha

English

 

 

 

Marathi

 

 

 

8

Lect 38

Export of
SPSS Results

English

 

 

 

Marathi

 

 

 

8

Lect 39

Summary Lecture

English

 

 

 

Marathi

 

 

 

 

Live Session-8

Date: --/--/---- (Saturday), Time: 04:00 pm (Participants will receive a link on their mail)

 

Assignment-8

Last Date and Time of Submission: -- /--/---- (Sunday) before 05:00 pm (Participants will receive assignment link on their mail)

Copyright © 2020 srtmun.ac.in. All Rights Reserved.