| Tiling a Patio |
Grade:
Fifth |
Content Area:
Technology |
Time Frame:
1-2 lessons (45-90 minutes) |
|
Unit/Lesson Overview:
Students will use Excel to demonstrate how to determine the number of tiles needed to create a patio.
Students will use pictures and gathered data to determine a pattern that can be used to solve problems.
|
Student Standards (TEKS)
| for
explanation of a TEK, click on the TEK |
| Language Arts: |
|
| Math: |
5.5(A)
5.5(B)
5.6(A) |
| Social Studies: |
|
| Science: |
|
| Technology: |
S1
S2
S3 |
| Technology: |
S10
S9
|
| Additional TEKS: |
|
|
I Can....
...identify a pattern from data that I collect...create a table and a graph using information that I gather |
Assessment(s):
Were the students able to use the information they gathered to determine the pattern?
Does the data that was gathered and graphed match the expected outcome?: |
TAKS Objectives:
| Reading: |
|
| Writing: |
|
| Math: |
Obj. 2, Obj. 6 |
| Social Studies: |
|
| Science: |
|
|
Bloom's Taxonomy
| Not Chosen |
Knowledge |
| Not Chosen |
Comprehension |
| Not Chosen |
Application |
| Not Chosen |
Analysis |
| Not Chosen |
Synthesis |
| Not Chosen |
Evaluation |
|
Big 6 Skills
| Not Chosen |
Task
Definition |
| Not Chosen |
Info. Seeking
Strategies |
| Not Chosen |
Location and
Access |
| Not Chosen |
Use of Information |
| Not Chosen |
Synthesis |
| Not Chosen |
Evaluation |
|
Supplementary Resources / Materials:
Excel document
File: tiling_a_patio1.xls
File: create_excel_graph.doc
|
Internet Links:
|
Accommodations:
To be determined by the teacher based on student needs |
| Procedures |
Introductory Activity (Warm-Up):
Before going to the lab, use a multimedia computer to show the students how they can create a patio and a perimeter around it using the Excel paint bucket. Discuss the Area and Perimeter of the patio that you create. |
Lesson:
Before taking the students to the lab, delete any worksheets from the Tiling a Patio Excel template (file 1) that you don't want the students to see and save it in the Student directory as a read-only document.Open the Tiling a Patio Excel template (file 1) and click on the Tiling a Patio worksheet.
Have the students read the problem and begin creating the patios.
Students click on the Questions worksheet and type their answers.
Have the students create a table and graph for the information they have collected. Use the Create an Excel Graph Excel template (file 2) to help you create a graph.
|
Reteach:
To be determined by the teacher based on student needs
|
Extension:
Have the students insert a new Worksheet and create their own patios independently or in small groups.
Students should then create a table and graph for the information they collect about the patios they create.
|
Guiding Questions:
Is there a relationship between the number of tiles used to create the patio and the number of tiles used for the perimeter?
Does the number of tiles used for the patio ever exceed the number of tiles used for the perimeter of the patio?
|
Summary Questions:
Were you able to find a pattern?
Would that same pattern work if the patios were not square? Why or Why not?
|
Reflection:
|