120-hour Rank based data science course

Organized by Rabindrik Psychotherapy Research Institute Trust (RPRIT), Registered Academic Trust by Indian Trust Act,1882, REGD.NO.150600103, DARPAN ID WB/2025/0514195.

About the trust:  It is a higher learning virtual research institute aiming at educating students about research for the welfare of the larger community through online and blended education. International students are welcome here. The trust regularly inviting applications for various courses. Both Internal and External Faculties are teaching here. The trust has more than 500 students.

Recent Achievements & Recognition

RPRIT is the registered vendor for Tata Power in psychometric assessment.  RPRIT has a strong track record of mentoring undergraduate students through research internships. In 2024, RPRIT offered research internships to 11 undergraduate students from Maharaja Manindra Chandra College on psychometric data analysis and 13 students from the department of applied psychology of the University of Calcutta. RPRIT received appreciation letters from these institutions in recognition of its contribution to student research and skill development. 

Additionally, RPRIT is proud to announce the publication of a book on statistics, developed in collaboration with Acharya Bangalore B-School (ABBS), Bangalore. This initiative brings together esteemed scholars, including Dutta Roy Sir, President of RPRIT, along with Prof. Naresh Babu and Dr. Sharma from ABBS. This collaboration reflects RPRIT’s commitment to advancing statistical knowledge and its practical applications in research and analysis.

About Internship 

In this advanced internship, students will learn to analyze:

- Intra-individual, inter-individual, intra-group, and inter-group variability

- Data-driven insights into human value preferences

- Design, implementation, and presentation of independent research projects.

Take aways for Job: This course prepares students for industry roles by building skills in rank-based decision-making, Excel-based data analysis, and performance evaluation. It enables them to handle survey data, customer feedback, and HR metrics

 

Weekly Modules 

  Week 1: Introduction to data science.(5 hours)

  Week 2: Measurement Scales.(10 hours)

  Week 3: Introduction to rank data.(5 hours)

  Week 4: Descriptive data science.(10 hours)

  Week 5: Diagnostic data science. (10 hours)

  Week 6: Predictive data science.(10 hours)

  Week 7:  Prescriptive Data science.(10 hours)

  Week 8: Exploratory data science. (5 hours)

  Week 9: Text and opinion data science. (10 hours)

  Week 10: Field Investigation. (10 hours)

   Week 11: Project Analysis and Report Writing.

(10 hours)

Week 12: Final Presentation & Viva. (5 hours)

Phase 1: Foundation (Weeks 1–4) - 40 Hours

Phase 2: Data Science Skills (Weeks 5–8) - 40 Hours

Phase 3: Research Projects & Dissemination (Weeks 9–12) - 40 Hours

 

Evaluation Criteria

Attendance & Participation: 15%

Data Collection Quality: 15%

Statistical & Visual Analysis: 20%

Research Report: 30%

Final Presentation: 20%

Tools & Resources

MS Excel (Desktop or Mobile version)

Google Forms/Sheets

Rabindrik Value Preference Documents

Sample questionnaires and templates

RPRIT Virtual Library 

Certification

Certificates will be awarded upon successful completion of:

- Minimum 80% attendance

- All assignments & deliverables

- Submission of project report and presentation

Summary Statistics Cheat Sheet

Mean Rank: =AVERAGE(range)

Median Rank: =MEDIAN(range)

Mode Rank: =MODE.SNGL(range)

Standard Deviation: =STDEV.S(range)

Count of Rank 1: =COUNTIF(range, 1)

Count of Rank X: =COUNTIF(range, X)

Minimum Rank: =MIN(range)

Maximum Rank: =MAX(range)

Observations Count: =COUNTA(range)

Rank (High = 1st): =RANK.EQ(cell, range, 1)

Rank with Ties Avg.: =RANK.AVG(cell, range, 1)

Internship Details:

Eligibility: Undergraduates from any field of study.

Mode: Hybrid

Seats: 30

Duration: 12 weeks(120 Hours)

Registration Fees (non refundable): Rs. 1500

Last Date of registration: 1st July

Contact us: Dr Rama Manna - Academic coordinator M: +919903542602 / Farha - Program Coordinator M: +919998301691

Account Details: Account number: 920020072908427, IFSC Code:- UTIB0000236 , AXIS BANK, DUNLOP (KOLKATA).

 You can pay by Gpay. UPI Address for payment: 9830010547@hdfcbank

: Rank-Based Data Science Using Excel

Duration: 120 Hours

Target Group: Undergraduate Students

Mode: Online and Hybrid

Offered by: Rabindrik Psychotherapy Research Institute Trust (RPRIT), Registered Under Indian Trust Act, 1882 REGD.NO.150600103. DARPAN ID: WB/2025/0514195

Registration Fee: Rs. 1500

1. Introduction

The Rabindrik Psychotherapy Research Institute Trust (RPRIT), a non-profit academic trust established on July 1, 2018, promotes research and training in psychometrics and value-based human behavior aligned with the tenets of Rabindrik Psychotherapy. This expanded 120-hour internship is designed to provide undergraduates with hands-on exposure to rank-based data science using Excel, while applying value-based reasoning in real-life research projects.

In this advanced internship, students will learn to analyze:

- Intra-individual, inter-individual, intra-group, and inter-group variability

- Data-driven insights into human value preferences

- Design, implementation, and presentation of independent research projects

2. Learning Objectives

By the end of the internship, participants will:

- Understand Rabindrik Path- and Goal-Oriented Values in context

- Apply rank-order scaling for value analysis

- Collect and interpret real-world data using Excel

- Visualize trends, variability, and comparative findings

- Conduct independent research and write a structured report

- Develop presentations for academic dissemination

3. Weekly Modules

Week 1: Orientation & Conceptual Foundations (5 hours)

- Introduction to Rabindrik Values and therapeutic background

- Basics of rank order scaling and self-ranking exercise

- Creating Google Forms for value data collection

- Excel basics: data entry and sorting

Week 2: Designing Rank Order Scales (10 hours)

- Constructing valid and reliable value rank scales

- Value dimension planning and item framing

- Developing Excel templates for ranking

- Peer review of draft scale

Week 3: Data Collection Preparation (5 hours)

- Planning systematic data collection process

- Ethical considerations and consent form preparation

- Sample size and respondent list planning

Week 4: Data Collection & Entry (10 hours)

- Data collection from minimum 20 respondents

- Excel data entry, cleaning, validation

- Weekly mentoring on difficulties faced

Week 5: Descriptive Analysis (10 hours)

- Calculating mean, median, mode, SD of ranks

- Excel functions: COUNTIF, RANK, STDEV.S

- Basic visualization: bar graphs, pie charts

Week 6: Group Comparison (10 hours)

- Using pivot tables and conditional formatting

- Gender- and age-wise analysis of Rabindrik values

- Creating comparative charts and interpreting trends

Week 7: Advanced Analysis & Patterns (10 hours)

- Identifying intra-group and inter-individual patterns

- Value variability and preference distribution

- Discussion on value shift over time

Week 8: Mid-Report Submission (5 hours)

- Writing draft report in APA format

- Title, abstract, introduction, method section

Week 9: Research Project Proposal (10 hours)

- Forming research groups and selecting topics

- Hypothesis generation using Rabindrik value model

- Planning methodology and tools

Week 10: Independent Data Collection (10 hours)

- Data collection for project-specific hypothesis testing

- Monitoring student progress and Excel entry

Week 11: Project Analysis and Report Writing (10 hours)

- Conducting full analysis using Excel

- Finalizing interpretation and implications

Week 12: Final Presentation & Viva (5 hours)

- 10-minute student presentation with slides

- Faculty and peer feedback

- Final report and certification

Total: 120 Hours

Phase 1: Foundation (Weeks 1–4) - 40 Hours

Phase 2: Data Science Skills (Weeks 5–8) - 40 Hours

Phase 3: Research Projects & Dissemination (Weeks 9–12) - 40 Hours

4. Evaluation Criteria

Attendance & Participation: 15%

Data Collection Quality: 15%

Statistical & Visual Analysis: 20%

Research Report: 30%

Final Presentation: 20%

5. Tools & Resources

MS Excel (Desktop or Mobile version)

Google Forms/Sheets

Rabindrik Value Reference Documents

Sample questionnaires and templates

Research reading bank (articles by Dutta Roy et al.)

6. Certification

Certificates will be awarded upon successful completion of:

- Minimum 80% attendance

- All assignments & deliverables

- Submission of project report and presentation

7. Contact Information

Dr. Rama Manna (Academic Coordinator)

Email: rpri.edu@gmail.com

Phone: 9903542602

8. Summary Statistics Cheat Sheet

Mean Rank: =AVERAGE(range)

Median Rank: =MEDIAN(range)

Mode Rank: =MODE.SNGL(range)

Standard Deviation: =STDEV.S(range)

Count of Rank 1: =COUNTIF(range, 1)

Count of Rank X: =COUNTIF(range, X)

Minimum Rank: =MIN(range)

Maximum Rank: =MAX(range)

Observations Count: =COUNTA(range)

Rank (High = 1st): =RANK.EQ(cell, range, 1)

Rank with Ties Avg.: =RANK.AVG(cell, range, 1)

9. Suggested Applications

Career Counselling: Rank-based career preference analysis

Therapy Settings: Value awareness in youth counselling

Organizational Behaviour: Mapping employee value systems

Market Research: Consumer preference ranking

Sports Analytics: Performance rankings