250 - 500 Words.1. Describe the composition and characteristics of BP’s board of directors. What are the pros and cons of how BP’s board of directors is composed?

Course Name: MGT 301 (Organizational Behavior) Directions: These assignments are an individual assignments.All students are encouraged to use their own words. Be three to five pages in length, which does not include the title page, abstract or required reference page, which are never a part of the content minimum requirements. Use Saudi Electronic University academic writing standards and APA style guidelines. Support your submission with course material concepts, principles, and theories from the textbook and at least two scholarly, peer-reviewed journal articles unless the assignment calls for more. It is strongly encouraged that you submit all assignments into the safe assignment Originality Check prior to submitting it to your instructor for grading. Write a three-part essay (i.e., an essay that includes an introduction paragraph, the essay’s body, and a conclusion paragraph) that address the questions using a question and answer format. Your well-written paper should meet the following requirements:Assignment No:- 1Course Learning Outcome: Recognize the impact of organizational culture on shaping values, attitudes and behavior (Lo 1.9). Case Study: Foundations of Individual Behavior Differing Perceptions at Clarkston Industries Susan Harrington continued to drum her fingers on her desk. She had a real problem and wasn’t sure what to do next. She had a lot of confidence in Jack Reed, but she suspected she was about the last person in the office who did. Perhaps if she ran through the entire story again in her mind she would see the solution. Susan had been distribution manager for Clarkston Industries for almost twenty years. An early brush with the law and a short stay in prison had made her realize the importance of honesty and hard work. Henry Clarkston had given her a chance despite her record, and Susan had made the most of it. She now was one of the most respected managers in the company. Few people knew herbackground. Susan had hired Jack Reed fresh out of prison six months ago. Susan understood how Jack felt when Jack tried to explain his past and asked for another chance. Susan decided to give him that chance just as Henry Clarkston had given her one. Jack eagerly accepted a job on the loading docks and could soon load a truck as fast as anyone in the crew. Things had gone well at first. Everyone seemed to like Jack, and he made several new friends. Susan had been vaguely disturbed about two months ago, however, when another dock worker reported his wallet missing. She confronted Jack about this and was reassured when Jack understood her concern and earnestly but calmly asserted his innocence. Susan was especially relieved when the wallet was found a few days later. The events of last week, however, had caused serious trouble. First, a new personnel clerk had come across records about Jack’s past while updating employee files. Assuming that the information was common knowledge, the clerk had mentioned to several employees what a good thing it was to give ex-convicts like Jack a chance. The next day, someone in bookkeeping discovered some money missing from petty cash. Another worker claimed to have seen Jack in the area around the office strongbox, which was open during working hours, earlier that same day. Most people assumed Jack was the thief. Even the worker whose wallet had been misplaced suggested that perhaps Jack had indeed stolen it but had returned it when questioned. Several employees had approached Susan and requested that Jack be fired. Meanwhile, when Susan had discussed the problem with Jack, Jack had been defensive and sullen and said little about the petty-cash situation other than to deny stealing the money. To her dismay, Susan found that rethinking the story did little to solve his problem. Should she fire Jack? The evidence, of course, was purely circumstantial, yet everybody else seemed to see things quite clearly. Susan feared that if she did not fire Jack, she would lose everyone’s trust and that some people might even begin to question her own motives. Case Questions :- 1.Case Summary 2.Explain the events in this case in terms of perception and attitudes. Does personality play a role? 3.What should Susan do? Should she fire Jack or give him another chance?

Question 1 What is the relationship between problem-solving and decision-making? Question 2 Using the Final-Exam-Excel-Your name.xlsm  In Tab “Q2-B” format the two columns’ values as currency and after the blank line Calculate: - AverageSales for Sales and COGS for Year 2 - Lower Sales for Sales and COGS for Year 2 - How many Sales < 200000 for Sales and COGS for Year 2 Write a label in the highlighted blue of Column B and formulas in columns C and D Question 3  Using the Final-Exam-Excel-Your name.xlsm  Copy the information of the Tab “Q2-A” to the Tab “Q3” and calculate: The means, median, mode, and standard deviation of Sales and COGS for Year 1 in columns C and D at the end of the data.  Calculate the 3rd largest number of Sales and COGS. (Use the LARGE function) Add labels and format them correctly.  Example: Means = 195,48 6.72 51,29 9.51 Median = 180,86 5.00 47,668.88 Mode = 162,35 9.00 51,36 1.75 Standard Deviation = 54,95 5.01 15,92 0.79 3rd largest number = 265,36 6.00 74,80 0.50 Question 4 How do sparklines differ from charts? Explain. Question 5 Using the Final-Exam-Excel-Yourname.xlsm  Copy the information of the Tab “Q2-A” to the Tab “Q5” and obtain: A-Line Chart of Sales of Year 1 by Store ID. Change the title to “Sales by Year 1”. Verify that all the information and labels are correct. Add your name Question 6 Using the Final-Exam-Excel-Your name.xlsm  In Tab “Q6”: Copy in Columns C and D the Sales and COGS for Tab Q2-D Calculate the following formula in the Calculate column: For Sales less than COGS* 4.5, calculate the Subtraction of Sales and COGS otherwise enter zeroes In addition, calculate the minimum of the Sales & COGS in C26 & C27 Question 7 You can use up to three levels of security and protection to control who can access and change your Excel data.  Please describe two of the three levels and how you access each of them. Question 8 List and describe the four areas of a PivotTable report. How PivotTable could be used in a business situation.  Argument your answer Question 9 Using the Final-Exam-Excel-Yourname.xlsm Insert a Pivot Table in the Tab for Q9 that shows: The Sum of Units Sold by Planner Code. (Name the Tab Q9-1)   What is the total Qty Sold in Quarter 3? (Name the Tab Q9-2)   Hint: you must group by quarter. Question 10 Using the Final-Exam-Excel-Yourname.xlsm In tab Q10 Record a Macro to record the following actions: 1- Call the Macro: Test EXCEL question 10 2- Select the range B5:G174 3- In the Home menu select “Format as Table” and select the “Green” format. 4-Select the records with Demand Class = “Joint Venture Brazil” 5- In Cell E3 type your name.