Module 3 – Case
Excel and Problem Scoping
For this Case assignment, you will apply basic Excel functions use as a tool (spreadsheet) to store, analyze and manipulate data. Use the spreadsheet and the linked Excel Tutorial Video provided to learn the steps required for each part of the Case assignment. Use the optional readings in your Background page to locate additional Excel help and tutorials.
Manipulate the data in this sample order spreadsheet to answer the following questions:
1. Sort your spreadsheet and then calculate each region’s order totals using Excel sort and “sum” functions. Which region’s order generated the highest dollar amount? What percent of total sales does this region represent?
2. Sort your spreadsheet and then calculate each region’s order totals using Excel sort and “sum” functions. Which rep generated the highest sales?
3. Create a bar chart or a pie graph to illustrate both of these trends.
Save each sort and submit it as a worksheet in your Excel workbook. Label each worksheet.
Save and submit your work on the sample spreadsheet as an Excel Workbook to show your sorting and totaling results as individual worksheets. For example, Worksheet 1 should be titled “Region;” Worksheet 2 should be titled “Rep;” and Worksheet 3, “Graphs.” In the summary, upload the following into the Case 3 drop box by the module due date:
1 Excel workbook with 3 worksheets
NOTE: You do not need to submit a cover or reference page for this assignment, but please add your name to each worksheet.
Module 3 – SLP
Excel and Problem Scoping
The initial phase of Creative Problem Solving is often referred to as Problem Scoping. This process establishes clear requirements for creating a viable final solution. It often is initiated by the identification of a need or issue. This part of the problem solving process focuses on the issue/need by gathering and analyzing information. In other words, you will clearly define what needs to be done prior to creating an effective solution.
This SLP will help you practice your problem scoping skills by completing a clear, focused Problem Scoping Document. This will provide a clear problem definition and target for solution development.
Problem Scoping Assignment Instructions:
As you complete problem scoping phase, your proposed document will include the following information:
· Develop a Problem Statement.
· Determine any potential constraints,
· Determine the criteria
· Identify the stakeholders
· Develop a procedure for gathering data prior to decision making.
Be sure to thoroughly complete and submit the Problem Scoping Document.
1. Select a problem from either: Performance Management or Compensation Case
2. Determine what questions you would ask yourself:
a. Scope of the problem – Part of the Problem Statement.
b. When and where the problem occurs – Part of the Problem Statement.
c. Impact – Part of the Problem Statement.
d. Identify two criteria related to the problem statement that you created.
e. Who is directly involved with the problem? Stakeholders?
3. Determine how you would gather data.
SLP Assignment Expectations
In addition to addressing each step above in the Problem Scoping word document template, your assignment must follow these formatting requirements:
1. Center the title, your name, and date on a separate page. Use Times New Roman, 14 point)
a. Bold the title only
2. Set Left and Right margins at 1 inch
3. Number the pages
4. Include a References section using the guidelines from the Trident University Writing Style Guide (Mullen, Timothy. 2014. Trident University Writing Guide. Accessed on June 20, 2016 at https://mytlc.trident.edu/index.php). Include this site as a reference in addition to any of the background readings that you draw upon to develop your problem scoping document.
5. Upload your document as a Word .doc or .pdf into the SLP drop box by the module due date.
DOWNLOAD THE SOLUTION HERE