mathematics presentation excel ( worksheet ) - 01 number sense

27
Stage 0 Question Count, say and write the number of the object below Write the number of object above Stage 1 Question Count, say and write the number of the object below THE NUMBER OF OBJECTS THE NUMBER OF OBJECTS

Upload: puworkutara-onscribd

Post on 14-Nov-2014

719 views

Category:

Documents


0 download

DESCRIPTION

This work is an updater for my previous document - Excel Mathematics (Tutorial)- 1.1 Displaying Place (Digit). Soon, it will be deleted.Suitable for both Excel 2003 & 2007 users.Features:Kids' Counting,Round Off Numbers, Digit Value/Place and Digit Partition.Thank You!

TRANSCRIPT

Page 1: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Stage 0

Question Count, say and write the number of the object below

Write the number of object above 1

Stage 1

Question Count, say and write the number of the object below

THE NUMBER OF OBJECTS

THE NUMBER OF OBJECTS

Page 2: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Write the number of objects above

Stage 2

Question Count, say and write the number of the object below

Write the number of objects above

Stage 3

Question Count, say and write the number of the object below

THE NUMBER OF OBJECTS

THE NUMBER OF OBJECTS

Page 3: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Write the number of objects above

Stage 4

Question Count, say and write the number of the object below

Write the number of objects above 4

Stage 5

THE NUMBER OF OBJECTS

Page 4: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Marks On Stage 1 1

Marks On Stage 2 0

Marks On Stage 3 0

Marks On Stage 4 0

Marks On Stage 6 1

Total Marks 2

Percentage 40.00%

Grade D

Analysis

Go To Stage To Restart

ANALYSIS

Page 5: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Your Marks On This Stage 1 1

Go To Stage 2

NoteIf the hyperlink does not work due to your PC setting,simply, just use the Slide Barfor navigation.

Page 6: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Your Marks On This Stage 2 0

Your Marks On This Stage 3 0

Go To Stage 3

Go To Stage 4

Page 7: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Your Marks On This Stage 4 0

Your Marks On This Stage 5 1

Go To Stage 5

Go To Analysis

Page 8: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense
Page 9: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Question 1 Read and write in Number Wo

a ) 300 =

b ) 460 =

c ) 703 =

d ) 821 =

e ) 999 =

Question 2 Fill in the missing numbers in

a ) 4560 4561 4562 4563 4564

b ) 1010 1020 1030 1040 1050

c ) 8000 7000 6000 5000 4000

NUMBER NAMES

NUMBER SEQUENCE

Page 10: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

No ! Three Hundred

No! Four Hundred and Sixty

No! Seven Hundred and three

No! Eight Hundred and Twenty One

No! Nine Hundred and Ninety Nine

References

IndicationBlue - Your answer is Correct.

Red - Your anser incorrect

Page 11: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Three Hundred

Four Hundred Sixty

Seven Hundred three

Eight Hundred Twenty One

Nine Hundred Ninety Nine

Page 12: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Question 1 Partition 4-digits numbers into thousands, hundreds, tens and ones

1236 = + + +

Question 2 Recompose this numbers

8 + 4000 + 50 + 700 =

Please check up your Excel 2003Follow this instructions

Click on any blank cell, click fx,Type MROUND click OK

If this MROUND doesn't appears,Click CANCEL, then

Click Tools_Add-ins..Click Mark (p) Analysis ToolpakClick OKWait until the Excel 2003 finish toinstall your request.Now you can use functionMROUND

NUMBER PARTITION

NUMBER COMPILE

IndicationBlue - Your answer is Correct. Red - Your anser incorrect

IndicationBlue - Your answer is Correct. Red - Your anser incorrect

Tips & Hints ( MROUND() function

C7
Teacher's Space Change this number to see the different results
F7
Students' Space Ask student to complete all of these blank cells
D18
Teacher's Space Edit these cells with appropriate numbers or digits
Page 13: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Click Tools_Add-ins..Click Mark (p) Analysis ToolpakClick OKWait until the Excel 2003 finish toinstall your request.Now you can use functionMROUND

MROUND function ( Examples )

If The formula = MROUND(Q7,10) Means : Round Off the number to the nearest of 10

If The formula = MROUND(Q7,100) Means : Round Off the number to the nearest of 100

If The formula = MROUND(Q7,1000) Means : Round Off the number to the nearest of 1000, and so on.

Page 14: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Partition 4-digits numbers into thousands, hundreds, tens and ones 1000 2001236 236

1000 200

84000

50700

4758

Notes & Hints

Click on any blank cell, click fx,Type MROUND click GO

This timeMROUND appears, click OK

L18
Answer Space: Students type answer here
Page 15: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

MROUND function ( Examples )

If The formula = MROUND(Q7,10) Means : Round Off the number to the nearest of 10

If The formula = MROUND(Q7,100) Means : Round Off the number to the nearest of 100

If The formula = MROUND(Q7,1000) Means : Round Off the number to the nearest of 1000, and so on.

Page 16: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

30 636 6

40 6

Page 17: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Question 1

Question 1 Represent the place value of digits in the given numbers

12340 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 1

0 0 1 1

0 1 1 1

1 1 1 1

TH H T O

Question 1 End

Question 2 Represent the place value of digits in the given numbers

0 0 0 0 1

0 0 0 0 1

0 0 0 1 1

0 0 0 1 1

0 1 0 1 1

0 1 0 1 1

0 1 0 1 1

NUMBER PARTITION

B6
Teacher or Students : Edit / Change this numbers. Discuss the outcomes
Page 18: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

0 1 0 1 1

0 1 1 1 1

0 5 6 7 9

Ten Thousand Hundreds Tens Ones

Question 2 End

Page 19: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

1 2 3

1000 200 30

1234 234 34

1000 200 30

NEXT

Tips & Formula

Page 20: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

PREVIOUS

Page 21: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

4

4

4

4

Page 22: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Page 1

Question 1 Round Off this given number to the nearest of 10

12

10

√ - Yes! Excellent!

Page 1 End

Page 2

Question 2

2300

Find out the numbers.

9990

No! Try Again

The below number is already Round Off to the nearest of 100

Your Answer

Quetion

Comment

Approximation

Approximation

IndicationBlue - Your answer is Correct. Red - Your anser incorrect

Quetion

Your Answer

Comment

D8
Teacher's: Teacher input this cell for any number.
D10
Student's: Pupils are asked to fill this cell according to the above question.
D29
Teacher's: Edit this Number.
D33
Student's: Input Positive Whole Number 1 - 9999
Page 23: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Page 2 End

Comment

Page 24: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Table_array

0

10

11

Number Round Off Controll

Cell D34 Cell D36 Cell E34

2300 10000 0

Number Reflect Controll

× - Incorrect! Try Again.

√ - Yes! Excellent!

× - Incorrect! Try Again.

NEXT

The below number is already Round Off to the nearest of 100

Hints

IndicationBlue - Your answer is Correct. Red - Your anser incorrect

Hints

Page 25: Mathematics Presentation Excel ( Worksheet ) - 01 Number Sense

Cell D34 Cell D36

2300 9990

PREVIOUS