Question: This project counts as your assignment and your final assignment It involves your participation with weekly assignments that all count toward your final grade. Read

This project counts as your assignment and your final assignment It involves your participation with weekly assignments that all count toward your final grade. Read the instructions below Excel is very good at displaying data in a way that we can get useful information. However we need to gather data and then present our findings. One of the ways we gather data is over a certain amount of time. The time can be at regular intervals or over the course of days. For the next 5 weeks your task is to gather data on a subject approved by your instructor. Rules: Data must be collected at regular predetermined time intervals. Any missed interval could jeopardize the validity of your result. It has to be local and in a physical location where you must collect, view, or observe. Data collected cannot be already being measured or presented by another application (ie. financial or stocks on the internet). Scoring will be based on three factors for a total of 95 points: All data are present and valid (taken weekly) with a data collection worksheet (31.66 pts) Data are organized in a final spreadsheet with chart of choice along with MS Word summation (31.66 pts) Results are presented in the last week of the course (31.66 pts) In Weeks 5-8, there will be an assignment submission of your data collection. You will receive credit for each weekly submission along with the final project. Use Excel to measure something throughout the next five weeks. What will it be? Some suggestions: Food Prices in the local supermarket ( min. 10 products) Gas Prices in a certain location (comparing at least 2 stations) Working conditions in your employment (wide range of options) Neighborhood activity sales, business increase or decrease Household Utilities Expenses (Electricity usage, Gas, water, etc.) Remember all types of measurements are taken at regular intervals and must be kept accurate. Strict adherence to these disciplines gives your data validity. Otherwise your results can be challenged by critics. For more information on this subject and project requirements speak with your professor and get approval of your project prior to building the spreadsheet for data collection. At the end of your data collection we will build a spread sheet with graphs that depict the current trends we are measuring. For more detailed instructions consult your course instructor. Use this link as an example: Final Project Pricing Survey PDF

This project counts as your assignment and your final assignment It involves your participation with weekly assignments that all count toward your final grade. Read the instructions below

Excel is very good at displaying data in a way that we can get useful information. However we need to gather data and then present our findings. One of the ways we gather data is over a certain amount of time. The time can be at regular intervals or over the course of days. For the next 5 weeks your task is to gather data on a subject approved by your instructor. Rules: Data must be collected at regular predetermined time intervals. Any missed interval could jeopardize the validity of your result. It has to be local and in a physical location where you must collect, view, or observe. Data collected cannot be already being measured or presented by another application (ie. financial or stocks on the internet). Scoring will be based on three factors for a total of 95 points:

  1. All data are present and valid (taken weekly) with a data collection worksheet (31.66 pts)
  2. Data are organized in a final spreadsheet with chart of choice along with MS Word summation (31.66 pts)
  3. Results are presented in the last week of the course (31.66 pts)

In Weeks 5-8, there will be an assignment submission of your data collection. You will receive credit for each weekly submission along with the final project. Use Excel to measure something throughout the next five weeks. What will it be? Some suggestions:

  • Food Prices in the local supermarket ( min. 10 products)
  • Gas Prices in a certain location (comparing at least 2 stations)
  • Working conditions in your employment (wide range of options)
  • Neighborhood activity sales, business increase or decrease
  • Household Utilities Expenses (Electricity usage, Gas, water, etc.)

Remember all types of measurements are taken at regular intervals and must be kept accurate. Strict adherence to these disciplines gives your data validity. Otherwise your results can be challenged by critics. For more information on this subject and project requirements speak with your professor and get approval of your project prior to building the spreadsheet for data collection. At the end of your data collection we will build a spread sheet with graphs that depict the current trends we are measuring. For more detailed instructions consult your course instructor.

Use this link as an example: Final Project Pricing Survey PDF

This project counts as your assignment and your

Week 4 Week 3 6/21/2014 6/28/2014 Chart Price Price 4.89 IS 3.00 2.99 4.99 Food Price Survey List Shop Rite Central Ave Scarsdale, NY Week 1 Week 2 6/7/2014 6/14/2014 Quantity Price Price 1 $ 5.89 $ 5.99 $ 1gallon $ 3.00 $ 3.00 $ 1 bunch $ 2.59 $ 2.49 $ 1 bunch $ 5.99 $ 5.99 $ 5-20lbs $ 18.99 $ 18.99 $ 1 lbs $ 3.00 $ 3.00 $ $ 25.00 $ 25.00 $ 1 dozen $ 9.99 $ 9.99 $ 1 Pack $ 4.89 $ 4.99 $ 5 lbs $ 15.99 $ 15.99 $ 1 $ 3.00 $ 2.49 $ 1 $ 2.95 $ 3.00 $ 1 $ 2.75 $ 3.00 $ 1 $ 3.00 $ 3.00 $ 1lbs $ 2.49 $ 2.49 $ 1Lbs $ 3.00 $ 3.00 $ 18.99 3.89 1lbs Items Whole Wheat Bread Milk Bananas Platanos Jasmine Rice Avacado Fresh Salmon Eggs Strawberries Chicken Pineapples Grapes Tomatoes Lettuce Lemons Limes 25.00 9.99 4.89 $ 3.50 $ 1.00 $ 5.99 $ 20.00 $ 3.00 $ 25.00 $ 9.99 $ 5.49 $ 13.99 $ 3.00 $ 2.49 $ 3.00 $ 2.49 $ 2.89 $ 3.29 $ 4.89 13.99 3.00 2.49 3.00 2.49 3.00 3.00 Ray Giles Week 4 Week 3 6/21/2014 6/28/2014 Chart Price Price 4.89 IS 3.00 2.99 4.99 Food Price Survey List Shop Rite Central Ave Scarsdale, NY Week 1 Week 2 6/7/2014 6/14/2014 Quantity Price Price 1 $ 5.89 $ 5.99 $ 1gallon $ 3.00 $ 3.00 $ 1 bunch $ 2.59 $ 2.49 $ 1 bunch $ 5.99 $ 5.99 $ 5-20lbs $ 18.99 $ 18.99 $ 1 lbs $ 3.00 $ 3.00 $ $ 25.00 $ 25.00 $ 1 dozen $ 9.99 $ 9.99 $ 1 Pack $ 4.89 $ 4.99 $ 5 lbs $ 15.99 $ 15.99 $ 1 $ 3.00 $ 2.49 $ 1 $ 2.95 $ 3.00 $ 1 $ 2.75 $ 3.00 $ 1 $ 3.00 $ 3.00 $ 1lbs $ 2.49 $ 2.49 $ 1Lbs $ 3.00 $ 3.00 $ 18.99 3.89 1lbs Items Whole Wheat Bread Milk Bananas Platanos Jasmine Rice Avacado Fresh Salmon Eggs Strawberries Chicken Pineapples Grapes Tomatoes Lettuce Lemons Limes 25.00 9.99 4.89 $ 3.50 $ 1.00 $ 5.99 $ 20.00 $ 3.00 $ 25.00 $ 9.99 $ 5.49 $ 13.99 $ 3.00 $ 2.49 $ 3.00 $ 2.49 $ 2.89 $ 3.29 $ 4.89 13.99 3.00 2.49 3.00 2.49 3.00 3.00 Ray Giles

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!