Bankura Christian College

Estd. 1903 Re-Accredited : Grade A (3rd Cycle) by NAAC in 2019 | "College with Potential for Excellence" (2nd Phase)

Data Analysis

Course Syllabus
Introduction of data analysis

Introduction to excel

•   Basic function in excel

• Short-cut keys in excel

Data formatting

•  Conditional formats

• Aggregate functions and number functions

Lookup functions

•  Lookup and hookup functions

• Index and match

Data handling

• Data validation

• Duplicates and Transpose

• Paste special functions

Data visualization

• Charts and diagrams

• Data summery, report and dashboard

Creating, importing and exporting data in SPSS

• Designing A Good Questionnaire and Codebook For SPSS

• Getting Familiar With SPSS

• File Options in SPSS

• Importing Data From Other Softwares Into SPSS

• SPSS Shortcuts

Creating, managing and manipulating SPSS variables

• Types of Variables

• Levels of Measurements in SPSS

• Creating Variables in SPSS

• How To Compute Variables in SPSS

Creating and interpreting SPSS output

• Frequency distribution and cross tabulation

• How To Create and Interpret The Result of A Histogram

• Creating Bar Graphs in SPSS

• Pie Charts in SPSS

• Inferential statistics

Assignments    

Project