Given $10,000. (in fictitious
money;), you will decide which stocks are worthy of your investment. Each
day for 5 days you will check the value of your stocks and enter formulas to calculate
the value of each stock in your portfolio and the total value of your
portfolio. At the end of 5 days, you will graph the value of your
portfolio over time. You can go to www.yahoo.com, then finance to look up the
stock prices for each day. There is
a link to look up the stock symbol it you don’t know it.
|
Stock
Market Spreadsheet |
||
|
Name |
||
|
Points |
Points |
|
|
Earned |
Possible |
Category |
|
|
10 |
Spreadsheet
layout is clear, color and white space used well. |
|
|
10 |
Data
entered is correct -- Ticker symbols, stock names, prices. |
|
|
10 |
Data
for stock prices is collected for 5 days. |
|
|
10 |
Formulas
calculate value for each stock and total value of portfolio. |
|
|
10 |
Graph
shows the changing value of the portfolio over 5 days,
is clearly labeled and is sized well. |
|
|
50 |
Total |