Explain how information technology affects the strategies of the organization in a nursing home.
What other external factors could affect the use of new technologies?
Explain how technology can impact an organization’s external environment.
Please use examples to highlight your points.
Jim Moor claims that computing will “ transform social institutions.” Evaluate this claim.
Minimum 600 words
Need two full pages double spaced
Hello,
i need this paper by Thursday 7pm.
Strictly No plagiarism please use your own words.
Topic: Artificial intelligence is going to exceed human intelligence.
Need 8-10 page argument paper on an appropriate academic topic. This paper needs to contain a debatable statement (an argument that others could or do disagree with) that addresses your topic. In order to support this argument, you must use at least four sources. The entire paper must be written in APA format and must contain the following:
Cover page (1 page)
Introduction statement (1/2 page)
Body/discussion (3 pages)
Counterargument (1 page)
Conclusion (1/2 page)
References page (1 page)
total 6 pages with reference 1 page
NP_EX19_6a
NP_EX19_6a_FirstLastName_1
New Perspectives Excel 2019 | Module 6: SAM Project 1a
Oval Lake Hospital
MANAGING YOUR DATA WITH DATA TOOLS
· Open the file NP_EX19_6a_FirstLastName_1.xlsx, available for download from the SAM website.
· Save the file as NP_EX19_6a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
· With the file NP_EX19_6a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format departmental data for the years 2021-2023 to make it easier to analyze.
Switch to the Cancer Center worksheet. Unfreeze the top row of the worksheet.
2. Sort the data in the CancerCenter table first in ascending order by the Admission field and then in ascending order by the Service field.
3. Insert a Total Row in the CancerCenter table, and then use the Total row to calculate the total of the values in the 2021, 2022, and 2023 fields.
4. The administrator overseeing the cancer center is considering mandating that all inpatient service names be different from outpatient service names, and wants to see which duplicate names are currently in use. Apply a conditional formatting rule to the range C4:C11 that uses Light Red Fill with Dark Red Text for duplicate values.
5. Switch to the Cardiac Care worksheet. Freeze the first column of the worksheet.
6. Format the range A3:F10 as an Excel table with headers using the Gold, Table Style Medium 5 table style. Enter CardiacCare as the name of the table.
7. Donnie notices that the CardiacCare table is missing a record. Add the record shown in Table 1 to the end of the CardiacCare table.
Table 1: Data for the Range A11:F11
A
B
C
D
E
F
11
Cardiac Care
Inpatient
Other
2855
3540
3752
8. The Maternity department has more admission criteria than other major divisions of the hospital. Donnie wants to summarize Maternity admissions data using subtotals to show the relationships between admission type and number of patients. Switch to the Maternity worksheet and complete the following steps:
a. Sort the table by the Admission field in ascending order.
b. Convert the table to a normal range.
c. Insert subtotals into the range A3:F13, with the subtotals appearing at each change in the Admission column value. The subtotals should use the SUM function and include subtotals for the 2021, 2022, and 2023 fields.
9. Switch to the Psychiatric worksheet and remove the duplicate record based on the values in the Admission and Service columns.
10. The data bars in the last three columns make some of the numbers hard to read. Change the Data Bars conditional formatting for the range D4:F12 to use the Solid Fill Green Data Bar format.
11. Donnie wants to calculate total admissions for the hospital for each year. Switch to the All Departments worksheet, then create the following formulas:
a. In cell D40 use the SUM function with a structured reference to total the values in the 2021 column of the AllDepartments table.
b. In cell E40 use the SUM function with a structured reference to total the values in the 2022 column of the AllDepartments table.
c. In cell F40 use the SUM function with a structured reference to total the values in the 2023 column of the AllDepartments table.
12. Donnie wants to prepare the AllDepartments table for 2024 data when it becomes available.
Add a table column to the end of the table.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Exp19_Excel_Ch11_Cap_Donors
You are a development officer for a state university. As an officer, you manage a portfolio of important donors who contribute financially to different areas within the university. You categorize the donors based on the college or school for which they want their donations associated. You recently downloaded the portfolio to an Excel workbook. Based on the way the data downloads from the main database, you want to format the text for readability and to make it easier for you to analyze. In addition, you will create an advanced filter to review a list of donors for a particular college or school. Finally, you want to create a look up area to look up data for a specific donor and create a summary section.
1
Start Excel. Download and open the file named Exp19_Excel_Ch11_Cap_Donors.xlsx. Grader has automatically added your last name to the beginning of the filename.
2
The first column displays the name of the college or school (such as ART or BUSINESS) associated with each. You want to assign a three-character code for each college and use that code to attach to existing donor IDs to create a unique field.
In cell B8, insert the LEFT function to extract the first three characters from the college name in cell A8. Copy the function to the range B9:B35.
3
You now want to combine the college ID and donor ID.
In cell D8, insert the CONCAT function to combine the college ID in cell B8 with the donor ID in cell C8 with a hyphen between the two text strings. Copy the function to the range D9:D35.
4
In cell J8, insert a text function that displays the college name from cell A8 with just the first letter capitalized, such as Engineering. Copy the function to the range J9:J35.
5
The Full Name column displays last and first names of the donors. You want to display last names only in a separate column.
In cell F8, type Schneider and use Flash Fill to fill in the last names for the donors in the range F9:F35.
6
The Address column contains street addresses, city names, and state abbreviations. To manage the address list better, you will separate the data into three columns.
Select the addresses in the range G8:G35 and convert the text to columns, separating the data at commas .
7
The top-left section of the spreadsheet is designed to be able to enter a donor’s ID, such as ENG-15, and look up that person’s position in the list, display the donor’s full name, and display the amount donated this year. The first step is to identify the position number of the donor ID.
In cell B3, insert the MATCH function to look up the donor ID in cell B2, compare it to the list in the range D8:D35, and then return the donor’s position within the list.
8
Now you are ready to use the position number as an argument within the INDEX function.
In cell B4, insert an INDEX function that uses the range D8:K35, looks up the row position number from the MATCH function result, and then uses the column position number for Full Name.
9
In cell B5, insert an INDEX function that uses the range D8:K35, looks up the row position number
from the MATCH function result, and then uses the column position number for Donation.
10
You want to format the results of the INDEX function.
Format the value in cell B5 as Accounting Number Format with zero decimal places.
11
To analyze the donor records, you are ready to create criteria and output ranges. You will enter conditions to find records for donors to the College of Business who donated $1,000 or more.
Copy the range A7:K7 to cell A38 to create the column labels for the criteria range. Type Business in cell J39 and >=1000 in cell K39.
12
You are ready to create the output area and perform the advanced filter.
Copy the column labels to cell A42. Perform the advanced filter by copying the records to
the output area.
13
Now that you created a copy of the records meeting the conditions, you are ready to enter database functions in the Summary area.
In cell K2, insert the database function to total the value of the donations for the records that meet the conditions in the criteria range.
14
In cell K3, insert the database function to calculate the average donation for the records that meet the conditions in the criteria range.
15
In cell K4, insert the database function to count the number of records that meet the conditions in the criteria range.
16
Format the range K2:K3 with Accounting Number Format with zero decimal places. Format cell K4 with Comma Style with zero decimal places.
17
You want to use the FORMULATEXT function to display the functions.
In cell G2, insert the FORMULATEXT function to display the formula stored in cell B3.
In cell G3, insert the FORMULATEXT function to display the formula stored in cell B4.
In cell G4, insert the FORMULATEXT function to display the formula stored in cell D8.
In cell G5, insert the FORMULATEXT function to display the formula stored in cell K2.
18
Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet.
According to recent surveys, China, India, and the Philippines are the three most popular countries for IT outsourcing. Write a short paper (2-4 paragraphs) explaining what the appeal would be for US companies to outsource IT functions to these countries. You may discuss cost, labor pool, language, or possibly government support as your reasons. There are many other reasons you may choose to highlight in your paper. Be sure to use your own words.
Your family is considering purchasing a house and investing in a business venture. You started the structure for a loan amortization table and the investment table. You will complete the first five years of the 20-year loan amortization table. To complete the table, you will enter formulas to calculate the beginning balance, monthly payment, and ending balance. You will use financial functions to calculate the interest and principal paid for each monthly payment. In addition, you want to calculate cumulative interest after the first year, total interest over the life of the loan, and the amount of principal paid after the first year. You also want to see how many months half or more of the payment is for interest. You will then focus your attention on completing an investment table using date functions, formulas, and a financial function to calculate the future value of the investment.
Start Excel. Download and open the file named Exp19_Excel_Ch07_ML2_Finances.xlsx. Grader has automatically added your last name to the beginning of the filename.
The first step is to enter a formula to reference the loan amount for the beginning balance for the first payment.
In cell B9, enter a formula that references cell D2.
A loan amortization table usually contains a column that displays the monthly payment for each row.
In cell C9, enter a formula to reference the monthly payment in cell D3. Use a mixed reference and copy the formula to the range C10:C68.
The monthly payment indicates the total amount of the payment, which includes principal and interest. Interest is calculated based on the loan amount, the rate, the payment number, and the number of payments.
In cell D9, enter the IPMT function to calculate the interest paid for the first month using mixed cell references to the input area for the Rate, Nper, and PV arguments and using cell A9 for the Per argument. Make sure the result is a positive value and copy the function to the range D10:D68.
After calculating the interest paid, the rest of the monthly payment repays the principal.
In cell E9, enter the PPMT function to calculate the principal paid for the first month using mixed cell references to the input rea for the Rage, Nper, and PV argument and using cell A9 for the Per argument. Make sure the result is a positive value and copy the function to the range E10:E68.
The last column of the loan amortization table calculates the ending balance.
In cell F9, calculate the ending balance by subtracting the Principal Repayment from the Beginning Balance in row 9. Copy the formula to the range F10:F68.
The beginning balance for each payment is calculated and entered in column B.
In cell B10, enter a formula that references the first month’s ending balance in cell F9. Copy the formula to the range B11:B68.
Ensure that Accounting Number Format is applied to the range B9:F68.
You want to calculate the total interest paid for the first year.
In cell F2, insert the CUMIPMT function to calculate the cumulative interest paid for the first year. Use A9 for the Start_period argument and B6 for the End_period argument. Use 0 as the Type argument. Make sure the result is a positive value.
Now you want to calculate the total interest paid for the entire loan.
In cell F3, insert the CUMIPMT function to calculate the total cumulative interest paid for the entire loan. Use A9 for the Start_period and D6 for the End_period arguments. Make sure the result is a positive value.
You want to calculate the cumulative principal paid for the first year.
In cell F4, insert the CUMPRINC function to calculate the cumulative principal paid for the first year. Use A9 for the Start_period and B6 for the End_period arguments. Make sure the result is a positive value.
In cell F5, insert the COUNTIF function to count the number of payment periods in which the interest in the loan amortization table is higher than one-half of the monthly payment (cell D4).
Apply General number format to cell F5.
You want to extract the year and use it to determine the payoff year.
Display the Investment sheet. In cell D4, insert the YEAR function to extract the year from cell D3 and add the number of years (cell B3). You will change the format of the result in the next step.
You need to format the result in cell D4 as a number.
Ensure that General number format is applied to cell D4.
At the end of each period, you will add $125 to the investment.
In cell D7, enter a formula that references cell D2. Use a mixed reference to ensure the row number does not change. Copy the formula to the range D8:D54.
You want to calculate the interest earned per period.
In cell C7, multiply the beginning balance in cell B7 to the result of dividing the APR by the No. of Pmts per Year. Use mixed and relative cell references. Copy the formula to the range C8:C54.
You are ready to calculate the ending balance for each payment period.
In cell E7, add the Beginning Balance, Interest Earned, and End-of-Period Investment for row 7. Copy the formula to the range E8:E54.
You will use a nested function to calculate the dates in column A.
In cell A8, create a DATE function with a nested YEAR function, a nested MONTH function and then add 1 to increment the month, and a nested DAY function. The function arguments should reference the date on the previous row.
Copy the function from cell A8 to the range A9:A54 but preserve the fill formatting.
In cell E56, insert the FV function to calculate the future value of the investment use references to the respective cells in the input area for the arguments. Make sure the result is positive. Leave the Type argument empty.
Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of both sheets.
Save and close Exp19_Excel_Ch07_ML2_Finances.xlsx. Exit Excel. Submit the file as directed.
Research paper on any one of the healthcare organization
For this assignment, you have been assigned as the project manager for a project involving the installation of a new Internet security suite for your company.Complete the following tasks for your project:
Requirements:
Text
Title: Managing Project Risks ISBN: 9781119489733 Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards Publisher: John Wiley & Sons Publication Date: 2019-08-13
Consider the types of digital technology advances that exist and how they might have gone awry. In 300 – 450 words identify some types digital technology that may have gone awry and how they affect your life.
