Course Objectives:
1. Understand the basic structure and functions of MS Excel
2. Understand the basic structure and functions of SPSS 3. Perform data entry and Data manipulation on MS Excel 4. Perform data entry and Data manipulation on SPSS 5. Prepare a small project report by preparing research design, collecting and analyzing data on excel/SPSS and drawing conclusions from it.
Course Outcomes (COs):
Learning outcomes (at course level) |
Learning and teaching strategies |
Assessment Strategies |
CO55: Understand the basic structure and functions of MS Excel CO56: Understand the basic structure and functions of SPSS CO57: Perform data entry and Data manipulation on MS Excel CO58: Perform data entry and Data manipulation on SPSS CO59: Prepare a small project report by preparing research design, collecting and analyzing data on excel/SPSS and drawing conclusions from it. |
Approach in teaching: Interactive Hours, Discussion, Tutorials, Reading assignments, Demonstration, Team teaching
Learning activities for the students: Self learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks, 3D models |
Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects |
Formulation of research problem, identification of problem, formulation of research title, drafting questionnaire
Data Collection methods: Primary data collection using google form, etc., secondary data collection using various online platforms.
Introduction to Data Analysis Softwares: SPSS, Excel, etc., Types of Data, compilation of data, classification of data, tabulation of data, data coding and data entry in softwares, custom frequency table
Diagrammatic presentation using data analysis Software: Chart Builder, Histograms, Box Plots, Bar Charts, Cluster Bar, Stacked Bar, Error bar, Line charts, Pie charts, Editing graphs and Axes
Descriptive Statistics using data analysis Software: Measures of central tendency, Measures of dispersion
1. James B Cunningham (2011), Using SPSS: An interactive hands- on Approach, Peacock publisher, 3rd Edition.
2. A. Rajathi & P. Chandran (2012), SPSS for You, mjp publishers.
3. Seyed Reza Hashemian Rahaghi, Farnaz Abed Ashtiani (2011), Basic of Statistics & SPSS, create space independent publishing platform.
4. Robert H. Carver (2013), Doing Data Analysis with SPSS version 18.0, Cengage publishers, 5th edition.
5. S. Ajai Gaur (2009), Statistical methods for practice & research: A guide to Data Analysis using SPSS, Sage Publishers, 2nd edition.