The Dream Team

Page Setup 7 # of pages 1 Step 1: Place the masthead of your newsletter in the header of your document (within the top 2.5 inch margin). Dimensions 8.5 x 11 inches Step 2: Use page or column guides to divide the page into two equal columns. Leave a .5 inch gutter space between the columns. Margins 2.5 inch top margin, and Step 3: Place the contents of the body of the newsletter within .25 inch left, right, and these columns. Note: Do not place any contents inside the .5 bottom margin inch gutter space (see page setup illustration below for more assistance). Orientation Portrait 11” 8.5” Word Processing Team Newsletter Place the masthead of your 2.5” newsletter here. .5” Place the contents Place the contents of the body of your of the body of your newsletter here. newsletter here. THE DREAM TEAM 43

Ryan used his newsletter to increase traffic to his team’s social 7 IN THE media sites. He included an article about a featured player and was sure to shine a spotlight on Bay City Boltz’ Twitter, Google+, Instagram, and Facebook sites. Connecting with fans ZONE in their inbox was a smart strategy for marketing Ryan’s team. Word Processing Team NewsletterPlayer Spotlight Blit zFan Newsletter Avoiding Concussions Boltz This month’s player spotlight is dedicated to quarterback Everyone knows that concussions in sports are common. Here are some ways to avoid suffering Tom Brady from one yourself. He has participated multiple First, learn all you can times in the Super Bowl and about the ways you can has been named MVP on get a concussion. numerous occasions. Born on Second, wear protective August 3, 1977 in San Mateo, gear such as helmets CA, Brady has achieved a level of fame that many and mouth guards. players dream of. His professional career began with Third, follow the rules of the New England Patriots, leading them to the NFL the game. Championship many times. He is married to super model Gisele Bundchen and has three children. Playing with safety in mind will ensure everyone gets the most Follow the out of the game with the least Bay City Boltz amount of trauma. The Bay City Boltz can be found on all of the Giving Back most popular social media platforms. Follow The Bay City Boltz has arranged to take part at an them on Twitter, Google+, Instagram, and upcoming fundraising event for the Bay City Facebook at @baycityboltz. Find out Children’s Hospital. A few of the team’s players have committed to appear at a meet and greet during the what’s happening with the team, what products hospital’s fundraiser this month. They will sign they are endorsing, and what new event they autographs, talk with fans, and take pictures. The are planning. Get a glimpse of what the team is following players are scheduled to appear: up to both on and off the field. Tom Brady Michael Strahan Jerry Rice The Bay City Boltz realize the importance of building strong relationships with our community and are excited to help out a very worthy cause. Use Ryan’s newsletter as a guide to help create your own. Do not duplicate his work. 44 THE DREAM TEAM

Spreadsheets ZONE 2 Game Plan Analyzing important team data In this section, you will use spreadsheet software to organize, calculate, and analyze important team information and data. SS-1 Season Schedule 46 Equipment List SS-2 Travel Expenses 48 SS-3 Salary Sheet 52 • Project Planning Forms SS-4 Promotional Calendar 54 • Spreadsheet Software SS-5 Merchandise Inventory 56 SS-6 Ticket Sales Analysis 60 THE DREAM TEAM 45

1Spreadsheets Season Schedule Determining Your Home and Away Games Your Goal 2. Name the workbook SS-1 Season Schedule and save it to The Dream Team folder. Your team is gearing up to play games for the season. Refer to the spreadsheets provided by Ryan and Allie for Now the schedule needs to be worked out and it’s assistance. Do not copy the content of the samples. your job as owner to organize the dates, times, and location of the season games. This type of data can 3. In cell A1, enter the title <Your Team Name> easily fit into a spreadsheet where columns and rows <Year> Season Schedule. can be formatted to fit text, and borders or shading can be applied to make things easier to read. 4. Merge and center cell A1 across cells A1 – E1. In this project, you will create a schedule for the first 5. Format the title with an appropriate font size, ten games of the season—five at home and five away. SKILLS UTILIZED style, text color, and background color to Use spreadsheet software to organize your dream coordinate with your team colors. team schedule. 6. In cells A2 – E2, enter the following column headings: Date, Time, Opponent, Location, and Tactics Home/Away. Note: Adjust row heights and column widths as needed so that all data displays zz Use the Internet to find the names of fields, properly. arenas, or stadiums where your opponents will 7. Bold and center align the column headings in play. cells A2 – E2. 8. Format column A as dates that show the day of zz Format your spreadsheet with borders and the week, month, date, and year. shading to make it easier to read. 9. Format column B as times that show hh:mm AM/PM. 10. Using your completed SS-1 Planning Form, zz Read through all instructions before proceeding key your season schedule information into the with this project. spreadsheet. 11. Center align the text in columns A, B, and E. zz Review the “In the Zone” section for guidance 12. Shade each row that contains an away game with when completing this project. a color of your choice. Be sure the text color is contrasting. Instructions 13. Apply a bottom border to row 2. 14. Change the orientation of your spreadsheet to landscape. 15. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 16. Submit the spreadsheet as required by your instructor. Download and complete the SS-1 Planning Form from The Dream Team section of www.mycompanionsite.com. 1. Create a new spreadsheet file. 46 THE DREAM TEAM

IN THE Ryan and Allie created the first year season schedule for their 1 dream teams using spreadsheet software. They considered ZONE formats and colors since the spreadsheet would later be used in other team material, such as the team program and a presentation to their instructors. The season schedules that Ryan and Allie created are shown below. Bay City Boltz 2016 Season Schedule Spreadsheets Season Schedule Date Time Opponent Location Home/Away Sunday, September 11, 2016 1:00 PM Baltimore Ravens M&T Bank Stadium Away Sunday, September 18, 2016 4:00 PM Detroit Lions Bay City Arena Home Monday, September 26, 2016 9:00 PM Cleveland Browns First Energy Stadium Away 4:00 PM Pittsburgh Steelers Bay City Arena Home Sunday, October 2, 2016 4:00 PM New England Patriots Gillette Stadium Away Sunday, October 9, 2016 1:00 PM Washington Redskins Bay City Arena Home Sunday, October 16, 2016 9:00 PM New York Jets Metlife Stadium Away Monday, October 24, 2016 9:00 PM Denver Broncos Bay City Arena Home Monday, October 31, 2016 4:00 PM San Franscisco 49ers Levi's Stadium Away Sunday, November 6, 2016 1:00 PM Green Bay Packers Bay City Arena Home Sunday, November 13, 2016 LA Strikers 2016 Season Schedule Date Time Opponent Location Home/Away Friday, May 6, 2016 7:00 PM Boston Breakers San Marino Stadium Home Saturday, May 14, 2016 5:00 PM Chicago Red Stars Toyota Park Away Saturday, May 21, 2016 5:00 PM Houston Dash BBVA Compass Stadium Away Thursday, May 26, 2016 4:00 PM FC Kansas City San Marino Stadium Home Saturday, June 4, 2016 8:00 PM Portland Thorns Providence Park Away Wednesday, June 8, 2016 9:00 PM Washington Spirit San Marino Stadium Home Saturday, June 18, 2016 7:00 PM Western New York Flash Sahlen's Stadium Away Friday, June 24, 2016 4:00 PM Seattle Reign FC San Marino Stadium Home Saturday, July 2, 2016 4:00 PM Sky Blue FC Yurcak Field Away Wednesday, July 6, 2016 7:00 PM Atlanta Beat San Marino Stadium Home Use Ryan and Allie’s schedules as a guide to help create your own. Do not duplicate their work. THE DREAM TEAM 47

2Spreadsheets Travel Expenses Budgeting Team Travel Expenses Your Goal Instructions An exciting part of managing a sports franchise is Download and complete the SS-2 Planning getting the opportunity to travel. Playing games Form from The Dream Team section of in different places is fun, but there are going to be www.mycompanionsite.com. costs involved. A spreadsheet can assist in budgeting travel expenses for your team. Using formulas in 1. Create a new spreadsheet file. the spreadsheet makes easy work of mathematical 2. Name the workbook SS-2 Travel Expenses and calculations. In this project, you will create a spreadsheet with save it to The Dream Team folder. formulas that contains the destinations of five away Refer to the spreadsheets provided by Ryan and Allie for games along with realistic estimates of the costs of assistance. Do not copy the content of the samples. airline tickets and hotel rooms. 3. In cell A1, enter the title <Your Team Name> Estimated <Year> Travel Budget. SKILLS UTILIZED 4. Merge and center cell A1 across cells A1 – M1 and Use spreadsheet software to estimate the travel change the font size to 18 point. expenses for your dream team’s away games. 5. In cells A3 – M4, enter the column headings with center alignment and bold as shown in Tactics Figure SS-2. Note: Adjust row heights and column widths as needed so that all data displays zz Use a travel website, such as tripadvisor.com to properly. find realistic prices of airline tickets and hotel 6. Format columns A, B, and C as dates that show rooms. mm/dd/yyyy. 7. Format columns F, H, K, L, and M to show the “$” zz Use the information from your team schedule for symbol and two decimal places. five of your team’s away games. 8. Using your completed SS-2 Planning Form, key your away game travel information into the zz Locate the closest airport to the stadium, arena, or spreadsheet. field that you are playing. 9. Enter a formula in cell J5 to compute the # of Nights the team will be away. This is computed zz The use of formulas in a spreadsheet turns by subtracting the Departure Date from the the workbook into a “What If” analysis tool. Return Date. Data can be changed and computed totals will Hint: C5-B5 automatically be updated. 10. Copy the formula entered in cell J5 and paste it into the remaining cells in that column for each zz Read through all instructions before proceeding away game. with this project. 11. Enter a formula in cell K5 to compute the Total Flight Costs. This is computed by multiplying the zz Review the “In the Zone” section for guidance Price Per Airline Ticket by the # of Players. when completing this project. Hint: F5*I5 48 THE DREAM TEAM

Travel Expenses (continued) 2 12. Copy the formula entered in cell K5 and paste it into the remaining cells in that column for each Spreadsheets Travel Expenses away game. 13. Enter a formula in cell L5 to compute the Total Hotel Costs. This is computed by multiplying the Price Per Hotel Room by the # of Players and then by the # of Nights. Hint: H5*I5*J5 14. Copy the formula entered in cell L5 and paste it into the remaining cells in that column for each away game. 15. Enter a formula in cell M5 to compute the Total Flight + Hotel. This is computed by adding the Total Flight Costs and the Total Hotel Costs. Hint: K5+L5 16. Copy the formula entered in cell M5 and paste it into the remaining cells in that column for each away game. 17. Below the last cell that contains data in column J, enter the word “TOTALS” in bold and right aligned. 18. Below the last cell that contains data in column K, enter a formula to compute the Total Flight Costs and format to bold. Hint: Use the SUM formula 19. Below the last cell that contains data in column L, enter a formula to compute the Total Hotel Costs and format to bold. Hint: Use the SUM formula 20. Below the last cell that contains data in column M, enter a formula to compute the Total Flight + Hotel and format to bold. Hint: Use the SUM formula 21. Display the spreadsheet with gridlines, change the orientation to landscape, and fit to one page. 22. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 23. Submit the spreadsheet as required by your instructor. THE DREAM TEAM 49

2 Figure SS-2 AB C D E F GH IJ K L M 1 <Your Team Name> Estimated <Year> Travel Budget Spreadsheets Travel Expenses 2 3 Game Departure Return Destination Nearest Price Per Nearest Price Per # of # of Total Total Total 4 Date Date Date Stadium Airport Airline Ticket Hotel Hotel Room Players Nights Flight Costs Hotel Costs Flight + Hotel 5 6 7 8 9 10 11 12 13 14 15 16 17 18 50 THE DREAM TEAM

IN THE Ryan and Allie have prepared very detailed and organized 2 spreadsheets that show typical travel expenses their teams will ZONE incur when playing away games. Formulas were used so that the ticket prices and hotel prices could be updated easily and total costs would be automatically recalculated. The budgets that Ryan and Allie created are shown below. Bay City Boltz Estimated 2016 Travel Budget Game Departure Return Destination Nearest Price Per Nearest Price Per # of # of Total Total Total Spreadsheets Travel Expenses Date Date Date Stadium Airport Airline Ticket Hotel Hotel Room Players Nights Flight Costs Hotel Costs Flight + Hotel 9/11/2016 9/7/2016 9/12/2016 M&T Bank Stadium BWI $356.20 Pier 5 Hotel $207.00 22 5 $7,836.40 $22,770.00 $30,606.40 9/26/2016 9/23/2016 9/27/2016 First Energy Stadium CLE $192.20 Hyatt Regency $167.00 22 4 $4,228.40 $14,696.00 $18,924.40 10/9/2016 10/6/2016 10/10/2016 Gillette Stadium BOS $313.57 Seaport Boston $369.00 22 4 $6,898.54 $32,472.00 $39,370.54 10/24/2016 10/21/2016 10/25/2016 Metlife Stadium LGA $299.56 Radisson $130.00 22 4 $6,590.32 $11,440.00 $18,030.32 11/6/2016 11/3/2016 11/7/2016 Levi's Stadium SFO $403.23 Marriott $127.00 22 4 $8,871.06 $11,176.00 $20,047.06 TOTALS $34,424.72 $92,554.00 $126,978.72 LA Strikers Estimated 2016 Travel Budget Game Departure Return Destination Nearest Price Per Nearest Price Per # of # of Total Total Total Date Date Date Stadium Airport Airline Ticket Hotel Hotel Room Players Nights Flight Costs Hotel Costs Flight + Hotel 5/14/2016 5/11/2016 5/15/2016 Toyota Park ORD $259.70 Holiday Inn Chicago $170.00 21 4 $5,453.70 $14,280.00 $19,733.70 5/21/2016 5/18/2016 5/22/2016 BBVA Compass Stadium IAH $313.40 Magnolia Hotel Houston $245.00 21 4 $6,581.40 $20,580.00 $27,161.40 6/4/2016 6/1/2016 6/5/2016 Providence Park PDX $222.20 Hotel deLuxe $233.00 21 4 $4,666.20 $19,572.00 $24,238.20 6/18/2016 6/17/2016 6/19/2016 Sahlen's Stadium ROC $481.20 Hyatt Regency $87.00 21 2 $10,105.20 $3,654.00 $13,759.20 7/2/2016 6/30/2016 7/5/2016 Yurcak Field EWR $376.20 Radisson $130.00 21 5 $7,900.20 $13,650.00 $21,550.20 TOTALS $34,706.70 $71,736.00 $106,442.70 Use Ryan and Allie’s travel expenses as a guide to help create your own. Do not duplicate their work. THE DREAM TEAM 51

3Spreadsheets Salary Sheet Calculating the Average Player Salary Your Goal Instructions Many organizations offer their employees a 1. Create a new spreadsheet file. competitive salary that will attract, retain, and 2. Name the workbook SS-3 Salary Sheet and save motivate. No successful company wants to lose out on an outstanding staff member to a competitor. it to The Dream Team folder. Your players have been chosen because of their great Refer to the spreadsheets provided by Ryan and Allie for athletic abilities and knowing what other teams could assistance. Do not copy the content of the samples. offer them in terms of pay is critical in managing the 3. Open the file WP-1 Team Roster Table that you team. previously completed. In this project, you will create a spreadsheet to find 4. Copy the column headings and data for player’s the average salary for the players on your team. first name, last name, and position from your SKILLS UTILIZED WP-1 Team Roster Table. Note: You will sort the Use spreadsheet software to compute the average table later in this activity, so it does not matter salary of your team. which table you copy from. 5. Paste the data into your SS-3 Salary Sheet file. Tactics Note: Adjust row heights and column widths as needed so that all data displays properly. zz Use the Internet to research players’ salaries in 6. Insert a row above the column headings and your particular sport. enter the title Average Salary. 7. Merge and center cell A1 across cells A1 – D1 and zz Format currency with the “$” symbol and two bold. decimal places. 8. Delete the row that contains the coach or manager. zz Sorting a spreadsheet allows you to see your data 9. In column D, enter a salary for each player using in various ways. amounts that are relevant to today’s salaries in your particular sport. zz Read through all instructions before proceeding 10. Format column D to show the “$” symbol and two with this project. decimal places. 11. Sort the spreadsheet alphabetically by Position. zz Review the “In the Zone” section for guidance 12. Below the last cell that contains data in column C, when completing this project. enter the text “Average Salary”. 13. Below the last cell that contains data in column 52 THE DREAM TEAM D, enter a formula to compute the average salary of all players. Hint: Use the AVERAGE formula 14. Display the spreadsheet with gridlines. 15. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 16. Submit the spreadsheet as required by your instructor.

IN THE FIRST NAME LAST NAME Average Salary SALARY 3 Jim Ringo POSITION ZONE Aeneas Williams Center $818,000.00 Spreadsheets Salary Sheet Deion Sanders Def. Back $720,000.00 Ryan and Allie want to Joe Greene Def. Back $986,000.00 compensate their players with Michael Strahan Def. Lineman $910,000.00 fair and competitive salaries. Randy White Def. Lineman $987,000.00 Therefore, both owners stayed Gene Upshaw Def. Lineman $835,000.00 current with what other players Mike Munchak Guard $618,000.00 in their sport had the potential Jan Stenerud Guard $545,000.00 to earn. The information was Dick Butkus Kicker $850,000.00 presented in an orderly way by Junior Seau Linebacker $814,000.00 using a spreadsheet to sort the Mike Singletary Linebacker $525,000.00 list of players and calculate the Ray Guy Linebacker $578,000.00 average salary. The average salary Tom Brady Punter $710,000.00 spreadsheets that Ryan and Allie Jerry Rice Quarterback $995,000.00 created are shown. John Stallworth Receiver $1,140,000.00 Barry Sanders Receiver $1,500,000.00 Use Ryan and Allie’s salary Walter Payton Running Back $1,000,150.00 sheets as a guide to help Art Shell Running Back $756,000.00 create your own. Do not Dan Dierdorf Tackle $510,000.00 duplicate their work. Mike Ditka Tackle $745,000.00 Tight End $965,000.00 Average Salary $833,673.81 FIRST NAME LAST NAME Average Salary SALARY Whitney Engen POSITION Nilla Fischer Defender $63,000.00 Amy LePeilbet Defender $65,000.00 Becky Sauerbrunn Defender $62,000.00 Bianca Schmidt Defender $60,000.00 Sara Thunebro Defender $65,000.00 Sydney Leroux Defender $64,000.00 Anja Mittag Forward $92,500.00 Alex Morgan Forward $90,000.00 Lotta Schelin Forward $200,000.00 Marta Vieira da Silva Forward $250,000.00 Abby Wambach Forward $400,000.00 Nadine Angerer Forward $300,000.00 Hope Solo Goalkeeper $90,000.00 Veronica Boquete Goalkeeper $65,000.00 Nahomi Kawasumi Midfielder $80,000.00 Nadine Kessler Midfielder $70,000.00 Carli Lloyd Midfielder $75,000.00 Dzsenifer Marozsán Midfielder $85,000.00 Homare Sawa Midfielder $80,000.00 Midfielder $75,000.00 Average Salary $116,575.00 THE DREAM TEAM 53

4Spreadsheets Promotional Calendar Generating Promotional Events Your Goal Instructions As owner of your team, you are responsible for Download and complete the SS-4 Planning keeping players and fans happy. You also want to Form from The Dream Team section of develop a strong fan base and sell out every event— www.mycompanionsite.com. two main objectives for any entertainment or sports franchise. You can give people a reason to come to an 1. Create a new spreadsheet file. event with a promotion or incentive. Giveaways and 2. Name the workbook SS-4 Promotional contests are one way to do this. They can be updated in creative ways that reflect the interests of your Calendar and save it to The Dream Team folder. target market. Include endorsed products in your Refer to the spreadsheets provided by Ryan and Allie for promotion, since those companies would be more assistance. Do not copy the content of the samples. than willing to showcase their items and get noticed 3. In cells A1 – E1, enter the dates of five of your by your fans. home games as column headings. Be sure your In this project, you will create a spreadsheet that lists dates show the day of the week, month, date, and five home game promotions for the season. year. Note: Adjust row heights and column widths SKILLS UTILIZED as needed so that all data displays properly. Use spreadsheet software to organize a schedule of 4. Insert a row above the dates and enter the title unique game promotions. <Your Team Name> Home Game Promotional Schedule. Tactics 5. Merge and center cell A1 across cells A1 – E1 and change the font size to 18 point. zz Use the Internet to research sports marketing 6. Using your completed SS-4 Planning Form, key promotion ideas. your game promotion information into row 3. Include the promotion name, a hyphen, then the zz Incorporate the product your team has chosen to brief description of the promotion. endorse into your promotion schedule. 7. Format row 3 with text wrapping. Do not resize the columns in row 3 to be any wider than the zz Resize columns and rows so that your spreadsheet dates in row 2. looks like a traditional calendar. 8. Insert a narrow column between each date so that the spreadsheet is visually appealing. zz Read through all instructions before proceeding 9. Shade cells A2 – I2 with the color of your choice. with this project. 10. Format the title and column headings with an appropriate font style and color. zz Review the “In the Zone” section for guidance 11. Display the spreadsheet with gridlines, change when completing this project. the orientation to landscape, and fit to one page. 12. Carefully proofread your work for accuracy, 54 THE DREAM TEAM format, spelling, and grammar, then resave. 13. Submit the spreadsheet as required by your instructor.

IN THE Ryan and Allie wanted their home games to be sold out each 4 time. They both planned unique and exciting promotions to ZONE fill their stadium seats at every game. Each owner knew that their fans would love to win something, meet a player, see a celebrity, and take home free merchandise. The promotional calendars that Ryan and Allie created are shown below. Bay City Boltz Home Game Promotional Schedule Sunday, September 18, 2016 Sunday, October 2, 2016 Sunday, October 16, 2016 Monday, October 31, 2016 Sunday, November 13, 2016 Spreadsheets Promotional Calendar Jay-Z Night - Jay-Z will perform Flashlight Night - Attendees Zip Energy Bar Night - Halloween Meet and Greet - Team Baby Picture Contest - Fans immediately after the game. will receive a team flashlight Attendees will receive two All members of the Bay City who correctly match the player to his Winners from the most recent with the Bay City Boltz logo. Zip Energy Bars upon Boltz will be signing baby picture are eligible to win WJMZ radio station contest are All attendees are eligible entrance to the game. All are autographs for any fan who season tickets to next year’s season. asked to show their tickets in while supplies last. eligible. shows up to the game in a Twenty random winners from correct order to watch Jay-Z perform. costume. entries will be chosen at the game. Entry forms will be available upon entrance to the game. LA Strikers Home Game Promotional Schedule Friday, May 6, 2016 Thursday, May 26, 2016 Wednesday, June 8, 2016 Friday, June 24, 2016 Wednesday, July 6, 2016 Paramount Springs Bottled Taylor Swift Night - Taylor Cool Splash Water Park Team Meet and Greet - All Cushion Night - Fans will Water Night - Attendees will Swift will perform Night - Fans who attend this members of the LA Strikers receive a team logo stadium receive one bottle of immediately after the game. game have the chance to will be signing autographs seat cushion. All attendees Paramount Springs Bottled Winners from the most win a family pack of tickets for recent high school or are eligible while supplies Water upon entrance to the recent WKSS radio station to Cool Splash Water Park. college graduates before last. game. Everyone is eligible. contest are asked to show All attendees of this game tonight’s game. Just show a their tickets in order to will be entered to win. copy of your diploma to watch Taylor perform. Twenty randomly chosen meet the team. winners will be announced at half-time during the game. Use Ryan and Allie’s promotional calendars as a guide to help create your own. Do not duplicate their work. THE DREAM TEAM 55

5Spreadsheets Merchandise Inventory Managing Gift Shop Merchandise Inventory Your Goal Instructions Managing a retail store can be a tricky business. Download and complete the SS-5 Planning Besides staffing and displaying merchandise in an Form from The Dream Team section of attractive way, managers need to keep a close eye on www.mycompanionsite.com. the inventory of the items they sell. Checking current stock and analyzing trends in sales is necessary when 1. Create a new spreadsheet file. making decisions about purchasing items to sell to 2. Name the workbook SS-5 Merchandise customers. In this project, you will choose 20 items to stock in Inventory and save it to The Dream Team folder. your dream team gift shop and use a spreadsheet to Refer to the spreadsheets provided by Ryan and Allie for calculate estimated costs based on current selling assistance. Do not copy the content of the samples. prices. 3. In cell A1, enter the title <Your Team Name> Gift Shop Merchandise Inventory. SKILLS UTILIZED 4. Merge and center cell A1 across cells A1 – H1 and Use spreadsheet software to organize a list of change the font size to 18 point. merchandise inventory you selected for your 5. In cells A2 – H2, enter the following column dream team gift shop. headings: On Hand Quantity, Item Name, Category, Markup Percent, Selling Price, Cost, Tactics Profit, Inventory Value. Note: Adjust row heights and column widths as needed so that all data zz The cost of a product is the amount of money the displays properly. retailer pays for a product. 6. Bold the column headings. 7. Format column D to show the “%” symbol with zz The selling price of a product is the amount of zero decimal places. money the customer pays for a product. 8. Format columns E – H to show the “$” symbol and two decimal places. zz Standard markup percentages, or the increase to 9. Using your completed SS-5 Planning Form, key the cost that determines the selling price, vary your merchandise inventory information into the from category to category but are the same in spreadsheet. similar categories. For example, clothing typically 10. Enter a formula in cell F3 to compute the Cost. has a markup of 60%. This is computed by multiplying the Selling Price by the complement of the Markup Percent. zz Use the Internet to find typical items found in Hint: E3*(100%-D3) most sports team gift shops along with their 11. Copy the formula entered in cell F3 and paste it current selling prices. into the remaining cells in that column for each item. zz Read through all instructions before proceeding with this project. zz Review the “In the Zone” section for guidance when completing this project. 56 THE DREAM TEAM

Merchandise Inventory (continued) 5 12. Enter a formula in cell G3 to compute the Profit. This is computed by subtracting the Cost from the Spreadsheets Merchandise Inventory Selling Price. Hint: E3-F3 13. Copy the formula entered in cell G3 and paste it into the remaining cells in that column for each item. 14. Enter a formula in cell H3 to compute the Inventory Value. This is computed by multiplying the On Hand Quantity by the Cost. Hint: A3*F3 15. Copy the formula entered in cell H3 and paste it into the remaining cells in that column for each item. 16. Below the last cell that contains data in column G, enter the text “Total” right aligned and bold. 17. Below the last cell that contains data in column H, enter a formula to compute the Total Inventory Value. Hint: Use the SUM formula 18. Display the spreadsheet with gridlines, change the orientation to landscape, and fit to one page. 19. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 20. Submit the spreadsheet as required by your instructor. THE DREAM TEAM 57

5 IN THE Ryan and Allie had fun stocking the shelves of their team’s gift shop. The owners acted as fans themselves and tried to think ZONE of cool merchandise that people would want to buy. Both were amazed at the variety of products that could be adorned with a team logo. The inventories that Ryan and Allie organized are shown below. Bay City Boltz Gift Shop Merchandise Inventory On Hand Quantity Item Name Category Markup Percent Selling Price Cost Profit Inventory Value $16.77 75 Women's T-Shirt - Gray clothing 60% $27.95 $11.18 $10.19 $838.50 $20.97 $169.90 Spreadsheets Merchandise Inventory 25 Women's Sleeveless Tank - Black clothing 60% $16.99 $6.80 $20.97 $1,398.00 $349.50 100 Men's Long Sleeve T-Shirt - Black clothing 60% $34.95 $13.98 $7.77 $518.00 $3.48 $808.44 25 Men's Long Sleeve Hoodie - Blue clothing 60% $34.95 $13.98 $5.23 $485.88 $5.93 $275.44 100 Infant Onesie - Gray clothing 60% $12.95 $5.18 $69.98 $1,299.68 $1.05 $291.53 125 Ceramic Coffee Mug housewares 35% $9.95 $6.47 $5.47 $111.94 $13.72 $1,122.75 50 Large Cooler housewares 35% $14.95 $9.72 $8.22 $100.91 $10.97 $224.44 25 Night Light housewares 35% $16.95 $11.02 $19.22 $471.83 $20.97 $1,347.75 10 Hard Case Suitcase housewares 35% $199.95 $129.97 $20.97 $628.95 $12.59 $269.85 150 Reusable Grocery Bag housewares 35% $2.99 $1.94 $20.99 $899.70 $39.17 $167.85 25 Player Bobblehead toys 55% $9.95 $4.48 Total $11,780.81 100 Stuffed Plush Mascot toys 55% $24.95 $11.23 15 Super Hero Cape toys 55% $14.95 $6.73 25 Plush Player Stuffed Animal toys 55% $19.95 $8.98 30 Football toys 55% $34.95 $15.73 150 Tablet Sleeve miscellaneous 70% $29.95 $8.99 70 Sunglasses miscellaneous 70% $29.95 $8.99 50 Money Clip and Keychain Set miscellaneous 70% $17.99 $5.40 100 Cell Phone Case miscellaneous 70% $29.99 $9.00 10 Fold-Up Seat miscellaneous 70% $55.95 $16.79 LA Strikers Gift Shop Merchandise Inventory On Hand Quantity Item Name Category Markup Percent Selling Price Cost Profit Inventory Value 50 Women's Nike Stadium Fan Top - White Clothing 60% $41.95 $16.78 $25.17 $839.00 50 Women's Tank Top - Navy Clothing 60% $33.95 $13.58 $20.37 $679.00 25 Men's Long Sleeve T-Shirt - Black Clothing 60% $34.95 $13.98 $20.97 $349.50 25 Men's Long Sleeve Hoodie - White Clothing 60% $34.95 $13.98 $20.97 $349.50 100 Toddler Short Sleeve Shirt - Pink Clothing 60% $17.95 $7.18 $10.77 $718.00 25 Collapsible Lunch Cooler Housewares 35% $11.95 $7.77 $4.18 $194.19 75 Ceramic Coffee Mug Housewares 35% $9.95 $6.47 $3.48 $485.06 10 Picnic Basket Housewares 35% $45.95 $29.87 $16.08 $298.68 25 Logo Toaster Housewares 35% $39.95 $25.97 $13.98 $649.19 40 Chef's Apron Housewares 35% $34.95 $22.72 $12.23 $908.70 25 Player Bobble Head Toys 55% $9.95 $4.48 $5.47 $111.94 100 Stuffed Plush Mascot Toys 55% $24.95 $11.23 $13.72 $1,122.75 15 1000 Piece Puzzle of Stadium Toys 55% $16.99 $7.65 $9.34 $114.68 15 Toy Train Toys 55% $74.95 $33.73 $41.22 $505.91 30 13\" Action Figure of Star Player Toys 55% $19.99 $9.00 $10.99 $269.87 150 Cell Phone Case Miscellaneous 70% $29.99 $9.00 $20.99 $1,349.55 70 Golf Umbrella Miscellaneous 70% $39.99 $12.00 $27.99 $839.79 50 Money Clip and Keychain Set Miscellaneous 70% $17.99 $5.40 $12.59 $269.85 100 Stadium Seat Cushion Miscellaneous 70% $11.99 $3.60 $8.39 $359.70 10 Wireless Headphones Miscellaneous 70% $379.99 $114.00 $265.99 $1,139.97 Total $11,554.82 Use Ryan and Allie’s inventory spreadsheets as a guide to help create your own. Do not duplicate their work. 58



6Spreadsheets Ticket Sales Analysis Comparing Ticket Sales Revenue Your Goal Instructions A picture is worth a thousand words, and that Download and complete the SS-6 Planning certainly holds true in business. Analyzing data in the Form from The Dream Team section of form of a chart is quicker, easier, and can sometimes www.mycompanionsite.com. show things more clearly than just numbers. Making projections and analyzing potential revenue (sales) 1. Create a new spreadsheet file. is a critical part of budgeting. When actual revenue is 2. Name the workbook SS-6 Ticket Sales Analysis reported, managers can compare the spreadsheets to see how well a product is performing. and save it to The Dream Team folder. In this project, you will create a spreadsheet to Refer to the samples provided by Ryan and Allie for project the revenue that your team has the potential assistance. Do not copy the content or design of the to receive from ticket sales. A column chart will be samples. used to illustrate the differences in various sections 3. In cell A1, enter the title <Your Team Name> of the stadium. Projected Ticket Sales Revenue. 4. Merge and center cell A1 across cells A1 – E1 and SKILLS UTILIZED change the font size to 18 point. Use spreadsheet software to compare ticket sales 5. In cell A2, enter the text “based on a stadium revenue from various sections of your dream team seating capacity of 60,000.” stadium. 6. Merge and center cell A2 across cells A2 – E2 and shade it gray. Tactics 7. In cells A3 – E3, enter the following column headings: Section Name, Price, # of Seats zz Column charts are used to compare sets of data, Available, # of Home Games, Total Projected whereas pie charts show the relationship of a part Sales. Note: Adjust row heights and column to a whole. widths as needed so that all data displays properly. zz Format your chart with various colors to make it 8. Underline and bold column headings. appealing to look at and easy to read. 9. Format columns B and E to show the “$” symbol and two decimal places. zz Images can be inserted into spreadsheet files just 10. Format column C with a comma separator. as they would in a word processing document. 11. Using your completed SS-6 Planning Form, key your projected stadium ticket sales information zz Read through all instructions before proceeding into the spreadsheet. with this project. 12. Enter a formula in cell E4 to compute the Total Projected Sales. This is computed by multiplying zz Review the “In the Zone” section for guidance the Price by the # of Seats Available and then by when completing this project. the # of Home Games. Hint: B4*C4*D4 60 THE DREAM TEAM

Ticket Sales Analysis (continued) 6 13. Copy the formula entered in cell E4 and paste it into the remaining cells in that column for each Spreadsheets Ticket Sales Analysis section. 14. Apply a bottom border to your last row of data. 15. Below the last cell that contains data in column B, enter the text “Total Seats” right aligned and bold. 16. Below the last cell that contains data in column C, enter a formula to compute the Total # of Seats Available. Hint: Use the SUM formula 17. Below the last cell that contains data in column D, enter the text “Total Projected Sales” right aligned and bold. 18. Below the last cell that contains data in column E, enter a formula to compute the Total Projected Sales for all sections. Hint: Use the SUM formula 19. To the right of your data, insert the image you saved of your stadium map. Position and resize the image so that no data is covered. 20. Create a column chart to show the comparison of seating sections and their total projected sales. Hint: To select the section names in column A and the corresponding projected sales in column E, hold down the Control Key. 21. Title the chart “Projected Ticket Sales by Section.” 22. Format the chart so that it is easy to read by changing the color of each column (if available), displaying data labels above each column, and showing a legend somewhere on the chart. 23. Position your chart below your data. Hint: Be sure all data is visible. 24. Display the spreadsheet without gridlines and change the orientation to landscape. 25. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 26. Submit the spreadsheet as required by your instructor. THE DREAM TEAM 61

6 IN THE Knowing the potential revenue from ticket sales really helped Ryan and Allie plan for team expenses as well as make ZONE necessary decisions about the stadium. Both owners were hopeful that they would sell out home games and achieve their projected revenue goals. The spreadsheets and charts Ryan and Allie created for ticket sales are shown below. Bay City Boltz Projected Ticket Sales Revenue Spreadsheets Ticket Sales Analysis based on a stadium seating capacity of 60,000 Section Name Price # of Seats Available # of Home Games Total Projected Sales Top Middle $19.00 15,000 5 $1,425,000.00 Bottom Elite $22.50 15,000 5 $337,500.00 $40.50 20,000 5 $810,000.00 $65.00 10,000 5 $650,000.00 Total Seats 60,000 Total Projected Sales $3,222,500.00 $1,600,000.00 Projected Ticket Sales by Section $1,400,000.00 $1,200,000.00 $1,425,000.00 $1,000,000.00 $810,000.00 $650,000.00 $800,000.00 $337,500.00 Elite $600,000.00 $400,000.00 $200,000.00 $0.00 Top Middle Bottom LA Strikers Projected Ticket Sales Revenue based on a stadium seating capacity of 60,000 Section Name Price # of Seats Available # of Home Games Total Projected Sales Upper Zone Middle Zone $25.00 25,000 5 $3,125,000.00 Lower Zone VIP $35.00 25,000 5 $875,000.00 $50.00 6,000 5 $300,000.00 $75.00 4,000 5 $300,000.00 Total Seats 60,000 Total Projected Sales $4,600,000.00 $3,500,000.00 Projected Ticket Sales by Section $3,000,000.00 $2,500,000.00 $3,125,000.00 $2,000,000.00 $1,500,000.00 $875,000.00 $300,000.00 $300,000.00 $1,000,000.00 Middle Zone Lower Zone VIP $500,000.00 $0.00 Upper Zone Use Ryan and Allie’s ticket sales spreadsheets as a guide to help create your own. Do not duplicate their work. 62

Digital ZONE 3 Publishing Game Plan Promoting your dream team In this section, you will use digital publishing software to create and design professional marketing documents to promote your new dream team. DP-1 Banner Stand Design 64 Equipment List DP-2 Selfie Promo  68 DP-3 Cell Phone Case 72 • Project Planning Forms DP-4 Admission Ticket 76 • Digital Publishing DP-5 Team Program 80 Software THE DREAM TEAM 63

1Digital Publishing Banner Stand Design Marketing Your Team to the Public Your Goal Instructions Your dream team and games need to be promoted Download and complete the DP-1 Planning wherever they can. Fortunately, other entertainment Form from The Dream Team section of events, such as a summer music festival, attract the www.mycompanionsite.com. same people who might come to a game. Trade shows and festivals offer promotional booth space 1. Create a new digital publishing file. for vendors and organizations to display their 2. Name the document DP-1 Banner Stand Design products and services, or to promote their own events. To attract the attention of a passerby, a large and save it to The Dream Team folder. vinyl banner can be displayed at the booth. Full color 3. Set up your document using the Page Setup banner stands can be made in extremely large sizes, such as 17 feet tall, and make a big impression. The instructions provided on the next page. banner stand typically contains a company logo Review the banner stand designs created by Ryan and and may also announce giveaways to generate fan Allie to get inspiration and ideas for designing your excitement. own. Remember: Use your own creativity and design In this project, you will design a banner stand to skills. Do not copy Ryan or Allie’s banner stands. attract fans, maintain a presence in the market, and 4. In the bordered frame, create the banner stand announce a giveaway. design from the sketch on your completed DP-1 Planning Form. SKILLS UTILIZED 5. Format and size the placement of the text and Use digital publishing software to create a banner other elements on the banner stand so that they stand design. are in proportion with each other and project a professional image. Tactics 6. Add additional text and/or graphic elements to help enhance the overall look and design of your zz Your banner stand must grab the audience’s banner stand. attention with an easy-to-read, dominant 7. Carefully proofread your work for design, format, message. spelling, and grammar, then resave. 8. Submit the document as required by your zz Your message and team logo should be the two instructor. most prominent elements on the banner stand. zz Use a maximum of two fonts on your banner stand. zz Read through all instructions before proceeding with this project. zz Review the “In the Zone” section for guidance when completing this project. 64 THE DREAM TEAM

Page Setup 1 # of pages 1 Other Dimensions 8.5 x 11 inches Using the rectangle tool in your digital publishing software, draw a rectangle that measures 5 inches wide by 7 inches tall. Place the Margins .5 inches on all sides rectangle in the center of the page, and place the contents of your banner stand design within this rectangle. Orientation Portrait 8.5” 11” 5” Digital Publishing Banner Stand Design 7” Place the contents of your banner stand design here. THE DREAM TEAM 65

Digital Publishing Banner Stand Design To attract the attention of her team’s fans, Allie created a well- 1 IN THE designed promotional banner stand. Using colors similar to her team logo and an easy-to-read, dominant message made her ZONE banner stand easily recognizable to her team’s fans. Use Allie’s banner stand as a guide to help create your own. Do not duplicate her work. 66 THE DREAM TEAM

IN THE Ryan wanted to catch the eye of his team’s fans and attract new 1 fans as well with an oversized banner stand. His plans were ZONE to use the banner stand at festivals, meet and greets, and any other off-site promotional events his team took part in. The banner stand design that Ryan created is shown below. Use Ryan’s banner stand as Digital Publishing Banner Stand Design a guide to help create your own. Do not duplicate his work. THE DREAM TEAM 67

2Digital Publishing Selfie Promo Announcing a Fan Event Instructions Your Goal Download and complete the DP-2 Planning Form from The Dream Team section of One of the fastest growing marketing tools being www.mycompanionsite.com. used today is social media, where potential customers (and fans) can be exposed to your 1. Create a new digital publishing file. organization via current customers (and fans). It is 2. Name the document DP-2 Selfie Promo and the word-of-mouth of the 21st century when a loyal customer posts a photo of themselves with your save it to The Dream Team folder. product. Your dream team will hold an event where 3. Set up your document using the Page Setup fans can take a selfie with a life-sized cutout of their favorite athlete on your team and then hopefully post instructions provided on the next page. their selfie to various social media sites. To launch Review the poster designs created by Ryan and Allie this promo, posters will be displayed throughout the to get inspiration and ideas for designing your own. stadium and in various places around the community. Remember: Use your own creativity and design skills. In this project, you will design your team’s poster that Do not copy Ryan or Allie’s posters. announces a selfie promo at your stadium. 4. In the bordered frame, create your poster design from the sketch on your completed DP-2 SKILLS UTILIZED Planning Form. Use digital publishing software to create a poster 5. Format and size the placement of text and announcing a fan event. other elements on the poster so that they are in proportion with each other and project a Tactics professional image. 6. Add additional text and/or graphic elements to zz Your poster should have a direct, easy to read help enhance the overall look and design of your message. poster. 7. Carefully proofread your work for design, format, zz Create a hierarchy of font sizes so that your most spelling, and grammar, then resave. important text is the largest. 8. Submit the document as required by your instructor. zz Use high quality graphics with a similar style, such as all photographs or all cartoons. zz Consider using highly recognized social media icons in your design and encourage fans to post their pictures. zz Read through all instructions before proceeding with this project. zz Review the “In the Zone” section for guidance when completing this project. 68 THE DREAM TEAM

Page Setup 2 # of pages 1 Other Dimensions 8.5 x 11 inches Using the rectangle tool in your digital publishing software, draw a rectangle that measures 8 inches wide by 10.5 inches tall. Place Margins .25 inches on all sides the rectangle in the center of the page, and place the contents of your poster within this rectangle. Orientation Portrait 8.5” 11” 8” Digital Publishing Selfie Promo 10.5” Place the contents of your poster here. THE DREAM TEAM 69

Digital Publishing Selfie Promo When fans tag your team in social media posts, it’s like free 2 IN THE advertising. Giving them an opportunity to snap a picture with their favorite player’s likeness is unique and fun. Allie hoped that the selfie promotion would create a social media buzz ZONE for existing and new fans. The selfie promo poster that Allie designed to announce the event is shown below. Use Allie’s selfie promo poster as a guide to help create your own. Do not duplicate her work. 70 THE DREAM TEAM

IN THE Announcing the selfie promo with a high-quality, dominant 2 image made Ryan’s poster very effective in promoting this ZONE popular event. The selfie promo poster that Ryan designed to announce the event is shown below. Digital Publishing Selfie Promo Use Ryan’s selfie promo poster as a guide to help create your own. Do not duplicate his work. THE DREAM TEAM 71

3Digital Publishing Cell Phone Case Designing a Smartphone Accessory Your Goal Instructions There is no arguing that people of all ages love Download and complete the DP-3 Planning their smartphones. Trends show that smartphone Form from The Dream Team section of ownership continues to increase, and with every www.mycompanionsite.com. smartphone comes the need to protect it. Using a cell phone case not only safeguards the device, but 1. Create a new digital publishing file. the design of the case can be a trendy statement for 2. Name the document DP-3 Cell Phone Case and the person carrying it. Your cell phone case says a lot about you, and many companies offer logo designed save it to The Dream Team folder. cases for those who want to display their brand 3. Set up your document using the Page Setup loyalty. In this project, you will design a dream team cell instructions provided on the next page. phone case to offer to fans. Review the cell phone case designs created by Ryan and Allie to get inspiration and ideas for designing your SKILLS UTILIZED own. Remember: Use your own creativity and design Use digital publishing software to design a cell skills. Do not copy Ryan or Allie’s cell phone cases. phone case. 4. In the bordered frame, create your cell phone case design from the sketch on your completed Tactics DP-3 Planning Form. 5. Format and size the placement of text and other zz The team logo should be the largest image on the elements on the cell phone case so that they case. are in proportion with each other and project a professional image. zz Position your design, taking into consideration the 6. Add additional text and/or graphic elements to cell phone camera opening. help enhance the overall look and design of your cell phone case. zz Read through all instructions before proceeding 7. Carefully proofread your work for design, format, with this project. spelling, and grammar, then resave. 8. Submit the document as required by your zz Review the “In the Zone” section for guidance instructor. when completing this project. 72 THE DREAM TEAM

Page Setup 3 # of pages 1 Other Using the rounded rectangle tool in your digital publishing Dimensions 8.5 x 11 inches software, draw a rectangle with rounded edges that measures 3.25 inches wide by 6.25 inches tall. In the top left corner of the Margins .5 inches on all sides rectangle, draw another rounded rectangle that measures .75 inches wide by .5 inches tall. Group both rectangles together and Orientation Portrait place the object in the center of the page. Place the contents of your cell phone case within this object. 8.5” 11” 3.25” .5” Digital Publishing Cell Phone Case .75” 6.25” Place the contents of your cell phone case here. THE DREAM TEAM 73

Digital Publishing Cell Phone Case Allie’s cell phone case design incorporated her team’s logo and 3 IN THE colors, along with a simple, dominant message that all soccer fans would relate to and recognize. The cell phone case that ZONE Allie designed is shown below. Use Allie’s cell phone case design as a guide to help create your own. Do not duplicate her work. 74 THE DREAM TEAM

IN THE Ryan had his team’s fans in mind when creating his dream team 3 cell phone case. He wanted his case to be eye-catching and ZONE stylish. The team logo and colors became the stand-out graphic on the case so that his fans could show team loyalty. The cell phone case that Ryan designed is shown below. Digital Publishing Cell Phone Case Use Ryan’s cell phone case design as a guide to help create your own. Do not duplicate his work. THE DREAM TEAM 75

4Digital Publishing Admission Ticket Creating an Admission Ticket Your Goal Instructions As the owner of your dream team, you want fans Download and complete the DP-4 Planning to leave the game having made a lasting memory. Form from The Dream Team section of An admission ticket can serve not only as a proof www.mycompanionsite.com. of purchase for a particular seat, but as a piece of memorabilia for the attendee. Clearly, your ticket 1. Create a new digital publishing file. needs particular information, such as the seat 2. Name the document DP-4 Admission Ticket and section, number, and row, as well as the date and time of the game, but an attractive design could save it to The Dream Team folder. make that ticket a collectible and something to hold 3. Set up your document using the Page Setup onto forever. In this project, you will design an admission ticket to instructions provided on the next page. one home game. Review the admission ticket designs created by Ryan and Allie to get inspiration and ideas for designing your SKILLS UTILIZED own. Remember: Use your own creativity and design Use digital publishing software to create an skills. Do not copy Ryan or Allie’s admission ticket. admission ticket to a home game. 4. In the bordered frame, create the admission ticket design from the sketch on your completed Tactics DP-4 Planning Form. 5. Format and size the placement of text and other zz Obtain some samples of real event tickets for elements on the admission ticket so that they inspiration to help you design your own. are in proportion with each other and project a professional image. zz Use your team colors and coordinating fonts that 6. Add additional text and/or graphic elements to are easy to read. help enhance the overall look and design of your admission ticket. zz Consider positioning the logo in an interesting 7. Carefully proofread your work for design, format, way. spelling, and grammar, then resave. 8. Submit the document as required by your zz Use multiple line shapes to create a bar code on instructor. your ticket. zz Read through all instructions before proceeding with this project. zz Review the “In the Zone” section for guidance when completing this project. 76 THE DREAM TEAM

Page Setup 4 # of pages 1 Other Dimensions 8.5 x 11 inches Using the rectangle tool in your digital publishing software, draw a rectangle that measures 5.5 inches wide by 2 inches tall. Place Margins .5 inches on all sides the rectangle in the center of the page, and place the contents of your admission ticket within this rectangle. Orientation Portrait 8.5” 11” 5.5” Digital Publishing Admission Ticket 2” Place the contents of your admission ticket here. THE DREAM TEAM 77

When designing an admission ticket for her team’s fans, Allie’s 4 IN THE goal was to create an easy-to-read, attractive memento that fans would want to keep for years to come. She included her logo and all of the necessary information that fans would need ZONE to easily find their seat. The admission ticket that Allie designed is shown below. Digital Publishing Admission Ticket Home Game LA Strikers VS Seattle Reign FC price www.lastrikers.net 4:00 pm $25.00 100 Main Street • Los Angeles CA 90272 San Marino seat # StadIum 7 Friday, June 24, 2016 seat row 5 Please arrive 15 minutes before start time. Thank you. LA Strikers VS Seattle Reign FC section seat row seat # price section upper row 5 seat 7 $25.00 upper zone zone STRIKERS 100 Main Street • Los Angeles CA 90272 310-555-1234 www.lastrikers.net Use Allie’s admission ticket as a guide to help create your own. Do not duplicate her work. 78 THE DREAM TEAM

IN THE Ryan wanted to provide his fans with a professional, well- 4 designed admission ticket that not only contained all of the ZONE necessary information, but would be something that fans of all ages would have fun collecting through the years. The admission ticket that Ryan designed is shown below. BAY CITY BOLTZ 10|16|16 No refunds or exchanges. vs.section section Digital Publishing Admission Ticket ELrIoTwE Washington Redskins EroLwITE 3seat sea3t Sunday, October 16, 2016 2price pric2e 1:00 pm $65.00 $65.00 www.baycityboltz.com www.baycityboltz.com HOME Bay City Arena 2200 West 39th Street • Bay City, MI • 48708 989-555-1234 Use Ryan’s admission ticket as a guide to help create your own. Do not duplicate his work. THE DREAM TEAM 79

5Digital Publishing Team Program Designing a Team Program Your Goal Instructions A team program typically includes a list of players Download and complete the DP-5 Planning and a schedule of upcoming games. However, this Form from The Dream Team section of booklet-style document should also be designed www.mycompanionsite.com. to highlight your team’s identity and give fans something to look at while waiting for the game to 1. Create a new digital publishing file. begin. Consider it a form of advertising since it will 2. Name the document DP-5 Team Program and include contact information for anyone wishing to purchase tickets for the season or a future game. save it to The Dream Team folder. In this project, you will create a booklet-style team 3. Set up your document using the Page Setup program. instructions provided on the next page. SKILLS UTILIZED Review the team program design created by Allie to Use digital publishing software to create a team get inspiration and ideas for designing your own. program. Remember: Use your own creativity and design skills. Do not copy Allie’s team program. Tactics 4. On the divided pages, create the team program design from the sketch on your completed DP-5 zz Obtain some samples of real team programs for Planning Form. inspiration to help you design your own. 5. Format and size the placement of text and other elements on the team program so that they zz Apply contrast to elements of the page by are in proportion with each other and project a using different font styles or sizes. For example, professional image. headings should be larger than the body of the 6. Add additional text and/or graphic elements to page. help enhance the overall look and design of your team program. zz Be consistent with font styles and sizes among all 7. Carefully proofread your work for design, format, like elements throughout the program. spelling, and grammar, then resave. 8. Submit the document as required by your zz Read through all instructions before proceeding instructor. with this project. zz Review the “In the Zone” section for guidance when completing this project. 80 THE DREAM TEAM

Page Setup 5 # of pages 2 Other Dimensions 8.5 x 11 inches On each page, insert two column guides with a .5 inch gutter (to allow room for folding the program in half ). The program should Margins .25 inches on all sides now be divided into two panels on each page as shown below. Note how the panels are labeled on each side. The contents of Orientation Landscape your program will be placed in their respective panels according to your completed planning form. 11” 8.5” 8.5” Place the contents of your Digital Publishing Team Program team program here. Outside Outside .25” Left Panel .5” Right Panel .25” (Back Cover) (Front Cover) 11” Place the contents of your team program here. Inside Inside .25” Left Panel .5” Right Panel .25” THE DREAM TEAM 81

5 IN THE Allie wanted to capture the attention of her team’s fans and make them excited about attending another game. The Player ZONE Spotlight section varied from game to game and gave the reader a place to learn more about a player. Allie worked hard to design the program to be easy to read and very informative. The team program that Allie created is shown below. LA Strikers Season Schedule L ASTRIKERSSan Marino Stadium Date Time Opponent Location Home/ www.lastrikers.net Away 100 Main Street • Los Angeles CA 90272 Friday, 7:00 Boston San Marino May 6, 20__ PM Breakers Stadium Home Digital Publishing Team ProgramSaturday, 5:00 Chicago Red Toyota Park Away May 14, 20__ PM Stars PLAYER SPOTLIGHT Saturday, 5:00 Houston BBVA Away May 21, 20__ PM Dash Compass Home Stadium Thursday, 4:00 FC Kansas San Marino May 26, 20__ PM City Stadium Saturday, 8:00 Portland Providence Away June 4, 20__ PM Thorns Park Wednesday, 9:00 Washington San Marino Home June 8, 20__ PM Spirit Stadium Saturday, 7:00 Western Sahlen's Away June 18, 20__ PM New York Stadium Flash Friday, 4:00 Seattle San Marino Home June 24, 20__ PM Reign FC Stadium Saturday, 4:00 Sky Blue FC Yurcak Field Away July 2, 20__ PM Wednesday, 7:00 Atlanta Beat San Marino Home July 6, 20__ PM Stadium TEAM ROSTER FIRST NAME LAST NAME POSITION HEIGHT WEIGHT UNIFORM # STRIKERS Nadine Angerer Goalkeeper 5’ 9” 157 16 Veronica 5’ 4” 140 9 This month’s player spotlight is Jill Boquete Mid elder n/a n/a n/a dedicated to goalkeeper, Hope Whitney 5’ 7” 143 3 Solo. She has participated Nilla Ellis Coach 5’ 9” 150 4 multiple times in the Olympics, Nahomi 5’ 2” 110 9 playing for team USA. Born on Nadine Engen Defender 5’ 7” 110 13 July 30, 1981 in Richland, WA, Amy 5’ 6” 143 17 Hope has achieved a level of Sydney Fischer Defender 5’ 7” 146 2 fame that many players dream Carli 5’ 7” 141 10 of. She started out as a forward Dzsenifer Kawasumi Mid elder 5’ 7” 110 10 for her high school team, but has Anja 5’ 6” 128 7 gone on to become a world— Alex Kessler Mid elder 5’ 7” 137 13 famous goalkeeper. Becky 5’ 7” 141 11 Homare LePeilbet Defender 5’ 5” 121 8 Lotta 5’ 10” 141 8 Bianca Leroux Forward 5’ 9” 141 22 Hope 5’ 9” 152 1 Sara Lloyd Mid elder 5’ 5” 132 6 Marta 5’ 4” 126 10 Marozsán Mid elder Abby 5’ 11” 179 20 Mittag Forward Morgan Forward Sauerbrunn Defender Sawa Mid elder Schelin Forward Schmidt Defender Solo Goalkeeper Thunebro Defender Vieira da Forward Silva Forward Wambach Use Allie’s team program as a guide to help create your own. Do not duplicate her work 82

Databases ZONE 4 Game Plan Organizing team-related information In this section, you will use database software to organize important data and information relevant to your dream team. DB-1 Opponents Database 84 Equipment List DB-2 Vendor Database 86 DB-3 Concessions Database 90 • Project Planning Forms • Database Software THE DREAM TEAM 83

1Databases Opponents Database Organizing Opponent Information Your Goal Instructions Throughout the season, your team will travel to Download and complete the DB-1 Planning other stadiums to play away games. Therefore, it is Form from The Dream Team section of important to easily access the essential information www.mycompanionsite.com. you will need to get there. The best way to organize details about your opponents is to keep a record of 1. Create a new database file. each team in your league. The file should contain important information, such as the team name, head 2. Name the database DB-1 Opponents Database coach, stadium name, stadium address, city, state, zip and save it to The Dream Team folder. code, and closest airport. In this project, you will create an opponents database 3. Create a new Table and name it Opponents that includes 10 teams you are scheduled to play Database. against. 4. In Design View, set up the table using the SKILLS UTILIZED database structure shown below: Use database software to organize your opponents’ contact information. Field Name Data Type Field Size Tactics Team Name Short Text 35 Coach First Name Short Text 20 zz Be consistent in the use of abbreviations in a Coach Last Name Short Text 20 database. For example, decide whether to use Stadium Short Text 35 Street or St. Address Short Text 50 City Short Text 25 zz Key the state abbreviations and airport codes in State Short Text 2 all capital letters. Zip Short Text 5 Closest Airport Short Text 3 zz Read through all instructions before proceeding with this project. 5. Enter the data for each record from your completed DB-1 Planning Form in Datasheet zz Review the “In the Zone” section for guidance View. when completing this project. 6. Adjust the Field Name column widths as necessary. 7. Sort the table by Team Name in ascending order. 8. Resave the table. 9. Carefully proofread your work for design, format, spelling, and grammar, then resave. 10. Submit the table as required by your instructor. 84 THE DREAM TEAM

IN THE Organizing opponent information will help Ryan and Allie easily 1 plan away game travel. Since they took the time to create a ZONE database of rival teams, Ryan and Allie will have no problem easily finding the information when it is needed. The opponents databases that Ryan and Allie created for their teams are shown below. Team Name Coach First Name Coach Last Name Stadium Address City State Zip Closest Airport Databases Opponents Database Baltimore Ravens John Harbaugh M&T Bank Stadium 1101 Russell Street Baltimore MD 21230 BWI Cleveland Browns Mike Pettine First Energy Stadium 100 Alfred Lerner Way Cleveland OH 44114 CLE Denver Broncos Gary Kubiak Sports Authority Field 1701 Bryant Street Denver CO 80204 DEN Detroit Lions Jim Caldwell Ford Field 2000 Brush Street Detroit MI 48226 DTW Green Bay Packers Mike McCarthy Lambeau Field 1265 Lombardi Avenue Green Bay WI 54304 GRB New England Patriots Bill Belichick Gillette Stadium 1 Patriot Place Foxborough MA 02035 BOS New York Jets Todd Bowles Metlife Stadium 1 Metlife Stadium Drive East Rutherford NJ 07073 LGA Pittsburgh Steelers Mike Tomlin Heinz Field 100 Art Rooney Avenue Pittsburgh PA 15212 PIT San Francisco 49ers Jim Tomsula Levi's Stadium 4900 Marie P. Bartolo Way Santa Clara CA 95054 SFO Washington Redskins Jay Gruden Fedex Field 1600 FedEx Way Hyattsville MD 20785 DCA Team Name Coach First Name Coach Last Name Stadium Address City State Zip Closest Airport Atlanta Beat James Galanis KSU Soccer Stadium 3200 George Busbee Parkway Kennesaw GA 30144 ATL Boston Breakers Tom Durkin Harvard Stadium 79 North Harvard Street Allston MA 02134 BOS Chicago Red Stars Rory Dames Toyota Park 5700 College Road Lisle IL 60532 ORD FC Kansas City Vlatko Adonovski Swope Soccer Village 6310 Lewis Road Kansas City MO 64132 MCI Houston Dash Owen Coyl BBVA Compass Stadium 2200 Texas Street Houston TX 77003 IAH Portland Thorns Paul Riley Providence Park 1844 Southwest Morrison Street Portland OR 97205 PDX Seattle Reign FC Laura Harvey Memorial Stadium 401 5th Avenue North Seattle WA 98109 SEA Sky Blue FC Jim Gabarra Yurcak Field 83 Fitch Road Piscataway Township NJ 08854 EWR Washington Spirit Mark Parson Maureen Hendrix Field 18031 Central Park Circle Boyds MD 20841 BWI Western New York Flash Aaran Lines Sahlen's Stadium 460 Oak Street Rochester NY 14608 ROC Use Ryan and Allie’s opponents databases as a guide to help create your own. Do not duplicate their work. THE DREAM TEAM 85

2Databases Vendor Database Maintaining Vendor Records Your Goal Instructions Besides the revenue generated from ticket sales, your Download and complete the DB-2 Planning dream team will also depend heavily on the profits Form from The Dream Team section of made in your stadium’s gift shop. Choosing vendors www.mycompanionsite.com. that offer fair prices and reliable delivery is a time consuming process. Many companies review several 1. Create a new database file. sources to buy products and services from and check references from the supplier before committing to 2. Name the database DB-2 Vendor Database and doing business with someone. Once the relationship save it to The Dream Team folder. has been established, vendor records must be created and maintained. You and your staff need to 3. Create a new Table and name it Vendor Database. be able to quickly locate vendor information, such as a contact person’s name, phone number, and email 4. In Design View, set up the table using the address, so that ordering is a seamless process. database structure shown below. In this project, you will create a database of twelve vendors from whom you buy merchandise for your 5. Create the Lookup for Category with the choices dream team gift shop. shown below: SKILLS UTILIZED Field Name Data Type Field Size Use database software to maintain and query Vendor Short Text 35 vendor records for your dream team gift shop. Address 50 City Short Text 25 Tactics State 2 Zip Short Text 5 zz Businesses choose their vendors wisely by First Name 20 considering their needs, checking online reviews, Last Name Short Text 20 and speaking with the vendor’s customer service Phone 12 representative. Email Short Text 50 Discount zz Many vendors offer discounts for those customers Category Short Text 30 who pay their outstanding invoices early. Businesses take advantage of these savings by Short Text keeping accurate and up-to-date records. Short Text zz Read through all instructions before proceeding with this project. Short Text zz Review the “In the Zone” section for guidance Yes/No when completing this project. Lookup Choices: Clothing, Housewares, Toys, Miscellaneous 6. Enter the data for each record from your completed DB-2 Planning Form in Datasheet View. 7. Adjust the Field Name column widths as necessary. 86 THE DREAM TEAM

Vendor Database (continued) 2 8. Sort the table by Vendor in ascending order. 9. Resave the table. 10. Create a query that shows all vendor records in the Toy category. Include the Vendor and Email. 11. Save the query as Toy Vendors. 12. Carefully proofread your work for design, format, spelling, and grammar, then resave. 13. Submit the table and query as required by your instructor. Databases Vendor Database THE DREAM TEAM 87

2 IN THE Ryan knew that a database was an excellent way to keep track of large amounts of data. Contact information for suppliers can ZONE be sorted and accessed quickly when orders need to be made for the dream team gift shop. Good managers take the time to set up organized records so that work can be done more efficiently. The vendor database that Ryan created is shown below. Vendor Address City State Zip First Name Last Name Phone Email Discount Category American Uniform 5 Umber Way Bismarck ND 58612 Doris Long  Clothing Databases Vendor Database Brooklyn Packaging 63 Harvest Terrace Brooklyn NY 11235 Jon Butler (701)540‐2065 [email protected]  Housewares Cedar Clothing Company 5257 Cedar Road New Rochelle NY 12630 Jerry White  Clothing Cotton Express 904 Grand Leaf Avenue Orlando FL 33401 Marie Mills (718)798‐4127 [email protected]  Clothing E & J Toys 8274 Little Place Circle Phoenix AZ 86277 Phyllis Peterson  Toys Fork and Spoon, Ltd. 6317 Wishing Drive Provo UT 84372 Celia Boyd (518)174‐1463 [email protected]  Housewares Global Sources 78 Old Road New Orleans LA 70714 Julie Davis  Miscellaneous Gourmet to Go 2576 Blue Road Richmond KY 42333 Dawn Hall (904)831‐6074 [email protected]  Housewares Jacobs Marketplace 9 Sienna Drive Charlotte NC 27915 Sharon Cook  Miscellaneous KidStuff 2007 Branch Avenue Baltimore MD 21613 Matt Smith (602)513‐9353 [email protected]  Toys Lacy Linens 6 Shady View Road Las Vegas NV 89327 Randy Griffin  Housewares Lifetime Graphics 75 Aspen Drive Lewisville TX 75067 Don Stewart (801)232‐7949 [email protected]  Miscellaneous New Jersey Novelty PO Box 52 Hartford CT 06251 Alex Norman  Miscellaneous Outdoor Express PO Box 6874 Lincoln NE 69515 Paula Stewart (337)772‐6516 [email protected]  Toys Purple Rose Athletics 4910 Bright Willow Parkway Des Moines IA 51198 Donna Sanders  Clothing Simon Toy Company 435 Brookside Drive Columbia MO 65696 Parker Martin (606)380‐9001 [email protected]  Toys Sports Unlimited 367 Stony Heights Lexington KY 40530 Kathy Morgan  Clothing The Toy Soldier 38 Indian Drive Great Falls MT 59086 Ruby Coleman (919)286‐8178 [email protected]  Toys White Dove Supplies 83 Harvest Street Wyoming VA 23718 Meg Barnes  Miscellaneous Williams Glass Company 74 Allen Road Wakefield RI 02879 Sara Williams (240)326‐1718 [email protected]  Housewares (702)601‐4528 [email protected] (213)267‐4670 [email protected] (475)952‐0492 [email protected] (308)915‐0378 [email protected] (319)701‐2973 [email protected] (417)368‐1597 [email protected] (502)629‐7558 [email protected] (406)440‐2646 [email protected] (703)870‐8676 [email protected] (401)175‐6122 [email protected] Vendor Email KidStuff [email protected] E & J Toys [email protected] The Toy Soldier [email protected] Simon Toy Company [email protected] Outdoor Express [email protected] Use Ryan’s vendor database as a guide to help create your own. Do not duplicate his work. 88 THE DREAM TEAM



3Databases Concessions Database Finding Concession Stand Suppliers Your Goal Instructions There is no better way to enjoy a game than to Download and complete the DB-3 Planning munch on a tasty treat while watching your favorite Form from The Dream Team section of team play. The food options available at your stadium www.mycompanionsite.com. will add to the overall experience of fans attending a game, so offer food and drinks that will appeal to the 1. Create a new database file. majority of your fan base. A great team and a variety of tasty food and drink options will make it more 2. Name the database DB-3 Concessions Database likely that your fans will attend another game. and save it to The Dream Team folder. In this project, you will create a database of contact information for 10 food service providers that will be 3. Create a new Table and save it as Concessions located in your stadium’s concession stand space. Database. SKILLS UTILIZED 4. In Design View, set up the table using the database structure shown below. Use database software to create your dream team concession stand food service providers list. 5. Create the Lookup for Food Category with the choices shown below: Tactics Field Name Data Type Field Size zz Use the Internet to find the name, address, phone number, and website of real food service Concession Vendor Short Text 35 providers. Consider using local restaurants Name that can provide well-known foods from your Address Short Text 50 hometown. City 25 State Short Text 2 zz Choose a diverse group of concession suppliers. Zip Code 5 You want your stadium to offer drinks and snacks, Website Short Text as well as complete meals and desserts. Food Category 30 Short Text zz Read through all instructions before proceeding with this project. Hyperlink zz Review the “In the Zone” section for guidance Lookup when completing this project. Choices: Sandwiches, Fast Food, Beverages, Snacks, Frozen, Dessert, Pizza, Other 6. Enter the data for your first record from your completed DB-3 Planning Form in Datasheet View. 7. Adjust the Field Name column widths as necessary. 8. Using the Concessions Database table, create a form to enter the remaining records. 90 THE DREAM TEAM

Concessions Database (continued) 3 9. Save the form as Concessions Information. Databases Concessions Database 10. Enter the data for the remaining nine records from the completed DB-3 Planning Form in Form View. Note: The Concessions Database table will update as you are adding new records in Form View. 11. Test the hyperlinks in the Website field to ensure they are working properly. 12. Go to Datasheet View and sort the table by Concession Vendor Name in ascending order. 13. Resave the table. 14. Carefully proofread your work for design, format, spelling, and grammar, then resave. 15. Submit the table and form as required by your instructor. THE DREAM TEAM 91

Ryan and Allie each chose concession stand vendors that would 3 IN THE be popular with their fans. They also wanted to give the fans a unique experience when attending a game, so they chose a wide variety of food and drink offerings. The concession stand ZONE database tables that Ryan and Allie created are shown below. Databases Concessions Database Concession Vendor Name Address City State Zip Code Website Food Category Auntie Anne's 48‐50 West Chestnut Street, Suite 200 Lancaster PA 17603 www.auntieannes.com Snacks Dairy Queen 7505 Metro Boulevard Edina MN 55439 www.dairyqueen.com Frozen Dunkin' Donuts 130 Royall Street Canton MA 02021 www.dunkindonuts.com Beverages Johnny Rockets 20 Enterprise, Suite 300 Aliso Viejo CA 92656 www.johnnyrockets.com Fast Food McDonald's 200 Monsignor O'Brien Highway Cambridge MA 02140 www.mcdonalds.com Fast Food Mrs. Fields 8001 Arista Pl #600 Broomfield CO 80021 www.mrsfields.com Dessert Orange Julius 7505 Metro Boulevard Edina MN 55439 www.orangejulius.com Beverages Panda Express 1683 Walnut Grove Avenue Rosemead CA 91770 www.pandaexpress.com Other Papa John's 971 Tremont Street Boston MA 02119 www.papajohns.com Pizza Subway 325 Bic Drive Milford CT 06461 www.subway.com Sandwiches Concession Vendor Name Address City State Zip Code Website Food Category Asia Wok 53 Walnut Grove Avenue Bay City MI 34627 www.asiawok.com Other Auntie Anne's 48‐50 West Chestnut Street, Suite 200 Lancaster PA 17603 www.auntieannes.com Snacks Ben & Jerry's Ice Cream 30 Community Drive South Burlington VT 05403 www.benjerry.com Frozen Dairy Queen 7505 Metro Boulevard Edina MN 55439 www.dairyqueen.com Frozen Dunkin' Donuts 130 Royall Street Canton MA 02021 www.dunkindonuts.com Beverages McDonald's 200 Monsignor O'Brien Highway Cambridge MA 02140 www.mcdonalds.com Fast Food Orange Julius 7505 Metro Boulevard Edina MN 55439 www.orangejulius.com Beverages Quizno's 1001 17th Street Denver CO 80202 www.quiznos.com Sandwiches Sbarro 401 Broadhollow Road Melville NY 11747 www.sbarro.com Pizza Subway 325 Bic Drive Milford CT 06461 www.subway.com Sandwiches Use Ryan and Allie’s concessions databases as a guide to help create your own. Do not duplicate their work. 92 THE DREAM TEAM