Process

This WebQuest includes six clear and practical steps. You will start by choosing a social project and end with a report and presentation based on real or simulated data, using AI tools to support your work.

Step 1: Choose a Social Enterprise or a Social Project.

What to do:

Choose a real or made-up social project or organization (like helping students, protecting the environment, or supporting communities).

1. Select a real or hypothetical social enterprise.
   • If you choose a real enterprise/project, you can use existing businesses (e.g., local nonprofits, NGOs, or sustainability initiatives).
   • If you choose a hypothetical enterprise/project, first you need to define a clear mission, the target audience, and the expected impact.
2. Define 4-5 Key Impact Indicators.
   • For example, if you choose a digital education program, the indicators may be student completion rates, job placements, skill improvement, etc.
   • Example Indicators:
     • % of people who complete a course
     • % who report improvement in their lives
     • Number of trees planted, meals served, etc.
3. Write a one-paragraph summary of your project and a list of indicators.
   • • Describe the enterprise’s/project’s mission and goals.
     • List the impact indicators that will be measured.
     • Explain why these indicators are important.

Step 2: Collect Data

What to do:

In this step, you will gather the data needed to evaluate your impact.

1. Choose your data method:
   • Surveys: Create a short form using Google Forms to collect feedback (e.g., satisfaction level, attendance).
   • Public data: Use trusted sources like the EU Open Data Portal or World Bank Open Data if you’re using real examples.
   • AI-generated data: For fictional projects, ask ChatGPT to create sample data (e.g., “generate 20 rows of feedback scores between 1–5”).
2. Make sure your data is diverse:
   • Try to include people from different backgrounds (e.g., age, gender, income).
   • Avoid collecting data from just one group.
3. Organise it clearly in Google Sheets or Excel:
   • Use columns like: “Name,” “Age,” “Satisfaction (1–5),” etc.
   • Remove any duplicate or blank entries.
4. Double-check your source:
   • For public data, make sure it’s recent and from a trusted organization.
   • For survey data, check that your respondents reflect your target audience.
   • Compare your data with similar sources to spot errors or gaps.
5. Helpful Tools: Google Forms, Google Sheets (use “Data cleanup” under the Data menu for duplicates)

Step 3: Analyse Your Data with Help from AI

What to do:

Use simple tools or AI to check your data and discover useful patterns and insights in your data.

1. Prepare your data for analysis
   • Keep one piece of information per column (e.g., name, age, satisfaction level)
   • Use clear labels for each column
2. Clean and Organise Your Data
   • Check for duplicates (remove repeated rows), empty cells (fill in or explain missing values), mistakes, missing values, or repeated entries.
   • Use tools like: Google Sheets’ Data Cleanup or Smart Fill or OpenRefine (great for cleaning large data sets)
   • Example: If “Age” is missing in some rows, use Smart Fill to complete them.
3. Standardise Your Data
   • Make sure similar things are written the same way.
   • Example: Use either “USD” or “$” for money—not both.
4. Explore and Analyse
   • Look at the data and ask questions:
     • Are certain groups more satisfied?
     • Do results change over time?
     • Are there links between participation and outcomes?
   • Use pivot tables (Google Sheets has a simple tool for this) to summarise or compare data.
5. Use AI Tools for Support
   • Ask ChatGPT to help you find patterns.
   • Example: “Here is a list of data about training and employment—what do you notice?”

Step 4: Create a Visual Impact Dashboard

What to do:

Use easy-to-understand visuals to show what your data reveals. Dashboards help others quickly see your results and understand your project’s impact.

1. Choose a tool for data visualisation.
   • Google Sheets is for beginners (simple charts, pivot tables).
   • Looker Studio, Tableau AI and Power BI are for experienced users (drag-and-drop dashboard creation, more advanced analytics).
2. Design a Dashboard layout.
   • Organise your dashboard so that the most important information stands out
     • Summary section: Show key results (e.g., “80% of participants completed the programme”)
     • Charts: Display trends over time (e.g., a line chart showing improvement in satisfaction scores)
     • Tables or maps: Show results by location, gender, or age group
     • Filters: Let users explore different time periods or regions
3. Keep it clear and easy to understand
   • Use simple titles and short explanations for each chart.
   • Include notes or short descriptions
   • Choose colours that are easy to read (avoid too many colours or hard-to-read combinations)
   • Make sure your dashboard works well on both computers and mobile devices
4. Customise for different audiences.
   • Think about who will see your dashboard and adjust it accordingly
     • For policymakers or government agencies: Show how your results relate to the UN Sustainable Development Goals (SDGs)
     • For the local community: Use real stories or relatable examples alongside the data

Step 5: Write Your Impact Report with AI Help

What to do:

Your report explains what your data shows and tells the story of your social project. Use AI tools to make your writing clearer, more professional, and easier to understand.

1. Structure of the Impact Report:
   • Executive Summary (1 page): a short overview of your project and the main results.
   • Introduction: What is your project about? What goals were you trying to achieve?
   • Methodology: How did you collect and analyse the data? What tools did you use?
   • Key Findings: What did the data show? Use simple charts or graphs to explain your results.
   • Recommendations: What should be done next? How can the impact be improved?
   • Ethical Considerations: Did you find any bias or fairness issues in the data? How did you handle them?
2. Use AI tools to improve the report writing
   • ChatGPT or Jasper AI: will help you write sections, summarise findings, or improve flow.
   • Grammarly AI: Check grammar, spelling, and clarity.
   • Quillbot: Rephrase and simplify complex text.
3. Review and finalise the report
   • Make sure all visuals match your written conclusions
   • Ask a peer or trainer to review for balance and clarity

Step 6: Present Your Work and Reflect

What to do:

Team Presentations

Now it’s time to share your results and reflect on what you’ve learned. Your presentation will help others understand the impact of your project and how AI supported your work.

Each team will give a short presentation that includes:

• Your impact dashboard: What does it show? What were the key results?
• Your main findings: What did you learn from the data?
• Tools used: Which AI tools and platforms did you use, and why?
• Challenges: What problems did you face? How did you solve them?
• Reflection: How did AI help or make things harder during your project?

Group discussion

After all teams present, take part in a group discussion. You can talk about:

• What did you find most helpful about using AI for social impact measurement?
• What ethical or technical challenges did you face (e.g., bias, data quality)?