Scrutinizing khelia and Uludanga Data

We collected data from two schools of Barasat through 4 th revision of questionnaire. By scrutinizing the data of Khelia school, I found least responded and SD=0 for few items. These items were extracted using following formula in Excel sheet.

=IF(B4<18,1, IF(D4=0,1, " "))

18= <50% of respondents
0=SD

In this way, I found following results:

CL_1 1 CL_1 1
CL_7 1 CL_7 1
DW_3 1 DW_3 1
FRND_3 1 FRND_3 1
GM_3 1 GM_3 1

So, 5 items failed to determine individual difference in both schools.

For Khelia
CL_1 1
CL_7 1
DW_3 1
BB_1 1
TCH_1 1
TLM_3 1
TLM_4 1
FRND_3 1
GM_2 1
GM_3 1
GM_6 1
CLP_5 1
MDM_1 1
HLTH_1 1
HLTH_2 1
HLTH_3 1
HLTH_6 1

Module 3
Q2 1
Q3 1

So, 17 items for module 2 and 2 items for module 3 are in the same category in case of Khelia school.

For Uludanga school

CL_1 1
CL_2 1
CL_4 1
CL_5 1
CL_7 1
DW_1 1
DW_3 1
TLM_1 1
FRND_3 1
GM_3 1
MODULE3 1
Q9 1

In case of Uludanga data, 10 items of module 2 and 1 item for module 3 are in these category.

In estimating total score, we must be very careful.