> 8:7` bjbj 4,JDvvvv$_aaaaaa$h:lmmm"_m_mm:_,dnv"
_0Rj"mWd4$"FEXCELLING in Geometry
Activity Summary:
This activity uses Microsoft Excel in order to review geometric concepts such as translation, rotation, reflection, and dilation (or size transformation). It can be given in a variety of different ways depending on the target grade level and the class understanding of Excel.
Subject:
Math: Geometry
Grade Level:
Target Grade: 8
Upper Bound: 10
Lower Bound: 7
Time Required: This activity can easily consume an entire 5060 minute class period and could be extended into a second class period if desired.
Activity Team/Group Size: The class was broken into three competing groups of approximately 6 students.
Expendable Activity Cost Per Group [in dollars]:
None
Authors:
Graduate Fellow Name: Ryan Pedrigi*
Teacher Mentor Name: Rachel Albin
Date Submitted: 2/28/06
Date Last Edited: 5/2/06
*This Excel spreadsheet was created by Ryan Pedrigi
Parent Lesson Plan(s): None.
Activity Introduction / Motivation:
This activity was created in order to allow for the review of such geometric concepts as dilation, reflection, rotation as well as reinforcing concepts such as plotting on an xy coordinate axes and solving onevariable equations, while simultaneously introducing the students to the very powerful and commonly used program Excel.
Activity Setup:
This activity can be executed in a variety of different ways. Originally it was intended to have the attached Excel spreadsheet projected onto the screen and the teacher would operate the spreadsheet while the students participated with pencil and paper at there desks in teams. Another way, perhaps for more advanced students, is to give them the blank spreadsheet and a hard copy of the questions and have them fill in the spreadsheet with the appropriate coordinates for a given geometric shape.
Activity Plan:
There are 4 separate subsheets attached in the one Excel file. The idea is that the xy coordinates of each shape are to be inputted into the appropriate labeled column on the spreadsheet in order to form the shape. The coordinates for the formation of the initial shape (labeled shape 1) are provided by the students through onevariable equations written on the board by the teacher. The first team to solve the set of 2 equations, which gives one point on the plot, gets 1 point. The first team to accurately guess the shape, as it is forming from the plot of each of the points, gets 2 points.
Next the students will be asked to find the coordinates of such things as the rotated, dilated, or translated shape. These problems can be worked out on graph paper, and as solutions are presented by individual groups the teacher can place these answers in the spreadsheet and award the appropriate points (as determined by the instructor). Note that the spreadsheet is set up so that the plot is on the same page as the inputted coordinates (That way all information can be seen without scrolling). Exactly what geometric distortion is wanted is given in the questions on each separate subspreadsheet (upper part of the sheet).
Activity Closure:
Closure of the activity is accomplished by adding up team points and finding a winner (extrinsic rewards are good).
Assessment:
The students can each turn in their handwritten plots of the coordinates of each shape with the appropriate geometric distortions. In addition there are other questions such as find the area of the plotted shape that could be turned in by the students.
Learning Objectives:
The students will be introduced to Excel spreadsheets.
The students will review geometric concepts (i.e. translation, rotation, reflection, dilation).
The students will review plotting on an xy coordinate axes.
Prerequisites for this Activity:
The students should have basic knowledge of a coordinate system (plotting points given xy coordinates) and have been introduced to the geometric concepts of translation, rotation, reflection, and dilation. In addition, area calculations, line symmetry, and solving onevariable equations are concepts in which the students should be comfortable and competent.
Background & Concepts for Teachers:
The Excel spreadsheet is set up so that immediately after each xy coordinate is inputted into the appropriate columns (boxed in columns for each shape) the point will be plotted on the graph with a label. The remainder of the activity requires teachers to have basic Excel knowledge, particularly with graphing functions.
Materials List:
Computer and connected projector with Microsoft Excel.
Activity Extensions:
More advanced students could be taken to a computer lab and asked to find and plot the coordinates of each geometric shape directly into Excel, working as either individuals or teams.
Attachments:
GK12_Geometry_Final.xls
Excel+Geometry.doc
*{> @ J N P X Z h *
,
F
g
q
5GKNUfŽŽ鞗h="Jh7xh="Jhh7Sh="JhDAB*phhB*phhDAB*phhDA5B*\phhJch#Ph+s/h h#P5h7xh7xh7x5 h5hh5>*:*? @ J Y Z h x ,

6OgdDAH$gdDAgd7x$a$gd7x
#
(:wx)gd7x'g
#
`
(@A89ahmno:sž hr5hrh?Gh`hdnhrh0hrh0h="Jhu1h7Shrhrh7xh7x5 h="J5hjh h5 h5hjhjhjhdnhjhjhjh6~>?ab7OtwxDbfst)EFmpqt h="J5h~hdn hIz5hth~h~5 h05 hd5hdhdh+s/hIzh0h7xh7x5hmh="JhG.vhG.vh?G5h?Gh7xhd:)pqrst
&Fgd7SgdG.vgd~h7Sh4h
h
h
5h
h
521h:p="J/ =!"#$%@@@NormalCJ_HaJmH sH tH DA@DDefault Paragraph FontRiRTable Normal4
l4a(k(No List6U@6s5 Hyperlink>*B*ph,!z z zt*?@JYZhx,6O#(
:wx)pqrst!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!*?@JYZhx,6O#(
:wx)pqrst000000000000000000000000000000000000000000000000000000000000000000 0 0){00{00
00)TU\:
8*urn:schemasmicrosoftcom:office:smarttagsCity9*urn:schemasmicrosoftcom:office:smarttagsplaceOt}\ut:JZx6O(tt},`
TDFPo3^`o(.
^`hH.
pLp^p`LhH.
@@^@`hH.
^`hH.
L^`LhH.
^`hH.
^`hH.
PLP^P`LhH.^`OJQJo(n^`OJQJo(npp^p`OJQJo(n@@^@`OJQJo(n^`OJQJo(n^`OJQJo(n^`OJQJo(n^`OJQJo(nPP^P`OJQJo(nPo,`
tĨhL_>>4TܳRo *V'l%J?>V':J?>6EqqQrInKQrI9%zPaJ?qq,j
f[!+s/0u1?G="J>LN7SUJc`.gdnrtG.v7xBzIz`zHPs54#P~m'W~]x DAjd`sUz(1L_@tt'2tt`@UnknownGz Times New Roman5Symbol3&z Arial;Wingdings"phLFF^ " "!>4 3QHX)?7x2What is EngineeringPedrigiPedrigiOh+'0x
4@
LX`hpWhat is EngineeringPedrigiNormalPedrigi11Microsoft Office Word@!
@<@9_dn՜.+,0hp
Pimpin' Inc." What is EngineeringTitle
!"#$%&()*+,.01234569Root Entry F`׀dn;1TableWordDocument4,SummaryInformation('DocumentSummaryInformation8/CompObjq
FMicrosoft Office Word Document
MSWordDocWord.Document.89q