SWOT Analysis SWOT Analysis for Strategic Plan for Unmet Social Needs of Adults Suffering from Mental Illness Ivy Garrett Walden University NURS 6241-5: Strategic Planning in Health Care Organizations April 12, 2020 SWOT Analysis Frequent visitors to the psychiatric emergency room are a small subgroup of patients, but they are responsible for many visits and thus demand significant resources. Their needs are often left unmet, and their frequent visits reflect their frustration as well as that of psychiatric emergency room staff (Schmidt, 2018). SWOT Analysis The SWOT Analysis is used to make the most of the tools that a company has at its fingertips and to their full advantage. SWOT analysis can help to reduce the chances of failure, to understand what is lacking, and to eliminate the hazards that would otherwise be hidden (MindTools.com, 2020). Strengths The strengths that were identified for the unmet social needs of the mentally ill adult are: • Adequate knowledge of the mental health population • Several studies conducted to address unmet social needs of the mental health population These strengths are essential to this project because the adult mental health population has been a widely studied topic for several years. Weakness The weakness of the course project: • Limited access to mental health treatment. • Data may be difficult to obtain due to patients’ unwillingness to participate. Among people seeking mental health care, access to face-to-face services is a higher priority than access to medication. Ninety-six million Americans had to wait for psychiatric health care for more than a week. And almost half of Americans had to or met someone who SWOT Analysis had to travel to receive treatment for more than an hour round trip (National Council for Behavioral Health, 2020). Individuals living in rural areas are less likely than people residing in urban and suburban areas to proactively pursue mental health services they need and go to their primary care provider or neighborhood treatment center. Rural Americans still have less knowledge of mental health and treatment programs (National Council for Behavioral Health, 2020). Opportunities The opportunities for the course project: • Focuses on prevention and promotes mental health across the lifespan, • Brings together individuals, communities, and a variety of systems (health, human services, schools, etc.) to work collaboratively toward better mental health for all. The Mental Health Gap Action Program emphasizes both the development of political commitment and policies and appropriate clinical interventions. Providers are developing alliances to close the gap to improve the physical and mental health of their patients and to reduce the cost of healthcare (Finnegan, 2016). Threats The threats of course project: • Lack of cooperation from other outside agencies • Lack of funding Intervening, at the first sign of symptoms, offers the best opportunity to make a significant, positive difference in both immediate and long-term outcomes for people affected by mental health issues (Watson, 2013). SWOT Analysis Services are not enough to meet the needs of people later in life. Attention should be paid to identifying and engaging older patients who require behavioral support services. Older adults require different treatment responses and support, such as transportation, home-based treatment options, and specialized outreach efforts (Watson, 2013). Conclusion SWOT analysis, a preliminary decision-making technique, is one of the strategic planning tools that help institutions managers assess the strengths, weaknesses, opportunities and threats of any business enterprise. The objective of the SWOT analysis is, firstly, to assess environmental opportunities and threats and, secondly, to assess the system’s internal strengths and weaknesses. The SWOT model offers a systematic framework for recognizing these factors and for selecting a strategy to determine the best symmetry between them. SWOT Analysis References Clay, R. (2009, June). Bridging the treatment gap. Retrieved from American Psychological Association: https://www.apa.org/monitor/2009/06/treatment Finnegan, J. (2016, February 23). Discussion: Evaluation Plan

How primary care providers can bridge the mental health gap for patients. Retrieved from Fierce Healthcare: https://www.fiercehealthcare.com/practices/how-primary-care-providers-can-bridgemental-health-gap-for-patients Mindtools.com. (2020). SWOT Analysis How to Develop a Strategy for Success. Retrieved from Mindtools: https://www.mindtools.com/pages/article/newTMC_05.htm National Council for Behavioral Health. (2020). New Study Reveals Lack of Access as Root Cause for Mental Health Crisis in America. Retrieved from National Council for Behavioral Health: https://www.thenationalcouncil.org/press-releases/new-study-revealslack-of-access-as-root-cause-for-mental-health-crisis-in-america/ Schmidt, M. (2018, March). Frequent visitors at the psychiatric emergency room – A literature review. . Retrieved from NCBI: https://www.ncbi.nlm.nih.gov/pubmed/28353131 Watson, L. (2013, October). Comprehensive Gap Analysis of Behavior Health Services. Retrieved from DPBH.NV.gov: http://dpbh.nv.gov/uploadedFiles/04%202013-1011_BehavioralHealthGapsAnalysisReport.pdf Welcome Make your first PivotTable PivotTables are not as hard as you think. After you walk through these simple steps, you’ll know how to quickly create one. Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN. What is a PivotTable? In its most basic form, a PivotTable takes data and summarizes it so you can make sense of it, all without typing any formulas! What is a PivotTable? its are most form, a PivotTable takes data and summarizes soeach you can Cells B10 through E17 contain Data. In There four basic columns: Date, Buyer, Type, and Amount. Each column has various valuesitfor row. Cells H10 through PivotTabletyping which summarizes the data. The PivotTable has two columns: Buyer and Sum of Amount. The Buyer column contains the values Dad, Mom, Kelly, and Grand Total; The Sum of Amount column contains the values $20, $544, $270, and $834. make senseI14ofcontain it, all awithout any formulas! To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial This simple PivotTable summarizes the data. This is data. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Buyer Sum of Amount Dad $20 Mom $544 Kelly $270 Grand Total $834 Feedback Page 2 of 35 That was a simple example. Here’s a more sophisticated one. This one shows the spending amounts broken down by type of purchase and by buyer. That was a E17 simple Here’s a more sophisticated ThisEach one shows the spending Cells B10 through containexample. Data. There are four columns: Date, Buyer, Type, andone. Amount. column has various values for each row. Cells G10 through K18 contain a more PivotTableand whichby summarizes amounts broken down by sophisticated type of purchase buyer. the data. The PivotTable has five columns: Type, Dad, Kelly, Mom, and Grand Total. The Type column contains the values Books, Food, Fuel, Music, Sports, and Tickets. The Dad, Kelly, and Mom columns contain various dollar amounts, and the Grand Total column contains the total dollar amounts for each Type. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial A more sophisticated PivotTable Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Sum of Amount Buyer Type Dad Kelly Mom Grand Total Books $125 $125 Food $470 $470 Fuel $74 $74 Music $20 $20 Sports $20 $20 Tickets $125 $125 Grand Total $20 $270 $544 $834 Feedback Page 3 of 35 nd Total. The Type column contains the values Books, Food, Fuel, Music, Sports, and Tickets. The Dad, Kelly, and Mom columns contain various dollar amounts, and the Grand Total column contains the total dollar amounts for each Type. Page 4 of 35 There are also PivotCharts, which are a more visual way to summarize and make sense of the data. We won’t be covering these, but for now, just know that they’re possible to do. There are also PivotCharts, which are a more visual way summarize and senseforofeach therow. Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and to Amount. Each column has make various values Todata. the right of the data isbe a PivotChart which summarizes and now, visualizes theknow data. Tothat selectthey’re it, press ALT+H, FD, P.to Then use your arrows keys to move to PivotChartExample and press Enter. When you’re done, press CTRL G, type A4, then Enter. We won’t covering these, but for just possible do. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial This PivotChart summarizes and visualizes the data. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Sum of Amount Column Labels Tickets Row Labels Dad Sports Books Music Food Fuel Fuel Music Food Sports $20 Books Tickets $0 Total $100 $200 $300 Grand $20 Kelly Mom Grand Total $125 $125 Dad $470 $470 $74 $74 Kelly $20 $20 Mom $20 $125 $125 $400 $544 $500 $270 $834 Feedback Page 5 of 35 But let’s back up. The first step to making a good PivotTable is to make sure the data is in good shape. So, make sure you do the following before you make one: Cells But B10let’s through back E17 contain up. The Data.first Therestep are four tocolumns: making Date, a good Buyer, Type, PivotTable and Amount. is to Eachmake columnsure has values, the data no duplicates, is in good and no blanks. There is a label the columns thatthe says,following “Name your columns.” is also a label shape. So,pointing maketosure you do before There you make one:pointing to the rows that says, “And make sure there are no duplicate rows, or blank cells.” To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial Name your columns. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 And make sure there are no duplicate rows, or blank cells. Feedback Page 6 of 35 Something to keep in mind: Lots of people use the word “column.” But to a PivotTable, a column is a “field.” Remember this as you progress with the tutorial. Something tocontain keepData. in mind: of people the word column. Discussion: Evaluation Plan

But to ahas PivotTable, a to column is “Field.” Cells B10 through E17 There areLots four columns: Date,use Buyer, Type, and Amount. Each column a label pointing it that says GOOD TO KNOW: Why the word “field”? a traditional term usedthe when working with data and database applications. The PivotTable menus and buttons use the word “field” a lot. So if you get used to it now, it will make things easier as you make PivotTables. a field. Try to remember this It’s asjust you progress with tutorial. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial Field Field Field Field GOOD TO KNOW Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Why the word “field”? It’s just a traditional term used when working with data and database applications. Amount $74 $235 $20 $125 $235 $20 $125 The PivotTable menus and buttons use the word “field” a lot. So if you get used to it now, it will make things easier as you make PivotTables. Previous Next Feedback Page 7 of 35 Let’s focus on one of the fields. One of the fields below, the Amount field, is probably the most important. Wouldn’t it be great if it was summed up? Cells B10 through There are four One columns: Buyer, Type, and Amount. The Amount column has a label pointing to it that says “This field should be summed up.” Let’s focusE17 oncontain one Data. of the fields. of Date, the fields below, the Amount field, is probably the most To important. continue with this tutorial, press go to the previous Wouldn’t it beCTRL+PAGE great ifDOWN. it wasTosummed up? sheet, press CTRL+PAGE UP. Give feedback on this tutorial This field should be summed up. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Previous Next Feedback Page 8 of 35 So we did that. We summed up the Amount field with a PivotTable. (Really?) Yes. Sum of Amount and $834 make up a small PivotTable that totals up the Amount field. SoB10 we did E17 that. WeData. summed Amount field with a PivotTable. (Really?) Yes. Sum Cells through contain There areup fourthe columns: Date, Buyer, Type, and Amount. Each column has various values of for Amount each row. Cells H10$834 and H11 contain a PivotTable totals the that Amount column. PivotTable has field. one column: Sum of Amount. And that column only has one value: $834. There is a label pointing to the PivotTable that says, “It may not look like much, but this is a PivotTable.” and make up a small which PivotTable totals upThe the Amount To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial It may not look like much, but this is a PivotTable. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Sum of Amount $834 Feedback Page 9 of 35 Why makemake such a small PivotTable? it emphasizes the concept of a PivotTable value If one of in your data contains numeric values, a PivotTable can total it up. When it does this, it’s called a PivotTable value field. Why such a smallBecause PivotTable? Because it emphasizes the field. concept ofthe a fields PivotTable value Cells B11 through E18 contain Data. Discussion: Evaluation Plan

There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row. There is a label pointing to the Amount column that says, “This field contains numeric values…” field. one the afields in your contains numeric a has PivotTable it up. When it only has one value: $834. There is a label pointing to the PivotTable that says, “…and this PivotTable made it into a ‘value field.'” Cells H11 If and H12 of contain PivotTable which data totals the Amount column. Thevalues, PivotTable one column:can Sum total of Amount. And that column this, PivotTable Todoes continue withit’s thiscalled tutorial,apress CTRL+PAGEvalue DOWN.field. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial …and this PivotTable made it into a value field. This field contains numeric values… Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Sum of Amount $834 Previous Next Feedback Page 10 of 35 PivotTables start getting interesting when you add conditions that divide or break down the value field. In this case, we added a new condition of Buyer to divide the value field. PivotTables start getting interesting when you add conditions divide or break down the Cells B11 through E18 contain Data. There are four columns: Date, Buyer, Type, and Amount. Eachthat column has various values for each row. Cells H11 through I15this contain a PivotTable which summarizes the data. The hasdivide two columns: Buyer and Sum of Amount. The Buyer column contains the values Dad, Kelly, Mom, and Grand Total; the Sum of Amount column contains the values $20, $270, $544, and $834. There is a label pointing to the Buyer column that says, “We added a condition here to divide the value field by ‘Buyer.'” There is also a label that points to the Sum of Amount column that says “Value field.” value field. In case, we added a new condition ofPivotTable Buyer to the value field. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial We added a condition here to divide the value field by Buyer. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Value field Buyer Sum of Amount Dad $20 Kelly $270 Mom $544 Grand Total $834 Previous Next Feedback Page 11 of 35 And here’s another version of the PivotTable, but this time we added the condition of Type to see how much was spent for each type of purchase. And here’sE17another version of columns: the PivotTable, but time added thevalues condition of Cells B10 through contain Data. There are four Date, Buyer, Type, and this Amount. Eachwe column has various for each row. Cells H10 through contain a PivotTable summarizes the data. Theof PivotTable has two columns: Type and Sum of Amount. Discussion: Evaluation Plan

The Type column contains the values Books, Food, Fuel, Music, Sports, Tickets, and Grand Total; the Sum of Amount column contains the values $125, $470, $74, $20, $20, $125, and $834. There is a label pointing to the Type column that says, “We added a condition here to divide the value field by ‘Type.'” There is also a label that points to the Sum of Amount column that says, “Value field.” Type to seeI17how much waswhich spent for each type purchase. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial We added a condition here to divide the value field by Type. Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Value field Type Sum of Amount Books $125 Food $470 Fuel $74 Music $20 Sports $20 Tickets $125 Grand Total $834 Previous Next Feedback Page 12 of 35 Another PivotTable term: The conditions we’ve added so far are called PivotTable row fields. In these examples, the row field breaks down, or divides, the value field. Another PivotTable term: conditions we’ve added soAmount. far are called rowforfields. In Cells B10 through E17 contain Data. ThereThe are four columns: Date, Buyer, Type, and Each columnPivotTable has various values each row. Cells H10 through I14 contain PivotTable summarizes The PivotTable has two columns: Buyer, and Sum of Amount. The Buyer column contains the values Dad, Kelly, Mom, and Grand Total; the Sum of Amount column contains the values $20, $270, $544, and $834. There is a label pointing to the Buyer column that says, “Row field.” There is also a label that points to the Sum of Amount column that says “Value field.” these examples, the arow field which breaks down,the ordata. divides, the value field. To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP. Give feedback on this tutorial Row field Date 01-Jan 15-Jan 17-Jan 21-Jan 02-Feb 20-Feb 25-Feb Buyer Mom Mom Dad Kelly Mom Kelly Kelly Type Fuel Food Sports Books Food Music Tickets Amount $74 $235 $20 $125 $235 $20 $125 Value field Buyer Sum of Amount Dad $20 Kelly $270 Mom $544 Grand Total $834 Feedback Page 13 of 35 Let’s review. You’ll learn how to actually make a PivotTable in a few moments. But let’s review the concepts we’ve t …Discussion: Evaluation Plan