The Baseball
Calculator Webquest
Computer Class 611/841
Mr. Penza, Instructor |
Final
Project
You have been asked by the General Manager
of the
To develop a Spread Sheet on the Top 10
Batters on the Dodger Club. Extract the
required data from the Dodger website.
Then, create a spreadsheet that will show the top 10 batters by Batting
Average (highest to lowest). Slugging
Average (highest to lowest) and On Base Percentage (highest to lowest) and Most Singles
Hit (highest to lowest).
You will need to use your technical skills to download
the statistics page to Microsoft Excel, and then use the DATA Sorting tools to
organize your information. For Most
Singles Hit, remember to subtract 2B’s 3B’s and HR from total Hits.
Present your SpreadSheet with
appropriate fonts, bold, italics, and box styles.
Save the file to the Server Folder for your Class and
print file name below:
File Name: ______________________
One Example
Top 10 Batting Averages
|
Name |
BA |
|
Player name |
.346 |
|
“ |
.322 |
|
“ |
.312 |
|
“ |
.305 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|