1 / 31

Using Excel

Using Excel. And the Internet. As Math Manipulatives. for a better understanding of. Math Concepts. Sue and Ray Hamilton. Sue’s E-mail address: Sueham123@aol.com Sue’s website address: http://www.geocities.com/mrshamiltons Ray’s E-mail address: rdhamilt@mvsc.k12.in.us

aisha
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 And the Internet As Math Manipulatives for a better understanding of Math Concepts ICE 2003

  2. Sue and Ray Hamilton Sue’s E-mail address: Sueham123@aol.com Sue’s website address: http://www.geocities.com/mrshamiltons Ray’s E-mail address: rdhamilt@mvsc.k12.in.us Ray’s web site: www.mvsc.k12.in.us/training/ice2003.htm

  3. 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.

  4. 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.

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

  6. Grade 3 standard 2.2 Represent concept of multiplication as repeated addition. 1x5=5 2x5=10 3x5=15 4x5=20 Leaf clip art taken from: http://www.designedtoat.com/nat2.htm

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

  8. 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

  9. 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.

  10. 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.

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

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

  13. 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

  14. 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)

  15. 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

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

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

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

  19. 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

More Related