Tuesday, March 01, 2005

Using Excel for Coordinate Grid mapping

Excel makes a great tool to help extend the old color the square coordinate grid worksheets we give the kids.
The activity I'm including has the students creating a smiley face by using the fill tool in Excel. The activity works even better if you shrink the width of the cell in columns A-Z so that the boxes look like squares. If you don't, your smiley face will be extra wide, but it will still work.

Coordinate Grid Mapping Activity
1. Type your name in cell (A, 1)


2.Use the fill tool on the bottom toolbar to color the following cells yellow. ** ( If you do not see the fill tool or the bottom toolbar click on View - Toolbars- Check Drawing and the tool bar will appear at the bottom. )
3. To change the fill color to yellow.
4. Click on the down arrow to the right of the fill tool and select more colors.
5. Click on yellow.

(A,6) (A,7) (A,8) (A,9) (A,10) (A,11) (A,12) (A, 13) (A,14) (A,15)

(A,16) (A,17) (B,4) (B,5) (B,17) (B,18) (C,2) (C,3) (C,18) (C,19)

(D,1) (D,2) (D,19) (D,20) (E,1) (E,2) (E,19) (E,20) (F,2) (F,3)

(F,18) (F,19) (G,4) (G,5) (G,17) (G,18) (H,6) (H,7) (H,8) (H,9)

(H,10) (H,11) (H,12) (H,13) (H,14) (H,15) (H,16) (H,17)


1. Use the fill tool on the bottom toolbar to color the following cells black.
2. To change the fill color to black.
3. Click on the down arrow to the right of the fill tool and select more colors.
4. Click on black.
(C,7) (C,8) (C,13) (D,14) (E, 14) (F,7) (F,8) (F,13)

Have fun with this activity!


Happy Computing!

0 comments: