Clemenson Imaging LLC monitors increased revenue from the use of CT scan equipment. You analyze the number of patients and procedures by technician and location.

[Student Learning Outcomes 6.3, 6.4, 6.5, 6.6, 6.7]

File Needed: ClemensonImaging-06.xlsx (Available from the Start file link.)

Completed Project File Name: [your name]-ClemensonImaging-06.xlsx

Skills Covered in This Project

• Calculate the net present value of a purchase.
• Use TRANSPOSE to rearrange labels into a column.
• Concatenate cells to display full names.
• Use SUMIFS to summarize data.
• Calculate procedure times.
• Format times with fractions.

1. Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
2. Determine the net present value of a new equipment purchase.
   1. Click the Financials sheet tab and select cell H5.
   2. Use NPV with a Rate argument of 4.25%.
   3. Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.
   4. Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.
3. Use TRANSPOSE and CONCAT to display technician names.
   1. Click the Technicians sheet tab. The names are in rows.
   2. Select cells A4:A10, seven rows in one column.
   3. Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.
   4. Press Ctrl+Shift+Enter to complete the array formula.
   5. Repeat the TRANSPOSE task for the first names in cells B4:B10.
   6. Select cell D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).Figure 6-111 CONCAT formula to display names
   7. Copy the formula in cell D4 to cells D5:D10.
   8. Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.
   9. Copy the formula and preserve the borders.Figure 6-112 SUMIFS with absolute and relative references
      Figure 6-113 Change time format to display fractions
4. Use SUMIFS to total number of patients by procedure and technician.
   1. Click the Summary sheet tab and select cell C5.
   2. Use the SUMIFS function with an absolute reference to cells $D$5:$D$41 on the Procedures sheet as the Sum_range argument.
      • The Criteria_range1 argument is an absolute reference to the image type column on the Procedures sheet, cells $E$5:$E$41.
      • The Criteria1 argument is a relative reference to cell B5 on the Summary sheet.
      • The Criteria_range2 argument is an absolute reference to the technician names column on the Procedures sheet.
   3. Select cell A5 for the Criteria2 argument (Figure 6-112).
   4. Copy the formula in cell C5 to cells C6:C11 and preserve the borders.
5. Use SUMIFS to total number of patients by category and location in cells C14:C15.
6. Look for and correct format inconsistencies.
7. Calculate procedure times.
   1. Click the Times sheet tab and select cell F6.
   2. Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.
   3. Copy the formula to row 41.
   4. Select cells F6:F41 and open the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to two digits (Figure 6-113).
8. Save and close the workbook (Figure 6-114).
9. Upload and save your project file.
10. Submit project for grading.

Exercise 24.3: (pg no.  971)

 (Implement a doubly linked list) The MyLinkedList class used in Listing 24.5 is

a one-way directional linked list that enables one-way traversal of the list. Modify

the Node class to add the new data field name previous to refer to the previous

node in the list, as follows:

public class Node<E> {

E element;

Node<E> next;

Node<E> previous;

public Node(E e) {

element = e;

}

}

Implement a new class named TwoWayLinkedList that uses a doubly linked list

to store elements. Define TwoWayLinkedList to implements MyList. You need

to implement all the methods defined in MyLinkedList as well as the methods

listIterator() and listIterator(int index). Both return an instance of

java.util.ListIterator<E> (see Figure 20.4). The former sets the cursor to

the head of the list and the latter to the element at the specified index.

Almost everywhere you look, you see people using mobile devices. You cannot drive down the street, sit in a restaurant, play in a park, or shop without seeing someone talking on the phone, checking messages, or sending texts. These mobile devices range from watches to phones, tablets, and small handheld computers, and each must have an operating system to manage the hardware, software, and user interface.

ABC Inc. is growing and wants to enter the business in distributed operating systems and mobile app development. The chief information officer (CIO) of the company knows that you are the expert in these areas and wants you to provide a report where you should do the following:

• Analyze 5 major characteristics of time-sharing systems and 5 major characteristics of distributed operating systems by comparing them with each other
• Analyze 10 constraints that are put on the operating systems for these carry-along computers (e.g., watches, phones, tablets, and so on) by comparing them with the operating systems for regular computers (e.g., desktops, workstations, and so on).

Write the report(3-5pages) in Microsoft Word using APA style. Cite references in APA format. Submit the Word document.

Write a comprehensive 2-paragraph (200 to 400 words) progress report detailing your experiences and achievements in your current internship, externship, training, volunteer work, or job position. Your report should offer a concise yet descriptive overview, including self-reflection on areas of success and potential improvement. Additionally, format your report following the guidelines of the American Psychological Association (APA) for a student paper, complete with a properly formatted cover page.