CART TRAINING ON SPSS AND EXCEL
Date: 25.08.2020- 28.08.2020
Time: 2-4 PM
The Department of International Studies, Political Science and History under the esteemed guidance of Dr Manoharan N organized the CART Training by Dr Shashikumar N D, Assistant Professor as an extension of the activities that prelude and fall under the purview of Skill Development Sub-Committee Teaching and Research headed by Lakshmi Karlekar, Sumedha K and Sanjana BS.
Prior to the Google Meet, a survey was conducted with the students of III MAIS regarding their numerical opinions (1-unfavourbale to 5-favourable and in practice) for the following aspects-
• Name
• Email Address
• Gender
• Resident of
• How often you go outside of your residence?
• How much awareness you are having on precautions?
• Rate the network/internet facility at your residence?
• How much you like online classes?
• How much you like offline classes?
The Google Meet was conducted on the following topics-
• Day 1- Excel Training
1. Sorting data
2. =count function
3. =countif function
4. Pivot Table
• Day 2- Excel Training
1. Mean, Median, Mode, Standard Error, Standard Deviation, Simple Variants
2. Kurtosis and Skewness
3. Normal versus not normal distribution
4. Non-parametric and Parametric : Rank and Pearson Correlation
5. Regression Statistics
6. T-Test: Paired Two Samples for Means
• Day 3- SPSS Training
1. Data view, Variable View (type, measure, role)
2. Analyse- Descriptive Statistics: Frequencies, Explore (Histogram functions)
• Day 4- SPSS Training
1. Analyse- Mixed Models- Linear
2. Analyse- Correlate- Bivariate
3. Analyse- Regression
4. Analyse- Non- Parametric Tests
5. Transform- Rank Cases
Regular home assignments were given post the detailed explanation to keep a track on the learning process. The sessions by CART were indeed reaping rich benefits and qualifying students to do Quantitative Analysis for their Research Papers respectively.
