Need Help ?

Expert Answers

Please help witht the following project. ...

Please help witht the following project.

READ MORE >>

           Shelly      Cashman Excel 2019 | Modules 1-3: SAM Cap ...

           Shelly      Cashman Excel 2019 | Modules 1-3: SAM Capstone Project 1a                     Ensight Healthcare Consultants CREATE FORMULAS WITH FUNCTIONS     GETTING STARTED · Open the file SC_EX19_CS1-3a_FirstLastName_1.xlsx, available for download from the SAM website. · Save the file as SC_EX19_CS1-3a_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 SC_EX19_CS1-3a_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. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.   Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet. 2. In cell J1, enter a formula using the NOW function to display today's date. Apply the Short Date number format to display only the date in the cell. 3. Format the worksheet title as follows to use a consistent design throughout the workbook: a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color. b. Change the font color to White, Background 1. c. Merge and center the contents of cell B2 across the range B2:H2. d. Use AutoFit to resize row 2 to its best fit. 4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand: a. Italicize the contents of cell I2 to match the formatting in cell I1. b. Apply the Currency number format to cell J2 to clarify that it contains a dollar amount.  5. Format the data in cell A4 as follows to display all of the text: a. Merge the cells in the range A4:A13. b. Rotate the text up in the merged cell so that the text reads from bottom to top. c. Middle-align and center the text. d. Remove the border from the merged cell. e. Resize column A to a width of 4.00. 6. Format the data in row 4 as follows to show that it contains column headings: a. Change "Description" to use Service Description as the complete column heading. b. Apply the Accent 6 cell style to the range B4:H4. c. Use AutoFit to resize column D to its best fit. 7. Carla wants to include the actual dollar amount of the services performed in column E. Enter this information as follows: a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell J2 in the formula. b. Use the Fill Handle to fill the range E6:E13 with the formula in cell E5 to include the charges for the other services. c. Format the range E6:E13 using the Comma number format and no decimal places to match the formatting in column F. 8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows: a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services. b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services. c. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F. 9. Carla also wants to show the remaining amount as a percentage of the actual amount. Enter this information as follows: a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5). b. Copy the formula in cell H5 to the range H6:H14, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total. 10. Calculate the project status totals as follows: a. In cell D14, enter a formula using the SUM function to total the actual hours (range D5:D13). b. Use the Fill Handle to fill the range E14:G14 with the formula in cell D14. c. Apply the Accounting number format with no decimal places to the range E14:G14. 11. Carla also wants to identify the services for which Ensight has billed more than the full estimate amount.   In the range H5:H13, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text.  12. Carla imported data about the consultants working on the Everett Hospital project and stored the data on a separate worksheet, but wants to include the data in the Project Status worksheet.   Copy and paste the data as follows: a. Go to the Consultants worksheet and copy the data in the range B2:G12. b. Return to the Project Status worksheet. Paste the data in cell J3, keeping the source formatting when you paste it. 13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows: a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4. b. If the consultant has four or more years of experience, display "Lead" in cell N5. c. If the consultant has less than four years of experience, display "Associate" in cell N5. d. Copy the formula in cell N5 to the range N6:N13, pasting the formula only. e. Use AutoFit to resize column N to its best fit. 14. Carla wants to include summary statistics about the project and the consultants. Include this information as follows: In cell D16, enter a formula that uses the AVERAGE function to average the number of years of experience (range M5:M13). 15. Make the 3-D Clustered Column chart in the range B17:H31 easier to interpret as follows: a. Change the chart type to a Clustered Bar chart. b. Use Actual Project Hours as the chart title. c. Add a primary horizontal axis title to the chart, using Hours as the axis title text. d. Add data labels in the center of each bar. 16. Delete row 33 since Carla has reformatted the clustered column chart. 17. Go to the Schedule worksheet. Rename the Schedule worksheet tab to Project Schedule to use a more descriptive name. 18. Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows: a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell C6. b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6. c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6. d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6. 19. Copy the formulas in Phase 2 to the rest of the schedule as follows: a. Copy the formula in cell D6 to the range D7:D9. b. Copy the formula in cell E6 to the range E7:E9. c. Copy the formula in cell F6 to the range F7:F9. d. Copy the formula in cell G6 to the range G7:G9. 20. In cell C11, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G9). 21. In cell C12, enter a formula that uses the MAX function to find the latest date in the project schedule (range C6:G9). Your workbook should look like the Final Figures on the following pages. The value in cell J1 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.     Final Figure 1: Project Status Worksheet   Final Figure 2: Project Schedule Worksheet  

READ MORE >>

Do only 1,3,4. Use equation writer in Word to type this up. ...

Do only 1,3,4. Use equation writer in Word to type this up.

READ MORE >>

Must be familiar and proficient with Cisco Packet Tracer.  The following attac ...

Must be familiar and proficient with Cisco Packet Tracer.  The following attachment is a .pka file that contains the lab activity to be completed. Please do the lab to 100% completion. It involves troubleshooting IPv4 and static and default routes. Details for troubleshooting steps must include proper commands. For the action plan, list it in a separate word file. The Cisco Network Build project is not a .pka file. It is a Word document file with instructions on how to build a specific network. This will be done in Packet Tracer from scratch. Please utilize this file to conduct the steps listed in the activity  in Packet Tracer and save the file. 

READ MORE >>

List the two most important diagrams in one of the three modeling spaces. The th ...

List the two most important diagrams in one of the three modeling spaces. The three modeling spaces are: the problem space, the solution space, and the architectural space. Some of the diagrams include: Use case, activity, package, class, sequence, interaction overview, and state machine diagrams. More information can be obtained from chapter three of the book: Software engineering with UML by Unhelkar, B., ISBN 9781138297432. Provide a sample diagram created in Lucidchart (https://www.lucidchart.com/pages/).

READ MORE >>

 One of the best practices to learn is to read about attacks made on other orga ...

 One of the best practices to learn is to read about attacks made on other organizations. In an earlier discussion, we reviewed the MITRE ATT&CK matrix for retrieving tactics, techniques, and procedures of bad actors and how to mitigate those attacks. This module will allow us to look at the basics of network architectures, network devices, and access methods to networks. The assigned reading for this discussion gives insight into a classic cyber attack by Kevin Mitnick who: Accessed a diskless workstation being used as an x-terminal that was granted through: IP Source Address Spoofing attack TCP sequence number prediction An existing connection to another machine was then hijacked. Discussion Questions After reading the SANS Institute (2022) titled Kevin Mitnik, Hacking and Krishna, Kollou, and Raju (2014)'s work.  Briefly summarize the attributes of Kevin Mitnik's attack.  What security measures could have stopped this attack if they were put into place at the time? Would a firewall or intrusion prevention system have stopped the attack? Make certain to address the external devices/monitors as well as the changes to computer and network protocols that could have stopped or prevented this attack.  For Reading Purpose:  Kevin Mitnik, Hacking and Krishna, Kollou, and Raju (2014)'s work.  

READ MORE >>

For your final assignment in this course, reflect on what you learned about the ...

For your final assignment in this course, reflect on what you learned about the importance of crisis communication and management for an organization.  You will prepare and record (present) a Powerpoint summary of your key takeaways from this course. Your PowePoint should be no less than 10 slides of content (not including the title slide and the final 'thank you for listening' slide). and no more than 20. Be sure to reflect on key takeaways on Crisis Comunication and Crisis Management. Your presentation should be in your owns words, but if you need to use secondary sources, please cite them using APA formatting.

READ MORE >>

  Sequences: The Sequel! Step 1 - Take your sequence class from Assignment 1 ...

  Sequences: The Sequel! Step 1 - Take your sequence class from Assignment 1 and update it to use a template parameter to determine what type of data to hold. Keep in mind that this will likely require you to implement some of your class member functions (and maybe some nonmember functions) as template functions, which will require them to be implemented in the header file. To solve this problem, create a file called sequence.template and define the necessary functions there. (All other functions should continue to be implemented in sequence.cpp.) Step 2 - Referencing the dynamic array example code from Lecture 5 if necessary, rewrite your templated sequence class from Step 1 to use a dynamic array for data storage. Save the resulting files as "sequence_dynamic[.h, .cpp, .template]". Step 3 - Extending your previous work on the node class in Lab 3, rewrite your node class to use a template parameter to determine what type of data it will store. (Figure 6.4 in Main and Savitch might be helpful here.) Save the resulting files as "node[.h, .cpp, .template]". Step 4 - Lightly modify your class from Step 3 to implement a templated _doubly_ linked list. Save the resulting files as "node_doubly_linked[.h, .cpp, .template]". Step 5 - Create a templated sequence class using a linked list for data storage. (This means using the templated node class.) Save the required files as "sequence_linked_list[.h, .cpp, .template]". Step 6 - Finally, modify your work from step 5 to implement the templated sequence class using a doubly-linked list. Save the resulting files as "sequence_doubly_linked[.h, .cpp, .template]". Step 7: Now that you've written all of your code, I'd like you to go back and indicate the Big-O complexity class of each function in each implementation. A short one-line comment (for example, "// O(n)") before each function is sufficient. Step 8:  You will need to test the core functionaliy of each class. (don't worry, tests should largelt be reusable between implementations of a given class.) Whether you submit a single test file for all classes, or one for each class, is up to you. *To be clear you will ultimately implement, analyze, and test 6 classes here: -- 4 different sequence classes -- 2 different node classes * Note that you may now always have a resulting *.cpp implementation file for some templated classes. Your entire implementation might rightfully end up in the *.template file. Once you are ready to submit everything, zip all *.h, *.template, and *.cpp files (including test files) into a single zip file and upload that file through Canvas.

READ MORE >>

  Discuss tools and techniques to remove Malware from infected machines; using ...

  Discuss tools and techniques to remove Malware from infected machines; using a popular product to make your point. Discuss the vulnerabilities that computer memory and computer process have that malware can take advantage of and exploit. List any observations, tips or questions about this lab that would prove helpful to fellow students prior to midnight on Wednesday and comment on other student posts with value added comments (not simply agreeing) by midnight Sunday for full credit consideration.

READ MORE >>
QUICK ORDER

Place a Quick Order

Our verified writers got you covered. Let us help you balance between studies, work, and family.

We provide our assistance to the numerous clients looking for a professional writing service.

Order Now
Designed and developed by Brian Mubichi (mubix)
WhatsApp