Holland Christian Schools

Baseball Ranking

Purpose:

• To learn how to use calculations and sorting in a spreadsheet?

To Do:

• Intro: We will work together through two spreadsheet samples. One involving pizza and another involving money.
• Project: Individually using the data about 11 baseball players, calculate their batting average, home runs per game, home runs per at bat, and home runs per hit.

Requirements:

• Download Baseball Ranking Spreadsheet.
• Enter a formula in the column "Batting Average." Which is equal to "Hits" / "At Bats" (=D2/C2). Then fill the column with that formula.
• Enter formula in the column "HR/Game" (which is Homeruns per game). The formula takes "Home Runs" / "Games." or (=G2/B2). Then fill the column with that formula.
• Enter formula in the column "HR/At Bat" (which is Homeruns per At Bat). The formula takes "Home Runs" / "At Bats." or (=G2/C2). Then fill the column with that formula.
• Enter formula in the column "HR/Hits" (which is Homeruns per Hit). The formula takes "Home Runs" / "Hits." or (=G2/D2). Then fill the column with that formula.
• Next answer the last 3 ranking questions at the bottom of the spreadsheet. To answer them you will need to use the "Sort" command found in the "Calculate" menu.
  • To use the sort function be sure that all of your data is selected.
  • Go to "Calculate" then to "Sort".
  • The "Range" should be A2..J12.
  • The "Order Keys" with "1st" should have the letter of the column you want to sort with a 2 after the letter.
• Copy and paste the list of names that are sorted and put them under each appropriate question.
• Save spreadsheet.
  

Evaluation:

• Please do the Baseball Ranking Rubric, with the person at a computer 5 numbers more than yours.

Final Steps:

• Name the document "Baseball Ranking"
• Save a copy in your "Public" folder and save a copy in your "Tech 6" folder.
• Go to the next project.