WORKSHOP ON MS EXCEL
Rapporteur: Department of Library and Information Centre
11-12 Feb, 2019: Two day workshop on Microsoft Excel was organized February 11-12, 2019 at
School of Liberal Studies (SLS), PDPU. The workshop was organized by Library and Information
Centre in joint collaboration with the Department of Business Administration and Department of
Social Sciences. The objective of the workshop was to train students on usage of MS Excel and
hands-on practice for data analysis. Dr. Vijay Jariwala Assistant professor, faculty of Economics at
Sardar Patel University, Anand was the instructed for the workshop. The workshop was coordinated
by Dr. Anurag Srivastava, Dr. Supriya Pal and Mr. Sandip Pathak.
Prof. Nigam Dave inaugurated the workshop, Dr. Anurag Srivastav & Dr Supriya Pal delivering the
workshop training and Mr. Sandip Pathak explaining the importance of data analysis through MS
Excel
Topics of Day – 1:
·
What and Why – Statistics, Writing and Presenting Reports, Statistics- Evolving Field.
·
Types of Data and Scale of Measurements, Methods for Primary Data collection.
·
Questionnaire.
·
Data Vocabulary, Level of Measurement, Time-series and Cross Sectional Data, Sampling
·
Concepts, Sampling Methods.
·
Visual Description of data, Dot Plots, Line charts, Bar charts, Scatter charts, tables, Pie
charts.
16