We have recently studied right triangles and the Pythagorean Theorem. We have learned how to use the Pythagorean Theorem to find find the missing side of a right triangle and how to use the converse of the Pythagorean Theorem to determine if three values are the sides of a right triangle. Now that we can do all of these calculations using paper, pencil, and a calculator, we are going to use Excel to streamline the process.
In this assignment, students will design an Excel spreadsheet that will calculate the third side a right triangle given the other two sides and also determine if three given values are the sides of a right triangle. If you need a quick refresher of how to use a spreadsheet, click on this link to assignment 3.
Remember that the Pythagorean theorem is: .
This use of exponents requires you to know how to enter exponents into Excel. To do exponents, one uses a carrot(^). This is typed by holding down the shift key and hitting the number 6. So, if one wanted to enter five squared into Excel, it would take the following key strokes: =5(shift six)2. The first number that is entered is the base and the second number is the exponent. The keystrokes would put the following output into the cell =5^2 and a person would see 25 which is five squared.
This can also be done with the cells. If a person wanted to square the number in cell A1, it would take the following keystrokes: =A1^2. This should now be enough new information to do the assignments.
Click on the links below to find your assignments.
Return to EMAT 6700
Back to BJ's page