LESSON PLAN 12
- Build a Hotel
- Arts (includes music, architecture ...), ICT (includes technical education, computer science ...), Mathematics (includes geometry, proportionality, finances ...)
- ISCED 3 = Upper Secondary Education
Duration
1 teaching unit, 2 hours, 3 activities
Topic
Suppose you are an architecture firm that is tendering to build a hotel.
Synopsis
To build a hotel an obtain the maximum benefit
Contributors
As the classes of students are inclusive the mathematics teacher is expected to be supported by an art and a home economics teacher that will support the activities through their special areas and provide the context for understanding and applying the counting principles in the context of their topics.
Framework
Material / Equipment
Material in the classroom
1 hour explanation from the mathematics teacher
2 hours in the computer room
Previous knowledge and skills
Knowledge of using Excel
Learning Objectives
Learning goals and objectives:
- Geometry
- Operations with integers
Learning outcomes and expected outcomes:
Use mathematical reasoning in non-mathematical environments.
- Make conjectures, experiment, argue, relate, check, validate, generalize and particularize in real-life contexts related to: numbers, geometry, functions, statistics and chance.
- Express orally and in writing reasoning, conjectures, quantitative relationships and information that incorporate mathematical, symbolic or graphic elements, assessing
- the usefulness of mathematical language and its evolution throughout history
Methodology
Role-playing game that involves experimenting, guessing and arguing
Preparation & Resources
Preparation, Space Setting, Troubleshooting Tips:
The activity will take place in the computer room
Resources, Tools, Material, Attachments, Equipment
All 50 cubes must be used, paper and pen.
One computer for each group
Implementation
STEP 1: Reading the rules for building and creating teams
10′ presentation of the cubic group and presentation of the activity
2′ first construction in a small group
8′ calculations in small groups
5′ ordering of all proposals by estimate
10′ real arrangement
10′ definitive construction
5” second ordering
10′ final thoughts
Instruccions
STEP 2: Understand the problem
Construction rules
- Each cube represents a hotel room.
- All 50 cubes must be used.
- The hotel must stand stably.
- The hotel must be of one piece.
- All rooms must have at least one window.
STEP 3: Experimentation, first hotels and first hypotheses
STEP 4: Improvement of hotels and presentation of the most beneficial ones
Profit = Revenue – Costs
Income from each type of room (daily rate)
The more windows, the more income.
4 windows, 1 roof = 600€
4 windows, 0 roof = 500€
3 windows, 1 roof = 300€
3 windows, 0 roof = 250€
2 windows, 1 roof = 200€
2 windows, 0 roof = 175€
1 window, 1 roof = 150€
1 window, 0 roof = 125€
Construction costs
The cost of building the hotel is calculated based on the size of the land and the roof, the number of windows and the tax for the height of the building.
The land has a cost of €400 per square unit.
The terrain refers to the outline of the building’s bird’s eye view.
Closed ground is also loaded.
Examples:
The hotel on the left has an enclosed space. The total cost of the land is
18 units².
The hotel on the right has a total land cost of 13 units².
The roof has a cost of 10€ per square unit.
The windows cost 5€ each.
Tax on height of building is calculated by multiplying the tax rate for the highest floor by the total land cost.
Floors 1-10 —> 50%
Floors 11-20 —> 1000%
Floors 21-30 —> 2000%
Floors 31-40 —> 3000%
Floors 41-50 —> 5000%
The tax for the height of the building is calculated by multiplying the tax rate of the highest floor by the total price of the land.
Link excel document calculations
STEP 5: Improvement of hotels and presentation of the most beneficial ones
STEP 6: Creation and presentation of the report
Outline of the Lesson
STEP 1: Reading the rules for building and creating teams
STEP 2: Understand the problem
STEP 3: Experimentation, first hotels and first hypotheses
STEP 4: Improvement of hotels and presentation of the most beneficial ones
STEP 5: Improvement of hotels and presentation of the most beneficial ones
Extension Activities
This work is designed to be done in groups of 2 or 3 students, groups of 3 students will have a student with educational needs
Assessmement
To evaluate the activity, the following will be taken into account:
A self-evaluation note evaluating the participation.
Co-assessment notes between group mates.
The teacher’s assessment.
Number of hotels built and the score obtained by the group.
A group report explaining what we have learned.
(To be decided) At the end of the activity, an individual written activity will be done.
Report must include:
Description of the best hotel built (room types, revenue, costs and profit)
Photo of the hotel
Explain what we have learned by building the hotel: what makes a hotel a good hotel? what to avoid what is better how do you build a “good hotel”?
Information about other hotels built
Other information that you think is appropriate
References
Activity by Fawn Nguyen.
Lighting extract:
https://illuminations.nctm.org/Lesson.aspx?id=5988
Activity credits
Activity by Fawn Nguyen.
Excerpt from Illuminations: https://illuminations.nctm.org/Lesson.aspx?id=5988