Lab 5 - Spreadsheets
Goals: Introduce the students to using Spreadsheet software applications.
Introduction
Spreadsheet programs are a vital part of modern business information management. They are used for budgeting, as well as for organizing tables of data. Spreadsheet applications like Microsoft Excel can store data neatly in rows and columns as well as provide easy to use mechanisms for searching and sorting the data, and even adding logic. In addition, importantly, Spreadsheets provide means for cascading calculations to be performed on data such that changing one piece of data may affect the results of calculations in other cells.
Instructions
Open Microsoft Excel and make a new File. Design and create a budget for your dream Major League Baseball team. For this team, you should pick 25 players (15 hitters, 10 pitchers) from various teams (don't just take them all from one team) and enter their statistics and salaries into your spreadsheet. Your spreadsheet file should be made up of 3 separate sheets: one for the pitchers, one for the hitters, and one for the team summary.
NOTE: All pitcher and hitter statistics, including 2007 salaries, may be found on the ESPN Web site. For example, you might go to the New York Yankees Batter statistics page to extract statistics on various players, and the Derek Jeter page to find his salary.
Pitchers Sheet: on the pitchers sheet, you should list all 10 pitchers' names, games pitched (G), wins (W), losses (L), innings pitched (IP), strike outs (SO), and salaries. Note: each column of your table should have a header in boldface type. This sheet should then have a row of totals, combining the numbers of all pitchers.
Hitters Sheet: on the hitters sheet, you should list all 15 hitters' names, positions, games played (G), at bats (AB), hits (H), runs (R), home runs (HR), runs batted in (RBI), stolen bases (SB), and salary. A total for all of these statistics for these hitters should be listed on this page as well. Note: each column of your table should have a header in boldface type.
Team Summary: on the team summary sheet, you should list all of the combined statistics for both pitchers and hitters. Hitters and pitchers have different statistics so their summaries should be listed separately, however, they all have salaries and so the combined total team salary should be listed on this sheet by referencing the data on the other pages. Note: each column of your table should have a header in boldface type.
For today's Lab: Setup your spreadsheet with 3 named sheets: pitchers, hitters, and team. Input all table headers and data for 2 hitters and 2 pitchers. Display the totals for this data on the hitters and pitchers sheets.
For Home: - Complete your team and define the team page such that it neatly summaries your team's data.
Web page created and maintained
by Richard McKenna