Data Analytics using Excel

Welcome to one and all the respected members in the National Level Training program on "Data Analytics using Excel" schedule between 1/7/2021 - 3/7/2021

Training Schedule (1/7/2021 - 3/7/2021)

1. Data Collection and Sources of Data

2. Converting Google Form Data into Ms-Excel Format for Analysis Purpose

3. Data Analytics using Excel – Introduction

4. Basic of Excel

5. Data Analytics - Working with Worksheet

Day - 2 (2/7/2021)

6. Data Analytic - What-if Analysis

7. Data Analytics – Database in Excel

8. Data Analytic – Charts using Excel

9. Sampling and Sample Size

10. Purpose & Types/Techniques of Sampling

Day - 3 (3/7/2021)

11. Selecting Sample data using Simple Random Sampling Technique via Excel

12. Selecting Sample data using Systematic Sampling Technique via Excel

13. Selecting Sample data using Stratified Sampling Technique via Excel

14. Selecting Sample data using Cluster Random Sampling Technique via Excel

Resource Person -

Dr. S. B. Kishor

(Click on V symbol to view detail profile)

β€’ He is a Chairman of, Computer Science Board, Gondwana University, Gadchiroli, and working as a member of the Computer Science board to various autonomous college.

β€’ Dr. Kishor, a double Ph.D. holder in the Professional subjects that includes Computer Science and Management, has written 63 books and with re-edition, this figure goes to 111 books.

β€’ He is working as a guide and examiner in the subject Computer Science and Management subject.

β€’ During Covid-19, he has uploaded more than 150 videos on Teaching aids for faculty, Academic, Research, and other Utility videos on YouTube (www.youtube.com/c/SBKishor )

β€’ So far, he has been credited with two patents, 12 research scholars have been awarded a Ph.D. under his guidance (9 in Computer Science and 3 in Management) and 6 M.Phil students awarded.

β€’ He has trained more than four thousand Ph.D. Research Scholars and faculty members on the topic of ICT and Plagiarism. He has worked as a resource person in Faculty Development Programs, Refresher Programs organized by HRDC- ASC, Ph.D. Course work organized by universities, etc.

β€’ He has been the Chair Session and Resource person at many National Conferences and Academic Staff College and presented many papers at National and International Journals and Conferences.

β€’ Dr. Kishor is also sharing his ideas and expertise on many important committees that include IQAC, NAAC, and Research, etc.

β€’ Most important, to honor his dedication and determination for his work, Dr. Kishor has been awarded many awards that include some prestigious like β€˜Ideal Teacher award – 2012’ and β€˜Best Writer award – 2013’ by RTMNU, Nagpur. A holder of β€œIndia Book of Records - 2014” for writing Maximum Books in Computer Science and Recipients of β€œIdeal Teacher Award - 2016” of Gondwana University, Gadchiroli and β€œDistinguish HOD-2017”, of Computer Society of India, Mumbai and β€œShiksha Ratan – 2019” of Zero Mile, Nagpur., β€œBest Faculty Development for Online Teaching During COVID-19" OF IESA (International Education Symposium and Awards-2020)

β€’ As a social responsibility, He has donated blood on 14 occasions and published 54 articles in the Hitavada newspaper, mostly on Research topics for making awareness of Research among the reader.

β€’ A meritorious and a national Computer - Quiz Winner, A four times district champion in Carom Tournaments and three times district champion in Chess Tournaments, and many more feathers in his cap.