**this assignment was previously worked on by another writer, but I received a f
**this assignment was previously worked on by another writer, but I received a failing grade. I need to make sure this one is right so I can use it for this week and my final for this class. ** I attached the documents below. The original instructions were:
The purpose of this assignment is to conduct internal and external research to determine viable solutions that could be implemented to solve an identified problem.
For this assignment, you will create an Excel spreadsheet that summarizes the data collection you have completed. The spreadsheet should indicate the date on which particular data were collected, the source of the data collected, the type of data (qualitative or quantitative), and a one- or two-sentence summary of the data findings. Name the Excel spreadsheet as follows: lastname.firstname.datacollection.xlsx.
Please note that as part of the research process, taking the initiative to speak with management and then requesting and reviewing business metrics and operations reports will allow you to find the data you need for the project while also showing your employer that you can be proactive and use critical thinking to solve problems within the organization.
Part 1:
The first step in data collection is to conduct research. You are looking for specific, measurable data (statistics and numbers) related to how the problem is affecting the organization. This information should be recorded in the form of a chart or graph that presents the data so key decision makers can see the “cost” of failing to address the problem. Use the study materials for assistance with creating Excel graphs and charts that can be used to illustrate your findings.
Part 2:
Next, conduct additional research to learn what has already been done to address this problem within the organization. Ask questions and interview individuals who assisted with the implementation of previous solutions used to address the problem. Prior to meeting with individuals, develop a list of questions about previous solutions. Consider factors such as customer importance, efficiency, quality, employee satisfaction, and cost effectiveness. You will want to make sure you ask questions that allow you to gather measurable data and include information about how successful previous solution options were in addressing each of the problems. When you have completed your research, the findings should be summarized in an illustration using at least one chart or graph that represents the data you have collected. Use the study materials for assistance with creating Excel graphs and charts that can be used to illustrate your findings.
Part 3:
The last step in determining potential solutions is to conduct external research. Using Internet and industry resources, research ways other companies have addressed this issue or one very similar to it. Look for specific information related to the customer response, efficiency, quality, employee satisfaction, and cost effectiveness of solutions others have implemented. Find at least five potential solutions you can consider for solving the problem you have identified. Your goal in conducting this research is to find practical examples and measurable data related to how other companies, and related industries, have resolved the same problem or one very similar to it. When you have completed your research, the findings should be summarized in an illustration using at least one chart or graph, representing the data you have collected. Use the study materials for assistance with creating Excel graphs and charts, as this will help illustrate your findings.
Submit the data collection Excel spreadsheet and the three data summary charts/graphs you have created from the research conducted to your instructor.
I added a photo of the feedback from my instructor.
My assignments are labeled “alexism.data.” and “bechmark470.”
I added a copy of my classmate’s excel sheet (Griffin.Shaw) for guidance and also. (schmitt.bobb..)
below… Helpful tips: it would be your 5 potential solutions tab. It does have numbers, so you can make a chart for that portion. You should also put a brief blurp talking about the info so that when you do your summary slide you have more to build off. There is a link below from week 2 that shows how to use your data to make a chart. It is easy and takes 2 clicks, and you’re done. As for your info, create 1 tab that shows the failure to address your problem and any data that shows the problem exists, another tab that shows previous attempts to fix the problem and any data that shows if it was successful or not and potentially why, and another tab that shows your 5 potential solutions and data that show your expected outcomes, and your final tab should be a summary of all that also shows your references.