1 / 44

Using Excel

Using Excel. As Math Manipulatives. for a better understanding of. Math Concepts.

tyrone-harrison
Download Presentation

Using Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Excel As Math Manipulatives for a better understanding of Math Concepts

  2. Please understand that some of these manipulatives would be best made by the teacher to use on the overhead or for demonstration purposes. Others, students can make themselves. You would have to decide what would best serve your purposes.

  3. By Sue and Ray Hamilton Sue’s E-mail address: Sueham123@aol.com Sue’s website address: http://www.ezwebsite.org/mrshamilton Ray’s E-mail address: rdhamilt@mvsc.k12.in.us Ray’s web site: www.mvsc.k12.in.us/training/ice2003

  4. The line was created in Excel. To put the numbers in you must copy the line into Paint and add the numbers there so that they can be placed directly under the lines.

  5. Grades 1 and 2. Math standard 5.7 Give the value of money This was done in paint because I feel it’s easier to manipulate the coins. However, coins can be copied/pasted into Excel.

  6. Grade 2 Math standard 1.1 Counting by 2s, 5s, and 10s to 100.

  7. Grade 3 standard 2.2 Represent concept of multiplication as repeated addition. 1x5=5 2x5=10 3x5=15 4x5=20

  8. 3rd grade math standard 1.11 Reading/writing decimals

  9. Grade 3 Standards 1.2 and 1.2 Show the value of a given number up to 1,000. 265 In expanded notation 265=200+60+5

  10. Grade 3/ math standards 1.3 and 1.4 place value Highlight the cells you will use for your labeling. Go to “format” then “cells” then “allignment”. Set the “orientation” box at 45 degrees. Click “OK”. For older students, add millions, billions, and even negative numbers.

  11. Pet frog costs $6.39. Paid with $10.00. Count back the change. Grade 4 Standard 5.10 Make change from a purchase by counting back.

  12. Grade 4 standards 6.1 and 6.2 Bar graphs and frequency tables

  13. 7/4=1.75 Grade 4 Math standard 1.8 Divide hundreds into fractional parts and decimals. ½=0.50

  14. Grade 4 Math standard 1.5 Mixed fractions 4/4 are colored 4/4 are colored 4/4 are colored ¼ is colored 13/4 are colored = 3 1/4

  15. Grade 4 Math standards 5.3 and 5.4 Finding perimeter and area of a rectangle Find the perimeter (add all sides) Find the area (WxH)

  16. Grade 4 Standard 5.7 Divide the total shape into three separate parts to be able to see the perimeter and area more clearly. totals. p. 36 units a. 41 sq. units p. 18 units a. 20 sq. units p. 10 units a. 6 sq. units p. 16 units a. 15 sq units

  17. Grade 5 Math standard 5.1 Finding the area of a triangle. Area = 70 sq. units Area of a triangle = ½ base times height

  18. Area of a trapezoid—grade 5 Find the area of the two rectangles to find the area of the trapezoid.

  19. 5th Grade Math standard 2.2 Adding fractions with different denominators Problem and solution 1/3 + ½ = 5/6

  20. Grade 5 standard 1.6 Prime and composite numbers The numbers of squares that can be arranged in only one rown and column are Prime Numbers Numbers of squares that can be arranged in rectangles other than one row and one column are called Composite Numbers The number one has only one row OR column, so it is NOT prime or composite The number 0 does NOT have one column or one row, so it is NOT prime or composite

  21. Here are some more ideas, not related to a specific grade level or standard, but good tools to use with elementary students.

  22. How many ways can you make 15 cents

  23. How many ways can you make ____?

  24. Complete the tiling for a better understanding of perimeter and area

  25. Make a geoboard in Excel. Hide the grid. Have students make shapes with these perimeters: A) 4 B) 6 C) 8 D) 10 E) 14 G) 16 H) 18

  26. Ten Frame Multiplication

  27. Multiplication Grid

  28. Here’s a wonderful website to add to your manipulatives. It has something for all grade levels K-12. http://www.arcytech.org/java/

More Related