Back to all projects

Excel Dashboard Creation

Help CorpsAfrica set up an accessible template to track key performance indicators to help measure their success.
CorpsAfrica
New York, NY, USA
CorpsAfrica
Unfollow
Log in to follow
CorpsAfrica
New York, NY, USA

0

Live Projects

6

Matched Projects
0 Followers
Cause
Philanthropy & capacity building
Skills
Data analysis

Posted February 21st

Excel Dashboard Creation

Project details

What we need
  • A dashboard in Excel or Google Sheets that visualizes key performance indicators (KPIs), with data from up to 3 sources
  • Training on how to consistently update the dashboard for ongoing use
  • Optional: Training on how to edit dashboard and execute on formulas and functions that will allow for its evolution
Additional details

CorpsAfrica has African Volunteers serving locally for a year in four countries (Morocco, Senegal, Rwanda, and Malawi). Our primary external donor wants to see more clear, streamlined, and simplified data on how Volunteer projects are impacting local communities of service. But the reality of grassroots development and community wellness is anything but simple. We need a way to balance these two competing realities, utilizing Volunteer data to create a simple snapshot of CorpsAfrica's impact.

What we have in place
  • We currently have notes from our M&E strategy conversations, quarterly reports, which should make it easy for you to get started. We also have M&E data from each country office on Volunteers, and the ability to provide any other information you need.
How this will help
This project will save us $4,828 , allowing us to grow our Headquarters staff, allowing for more specialized roles such as someone dedicated to enhancing M&E and fundraising.

Simply put, demonstrating CorpsAfrica's impact is essential to its survival and growth as an organization. With a clear and systemized way of collecting and showing data, we can continue raising the funds and support necessary for operations.

Project plan

P
Prep: Goals & Data for the Dashboard
  • Volunteer Manager gives overview of the current data the organization has available, the desired KPIs they would like to track and the dashboard audience
  • Professional and Volunteer Manager discuss what is feasible for the dashboard given the current state of the organization’s data
  • Professional and Volunteer Manager outline next steps and timeline for the project
  • Volunteer Manager shares the necessary raw data files with the Professional
1
Milestone 1: Dashboard Creation & Feedback
  • Professional creates a draft of the dashboard based on initial conversation with Volunteer Manager
  • Professional shares the dashboard with the Volunteer Manager and explains how the dashboard depicts the desired KPIs
  • Volunteer Manager provides any feedback on the dashboard (up to two rounds)
  • Professional implements feedback and provides a revised dashboard
2
Milestone 2: Training
  • Professional creates guidelines for continued maintenance and update of the dashboard
  • Professional reviews the guidelines with Volunteer Manager
  • Professional is available for up to four weeks to address questions and troubleshoot as Volunteer Manager starts to regularly use the dashboard
3
Milestone 3 (Optional): Additional Advanced Training
  • Professional trains the Volunteer Manager on the key formulas, tables and charts that are used to create the dashboard, and how to make edits to them if needs evolve
  • Professional directs the Volunteer Manager to further relevant resources or an Excel Training project
Show more

About the org

CorpsAfrica
Unfollow
Cause
Philanthropy & capacity building
Posted by
Julie S
Julie S.

Program and Development Assistant

Our mission

CorpsAfrica will help create a culture of public service within developing nations by giving volunteer participants the opportunity to apply their skills and energy toward helping their fellow citizens overcome extreme poverty.

What we do

Modeled after the successful Peace Corps and AmeriCorps programs in the United States, CorpsAfrica would recruit men and women from developing countries of Africa to move to high-poverty communities within their own country for six months to two years and create small projects that eliminate barriers for economic growth and prosperity.

CorpsAfrica volunteers will be a diverse group of people – all ages, sexes, income levels, expertise, etc. After being selected through a rigorous screening process and an intense three-week training program in the capital city and on site visits, CorpsAfrica Volunteers will move to their sites where they will live with host-families, learn the local dialect, participate in day-to-day activities, and become trusted members of the community.

They will engage the local people in conversations and facilitate community meetings to help identify and address their changing and complex needs in education, health, small business development, urban planning and infrastructure, agriculture, the environment, and more. The volunteers will then help the communities determine their priority needs, design and implement projects to address those needs (which will be supported by a special fund of the CorpsAfrica project), and then perform a comprehensive impact evaluation analysis.

The pixel