1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12...

Transcribed Image Text:

1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12 2222 4 3 12 2 12 1 12 0.1 12 0.01 8 12 0.001 9 12 0.0001 10 12 0.00001 11 12 0.000001 12 12 0.0000001 D Quotient (calculator) Quotient (Excel) 2. Find the Quotient for each row using a calculator and type the result in the third column. Recall that to find the Quotient, you take the Dividend and divide by the Divisor. Dividend + Divisor = Quotient 3. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 4. Based on the pattern of the Quotient, do your best to explain what happens when 12 is divided by 0? 5. What happens if you enter the expression 12 + 0 on a calculator? 6. Now, conduct this activity using Excel. Enter the following expression into cell D2: =A2/B2 and hit the enter key. Repeat this step for cells D3 through D12. Note that it is important to type the equal sign first. This tells Excel that what follows is a mathematical formula to be computed rather than text. 7. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 8. Page 21 of your textbook says that "a 0 is undefined for any number a. Any number divided by zero is undefined." That means that the Quotient is undefined for any number when divided by zero; the Quotient does not have meaning. Why do you think the Quotient does not have meaning? 9. Now, switch the number values in column A with column B, so that the Dividend ranges from 4 to 0.0000001 and the Divisor is consistent at 12. Now what is happening to the Quotient? 10. What patterns do you notice? 11. What is one question about algebraic expressions or division by zero that you are wondering about? 12. Now, create two new patterns for the Dividend and/or the Divisor, for your classmates to investigate what happens to the Quotient. 13. For your initial post, post pictures of your excel work but you don't have to attach the actual excel document. You also need to post the instructions addressing all of the prompts and questions, showing your work, and explaining your solutions or answers to all of the questions. Make sure to also post the two new patterns for the Dividend and/or the Divisor for your classmates to investigate what happens to the Quotient. 1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12 2222 4 3 12 2 12 1 12 0.1 12 0.01 8 12 0.001 9 12 0.0001 10 12 0.00001 11 12 0.000001 12 12 0.0000001 D Quotient (calculator) Quotient (Excel) 2. Find the Quotient for each row using a calculator and type the result in the third column. Recall that to find the Quotient, you take the Dividend and divide by the Divisor. Dividend + Divisor = Quotient 3. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 4. Based on the pattern of the Quotient, do your best to explain what happens when 12 is divided by 0? 5. What happens if you enter the expression 12 + 0 on a calculator? 6. Now, conduct this activity using Excel. Enter the following expression into cell D2: =A2/B2 and hit the enter key. Repeat this step for cells D3 through D12. Note that it is important to type the equal sign first. This tells Excel that what follows is a mathematical formula to be computed rather than text. 7. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 8. Page 21 of your textbook says that "a 0 is undefined for any number a. Any number divided by zero is undefined." That means that the Quotient is undefined for any number when divided by zero; the Quotient does not have meaning. Why do you think the Quotient does not have meaning? 9. Now, switch the number values in column A with column B, so that the Dividend ranges from 4 to 0.0000001 and the Divisor is consistent at 12. Now what is happening to the Quotient? 10. What patterns do you notice? 11. What is one question about algebraic expressions or division by zero that you are wondering about? 12. Now, create two new patterns for the Dividend and/or the Divisor, for your classmates to investigate what happens to the Quotient. 13. For your initial post, post pictures of your excel work but you don't have to attach the actual excel document. You also need to post the instructions addressing all of the prompts and questions, showing your work, and explaining your solutions or answers to all of the questions. Make sure to also post the two new patterns for the Dividend and/or the Divisor for your classmates to investigate what happens to the Quotient.