Utah Desert Golf Classic - Bar Graph of Scores

Introduction
Use the information from the spreadsheet of Utah Desert Classic to create a bar graph of the scores. Also a set of formulas will be printed out.

Objectives and Skills

Instructions

  1. Use the Top Five Golf Scores worksheet to create a graph
  2. Create a stacked bar graph using the golfer's name and the scores for the both sets of 9 holes. (Do not include the 18 hole totals.)
  3. Add a title Top Five Golf Scores. Change the font for the title to about 24 points in a decorative font.
  4. On the sub-title line write "Prepared by....".
  5. Change the colors and shading on the bars if possible.
  6. Include the Players Name's on the X-axis.
  7. Add an appropriate title for the horizontal and vertical axis.
  8. Add a border around the outside if possible.
  9. Change the orientation of the paper so it prints landscape.
  10. Make any additional adjustments to prepare a well-designed graph.
  11. Proofread, preview, save and print.

Formula Printout Instructions

  1. Use the Top Five Golf Scores worksheet.
  2. Display the formulas.
  3. Make any adjustments needed, including column widths.
  4. Save as a new worksheet and print.

© 1996 Carl Lyman www.dtc.millard.k12.ut.us/~lyman/infoproc/udgbargf.htm