pp. 84- 85 complete green square 1,2,3
Oct22/09 Spread sheet work on the computers today so no hw
Oct. 23/09 More work today on microsoft excel. Most of you should have office suite on your home computer so if you don't complete the assignment in class you may finish at home and send your solutions to your i-mail at school and save in your folder. Math 10 Pure: Spreadsheet Worksheet MMost calculations that would be repeated again and again are done on a spreadsheet so the computer instead of by hand does the same calculation.This makes it faster and less chance for mistakes. MThe spreadsheet is a list of “cells” which are identified by the letter across the top and the number down the left side of the spreadsheet.The cells are labeled as the letter followed by the number.For example, C5 is the cell in the C column and in the 5th row.These cells can hold captions, data or equations and is really useful to organize and manipulate data. MTo enter captions or data into a spreadsheet, simply click on the cell that you want to use and type what you want to input into the cell.You can make the cells wider by moving the cursor to the top of the cells and dragging the edge to the right.You can format the cells making them centered in the column, or making them a currency displayed to 2 decimal points using the format function. MTo enter formulas, you will click onto the cell and then press the “=” sign.This tells the computer that a formula will be entered into the cell.This equation can include all the usual functions in math, but it can also include cells from the spreadsheet, which can be added by clicking on the cell.For example, a sample equation could look like “=(C5+A3)/2”. MThe real power of the spreadsheet comes from the types of equations that can be calculated and from the “fill down” function.Once an equation has been entered, you can apply that equation downward by clicking on the cell with the equation and then dragging downward highlighting the cells that you want to apply the equation.Then from the EDIT menu, select FILL and down.This will apply the equation to all the necessary cells.If the equation is linked to selected cells, the fill down function will use the appropriate cells that correspond to the specific equation. MThere are also some built in equations into the spreadsheet that can be used.For example, equations like SUM(A1:A5) will calculate the sum of the numbers from cell A1 to A5 or AVERAGE(C1:C6) will add the cells from C1 to C6 and then divide by the number of cells that there are in the range. MIT IS IMPORTANT TO SET UP THE SPREADSHEET CORRECTLY SO THAT THE DATA IS ARRANGED IN A WAY THAT YOU CAN UNDERSTAND AND THE FILL DOWN FUNCTION WILL GIVE YOU THE INFORMATION THAT YOU ARE LOOKING FOR. MSo, lets set up some practice spreadsheets that will answer the following questions.You will need to think of headings required for the spreadsheet as well as equations that will give you the information required. 1)Sandra opens a savings account in her newborn son’s name.Sandra decided to deposit $150 at the end of every month into this account. a)How much will be in this account for her son after 18 years if the account pays an interest rate of 3.50% compounded monthly? b)How much interest was earned during the 18 years? 2)Frank wishes to save up for a trip.The estimated cost of the trip is $4500.He decides to make quarterly deposits of $400 to a trust company that pays him 8.00% quarterly.Will Frank have enough money saved in this account to afford the trip in 30 months? 3)Alisa spends $75 per month for cigarettes.If Alisa quits smoking and deposits the $75 monthly into an account paying 6.00% compounded monthly, how much will be in the account after 4 years? 4)Alexis is buying a car.Alexis needs a loan for $26731.73 and is able to get an interest rate of 1.90% per year for 3 years.If his monthly payments are 764.50, determine the cost of the loan after the 36-month period. Math 10: Spreadsheet Assignment For each of the following questions, build a spreadsheet that will accurately display the data for each question.Then, using the information from the spreadsheet, answer the following questions.Save a copy of the spreadsheets in your folder for reference at a later date. 1)Trevor invests $1000 in an RRSP starting at age 25 and does so each year until he is 65.Roger invests $3000 in an RRSP starting at age 45 and does so each year until he is 65.If in both cases, the investments earn 6.00% per year, compounded annually, which person will have more money when they are turn 65?How much more money will he have? $ 2)Charlotte is going to invest $100 every year on her birthday into an account that has an interest rate of 4.25% compounded monthly.If Charlotte is 17 years old now, a)What will her investment be worth when she is turning 30? _ b)What will her investment be worth when she is turning 40? _ c)How much interest would she have earned when she turns 40? 3)Jack is planning on purchasing a new car.The car has a price of $50000 but Jack has an $8000 down payment and a trade in worth $13000.The remainder of the car is financed at a rate of 5.50% compounded monthly for 4 years making equal monthly payments of $674.44. a)Calculate the interest that he will have to pay on his new car. b)What will be the amount of the final payment so the balance will be zero on the car? _
Oct22/09 Spread sheet work on the computers today so no hw
Oct. 23/09 More work today on microsoft excel. Most of you should have office suite on your home computer so if you don't complete the assignment in class you may finish at home and send your solutions to your i-mail at school and save in your folder.
Math 10 Pure: Spreadsheet Worksheet
M Most calculations that would be repeated again and again are done on a spreadsheet so the computer instead of by hand does the same calculation. This makes it faster and less chance for mistakes.
M The spreadsheet is a list of “cells” which are identified by the letter across the top and the number down the left side of the spreadsheet. The cells are labeled as the letter followed by the number. For example, C5 is the cell in the C column and in the 5th row. These cells can hold captions, data or equations and is really useful to organize and manipulate data.
M To enter captions or data into a spreadsheet, simply click on the cell that you want to use and type what you want to input into the cell. You can make the cells wider by moving the cursor to the top of the cells and dragging the edge to the right. You can format the cells making them centered in the column, or making them a currency displayed to 2 decimal points using the format function.
M To enter formulas, you will click onto the cell and then press the “=” sign. This tells the computer that a formula will be entered into the cell. This equation can include all the usual functions in math, but it can also include cells from the spreadsheet, which can be added by clicking on the cell. For example, a sample equation could look like “=(C5+A3)/2”.
M The real power of the spreadsheet comes from the types of equations that can be calculated and from the “fill down” function. Once an equation has been entered, you can apply that equation downward by clicking on the cell with the equation and then dragging downward highlighting the cells that you want to apply the equation. Then from the EDIT menu, select FILL and down. This will apply the equation to all the necessary cells. If the equation is linked to selected cells, the fill down function will use the appropriate cells that correspond to the specific equation.
M There are also some built in equations into the spreadsheet that can be used. For example, equations like SUM(A1:A5) will calculate the sum of the numbers from cell A1 to A5 or AVERAGE(C1:C6) will add the cells from C1 to C6 and then divide by the number of cells that there are in the range.
M IT IS IMPORTANT TO SET UP THE SPREADSHEET CORRECTLY SO THAT THE DATA IS ARRANGED IN A WAY THAT YOU CAN UNDERSTAND AND THE FILL DOWN FUNCTION WILL GIVE YOU THE INFORMATION THAT YOU ARE LOOKING FOR.
M So, lets set up some practice spreadsheets that will answer the following questions. You will need to think of headings required for the spreadsheet as well as equations that will give you the information required.
1) Sandra opens a savings account in her newborn son’s name. Sandra decided to deposit $150 at the end of every month into this account.
a) How much will be in this account for her son after 18 years if the account pays an interest rate of 3.50% compounded monthly?
b) How much interest was earned during the 18 years?
2) Frank wishes to save up for a trip. The estimated cost of the trip is $4500. He decides to make quarterly deposits of $400 to a trust company that pays him 8.00% quarterly. Will Frank have enough money saved in this account to afford the trip in 30 months?
3) Alisa spends $75 per month for cigarettes. If Alisa quits smoking and deposits the $75 monthly into an account paying 6.00% compounded monthly, how much will be in the account after 4 years?
4) Alexis is buying a car. Alexis needs a loan for $26731.73 and is able to get an interest rate of 1.90% per year for 3 years. If his monthly payments are 764.50, determine the cost of the loan after the 36-month period.
Math 10: Spreadsheet Assignment
For each of the following questions, build a spreadsheet that will accurately display the data for each question. Then, using the information from the spreadsheet, answer the following questions. Save a copy of the spreadsheets in your folder for reference at a later date.
1) Trevor invests $1000 in an RRSP starting at age 25 and does so each year until he is 65. Roger invests $3000 in an RRSP starting at age 45 and does so each year until he is 65. If in both cases, the investments earn 6.00% per year, compounded annually, which person will have more money when they are turn 65? How much more money will he have? $
2) Charlotte is going to invest $100 every year on her birthday into an account that has an interest rate of 4.25% compounded monthly. If Charlotte is 17 years old now,
a) What will her investment be worth when she is turning 30? _
b) What will her investment be worth when she is turning 40? _
c) How much interest would she have earned when she turns 40?
3) Jack is planning on purchasing a new car. The car has a price of $50000 but Jack has an $8000 down payment and a trade in worth $13000. The remainder of the car is financed at a rate of 5.50% compounded monthly for 4 years making equal monthly payments of $674.44.
a) Calculate the interest that he will have to pay on his new car.
b) What will be the amount of the final payment so the balance will be zero on the car? _