Unifying Data Collection and Analysis in Support of Educational Equity
- Status
- Team Selection: Apply now!
- Project Period
- July 2026 – December 2026 (planned)
- Partner
The Challenge
As a young, growing nonprofit with limited volunteer resources, Edunovo wants to collect and use data to steer its own work efficiently and effectively, to develop its formats and organization in a data-driven and impact-oriented way, and to be able to make statements about impact to funders. Questions such as "how much do we put in, how much do we and our target group get out?" preoccupy the leadership team and are also of interest to external stakeholders and funders.
Internally, Edunovo is organized into eight teams, four of which are aligned with the core educational offerings: "Online Workshops", "SchoolConnect" (school workshops), "Empower U", and Editorial (newsletter). Some teams already collect data and analyze it using self-built Google Sheets. Other teams, however, lack the time and technical know-how to conceptually think through and build tools and data flows.
The Project
In this project, the Edunovo teams are supported in setting up data collection and analysis. This includes the following aspects for each team:
- Alignment with team leads or Edunovo leadership on which KPIs/data should be collected and tracked
- Conception and implementation of data collection / management
- Data analysis / visualization in Google Sheets or, if applicable, Data Studio
Wherever possible, Google Suite products are used consistently: Google Sheets + optionally Google Data Studio as the analysis platform. Google Apps Script can be used to implement interfaces to other platforms; Google Forms is already established for data collection from participants. Depending on the team, other data sources will also be relevant (see below).
Since the prerequisites and needs in the teams vary considerably, work is prioritized. Priorities 1-3 are an integral part of the project; priorities 5-7 are optional/nice to have.
Project Area 1 - SchoolConnect: KPI development, data integration and analysis
Priority: 1
The SchoolConnect team has data in several sources, since the program is run via a custom-built platform: feedback and impact surveys in an Azure database, student surveys via Google Forms. These are currently not merged and not analyzed. Since SchoolConnect is to be scaled in the coming years, the substantive development of solid KPIs and indicators as well as the creation of a reliable data basis are particularly important.
Tasks:
- Kickoff workshop: Joint development of relevant KPIs for management and impact measurement, awareness-raising for data-driven management
- Data integration: Setting up a data flow that merges the Azure database and Google Forms into Google Sheets
- Analysis: Development of analyses that the team can use independently
- Documentation of the interfaces and processes
Project Area 2 - Marketing: Data persistence and dashboard
Priority: 2
The Marketing team has access to data from Meta Business Suite, Google Analytics, and LinkedIn, but loses historical data due to a lack of systematic storage. Growth and reach development over time are therefore not traceable.
Tasks:
- Substantive review of existing KPIs
- Persistence: Setting up a semi-automated process that regularly loads exports from Meta, LinkedIn, and Google Analytics into Google Sheets
- Analysis: Preparation of key metrics (follower development, reach, engagement rate) in a clear view
- Documentation of the process for independent further use
Project Area 3 - Reviews EmpowerU, Online Workshops, Culture/Community
Priority: 3
In the three teams EmpowerU, Online Workshops, and People & Culture, there are already relatively robust structures and tools developed by Edunovo itself (mostly: Google Forms + Google Sheets). A systematic review of the existing structures and small adjustments ensure quality and help Edunovo gain confidence.
Tasks:
- Review of KPIs: Does the existing system cover everything Edunovo wants to know? Are there questions that remain unanswered?
- Review of data collection and management: question wording, answer options, survey structure, robustness of manual data entry, links and formulas in Google Sheets
- Review of data analysis: charts, pivot tables, filter functions
- Implementation: Implementation of smaller improvements or written documentation of recommendations if larger changes are required
Project Area 4 - Further teams: Review and recommendations
For three further teams, data structures will be built or improved depending on remaining capacity. In the Newsletter team (Priority 4), there is currently no systematic storage of data, so subscriber numbers, click rates, and subscriber origin are not traceable. In the Board area (Priority 5), there is a financial overview that is, however, difficult to understand and error-prone. For the Public Affairs team (Priority 6), no systematic considerations have so far been made on the topic of data.
Tasks:
- Newsletter: Setting up a process for persisting newsletter data in Google Sheets; analysis of subscriber numbers, click rates, and subscriber origin, if applicable via API (subject to effort estimation)
- Board: Revision of the existing financial overview into a robust, understandable representation broken down by offering
- Public Affairs: Written recommendations for capturing LinkedIn interactions, conversations, and press mentions
The Impact
Edunovo will be enabled to better manage its own work and professionalize its external communication. Through the most uniform setup possible across teams, the volunteer Edunovo team saves valuable time and capacity that can be invested in the development and scaling of the educational programs.
This way, even more young people can benefit from the digital educational offerings. At the same time, data collection and preparation improves the presentation of impact to Edunovo's important stakeholders.
Timeline
- Application open: until 19.7.2026, 11:59 PM
- Team selection: by 22.07.2026
- Kickoff: 28.7.2026, 6-8 PM
- Project work: until the end of 2026
Team Roles
Data Analyst Google Suite
Your responsibility & your impact:
As a Data Analyst, you ensure that the data from the Edunovo teams flows together and is analyzed. Thanks to your work, at the end of the project Edunovo will have well set-up and reliable processes, data, and tools to make informed decisions and to present its own work convincingly to funding partners.
Your tasks:
- Review, structure, and merge data sources (e.g. Azure database and Google Forms for SchoolConnect, Meta/LinkedIn/Google Analytics for the Marketing team)
- Develop (semi-)automated or manual processes to regularly ingest data (e.g. Google Apps Script, setting up Google Sheets)
- Design and implement analyses and dashboards in Google Sheets or Google Data Studio
- Review and improve existing Google Sheets for quality (see Reviews)
What you'll learn in the project:
- Practical experience in setting up data processes and analyses with the Google Suite (Sheets, Forms, Data Studio, Apps Script)
- Working with different data sources and APIs (Azure, Meta, LinkedIn, Google Analytics) and their pragmatic integration
- Insights into data-driven management and impact measurement in the non-profit context
What you bring:
- Basic knowledge in data analysis and preparation (Excel/Google Sheets, ideally pivot tables, formulas; initial programming experience in JavaScript is an advantage) and motivation to further familiarize yourself
- Structured, independent way of working and enjoyment of designing data flows and structures
- Communication skills to clarify requirements with non-technical contacts
- Interest in educational equity and the work of a young, volunteer-run organization
- German language skills at least at B2 level
- Time availability of approximately 4 hours per week
Volunteer KPIs, Impact, Data Collection
Your responsibility & your impact:
As a Volunteer for KPIs and Impact, you help the Edunovo teams ask the right questions and collect meaningful data. Thanks to your work, it is ensured that the data and analyses fit Edunovo's pressing questions and strategic needs.
Your tasks:
- Conception and delivery of an approximately 2-hour workshop with the SchoolConnect team with the goals: knowledge transfer, raising awareness for data-driven management and impact logic, developing KPIs.
- Substantive review of existing data collection instruments (Google Forms): question wording, answer options, structure of the surveys
- Check whether existing KPIs cover everything Edunovo wants to know, and identify gaps / make recommendations
- Provide conceptual groundwork so that technical implementation in the team can proceed in a targeted way
What you'll learn in the project:
- Practical experience in developing pragmatic and low-threshold KPI systems and data collection instruments for a volunteer-run organization
- Deepening of concepts of impact measurement and KPI-based management
- Experience in moderating workshops and consulting with volunteer non-profit teams
What you bring:
- Basic understanding of KPIs, survey design, or impact measurement (e.g. from studies, work, or volunteering)
- Enjoyment of conceptual, moderating work
- Structured communication skills to clarify requirements with different teams
- Interest in educational equity and the work of a young, volunteer-run organization
- German language skills at least at B2 level
- Time availability of approximately 4 hours per week
Team Trainee
As an educational network, it is important to us to also offer a place to people who have little or no technical knowledge yet. That is why the Team Trainee role exists. As a Team Trainee, you are still co-responsible for the project's success and responsible for seeking out your learning experiences. What exactly you do and learn in the project is something you work out together with the team. The team coordinator supports you in this.
If you belong to a group marginalized in data science (e.g. FLINTA), we would like to encourage you to apply for a regular team role, even if you may not meet all the requirements. CorrelAid projects are a good place to take on responsibility, expand your comfort zone, and develop further - supported by others and as part of a community.
Team Coordinator
If the "Team Coordinator" role cannot be filled, the tasks will be divided within the team.
Your responsibility & your impact: You make sure that the project team works together in a focused, coordinated, and motivated way. You create a framework in which everyone can use their volunteer time meaningfully and effectively, have fun, learn, and at the same time bring the project's vision to life. You are supported in this by Leo from the full-time CorrelAid team - he onboards you to your role before the project and is available as a contact person during the project.
Your tasks:
- You support the team in dividing, prioritizing, and tackling tasks sensibly.
- You keep track of the project goals and the timeline.
- You keep an eye on the other team members and project partners and are a contact person for them when challenges arise. You help the team trainee orient themselves in the project and find learning experiences.
- You act as the interface to the full-time CorrelAid team around Leo.
- Together with Leo from the full-time team, you moderate the project kickoff and enable a good project start. You work with the other team members to determine how you want to shape and organize your collaboration.
- You plan and moderate regular check-ins – synchronously as meetings or asynchronously via Slack.
- Optional: If you have time, motivation, and capacity beyond your role as team coordinator, you are free to (co-)take on tasks in the project (e.g. writing code, creating visualizations, …). However, this is by no means expected!
What you'll learn in the project:
- To enable work in an interdisciplinary, voluntary team
- To find the balance between structure, self-organization, and voluntariness
- Collaboration with partners from social organizations
- Working with project management tools (e.g. GitHub Projects or Trello)
What you bring:
- Motivation for organizing and moderating teams or projects
- Enjoyment of structuring and facilitating collaboration, and a good understanding of people and their strengths and needs.
- Optional: Previous experience in organizing teams, e.g. from other (voluntary) contexts or as Agile Coach, Scrum Master, project manager, or similar.
