Purpose of Assignment

Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel^®, values can be modified at any time, and the electronic spreadsheet will automatically update itself. Students will create a spreadsheet of computer equipment for a small fictional business where they are the owner. They will include the cost of all hardware and software needed for their employees, and calculate a monthly budget for the equipment.

Assignment Steps

Resources:

• Research hardware and software to satisfy operational requirements described above
• Microsoft Office 365, Office 2016: Introductory: Module 1: Creating a Worksheet and a Chart
• Microsoft Office 365, Office 2016: Introductory: Module 2: Formulas, Function, and Formatting

Scenario: Imagine you are the owner of a small internet business where you employ five people. You need to budget for the cost of hardware and software needed to run company operations. Each employee is required to work both in the office and remotely, and needs access to company data at all times.

Choose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spreadsheet software applications.

Create a business budget sheet using Microsoft^® Excel^®. In the budget sheet, do the following:

• List the make and model of desired hardware devices and their cost.
• List software operating systems and applications for each device and their costs.
• Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems.
• Insert a graph or chart displaying total costs graphically.
• Label columns/rows with titles reflecting data they contain.
• Use no more than two sheets in one workbook to display required data.
• Format data to highlight important totals.

The Budget sheet answers should include 1,400 words.

Note: this assignment only requires that you submit an Excel^® Workbook file. There are no written or APA guideline requirements.

Case Study:

Healthy Hospital has hired you (an HIM professional) to assist with the risk analysis program for identifying and preventing medical identity theft.

1. What measures to prevent and detect identify theft should be reported to Healthy Hospital?
2. You may find this document helpful to utilize when answering this question. Raising Awareness of Medical Identity Theft: For Consumers, Prevention Starts with Guarding, Monitoring Health Information download the assignment overview to open in word. Once open, hold down the ctrl key & click this link. OR copy the original link to the article. http://bok.ahima.org/doc?oid=85512#.WNvqO28rLX5

Research

Omar has recently been hired as the HIM Director at a large medical center. He realizes that he has a number of employees whose job duties would allow them to work from home. Because his boss has asked him for a space reduction proposal, he recognizes the need to implement a work-at-home program for his employees.

• What steps should Omar take in developing a security program for the employees who will work from home? You may find it helpful to utilize these two resources:
  • AHIMA Practice Brief: This document provides additional policy and procedure guidance for remote access. Hold down the ctrl key & click on this link to locate the document: Safeguards for Remote Access.
  • The National Institute of Standards and Technology: The NIST provides guidance for implementing the HIPAA Security Rule. Hold down the ctrl key & click on this link to locate the document: Implementing HIPAA Security Rule.
• Develop a checklist of considerations, along with a list of resources that would facilitate his security program. You might find the following website helpful. http://www.computerworld.com/s/article/9025253/HIPAA_audit_The_42_questions_HHS_might_ask. Computerworld published a list of the 42 questions that HHS might ask which was developed about the first HIPAA security audit at Piedmont Hospital in Atlanta. You can use this document to develop your own checklist. Do not copy & paste any information. The document should have your own personal touch and be typed in your own words. IF quoting anything, be sure to provide the statements in quotes. Also, include your references used. For example: textbook page, website link/address, etc.

Sparrow Pharmaceuticals is the maker of several popular drugs used to treat high blood pressure and arthritis. Over time, the company has developed a positive relationship with many of the patients who use its medications through a quarterly newsletter that offers the latest information on new medical research findings and general health and fitness articles. The company just has been acquired by a group of investors who also own Soothing Waters Hot Tubs and Spas. The marketing director for Soothing Waters would like to use Sparrow’s mailing list for a direct-mail promotion.

1. What should Sparrow Pharmaceuticals do?
2. Do you think it is ethical to use customer information across multiple divisions of the same company? Explain.
3. To which marketing management philosophy do you think the marketing director for Soothing Waters subscribes? Explain.
4. Does the AMA Statement of Ethics address the use of the customer information by multiple divisions of the same company? Go to http://www.marketingpower.com and review the statement. Then write a brief paragraph on how the AMA Statement of Ethics relates to Sparrow Pharmaceuticals’ dilemma.

Objective 2: Summarize the causes and impacts of earthquakes.

Earthquakes have caused considerable fear and damage since at least the time of the flood. Biblical prophecy associates earthquakes with end times. Plate tectonic theory explains the causes and locations of earthquakes, which occur predominantly at plate boundaries but which may occur at any fault. According to the U.S. Geological Survey 42 states including Ohio, “have a reasonable chance of experiencing damaging ground shaking from an earthquake in the next 50 years.”

Learning Activity #3: Earthquake Exercise

• Read Chapter 5, Sections 1-4 in The Heavens and the Earth textbook.

• For onsite students, come to class prepared to discuss questions 6, 7, and 12 from the Review Section in Chapter 5. Topics will include:
  • the types of earthquake waves
  • locating the focus of earthquake waves
  • measuring earthquake waves
  • earth interior
• Research an event involving an earthquake OR investigate the causes, measuring scales, and impacts of earthquakes
• Submission Item: Write a 1-2 page written report on earthquakes. Your report should summarize the measuring scales, causes, impacts, and most common locations of earthquakes and will include either an identification chart or relate the information to a current event of a recent earthquake.
  
• APA formatting is only required for citing sources and references, unless otherwise instructed by your professor.

Learning Activity #4: Volcanoes Exercise

• Read Chapter 5, sections 5 and 6 in The Heavens and the Earth textbook.
• For onsite students, come to class prepared to discuss questions 6, 7, and 12 from the Review Section in Chapter 5. Topics will include:
  • Discuss types of volcanoes
  • Volcanic materials
  • Dangers caused by volcanoes
  • Location of volcanoes

• Research an event involving a volcano OR investigate the causes, measuring scales, and impacts of volcanoes
• Submission Item: Write a 1-2 page (250 to 500 words double spaced) written report on volcanoes. Your report should summarize the measuring scales, causes, impacts, and most common locations of volcanoes and will include either an identification chart or relate the information to a current event of an active or recent volcano.
• APA formatting is only required for citing sources and references, unless otherwise instructed by your professor
• NO PLAGERISM AND USE REFERENCES