Excel_Project_Su09

# Excel_Project_Su09 - CIS 150 Excel Project Summer 2009 DUE...

This preview shows pages 1–2. Sign up to view the full content.

CIS 150 –Excel Project – Summer, 2009 DUE DATE: You are asked by the coach of the Mobile Area Triathlon Team to help keep track of the members training distances. You begin this process by setting up a template worksheet that can be used for all events. A template is a spreadsheet with labels, formulas, and charts predefined, a framework for the collection of data. You will also create a consolidated worksheet to tally up each athlete’s total mileage for the quarter. Your workbook will contain 5 worksheets; 1 template, 3 event sheets, and the consolidated. Use the following information to create your workbook. Creating the worksheets. 1) Create the template worksheet using the format shown on page 4 of this project. Name this worksheet “Template”. Save the workbook with the file name: “yourLastName_ExcelProject_Su09”. 2) Make 3 copies of the template within the workbook. Name these worksheets “Swimming”, “Running”, and “Biking”. 3) On each event worksheet customize the subtitle in row 2 to show the event name (Swimming, Running, Biking). 4) Enter the following data into the 3 event worksheets: Athlete Week1 Week2 Week3 Week4 Week5 Week6 Week7 Week8 Week9 Week10 Week11 Week12 Swimming Deb Adams 3.00 3.50 3.00 3.25 3.25 00 3.25 3.50 3.50 3.75 3.75 3.2 Ben Collins 3.50 3.25 3.25 3.75 3.50 3.75 3.50 3.75 4.00 3.75 4.00 3.5 Mary Jones 3.00 3.00 3.25 3.00 3.00 3.25 3.25 3.00 3.50 3.25 3.50 3.0 Lan Nguyen 3.50 3.25 3.50 3.75 3.75 3.75 4.00 3.75 4.00 3.75 4.00 3.5 Dave Sams 4.00 4.25 4.25 4.00 3.75 4.00 4.00 4.00 4.25 4.25 4.00 4.0 Tim Willis 3.50 3.50 3.25 3.25 3.50 3.25 3.50 3.75 3.75 3.50 3.50 4.0 Running Deb Adams 32.00 30.00 34.00 35.00 35.00 00 36.00 38.00 38.00 40.00 40.00 35.0 Ben Collins 40.00 40.00 40.00 42.00 44.00 44.00 44.00 46.00 46.00 44.00 44.00 40.0 Mary Jones 32.00 34.00 34.00 35.00 35.00 36.00 37.00 38.00 38.00 40.00 40.00 35.0 Lan Nguyen 36.00 36.00 38.00 38.00 38.00 40.00 40.00 42.00 44.00 44.00 46.00 40.0 Dave Sams 40.00 40.00 42.00 42.00 46.00 44.00 38.00 40.00 40.00 40.00 42.00 38.0 Tim Willis 46.00 48.00 48.00 50.00 52.00 52.00 54.00 54.00 50.00 50.00 52.00 54.0 Biking Deb Adams 80.00 80.00 77.00 75.00 73.00 00 85.00 88.00 80.00 82.00 75.00 70.0 Ben Collins 98.00 102.00 110.00 110.00 108.00 98.00 102.00 102.00 110.00 110.00 115.00 102.0 Mary Jones 80.00 80.00 77.00 75.00 73.00 80.00 86.00 88.00 80.00 82.00 75.00 70.0 Lan Nguyen 92.00 92.00 95.00 95.00 98.00 98.00

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/10/2012 for the course CIS 150 taught by Professor Chapman,d during the Summer '08 term at S. Alabama.

### Page1 / 6

Excel_Project_Su09 - CIS 150 Excel Project Summer 2009 DUE...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online