Enabling Data-Driven Management of a Course Program for People with Cancer
- Status
- Team Selection: Apply now!
- Project Period
- June 2026 – January 2027 (planned)
- Partner
Project description
The Challenge
lebensmut Landshut supports people with cancer and their families through various therapy-accompanying programs that are not part of insurance-covered care. In addition to volunteer companions on the cancer ward and counseling services, these include a wide range of courses, e.g. art therapy, pottery, yoga, breathing therapy, and many more. These programs promote the well-being of those affected and support them in coping with cancer therapy. All programs are funded by donations and free of charge for participants.
To use donations as effectively and as needs-based as possible for the target group and to ensure the quality of the programs, the management of lebensmut Landshut needs a better overview of demand for the courses offered and the satisfaction of participants.
The Project
In this project, the CorrelAid team supports executive director Sandra with setting up data collection, management, and analysis around the course program.
Specifically, the following will be implemented:
Data collection:
- Review of the existing (one-time conducted) Microsoft Forms feedback survey and setup for permanent use
Data management:
- Setting up a course list in SharePoint Lists, conception and establishment of an ID system (each course has an ID)
- Integration of data from the MS Forms feedback survey
- Setting up a process to integrate exports (Excel/CSV) from the bookkeeping tool (Vereinsmeister)
Data analysis:
- Development of an Excel "dashboard" for low-threshold analysis of the data (e.g. pivot tables, Excel charts)
Reusability and independent use and further development of the results is very important for lebensmut Landshut. That is why the dashboard is implemented in Excel (and not in Power BI).
Impact
With the data structures and tools set up, executive director Sandra will in future be able to quickly answer questions such as "What does course X cost per participant?" and "How many people participated in course X?". The data prospectively collected from the feedback survey help to ensure the quality of the programs and, if necessary, to take corrective action.
Overall, management can further develop the course program in a needs- and quality-oriented manner and use donations more effectively. With the improved, needs-oriented, and high-quality course program, lebensmut Landshut can support people with cancer even better in coping with the illness. In addition, the insights and figures gained help lebensmut Landshut to convince funding agencies of their work.
Timeline
- Until 25.05.2026 inclusive: Applications open
- Until 05.06.2026: Team selection
- 05.06.2026 - 10.06.2026: Onboarding
- 10.06.2026, 6-8 PM: Kickoff (online)
- Project duration: until January 2027 inclusive
Your Team and Your Role
In the Data4Good project with lebensmut Landshut, you will become part of a team consisting of managing director Sandra from lebensmut Landshut, as well as 2-4 other volunteers from CorrelAid. Together, you can use your skills and potential for a good cause, support a great nonprofit organization, and most importantly: have fun. Here’s what you can expect as a CorrelAid Data4Good volunteer:
- A place for learning: A CorrelAid project is a great place to share knowledge, learn new skills, or to deepen existing ones and apply them in practice.
- (Shared) responsibility: Together with your teammates, you take responsibility for the entire project. You are (co-)responsible for specific tasks and outputs, depending on your team role (see below).
- Support and collaboration: You support each other within the team, coordinate closely, and share knowledge. You can ask for advice in the CorrelAid Slack community. The full-time CorrelAid team is available in the background if problems arise.
- Flexibility: You can organize your time flexibly and work on the project whenever and wherever you want. You can work independently or meet with teammates for (online) co-working or collaboration.
- Online communication: You coordinate with other team members via Slack and regularly participate in meetings with your project partners (approximately every 1–3 weeks, depending on the project and phase). Occasionally, additional meetings or coordination with project partners or team members may be necessary.
- A supportive environment for everyone: CorrelAid’s goal is to ensure that everyone in the community—regardless of background, prior experience, gender, or other personal characteristics—can contribute and grow as a person. A respectful and safe environment is essential for this. Therefore, collaboration within the project team follows the values and principles outlined in the Code of Ethics and Code of Conduct. The Ethics Commission and Community Team provide concrete and enforceable processes to support you if you observe or experience violations of these rules and values during the project.
- Time commitment: You can expect a time commitment of approximately 4 hours per week.
To help you better assess where you can contribute most effectively with your skills and experience, we outline different team roles below. In the application form, you can select one or more roles that appeal to you.
There are two specific roles that do not require technical knowledge or prior experience:
Team Coordinator: As a team coordinator, you do not need technical skills, but you should be motivated to coordinate and organise teams.
Team Trainee: The team trainee role is for individuals who have little or no technical knowledge but would like to gain technical skills during the project. As a team trainee, you still share responsibility for the project’s success and are responsible for shaping your own learning experience - for example, by collaborating with one of the technical roles.
Team Roles
Data Analyst
Your responsibility & your impact: As a Data Analyst, you are responsible for the complete data life cycle, from revising data collection to developing data management and processes through to analysis. Thanks to your efforts, lebensmut Landshut will be empowered after the project to collect, manage, and gain important insights from data around the course program and participant satisfaction.
Your tasks:
- Conception of a data structure for the course program (defining fields, ID system) and implementation in SharePoint Lists
- Review and revision of the existing feedback survey in Microsoft Forms
- Integration of data from Microsoft Forms into SharePoint or Excel using suitable tools (e.g. Power Automate)
- Integration of data from CSV exports from the bookkeeping software
- Merging the data sources in an analysis Excel
- Creating analyses in Excel (charts, pivot tables)
- Introduction to the developed tools & knowledge transfer
What you'll learn in the project:
- To conceive and implement a low-threshold data management structure
- To think holistically from data collection to data analysis
- Microsoft tools beyond Excel
Your profile:
- Initial experience with data (e.g. with Excel, R, Python) and interest in data analysis
- Basic Excel knowledge and willingness to expand it in the project
- Interest in engaging with various low-code/no-code Microsoft tools (SharePoint Lists, Power Automate, Power Query)
- Pragmatic working style and motivation to develop solutions that are as low-complexity as possible, easy to understand, reusable, and maintainable for lebensmut Landshut.
- Basic understanding of best practices for structuring data in tables (good variable names, dropdowns instead of open text fields, etc.) or willingness to learn
Nice to have:
- Experience with SharePoint Lists, Power Automate, and/or Power Query
- Experience in developing dashboards in Excel
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)
Your profile:
- 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.
