Category Archives: Algebra & Geometry

Happy Pi Day

TechsmithWor4563.pngToday is March 14. 3.14. Pi Day! Google spreadsheet offers a function that will return the value of pi to 14 decimal points. In a Google spreadsheet template, type = PI() and the output is 3.14159265358979. In Excel the same function = PI() returns the value of pi to 9 decimal points. Continue reading

Take the ‘Order of Operations’ Spreadsheet Quiz!

TechsmithWor63E8.pngKnow the rules of the order of operations? A central concept in pre-algebra/algebra, these rules clarify which actions in any algebraic expression should be performed first. Let’s review what the rules are and why they are important. Then, you can test your knowledge with a spreadsheet quiz!   Continue reading

Fibonacci and the Golden Ratio in Spreadsheets

© Photographer Dan Tataru|Dreamstime.com

What do sunflowers, shells, honeybees, the Parthenon, and human arm length measurements have in common? All reflect a remarkable pattern of numbers. Now just where does this intriguing sequence of numbers come about? Let’s discover the Fibonacci sequence and the Golden Ratio and how we can use spreadsheets to calculate them! Continue reading

Pythagoras and SUMSQ

Ever heard of the philosopher and mathematician, Pythagoras of the 6th century BC? Perhaps you’ve come across one his most famous theorems during your geometry class. The Pythagorean Theorem states that in a right triangle, the sum of the legs squared is equal to the hypotenuse squared. 

Continue reading