Option 2: Alternative Assignment
Your first day of interning in the Horizons Medical Center has you working in the HR department. The department supervisor has asked that you combine information from a Microsoft Office survey distributed to a few hospital departments. The supervisor believes that the information will be better explained using charts.
Create a spreadsheet from the data below and generate two charts to visually represent the data. The chart types should be:
-
Pie Chart in 3D – Depicting only the Excel users
-
3D Clustered Column Chart – Comparing all software used per department
| Cardiology | Dermatology | Neurology | Human Resources | Purchasing | |
| Excel | 35 | 12 | 5 | 7 | 35 |
| Word | 15 | 35 | 17 | 15 | 10 |
| PowerPoint | 17 | 5 | 12 | 5 | 3 |
| Access® | 17 | 15 | 8 | 10 | 15 |
| Publisher® | 1 | 15 | 22 | 15 | 25 |
Is this your assignment or some part of it?
We can do it for you! Click to Order!
Related posts:
- Microsoft Office states that scatter plots are most often used for “displaying and comparing numeric values, such as scientific, statistical, and engineering data” (Microsoft Office, 2012). These types of charts are useful for showing the relationships among the numeric values of data. I believe that medical researchers tend to use scatter plots as a way to show their completed data from any of their studies. The Census Bureau would use the scatter plot to show the population of the U.S.
- ROLE OF CONTROLLER: Juanita Veracruz, newly hired controller of Braxton Industries, had been lured away from a competitor to revitalize the controller’s department. Her first day on the job proved to be an eye-opener. One of her first interviews was with Adrian Belton, production supervisor in the Cleveland factory. Belton commented, “I really don’t want to talk to anyone from the controller’s office. The only time we see those accountants is when our costs go over their budget. They wave what they call a ‘performance report,’ but it’s actually just a bunch of numbers they make up. It has nothing to do with what happens on the shop floor. Besides, my men can’t afford the time to fill out all the paperwork those accountants want, so I just plug in some numbers and send it back. Now, if you’ll let me get back to important matters.…” Veracruz left quickly, but she was already planning for her next visit with Belton. 1. Identify some of the problems in the relationship between the controller’s department and the production departments (assuming that the Cleveland factory is representative of the production departments). 2. What should Juanita Veracruz do next?
- For this Discussion, you will investigate how another organization conducts assessments. Begin by finding out whatever you can through Web searching about your local or state health department’s approach to assessment and strategic planning. Find out also if there are initiatives at the state level to coordinate health assessments from the various communities in the state. If so, are there tools and forms available to do that? (See the Iowa state Web site as an example: http://www.idph.state.ia.us/chnahip/reports_2005.asp.) Then locate and interview someone who has been involved in community health assessment and strategic planning at either a local or state level. To find a person to interview, contact your local health department. Depending on the size of the department, you may wish to ask to interview the director or else ask to be referred to someone who has participated in assessment and strategic planning. If you prefer, you could instead call your state health department; each state should have personnel who deal with coordinating strategic plans from individual counties, and one of these individuals might be a good person to interview. Your interview may be conducted over the phone or via e-mail, or in person if you prefer. (Note: You must transcribe or summarize your interview and post it.) Prepare your thoughts and questions carefully in advance so you can be succinct in your interview. In your interview, you should ask them questions along these lines, as well as any other questions you think are appropriate to the organization or individual you are working with: 1. How do you assess the needs of your community? How often do you conduct assessments? 2. What use did you make of the assessment data? Did you develop a strategic plan or something similar for your department and/or for the community? Please describe this plan. (For example, how detailed is it? Is it a long-range plan?) 3. What are your thoughts about the assessment process? How well is it working? What are specifc strengths of the process from your perspectives? Any barriers or difficulties to overcome? Then: # Identify the organization and title of the person you contacted (for privacy purposes, however, do not identify the name of the person you interviewed). # Summarize the findings of your interview, highlighting what you found most surprising or interesting regarding the challenges and benefits of the community health assessment process. Is there anything you would do differently or do you have suggestions for improvement? # Post a transcript or detailed summary of the interview as an attachment; this will allow other students who are interested to learn more about this organization’s assessment process.
- Do individual research on creating a new hospital department. Discuss the measures you would use to show that your department has an edge over the competition. What kind of measures would you use to argue for this department to the hospital leadership? Conclude if your measures are strong enough to justify the new department.
- To make sure you are up to date on the special guidelines the GASB has declared, your manager asked you to research GASB Statement No. 56. He also asked you to show him, side by side, how government accounting journal entries might differ from for-profit journal entries in these similar events. Write 500–750 words that addresses the following: When was GASB Statement No. 56 initiated? In your own words, what is the essence of the new ruling? Why did the GASB probably deem it as being necessary? How might GASB Statement No. 56 change the activities of any accountant performing governmental accounting? Create journal entries for all of the following situations. On 10/1/2010, a for-profit Company A provides $100,000 of service to Company B. Company B plans to pay their bill 90 days later. Create the journal entry when the service is provided. Create the journal entry when the cash is received. On 12/1/2010, the city’s recreation department receives a government grant of $100,000 specifically to use for next year’s park upgrades, which will begin on 1/1/2011. Create the journal entry made when the cash is received. Create the journal entry to be made on 1/1/2011. A for-profit retail store buys $200,000 of inventory on 9/1/2010. Create the proper journal entry to show purchase of this inventory. A local city park buys $200,000 of food merchandise for later resale. It uses the purchase method to account for inventory. Create the proper journal entry for when this purchase is made. A nonprofit organization receives a $250,000 donation on 12/1/2011, but the donor specifically wants it spent in 2012. Create the journal entry or entries to show the proper recording of revenue (this may require more than on journal entry). Create the subsequent journal entry to show spending of the funds.
- To make sure you are up to date on the special guidelines the GASB has declared, your manager asked you to research GASB Statement No. 56. He also asked you to show him, side by side, how government accounting journal entries might differ from for-profit journal entries in these similar events. Write 500–750 words that addresses the following: When was GASB Statement No. 56 initiated? In your own words, what is the essence of the new ruling? Why did the GASB probably deem it as being necessary? How might GASB Statement No. 56 change the activities of any accountant performing governmental accounting? Create journal entries for all of the following situations. On 10/1/2010, a for-profit Company A provides $100,000 of service to Company B. Company B plans to pay their bill 90 days later. Create the journal entry when the service is provided. Create the journal entry when the cash is received. On 12/1/2010, the city's recreation department receives a government grant of $100,000 specifically to use for next year's park upgrades, which will begin on 1/1/2011. Create the journal entry made when the cash is received. Create the journal entry to be made on 1/1/2011. A for-profit retail store buys $200,000 of inventory on 9/1/2010. Create the proper journal entry to show purchase of this inventory. A local city park buys $200,000 of food merchandise for later resale. It uses the purchase method to account for inventory. Create the proper journal entry for when this purchase is made. A nonprofit organization receives a $250,000 donation on 12/1/2011, but the donor specifically wants it spent in 2012. Create the journal entry or entries to show the proper recording of revenue (this may require more than on journal entry). Create the subsequent journal entry to show spending of the funds.
- list the Microsoft Office application that you feel is likely to be utilized most often in your future career (medical assistant)
- Department of Homeland Security (DHS): What issues could arise when a panicked public believes it has been exposed, or has been exposed, to an element that may require decontamination?
- Your supervisor, Sarah Harris, is a new probation officer who has been on the job for only a few months and is still learning the job herself. You are asked to prepare a memo to Sarah Harris listing the five types of helping professionals that she might come into contact with during her job as a probation officer in a pretrial diversion program. Also, you will need to select one psychological theory and one social work theory from the list that you feel would aid her most in dealing with the adults on her caseload. You will need to explain the theories and why she needs to know this as probation officer.
- Emergency department observation: an observation experience at an Emergency Department (ED at a hospital) Custom Essay
