This final project is due by 2:45 on Thursday, May 27th. Here is the final grading criteria.

• 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)

Here is the final rubric for your video project (100 possible 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.

If you get your spreadsheet in order from yesterday’s directions, then here is your next challenge. See if you can create the following graphs of your data:

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.

Now that we have some time, we are going to further analyze the data that you collected during the Stock Market Game.

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

For this science lab, you are going to complete two virtual dissections. First, click here to go to froguts.com. Once on the site, click on Demo>Begin Demo. This will walk you through some initial observations of the exterior of the frog as well as a preliminary dissection.

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.

This is due on Friday, May 14th, by the end of the day, and should be placed in the Video Project folder inside of 2010.

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.

Please fill in the form below by Friday, May 7th.

Here is the rubric for how I will be assessing your final presentations. Mr. McMahon may have different criteria. You will note that I am not looking at your history, but rather how you use the technology. If you have all of your information typed in, you can start working on these aspects of your final project.

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)