April Calendar Assignment

Using Google Docs create a calendar for April just as you have for previous months.  April begins on a Saturday and has 30 days.  Make sure that you format you paper for landscape and create your table so that it fits on one page.

Make sure that you include and classmates birthdays, and pertinent holidays, school holidays, sporting events, and other crazy holidays etc.....  Use different fonts, shadings, pictures to accent your calendar if you want to make a 100 on this exercise.  There will be an assignment on Google classroom to turn in your completed calendar.

"Play it again Sam"
                         Humphrey Bogart from Casablanca

Instructions for final day of Stock Market Activity

Today we will finish out our Stock Market Activity.  You should have 6-7 day of prices to create a trend of your 10 chosen stocks.  Today we will complete day 6-7 of new prices, net worth, and profit or loss. 

Today we will insert 4 graphs that will hopefully show you a trend of what your stock prices did over a period of time.  You will insert 2 line graphs, a column graph, and a bar chart.

The first graph will be a Stack line chart with Markers.  You will choose two of your stocks and create a line chart that shows their price trend over your 6-7 days of data.  To do this you click on the first stock you want and then hold down the CONTROL  key and click on each days price going across your data (from the original price to your last days price) and then do the same thing for your second choice.  This should highlight all of the information for those two stocks.  You will title this chart Seven Day Price Trend.

Your next graph will be a 2D or 3D bar chart.    In this graph you will Highlight all 10 of your stocks then hold the control key down and then highlight each of the price columns from top to bottom.  Then insert a 2D or 3D graph and change the name to Seven Day Price Trend.

Your next graph will be a Column Graph.  You will follow the same instructions as the bar chart for this graph.

The final graph will be a line chart that show the trend of your profit or loss.  You will click on the Word Total in col B then hold down the control key and click on each of your profit or loss totals and insert the graph below the first three.  Title this loss Profit/Loss Trend.

Turn in lesson on Google Classroom under Assignment title Final Stock Market Activity.

Stock Market Day Two

Today you will need to add columns G, H, and I.  New Price Day Two, New Net Worth, and Profit or Loss.  Again use the text wrap feature to make yours look as close to the example as possible.


Today you will check your investments for day 2.  You will find the price for each of your stocks and enter them in to the New Price Day Two column.  You will then enter a formula in column H that will multiply the original number bought (Col E) times the new price (Col G), this will give you the new net worth of your investment.  To calculate if you are making a profit or loss your will place a formula in col I that subtracts the original amount spent (Col F) from the new net worth (Col H).  You will need to place formulas for totals at the bottom and format all of your information accordingly.  Any thing that is a $$$ should be formatted for currency and 2 decimal places anything else should be for general and 0 decimals.

"Life is like a box of Chocolates..."
                                        Forrest Gump