# Blank Borders Designs - Excel by efz59986

VIEWS: 46 PAGES: 15

• pg 1
```									  This lesson is designed for teacher-directed instruction and whole class
group discussion. The Tiling a Patio tab can be displayed on your multi-m
computer/tv screen or a projector and used to guide the class through t
Follow-up questions for discussion are included on the Questions Tab. Sa
completed patios and related graphs follow.

As an extension for this activity, teachers can have students create the
patios independently or with small groups in the computer lab. Students
create the related tables and graphs using the chart wizard.

Once their patios are created, have students create a text box to exp
procedures and mathematical thinking behind the activity. Directions fo
student files are found on Student Set Up tab.
ction and whole class/small
de the class through the activity.
he Questions Tab. Samples of

ve students create their own
mputer lab. Students can then
rt wizard.

eate a text box to explain their
activity. Directions for setting up
The local gardner designs square patios with a tile border around them. It is important for
him to know exactly how many tiles he will need when building a patio so that he can orde
the correct number of tiles.
(Using two different colored tile have students build the three smallest patios with their border. Record the
number of red and blue tiles for each patio in a table. Ask the students, "How many tiles will there be in
the next largest patio?)
em. It is important for
io so that he can order

h their border. Record the
any tiles will there be in
1. Is it possible to predict the number of outer tile you will need if you know how many tiles
the Patio? How can we test our thinking?
2. Describe your methods for counting the different tiles.
3. What patterns do you see in the table?
4. If there are 36 tiles used for the patio, how many tiles will be needed to surround the pa
how you know.
5. Is it possible to make a patio with 49 tiles? Explain why or why not?
6. Make a line graph that shows the number of tiles in each square patio in the table. Mak
for the outer tiles used around each square patio. How are the graphs the same and how
different?
7. As the patio gets larger, how does the number of outer tiles change?
8. Does the number of black tiles ever exceed the number of outer tiles in a patio? Why?
9. Find the number of tiles used for the patio and outer tiles in the 15th, 30th, and 100th pa
10. If there is a total of 144 tiles in the patio, what is the side length of the square patio inc
border? How many tiles would be used in the border?
11. A customer wants a square patio with a border of 56 outer tiles. How many tiles will be
to build this patio? Explain how you know.
f you know how many tiles are used for

needed to surround the patio. Explain

y not?
are patio in the table. Make a line graph
graphs the same and how are they

hange?
ter tiles in a patio? Why?
he 15th, 30th, and 100th patio.
gth of the square patio including the

les. How many tiles will be needed
rap
To set up the Tiling a Patio Activity, start by making sure that the Drawing toolbar is open. To open the toolbar, click on View --
and make sure
that there is a check next to Drawing.
To create squares, start by highlighting the whole excel worksheet. To do this click in the blank area above row 1 and to the left
column A.
Once the document is highlighted click on the line between column A and column B and drag it to adjust the width of the square
click on the line
between row 1 and row 2 and drag it until all of cells look like squares.
While the whole excel worksheet is highlighted, click Format -- Cells -- Border and then click inside and outside. This will create
borders for your
squares.
To color cells, highlight the cells that you want colored and then click on the down arrow next to the paint bucket to choose a co
cells.
To create a text box like this one:
highlight the cells that you want included in the text box
click on Format -- Cells
click on the Alignment tab
click in the box next to Merge Cells and Wrap Text
change the text alignment Horizonal to: Left Indent and Vertical to: Top

Tip: To return to the next line within the same cell, hold down the Alt key and then hit Enter.
pen the toolbar, click on View -- Toolbars --

area above row 1 and to the left of

to adjust the width of the square. Then

side and outside. This will create the

the paint bucket to choose a color for the
The local gardner designs square patios with a tile border around them. It is important for
him to know exactly how many tiles he will need when building a patio so that he can orde
the correct number of tiles.
(Using two different colored tile have students build the three smallest patios with their border. Record the
number of red and blue tiles for each patio in a table. Ask the students, "How many tiles will there be in
the next largest patio?")
em. It is important for
io so that he can order

h their border. Record the
any tiles will there be in
Outer Tiles Patio Tiles Total Tiles
Patio 1              8           1           9
Patio 2             12           4          16
Patio 3             16           9          25
Patio 4             20          16          35
Patio 5             24          25          49                                               Tiling a Patio
Patio 6
60

Number of Inside tiles
Patio 7
50
Patio 8
40
30
20
10
0
Patio 1Patio 2Patio 3Patio 4

Patio Number
Tiling a Patio

Outer Tiles
Patio Tiles
Total Tiles

Patio 4Patio 5

io Number

```
To top