Summary

Topics

–  ‘ Research, identify, and briefly describe the evolution of information systems infrastructure. ‘.

– The summary should be 300 words with a minimum of 2 research papers as a reference.

– There should be no plagiarism, attach a plagiarism report with 0% similarity index

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.

Social Media

 

This week, you watched the Social Media Revolution 2019 #Socialnomics and read The Beginner’s Guide to Social Media.  https://moz.com/beginners-guide-to-social-media

Discussion:
As you review the multiple statistics that display in Social Media Revolution 2019 #Socialnomics, and reflecting on what you read about social media, assess the impact of social media in your life.
Question #1: 
What role does Social Media play in your life? Are you aware of the social media policies of the organizations where you work, attend school, or volunteer? Have you used social media to resolve problems, participate in a cause you are passionate about, or to learn about UMGC? How does Social Media impact your personal and professional communications?

 

Topic 2: Digital Humanitarianism

This week you also watched Innovations in Humanitarian Relief (PBS online video) https://www.pbs.org/video/innovation-humanitarian-relief-e6xivw/

Discussion:
In the wake of natural disasters and acts of terror, several tech companies are making an effort to improve traditional responses effort in humanitarian relief.

Question #1: 
Do you think that humanitarian aid workers constantly need new ways of thinking, new products and new processes to better respond to disasters? Why or why not?

 

Topic 3: Cyber Psychology

This week you read: Cyber psychology and cyber behavior of adolescents-the need of the contemporary era  https://www.sciencedirect.com/science/article/pii/S1877050917326704

Discussion:

Cyber psychology evaluates how we interact with others using technology, how we can develop technology to best fit our requirements, and how our behavior and psychological states are influenced by technology. Cyber psychology applies psychological theory to explain how individuals interact in cyberspace and how these interactions might affect our offline lives. It offers a new way to define the self and society.

Question #1: 

How does technology impact psychology? List at least three advantages and at least three disadvantages.

Question #2: 

Do you present yourself differently in different online spaces? In what ways are you different and in what ways are you consistent? Why do you think this is?

Data gathering instrument

 Task: Create one (1) instrument that could be used to gather data for your mock dissertation topic. The instrument should be designed to be exactly how it would be deployed to collect data. Since instrumentation usually goes through several steps of field testing, for purposes of this assignment you can submit a deployment-ready draft of your instrument without field testing it. Be sure the instrument collects data appropriately to measure your research question.  If your study will not use an instrument to collect data because your data is archival and already exists, you will discuss your process for data retrieval.

Some examples in below link

  

Report

 Research and write 5-6 page report (double spaces 12pt) on one of the two topics. Make sure to include bibliography, and quote any language or phrases you borrow from your references with proper citation. 

 

  1. Software licensing, copyrights and patents
  2. Testing web applications: strategies and tools

PhD Interview Questions INFORMATION TECHNOLOGY

INFORMATION TECHNOLOGY – PROVIDE AN AUTHENTIC PERSONAL STATEMENT TO EACH OF THE FIVE FOLLOWING QUESTIONS/PROMPTS REFLECTING ON THEIR INTERESTS. IN THE EVENT THAT ANY OUTSIDE RESOURCES ARE USED, RESOURCES SHOULD BE CITED IN APA FORMAT. SUBMISSIONS SHOULD BE A MAXIMUM OF 500 WORDS OR 125 WORDS PER QUESTION/PROMPT. IT IS BEST TO RESPOND TO EACH PROMPT/QUESTION INDIVIDUALLY FOR CLARITY OF THE REVIEWER. WRITING SAMPLES SHOULD BE SUBMITTED IN MICROSOFT WORD FORMAT AND INCLUDE THE CANDIDATE’S NAME.

1. PROVIDE A BRIEF INTRODUCTION FOCUSING ON YOUR EDUCATION, CAREER, AND DECISION TO APPLY TO UNIVERSITY OF THE CUMBERLANDS.

2. IN RELATION TO YOUR DOCTORAL PROGRAM APPLICATION, WHAT AREA OF RECENT RESEARCH IN THE FIELD WOULD YOU WANT TO STUDY, AND WHY?

3. HOW DOES YOUR CURRENT VOCATION RELATE TO YOUR APPLICATION TO THE DOCTORAL PROGRAM?

4. HOW WILL YOUR EXPERIENCES AND PERSONAL SKILLS HELP YOU TO BE SUCCESSFUL IN YOUR PROGRAM?

5. WHAT LONG-TERM GOALS DO YOU HAVE FOR APPLYING YOUR LEARNING FROM YOUR DOCTORAL PROGRAM?

Technology Entrepreneurship

Que:1 

Discuss the types of decisions related to each element of the marketing program for delivering a value proposition and positioning it correctly in the minds of the target customer.

Que:2 

Discuss this statement: Collins and Hansen (2011) argue that good results in successful businesses are produced through a combination of paranoia, discipline, and creativity.

Collins, M. and Hansen, J. (2011) Great by Choice. New York: Harper Business.

Que:3

Read the attached case study and write 2 and a half-page summary analysis and answer the Case Study Questions.

Note: My assignments will need actual references from EBSCO host, google scholar, and semantic scholar With a website link at the end.  

Physical Security

 

Topic: My father use to tell me that “locks keep honest people honest”. What do you think he meant by that? Is there any such thing as total security? Once you make your original post comment on a classmates post.

Instructions: Note that the requirement is to post your initial response no later than Friday and you must post one additional post during the week (end of Sunday). I recommend your initial posting to be between 200-to-300 words. The replies to fellow students and to the professor should range between 100-to-150 words. All initial posts must contain a properly formatted in-text citation and scholarly reference.

essay

 In an essay (no more than 500 words) please discuss the following topic:

 

Describe your academic and career plans and any special interests that you are eager to pursue as an undergraduate in Informatics and Computing. If you encountered any unusual circumstances, challenges, or obstacles in completing your education, share those experiences and how you overcame them.