Today you start a ten-week project with real answers from your school. You will pick a school-life question someone could act on, set up your portfolio folders, and build a short anonymous survey linked to a spreadsheet.
By the end of this lesson, you will be able to:
- Set up {{code:Digital_Portfolio}} and {{code:Digital_Spreadsheets}}
- Choose a school-life question and name who could act
- Build an anonymous linked survey of six to eight countable questions
- Get approval and collect a few classmates' answers
Name one school-life change you want, and who could make it.
One school survey runs through all 10 weeks. Each week adds something to your portfolio.
| Week | What you'll do | What lands in your portfolio |
|---|---|---|
| 1 (today) | Ask a question and build a linked survey | {{code:01_survey}} + {{code:01_survey_responses}} |
| 2 | Copy and clean answers; log each change | {{code:02_survey_analysis}} |
| 3 | Count and average by group with one formula | {{code:03_summary}} |
| 4 | Compare two groups with ranks and a colour scale | {{code:04_compare}} |
| 5 | Band answers and flag two conditions | {{code:05_bands}} |
| 6 | Build a results explorer with a choice list and XLOOKUP | {{code:06_explorer}} |
| 7 | Summarise two questions with a pivot table | {{code:07_pivot}} |
| 8 | Build two honest, labelled charts | {{code:08_charts}} |
| 9 | One protected, shareable dashboard | {{code:09_dashboard}} |
| 10 | Write findings and present them | {{code:10_findings}} |
By week 10, your data becomes findings someone can act on.
| Concept | Why it matters | Example |
|---|---|---|
| Question worth answering: a school-life question someone can act on | Findings only matter if a real person could change something | How students get to school, aimed at the principal or student council |
| Countable answers: choices, a 1 to 5 rating, or a number | You can total, compare and chart these later | Bus, Walk, Car, Cycle, Train; or minutes as a number |
| Anonymous survey: no names, emails or personal details | Classmates answer more honestly; the survey stays safe and fair | The getting-to-school survey asks how you travel, but never your name or email |
| Linked responses: every answer lands in a spreadsheet automatically | You never retype answers; cleaning starts from a live sheet | Forms for Excel or a Google Form linked to Sheets |
Weak: "Tell us about school", no audience, free text, nothing to count.
Strong: Audience = student council. Six countable items on getting to school:
- Class group (choice)
- Usual travel mode (choice)
- Journey minutes (number)
- Weekly travel cost in euro (number)
- Would cycle if you could? (choice)
- Rate the journey 1 to 5 (rating)
Reject free-text cores such as "Describe your morning." Save comments for one optional box at the end.
Unlock the full learning experience
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.
This lesson is copyright of 123Learn.ie 2017 - 2026. Unauthorised use, copying or distribution is not allowed.