Need Original Work only Assignment InstructionsCreate a PowerPoint presentation with following (Save as w8_firstname_lastname.PPTX).We did not cover PowerShell in this course; you are tasked to use PowerShell as your scripting language.Create at least 9 Slides to cover the following:-1) The role of scripting in system administration2)How to apply security measures in scripting3)What is PowerShell4)Can PowerShell run in other platforms5)How to Assign variables6)How to use if-then7)How to use loops8)How do I apply security on PowerShell scripts9)How do I use PowerShell Scripting in everyday tasks?Note: Please explain the above 9 requirements in your own words. Go into detail on each slide so it is clear that the concepts you are stating are explained and understood by you. For example, a list of security protocols will not be sufficient for full credit without an explanation of each protocol.RequirementsPointsComment block. (Slide 1)10Presentation70conclusion slide 30TOTAL POINTS100Keep the presentation clean and simple, select soft colors and font size. Remember it is a presentation, you are presenting this to others with different skills.Submit your week 8 work in w8_firstname_lastname.PPTX

Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. The file includes variables regarding students’ age, gender, major, GPA, Bachelors GPA, course load, English speaking status, family, weekly hours spent studying. Each of the three assigned problems should be formatted as a one page memo. Answers to all three of the problems should be submitted via the Drop Box as a single Word document with each of the problems clearly labeled. Be sure to include your name on the document itself! COMPLETE PROBLEM 1: It is pretty common across most schools to find the grades at the MBA level divided between A’s and B’s. As such, you expect the mean GPA to be around 3.50. Using the sample of 200 MBA students, conduct a one-sample hypothesis test to determine if the mean graduate GPA is different from 3.50. Use a .05 significance level. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also include a chart (a bar chart or column chart will probably work best) comparing the calculated mean with the hypothesized mean. COMPLETE PROBLEM 2: Assume you read in the Whatsamatta U website that the average age of their MBA students is 45. Is this really true or have they failed to update this correctly? You think it is far less because more students have started their Masters sooner since the economy is so bad. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the mean age is less than 45. Use a .05 significance level. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also include a chart (a bar chart or column chart will probably work best) comparing the calculated mean with the hypothesized mean. COMPLETE PROBLEM 3: You have heard from idle chatter that most students don’t declare a major in their MBA programs. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the proportion without a major is greater than 50%. Use a .05 significance level. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also include a chart (a bar chart or column chart will probably work best) comparing the calculated proportion with the hypothesized proportion. *Note: you are testing sample date to some stated norm or Null.  You have to choose which of the three directions for the one sample tests that you will perform based on the wording in the problem set.  (two-tailed, upper tailed, or lower tailed). You would only use one of the three. ***The only charts that I am interested in you providing for your homework are the output charts from the one sample tests.  You do not need to create additional bar or pie charts for the future units.  Use the “Solutions To Practice Problems” as your guide for formatting your work and writing your analysis**. Finished work should look like the Practice Problems file that I uploaded. Please follow the instructions thoroughly and let me know if you have any questions or concerns. Make sure to use the files I uploaded.

InstructionsCookie Creations (Chapters 11 and 15)This assignment is a continuation of the Cookie Creations case study and focuses on Cookie Creations' liabilities (current and long-term). From the information gathered from the unit lesson, required unit resources, and suggested unit resources, read the Cookie Creations case study below, which is also available on p.11-37 (Chapter 11) and p. 15-38 (Chapter 15) in the textbook.The case study allows you to apply what you have learned about liabilities and the accounting process. This assignment will allow you to practice what you have learned so far.Part IRecall that Cookie Creations sells fine European mixers that it purchases from Kzinski Supply Company. Kzinski warrants the mixers to be free of defects in material and workmanship for 1 year from the date of original purchase. If the mixer has such a defect, Kzinski will repair or replace the mixer free of charge for parts and labor. The product must be shipped prepaid to an authorized Kzinski service center. The consumer pays the cost to ship the mixer. The cost to return the product to the consumer is paid by Kzinski.The authorized service center is located in Boston. Because Cookie Creations values serving its customers, it pays the shipping to Boston for any mixers needing repair under Kzinski’s warranty terms. Based on past experience, Kzinski has found that approximately 10% of mixers are returned for repair or replacement. The average cost to ship a mixer to Boston is $60.The following transactions take place in 2020 and 2021.A total of 30 mixers are sold in 2020.Four of the mixers sold in 2020 are returned for repair in 2021. The total shipping cost for returning these four mixers to Boston is $210.A total of 40 mixers are sold in 2021.Two of the mixers sold in 2021 are returned for repair in 2021. The total shipping cost for returning these two mixers to Boston is $55.For Part I of the assignment, complete the tasks listed below using Excel.Calculate Cookie Creations’ warranty liability for the shipping costs at December 31, 2020.Record the estimated warranty liability at December 31, 2020.Prepare the summary journal entry (or entries) to record the shipment of the six mixers (four from the 2020 sales and two from the 2021 sales) for warranty repair in 2021. d.Calculate Cookie Creations’ warranty liability at December 31, 2021. (Hint: Note that there is no liability outstanding for the mixers sold in 2020. The 1-year warranty period has expired.)Record the estimated warranty liability at December 31, 2021. (Hint: Similar to accounting for bad debts, consider any existing balance in the warranty liability account when you prepare your entry. You will find it helpful to prepare a general ledger account for the warranty liability and to post the above transactions.)Part IINatalie and Curtis have been experiencing great demand for their cookies and muffins. As a result, they are now thinking about buying a commercial oven. They know which oven they want and that it will cost $17,000. The company already has $5,000 set aside for the purchase and will need to borrow the rest.Natalie and Curtis met with a bank manager to discuss their options. She is willing to lend Cookie & Coffee Creations Inc. $12,000 on November 1, 2020, for 3 years at a 5% interest rate. The terms provide for fixed principal payments of $2,000 on May 1 and November 1 of each year plus 6 months of interest.For Part II of the assignment, complete the tasks listed below.Prepare a payment schedule for the life of the note.Prepare the journal entry for the purchase of the oven and the issue of the note payable on November 1, 2020.Prepare the journal entries on May 1 and November 1 for the note.Determine the current portion of the note payable and the long-term portion of the note payable at October 31, 2021.Parts I and II should be submitted in a single Excel spreadsheet. You will use a new tab to complete each transaction for both Parts I and II for a total of nine separate tabs or sheets. Submit the Excel spreadsheet in Blackboard.