Beth Holland

Food for thought…

7th Grade – Spreadsheets Part #2

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.
Extra credit: add three more columns to your spreadsheet for each of the three major sectors. See if you can create a pie chart to show how your stocks are diversified across each sector.

Author: brholland

EdD Student, Writer, Speaker, Consultant

Comments are closed.