Rabindrik Psychotherapy Research Institute Trust: December 2024

Tuesday, December 31, 2024

List of external faculties in 2024

1.Dr. Sumona Dutta

Assistant Professor, Singur Government General Degree College

Dr. Sumona Dutta conducted sessions on Interview Technique and Thematic Technique for the course Qualitative Research Methodology on February 8 and 15, 2024, from 8:00 PM to 10:00 PM.

She also delivered lectures on Principal Component Analysis for the course Introduction to Multivariate Data Analysis on July 17 and 22, 2024, from 7:00 PM to 8:00 PM.

2. Dr. Rita Karmakar

Associate Professor, Amity University

Dr. Rita Karmakar conducted sessions on Case Study and Phenomenology for RPRIT's online certificate course on Qualitative Research Methodology on February 10 and 13, 2024, from 8:00 PM to 10:00 PM.

3. Dr. Sanchita Ghosh

Assistant Professor, West Bengal State University

Dr. Sanchita Ghosh conducted a Practicum on Case Study for RPRIT's online certificate course on Qualitative Research Methodology on March 12, 2024, from 8:00 PM to 10:00 PM.

4. Mrs. Mala Saha

Mind-Body-Soul Counsellor and Founder Secretary, Search Within

She Delivered a lecture on Mindfulness Meditation and Progressive Muscle Relaxation for the course Introduction to Rabindrik Psychotherapy on June 13, 2024, from 9:00 PM to 10:00 PM.

5.Dr. Rituparna Basak Dasgupta

Member of RPRIT

Dr. Rituparna Basak Dasgupta delivered a lecture on Tagore's Philosophy on Art, Music, and Literature for the course Introduction to Rabindrik Psychotherapy on July 24, 2024, from 8:30 PM to 10:00 PM.

She also visited on October 3, 2024, to deliver a lecture on Authoritarian Parenting: The Home and the World for the course Introduction to Rabindrik Psychotherapy in Parenting.

6.Dr. Ivan Das

Guest Faculty, SKBU

Delivered lectures on Binomial and Multinomial Regression for the Three-Month Online Certificate Course on Introduction to Multivariate Data Analysis using SPSS and R-Studio on August 10 and 12, 2024, from 7:00 PM to 8:00 PM.

7.Dr. Atri Sengupta

Associate Professor, Indian Institute of Management, Sambalpur

Dr. Atri Sengupta conducted a session on Data Exploration and Preparation for RPRIT on November 22, 2024, from 7:00 PM to 9:00 PM.

Previously, Dr. Sengupta also served as a resource person for the Two-Month Online Training Course on Systematic Literature Review for Journal Publication, delivering a lecture on Meta-Analysis on September 12, 2024, from 7:00 PM to 8:00 PM.

list of you tube videos

1.https://youtu.be/WlyefC3YECg?si=JmjCFy31GD0jIcot

2.https://www.youtube.com/live/GotlffqTugE?si=zH9EWMLDXFXJIpy4

3.https://www.youtube.com/live/tgOhmeNJWi0?si=Ju4JjgIbel06eH_5

9.https://www.youtube.com/live/3GhcjfvLrOU?si=-pAC9k170BXLaTjo

11. https://www.youtube.com/live/lxMthb-Ed68?si=SUt-UJs2_R-HB0SE

13. https://www.youtube.com/live/nZ2zrVyWbD8?si=042uC0F6JRHnLVlS

14. https://www.youtube.com/live/nj6RqHSfedk?si=L5GFyHAo48gYGsfb

15.

https://www.youtube.com/live/uchxO_IRDMs?si=IQfu7ELJemtLXKiT

16.

https://www.youtube.com/live/QD3eaO_lxBI?si=1iqHICFxRthTJsKb

18. https://www.youtube.com/live/kVutVhjyuc0?si=_Lxhs1ZrsqvYsarm

19. https://www.youtube.com/live/OIhzwyJ8-CY?si=m1fAxzAKzpgnAh_m

20.

https://www.youtube.com/live/L7_SuS68PZ0?si=sE0C_Kfr1Sr7fcWN

21.

https://www.youtube.com/live/gs05z7HM3ag?si=0p9l4pu1_PaT4OE_

22.

https://www.youtube.com/live/nFgEB2Z4FpY?si=-SIxY-ZNqcm2jX7Y

24.

https://www.youtube.com/live/2uFLD7ZCzQk?si=oSAEDGS69AZ0iGM5

25. https://www.youtube.com/live/a2xhvssLIVs?si=6tihf4lxg4DOAbPC

26.

https://www.youtube.com/live/-D0hcsLYq-E?si=OyIc2-BuNQs7wrEl

27.

https://www.youtube.com/live/__CVF6RdIzo?si=Qs0RHVdHSTdvB-2q

28.

https://www.youtube.com/live/jclPqosQ1mY?si=9DnerpDw0v68XK-K

29.

https://www.youtube.com/live/Y0EK1Jq3NGo?si=hDifr5V_71HQPzMs

30. https://www.youtube.com/live/8GVDkaWMkzQ?si=xCebx3MAwFtg4L2l

31.

https://www.youtube.com/live/8iU9yoArOVA?si=RIXxE-xByke2cujn

https://www.youtube.com/live/PBJVFG8TMro?si=tQ8UhcUuzhgH9ZVA

33.

https://www.youtube.com/live/TBzdH_1heIE?si=kVuIab-aNLTRpidZ

34.

https://www.youtube.com/live/QoJ44JJ1eew?si=NlMGX9oy_KxPZFFh

35.

https://www.youtube.com/live/uU9YtCzFpbk?si=w2qXqsejHQEj3zy_

36.

https://www.youtube.com/live/Q9pRn_vlet0?si=Z3ygq2IjN36mn3JN

37.

https://www.youtube.com/live/aAv-wcw5Wm8?si=WxG-eNhaTzaMdzK4

38.

https://www.youtube.com/live/7TrzI8XmVAw?si=OP3ZGhBZFb9AhaJc

https://www.youtube.com/live/jMr4aLqhiok?si=ePMvMrHMBnvQjpUw

https://www.youtube.com/live/PyaWVshh56U?si=wg-CxdVcDYAOpQS4

https://www.youtube.com/live/2cdXO-JBpBc?si=ssuRVdMnd3k8rvi7

42.

https://www.youtube.com/live/x3rST7CQ3So?si=rLtbzTjA-eSKtVYa

43.

https://www.youtube.com/live/I_vDGzW9KTU?si=6m7QqniQ2XIGFK4t

44.

https://www.youtube.com/live/l9aq4KP6hdU?si=d09dYKOARDfMh3e0

https://www.youtube.com/live/egw1-6fPZdo?si=NMRshSxKcMVCm_NZ

46.

https://www.youtube.com/live/uWf4N-Kjzq8?si=3XFhR9PWVFCeJwtz

47.

https://www.youtube.com/live/RWWfgn6jf2Q?si=MaKRUZgJwIEUNb_v

48.

https://www.youtube.com/live/5LLQ1cOCZ_w?si=iMkXu1qG31kjxFWw

49.

https://www.youtube.com/live/OE7OtqSiaQE?si=8eLsQh702xc_Nr89

50.

https://www.youtube.com/live/-2eeOf6IiOM?si=BsOAZnwqUg7fY8KX

51.

https://www.youtube.com/live/Gl2JNureEHQ?si=mIDhzQx-IHIw85XA

52.

https://www.youtube.com/live/Vqv4fOjXQYo?si=HQhMdCUbpo4uDCEc

53.

https://www.youtube.com/live/RYFPptWF6Fc?si=FmVMw4CiZ34u1JdX

54.

https://www.youtube.com/live/KrrNvDHS0A0?si=ZLR1YZ0LncvrL3MH

55.

https://www.youtube.com/live/Ukow02FOfoc?si=3g5xOMvXh1oJs5fp

56.

https://www.youtube.com/live/ZBfZSN2UqP0?si=1J36WoNLbQeNa5UA

57.

https://www.youtube.com/live/ZymFNtwMvKg?si=g8hqb-qnZUJMqQmo

58.

https://www.youtube.com/live/WxIiEu1Nk_0?si=4M3ryzsosim-5rG9

59.

https://www.youtube.com/live/sCQ1WnQe8Oo?si=kY0tI_nMKhnuBcny

60.

https://www.youtube.com/live/2OclVCt-AZ0?si=tHyALIZvxLz9QZy1

61.

https://www.youtube.com/live/GLWHFs7zYq4?si=ooMH4m80l-_Zt1bY

62.

https://www.youtube.com/live/GotlffqTugE?si=XwsQM7Z2vOWs7z06

63.

https://www.youtube.com/live/1AIJDWZ_JG4?si=V2eVF5VT9der68To

64.

https://www.youtube.com/live/1nV4Jz_Akqg?si=mVB_d9YrdVYqxxKS

65.

https://www.youtube.com/live/ifQyaYvqLeU?si=UBnd2Q4gB9cyFL5e

66.

https://www.youtube.com/live/KsVO61e3CZ8?si=R4cAa8RmS7NfE4hZ

67.

https://www.youtube.com/live/uGlPjnoIpKg?si=VF_UMVaSaYeSRB44

68.

https://www.youtube.com/live/vWquzVK2Qgc?si=bQ_tLfKpKzIagewh

69.

https://www.youtube.com/live/w_YKonNa7Yc?si=1GZBW5YBguxjTPdB

73.

https://www.youtube.com/live/jKb5mg6fUhU?si=1NtizDegLwlcrDMS

75.

https://www.youtube.com/live/9UKuwQcI0HY?si=z_TaULNVIgtKMKD6

82.

https://www.youtube.com/live/Yl9UoBG_j_4?si=P8YNWRe3DFAa4BnX

84.

https://www.youtube.com/live/HiU1LAfWdlQ?si=q1YKy_u8pf9XDBSH

85.

https://www.youtube.com/live/9iJ38LOUbC4?si=DlaviDrfoyn7UDmS

86.

https://www.youtube.com/live/BeBo6egwuRY?si=UUq6C26ylLyTYtYa

87.

https://www.youtube.com/live/YakmBOAp7hk?si=4EIgXf29UZgjIR1x

80.

https://www.youtube.com/live/CzX80KxzwYA?si=uZKb0L-3kDJw1JDv

90.

https://www.youtube.com/live/OcR8vwykMBw?si=qqS5GrekzIxnIKCo

91.

https://www.youtube.com/live/Icjey0vLutQ?si=Nsh46apMjSi3lAgd

92.

https://www.youtube.com/live/hQNO8SXtWQw?si=99631j8QwnGNILsD

93.

https://www.youtube.com/live/wgNNrp7GA-o?si=nlndWqLMlIOBrhvq

94.

https://www.youtube.com/live/m-dYRGMwHLk?si=tNu_3R01ED4AckfK

96.

https://www.youtube.com/live/4RTTAwMJuGg?si=k1oYuGUxOWDRw2pM

97.

https://www.youtube.com/live/9Ih92JKve_w?si=K2aatnqWmZubRxbB

98.

https://www.youtube.com/live/9qwFtpTfcm8?si=5y-PuAK3LzMDgoXt

Wednesday, December 18, 2024

Practicum, Project and Dissertation

The terms practicum, project, and dissertation refer to different types of academic or professional work, each with distinct purposes, formats, and outcomes. Here's a breakdown of their differences:

1. Practicum

Definition: A practicum is a supervised practical experience in a real-world setting, designed to apply academic knowledge to practice.
Purpose: To gain hands-on experience and develop practical skills in a professional environment.
Structure: Often involves working in an organization (e.g., hospitals, schools, companies) under the guidance of a mentor or supervisor.
Assessment: Evaluation may include a reflective report, supervisor feedback, or a presentation on the experience.
Fields: Common in fields like education, social work, healthcare, and business.

2. Project

Definition: A project is a focused piece of work aimed at solving a specific problem or exploring a topic, often through practical or creative means.
Purpose: To demonstrate the ability to apply knowledge and skills to achieve a defined goal.
Structure: Can be individual or group-based, and often involves planning, executing, and presenting the outcomes.
Assessment: Evaluated based on deliverables such as a report, prototype, presentation, or portfolio.
Fields: Widely used across disciplines, including engineering, IT, management, and the arts.

3. Dissertation

Definition: A dissertation is a formal academic document that presents original research on a specific topic.
Purpose: To contribute new knowledge to the field through systematic investigation.
Structure: Typically includes an introduction, literature review, methodology, results, discussion, and conclusion.
Assessment: Assessed through a written document and often an oral defense before a committee.
Fields: Common in advanced degrees (master’s, Ph.D.) across disciplines.

Key Differences

Aspect	Practicum	Project	Dissertation
Focus	Practical experience	Problem-solving/creation	Original research
Setting	Real-world workplace	Varied (labs, studios, etc.)	Academic/research environment
Duration	Short-term (weeks/months)	Moderate	Long-term (months/years)
Output	Reflective report/presentation	Deliverables (e.g., product)	Research document
Assessment Basis	Skills and application	Outcome and implementation	Academic rigor and originality

Each serves a unique role in academic and professional development, depending on the program's goals and requirements.

Tuesday, December 17, 2024

list of technical reports

1. Human Well-Being and Quality of Life

This category focuses on individual and societal well-being, addressing life satisfaction, job satisfaction, and health-related quality of life.

1. Amruta Arabhavi (Mumbai) - Quality of Life in the Elderly: Exploring the Effects of Age, Sex, and Education.

2. Sara Chavan (Mumbai) - A Study on Indian Psychologists’ Quality of Life.

3. Dr. Seema R Sarraf (Lucknow) - Job Satisfaction in School Teachers.

4. Seema Rani Sarraf (Lucknow) - Job Satisfaction and Organizational Health Among School Teachers.

5. Nishu Chandna (Lucknow) - Impact of Online Classes on Psychological Well-Being of Teachers During Online Teaching in the Covid-19 Era.

6. Subrata Dalal (Kolkata) - Work Family Conflict Among Nurses.

7. Poonam Singh (Bareilly) - A Study on Altruism and Happiness in Young Adults.

8. Dr. Kakoli Das (Assam) - Obstacles Faced by Caregivers: An Interview Analysis.

9. Shrestha Ash (Kolkata) - Understanding the Dynamics of Caregiver: An Interview Analysis.

10. Kabita Sahoo (Kolkata) - Perception and Experience of Quality Care of Post-Caesarean Mothers: An Interview Analysis.

11. Subrata Dalal (Kolkata) - Psychological Impact of Vision Impairment Among Diabetics: An Interview Analysis.

________________________________________

2. Values, Emotions, and Environmental Dynamics

Reports examining values, emotional control, and the impact of environmental knowledge and attitudes on behavior.

12. Dhanushi Mayank Sharma (Ahmedabad) - Preference to Emotional Control Values of College Teachers.

13. Prabhnain Kaur (Noida) - Exploring Systematic Values Among College Teachers.

14. Ankita Dey Tapader (Kolkata) - Assessment of Self Awakening Value.

15. Kabita Sahoo (Kolkata) - Assessment of Fearlessness Value.

16. Lalrinawmi Rawite (Mizoram) - Assessment of Cleanliness Value.

17. Monalisa Pattanayak (Odisha) - Assessment of Work-Family Compatibility (WFC) Value.

18. Rudrani Mitra (Kolkata) - Assessment of Self Understanding Value.

19. Subrata Dalal (Kolkata) - Assessment of Resolute Value.

20. Sreyashi Sen (Kolkata) - Assessment of Resolute Value.

21. Sophie Lalrinnungi (Kolkata) - Assessment of Doubtless Value.

22. Anjali Maurya (Bangalore) - A Comparative Study on the Relationship of Pro-Environmental Attitude, Pro-Environmental Behaviour and Nature-Relatedness among Students Studying Environmental and Non-Environmental Disciplines.

23. Dr. Nimrat Singh (Ahmedabad) - A Comparative Study on the Relationship of Pro-Environmental Attitude, Pro-Environmental Behaviour and Nature-Relatedness among Students Studying Environmental and Non-Environmental Disciplines.

24. Monalisa Pattanayak (Odisha) - Impact of Environmental Knowledge on Pro-environmental Attitude: A Study Conducted Among the College Students.

________________________________________

3. Cultural and Narrative Psychology

Studies analyzing cultural narratives and psychological themes in literature and self-esteem.

25. Monalisa Pattanayak (Odisha) - The Theme of Humanity in ‘Chandalika’: A Narrative Analysis.

26. Swati Punia (Delhi) - ‘Chandalika’: A Narrative Analysis.

27. Sreelakshmi K (Kerala) - The Theme of Humanity in ‘Chandalika’: A Narrative Analysis.

28. Dalia Das (Kolkata) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

29. Gargi Datta (USA) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

30. Oindrila Das (Kolkata) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

31. Papiya Banerjee (Kolkata) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

32. Sudeshna Das Adhikari (Kolkata) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

33. Chandraie Sarkhel (Kolkata) - Analyzing the Self-Esteem in Rabindranath Tagore’s “Chandalika.”

________________________________________

4. Psychometric and Multivariate Data Analysis

Reports leveraging statistical tools to analyze career data, values, and psychometric frameworks.

34. Abhishek Biswas (Kolkata) - Analysis of Career Assessment Data.

35. Trishna Dey (Kolkata) - Analysis of Career Assessment Data.

36. Risha Brahma (Kolkata) - Analysis of Career Assessment Data.

37. Deepjyoti Banerjee (Kolkata) - Analysis of Career Assessment Data.

38. Arka Bhattacharya (Kolkata) - Analysis of Career Assessment Data.

39. Sourin Chatterjee (Kolkata) - Analysis of Career Assessment Data.

40. Pritish Manna (Kolkata) - Analysis of Career Assessment Data.

41. Subhadeep Manna (Kolkata) - Analysis of Career Assessment Data.

42. Jwel Mondal (Kolkata) - Analysis of Career Assessment Data.

43. Raja Sarkar (Kolkata) - Analysis of Career Assessment Data.

44. Ayan Seal (Kolkata) - Analysis of Career Assessment Data.

45. Dr. Amit Tirpude (Raipur) - Principal Component Analysis of the Rabindrik Human Value Preferences Between India and Bangladesh.

46. Fahmida Tofail (Bangladesh) - Analyzing Gender Differences in Rabindrik Values: A Multivariate Approach.

47. Kabita Sahoo (Kolkata) - Principal Component Analysis of the Rabindrik Human Value Preferences According to Age.

48. Shubham Pandey (Banaras) - Multivariate Analysis of Rabindrik Values: Exploring Gender and Nationality Differences in Resilience, Self-Regulation, and Certainty.

49. Poushali Baidya (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

50. Jayeta Bhanja (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

51. Jineya Dey (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

52. Sagnik Dutta (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

53. Sk Kabir Husan (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

54. Salini Mondal (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

55. Sridatri Kar (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

56. Anuska Pal (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

57. Doyel Paul (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

58. Madhuparna Rajak (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

59. Debanjana Roy (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

60. Afrin Saba (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

61. Sanchari Saha (Kolkata) - Study of the Principal Component Analysis of Safety Consciousness of Industrial Workers.

________________________________________

5. Systematic Reviews and Innovative Learning

Reviews summarizing methodologies and innovations in education and healthcare.

62. Dr. Amit Tirpude (Raipur) - 3D Printing in Anatomy Education: Analyzing Learning Outcomes, Regional Variability, and Skill Acquisition: A Systematic Review.

63. Dr. Dharam Singh Rathia (Raipur) - A Review of the Various Teaching Techniques and Tools to Assess the Utility of 3D Printed Anatomical Models for Learning Human Anatomy.

64. Kabita Sahoo (Kolkata) - Assessment of Determinants Related to Short Inter-Conceptional Pregnancy Among Parous Pregnant Women.

65. Dr. Amit Tirpude (Raipur) - Reading and Writing Motivation in First-year Medical Students.

66. Varsha Madhulika (Bangalore) - An Exploratory Study on Writing Motivation and Note-taking Behaviour of College Students of India.

Thursday, December 5, 2024

List of Sunday Webinars

1.https://youtu.be/WlyefC3YECg?si=JmjCFy31GD0jIcot

2.https://www.youtube.com/live/GotlffqTugE?si=zH9EWMLDXFXJIpy4

3.https://www.youtube.com/live/tgOhmeNJWi0?si=Ju4JjgIbel06eH_5

9.https://www.youtube.com/live/3GhcjfvLrOU?si=-pAC9k170BXLaTjo

11. https://www.youtube.com/live/lxMthb-Ed68?si=SUt-UJs2_R-HB0SE

13. https://www.youtube.com/live/nZ2zrVyWbD8?si=042uC0F6JRHnLVlS

14. https://www.youtube.com/live/nj6RqHSfedk?si=L5GFyHAo48gYGsfb

15.

https://www.youtube.com/live/uchxO_IRDMs?si=IQfu7ELJemtLXKiT

16.

https://www.youtube.com/live/QD3eaO_lxBI?si=1iqHICFxRthTJsKb

18. https://www.youtube.com/live/kVutVhjyuc0?si=_Lxhs1ZrsqvYsarm

19. https://www.youtube.com/live/OIhzwyJ8-CY?si=m1fAxzAKzpgnAh_m

20.

https://www.youtube.com/live/L7_SuS68PZ0?si=sE0C_Kfr1Sr7fcWN

21.

https://www.youtube.com/live/gs05z7HM3ag?si=0p9l4pu1_PaT4OE_

22.

https://www.youtube.com/live/nFgEB2Z4FpY?si=-SIxY-ZNqcm2jX7Y

24.

https://www.youtube.com/live/2uFLD7ZCzQk?si=oSAEDGS69AZ0iGM5

25. https://www.youtube.com/live/a2xhvssLIVs?si=6tihf4lxg4DOAbPC

26.

https://www.youtube.com/live/-D0hcsLYq-E?si=OyIc2-BuNQs7wrEl

27.

https://www.youtube.com/live/__CVF6RdIzo?si=Qs0RHVdHSTdvB-2q

28.

https://www.youtube.com/live/jclPqosQ1mY?si=9DnerpDw0v68XK-K

29.

https://www.youtube.com/live/Y0EK1Jq3NGo?si=hDifr5V_71HQPzMs

30. https://www.youtube.com/live/8GVDkaWMkzQ?si=xCebx3MAwFtg4L2l

31.

https://www.youtube.com/live/8iU9yoArOVA?si=RIXxE-xByke2cujn

https://www.youtube.com/live/PBJVFG8TMro?si=tQ8UhcUuzhgH9ZVA

33.

https://www.youtube.com/live/TBzdH_1heIE?si=kVuIab-aNLTRpidZ

34.

https://www.youtube.com/live/QoJ44JJ1eew?si=NlMGX9oy_KxPZFFh

35.

https://www.youtube.com/live/uU9YtCzFpbk?si=w2qXqsejHQEj3zy_

36.

https://www.youtube.com/live/Q9pRn_vlet0?si=Z3ygq2IjN36mn3JN

37.

https://www.youtube.com/live/aAv-wcw5Wm8?si=WxG-eNhaTzaMdzK4

38.

https://www.youtube.com/live/7TrzI8XmVAw?si=OP3ZGhBZFb9AhaJc

https://www.youtube.com/live/jMr4aLqhiok?si=ePMvMrHMBnvQjpUw

https://www.youtube.com/live/PyaWVshh56U?si=wg-CxdVcDYAOpQS4

https://www.youtube.com/live/2cdXO-JBpBc?si=ssuRVdMnd3k8rvi7

42.

https://www.youtube.com/live/x3rST7CQ3So?si=rLtbzTjA-eSKtVYa

43.

https://www.youtube.com/live/I_vDGzW9KTU?si=6m7QqniQ2XIGFK4t

44.

https://www.youtube.com/live/l9aq4KP6hdU?si=d09dYKOARDfMh3e0

https://www.youtube.com/live/egw1-6fPZdo?si=NMRshSxKcMVCm_NZ

46.

https://www.youtube.com/live/uWf4N-Kjzq8?si=3XFhR9PWVFCeJwtz

47.

https://www.youtube.com/live/RWWfgn6jf2Q?si=MaKRUZgJwIEUNb_v

48.

https://www.youtube.com/live/5LLQ1cOCZ_w?si=iMkXu1qG31kjxFWw

49.

https://www.youtube.com/live/OE7OtqSiaQE?si=8eLsQh702xc_Nr89

50.

https://www.youtube.com/live/-2eeOf6IiOM?si=BsOAZnwqUg7fY8KX

51.

https://www.youtube.com/live/Gl2JNureEHQ?si=mIDhzQx-IHIw85XA

52.

https://www.youtube.com/live/Vqv4fOjXQYo?si=HQhMdCUbpo4uDCEc

53.

https://www.youtube.com/live/RYFPptWF6Fc?si=FmVMw4CiZ34u1JdX

54.

https://www.youtube.com/live/KrrNvDHS0A0?si=ZLR1YZ0LncvrL3MH

55.

https://www.youtube.com/live/Ukow02FOfoc?si=3g5xOMvXh1oJs5fp

56.

https://www.youtube.com/live/ZBfZSN2UqP0?si=1J36WoNLbQeNa5UA

57.

https://www.youtube.com/live/ZymFNtwMvKg?si=g8hqb-qnZUJMqQmo

58.

https://www.youtube.com/live/WxIiEu1Nk_0?si=4M3ryzsosim-5rG9

59.

https://www.youtube.com/live/sCQ1WnQe8Oo?si=kY0tI_nMKhnuBcny

60.

https://www.youtube.com/live/2OclVCt-AZ0?si=tHyALIZvxLz9QZy1

61.

https://www.youtube.com/live/GLWHFs7zYq4?si=ooMH4m80l-_Zt1bY

62.

https://www.youtube.com/live/GotlffqTugE?si=XwsQM7Z2vOWs7z06

63.

https://www.youtube.com/live/1AIJDWZ_JG4?si=V2eVF5VT9der68To

64.

https://www.youtube.com/live/1nV4Jz_Akqg?si=mVB_d9YrdVYqxxKS

65.

https://www.youtube.com/live/ifQyaYvqLeU?si=UBnd2Q4gB9cyFL5e

66.

https://www.youtube.com/live/KsVO61e3CZ8?si=R4cAa8RmS7NfE4hZ

67.

https://www.youtube.com/live/uGlPjnoIpKg?si=VF_UMVaSaYeSRB44

68.

https://www.youtube.com/live/vWquzVK2Qgc?si=bQ_tLfKpKzIagewh

69.

https://www.youtube.com/live/w_YKonNa7Yc?si=1GZBW5YBguxjTPdB

73.

https://www.youtube.com/live/jKb5mg6fUhU?si=1NtizDegLwlcrDMS

75.

https://www.youtube.com/live/9UKuwQcI0HY?si=z_TaULNVIgtKMKD6

82.

https://www.youtube.com/live/Yl9UoBG_j_4?si=P8YNWRe3DFAa4BnX

84.

https://www.youtube.com/live/HiU1LAfWdlQ?si=q1YKy_u8pf9XDBSH

85.

https://www.youtube.com/live/9iJ38LOUbC4?si=DlaviDrfoyn7UDmS

86.

https://www.youtube.com/live/BeBo6egwuRY?si=UUq6C26ylLyTYtYa

87.

https://www.youtube.com/live/YakmBOAp7hk?si=4EIgXf29UZgjIR1x

80.

https://www.youtube.com/live/CzX80KxzwYA?si=uZKb0L-3kDJw1JDv

90.

https://www.youtube.com/live/OcR8vwykMBw?si=qqS5GrekzIxnIKCo

91.

https://www.youtube.com/live/Icjey0vLutQ?si=Nsh46apMjSi3lAgd

92.

https://www.youtube.com/live/hQNO8SXtWQw?si=99631j8QwnGNILsD

93.

https://www.youtube.com/live/wgNNrp7GA-o?si=nlndWqLMlIOBrhvq

94.

https://www.youtube.com/live/m-dYRGMwHLk?si=tNu_3R01ED4AckfK

96.

https://www.youtube.com/live/4RTTAwMJuGg?si=k1oYuGUxOWDRw2pM

97.

https://www.youtube.com/live/9Ih92JKve_w?si=K2aatnqWmZubRxbB

98.

https://www.youtube.com/live/9qwFtpTfcm8?si=5y-PuAK3LzMDgoXt

Wednesday, December 4, 2024

Text mining in MS-Excel

UPPER: Converts text to uppercase. Example: =UPPER("text") returns "TEXT".
LOWER: Converts text to lowercase. Example: =LOWER("TEXT") returns "text".
PROPER: Capitalizes the first letter of each word. Example: =PROPER("hello world") returns "Hello World".
LEFT: Extracts a specified number of characters from the start of a text string. Example: =LEFT("Excel", 2) returns "Ex".
RIGHT: Extracts a specified number of characters from the end of a text string. Example: =RIGHT("Excel", 2) returns "el".
MID: Extracts a substring starting at a specified position. Example: =MID("Excel", 2, 3) returns "xce".
LEN: Returns the number of characters in a text string, including spaces. Example: =LEN("Excel") returns 5.
SEARCH: Finds the position of a text string within another (case-insensitive). Example: =SEARCH("c", "Excel") returns 3.
FIND: Finds the position of a text string within another (case-sensitive). Example: =FIND("c", "Excel") returns 3.
SUBSTITUTE: Replaces occurrences of old text with new text. Example: =SUBSTITUTE("Excel", "c", "x") returns "Exxel".
REPLACE: Replaces part of a text string with another. Example: =REPLACE("Excel", 2, 3, "mpl") returns "Empl".
CONCAT: Joins multiple text strings into one. Example: =CONCAT(A1, B1) combines the text in A1 and B1.
TEXTJOIN: Joins text strings with a specified delimiter. Example: =TEXTJOIN(", ", TRUE, A1, B1, A2) joins with commas.
TRIM: Removes extra spaces from text. Example: =TRIM(" Excel ") returns "Excel".
CLEAN: Removes non-printable characters from text. Example: =CLEAN("Excel ") returns "Excel".
EXACT: Checks if two text strings are exactly the same (case-sensitive). Example: =EXACT("Excel", "excel") returns FALSE.