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) |
|
Syllabus and Other Details |
https://drive.google.com/file/d/1PfAO0QFDKR0hu9Yt3uiEojWkkMIW0ldf/view?usp=sharing |
Link for Registration |
All Week-Wise Lectures |
Week-1 (From 06/02/2023 to 11/02/2023) (Lecture 0 to Lecture 4) |
||||
Week |
Lecture |
Topic |
Language |
Video Link, PPT Link |
1 |
Lect 0 |
Introduction to Course |
English |
https://drive.google.com/file/d/1C77wmpIYeDOodbQKz3lou8eIrRm4F-fc/view?usp=sharing |
Marathi |
https://drive.google.com/file/d/1wQPcs0eTudoo_gQbfDLCUS50G9vGKB2L/view?usp=sharing |
|||
1 |
Lect 1 |
Basic Vocabulary |
English |
https://youtu.be/PMYHTGEquzPMYHTGEquzUU https://drive.google.com/file/d/1RpMckKEBVgN0XQcc7OJRIVGFMox44eNp/view?usp=sharing https://docs.google.com/document/d/1U50VppE1Jzcb4SOUr5a9IcLZk-yYckBKnPsTyckukzo/edit?usp=share_link |
Marathi |
https://drive.google.com/file/d/1I2mqzJMQx5TYFEscPkhmfz6CIlEk0Hhw/view?usp=sharing |
|||
1 |
Lect 2 |
Introduction to Variable & Data |
English |
https://drive.google.com/file/d/10meVhsZe2IQsONyh4JmBbBXTh5OGGUKw/view?usp=sharing |
Marathi |
https://drive.google.com/file/d/1ohjscIBDruw2pxhQVN3xfOV26S7tvLX2/view?usp=sharing |
|||
1 |
Lect 3 |
Measurement of Scale |
English |
https://drive.google.com/file/d/1LKT1pEwv8zqKdeoRH8nTtHMaaD4pMTcJ/view?usp=sharing |
Marathi |
https://drive.google.com/file/d/184kwWySbvrvV1TtnxX91Ttxc7-ndT4Za/view?usp=sharing |
|||
1 |
Lect 4 |
Introduction to Statistical Techniques |
English |
https://drive.google.com/file/d/1tBH1wrEHWaTsPNwGTAb_UEZc75raJeSy/view?usp=sharing |
Marathi |
https://drive.google.com/file/d/1alxYBAPgXljYaWoUkwEZUyK1HSOtDhfv/view?usp=sharing |
|||
|
Link for Week-1 TextScripts |
https://drive.google.com/drive/folders/1XQMhnHvXiXRPhU0anNkEIkM3-jQSAGmb?usp=share_link |
||
|
Live Session |
Date: 11/02/2023 (Saturday) Time: 04:00 pm (Participants will receive a link of meeting on their mail) |
||
Assignment |
Last Date of Submission: 12/02/2023 (Sunday) before 05:00 pm (Participants will receive a link of assignment on their mail one day before) |
Week-6 (From 13/03/2023 to 18/03/2023) (Lecture 25 to Lecture 29) |
|||||
Week |
Lecture |
Topic |
Language |
Video Link |
PPT Link |
6 |
Lect 25 |
Introduction to Inferential Statistics |
English |
https://drive.google.com/file/d/14Q3ySZhBkzTdVByMLthvm_osgQ-zKYw-/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1DDFuozDybOfZCnB0MfCs5dCsCjdT-85R/view?usp=sharing |
||||
6 |
Lect 26 |
Introduction to Hypothesis Testing |
English |
https://drive.google.com/file/d/1kwkvyWE9XM3m0qG3WSy3palV6fN31K57/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1bzR8mQEy99BOzuPRNnySVPkcWvoFh5Up/view?usp=sharing |
||||
6 |
Lect 27 |
One sample t-test |
English |
https://drive.google.com/file/d/1lxK2NF-9DJZWbs3VQdv6EqLY1U13z5tz/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1cvUzS5FDtWt-LNwTukSEq6sU03AIRtTx/view?usp=sharing |
||||
6 |
Lect 28 |
Independent Samples t-test |
English |
https://drive.google.com/file/d/11r6MzoWla_f02tMEEEJBf7h5Mri_6AVT/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/14EYRrl5R1_u1mPt7g9ZL-VtEl5yCpGxB/view?usp=sharing |
||||
6 |
Lect 29 |
Dependent (paired) samples t-test |
English |
https://drive.google.com/file/d/1EVSxZp2OExvV5373Fgb5h_0dxAKtBp3Y/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1NjZf1eDvywPiJS5X_-YhYsojtwfh4HKJ/view?usp=sharing |
||||
|
Link to Sample Data: One-Sample t-test |
||||
|
Link to Sample Data: Independent Samples t-test |
||||
|
Link to Sample Data: Dependent (paired) samples t-test |
||||
|
Live Session-06 |
Date: 18/03/2023 (Saturday) Time: 04:00 pm (Participants will receive a link of meeting on their mail) |
|||
|
Assignment-06 |
Last Date of Submission: 19/03/2023 (Sunday) before 05:00 pm (Participants will receive a link of assignment on their mail one day before) |
Week- 7 (Lecture 30 to Lecture 34) (20/03/2023 to 25/03/2023) |
|||||
Week |
Lecture |
Topic |
Language |
Video Link |
PPT Link |
7 |
Lect 30 |
One-Way ANOVA |
English |
https://drive.google.com/file/d/1rSWrtFYQDAFZEKwxr3sAtFTxhiRmKcVh/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1a995qVAMpWL1SLEqVJmJ4RnCDTvO8Km1/view?usp=sharing |
||||
7 |
Lect 31 |
Two-Way ANOVA |
English |
https://drive.google.com/file/d/1XPsAJmCmh9rxxj0UhqnSc6JcB6XbfYZD/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1zKk8snX1LDXPDsJ7f_UP7bmCaEy6BQyf/view?usp=sharing |
||||
7 |
Lect 32 |
Chi-Square Test |
English |
https://drive.google.com/file/d/19y2H3tEm61PwxyvBLyK1wtXyvhjF443g/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/15l5IkaBA1hdX0rdTmEXZxY4Plaz9N90b/view?usp=sharing |
||||
7 |
Lect 33 |
Correlation Coefficient |
English |
https://drive.google.com/file/d/1PvG5oviV-kr93I_DDAdu-BDY6EJesFk4/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1kk5Iol_frHokrUxWXsgBWm1FAnU2YOXg/view?usp=sharing |
||||
7 |
Lect 34 |
Partial Correlation |
English |
https://drive.google.com/file/d/1MdMcO-mWv1wi6Hqd_jJjTIWtyoZj3Cwg/view?usp=sharing |
|
Marathi |
https://drive.google.com/file/d/1n5-Ww-lwpUfs7zfDA8gN49zm0Zu05b_C/view?usp=sharing |
||||
|
Sample Data Sets: |
||||
30 |
Link to Sample Data: One-Way ANOVA |
For Excel Treatment |
|||
For SPSS Treatment |
|||||
31 |
Link to Sample Data: Two-Way ANOVA |
For Excel Treatment |
|||
For SPSS Treatment |
|||||
32 |
Link to Sample Data: Chi-Square Test |
For Excel Treatment |
|||
For SPSS Treatment |
|||||
33 |
Link to Sample Data: Correlation |
For Excel Treatment |
|||
For SPSS Treatment |
|||||
34 |
Link to Sample Data: Partial Correlation |
For Excel Treatment |
|||
For SPSS Treatment |
|||||
|
Live Session-07 |
Date: 25/03/2023 (Saturday) Time: 04:00 pm (Participants will receive a link of meeting on their mail) |
|||
|
Assignment-07 |
Last Date of Submission: 26/03/2023 (Sunday) before 05:00 pm (Participants will receive a link of assignment on their mail one day before) |
Sample Data Sets: | |||
35 | Simple Linear Regression | For Excel & SPSS Treatment | https://docs.google.com/spreadsheets/d/1wFpAlcjYOQPUQTjPY8ezSlG502UrwXh6/edit?usp=sharing&ouid=108673223323713712833&rtpof=true&sd=true |
36 | Multiple Linear Regression | For Excel & SPSS Treatment | https://docs.google.com/spreadsheets/d/1884L0KpWmVBGiFQOoeUSJXU0rL60sMDJ/edit?usp=sharing&ouid=108673223323713712833&rtpof=true&sd=true |
37 | Reliability Test: Cronbach Alpha | For Excel & SPSS Treatment | https://docs.google.com/spreadsheets/d/1RQt66qys4rWFjhe57l5Qk63rEGeWjzuZ/edit?usp=sharing&ouid=108673223323713712833&rtpof=true&sd=true |
Live Session-08 | Date: 01/04/2023 (Saturday) Time: 04:00 pm (Participants will receive a link of meeting on their mail) | ||
Assignment-08 |
Last Date of Submission: 02/04/2023 (Sunday) before 05:00 pm (Participants will receive a link of assignment on their mail one day before) |