Excel Graded Project

Introduction
This project requires you to develop a spreadsheet that tracks the cost of elementary school supplies distributed to teachers over a two-month period. You’ll assume the role of Office Manager, who has multiple responsibilities, including distributing and maintaining classroom supplies. For this project, you must prepare an Excel spreadsheet and chart that will be sent to the school District Manager.

Create a Spreadsheet
1. Start Excel and create a blank workbook.
2. Enter the data shown in the following table and then format, sizing columns as necessary and right-aligning all number values. Save your file, naming it School Supplies.
3. Merge and center cells A1 through H1. Format the school name as Title style.
4. Merge and center cells A2 through H2. Format the label as Heading 1 style.
5. Bold the labels in row 4 and right align the labels above the numeric values.
6. Format the Cost/Unit values as Currency with 2 decimal places. Your spreadsheet should look like the figure below.
7. In column D, enter appropriate formulas to calculate the September costs for each school supply. Your formulas must use cell references. Format the calculated values as Currency with 2 decimal places.
8. In cell A16, enter the label “Grand Total” and format it as bold.
9. In cell D16, enter a formula that uses a function to calculate the total of the column.
10. In column E, enter formulas that calculate the percentage of the grand total for each type of school supply (total cost of each item divided by the grand total). Your formulas must use appropriate absolute cell references. Format the calculated values as Percentage with 0 decimal places.
11. In cell E16, enter a formula that uses a function to calculate the total of the column (it should total 100%).
12. Repeat the process you used in steps 7–11 to calculate values for October.
13. Sort the school supplies alphabetically. (Be sure to select cells A5:H14 to sort the entire row of data.) Your spreadsheet should look similar to the figure below.
14. Save the modified spreadsheet.

Create a Chart
1. Create a chart by first selecting the cell ranges for the chart. Drag from cell A4 to A14 to select the range and then press and hold the Ctrl key while you drag from cell D4 to D14. Continue to press and hold the Ctrl key while dragging from cell G4 to G14. Your selected cells should look like the figure below.
2. Insert a 3-D Clustered Column chart.
3. Change the chart title to read “Cost of Supplies.”
4. Position the chart with the upper-left corner in cell A18 and then size the chart until it extends to column H, as shown in the figure below.
5. Put the following information into cell A41:
Your name
Your email address
Your student number
The course name and number
Project number (584042)
6. Save and close the workbook.

DATA WILL BE GIVEN IN UPLOADED IMAGES

Review the Focused Note Checklist provided in this week’s Learning Resources and consider how you will develop your Focused Note for this week’s Assignment.

To prepare:

Review the Focused Note Checklist provided in this week’s Learning Resources and consider how you will develop your Focused Note for this week’s Assignment.
Use the Focused SOAP Note Template and the example found in the Learning Resources for this week to complete this Assignment.
Select an adolescent patient that you examined during the last 3 weeks. With this patient in mind, address the following in a Focused Note.
Assignment

Subjective: What details did the patient or parent provide regarding the personal and medical history? Include any discrepancies between the details provided by the child and details provided by the parent as well as possible reasons for these discrepancies.
Objective: What observations did you make during the physical assessment? Include pertinent positive and negative physical exam findings. Describe whether the patient presented with any growth and development or psychosocial issues.
Assessment: What were your differential diagnoses? Provide a minimum of three possible diagnoses. List them from highest priority to lowest priority and include their ICD-10 code for the diagnosis. What was your primary diagnosis and why?
Plan: What was your plan for diagnostics and primary diagnosis? What was your plan for treatment and management? Include pharmacologic and non-pharmacologic treatments, alternative therapies, and follow-up parameters as well as a rationale for this treatment and management plan.
Reflection notes: What was your “aha” moment? What would you do differently in a similar patient evaluation?

This is the patient that I examined. I have attached a sample form to use. I also have the diagnoses already it just needs articles pertaining to the diagnoses only.
patient Initial: US Age 16-year gender female race AA
CC: Well child check
HPI: The patient is a 16y old female who came in today for a well-child visit. The patient does live with her parents. she endorses having some migraine periodically. Endorse exercising by participation in sports activities and denies any chest pain on exertion. No history of a sports injury or concussion. Denies smoking, alcohol use, and recreational drugs. Endorse having her menses regularly every 4 weeks and lasting 4-5 days. She denies being sexually active. she reports sleeping well with no issues. No recent significant weight loss or gain. Does have good eating habits, a well-balanced diet, and adequate fluid. Personal social: appropriate behavior, hobbies/sports, best friend, group activities, appropriate interaction, no gang involvement, no risky behavior identified. The child does have a good support system and extended family involved, including father, involve, and grandparents. Both parents work. No fire gun at home.
The patient gets along well, has no stress, has good concentration, has no abrupt mood changes, has a good level of energy, good motivation, no feeling of guilt or isolation, does not carry a weapon, is not depressed, has no thought or history of violence. NKDA. PMHX Acute bronchitis, Dysmenorhea, Migraine without aura and status migrainosus, notintactable
no current medication

Objective: T 97.8 WT 133LB 12OZ HT 5FT 3 IN BP 127/76 P 76
General appearance: alert, Active well nourished
Skin: normal, no skin lesions, no tattoos, no scars
Head: normocephalic, atraumatic
Eyes: red reflex present bilaterally, extraocular movements intact, no eye discharge
Ears: Bilateral TM normal color, canals normal
Nose: nare patent and clear, mucosa normal
Oral cavity/throat: moist mucus membranes, no lesions, throat normal, palate normal
neck: supple, no lymphadenopathy, thyroid normal
chest: normal contour good expansion, symmetric
Heart: regular rate and rhythm, normal S1S2, no murmurs, normal peripheral pulses
Lungs: Clear to auscultation, equal breath sounds bilaterally
Abdomen: soft, non-tender, no masses, normal bowel movement
Genitalia: normal external genitalia
Extremities/back: hip exam normal with no clicks, normal exam of the spine, moving all extremities equally.
Neurologic exam: normal tone and motor development, no abnormal reflexes

Assessment: Encounter for routine child health examination without abnormal findings Z00.129
Immunization – Z23
Migraine without aura and without status migrainosus, not intractable G43.009

Plan: Start Rizatriptan Benzonate Tablet, 5 MG, 1 Tablet, twice a day, 10 days, 20 tablet 1 refills
Hearing screen done and normal bilaterally. Vision screening done and 20/20

Menveo 0.5 ml IM given
Meningococcal B 0.5 ml IM given

Lab: Quantiferon-TB Gold plus, CPM, CBC With diferential/ platelet, Lipid panel done
Patient counsel on healthy food choices, regular exercises. counseled on self breast exam. oral hygiene and dental appointment. safe sex , sexual transmitted diseases education, use of condoms, birth control. skin/UV protection. smoke exposure. Drivers education discussed driving under the influence of alcohol/ drugs, obeying driving rules. RTC in a year or as needed.

IMMUNIZATION: Dtap 11/30/2010 . Gardasil 9 01/22/2021 and 07/22/2020 Hep A 01/19/2011 IPV 11/30/2010 Meningococcal 03/08/2023 Menveo 03/03/2023 and 07/23/2019 MMR 11/30/2010
Tdap- Adacel or Boostrix 07/23/2019 Varicella 11/30/2010

Identify a central idea that emerges throughout the poems and through your analysis, describe how the background, time period and historical context shape the poet’s world view.

Hi! I already have my poet, poems, and thesis. I selected William Shakespeare and the three poems I’ve selected are sonnet 57, 147, 133. And the thesis is William Shakespeare demonstrates love as a dark power that traps and intoxicates the person in love. The historical background which shapes the poets writing needs to be a few sentences in the intro.

Discussion Thread: Counseling Those Who Suffer

Your human services counseling clients will come to you suffering at one level or another. The Learn materials from the last two modules discuss the concept of suffering and factors guiding how to counsel those who are suffering. In fact, a careful analysis of the Learn materials indicates numerous concepts and principles that could apply in counseling those who are hurting.

As you counsel your hurting clients, what you say to them will be guided by your own beliefs about the role of suffering in human experience (part of your own “theoretical map” as discussed in the lecture). Considering the numerous points that were made in the course, make a list of at least 5 concepts (“questions to ask myself as I counsel those who are suffering. . . “) that you found particularly helpful, insightful, unique, or had not thought about before. What guidelines would you particularly emphasize as you counsel hurting people? The five concepts you list should be based on the course materials, so make sure you cite the source you use.
Then consider the following scenario. What suggestions from the course materials would you want to apply to this hurting client? Why did you choose those suggestions as most important?

Scenario:

You work primarily for an adoption agency but on some evenings, you volunteer your time at your church’s free counseling clinic. Your client in that setting, Jamie, was recently divorced, and expresses that she “has no direction” in life. She feels very rejected and alone. She often cries in session and in her latest session, lashed out at you, her therapist, since she was “not feeling better.” She questioned whether you were really helping her since she is still “feeling all this pain.” She left asking, “Why can’t you help remove this needless suffering?”

The student will post one thread of at least 400 words.

Chapter 1 and 2 of McMinn
Watch: https://youtu.be/F7BVP_fyiGQhttps://youtu.be/F7BVP_fyiGQhttps://youtu.be/F7BVP_fyiGQhttps://youtu.be/F7BVP_fyiGQ

Please submit a plagiarism report for the assignment. Thank you.

Intro to Business Case Assignment

Reference Textbook:
Nickels, William, McHugh James & McHugh, Susan (2022)
Understanding Business 13th Edition, McGraw-Hill, New York, NY.

1. Watch the video case called “Finding and Keeping the Best Employees”

2. Read the following after watching the Case 3 Video: (Video in Uploaded Files)

Overview

High education scores among U.S. students have fallen off over the years and minority students in inner-city schools are particularly vulnerable to underperformance. Understaffing is a major issue contributing to this problem. One organization, however, is trying to change this. Teach for America (TFA) is a nonprofit training and placement organization with a mission to put more quality teachers into schools that need them the most. The organization seeks young, highly-qualified volunteers to teach at troubled inner-city schools for a period of two years before getting their ultimate careers. TFA places a special emphasis on diversity so that its teachers reflect the unique environment in which they will work. Forty percent of its teachers are people of color—African American, Latino, Asian, and Native American.

Wanting to ensure that it isn’t contributing to the problem, TFA has developed a rigorous recruitment and training process to ensure that it is placing only the best teachers into inner-city schools. In fact, only one out of every ten applicants is ultimately selected for the program. TFA’s vetting process is extensive. Applicants are interviewed by phone, must present a lesson plan, are interviewed in person, must pass a written test, and are monitored in a group discussion with other applicants.

Once selected, the recruits attend a five-week summer course to prepare them for the challenges and needs of the inner-city classroom environment and to ensure they are grounded in curriculum, lesson planning, and in building strong relationships with schools and the community. After the recruits are placed into a school, they continue to receive support and training to help them turn their at-risk students around and guide them toward success.

What draws people to want to work for Teach for America? Certainly the satisfaction of helping students succeed is a major factor, but TFA’s compensation package is unmatched in the field of public service. Unlike other volunteers that earn very little for their work, TFA teachers earn salaries comparable to other teachers in their grade level.

This combination of recruiting, selecting, training and compensating employees has proven to be a successful formula for Teach for America as evidenced by the growth of the program, the demand for its teachers, the 10,000 recruits it trains each year and the glowing reviews it receives from school principals.

3. Answer the questions (refer to chapter 11 in your text for reference):

1. Summarize the five steps in human resource planning.
2. What is the difference between training and development and what are the three steps included in both?
3. What are fringe benefits and what role do they plan in the compensation of employees?

4. Type up your answers in a 2 page paper, doubled spaced, APA format

ecological modelling

I provide detailed assignment instructions, step-by-step instructions, and references. If the model in the assignment requirements cannot be done, it is okay, the mathematical equations in the information I give are the model I use, and I will also provide some information to help me rewrite it with reference to it, and make sure to complete the textual report content with excellence.
About the modelling part, I can also provide video tutorials, each part is only about 15 minutes, but you may need to download good software for it. About the modelling part, I can also provide video tutorials, each part is only about 15 minutes, but you may need to download good software for it.

SOCIAL WORK PRACTICE WITH GROUPS

Post a response to the following:
Compare task groups versus educational, support, or skills groups.
Describe a type of treatment group you would facilitate as a social worker.
Explain what professional role you may take when facilitating this group.
Describe what is meant by group norms, and explain how you would help shape these norms based on your role in the group.
Explain what is meant by group roles. Identify at least one group role, and explain why a group member may take that role.
Describe a group member role that might be most challenging to you as a group leader, and explain why.

English and psychology

1. After reading/watching the information provided on Freud’s Psychoanalytic Theory, you will be choosing a character in Othello to analyze using Freud’s theories.

Each of the characters in the play can easily be analyzed using Freud’s theories. However, I do believe that either Iago, Othello, Roderigo, Emilia, or Desdemona, would be the best choices. You may also choose to discuss three characters and how each character correlates with one aspect of Freud’s understanding of the subconscious mind (Id, Ego, and Superego).

For Example: (Harry Potter Series) Harry as the Ego, Ron as the Id, and Hermione as the Superego

See this Prezi for a more detailed explantation: https://prezi.com/q0sjakqa7_ms/harry-potter-and-freud/Links to an external site.

Your analysis will be submitted to Turnitin. It should be roughly 4-6 pages and use 1-2 outside sources on Freud’s theory, as well as the play itself. Before beginning the paper, make sure to feel confident on how to write a paper of this nature. Read the sample essays in the Unit Materials folder and ask questions if you are feeling confused! 🙂

2. Think about your own personality. Are you like your parents, siblings, or do you find that you are very different compared to those in your social circle? What factors have been involved in the creation and manifestation of your personality? What theorist seems most correct to you?

What theory do you think is most correct about personality development. Using your personality as a lens, explain why you believe this particular theory sounds most correct to you.

If you disagree with all of the theories, create a theory and compare and contrast it, with the theories you have learned about in this section.

Your work will be a minimum of 3 full pages long, and should not exceed 4 pages. Work should be double spaced, 12 point font, 1″ margins.

POPULATIONS AND PROBLEMS OF INTEREST

Submit a 2- to 3-page paper in which you do the following:
Describe the population or problem with which you are interested in working.
Identify the roles social workers take with this population/problem.
Describe what you learned about working with this population during your Walden Library search.
Identify types of skills and knowledge you want/need to develop in order to effectively work with this population/problem.
Support this paper with 3 sources, including from the Learning Resources throughout this course and information found in the Walden Library.

Alvarez-Hernandez, L. R., & Choi, Y. J. (2017). Reconceptualizing Culture in Social Work Practice and Education: A Dialectic and Uniqueness Awareness ApproachLinks to an external site.. Journal Of Social Work Education, 53(3), 384-398. doi:10.1080/10437797.2016.1272511
Barsky, A. (2018). Cultural competence, awareness, sensitivity, humility, and responsiveness: What’s the difference?Links to an external site. New Social Worker, 25(4), 4–5.Alvarez-Hernandez, L. R., & Choi, Y. J. (2017). Reconceptualizing Culture in Social Work Practice and Education: A Dialectic and Uniqueness Awareness ApproachLinks to an external site.. Journal Of Social Work Education, 53(3), 384-398. doi:10.1080/10437797.2016.1272511
Barsky, A. (2018). Cultural competence, awareness, sensitivity, humility, and responsiveness: What’s the difference?Links to an external site. New Social Worker, 25(4), 4–5.

Pharmacology/Patho Paper

You will write a 3-5 page paper (this does not include title page or reference page) from the topics listed below. In this paper you will apply the nursing process to the drug & disease process. This is an evidence based paper that will reflect your understanding of how a drug works in the body, what patient education is required, how the medication is monitored and how would you, the nurse, know that the treatment is effective. You will describe the pathophysiology of the disease in a way that a patient would understand it. As well as the treatment(s) for this disease process. You will include risks, patient education, monitoring/testing, and long term outcomes.

This should be a thorough teaching about either the medication & disease that reflects your ability to provide safe, comprehensive care to the patient.

My topic: Breast Cancer