One Week Workshop on Data Analysis in MS Excel

One Week Workshop on Data Analysis in MS excel (Online Mode)     
17 - 21 May 2021

                                   Organized by                                         
REST Society for Research International (RSRI)     

About the Workshop

All Registered participants will get both Soft copy and Hard copy  Course Completion Certificate and those who got 50℅ scores in the final online Exam will get Qualified the Exam certificate and Topperswill get Topper in  Exam certificate and lifetime membership of RSRI Society. Participants once paid and registered through google form will be added to the WhatsApp group of Workshop within 12 hours from the time of registration. All the instructions, the link of Prerecorded videos, the link of the Mock exam, the link of the final exam, and the link for downloading the Softcopy certificate will be shared through the WhatsApp group only. There will not be any email confirmations. All queries will also be addressed through WhatsApp (WhatsApp no: 9025493434) only. Participants can use the WhatsApp group discussion platform for asking the questions related to lectures and all valid questions will be addressed through a video.

Schedule of workshop

The workshop is scheduled from 10am-4 pm from 17/05/2021 (Monday) to (21/05/2021 (Friday). However, participants can watch videos in their convenient time(since it is pre-recorded) and give the mock exam as per their Convenient time.

Day 1(17/05/2021)
10.00-10.15am: Registration
10.15-10.45am: basics of data analysis in excel part 1
10.45-11.15am: basics of data analysis in excel part 2
11.15-11.30am: Tea Break
11.30-12.00pm: basics of data analysis in excel part 3
12.00-12.30pm: basics of data analysis in excel part 4
12.30-01.30pm: lunch
01.30-02.00pm: basics of data analysis in excel part 5
02.00-02.30pm: basics of data analysis in excel part 6
02.30-03.00pm: statistical analysis as a tool
to maximize your research impact excel part 1

03.00-03.30pm: WhatsApp group Discussion
03.30-04.00pm: Mock online test

Day 2(18/05/2021)
10.00-11.00am: statistical analysis as a tool
to maximize your research impact excel part 2

11.00-11.15am: Tea Break
11.30-12.20am: Basics & one sample T test - Excel
12.20-01.00pm: independent sample & paired T Test- Excel
01.00-02.00pm: lunch
02.00-02.45pm: Anova- Excel
02.45-03.00pm: tea break
03.00-03.30pm: WhatsApp group Discussion
03.30-04.00pm: Mock online test

Day 3(19/05/2021)
10.00-11.00am: Histogram, Skewness, Normaility in Excel
11.00-11.15am: Tea Break
11.15-11.45am: Chi Square Test
11.45-12.30pm: Data Collection Part 1
12.30-01.30pm: lunch
01.30-02.00pm: Data Collection Part 2
02.00-02.30pm: Data Collection Part 3
02.30-03.00pm: Data Collection Part 4
03.00-03.30pm: WhatsApp group Discussion
03.30-04.00pm: Mock online test

Day 4(20/05/2021)
10.00-10.50am: Forecasting in excel
10.50-11.30am: What if analysis in excel
11.30-11.45am: Tea Break
11.45-12.40pm: Central Tendancy measures and box plot
12.40-01.40pm: lunch
01.40-02.15pm: Types of Correlation in excel part 1
02.15-02.45pm: Types of Correlation in excel part 2/strong>
02.45-03.00pm: tea break
03.00-03.30pm: WhatsApp group Discussion
03.30-04.00pm: Mock online test

Day 5 (21/05/2021)
10.00-10.45am: Regression Analysis in Excel
10.45-11.30am: Linear Regression Analysis
11.30-11.45am: Tea Break
11.45-12.30pm: Non Linear Regression Analysis
12.30-1.30pm: lunch
01.30-02.00pm: Moderation Interaction Plots using MS Excel
02.00-03.00pm: Revision for Examk
03.00-04.00pm: Final Exam online test

Day 6 (22/05/2021)
03.00-04.00pm: Re Exam online test

Every day there will be mock exam (10 MCQ) which is only for Mock Test. The final Qualifying exam (40 MCQ) will be on 21/05/2021 (Friday) and if anyone missing the final exam orelse they need more time to prepare for exam then they can give an exam along with re-exam participants without any additional charges. If any participants want to go for Re-exam to improve the score, then he/she have to pay Rs. 80/.

Resource Person

Dr. Ranjan Ghadai, Asst. Prof., Sikkim Manipal University, Sikkim
https://smu.edu.in/smit/dept-faculty/faculty-list/ranjan-kmr-ghadai.html
Dr. Kanak Kalita, Asst. Prof., VelTech University, Chennai.
https://kanakkalita-com.webnode.com/

Important Dates

Last Date of Registration: 16/05/2021.
Result Declaration: 24/05/2021.
Distribution of  Softcopy certificate: 27/05/2021.
Distribution of Hardcopy Certificate: 30/06/2021.

Registration Cost
For RSRI Member - Rs. 100.
For Non-RSRI Member - Rs.150
Registration costs can be paid through Paytm, Google Pay, and Phonepe with mobile no 9025493434.

Bank details:
Account name: M. Murugammal
Account no: 35324345531
Bank: State Bank of India, Kaveripattinam
IFSC code: SBIN0007463

Registration

Interested person can register for the workshop through below google form

Contact us
Email: rsrisociety@gmail.com;
Mob: 9025493434, 9168882316;
WhatsApp: 6381995134, 8056352316