One Week FDP on Data Analysis in MS Excel (Online Mode)
21 - 25 June 2021
Organized by
REST Society for Research International (RSRI)
About the Workshop
Schedule of workshop
The workshop is scheduled from 10am-4 pm from 21/06/2021 (Monday) to (25/06/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(21/06/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(22/06/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(23/06/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(24/06/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 (25/06/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 (26/06/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 25/06/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
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
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
Contact us
Email: [email protected];
Mob: 9025493434, 9168882316;
WhatsApp: 6381995134, 8056352316