Apply your creative thinking and problem-solving skills to design and implement a solution.

Part 1: You have just started a new running regimen. You decide to track your progress so that you can evaluate your workouts. You decide to use Excel to track information about time, distance, and frequency of your runs. You plan to record the data for each run and to consolidate data on a weekly basis so that you can see how you are progressing from week to week.

Use the concepts and techniques presented in this module to create a workbook for tracking your running data. You want to create a workbook that contains multiple worksheets to allow you to review daily data, as well as consolidated data. Use your knowledge of consolidation to design a workbook that will allow you to analyze your progress. You should have at least one computed field, such as average miles per run, in your worksheets. You should include at least one chart presenting fitness data. Submit your assignment in the format specified by the instructor.

Part 2: This exercise had you create a chart presenting fitness data. List two other ways you could chart the data in Excel. What are the strengths and weaknesses of each of the three chart types for the data you are presenting?