Participants will explore how Excel can be used as a tool to teach math concepts, by
investigating a particular project from a 9th grade math class at High Tech High. In
this project students learned how to perform mathematical transformations (translation,
dilation, reflection, rotation) on images. In this workshop you will go through the
same (but abbreviated) process as the students and create a story through the use
of mathematical transformations. The final product is an animated gif of the story.
Mathematical concepts learned in this project are: functions, functional transformations,
matrices.
Sample Excel Worksheet - DogChase
Sample Gif file - Dog Chase
Sample Excel Worksheet - Archer - Curved Motion Path
Sample Gif file - Archer
Rachel & Tyler |
Josh and Josh
|
Sharon and Savanah |
Juliet & Christian |
Isaac and Robert |
Crockett and Walker |
Trevor and Ezio |
Brian and Jimmy
|
Indika and Jazzay |
The goal is to find the Center of Mass (or Centroid) of a
two dimensional shape.
Students use methods of numerical integration and use Excel as a tool to find the balance point of a two dimensional object.