Microsoft’s Education site has a few good lesson plan ideas that incorporate their Office software. Here is a lesson investigating the patterns of average daylight. This could perhaps be investigated by our trig/pre-calculus students.
Showing high school students to create their own check book using excel is a really nice way of showing them how to use the formulas in excel while doing real world activities. Operations in excel can be tricky yet beneficial to their comprehension of the math topics they have learned. Excel is a good way […]
The lesson plan that incorporates Excel is found at http://www.microsoft.com/education/makingmoney.mspx#E2D. This lesson is for middle grade students and gives them some insight of the trials and tribulations of running their own business by operating a lemonade stand. The students will record all of the materials, costs, data, and then analyze how much money you made […]
I found a lesson plan integrating math and science together. The lesson involves monitoring how much water a student’s household uses in one Saturday. With this information the students will then research an average household’s water use and compare it to theirs. Also they are asked to brainstorm ways to lower the water use. The […]
This lesson has the students graph functions using Excel. Excel makes it easy for them to change the numbers in the formulas (example: changing the m in y=mx+b) and see how that effects the graph. Being able to manipulate the formulas so easily will help the students see the connections between the formulas and their […]
http://teach.fcps.net/trt10/Documents/VampiresWS.pdf is a cute PDF to give students that outlines the uses of excel for students to explore an exponential growth relationship. The assignment helps students to walk through each step in identifying the relationship, working on their communication by asking students to describe what is happening to the numbers in each step, which helps […]
The lesson I found online involving Excel turned the 12 Days of Christmas song into a song about the 12 Days of Middle School and required the students to use an Excel spreadsheet to determine how much Middle School would cost according to the song. The students had to figure out how to make Excel […]
Find a math lesson (on the web) that uses Excel or some other spreadsheet. Write a blog post about it. Include a link to the site where you found the lesson Tell what math is taught in the lesson (and grade level if any) What makes the technology piece better than a chalk board (if […]
Today we’re going to explore Geogebra. This is a free program that does a lot of the things Geometers Sketchpad does (they both have nice features that the other doesn’t have, but most of the obvious features are ones they share). Goals with Geogebra: Construct a parallelogram Show what happens if your reflect an object […]
Our main goals for today are to learn how to use the commands in the Transform and Construct menus. Class outline: overview of the Transform menu download and play Transformation Golf discuss the advantages of Transformation Golf and Transtar break overview and exploration of the Construct menu discuss constructions vs drawings construct a square construct […]