Department of BMS, St. John College of Humanities & Sciences,  30Hour Value Added Certificate Course on Research Methodology and Hypothesis Testing Using Excel  for SYBMS from 18th August 2025 to 23rd  August 2025 by Mr. Sohil Pirani

Programme: 30Hour Value Added Certificate Course on Research Methodology and Hypothesis Testing Using Excel
Organized by: Department of BMS, St. John College of Humanities & Sciences (Autonomous)
Duration: 18th – 23rd August 2025
Participants: SYBMS Students
Resource Persons: Mr. Sohil Pirani.

 

Day 01 – 18/08/2025 (Monday) | Mode: Offline

The session started at 11:05 am with a brief introduction and welcome of the guest speaker Mr. Sohil Altaf Pirani (B.Com, B.Ed, M.Com (Accountancy & Commerce), Postgraduate Diploma in Statistics (Applied), Mumbai University Ranker, MH-SET Topper, UGC NET JRF with All India Rank 99.93 percentile in Commerce, awarded UGC JRF in 2019, promoted as SRF in 2022, currently associated with Viva College as visiting faculty for MBA/MMS Data Science lectures using R/Python).

A total of 89 students (SYBMS) attended. The session covered basics of research – statement of problem, objectives of research, importance of research, hypothesis, tests, questionnaire design, and literature review. Students received a gist and overview; detailed discussions and practicals were scheduled for later sessions.

Day 02 – 20/08/2025 (Wednesday) | Mode: Online

69 students participated. The session focused on research report components, structure and descriptive abstracts, types of abstracts, correlations, Pearson’s coefficient, dependent and independent variables. Students practiced correlation matrix steps and graph creation techniques. Hypothesis was also discussed in detail. Assignments were given to reinforce learning. The session was highly interactive.

Day 03 – 21/08/2025 (Thursday) | Mode: Offline

93 students attended. Topics covered included sampling methods, sampling design, probability vs. non-probability sampling, quantitative & qualitative data, and measurement

scales. Tests such as T-test, ANOVA, one-sample T-test, and paired T-test were introduced. Assignments were given for practice.

Day 04 – 22/08/2025 (Friday) | Mode: Offline (Lab Session)

93 students attended. The session dealt with key steps in research methodology – identifying the research problem, reviewing literature, formulating hypotheses, and selecting appropriate research designs (descriptive, correlational, experimental). Students were taken to IT Labs 3 & 4 for hands-on training. The session emphasized the importance of clear problem definition and literature review in developing sound hypotheses.

Day 05 – 23/08/2025 (Saturday) | Mode: Offline (Practical Session)

The final session was practical and application-based. Students were given live demonstrations and exercises on statistical tests including:

Independent T-Test – comparing means of two independent groups

Paired T-Test – comparing means of the same group at two points

ANOVA (One-Way & Two-Way) – analyzing variance with one or two independent variables

Chi-Square Test

Kruskal-Wallis Test

Pearson’s Correlation

Spearman’s Rank Correlation

Students successfully applied these tests and learned parameters to consider while using them. The session was highly engaging and marked the conclusion of the course.

Conclusion

The Certificate Course on Research Methodology and Hypothesis Testing Using Excel conducted from 18th to 23rd August 2025 provided students with both theoretical understanding and practical exposure. Beginning with research fundamentals and progressing towards advanced statistical tests, the course empowered students with essential skills for conducting systematic research.

A total of five sessions were conducted (3 offline, 1 online, and 1 practical lab session), with student attendance ranging between 69 and 93. The sessions were highly interactive, assignment-driven, and hands-on, ensuring that students could practically implement the concepts learned.