Excel Darts

SPREADSHEETS

What do you know about Spreadsheets? Answer these questions to find out.    Try Me    Did you learn anything

Can students create an Excel data table and graph using data from a fictitious dart team?

Students create a three member team, each throwing 10 darts. Students must:

1. Create a data table

2. Write a formula adding up each team member's score

3. Merge and center the team name

4. Format the data table in a neat and legible manner

5. Sort the total scores highest to lowest

6. Find the team's average score and round it to two decimals

7. Make a bar or column graph of the players final score, including the team's average

8. Label the graph and the horizontal and vertical axis

To submit, the students must:

1. Select the first player's final score, this will show the formula in the formula bar

2. Put the graph under the data table

3. Use the Print Screen function on the computer to capture the screen

4. Paste the captured screen in Paint

5. Select and crop the formula, the data table and graph

6. Save this to the desktop and upload the file into your Google drive account

7. Click on the saved picture and go to File-Share and change from Private to Anyone with a Link

8. Copy the web address for the picture and SUBMIT it in the link below.

RUBRIC

SUBMIT