Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the Lab Design and implement a solution using creative thinking and problem-solving skills. Track Fitness Data Note: To complete this assignment, you will be
In the Lab Design and implement a solution using creative thinking and problem-solving skills. Track Fitness Data Note: To complete this assignment, you will be required to use the Data Files. Please contact you instructor for information about accessing the Data Files. Problem: You have just started a new biking regimen. You decide to track your progress so thar you can evaluate your bike rides. You decide to use Excel to track information about time, distane and frequency of your rides. You plan to record the data for each ride and to consolidate data on weekly basis so that you can see how you are progressing from week to week. Perform the following tasks: Part 1: Use the concepts and techniques presented in this module to create a workbook for track ing your biking 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 ride 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? In the Lab Design and implement a solution using creative thinking and problem-solving skills. Track Fitness Data Note: To complete this assignment, you will be required to use the Data Files. Please contact you instructor for information about accessing the Data Files. Problem: You have just started a new biking regimen. You decide to track your progress so thar you can evaluate your bike rides. You decide to use Excel to track information about time, distane and frequency of your rides. You plan to record the data for each ride and to consolidate data on weekly basis so that you can see how you are progressing from week to week. Perform the following tasks: Part 1: Use the concepts and techniques presented in this module to create a workbook for track ing your biking 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 ride 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started