Overview

Partner:	coach@school e.V.
Goal:	Evaluation and reporting of teacher surveys and reading diaries
Skills:	Data analysis, visualization, reporting, and automation in R / RMarkdown
Team:	* 1 Team Lead * 3 Team Members * 1 Team Trainee
Project Start:	Early July 2025
Project End:	End of October 2025
Location:	Remote
Project Language:	coach@school operates in German. Therefore, German language skills at a level that allows you to follow a meeting without difficulty (approximately B2) are required.
Application:	Until June 11, 2025 HERE
Resources:	Link to CorrelAid Data4Good Documentation

Project Description

Title

Automation of Reports from Evaluation Data

Summary

This project aims to support coach@school staff in leveraging the potential of their survey data and automating recurring workflows for creating reports, especially for different federal states and regions. Additionally, the project team will help coach@school optimize reports for funders and other key stakeholders through compelling data visualizations. The reports will be created using R (e.g., RMarkdown, Quarto), with the goal of thorough documentation and handover to coach@school so they can maintain and further use the reports independently.

Challenge

coach@school faces challenges in manually evaluating and reporting data collected through their programs—including reading diaries, annual teacher surveys, and training feedback. All data is collected via SurveyMonkey and available as CSV files.

Manual processing is time-consuming and hinders timely, differentiated feedback to funders and stakeholders.
coach@school wants to improve and automate the creation of reports with different regional focuses, particularly:

• Merging data from various sources
• Standardized evaluation (e.g., by federal state or funding region)
• Creating graphics

Data

Two types of datasets will be analyzed: surveys from teachers using the book boxes program and evaluations of students' reading diaries (e.g., most popular books or frequency of book box usage).

The data comes from SurveyMonkey surveys (approximately 250 responses from teachers and 6,000 datasets from reading diaries per year) and can be provided as CSV files. Currently, evaluation and graphic creation are done manually in Excel, and reports are compiled in Word.

Project Goals and Content

The project focuses on automating processes that currently require significant manual effort and preparing reports in a way that enables long-term use by coach@school staff. This will facilitate faster, data-driven, and target-group-specific communication with funders and partners while freeing up internal resources.

The main project components are:

• Creating a federal-level report and at least one additional regional report (e.g., by federal state) that coach@school can use as a template for similar reports
• Automating reports (e.g., using RMarkdown or Quarto) with comprehensive documentation and training for the coach@school team to adapt and use the reports for other regions
• Graphic design of reports, including revising and expanding data visualizations
• Optional: Tutoring coach@school staff to provide basic R skills and facilitate further use and maintenance of the reports after project completion

Outcome and Social Impact

The project will deliver an automated report summarizing the evaluation results of the book boxes program, visually presented and adaptable for different regions. This will help coach@school convince funders of their work. Additionally, through good documentation and training, coach@school staff will be empowered to independently modify the report in subsequent years.

The project outputs will immediately help coach@school staff streamline recurring workflows, allowing them to focus more on working with children and youth. Furthermore, the results will deepen their understanding of their work's impact and the needs of their target group.

Timeline

• Application deadline: June 11, 2025
• Team selection process: June 2025
• Project kickoff: Early July 2025
• Project work: Until end of October 2025

Your Profile

CorrelAid projects offer you the opportunity to collaborate in a team, applying and developing your skills for the common good. Here, you can acquire new skills, develop innovative solutions, and expand your experience. For this application, you should have a strong enthusiasm for (survey) data and an interest in children's and youth education. Additionally, it is important for this project to keep everyday workflows in mind to ensure a practical implementation that can be used long-term.

Here is some additional information about the project:

Time Commitment

Approx. 4–6 hours per week

Motivation and (Learning) Experience

• Interest in collaborating with coach@school staff to develop a sustainable solution they can maintain independently
• (Basic/advanced) knowledge of data analysis in R and R Markdown or Quarto (to be agreed within the team)
• Experience in evaluating survey results (e.g., Net Promoter Score) is an advantage
• Enthusiasm for clear presentation and explanation of data and analyses. Creativity and enjoyment in analyzing evaluation data. Output-oriented work.
• Experience in automating reports and data visualization is an advantage
• Interest in improving educational opportunities for children
• Basic understanding of Git workflows (pull, commit, push) or willingness to learn
• Optional: Experience and/or interest in knowledge transfer to train coach@school staff in maintaining and further processing the created scripts.

Application

Open Team Positions

• 1 Team Lead
• 3 Team Members
• 1 Team Trainee

Application Link

APPLY HERE