Braves Assignment :: Performance Test 02
Click here to go back to the Technology Lesson Plans

Complete the following tasks using the Braves Spreadsheet
from the web site.

1) A loyal Braves fan wants to purchase 6 field level seats for this Friday’s game. They give you $250.00 for the tickets what is the change that they will receive back?

2) A church is purchasing 11 upper deck reserved tickets for a youth activity. Since they are exempt from paying taxes what is the cost per seat total?

3) You have a total of $175.00 to spend on tickets what is the best combination of tickets that you can get

• 4 field level tickets, 2 upper deck reserved tickets

• 3 upper deck tickets, 3 reserved tickets, 4 outfield tickets

• 2 reserved tickets, 4 box seats tickets, 3 upper deck tickets

4) What is the total cost of 4 outfield tickets?

5) A customer purchase 6 upper deck tickets, and they give you $40.00, how much money do they still owe you?

6) Next to the Total Cost column insert another column titled “number of seats”. Then type in the following information in the “number of seats” column:

• 33,000 (field level)

• 6,738 (reserved)

• 45,972 (outfield)

• 5,634 (upper deck reserved)

• 736 (box seats)

• 6,734 (upper deck)
  
  Insert 4 for each item under “# of Tickets”
  
  7) Using the spreadsheet, create a chart (graph) containing the following information:
   Column labels (SEAT SECTIONS, # OF TICKETS, COST PER TICKET, COST PER SEAT)
   Names of all 6 seat sections (FIELD LEVEL, RESERVED, OUTFIELD, UPPER DECK RESERVED, BOX SEATS, UPPER DECK)
   Data in all columns for all 6 seat sections
   Do not include the “Sales Tax” column, the “Total cost” column, the “# of seats” column, or the “total Cost” row