Assignment 2: Expenses Worksheet in Excel

Before beginning this assignment, you should thoroughly review Excel Worksheets, Charts, Formulas, Functions, and Tables from your course textbook, Go! All in one: Computer concepts and applications.
 
For this assignment you will use Microsoft Excel to develop a worksheet that details your personal expenses in at least four categories from the last three months. Some of these expense categories might include, but are not limited to, Mortgage, Rent, Utilities, Phone, Food, Entertainment, Tuition, Childcare, Clothing, and Insurance. (These numbers may be fictitious.)

Part 1: The Spreadsheet

• Begin by opening a new Microsoft Excel file. (You may use the template found here.)
• Save it as LastnameFirstInitial_M3_A2
• Use Rows 1 and 2 for a title.
• Beginning in row 4, use column A to list your different expenses.
• Label the next three columns (B, C, D) for the past three months.
• Fill in the appropriate amount for each expense for each month.
• Beside the column with your third month’s entries, create another column for totals for each category.
  • Use a formula to calculate a total for each category of expense. 
• In the row below your last expense entry, create another row for the monthly totals of expenses.
  • Use a formula to calculate a total for each month of expenses.
• Beside the column add another column for calculating the percent of the budget for each expense category.
  • Use a formula to calculate the percent that each expense category is of the total expenditures.
• Format the worksheet by adjusting column widths and wrapping text, and by applying appropriate financial number formatting and cell styles. 

Please Note: While some calculations might be easy to do in your head or using a calculator—merely typing the answer into the appropriate cell—the point of this assignment is to get you accustomed to using formulas. In situations requiring frequently updated data or more complex calculations, Excel is a very powerful tool if you know how to use it. Your grade is based on your demonstrated ability to use the required formulas.

Part 2: The Chart

Below your table of monthly expenses, you will create a chart using the numbers from your spreadsheet similar to the example below.

• Open the Insert ribbon at the top of the screen.
• Click on a populated cell inside your spreadsheet, then, click on Column on the Insert ribbon. Select the style of column chart you like. 
• Click and drag your column chart into position below your spreadsheet.

Save your file as LastnameFirstinitial_M3_A2.xls. Submit this document to the Submissions Area by the due date assigned.

Suggested challenge for intermediate users: Add a row or rows detailing your income and subtract the total expenditures from the total income.

Suggested challenge for advanced users: Use a formula, function, or combination of both to show your net gain or loss (income minus expenses summed over time) for the three-month period.

400-600 words APA 6 format, 2 cited sources- more can be used if needed. Provide sources used.

As a health care manager, you will be involved in strategic management. Discuss the following in regard to this:

• Does strategic management involve long-term or short-term activities?
• Describe how strategic management helps your facility control the future.

*NOTES FROM PROFFESOR*

While the first question may seem more “yes or no” in nature, it is also a point that you can expand upon using the knowledge from this course.  The Learning Materials in Unit 3 have a specific section dedicated to strategic management that might be helpful in expanding upon this first prompt.  Identifying examples of both long term and short terms strategic activities can also demonstrate knowledge of the subject area.  

For the second prompt, you can also consult the course materials.  Feel free to bring in real-life examples or references from outside of your course materials to support your ideas.  For instance, as a manager I can say that strategic management has helped me in many ways control the trajectory of my department and my employees in the context of a larger organization.  Being involved in a strategic management plan helps me grow my department, budget for the future, and inform and train my personnel.  When you are responding to peers, reflect on what their experiences might be with strategic management and looks for both similarities and differences to your own experience and those you have read about in the course materials. Strategic management is concept that is not seen just in healthcare; it used across the entire business world to help manage and grow companies for the future.  Even not-for-profits use them to help define their missions, goals, and vision for the future.

 
1 postsRe: Topic 4 DQ 2

The Affordable Care Act (ACA) was put into effect in 2010, it is also referred to as Obama Care. The goal was to make insurance more accessible to those who were previously unable to afford insurance coverage. The ACA prevented insurance companies from denying coverage to people with pre-existing conditions, and it changed the age a child to stay on their parents plan to 26, it also removed benefit limits on insurance, and made preventative care at no cost service to the patient.

The most important role is to provide coverage for all citizens. It allows people to obtain care and not have high out-of-pocket costs. It promotes primary prevention through preventative care. The system also rewards people for having health coverage. Patients are rewarded through tax breaks for providing proof of coverage each year, and physicians are rewarded for meeting goals in patient care.

As a nurse it is our responsibility to make sure patients are properly educated on the services available to them. We can promote primary prevention, through education. We must advocate and provide them the knowledge to make appropriate health decisions and to take initiative of their own care to prevent any unnecessary medical expenses.

Using 200-300 words APA format with references to support the discussion.

 What are the most important elements of the Affordable Care Act in relation to community and public health? What is the role of the nurse in implementing this law? 

  

  

Part I

Please define and give the historical significance/importance of each identifications(IDs) and include the information below each.  Use only the provided reference materials.   Due 4 May at 11:59 PM

· Brown vs. Board of Education (1954) 

– “Doll Babies”

· NAACP 

· Civil Rights Act (1964)

– Significance, 

-we do not discriminate based on…, 

· War on Poverty 

– 1 of 4 in poverty

– 1) , 2)School lunch programs, 3)Food stamps, Medicare

– 1960 $25B spent on poverty, 1970 $60B spent and both still averaged $250 per person

· Sputnik 

– Explorer 1 1958(scared Americans)

– How longe before Nuclear bombs hit America

– Bomb shelters was built

– NASA was created

– $400M invested in Math and Science

· “Watergate”

– Plummer’s worked at WH

– Woodword & Brunsteen started to investigate

– Argibal Cox took Nixon to Court(fired by Nixon)

– Nixon wouldn’t turn over tape 

– Congress files for impeachment, 1) Obstruction of Justice, 2) violated……, 3)Contempt of Congress

· Gulf of Tonkin resolution 

– USS Maddox is attacked

– CIA

– Resolution passed(Senate 88-2)(House 416-0); gsve president authority to protect forces and prevent …

– LBJ quote

– Brought us deeper into Vietnam

· Yalta Conference (1945)

– Stallin promised free elecctions for Poland and Eastern Europe(he reniged on promise)

· Cuban Missile Crisis (

-October U2 fly over

-JFK gets pics

-Orders blockade that was called quarantine

-JFK get on Radio and said we will respond

-Back and Forth on phone with Russia, Russia blinked

-Closest we ever been to a nuclear war

· SALT I/II1972/78)- froze the number……

-Example of detaunt 72-79

– what is SALT

-SALT I Nixon/Breznew

-SALT II Carter/Reznet(not ratified by Congress because of distrust of Russia/giving up to much)

-Carter/Regan did follow guidelines

INF Treaty(Intermediate Nuclear Forces.

Part II (at least 2 pages)

Essay: Answer the following questions in a clear and coherent essay. Be sure to include specific examples from lectures and readings.

b. Civil Rights in the Twentieth century began to gain momentum in the 1950s with the Brown vs. Board of Education decision of the US Supreme Court. Discuss the importance of this decision, as well as other civil rights legislation, in terms of events that occurred in the 1950s and 1960s. What is the significance of the year 1965 in American civil rights? Get specific and offer numerous examples to support your argument.

Include:

· NAACP-1909(IDs)

· CORE – 1942 Congress of Racial equality

· SCLC – 1955 Southern Christian Leadership

· SCC – 1960 – Student Non-Violent Coordinating Committee

· Emmitt Till

· Watts, CA 1964

· 1966 –There are 43 riots, worst are from Chicago and Cleveland

· 1967 – 8 Major Riots, Worst was Detroit. 43 people killed, 33 Black

· “White Flight” – get out of city and went into suburbs.

· Malcolm X(killed in 1965

· Rodney King

· Civil rights act of 1964(ID)

· Brown vs Board of Education(ID)

 Instructions: Read the following case study and answer the reflective questions. Please provide  rationales for your answers. Make sure to provide citations/references for your answers in APA  format. 

  CASE STUDY: Active Labor: Susan Wong Mrs. Wong, a first-time mother, is admitted to the birthing suite in early labor after spontaneous rupture  of membranes at home. She is at 38 weeks of gestation with a history of abnormal alpha-fetoprotein  levels at 16 weeks of pregnancy.  She was scheduled for ultrasonography to visualize the fetus to rule out an open spinal defect or Down  syndrome, but never followed through. Mrs. Wong and her husband disagreed about what to do (keep  or terminate the pregnancy) if the ultrasonography indicated a spinal problem, so they felt they did not  want this information. 

Reflective Questions

 1. As the nurse, what priority data would you collect from this couple to help define relevant interventions to meet their needs? 

2. How can you help this couple if they experience a negative outcome in the birthing suite? What are your personal views on terminating or continuing a pregnancy with a risk of a potential anomaly? What factors may influence your views? 

3. With the influence of the recent Human Genome Project and the possibility of predicting open  spinal defects earlier in pregnancy, how will maternity care change in the future