Transcript Document

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.
Sue’s E-mail address:
[email protected]
Sue’s website address:
http://www.ezwebsite.org/mrshamilton
Ray’s E-mail address:
[email protected]
Ray’s web site:
www.mvsc.k12.in.us/training/ice2003
K math standards using Excel
Find the number that is one more or one less than numbers up to 10 (standard 1.7)
6
0
3
5
9
1
2
7
4
8
7
1
4
6
10
2
3
8
5
9
8
2
5
7
11
3
4
9
6
10
Cells were enlarged by choosing "format"
Then "row" then "height".
For Grade 1
Standard 1.4 (One more or one less)
For numbers up to 100.
Type the first two numerals.
First Grade
Highlight the numerals.
Standard 1.1--Counting to 100
Put your cursor on the small black square
in the bottom right hand corner of the cell.
Click and drag to the desired number.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
How to make a border:
Highlight the desired cells. Go to "format" and choose "cells"
Go to "border". Choose your line style and your color (under "automatic")
Click "outline". Choose a thinner line and click "inside"
First Grade Standards
1.9 find the fraction for an object
divided into 8 or fewer parts.
Example: 3 out of 8 parts are yellow.
Make ONE object.
Highlight it.
"Control C" for copy.
Click in a new spot and "Control V" for paste.
For grade 2, add the terms
"numerator" and "denominator".
Four out of 6 are green.
This shows a set rather than a whole.
Standard 1.8 for grade 2.
First grade
Standard 2.3
Show equivalent forms of the same number.
8
11
7
14
9
4+4
6+5
3+4
10+4
0+9
Format cell size:
1+7
0+11
7+0
6+8
1+8
Highlight cells.
5+3
8+1
6+1
9+5
2+7
Choose "format", "column width"
0+8
2+9
6+2
5+2
11+3
3+6
3+8
12+2
4+5
4+7
1+13
10+1
7+7
and "format", "row height".
Grade 1
Math standard 2.7
Understand and use inverse relationships
between addition and subtraction
facts.
6+5=11
5+6=11
11-5=6
11-6=5
2+6=8
6+2=8
8-2=6
8-6=2
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.
Grade 1
Standard 1.3
Identifying numbers of 10s and 1s.
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.
Grade 2
Math standard 2.2
Add two whole numbers less than 100
with or without regrouping.
55+ 28=
Highlight the tens.
Put the cursor on the highlighted area.
When an arrow appears, the tens can be moved to show
the addition.
Do the same for the ones.
Grade 2
Math standard 1.1
Counting by 2s, 5s, and
10s to 100.
25
8
8
73
12
12
19
19
19
Grade 2 Standard 1.5/ordering numbers
91
25
25
Column A numbers are dictated to students.
37
30
30
Column B students order the numbers.
8
37
37
As the numbers are used they are changed to green.
52
41
41
Column C. students copy/paste the numbers from A.
100
52
52
Students use the sort tool to order the numbers in C
12
64
64
30
73
73
41
81
81
64
90
90
81
91
91
90
100
100
Students can now check their work by comparing
columns B and C.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
91
82
92
83
93
84
94
85
95
86
96
87
97
88
98
89
99
90
100
22= 2 tens and 2 ones
7= 0 tens and 7 ones
Grade 2
36= 3 tens and 7 ones
Math standard 1.3
49= 4 tens and 9 ones
Recognizing 10s and 1s in
58= 5 tens and 8 ones
70= 7 tens and 0 ones
75= 7 tens and 5 ones
numbers up to 100
1 odd
31
8 even
2 even
82
9 odd
99
3 odd
73 10 even
100
4 even
24
5 odd
68
45
Grade 2 math standard 5.1
6 even
66
odds and evens
7 odd
10+1
5
10
20
10+2
10
20
29
30
10+3
15
30
38
39
40
10+4
20
40
47
48
49
50
10+5
25
50
56
57
58
59
60
65
66
67
68
69
70
10+6
30
60
74
75
76
77
78
79
80
10+7
35
70
84
94
85
95
86
96
87
97
88
98
89
99
90
100
10+8
40
80
10+9
10=10
45
50
90
100
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
21
22
23
24
25
26
27
28
31
32
33
34
35
36
37
41
42
43
44
45
46
51
52
53
54
55
61
62
63
64
71
72
73
81
91
82
92
83
93
Grade 2
Math standard 1.2
Recognizing patterns in number values up to 100
consecutive numbers
Grade 3 standard 2.2
Represent concept of multiplication as repeated addition.
1x5=5
2x5=10
3x5=15
4x5=20
1/3>1/6
Grade 3 math standards 1.8/1.10
Comparing fractions
1/2>1/4
2/4=1/2
1/6<1/3
3rd grade math standard 1.11 Reading/writing decimals
0.07
0.05
0.32
0.79
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
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”.
s s
d
n ed
a
s dr s
u
n n nes
o
u
th h
te o
5
0
7 500+7
3
6 30+6
1
0
4
5 1,000+40+5
9
0
2 900+2
4
2
0 400+20
6
1
1 600+10+1
1
9
0
0 1,000+900
1
2 10+2
9
0 90+0
For older students, add millions, billions, and even negative numbers.
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.
Grade 4 standards 6.1 and 6.2
A frequency table
What type of movie do you like best?
boys
girls
Adventure
11
10
Science fiction
10
6
Horror/Suspense
13
14
Mysteries
6
11
Animation
12
14
Comedy
13
12
14
12
10
8
6
4
2
0
Bar graphs and frequency tables
Horror is the favorite movie of both boy and girls.
Science fiction is the least popular.
The biggest difference between boys and girls is mysteries.
Adventure
Science fiction
Horror/Suspense
Mysteries
Animation
Comedy
boys
girls
Boxes of Cookies Sold
72
64
56
Boxes of Cookies
48
40
32
24
16
8
0
Marion
Ray
sue
Jay
Students
Jack
Bob
7/4=1.75
Grade 4
Math standard 1.8
Divide hundreds into fractional parts and
decimals.
½=0.50
Grade 4
Math standard 1.5
4/4 are colored
4/4 are colored
4/4 are colored
¼ is colored
13/4 are colored = 3 1/4
Mixed fractions
Grade 4
6
Math standards 5.3 and
5.4
5
5
6
Find the perimeter (add all sides)
Find the area (WxH)
Finding perimeter and
area of a rectangle
3
Grade 4
4
Standard 5.7
3
5
3
3
5
Divide the total shape into three
separate parts to be able to see
the perimeter and area more
clearly.
10
3
4
5
3
5
5
5
2
2
3
4
3
p. 16 units
a. 15 sq units
p. 10 units
p. 18 units
a. 6 sq. units
a. 20 sq.
units
totals.
p. 36 units
a. 41 sq. units
Grade 5
10
Math standard 5.1
7
7
Finding the area of a
triangle.
10
Area = 70 sq. units
10
7
7
Area of a triangle =
½ base times height
10
10
7
10
Area of a trapezoid—grade 5
Find the area of the two rectangles to find the area of the
trapezoid.
3
5th Grade
Math standard 2.2
Adding fractions with
different denominators
Problem and solution
1/3 + ½ = 5/6
Grade 5 standard 1.6
Prime and composite numbers
5x2=10
2x5=10
10x1=10
1x10=10
1x3=3
3x1=3
1x7=7
7x1=7
6x1=6
1x6=6
2x3=6
3x2=6
3x3=9
1x9=9
9x1=9
1x2=2
2x1=2
1x1=1
The numbers of squares that can be arranged
in only one rown and column are Prime
Numbers
1x5=5
5x1=5
4x2=8
2x4=8
1x8=8
8x1=8
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
2x2=4
1x4=4
4x1=4
The number 0 does NOT have one
column or one row, so it is NOT prime
or composite
Here are some more ideas, not
related to a specific grade level
or standard, but good tools to
use with elementary students.
For Inquiry Math--Use double ten
frame to teach basic facts,
and how many more or how
many less. The example
here is 7+9= Also, how
many more red circles are
there than blue circles.
How many ways can you make 15 cents
How many ways can you make ____?
HD
Q
D
N
P
Complete the tiling for a better
understanding of perimeter and area
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
Ten Frame Multiplication
Multiplication Grid
1
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
12
14
18
8
17
The sum is 40
5
The sum is 50
Here’s a wonderful website to add to
your manipulatives. It has something for
all grade levels K-12.
http://www.arcytech.org/java/