SLP 4 consists of two parts. In Part I, you will create an Excel Pivot tables, and in Part II you will and evaluating security measures to protect Internet consumers.
Refer to tutorials at http://www.gcflearnfree.org/excel2013 and watch the videos.
Track Change and Comments [Video 24]
Finalizing and Protecting Workbooks [Video 25]
Conditional Formatting [Video 26]
Pivot Tables [Video 27]
What-If Analysis [Video 28]
For this assignment, first watch the below videos by clicking the links:
Using PivotTables to answer questions
Suppose we wanted to answer the question: What is the amount sold by each salesperson?” for the sales data in the example below. Answering this question could be very time-consuming and difficult?each salesperson appears on multiple rows, and we would need to total all of their different orders individually. We could use the Subtotal command to help find the total for each salesperson, but we would still have a lot of data to work with.
Fortunately, a PivotTable can instantly calculate and summarize the data in a way that is both easy to read and manipulate. Perform the following.
Use the PivotTable to calculate and summarize the data.
Once you have created a PivotTable, change the order amount to currency.
What is the amount sold by each salesperson?
What is the total amount sold in each month?
Take a screenshot or use the Snipping tool to copy the worksheet where the new pivot table and pivot table fields appear to show your work. Paste the screen images into a Word doc.
Submit your answers for this assignment by pasting the worksheet screenshots in 1- to 3-page Word document.
SLP Part II
For Part II, prepare a 1- to 2-page Word document paper addressing the following question.
Research 2-3 security measures that are available to protect customers shopping on the Internet. Define the measure and find the benefits and limitations of each approach.
SLP Assignment Expectations
Your assignment will be graded following these expectations:
SLP Part I and II must be submitted in one combined Word document containing 2-5 pages properly labeling each section.
Submit a Word document with screen copies of the Excel worksheet by pasting them in 1-3 pages. Answer the security question in 1-2 pages.
Precision: the questions asked are answered.
Clarity: Your answers are clear and show your good understanding of the topic.
Breadth and depth: The scope covered in your paper is directly related to the questions of the assignment and the learning objectives of the module.
Your paper meets the page requirements not counting the cover page or the references pages.
Human Resources and Staffing Crisis at Blumberg?s Nursing Home
Blumberg?s Nursing Home (BNH) is a 100-bed Medicare and Medicaid certified facility in suburban Philadelphia, PA. The administrator recently terminated the facility?s Director of Nursing (DON), receptionist, and dietary aid for inappropriate conduct. They had all been involved in purchasing and using illegal substances on facility grounds. Facility staff, as well as many of the more lucid residents, have found out about the incident.
The charge nurse has been appointed interim DON. The human resource manager has sent a memo to all staff informing them of a mandatory staff meeting to discuss BNH?s code of ethics and to provide additional training on workplace culture. Because federal law requires that there be at least one (1) registered nurse on duty for a minimum of eight (8) hours a day, seven (7) days a week, and that the DON must be a registered nurse (RN) ? which the interim DON is not ? BNH is out of compliance.
Write a four (4) page paper in which you:
Assess the immediate staffing needs at BNH. Prioritize the order in which BNH should fill the main unstaffed position(s). Justify your selection(s).Considering the reason behind the termination of the employees, formulate a human resources policy that addresses inappropriate conduct in the workplace, the process of reporting inappropriate conduct, and the consequences of violating the policy. Explain your rationale. Per the text, an effective long-term care facility administrator must have both leadership and management skills. Propose at least one (1) way the administrator in this case must demonstrate quality leadership skills, and one (1) way the administrator must demonstrate quality management skills in the aftermath of this crisis so as to improve and maintain staff and resident morale.Recommend a strategy for BNH to use the Quality Indicator Survey to improve administrative practices and ensure future compliance at the facility. Justify your recommendation.Use at least three (3) quality academic resources. Note: Wikipedia and other similar websites do not qualify as academic resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student?s name, the professor?s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Differentiate the administrative functions of long-term care practices from those of other healthcare administrative services. Identify the factors that have led to the current realities of long-term care in the United States.Assess the various stakeholder groups of long-term care along with the nature of the relationship(s). Recommend how a company can use the Quality Indicator Survey to improve administrative practices. Use technology and information resources to research issues in long-term care management.Write clearly and concisely about long-term care management using proper writing mechanics.