IT345 Week 6 discussion

 Pick a topic below and post your reply. Your response should be at least 500 words and appropriately cites your resources. 

 

Topics:

  • What jobs have been eliminated due to technology? What jobs have been created?
  • Do automated systems mean fewer jobs for high-skilled workers?
  • Would you want to telecommute? Why or why not? Is it a viable solution for all employers?
  • Is hacking that does no direct damage a victimless crime? Give an example to support your case
Images

WEEK 5: INDEPENDENT PROJECT: EXCEL 2019 IN PRACTICE – CH 6 INDEPENDENT PROJECT 6-6

 

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).ImagesFigure 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.ImagesFigure 6-112 SUMIFS with absolute and relative references
      ImagesFigure 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.

HR critical Week 4

Find a peer reviewed article pertaining to Blockchain and HR. Write a critical review of the article. Your review should  be at least 3 pages long from introduction to conclusion. Be sure to provide in-text citations when you paraphrase or directly quote from the article. Also include a reference page with an APA style citation of the article. Follow the writing requirements for this course when preparing the paper. Use the following format for the paper:

1.  Introduction, including the purpose of your paper and a preview of your paper. Be sure to also provide the article’s title and author(s)’ name(s) in the introduction of your paper. 

2. Discuss the purpose and problem the article is addressing.

3. Elaborate on the content of the article.

4. Discuss the findings and conclusion(s) drawn by the article’s author.

5. Discuss the author’s point of view and assumptions. Indicate whether unsubstantiated assumptions were made and whether there is bias that exists in the article.

6. Discuss the significance of the article. Why it is important? On what do you base your assertions?

7. Conclude your paper. Summarize the important aspects of the review.

8. References

Your paper should include 8 centered and bolded headings that correspond to each of the required sections (Introduction, Article’s Purpose and Problem, Content, Article’s Findings and Conclusions, Point of View and Assumptions, Significance, Conclusion, References).

Writing Requirements for All Written Work:

  • References MUST be cited within your paper in APA format. Your reference page and in-text citations must match 100%. Papers without in-text citations will earn failing grades.
  • Always include a cover page and reference page with ALL submissions (even initial discussion posts) 
  • Provide the EXACT web link on the reference page citations for all online sources – do not provide just the home page, but the EXACT LINK – I check all sources
  • No abbreviations, no contractions – write formally
  • Write in the third person formal voice (no first or second person pronouns)
  • Write MORE than the minimum requirement of the word count assigned
  • As always, the word count is ONLY for the BODY of the paper – the cover page, reference page, and / or Appendix (if included) do not count towards the word count for the paper 
  • Indent the first line of each new paragraph five spaces
  • Refer to the example APA paper in the getting started folder under the content tab if you need an example. Also, a Power Point is provided under the information tab that addresses APA format.
  • Use double-spacing / zero point line spacing, a running header, page numbers, and left justify the margins.

Assignment: Individual Assignment 4

Length: Minimum of 700 words

Briefly respond to all the following questions. Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references

Figure 8.1 Business analytics logical data flow diagram (DFD).

Consider the data flow “octopus,” as shown in Figure 8.1. How can the analysis system gather data from all these sources that, presumably, are protected themselves?

biw1

Find information about IBM Watson’s activities in the healthcare field. Write a report.

DSBDA W 1 D

 In this week’s reading, the concept of 3-F Method is introduced.  Discuss the purpose of this concept and how it is calculated.  Also perform your own research/analysis using these factors and provide your assessment on whether the United States need to introduce top talents in the field of big data and cloud computing by using bibliometrics. 

ns-d-11

 explain what is meant by an IDS and an IPS.  How are they different?  How are they connected to a network?  List a few examples of IDS/IPS tools that are currently on the market.  300 words