The task from Mr. Hileman and Mr. Tavares is for each class to analyze their collective holdings, compare them to various market indexes, and to show their collective diversification (or lack thereof). In order to do this, you will need to accomplish the following three (3) tasks. Upon completion, each math class will present their findings to the rest of the grade as well as a panel of experts.

Task #1 – Create a Common Database

1. You will need to have a master database of all of the holdings. List each holding alphabetically by ticker symbol. Combine duplicates, ensuring that you count all of the duplicate shares. For example, if three teams each hold 100 shares of Apple in their portfolios, then the class portfolio should show 300 shares of Apple. Only use the holdings in the portfolios as of the 23rd of April. For the total value of each of the holdings, use the pricing data for market close on April 23rd. Make one final listing showing the cash balance on April 23rd. Calculate the percent increase or decrease of each of your holdings (ROI), using February 22nd as the buy date, and April 23rd as the last day of change.
2. Identify the sector for each holding. When the total dollars invested in each sector is computed, make a place on your spreadsheet that shows the total dollar amount for each of your sectors.
3. Identify the capitalization for each holding. (large, mid, or small). When the total dollars invested in each cap category is computed, make a place on your spreadsheet that shows the total dollar amount in the cap category.

A GoogleDoc has been shared with all of you. Within the workbook, there is one sheet for each math class. You will need to fill in the columns with your data. Remember, to indicate sector or cap, place a 1 in the appropriate column.

Task #2 – Graph your Data

As part of your technology class, EVERY person must create a Numbers document from which to graph your data. You must graph:

• The ROI of each of your sectors vs. the whole market’s return in that sector
• The ROI of each of your caps vs. the whole market’s return in that category
• The return of the class portfolio vs. the following indexes: S&P500, the Russell 2000, and the Barclay’s Capital Aggregate Bond Index (use 1.6% for Barclay’s) from February 22nd until April 23rd.

HINT: think double-bar graph…..

Task #3 – Create a 4 slide presentation

Inside the Hileman or Tavares math folder, each class needs to create a single Keynote presentation which you will use as your final. Your four slides should be a Title slide plus one slide for each of your graphs.

Sectors: For this project, you have a choice as a class to use all twelve sectors, or to combine them as Mr. Hileman has done below. The current spreadsheet has them combined, but you can change that. It is your project; it is your decision.

Information

• Hardware
• Media
• Software
• Telecommunications

Services

• Business Services
• Consumer Services
• Financial Services
• Healthcare

Manufacturing

• Consumer goods
• Energy
• Industrial materials
• Utilities

Today, we are going to practice being scientists and observe some creatures in the wild. We are going on deep into the wilds of Arkive.org in order to find some of the most rare animals on earth. When you find them, your goal will be to observe them in their natural habitat.

Several years ago, Congress established an official Day of Remembrance for the victims of the Holocaust, and the Holocaust Museum was established as a permanent memorial. On Sunday, April 11th, the world observed the 65th anniversary of the liberation of the Nazi concentration camps with fanfare and presentations at the museum.

President Obama referred to the Holocaust as “our history,” understanding that Holocaust memory belongs to all of humanity. Because unlike the battle-hardened soldiers who liberated the camps and brought freedom to Europe, we now know that the unthinkable is thinkable. We know all too well the human capacity for evil and the catastrophic consequences of indifference in the face of evil. And we now realize that to preserve human freedom, what we do matters. Every day each of us has the potential to shape the world in which we live. (Source: 2010 Days of Remembrance)

For weeks, you have tried to empathize and relate to your historical figure who witnessed these events first hand. Have you succeeded? What have you learned? Did the trip to DC change your opinions in any way?

To finish up this project, complete one final blog post as a sort of farewell. Make sure that you discuss what you have learned about your person as well as yourself. Write it from the perspective of your person, much like you did with your other posts, and be sure to include media that will enhance the final experience.

DUE DATE: Friday, April 30th. (Note: we will be working on the stock market game next week in class)

The purpose of creating this Ning was to allow you to not only experience another person, but to also interact. This week, you should do two things.

1. Respond to the Forum post
2. Read others’ forum and blog posts and then comment on them.

We will be creating these presentations in Keynote. To get started, please do the following:

• Open Keynote and Choose White
• File>Save As> Name-Topic1 (example: MrsH-US_Involvement1)

When designing a presentation, it follows an outline – much like a paper. However, there are a few rules.

1. Do NOT do anything to your fonts or colors until the very end.
2. Do NOT use complete sentences unless you are displaying a quote. Slides are visual cues for your audience and not a script for you.
3. Use SLIDE MASTERS.
4. Title Slide – this should introduce your topic, not you. The Sub-Title place is NOT for your name. Leave this until the very end
5. Slide #2 (Introduction) – this does not mean that the title is Introduction. You should use this slide to tell your audience what you plan to talk about. In other words, introduce your overall concept and your 3 supports.
6. Support slides – for each of your examples, you will need 2-3 slides. At the minimum, 1 slide to explain the example and 1 to explain the significance.

You are not going to need to give everything to Mr. McMahon. Therefore, to print, do a File>Print and then click the “more” button (upside down triangle next to the printer location) so that you get additional options. You can indicate exactly which pages you would like to print, and should also print out individual slides. This image will give you an example, or just ask.

Now that you have your facts typed, let’s try to find some pictures.

1. Begin by looking on the Lonely Planet website.

2. They try Wikipedia

3. If you still can’t find what you are looking for, ask Mrs. H

Before you get started, please fill in the short survey for Mrs. Ashby. The link is one post down.

BOTH classes, this is your week to start polishing up projects. You may work at your own pace, and however you wish, but these things must be completed by the end of your second class.

• Stock Market Game Cash Balance – all transactions to date must be entered into your team spreadsheet. See if you can figure out:
  1. How/why your cash balance may or may not be the same as what is on your spreadsheet
  2. The “glitch” that may make your cash balance way off.
• History Ning Blogging – In class, we discussed what makes a blog different from just writing an essay (infusion of images, video, and hyperlinks as well as the ability to make comments).
  1. Go back to any one of your blog entries and see what you can do to enhance it. I have added a blog post to William Thalhimer’s page as an example.
  2. Create a wall post that announces how or why you updated your blog.

Mrs. Ashby would like for each of you to please take this survey for the Newport County After School program.