Data Science
Create a live Excel dashboard to manage volunteer data for an NGO
Create an excel-based database management system for maintaining volunteer records at an NGO
About this Menternship
Opportunity:
Teach for India an education-focussed NGO that trains mid-career professionals to be social impact leaders via a two-year fellowship program. Professionals who have completed training in the Teach For India (TFI) fellowship are now serving more than 33 million children in the country. More than 77% of TFI fellows continue to serve in the social sector. 
TFI is attempting to repair India’s educational crisis through Innovation Cell programmes that equip teachers, students and entrepreneurs to spark long term change in education. Through social and print media- TFI has garnered the support of thousands of people from a wide range of sectors, all of whom are invested in the vision of an excellent education for all children.


Problem:
NGOs like Teach for India depend on volunteers to drive a lot of their ground and strategy work. Volunteers can join an NGO to simply support a campaign for social good like cleanliness drive, or they can join an NGO for a longer duration to contribute to more strategic roles via their professional skills. For example, professionals like accountants and data scientists frequently volunteer at NGOs to help them improve their accounting and data management systems. Similarly, designers, teachers, writers etc can all contribute to an NGO’s work. For a big NGO like TFI, it is important to keep track of the various volunteers who have worked with it or have expressed interest in contributing to its work. The challenge is to maintain this database in a manner that is automated and efficient. The database should integrate well with methods of data collection about volunteer information and it should serve the purpose of teams who need to access this data regularly.

Deliverable:
Use advanced MS Excel functions to create an automated database for volunteer management at an NGO
Why take up this Menternship?
On completing this Menternship, you will learn about
You will explore: 
Advanced Analytics
MS Excel - Pivot, VLookup, and Dashboard building

You will apply:
Database management
Data visualization

You will create:
An automated excel dashboard for tracking and managing volunteer activity in an NGO


Expected Output
  1. SOP and quality checklist for data collection and management of volunteer activity
  2. Excel - Volunteer Management System
Create a live Excel dashboard to manage volunteer data for an NGO
Build Real Skills through practical experience.
Each Menternship is rooted in MentorMind's experiential learning model that guides you on how to apply all theoretical learnings into real world practice at work.
Do Real Work that matches corporate expectations.
Every Menternship is specially designed on real work that is done in the field at the company. All work outputs you are guided to produce over the duration & different phases of a Menternship will match corporate expectations.
Showcase your Official Certification.
You get officially certified by our partner company on successfully completing a Menternship. Simply add it on your CV and your LinkedIn as a proof of your real skills & work experience to gain a headstart in opportunities that come your way!