This week we learned about several modeling techniques…for the case study above, you need to create: ONE USE CASE…ONE SEQUENCE MODEL…ONE OF ANY OTHER DIAGRAM from the ones we studied this week…just as a reminder, some of the techniques we studied were:UML Diagram…Process Model…Class Diagram…Activity Model…States and Stimuli… This means that you will be submitting THREE MODELS…I prefer that you use Power Point or Visio or similar software to create these models…if you do not have access to software to create these, you may hand write the diagrams, scan or take a picture of what you created and submit that…but please keep in mind…if you hand write these documents and I cannot read them or follow them, you will have points taken off…

Directions:Follow the requirements listed on the next page.Create the Excel Table and the Pivot Tables as indicated.Enter your name on cell J1 of the worksheets.Submit your assignment11.xlsx file to Canvas using the Canvas-> Assignments link.Requirements: Excel TablesThe Orders worksheet shows orders from a SuperStore. Some research needs to be done to locate a group of information.Convert the Orders dataset into an Excel Table (remember you only need to select one cell to create excel table)Then, locate the records of the Orders dataset that comply with all the following characteristics:City is New York or Philadelphia.Segment is Corporate.Format the Sales and Profit to be currency ($)Enter customer name with the most distinct product id from this filtered set into Page 1 of 2cell A30E Add a Total row and use the properties of the Total Row to calculate:the sum of sales (Column R).the sum of profit (column U).F Apply the Blue, Table Style Medium 9 to the table.Pivot Tables and Pivot ChartsPivot Table 1 :Use the Orders worksheet and create a Pivot Table on new worksheet with a filter on Category, row of Sub-Category, and sum of Quantity, Sum of Sales, Sum of ProfitFilter the information so that only “Office Supplies” is displayed.Which sub-category of Office Supplies has the most sales? Answer in cell J1 of thissheet.Format the Sum of Sales and Profit column to be currency ($)Rename the PivotTable's worksheet: Pivot Table 1.Pivot Table 2 & Pivot Chart:Use the West Coast Coffee worksheet and create another Pivot Table that displays the average of Sales $ organized by: Product and Month as row labels (in that order) and State as column labels. Format all sales numbers as currency ($)In cell J1 of this sheet put in the state that has the highest average coffee sales $Collapse the Product rows and create a 3D Clustered Column Pivot Chart.Apply Chart Style 5 and Quick Layout 3.Enter as Title of the Chart: Average Sales Totals.Rename the PivotTable's worksheet: Pivot Table 2.Move the Pivot Chart to its own worksheet. Rename this new worksheet as Pivot Chart.References:Chapters 13 and 14 of the Fluency7 textbookSupport.office.com Table and Pivot Table TutorialsLectures and Recitations

Answer 1 :Question 1) When implementing change in an organization, there are always culture issues that are faced, such as not accepting change, determine how differently this would be handled thinking about the management versus leadership constructs?Organizational changes should be constituted through open communication between all employees and their leaders. For instance, employees should be given a chance to air their views rather than rely on the in-line managers who can alter the original message from employees to favor themselves. Every organization contains employees who are gifted differently, and their contributions can spearhead the organization's success. If employees learn that their views are taken into consideration to better their working environment, they will positively react to changes within the organization. Therefore, managers will not have a hard time trying to convince employees of the importance of change as they are part and parcel of it. Leaders should also not implement policies that belittle their employees. Employees are the greatest assets within an organization, and they should always be valued to ensure organizational goals are achieved within the intended time. If managers are on good terms with employees, there won't be difficulties in implementing changes. Question 2) When dealing with performing work, how is this implemented differently within the management versus leadership constructs?Performing work is based on employee morale in their respective work environment. According to Widagdo, Widodo, & Samosir, (2018), compensation motivates employees to exert extra effort in their places of work. With a good compensation strategy, employees can positively react to change because they understand that the sole goal is to propel the organization towards a better position, and their effort will be rewarded through increased payments. The managers should ensure that there is a strategy to reward the best performing employees as this creates a competitive nature within the work environment whereby employees focus on achieving targets rather than conspiring to sabotage changes. The aspect of compensation is different from communication-based changes because in performing work, the output is based on the results compared to management versus constructs that rely on the relationship between employees and the top management. Therefore, leaders should focus on how employees are satisfied through the compensation strategy offered and incentives in performing work. ReferenceWidagdo, A., Widodo, D. S., & Samosir, P. S. (2018). Effect of Compensation and Motivation to Employee Performance through Commitment. Scholars Journal of Economics, Business and Management (SJEBM), 5(4), 319-325.Answer 2 :The process of getting to know individuals and groups in a system also provides an early forum in which people can deal with any discomfort and voice their concerns about working with US consultants so that we can address their concerns. Effectively adapting organization development approaches and models both ours and others to our client engagements outside of the US has been essential to facilitating the culture change and inclusion breakthroughs that have impacted our client s 'productivity and success (Katz, & Miller, 2016). The concepts we use are basically the same globally, but how we implement our work can vary dramatically based on national and organizational contexts. One of the key cultural dynamics we have often heard in Japan is “the nail that sticks out gets hammered.” This cultural saying translates into a strong need for harmony within a group or team, which often makes people reluctant to raise issues that might be problematic. This experience helped us bridge the gap and reframe speaking up as a practice that creates greater harmony by letting others know of an issue before it becomes a big problem for the team. This framing for the good of the group made people more willing to raise issues in the spirit of helping the team be better. Similarly, we used the lean manufacturing concept of eliminating production waste as a framework for considering how inclusive behaviors eliminate waste in human interactions.Adapting models and frameworks for change so that they are relevant to our client systems is not only a need in working globally, it is the very essence of OD work (McCalman, 2015). Such adaptation requires us to constantly adjust our own attitudes, beliefs, and methodologies to the local national, cultural, and organizational circumstances. Our job as change agents is to understand, adjust to, and challenge the system and ourselves in the process. In doing so, we can help our clients achieve their ultimate goals while hewing to the values that are central to our practice and our field.When dealing with performing work, how is this implemented differently within the management versus leadership constructs?While dealing with performing work the leader should at the first train the employee so that they can use the employee as a good resource. If there is any underperformance, then the leader should talk to the employee and make it done before it is too late (Stewart, 2016). As a good leader, you should know what motivates your employee the most. Reference:McCalman, J. (2015). Leading Cultural Change : The Theory and Practice of Successful Organizational Transformation. Kogan Page.Katz, J. H., & Miller, F. A. (2016). Defining Diversity and Adapting Inclusion Strategies on a Global Scale. OD Practitioner, 48(3), 42–47.Stewart, S. E. (2016). At Play in the Fields of OD. OD Practitioner, 48(3), 22–30.