Welcome to H3 Maths

Blog Support for Growing Mathematicians

Posts tagged with Excel

Excel basics for Math students

July29

In this series of short videos students will learn to make use of the basic mathematical features of Microsoft Excel, such as using Excel as a calculator, using functions, etc. Many high school Math students struggle to learn the basics of Excel, yet to do so can greatly enhance their skills and also provide useful […]

by posted under Uncategorized | tagged under  |  Comments Off on Excel basics for Math students

Less than excellent use of Excel…

July27

Yes, it happened to me – I was using Excel to finish my tax claim and then sent it off to my accountant. He remarked to me, over lunch, that I had made a mistake in my Excel calculations. Yes, I had made the kind of error that is just so easy to do – […]

by posted under Uncategorized | tagged under , , ,  |  Comments Off on Less than excellent use of Excel…

Iditarod Activity Sheet for Middle School

February28

I have included an activity sheet for Year 8 or 9 students to help them take a mathematical interest in the Iditarod Race, and also use Excel to sort and graph the mushers. Click on or download Using the Iditarod Race as a Teaching Tool in Mathematics.  

by posted under Uncategorized | tagged under , , , ,  |  Comments Off on Iditarod Activity Sheet for Middle School

Excel fails at some math calcs!

August1

In a blog post, Microsoft employee David Gainer said that when computer users tried to get Excel 2007 to multiply some pairs of numbers and the result was 65,535, Excel would incorrectly display 100,000 as the answer. Gainer said Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5, but the […]

by posted under Uncategorized | tagged under ,  |  Comments Off on Excel fails at some math calcs!

Post Support

Largest number between o and 1 million which does not contain the ‘n’ is 88

 

Rotation SAT Problem: Answer: 4 (see: https://www.youtube.com/watch?v=FUHkTs-Ipfg)

 

Which number has its letters in alphabetical order? Answer: F O R T Y

Hidden Rabbit? Clue: check the trees

How long for the stadium to fill? 45 minutes.

Where are you? the North Pole

Prize Object Puzzle: If Sue does not know where the prize is in the first question, it can’t be under the square. She must have been told it is under another shape. Apply this same logic to Colin. It is then obvious that the prize cannot be under a yellow object. That helps Sue eliminate her yellow shapes. Got the idea?

Algebra Puzzle: Answer = 1

Popular Math Problems Answers: 1, 1

Number of tabs? According to Lifehacker, the ideal number of tabs you should have open is nine. Yes, a single digit. To some, this is like playing a piano and only using a fraction of the notes!

Worst Graph? Where to start. What a visual mess and even some of the lines merge and are impossible to follow. A graph is a visual display of data, with the goal to identify trends or patterns. This is a spider’s web of information which fails to show a clear pattern at all. Solution? Well, different colors would help, or why not group in two or three graphs where trends are similar?

Number of different nets to make a cube is eleven – see this link

Homework Puzzle; The total value of the counters is 486, so halve this to get 243. Now, arrange the counters to equal this amount twice.

The graph on the left (Coronavirus) is for a time period of 30 days, while the one on the right (SARS) is for 8 months! Very poor graphical comparison and hardly relevant, unless it is attempting to downplay the seriousness of the coronavirus?

10 x 9 x 8 + (7 + 6) x 5 x 4 x (3 + 2) x 1 = 2020

NCEA Level 2 Algebra Problem. Using the information given, the shaded area = 9, that is:
y(y-8) = 9 –> y.y – 8y – 9 =0
–> (y-9)(y+1) = 0, therefore y = 9 (can’t have a distance of – 1 for the other solution for y)
Using the top and bottom of the rectangle,
x = (y-8)(y+2) = (9-8)(9+2) = 11
but, the left side = (x-4) = 11-4 = 7, but rhs = y+? = 9+?, which is greater than the value of the opp. side??
[I think that the left had side was a mistake and should have read (x+4)?]

Archives

H3 Viewers



Skip to toolbar