medals.gifThe 2008 Summer Olympics

Activity 1:

Make a column graph showing the 5 countries who won the most medals at the 2008 Olympics.
Show the number of gold, silver, and bronze medals won by those countries by graphing 3 bars for each country.
Add appropriate titles and legends.

phelps.jpg
Michael Phelps
Activity 2:

Several people won more than one medal for the U.S. Make a bar graph showing the top 5 medalists for the U.S.
Show how many medals they won and show their names.

Go to this site to get information for making graphs:
http://results.beijing2008.cn/WRM/ENG/INF/GL/95A/GL0000000.shtml




Activity 3--Commission:

  1. Pretend you are a salesperson at Dillards. You get 25% commission for your sales.
  2. Make a spreadsheet to show your sales for the weeks below. Make the columns wider as needed.
  3. Bold the titles as shown.
  4. Merge and center the main title.
  5. Add formulas to find Total Sales for each week, Commission for each week, and Total Commission for the 5 weeks.
  6. Put a box border around the cell that has the total commission.
  7. Underline the titles row.
  8. Copy the entire table and place it below the 1st table on the spreadsheet.
  9. Change the numbers as they appear in the second spreadsheet below. Watch how the totals change.
  10. Make a column graph to show your Commission for the 5 weeks.

Priscilla's Sales
Week of:
8-Nov
15-Nov
22-Nov
29-Nov
6-Dec
Monday
$125.00
$115.00
$175.00
$250.00
$275.00
Tuesday
$150.00
$165.00
$145.00
$350.00
$375.00
Wednesday
$225.00
$225.00
$215.00
$450.00
$465.00
Thursday
$125.00
$150.00
$125.00
$325.00
$350.00
Friday
$350.00
$400.00
$375.00
$450.00
$475.00






Total Sales











Commission











Total Commission:























Priscilla's Sales
Week of:
8-Nov
15-Nov
22-Nov
29-Nov
6-Dec
Monday
$115.00
$125.00
$185.00
$275.00
$300.00
Tuesday
$125.00
$175.00
$125.00
$375.00
$350.00
Wednesday
$205.00
$215.00
$200.00
$425.00
$450.00
Thursday
$115.00
$175.00
$135.00
$315.00
$425.00
Friday
$300.00
$450.00
$385.00
$500.00
$450.00






Total Sales











Commission











Total Commission: