• Turn your spreadsheet into the 7A or 7M Technology folder, on time, and with the file name of Name-Stockmarket (ex: Susie-Stockmarket) - 10 points
• Your final project should print on 2 pieces of paper. Hint: Make sure that your page is set to landscape, and you may need to change your margins to .5 inches - 10 points
• You should fill in the header areas on both sheets. The first page should have your name and Cash Balance. The second page should have your name and Portfolio - 10 points
• Your Cash Balance spreadsheet should be completed, with formulas - 20 points
• Your Portfolio spreadsheet should be completed, with formulas - 20 points
• Complete Graph #1 and make sure that it is labeled - 10 points
• Complete Graph #2 and make sure that it is labeled - 10 points
• Complete Graph #3 and make sure that it is labeled - 10 points
• Extra Credit – complete the final task for the market sectors. This should be on a 3rd sheet. (10 points)

• The final video is exported as a .mov and placed in the FINAL VIDEOS folder inside of the 2010 folder (20 points)
• The final video has the file name of Name-Final (20 points)
• The video is turned in by 3:45 on Friday, May 28th (20 points)
• The video has a clearly identifiable theme (40 points). Know that both Mrs. Bartlett and I will view the video to make this determination.

1. A double-bar graph to compare the initial value of each stock to the final value of each stock on April 23rd.
2. A pie chart to show how much of your total portfolio each stock represents
3. A pie chart which includes how your stocks are spread across each capitalization and how much was left as cash.

1. Make sure that your Cash Balance sheet is completed and that it is named Cash Balance
2. Create a new sheet and name it Portfolio. Your columns should be:
   • Ticker Symbol
   • Company Name
   • Date Purchased
   • Purchase Price Per Share
   • # of Shares Purchased
   • Total Value (Hint: Total Value = Price per Share x # of Shares)
   • Price Per Share on April 23rd
   • Value on April 23rd
   • Return on Investment (Hint: you need a formula)
   • Small Cap
   • Mid Cap
   • Large Cap
3. Use Morning Star and Yahoo Finance to find any information that you need

If you finish that exercise, here is another frog. With this one, you can get a closer look at the interior of the frog and its organs. Click here to begin.

Use the Storyboard template from Pages to map out your video. What images will you need? What music? What is the overall outline of your video?

When you come to class next week, you will need to bring any digital images and/or music files that you will require to construct your final video.

Criteria

• Use of Masters – stay within the framework of slide masters and choose the correct master for the slide (10)
• Design Choices - the choice of overall theme should match the topic, lead to legibility, and support the presentation as a whole. Any transitions or effects should enhance and not distract. (15)
• Visual Hierarchy - each slide should be laid out in such a way that there is order (20). You should also make sure that you have appropriate grammar so as to have your hierarchy within your writing. (HINT: use a capital letter to begin every sentence)
• Cohesiveness of Material - the titles, text, and images should all support each other in order to serve as an effective presentation tool (30)
• File Name - saved as Name-Topic (example: Billy-Fortitude), and in the 7A or 7M History folder (5)
• Bibliography - all images and information are documented correctly using NoodleTools. They should be presented in chronological order in the bibliography slide(s) (20)

For today, here’s what you need to do. HINT: follow the directions!!!

1. Open Numbers and choose Blank
2. File>Save As>Name-Task2 and put it in the Hileman or Tavares Math folder inside of 2010
3. Name Sheet #1 as Sector Database
4. This sheet should contain all of the data from your math class’ database except for the info on Caps. Copy & paste the info into place. With this spreadsheet, you should sort by each sector so that you can calculate your ROI for each sector.
5. Name Sheet #2 as Sectors
6. Title your columns
   • Sector Name
   • My Portfolio
   • Market Value on 2/22
   • Market Value on 4/23
   • Market ROI
7. Fill in the data based on your info from Sheet #1 and the market values. Use this page from Morning Star to find the market info.
8. Create a graph to show the relationship between your data and the market
9. Create a Sheet #3 and call it Caps Database. On this sheet, you will need to do the same calculations as you completed for your sectors, but for your small, mid, and large caps.
10. Create a Sheet #4 and call it Caps. Use the same concept as from your sectors sheet to create a table and graph to compare your portfolio to the market value.
11. Create a Sheet #5 and call it Total Market Value. Use this sheet to compare the total portfolio of the class to the following indexes: S&P500, the Russell 2000, and the Barclay’s Capital Aggregate Bond Index (use 1.6% for Barclay’s according to Mr. Hileman’s directions)

I have also shared a PDF file with you to give you an idea of what the final Numbers document may look like. You cannot just use my numbers as they are NOT correct. Good luck!

• Martin Luther King – Sawyer
• Mahatma Ghandi – Freddie
• Oprah Winfrey – Jane
• Ellen MacArthur – Maggie D
• Margaret Thatcher – Kaylynn
• Desmond Tutu – Will
• Mary Robinson – Maggie W
• Bono – Sophia
• Angelina Joli – Ty
• Arthur Ashe – Mary Ann
• Mia Hamm – D.D
• Jim Henson – Lydia
• Rosa Parks – Nadia
• Ernest Shackleton – Annie
• Harry Connick Jr. – Ally
• Ted Williams – Will
• J.K Rowling – Victoria
• Jennifer Aniston – Aubrianna
• Thomas Edison – Jack
• Lech Walesa – Giles
• Amelia Erhart – Heather
• Jim Brown – Jake
• Mother Teresa – Margaret