60 hour Rank-Based Data Science Using Excel

-

 Internship Handbook

Title: Rank-Based Data Science Using Excel
Duration: 60 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

1. Introduction

The Rabindrik Psychotherapy Research Institute Trust (RPRIT), Non Profit oriented registered Academic Trust  was established on July 1st, 2018, with a dedicated focus on advancing training and research methodologies within the academic domain, particularly in psychometrics, to support various principles of Rabindrik Psychotherapy. Through extensive research internship programs and collaborative efforts with both academic and non-academic institutions, RPRIT has consistently nurtured the development of research skills among participants.
In this research internship, students will learn the followings :
1. Intra individual variability.
2. Intra group variability.
3. Inter individual variability.
4. Individual and group variability. 
They will learn the variability, trends, and patterns through statistics and data visualization. 

This internship aims to introduce students to the theoretical and practical aspects of human value preference analysis, rooted in Rabindrik Psychotherapy. Students will engage in rank order scaling methodology using MS Excel to explore value hierarchies among individuals and groups. Data analysis using ranking provides a way to understand the relative importance or position of items within a dataset, simplifying complex information and highlighting key patterns. This method is valuable for various reasons, including validating research, uncovering trends, and making informed decisions in fields like market research and sports analytics. 

Registration for 60 hours internship form 

2. Learning Objectives

By the end of this internship, students will:

  • Understand the foundational concepts of Data science and Rabindrik Value Preferences.

  • Learn how to develop and apply rank order scaling techniques.

  • Use MS Excel for data entry, management, and analysis.

  • Collect, analyze, and interpret real-life data on value preferences.

  • Develop a structured research report and deliver a presentation.

3. Weekly Modules

Week 1: Orientation & Conceptual Foundations

  • Introduction to Rabindrik Values and therapeutic background

  • Basics of rank order scaling

  • Creating Google form for data collection.

  • Introductory Excel skills for data entry and sorting

  • Deliverable: Reflection on personal value preferences

Week 2: Designing Rank Order Scales

  • Constructing a rank order scale for Rabindrik values

  • Minimum 10 data collection by each student.

  • Creating Excel templates for ranking tasks

  • Deliverable: Draft value preference questionnaire

Week 3: Data Collection Planning

  • Planning ethical and systematic data collection

  • Designing consent forms and sampling framework

  • Deliverable: Data collection plan and respondent list

Week 4: Data Collection

  • Field data collection from selected samples

  • Excel data entry and cleaning

  • Deliverable: Completed dataset (minimum 20 respondents)

Week 5: Data Analysis Part 1

  • Summary statistics

  • Introduction to rank computation and analysis in Excel

  • Creating charts and visual profiles

  • Deliverable: Value preference profile of the sample

Week 6: Data Analysis Part 2

  • Advanced Excel techniques: conditional formatting, pivot tables

  • Comparative analysis between demographic groups

  • Deliverable: Group-wise comparison charts

Week 7: Report Writing

  • Writing a research report in APA format

  • Structuring findings, visuals, and interpretations

  • Deliverable: Internship research report draft

Week 8: Presentation & Evaluation

  • Student presentations (10 minutes each)

  • Peer and faculty feedback

  • Final assessment

  • Deliverable: Final report and presentation slides

4. Evaluation Criteria

  • Attendance and Participation: 20%

  • Quality of Data Collection: 20%

  • Accuracy of Analysis: 20%

  • Report Writing: 20%

  • Final Presentation: 20%

5. Tools & Resources

  • MS Excel (latest version preferred)

  • Internet access

  • Rabindrik Value Reference Document

  • Excel Template (provided)

  • Sample questionnaires and reports

6. Certification

Students who successfully complete all modules and submit their final report and presentation will receive a certificate of completion.

7. Contact Information

For queries and support, contact:
Dr. Rama Manna (Academic Co-ordinator)
Email: rpri.edu@gmail.com
Phone: 9903542602

Summary statistics

StatisticExcel Formula
Mean Rank=AVERAGE(range)
Median Rank=MEDIAN(range)
Mode (most frequent)=MODE.SNGL(range)
Standard Deviation=STDEV.S(range)
Count of Rank 1=COUNTIF(range, 1)
Count of Any Rank X=COUNTIF(range, X)
Minimum Rank=MIN(range)
Maximum Rank=MAX(range)
Number of Observations=COUNTA(range)
Rank a set of values=RANK.EQ(cell, range, [order])
Rank with average ties=RANK.AVG(cell, range, [order])

  • Market Research:
    Ranking products or services based on customer preference to identify the most popular items.
  • Sports Analytics:
  • Ranking athletes based on performance metrics to identify top performers or areas for improvement. 
  • Everyday Life:
    Ranking options based on personal preference, such as choosing the best restaurant for dinner. 
Dutta Roy, D. (2015). Rabindrik Value Orientations of War Returned Senior Rank Police Officers.
Journal: Journal of Organization & Human Behaviour, 4(4).
Details: This study explores how senior police officers returning from conflict zones exhibit value orientations aligned with Rabindrik principles, emphasizing path-oriented (e.g., self-awakening, resoluteness) and goal-oriented (e.g., peace, altruism) values derived from Rabindranath Tagore’s works. It addresses the application of these values in high-stress professions.

2. Shah, H., & Dutta Roy, D. (2015). Structure of Rabindrik Human Values.Indian Journal of Positive Psychology, 5(4), 368-375.
    • Details: This study analyzed data from 519 adolescent students to explore latent structures of Rabindrik human values using principal component analysis. It identified four components of path-oriented values (70% variance) and two components of goal-oriented values (80% variance), highlighting their relevance in Rabindrik psychotherapy and human resource management.
    • Source:,
      3. Dutta Roy, D., & Bhaduri, S. (2014). Gender and Rabindrik Value Orientation.Journal: Psybernews, 5(1), 46-50.
    • Details: This article examines how gender influences Rabindrik value orientations, focusing on differences in path- and goal-oriented values. It draws on Tagore’s songs to explore universal values like self-awakening and universalization across genders.
    • Source:
  3. Dutta Roy, D., & Basu, D. (2013). Rabindrik Work Value Preference. Psybernews, 4(2), 82-89.
    • Details: This study investigates work value preferences through the lens of Rabindrik values, emphasizing principles like the niskam principle (selfless work) and their impact on workplace behavior and motivation.
    • Source:
      Dutta Roy, D. (2014). Rabindrik Psychotherapy. Journal of Social Science & Welfare, 1(1), 44-53.
    • Details: This foundational article outlines the framework of Rabindrik psychotherapy, which integrates Rabindrik values to foster self-awakening and harmony. It discusses the application of path- and goal-oriented values in therapeutic settings without labeling disorders.
    • Source:
  5. Dutta Roy, D. (2019). Rabindrik Psychotherapy and Consciousness Flow.Monotori, 2, 20-21.
    • Details: This article delves into how Rabindrik psychotherapy influences consciousness flow, leveraging values like harmony and peace to enhance mental health outcomes.
    • Source:

Comments

Post a Comment

Popular posts from this blog

UGC guidelines for undergraduate internship

-
The University Grants Commission (UGC) has issued guidelines to promote internships for undergraduate students under the National Education Policy (NEP) 2020, aiming to enhance employability, skill development, and experiential learning. Here are the key points of the UGC Guidelines for Undergraduate Internship: 1. Duration and Credit Allocation Internships are mandatory and should be a part of the undergraduate curriculum. Minimum duration: 8–10 weeks (approx. 2–3 months). Internships carry 2 to 4 credits, depending on the duration and effort. 2. Types of Internships Research internships with faculty or institutions. Industry internships in private or public sectors. Social or community engagement internships (NGOs, Panchayats, local bodies). Entrepreneurial internships or field-based projects. 3. Implementation Framework Institutions must have an Internship Cell. A mentor or faculty guide must supervise the internship. MOUs with industries or organizations are encouraged. 4. Assessme...
Read more

6-months course on Foundation of School psychology

-
School psychology is a specialized field that combines psychology, education, and child development to support the academic, social, and emotional well-being of students. School psychologists work with students, teachers, parents, and other school professionals to create a supportive and inclusive learning environment. This course provides an overview of the principles, theories, and practices of school psychology. Students will learn about the historical and philosophical foundations of school psychology, as well as the key concepts and methods used in the field. Topics will include: Throughout the course, students will engage in discussions, readings, and activities designed to promote critical thinking, problem-solving, and professional growth. By the end of the course, students will have a comprehensive understanding of the field of school psychology and be prepared to apply this knowledge in real-world settings. Registration : click here Course Outcomes: By the end of this course,...
Read more

Therapeutic postulates of Rabindrik Psychotherapy

-
1. Consciousness is free floating ‌2. It is unbound. ‌3. Do not label rather understand other's consciousness. ‌4. Consciousness is composed of three layers Murta, Raga and Saraswat. ‌5. Experience of Consciousness is like a journey from incomplete to complete across three layers. ‌6. Man is pursuer of newness. ‌7.Man is pursuer of completeness. ‌8. Searching newness makes man incomplete that acts as the driver to find out completeness. ‌9. Incomplete to complete is a cyclic process. ‌10. Image characteristics change across layers of consciousness. ‌11. Man has power to customise environment for change in consciousness layers. ‌12. Incoming images  are changed when it came out from saraswat layer. ‌13. Murta image has structure but no affect or emotion. ‌14. Raga layer based image is affected by emotion. ‌15. Saraswat image indicates harmony of object and environment. ‌16. Incom...
Read more