Working with Multiple Worksheets – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/working-with-multiple-worksheets/1/
   • Insert a new worksheet, and rename it Q1 Summary.
   • Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April.
   • Create a copy of the Expenses Summary worksheet by right-clicking . Do not just copy and paste the content of the worksheet into a new worksheet.
   • Change the color of the January tab to blue and the color of the February tab to red.
   • Group the worksheets September, October, and November.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_MultipleWorksheets.docx

25

25

You nailed it!

Using Find & Replace – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/using-find-replace/1/
   • Select the Challenge worksheet in the bottom-left of the workbook.
   • Crystal Lewis was married and changed her last name to Taylor. Use Find and Replace to change Crystal’s last name from Lewis to Taylor. Be careful to only change Crystal’s last name!
   • Find and replace Bio with Biology. Be careful not to change the major Biomedical Engineering!
   • Use Find and Replace All to replace the Physics major to Physical Science.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_FindAndReplace.docx

15

15

Checking Spelling – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/checking-spelling/1/
   • Select the Challenge worksheet in the bottom-left of the workbook.
   • Run the Spell Check to correct any spelling errors in the workbook.
   • Correct the words coffe and medum using the suggested spelling.
   • Ignore the spelling suggestion for the word Amanecer.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_Spelling.docx

15

15

Page Layout and Printing – Challenge activity

1. Follow the instructions given here
2. https://edu.gcfglobal.org/en/excel2016/page-layout-and-printing/1/
3. Provide a screen image of the following:
   • Select East Coast at the bottom of the workbook.
   • In the Page Layout tab, use the Print Titles feature to repeat row 1 at the top and column A at the left.
   • Using the Page Break Preview command, move the break between rows 47 and 48 up so it’s between rows 40 and 41.
   • In Backstage view, open the Print Pane.
   • In the Print pane, change the orientation to Landscape.
   • Change the margins to Narrow.
   • Change the scaling to Fit All Columns on One Page.
4. Put your name on the file and screen shot the document showing your name. Paste the screenshot into Word before saving as YourName_PageLayout.pdf. (Be sure to save it as a PDF file.)

45

45

 

1) Minimum 6 full pages (No word count per page)- Follow the 3 x 3 rule: minimum three paragraphs per part.

             Part 1: Minimum 4 pages

             Part 2: minimum 1 page

             Part 3: Minimum 1 page

            

Submit 1 document per part

2)¨******APA norms

          All paragraphs must be narrative and cited in the text- each paragraphs

          Bulleted responses are not accepted

          Don’t write in the first person 

          Don’t copy and paste the questions.

          Answer the question objectively, do not make introductions to your answers, answer it when you start the paragraph

Submit 1 document per part

3)****************************** It will be verified by Turnitin (Identify the percentage of exact match of writing with any other resource on the internet and academic sources, including universities and data banks) 

********************************It will be verified by SafeAssign (Identify the percentage of similarity of writing with any other resource on the internet and academic sources, including universities and data banks)

4) Minimum 3 references per part not older than 5 years

Part 1: Minimum 6 references per part not older than 5 years

5) Identify your answer with the numbers, according to the question. Start your answer on the same line, not the next

Example:

Q 1. Nursing is XXXXX

Q 2. Health is XXXX

6) You must name the files according to the part you are answering: 

Example:

Part 1.doc 

Part 2.do

__________________________________________________________________________________

Part 1: Trends and Issues in Health Care 

Examine changes introduced to reform or restructure the U.S. health care delivery system. Discuss action taken for reform and restructuring and the role of the nurse within this changing environment.

Include the following (Mandatory):

1. Outline a current or emerging health care law or federal regulation introduced to reform or restructure some aspect of the health care delivery system. 

2. Describe the effect of law or federal regulation on nursing practice and the nurse’s role and responsibility.

3. Discuss how quality measures and pay for performance affect patient outcomes. 

a. Explain how these affect nursing practice and describe the expectations and responsibilities of the nursing role in these situations.

4. Discuss professional nursing leadership and management roles that have arisen

a. How they are important in responding to emerging trends and in the promotion of patient safety and quality care in diverse health care settings.

5. Research emerging trends (2) in nursing. Predict two ways in which the practice of nursing and nursing roles will grow or transform within the next five years to respond to upcoming trends or predicted issues in health care.

Part 2: Ethical and Legal Aspect of Nursing Practice

Case Study, Chapter 16, Whistle-Blowing in Nursing

A student nurse asks a faculty member to explain whistle-blowing. The student nurse wants to know the work conditions that would have to be met before whistle-blowing occurs, as well as situations in which whistle-blowing is clearly indicated. The faculty member reviews key concepts with all members of the class.

Being a whistle-blower takes great courage and self-conviction because it requires the whistle-blower to avoid groupthink. 

1. Analyze how groupthink affects the process of whistle-blowing.

2. Discuss the pros and cons of whistle-blowing.

3. What are the key guidelines for blowing the whistle?

Part 3: Ethical and Legal Aspect of Nursing Practice

 

Case Study, Chapter 18, Academic Integrity in Nursing Education: Is it Declining?

A group of nursing students are in the middle of an exam when two students witness another student pull out his phone and look up answers. Neither student informs the faculty member but after the exam they discuss what they witnessed.

1. Describe the most common forms of cheating in the classroom and in the clinical area.

2. What should the nursing students do in regard to what they witnessed during the exam? 

3. Why is it important for them to do anything?

 Week 6 DiscussionCOLLAPSE

What Else Is Going On Out There?

Using the Wall Street Journal, or another reputable news source, locate and post an article published in the last 12 months about an organization undertaking a change initiative.

• What was the driver for the change?
• What was the nature and scale of the change initiative? 
  • Was it a change in leadership? Strategy? Structure? 
  • Did it impact the entire organization, or was it primarily focused on one region or business?
• Was the change initiative undertaken with a “people first” agenda? How can you tell?
• Is there any mention of steps taken during the change that indicate the use of a particular change model to support the initiative? Explain.
• What stage is the change at now? What wins have been secured so far, and what still needs to be dPost your initial response by Wednesday, midnight of your time zone, and reply to at least 2 of your classmates’ initial posts by Sunday, midnight of your time zone.  Please include references

1st response

Nat Simmons

 

What Else is Going on out There?

Uber has changed its UK-based operational model to reclassify drivers as workers. The decision was made after a Supreme Court ruling was made in favor of 35 drivers who had challenged the ride-hailing firm concerning their independent employment status. Since the last week of March 2021, the drivers would start receiving holiday benefits, a workplace pension, and a minimum wages guarantee (Strauss et al., 2021). The change is significant not only for Uber but for the entire industry, given that it put other brands that utilize self-employed models under pressure to follow suit. In addition, the change was only enacted in the UK, yet Uber is a global firm. Such a move is likely to cause drivers from other regions to demand similar treatment, affecting the entire operational model.

The change in structure and strategy implies that the firm must employ new terms and conditions for the drivers to facilitate business practices. Previously, the drivers worked at their convenience time, depending on their earning goals. However, if Uber is to offer employee privileges, a new structure in terms of working hours and shifts must be formulated to implement the strategy. The initiative was taken with a people-first agenda, given that it concerns the rights of the employees. The brand will be offering holiday benefits and minimum earning allowances.

The firm has already made steps to initiate the change. The holiday benefits will be based on 12.07 percent of the driver’s earnings, and Uber would be making pension contributions amounting to 3 percent of the earnings. According to Welch (n.d), one of the barriers to transformational organizational efforts is loss of focus and allowing business-as-usual to extend the time frame to get the initiative done. Uber countered the challenge by implementing the change immediately after the decision was communicated to the affected stakeholders. The change is in the actualization stage, given that it has been executed.

Strauss, D., Bradshaw, T., & Dempsey, H. (2021). Uber’s UK concessions change game for gig economy. Financial Times. https://www.ft.com/content/68718de3-b25f-47d6-8f51-4df1f66d8b1e

Welch, J. (n.d). Leading change by putting people first.  Jack Welch Management Institute.

2nd response

Mary  

As we learned this week, the larger the change initiatives, the more can go wrong (Kotter, 1). This week, the article I found was about Sara Greenstein of Lydell Incorporated:

This CEO Invested Millions to Increase N95 Face-Mask Supplies.

The article is from a series the WSJ highlights entitled “Personal Board of Directors.” The series focuses on CEOs and the other leaders they turn to for guidance and advice. As we have been discussing having guiding coalitions for change initiatives, the series brings light to the importance of having a personal coalition.

In 2020, the pandemic rapidly grew worldwide, spreading disease and death with it. Sara Greenstein was only months into her first CEO role when the world needed high levels of filtering products that only a few companies were producing. The company produced products for a wide variety of industries, including medical and automotive. Like many companies, Lydell began furloughing employees in less demanding areas and finding a way to survive. For Greenstein, the demand for the oil-derived textile nonwoven polypropylene increased, as it was a core component of N95 masks. After rolling old machines back onto the floor, the team did what they could to keep up with orders. By April, Greenstein knew change had to happen in the company to fulfill her professional and ethical obligations. Besides the furloughs, there were no major leadership changes to speak of, but the operational processes had to.

Without knowing how long the pandemic would last or how bad things would get, she knew that it was her duty to shift the company’s focus 100% to PPE and filtering materials. Although an internal need for change wasn’t the driver, but the company put “people first” in the truest sense (the public and its health). After securing a 40 million dollar investment, Greenstein had to convince the board that the change must happen. Lydell expanded its New Hampshire and French production locations. This means workers had to be hired and retrained if they worked in other facets of the business.

There is no mention that I can find so far regarding her specific change steps; however, the sense of urgency and vision were made clear from the beginning. With thousands of people dying globally, workers likely knew the gravity of the power they held. From there, it was making sure the right people were in the right places to grow accordingly. The HR team would need to work closely with her to make sure onboarding processes would be informative and get new workers up and running immediately.

The change efforts have proved successful so far. As of last June, the company was positioned to produce enough material for 125 million N95 masks per month. Today, Greenstein works with President Biden on producing enough PPE to have stockpiles for future medical crises (Clifford). Greenstein depended on her advisors to guide her decisions, making sure she was considering more than just profitability. During times of duress, it’s important to have your own group of guides to keep you on track to see challenges clearly, with people at the center.

Resources:

1. Kotter, J. (2012) Leading Change. Harvard Business Review Press.
2. Hufford, A. (2021) This CEO Invested Millions to Increase N95 Face-Mask Supplies. Wall Street Journal
3. Clifford, T. (2021). Lydall CEO expects demand boom for filtration material used in N95 masks and indoor systems beyond the pandemic. Mad Money.

 Primary Task Response: Within the Discussion Board area, write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

Accurate coding and billing are essential to a health care facility and to a physician’s financial survival. Coding is a complex task that ties to charges and revenue generation. Failure to capture all charges associated with a patient encounter can result in significant revenue loss. Medical necessity also plays a vital role in the contract with the facility or physician in terms of receiving payment from the third-party payer (e.g., an insurance company).

Part 1

For this Discussion Board, define the term medical necessity, and describe the criteria to determine it.

Part 2

Once the patient has an established diagnosis and the services and procedures have been ordered, they will be assigned codes and placed on the claim for payment.

It is important for health care professionals to understand this process to receive accurate reimbursement. Consider the following questions:

• Why is it important to assign the correct codes to the diagnoses, services, and procedures that a patient has received?
• What are the repercussions of submitting incorrect coding and billing errors to the third-party payers?