Thursday, March 31, 2011

Risk - Can you handle the ups and downs in the Stock Market
Spreadsheets are great tool to show you how investing in the stock market has risk and rewards compared to placing your money in a savings account earning constant interest rate. It is your decision where to put your money.

In 2004 you were were given a gift of $1000. At the time you had 2 options on what to do with the money. Place in a secure Certifcate of Deposit or Invest in a mutual fund that mirrors the S & P 500 Stock Index.

What would be the best Investment option?
CP Federal Certificate of Deposit
S & P 500 Stock Index

- Click to make bigger

http://3.bp.blogspot.com/-JwgkhurW7P0/TZMGVED2AFI/AAAAAAAAYgs/haAAdHfjKXk/s1600/Screenshot.png
Copy and paste this link

Start by layout the following table on your Daily Notes

Locate the APY for the CD at CP Federal and enter
Use the future value function to calculate what the $1000 will be worth in 5 years

Now the S & P is a bit more complex.
The rate changes each year.
You will have to do 5 calculations.

Wednesday: - Risk VS Return

Wednesday: - Risk VS Return
Please check your grades in PowerSchool. You will see the grades from Moodle have been transferred.  If you complete an assignment or have turned in an assignment that is not showing up in PowerSchool.

1. Check to make sure you have submitted in Moodle
2. Submit if you have it completed
3. Create a shared Google doc with your name and the name of the assignment you have submitted in Moodle.
4. Share the document with me.

Click Image for larger size

 Terms for your Daily Notes:

What is a stock Index
What is the S&P 500
What is the Dow Jones Industrial Average (DJIA), DOW

Sample Stock Project

Tuesday

What stock to buy? Sprint, Verizon Communications Inc, or ATT

1. What is Net Profit Margin?
2. What is a PE ratio tell you?

Video Help
Create a comparison for 3  cell phone carriers price, PE ratio, and Net Profit. What company would you buy based on the data?

Monday, March 28

Last week of the Marking Period

Please make sure you are submitting your google spreadsheets correctly. A number of you are sharing it with me. I can only grade it if there is a link in Moodle. Check your assignments.

• Directions for Sharing

Make sure you have completed Friday's Quiz

1. Rename and/or Create a Worksheet for Each day of the Week for your Daily Notes for this week.
2. Share and submit this weeks Daily Notes
3. Go to Google Finance
4. Type in aapl the ticker symbol for Apple Computer
5. On the left side click on Historic Data
6. You will be taken to a listing of the most recent closing prices for Apple Computer.
7. Down load the data (Lower Right)
8. Upload the data into a google spreadsheet
9. Create a chart for Apple Computers Close Price
1. What type of chart would you create to show the closing price of appl computer stock for 1 year?

Friday

• Quiz today in Exam View 
• Weller Quiz 7 - Week 8

• Use your Daily Notes on the quiz

Once you finish the quiz make sure you have correctly submitted the 2 exercises for this week

1. Borrowing VS Saving
2. Creating a Payroll Register

Directions:
Compare Compounding Interest with a Spreadsheet.
How much more or less will $1000 dollars earn in 8 years, compounded daily at 4 % compared to $1000 over 8 years compounded annually?

Thursday

Thursday, March 24, 2011



Saving money in Plain English


This is a fun website to explore what it would take to reach your saving goals.
LifeTuner

See if you can not calculate what it will take to save a $1,000,000.



Directions Link
 Video Link
How much will the $250 your grandma gave you for Christmas be worth in 4 years if you put it in a saving account earning 1.4% APR?

This time we are using just the =FV(rate, NPER, PMT, PV, type)

What if you get a job delivering pizzas and can save just $2.00 a day or can add $60 a month to the account?




Video Link

Wednesday, Early Release Day!

Video Link
Savings: - Take the survey at the bottom of today's Daily Notes

Using the =FV(rate, NPER, PV, type) function
New Term is FV - Future Value of an investment... Or what will it be worth at some point in the future.

Basic work and save plan:
1. Think of a very simple job that will take very little amount of your time.
2. How much do you think you could save in 1 month every month for 1, 2, 3,.....
3. What would your Saving be worth at the end of each year?


Break down what you have to do in simple steps using a spreadsheet
1. Calculate how much you would have to save each day.

• What is the average number of days in a Month?
• On Average how much will you have to save each day?

2. If you put your money in a Piggy Bank, what will it be worth in 1 year, 2 years, 3 years, 4 years, 5 years.
3. If you put your money in a Saving Account at CP Federal. How much will it be worth in 1 year, 2 years, 3 years, 4 years, 5 years.

Tuesday, March 22

Spreadsheets and Money!
You just got a new Credit Card - Yippeee! The card has a 24.9% interest rate and a really cool MTV logo. You went shopping and ran up a Balance of $5000!
How much do you have to pay back?




Create a spreadsheet that will show you exactly how much will you have to pay if you spread out your payments for; 1 year, 2 years, 3 years, 4 years, 5 years.
Do make sure you have linked last weeks travel budget into Moodle.

Watch the Video Below and answer the 3 questions about borrowing money.
Borrowing Money in Plain English

1. What do banks get in return for giving you money?
2. What does APR stand for?
3. When talking about a loan what does word term mean?

You just got a new Credit Card - Yippeee! The card has a 24.9% interest rate. You went shopping and ran up a Balance of $5000!
Now reality hits you have to pay all this back.

Create a spreadsheet that will show you exactly how much will you have to pay if you spread out your payments for; 1 year, 2 years, 3 years, 4 years, 5 years.

Video Link

Using the =PMT(rate, NPER, PV, FV, type) function

A Credit Card balance of just $5,000 with 19.99% APR
How much interest will you be forking over for each term?

What is the total purchase price for all the good stuff you bought for $5000.

Monday, March 21st

Set up your Daily Notes just like we did last Week.
Make Share them with anyone with the link. Then post them to the Daily notes Week 8 Link area.

Cleaning up the Map!

1. When working with a spreadsheet what key must start every formula?

Use Your Excel Warm UP to answer the following Problem

Excel Warm Ups
You only have $20.00 to spend on gas today and gas is $2.85 a gallon. How many gallons could you buy?

Friday! March 18th

Quiz today:
You may use your Daily Notes.

You should have already submitted your daily notes on Monday as a link.

---

Video Link
You are planning a trip to St Pete Times Forum in Tampa Florida to watch West Virginia University and Clemson.

You can rent a car for $37.78 at Enterprise
 and you have to pay  the fine print "MILEAGE IS CHARGED AT 150 FREE MILES PER DAY AND $.25 FOR EACH ADDITIONAL MILE FOR THE ENTIRE RENTAL."

You are thinking about renting the car and driving down to Florida. 

How much will the entire car rental cost? What if you split the price with 3 friends (4 way split)

Thursday, March 17, 2011

Happy St. Patrick's Day!

Daily Notes. 
Video Link

 What is the sum of the following numbers?
 What is the average of the following number?
89   
5467   
9445   
5697   
42789   
12365   
7895
12569


If gas cost in  Milan Italy 1.37 €   per liter how much would 20 Gallons Cost in US dollars?
There are several Problems inside of this 1 problem
1. What is the exchange rate from € to $
2. How many liters in a gallon
3. How much will 20 gallons cost

Wednesday - Early Release day

If you activated the link from an email that was sent to you from the "Wish I was Here" map you should be able to add your location marker.

I will be out tomorrow and Friday. Please make sure you check and do the Daily Notes for both days. The material will be on the quiz.

1. Create a list of the 1st 100 multiples of 23.
    What is sum?
    What is the Average?
    What is the difference between the High and the Low numbers?

2. How many multiples of 4 are there between 20 and 116? - You can   use the count function to save time

Tuesday! Chart

I am still working on a solution for allowing you to place a marker on the "I wish I was here" project. One solution is for you to complete this form and I can invite you via email


Daily Notes:
Bar and Column Charts -

Creating a chart:
Use this website Jackson Weather Data

1. Copy the Data from January - March (you may have to re-type)
2. Use the find and replace option to remove all of the degree marks (°)
3. Use the find and replace option to remove all of the in markers
4. Click on the Chart Tool from the tool bar
5. Select only the Winter months for a chart
6. Select a Bar Chart
7. Use the customize
8. Add an appropriate title.

Monday, March 14, 2011

1. What does the sigma (The funny E) located inside of the standard tool bar allow you to do?
2. The following is a list of people that owe you money on a new Google Spreadsheet.
1. Sort the list from least to greatest
2. Use a function to find the total
3. Use a function to find the least amount of money owed to you

Name	Amount
Joey	56
Stevie	72
Rob	98
Scott	101
Frank	96
Paul	108

Project:
I would rather be here

Friday!

The following items should be completed today:

• Spreadsheet Task 1 - You had to download your final sheet then submit to Moodle
• Spreadsheet Task 2 - Your GPA - You are sharing a spreadsheet and giving me the web address
• Spreadsheet Task 3 - Shared Spreadsheet with data entry. You should have a link posted to your sheet.

Daily Notes - will be a shared sheet and you will need to give me the web link to submit

Quiz Today
I would Rather Be Here Project

Daily Notes

1. Starting at 13. What is the average of the next 10 multiples of 13.  Round your answer to the nearest whole number.
2. Organize a Spreadsheet that will calculate the Average, Median, Max, and Min values for the following gas prices found around Jackson County:

 gasbuddy.com


Starting at 13. What is the average of the next 10 multiples of 13.  Round your answer to the nearest whole number.

Thursday - Parent Teacher conferences today

Quiz tomorrow will be on:

• Vocabulary given to you on Tuesday.
• Row, column, cell, sheet, fill down, text wrapping, formula, function
• You ability to use basic function with a spreadsheet
• Given a list of numbers you should be able to calculate the average, median, max, and min values.
• Use simple mathematical symbols (

Daily Notes:

On you daily Notes solve the follow simple math problems:
Remember to place an = sign 1st

               
= 1*2+3                
= 1^2        
=sqrt(16)        


Now with Algebra and a spreadsheet

1. Use the fill handle to create a list from 1 to 20
2. In the next column create a list of 2s
3. In the next column multiply your 1st number x the second and add 3
4. In the next column square the the 1st column
5. In the final column take the square root of square column. 

You should have something similar to the screen shot below.

Assembly Today - Wednesday and Early Release

GPA assignment should be completed on a Google Spreadsheet!

Today we are all going to be working in Groups on a shared Spreadsheet assignment.

Your assigned groups are your rows(The short rows with 3 or 4 people)

Assignment

Tuesday, March 8

Use the same spreadsheet we started yesterday and copy the following vocabulary

Keep your daily Notes for this unit on a Google Spreadsheet document.
Monday, March 7, 2011
Starting a Unit on Spreadsheets

• Complete the Task and Projects in Word 1st
• Then begin the Excel tasks

 Warm Up: Video Link - Written in Excel use your Google Docs account

Start a new Excel Warm ups Document

1. What is the Sum of the following numbers
2. What is the Greatest or Max
3. What is the Least or Min
4. What is the Median
5. What is the Mean (Average)
6. Sort the list from least to Greatest

63
56
57
58
55
60
59
53
54
61
62
64
52
65
51
50
48
66
49
47
45

Friday, March 4, 2011 - No Quiz today

There is no quiz today!

Use the extra time to complete your Timeline project and Computer Shopping Project.

---

A summary of yesterday's survey is available by clicking here.

We know a table is a great tool to organize and display data. The following an excerpt from an article written about teen cell phone use. How could you display the information in the article inside of a table? Make sure you are keeping similar or grouping similar items. You should have 3 tables.

Text messaging frequency increases as teens age – 35% of 12 year-olds say they text daily, while 54% of 14 year-olds and 70% of 17 year-olds text everyday. Younger teens are much more likely to say that they never send or receive text messages – 46% of 12 year-olds do not text; only 17% of 17 year-olds do not text. Girls are more likely to text than boys with 77% of all girls texting while 68% of boys do. Older girls ages 14-17 are the most avid texters – 69% say they text their friends every day, while 53% of boys the same age report daily texting.

Link to full article  -

How phones are used with friends - What they can do and how teens use them

---

New Survey today as a follow up to yesterday's Daily Notes.

Thursday, March 3, 2011
 Video Help
Table Example:  as a tool to organize and display data.

1. Read the paragraph below. It has a lot of numeric data.
2. Pull the data from the text into a table that that will correctly show the data.

Make sure you keep similar or like data chunks together.
Keep your data labels short

Video Help
Teens in our focus groups talked about how in many families, parents as much as teens were the instigators of the first phone purchase. Parents are most often the phone provider – 70% of teens have phones fully paid for by someone else. Most American teenagers get their first cell phone in middle school, at age 12 or 13: 23% of teens got their first cell phone at age 12 and another 23% got their first phone at age 13. About 20% of teens have their first phone by the time they enter middle school (age 11 or under for first cell phone owned). Another 14% of teens get their first phone at age 14 and roughly 20% get their first phone when they’re between 15 and 17. 

Wednesday, March 2, 2011

Tuesday, October 5, 2010
Google site problem

Google Shared Daily Notes

• Computer Shopping
• Time Line
• Newsletter - Word Task 13

Create the table below but add a row to summarize the data
Video Link