This is a simple assignment that u just need to follow the instructions. Open the start file EX2019-SkillReview-5-2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.Format the data on the Sales Data worksheet as a table using the Blue, Table Style Medium 2 table style: Select any cell in the data. On the Home tab, in the Styles group, click the Format as Table button to display the Table Styles gallery. Click the Blue, Table Style Medium 2 Quick Style. It is the second option in the Medium section of the gallery. Verify that the My table has headers check box is checked and that the correct data range is selected. Click OK.Add a Total row to the table to display the number of buyers; the average number of bedrooms and bathrooms for each sale; and the average purchase price, interest rate, and mortgage length. On the Table tab, in the Table Style Options group, click the Total Row check box. In the Total row at the bottom of the table, click in the Buyers column, click the arrow, and select the Count function. In the Total row at the bottom of the table, click in the Bedrooms column, click the arrow, and select the Average function. In the Total row at the bottom of the table, click in the Bathrooms column, click the arrow, and select the Average function. In the Total row at the bottom of the table, click in the Purchase Price column, click the arrow, and select the Average function. In the Total row at the bottom of the table, click in the Rate column, click the arrow, and select the Average function. In the Total row at the bottom of the table, click in the Mortgage Years column, click the arrow, and select the Average function.Sort the data so the newest purchases appear at the top. Click anywhere in the Date of Purchase column. On the Data tab, in the Sort & Filter group, click the Z-A button.Filter the data to show only houses sold by owner with three or four bedrooms. Click the arrow at the top of the Agent column. Click the (Select All) check box to remove all of the checkmarks. Click the check box in front of By Owner. Click OK. Click the arrow at the top of the Bedrooms column. Click the (Select All) check box to remove all of the checkmarks. Click the check boxes in front of 3 and 4. Close the dialog.Create a line chart showing the purchase prices for houses by date. Select the Date of Purchase data cells. Be careful not to include the column heading. Press and hold the Command key and click and drag to select the Purchase Price data cells, again being careful not to include the column heading. On the Insert tab, in the Charts group, click the Insert Line or Area Chart button. Select the first line chart type shown. The Line Chart is inserted in the worksheet.Move the chart to its own sheet named Purchase Prices. If necessary, select the chart. On the Chart Design tab, in the Location group, click the Move Chart button. In the Move Chart dialog, click the New sheet radio button. In the box type: Purchase Prices Click OK.Update the chart title and display the data labels as callouts. Change the chart title to: Homes For Sale By Owner Click the Chart Design tab if necessary. In the Chart Layouts group, click the Add Chart Element button. Point to Data Labels and select Data Callout.Apply the Style 2 Quick Style to the chart. Select the Chart Design tab, if it is not selected already. In the Chart Styles group select Style 2.Create a PivotTable to summarize the average purchase price of different house types for each agent. Return to the Sales Data worksheet and click anywhere in the table. Click the Insert tab. In the Tables group, click the PivotTable button. Verify that the Table/Range: range is Table1 and click OK. Add the Agent field by clicking the check box in the Fields List pane. Add the Purchase Price field by clicking the check box in the Fields List pane. Select any cell in the Sum of Purchase Price column. On the PivotTable Analyze tab, in the Active Field group, click the Field Settings button. In the Summarize by area, select Average. Click OK. Add the House Type field to the PivotTable by clicking the check box in the Fields List pane. To summarize the house type data for each agent, use the House Type field as columns in the PivotTable. Click and drag the House Type field from the Values box to the Columns box in the PivotTable Fields pane.Add column Sparklines to the right of the PivotTable. Select cells B5:E9 to use as the data for the Sparklines. You do not want to include the grand total column or row. On the Insert tab, in the Sparklines group, click the Sparklines button and select Column. In the Create Sparklines dialog, verify that the cell range B5:E9 is listed in the Data Range box. Add the range G5:G9 to the Location Range box either by typing the cell range or by clicking and dragging to select it in the worksheet. Click OK.Create a PivotChart from the PivotTable. Select any cell in the PivotTable. On the PivotTable Analyze tab, in the Tools group, click the PivotChart button. Right-click the chart and point to Change Chart Type. Then point to Column and select Clustered Bar from the 2-D Bar section. If necessary, move the PivotChart to another part of the worksheet so it does not cover the PivotTable data.Use the data in the Loan Worksheet sheet to run a what-if scenario for a client to show loan payments for a variety of interest rates and loan lengths. This what-if scenario requires a two-variable data table. Go to the Loan Worksheet sheet and familiarize yourself with the formula in cell B5. Pay close attention to the cell references. Select cells B5:E25 to use the payment formula in B5 and the various years and rates as the data table. On the Data tab, in the Forecast group, click the What-If Analysis button, and click Data Table. In the Row input cell box, enter the cell reference for the length of the loan—the nper argument from the formula in cell B5: C2. In the Column input cell box, enter the cell reference for the loan interest rate—the interest argument from the formula in cell B5: A2. Click OK. (Data table values are inserted)Use Goal Seek to determine the most you can afford to borrow, on a $950 per month budget: On the Loan Worksheet sheet, select the outcome formula cell, H4. On the Data tab, in the Forecast group, click the What-If Analysis button and click Goal Seek... Verify that the outcome cell H4 is referenced in the Set cell box. Enter the outcome value of 950 in the To value box. Enter the input cell H9 in the By changing cell box. Click OK. Click OK again to accept the Goal Seek solution. Notice the loan payment changed to $950 and the amount to borrow was computed to be $206,395. Save and close the workbook. Upload and save your project file. Submit project for grading.

Assignment 3: Advanced Nurse Role Integration Final PresentationAssignment 3: Advanced Nurse Role Integration Final PresentationCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeAssignment Criteria10.0 ptsProficientAll criteria addressed. Information provided relates to the topic and includes supporting details, rationale, and/or examples.8.0 ptsCompetent1-2 criteria omitted and/or information provided did not relate to the topic or include supporting details, rationale, and/or examples.6.0 ptsAdequate3-4 criteria omitted and/or information provided did not relate to the topic or include supporting details, rationale, and/or examples.4.0 ptsNoviceGreater than 4 criteria omitted and/or information provided did not relate to the topic and did not include supporting details, rationale, and/or examples.10.0 ptsThis criterion is linked to a Learning OutcomeOrganization/Headings4.0 ptsProficientHeadings present and wording readable from 3 feet away design layout is neat and attractive; citation(s) present on slide, information logically organized according to the assignment criteria utilizing well-constructed bullet points.3.0 ptsCompetentHeadings not present and/or wording is not readable from 3 feet away and/or design layout is not neat and attractive and/or information not logically organized according to the assignment criteria utilizing well-constructed bullet points.2.0 ptsAdequateHeadings not present and wording not readable from 3 feet away. There is an attempt at organization, but errors exist.0.0 ptsNoviceHeadings not included and/or design layout is not neat and attractive and/or information not logically organized according to the assignment criteria utilizing well-constructed bullet points.4.0 ptsThis criterion is linked to a Learning OutcomeSlide Requirement2.0 ptsProficientAdhered to required number of slides and includes a title slide, purpose statement slide, introduction slide, conclusion slide, and reference slide1.0 ptsCompetentAdhered to required number of slides but omitted a title slide or purpose statement slide or introduction slide or citation(s) present on slide or conclusion slide or reference slide0.5 ptsAdequateDid not adhere to the required number of slides and/or did not include a title slide, purpose statement slide, introduction slide, a conclusion slide, and reference slide0.0 ptsNoviceDid not adhere to slide requirement or instructional rubric2.0 ptsThis criterion is linked to a Learning OutcomeSources2.0 ptsProficientAll references are from a relevant professional peer-reviewed scholarly journal, within a 5-year timeframe, or a classic/ historical source.1.0 ptsCompetentThe majority of references are from a relevant professional peer-reviewed scholarly journal, within a 5-year timeframe, or a classic/historical source.0.5 ptsAdequateSome references are from non-peer-reviewed scholarly sources or older than 5 years.0.0 ptsNoviceMajority of references are from non-peer-reviewed scholarly sources or older than 5 years.2.0 ptsThis criterion is linked to a Learning OutcomeResponses to Presentations (Online)2.0 ptsProficientFinal presentation posted on time and responded to the required number of presentations (not own) on the discussion board.1.0 ptsCompetentFinal presentation not posted and/or did not respond to the required number of presentations on the discussion board.0.0 ptsNoviceNo responses0.0 ptsNoviceNo responses2.0 ptsThis criterion is linked to a Learning OutcomeKaltura Media4.0 ptsProficientKaltura Media utilized0.0 ptsNoviceKaltura Media not utilized0.0 ptsNoviceKaltura Media not utilized0.0 ptsNoviceKaltura Media not utilized4.0 ptsThis criterion is linked to a Learning OutcomeAPA0.0 ptsAdequate0.0 ptsCompetent0.0 ptsNovice0.0 ptsProficientUp to 10% of the assigned points (total points of assignment) can be deducted from the earned points for errors in APA (title slide, reference slide, citations, format, spelling, or grammar).0.0 ptsTotal Points: 24.0Assignment 3: Advanced Nurse Role Integration Final Presentation (24 points):Review the instructions and grading rubric that follow this grid Submit the PowerPoint and Kaltura by posted due date ***Remember to attend to the SSS this week. Link located in Modules/Student Success Seminar***WEEKTOPICAL OUTLINEACTIVITIES AND ASSIGNMENTSWeek 8Course Wrap UpFinal assignment due End of course evaluationsComplete the course and instructor evaluations! Thank youWeek 8 Content Go to Modules on the Course Menu, click, and scroll down to Week 8 contentAssignment 3: Advanced Nurse Role Integration Final PresentationSubmit the Kaltura presentation to the Week 8: Discussion Board Posting-Advanced Nurse Role Integration Kaltura Presentation Monday of Week 8 by 11:59 PM/ESTRespond to one classmate’s presentations using the Record/Upload Media icon in CanvasComplete by Friday of Week 8 No reference requiredOnline Instructor and Course EvaluationsPlease complete the Course and Instructor EvaluationsLink sent in the NSU EmailThank you!Nova Southeastern University Ron and Kathy Assaf College of Nursing13NSG 5000: Advanced Nurse RolesActivities and Assignments5.2.19; 7.6.20 TMP, ASDiscussion Board Instructions and Rubric for MSN Online and Hybrid CoursesThe purpose of the Weekly Discussions is to develop a scholarly and dynamic exchange between students, faculty, and other students in the course promoting an active and engaging online learning community. Your success, and the success of your classmates in a positive learning environment, are dependent on discussion participation and timely completion of assignments.Use these guidelines and rubric for all discussion board postings. Each week begins on Monday at 12:01 AM/EST and ends on Sunday at 11:59 PM/EST. ***Initial postings cannot begin until Monday 12:01 AM/EST of each week. The instructor will delete any posts (initial postings and/or responses) made prior to the start of each week (Monday at 12:01 AM/EST). Tips for PostingAll writing and references must follow current American Psychological Association (APA) standardsPoints will not be deducted for font, italicizing, and indentation in the discussion boardThere are no “make-ups” for not posting to the Weekly DiscussionsAvoid postings that are limited to 'I agree' or 'great idea', etc. If you agree (or disagree) with a posting, then say why you agree (or disagree) by supporting your statement with topics from the readings or by bringing in a related example or experienceAddress the questions as much as possibleSynthesize the readings into your own words (you may use quotes and paraphrasing from the articles as needed) to support your postings. Expand on your insights and reflect on the material. Be sure to follow APA standardsBuild on other responses to create threadsGo back and look at the responses posted to your Initial Post. Your peers or the instructor may ask questions of you that you can answer as a Peer Response PostBring in related prior knowledge (work experience, prior coursework, readings, etc.) Use proper etiquette (address your peer by name, use professional language, etc.Assignment Criteria:Students will develop a PowerPoint presentation and Kaltura Capture addressing the following:1. Explain three topics learned within the course related to the role of the advanced practice nurse.a. Describe two reasons how the chosen topics impact the role of the advanced practice nurse. 2. Explain three topics learned within the course related to scholarship and evidence-based practice. a. Describe two reasons how the chosen topics impact the role of the advanced practice nurse.3. Explain three topics learned within the course related to standardized terminologies, informatics, and healthcare technology. a. Describe two reasons how the chosen topics improve outcomes.4. Formulate two strategies that can facilitate the successful transition into an advanced practice nurse role.5. Once the PPT is created, utilize Kaltura Capture to present the PPT with voice over (use computer and microphone). a. For presentation clarification, include presenter’s notes in the click to add section to explain the slide.6. Develop a recorded PPT presentation using Kaltura Capture in the form of a scholarly presentation. Follow the instructions for using Kaltura Capture located in Canvas under Modules then Kaltura Resources. 7. The PPT presentation should not be more than 12 slides (excluding the title slide and reference slide) and 8-10 minutes in length. Be complete and concise. Use bulleted statements not complete sentences or paragraphs.8. Use APA format for PPT, which always includes a title slide, purpose statement, a reference slide, and APA requirements. Resources found in APA 7th Edition Help Documents.9. Include three references for this assignment. References should be from scholarly peer-reviewed journals (check Ulrich's Periodical Directory) and be less than five (5) years old.10. Submit the Kaltura presentation to the discussion board Monday of Week 8. 11. Comment on one classmate’s presentations using the Record/Upload Media icon in Canvas by Sunday Week 8. 12. Submit both the PPT and the Kaltura presentation by posted due date.Include the following slides: Slide 1: Title-develop a title slide. This should include the title of the presentation, student name, course number and due date. Use APA format (does not need to be in Times New Roman for a PPT)Slide 2: Introduction-Draw audience into presentation. Use key bulleted points not paragraphs Slide 3: Purpose Statement-Develop the purpose statement utilizing the assignment criteria (use bulleted points)Slide 4: Explain three topics learned within the course related to the role of the advanced practice nurse.Slide 5: Describe two reasons how the chosen topics impact the role of the advanced practice nurse. Slide 6: Explain three topics learned within the course related to scholarship and evidence-based practice.Nova Southeastern University Ron and Kathy Assaf College of Nursing25NSG 5000: Advanced Nurse RolesActivities and Assignments5.2.19; 7.6.20 TMP, ASSlide 7: Describe two reasons how the chosen topics impact the role of the advanced practice nurse.Slide 8: Explain three topics learned within the course related to standardized terminologies, informatics, and healthcare technology. Slide 9: Describe two reasons how the chosen topics improve outcomes.Slide 10: Formulate two strategies that can facilitate the successful transition into an advanced practice nurse role.Slide 11: Conclusion-Include a summary of the main points. Again, utilize bulleted statementsSlide 12: References in APA format used for citations throughout the presentation. (include in-text citations on slides). References should be in APA formatAssignment 3: Advanced Nurse Role Integration Final Presentation Grading Rubric (24 points)Assignment Criteria/Quality/Accuracy of Information10 points8 points6 points4 pointsAll criteria addressed. Information provided relates to the topic and includes supporting details, rationale, and/or examples. 1-2 criteria omitted and/or information provided did not relate to the topic or include supporting details, rationale, and/or examples. 3-4 criteria omitted and/or information provided did not relate to the topic or include supporting details, rationale, and/or examples. Greater than 4 criteria omitted and/or information provided did not relate to the topic and did not include supporting details, rationale, and/or examples. Organization/Headings4 points3 points2 points0 pointsNova Southeastern University Ron and Kathy Assaf College of Nursing26NSG 5000: Advanced Nurse RolesActivities and Assignments5.2.19; 7.6.20 TMP, ASHeadings present and wording readable from 3 feet away design layout is neat and attractive; citation(s) present on slide, information logically organized according to the assignment criteria utilizing well-constructed bullet points.Headings not present and/or wording is not readable from 3 feet away and/or design layout is not neat and attractive and/or information not logically organized according to the assignment criteria utilizing well-constructed bullet points.Headings not present and wording not readable from 3 feet away. There is an attempt at organization, but errors exist.Headings not included and/or design layout is not neat and attractive and/or information not logically organized according to the assignment criteria utilizing well-constructed bullet points.Slide Requirement 2 points1 point0.5 points0 pointsAdhered to required number of slides and includes a title slide, purpose statement slide, introduction slide, conclusion slide, and reference slide. Adhered to required number of slides but omitted a title slide or purpose statement slide or introduction slide or citation(s) present on slide or conclusion slide or reference slide.Did not adhere to the required number of slides and/or did not include a title slide, purpose statement slide, introduction slide, a conclusion slide, and reference slide.Did not adhere to slide requirement or instructional rubric. Sources2 points1 point0.5 points0 pointsAll references are from a relevant professional peer-reviewed scholarly journal, within a 5-year timeframe, or a classic/ historical source.The majority of references are from a relevant professional peer-reviewed scholarly journal, within a 5-year timeframe, or a classic/historical Some references are from non-peer-reviewed scholarly sources or older than 5 years.Majority of references are from non-peer-reviewed scholarly sources or older than 5 years.Nova Southeastern University Ron and Kathy Assaf College of Nursing27NSG 5000: Advanced Nurse RolesActivities and Assignments5.2.19; 7.6.20 TMP, ASsource. Responses to Presentations2 points1 point0 pointsFinal presentation posted on time and responded to the required number of presentations (not own) on the discussion board.Final presentation not posted and/or did not respond to the required number of presentations on the discussion board.No responses Kaltura Media4 points0 pointsKaltura Media utilizedKaltura Media not utilizedEarned PointsUp to 10% of the assigned points (total points of assignment) can be deducted from the earned points for errors in APA (title slide, reference slide, citations, format, spelling, or grammar).Final Total

For the final project, you will write a proposal as an HR Consultant hired to assist in identifying a realistic action plan to address workforce issues facing the company in the Case Study.The proposal will be distributed at an executive meeting, where the presentation will be presented. You will be utilizing the previous course project assignments to create an 8-10 page written report (not counting cover and reference pages).In addition, you will created an 8-10 slide PowerPoint presentation action plan addressing a comprehensive action plan. Both the written report and the PowerPoint presentation should include:A summary of the current talent management system in place.An explanation of the current appraisal process and a suggested appraisal practice with a copy of the new performance appraisal recommendation.An Employee Development Plan for a high-potential, high-performing entry-level employee of the company in the Case Study. Your plan should include all elements of an employee development plan (also called an IDP).A recommended action plan addressing what impacts performance and what actions should be taken regarding employees that perform below expectations.The suggested on-going and future talent management program for the company - including recruiting, employee retention, and employee development.The action plan needs to flow as one continuous plan, rather than appear to be several plans combined. There should be a reference slide in APA format.The paper should demonstrate a strong thesis statement supported by research from at least 5 different sources. Include both in-text citations and a References page in APA format.