Budgeting for a School Field Trip: Real Financial Planning
Lower secondary - 12-14 years - Duration: 2 sessions of 45 min.
Introductory question
What if we organized the next school trip, how much would it really cost and how could we all pay for it in a fair and responsible way?
Explanatory summary
This guide transforms planning a school trip into a hands-on personal finance simulation. Students will learn how to create a budget from scratch, research real costs, calculate «hidden» expenses such as taxes and tips, and design a savings plan. The goal is to develop math skills and encourage responsible consumption and ethical group decision-making.
Skills to be developed
- Cognitive: Analysis of variables, calculation of percentages (taxes, tips), planning and decision making based on data.
- Socioemotional: Group negotiation, assertive communication, empathy in considering others' budgets and shared responsibility.
- Internships: Use of spreadsheets (optional), research of actual prices, creation and follow-up of a budget.
Linked standards: Common Core (Mathematics), UNESCO (Education for Sustainable Development).
Learning objectives
- Identify and categorize the direct and indirect costs of a school trip.
- Calculate the total cost per person, including a local tax (e.g. 7%) and tips.
- Design a personal savings plan to achieve the exit financial goal.
- Evaluate consumption options (transportation, food) under sustainability and ethical criteria.
Materials
| Economical (Recycled) | Standard | Pro (Digital) |
|---|---|---|
| Paper, pencil, calculator. Local tourist brochures or internet access on a single device for group consultation. | Printed worksheets with budget templates, individual calculators, access to computers for research. | Individual access to tablets with spreadsheet software (Google Sheets, Excel), projector for sharing findings. |
Note: Prioritizes responsible use of technology and adult supervision during online research.
Step-by-step procedure
- Phase 1: Brainstorming and Selection - In groups, propose 3 possible destinations for a day trip (museum, park, etc.). Investigate basic costs (entrance fee, transportation, food) and select an option democratically. (20 min)
- Phase 2: Creation of the Detailed Budget - Break down all possible costs: transportation, entrance fees, lunch, snacks. Research and add a 7% excise tax and a 15% tip if applicable. Calculate total cost and cost per student. (40 min)
- Phase 3: Savings Plan and Ethical Reflection - Each student creates a savings plan to cover their quota in 4 weeks. As a group, discuss: Are there greener options? How can we include everyone? Present the final budget to the class. (30 min)
Formative evaluation
Reflection questions:
- What was the most surprising «hidden cost» they found (taxes, tips, etc.)?
- Explain how your group made the final decision on destination and expenses.
- Which savings strategy seems most realistic for you and why?
Evidence: Budget drafts, final spreadsheet, personal savings plan, participation in discussion.
Evaluation Rubric
| Criteria | Initial | Basic | Advanced | Expert |
|---|---|---|---|---|
| Costing | Identify only obvious costs (input, transportation). | Includes most costs, but omits taxes or tips. | Correctly calculates costs, taxes and tips. | Calculate everything accurately, justify every expense and add a contingency fund. |
| Planning and Savings | Proposes an unrealistic or vague savings plan. | Create a simple savings plan without detailing actions. | Detail a feasible savings plan with weekly goals. | Create a detailed plan with multiple strategies and consider potential pitfalls. |
Differentiation
- Supports: Provide a budget template with predefined categories and basic formulas. Provide concrete examples of percentage calculations.
- Extensions: Add a «fundraising» variable to the budget to reduce the individual cost.
- Challenges: Compare the cost of two different outlets and present an argument as to which offers the best «educational value for money».
Connections to daily life
- Finance: Foundation for personal financial management, saving for goals, understanding taxes and informed consumption.
- Values: Discussion of equity, financial inclusion and responsible consumption when making decisions that affect a group.
- Environment: Evaluation of the ecological impact of transportation options or places visited.
Safety and Sustainability
When planning, it is crucial to consider transportation safety and the chosen destination. In addition, low environmental impact options should be prioritized, such as using public transportation, choosing local suppliers, and reducing waste by bringing reusable containers and bottles.