Project Name: Polygons Everywhere-4th grade- Math.
Description of Learning Goals and Standards: Students will be able to identify different polygons and also learn how to collect data and use a graph using Microsoft Excel. Students will be able to understand these shapes in real situations around them. Some QCCs for 4th grade are: Standard 8- identifies and distinguishes among planes and solid figures such as triangles, circles, rectangular prisms. Standard 25 – collects, reads interprets and compares data from charts, tables and graphs.
Rationale for Technology: Using Excel for this project allows the student to gather the information and input the data in an organized manner.
Description of Lesson Implementation: After having a lesson on polygons, this activity will be done just to reinforce what the shapes and names are and where they are in the students’ everyday life. I will have students work individually. They will investigate five locations (bulletin board, inside desk, inside bookbag, on bookbag, and on clothes) to tally up how many of the six polygons they find. This will be done a sheet of paper. After they are finished, we will go to the computer lab and they will enter in their results. I will have a pre made spreadsheet for them to use. When they are finished, I will instruct them on how to make a graph and pass out a fact sheet on how to do it. They will be required to make two different graphs, with one showing the total data and one which just highlights one particular polygon found in their data.
Assessment : Matching quiz of polygons
Other Places to Use this Solution: Spreadsheets can be used in a variety of ways and subjects. In science they are great for plotting data from experiments. They are also helpful for the teacher to plot attendance and grades.
What I Learned and What I would Improve it Next Time: I think this could be used for older students and I could not plug in the formulas but have them do it. Or have the students calculate to see if their totals match that of the spreadsheet.
References/Resources Used
http://www.mathleague.com/help/geometry/polygons.htm