Solved Exp19_Excel_Ch07_HOEAssessment_Employees

Exp19_Excel_Ch07_HOEAssessment_Employees

Project Description:

You work for a clothing distributor that has locations in Iowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main employee data set, use database functions to calculate key summary statistics and create a map, and use financial functions to complete a loan amortization table.

     

Start   Excel. Download and open the file named Exp19_Excel_Ch07_HOEAssessment_Employees.xlsx. Grader has automatically added   your last name to the beginning of the filename.

 

The 1-Data worksheet contains   employee data. You will insert several functions to complete this worksheet.   Column C contains the actual hire dates for the employees. You want to   extract only the year in column G.
 

  In cell G9, insert the appropriate date function to extract the year from the   date in cell C9. Copy the function from cell G9 to the range G10:G33.

 

Next, you want to determine how   many years each employee has worked for the company.
 

  In cell H9, insert the YEARFRAC function to calculate the years between the   hire date and the last day of the year contained in cell G2. Use a mixed   reference to cell G2. Copy the function from cell H9 to the range H10:H33.

 

You want to determine what day   of the week each employee was hired.
 

  In cell I9, insert the WEEKDAY function to display the day of the week the   first employee was hired. Use 2 as the return_type. Copy the function from   cell I9 to the range I10:I33.

 

The value returned in cell I9 is   a whole number. You want to display the weekday equivalent.
 

  In cell J9, insert a VLOOKUP function to look up the value stored in cell I9,   compare it to the array in the range H2:I6, and return the day of the week.   Use mixed references to the table array. Copy the function from cell J9 to   the range J10:J33.

 

Column D contains the city each   employee works in. You want to display the state.
 

  In cell F9, insert the SWITCH function to switch the city stored in cell D9   with the respective state contained in the range C2:C4. Switch Des Moines for Iowa, St. Paul for Minnesota, and Milwaukee for Wisconsin. Use mixed   references to cells C2, C3, and C4. Copy the function from cell F9 to the   range F10:F33.

 

Your next task is to calculate   the bonus for the first employee. If the employee was hired before 1/1/2010,   the employee’s salary is multiplied by 3%. If the employee was hired before   1/1/2015, the employee’s salary is multiplied by 2%. If the employee was   hired before 1/1/2020, the employee’s salary is multiplied by 1%.
 

  In cell K9, insert the IFS function to create the three logical tests to   calculate the appropriate bonus. Use mixed references to cells within the   range K2:L4. Copy the function from cell K9 to the range K10:K33.

 

Top management decided to ensure   all representatives’ salaries are at least $62,000 (cell G2).
 

  In cell L9, nest an AND function within an IF function. If the job title is Representative   and the salary   is less than the minimum representative salary, calculate the difference   between the minimum representative salary and the actual salary. If not,   return zero. Use a mixed reference to cell G3. Copy the function from cell L9   to the range L10:L33.

 

The 2-Summary worksheet contains   data to insert conditional math and statistical functions to provide summary   data. First, you want to count the number of employees in each state.
 

  Click the 2-Summary worksheet. In cell J3, insert the COUNTIF function to   count the number of employees in Iowa, using the state abbreviation column   and the state abbreviation in cell I3. Use mixed references for the range and   cell to keep the row numbers the same. Copy the function from cell J3 to the   range J4:J5.

 

Next, you want to calculate the   total payroll for each state.
 

  In cell K3, insert the SUMIF function to total the salaries for employees who   work in Iowa, using the state abbreviation column and the state abbreviation   in cell I3. Use mixed references for the ranges and cell to keep the row   numbers the same. Copy the function from cell K3 to the range K4:K5.

 

Next, you want to calculate the   average salary for executives and the average salary for representatives.
 

  In cell J8, insert the AVERAGEIF function to calculate the average salary for   executives. Use mixed references to the range and for the cell containing   Executives. Copy the function to cell J9.

 

You want to identify the number   of representatives hired before 1/1/2015.
 

  In cell J12, insert the COUNTIFS function to count the number of   representatives who were hired before 1/1/2015. Use ranges for the criteria   ranges and the reference to cell H9 that contains Representatives. Enter the   date condition directly in the criteria box.

 

In cell J13, insert the SUMIFS   function to calculate the total salaries for representatives hired before   1/1/2015. Use ranges for the criteria ranges and the reference to cell H9   that contains Representatives. Enter the date condition directly in the   criteria box. Use mixed references to the ranges and cell reference so that   you can copy the function in the next step.

 

Copy the function from cell J13   to the range J14:J16. Edit the function in cell J14 to calculate averages.

 

Edit the function in cell J15 to   calculate the lowest salary.

 

Edit the function in cell J16 to   calculate the highest salary.

 

Insert a map to display total   salaries by states.
 

  Select the ranges I2:I5 and K2:K5 and insert a filled map. Change the chart   title to Payroll by State. Cut the chart and paste it in cell M1.

 

The 3-Finance worksheet contains   inputs for a loan.
 

  In cell F2, insert the PV function to calculate the loan. Use cell references   in the Input Area and Basic Output Area.

 

You are ready to insert formulas   and functions in the loan amortization table.
 

  In cell C7, enter a reference to the Payment that is stored in cell D2. Use   mixed reference so that the row number does not change. Copy the formula from   cell C7 to the range C8:C42.

 

The next column is designed to   display the interest portion of each payment.
 

  In cell D7, insert the IPMT function to calculate the interest for the first   payment. Use mixed references for cells in the Basic Output Area and make   sure the result is a positive value. Copy the function from cell D7 to the   range D8:D42.

 

Next, you are ready to calculate   the portion of the monthly payment that goes toward the principal.
 

  In cell E7, insert the PPMT function to calculate the principal portion of   the first payment. Use mixed references for cells in the Basic Output Area   and make sure the result is a positive value. Copy the function from cell E7   to the range E8:E42. 

 

Now you are ready to calculate   the balance of the loan after each payment.
 

  In cell F7, enter a formula to calculate the ending balance after subtracting   the Principal Repayment from the Beginning Balance. Copy the formula from   cell F7 to the range F8:F42.
 

  In cell B8, enter a formula that refers to the ending balance for the   previous month in cell F7. Copy the relative formula to the range B9:B42.

 

Now you want to calculate the   cumulative interest after each payment.
 

  In cell H7, insert the CUMIPMT function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell H7 to the range H8:H42. 

 

Finally, you want to calculate   the cumulative principal after each payment.
 

  In cell I7, insert the CUMPRINC function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell I7 to the range I8:I42.

 

Insert a footer on all three   sheets with your name on the left side, the sheet name code in the middle,   and the file name code on the right side.

 

Save and close Exp19_Excel_Ch07_HOEAssessment_Employoees.xlsx.   Exit Excel. Submit the file as directed.

information technology ….3

Answer the the following questions in your own words. No copy and paste or citations,  

Questions

1- Describe the impact of Oss on the IT market.

2- Show your understanding of the commercial OSS market. How do red hat, oracle, oracle’s sun division and IBM make money via open source?

3- Visit Mozilla.org which open-source products does this organization develop? Investigate how development of these efforts is financed, how does this organization differ from the ones mentioned above?

4- What is the Linux foundation? Why is it necessary? Which firms are members? Underwriting foundation efforts?

5- List the reasons why Linux is installed on only a very small fraction of desktop computers. Are there particular categories of products or users who might see Linux as more appealing than conventional operating system? Do you think Linux ‘s share of the desktop market will increase? Why or why not?

6- How is Microsoft combating the threat of open-source software and other free tools that compete with it commercial products?

7- What is the dominant open-source database software? Which firm use the products? Why?

8- Which firm developed the leading OSS database effort changed in recent years? Who oversee the effort today? What questions does this raise for the office suite or desktop alternative. Why or why not 

9- How has stewardship of the leading OSS database efforts changed in recent years? Who oversees the effort today? What question does this raise for the product’s future? Although this book is updated regularly, current events continue to change after complication of this chapter. Investigate the current status of this effort – reaction of the developer community, reception of the product and be prepare to share your findings with class.

10- List some of the risk associated with using OSS. Give examples of firms that might pass on OSS software, and explain why. 

Discussion 13- Org Behavior

Assigned Readings:Chapter 14. Conflict and NegotiationInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

  1. Pauline has been asked to reorganize her department, eliminating at least two people within the office. Pauline has strong personal relationships with everyone in her office and being asked to complete this task is very hard on her. Thinking back to Stage Four of the conflict process, discuss one of the types of intentions with which Pauline might struggle in this situation.
[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]  [Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word version of the paper for APA review]

Text

Title: Essentials of Organizational Behavior, Student Value Edition 

ISBN: ISBN-13: 9780135468890 

Authors: Stephen P. Robbins, Timothy A. Judge 

Publisher: Pearson 

Edition: 15TH

US compliance laws

  Question A: 

Pick two US compliance laws and provide a brief description. Then, provide your thoughts on if the laws need to be updated or changed in any way. Describe how these laws relate to the CIA triad.  

 Question B: 

Research a unique article on compliance laws. Post a summary of what you learned to the discussion thread, and please also provide a link to the original article. The source is your choice; however, please fully cite your source.

Business Intelligence vs Data Analytics

Other than the fact that the title of the course contains both Business Intelligence AND Data Analytics, these two concepts seem like separate things, right?

Well that’s what this week’s discussion is going to find out.

While we won’t address data visualization in depth in this course, data visualization is never very far from any discussion of data analytics, so I’d like everyone (ALL students, not just the initial post group) to get acquainted with Google’s Ngram Viewer: https://books.google.com/ngrams.

Basically the Ngram Viewer allows you to see a graph of the occurrence of a given word or phrase over a specified period of years in the entire corpus of books contained in the Google Books collection.  You can also enter several words or phrases to compare the evolution of usage over time.  The default (sample) ngram on the day I visited was a comparison of

Albert Einstein,Sherlock Holmes,Frankenstein

which resulted in

Your tasks and the discussion topic(s) this week:

1. ALL students should use Ngram and try various combinations of

  • business intelligence,
  • data analytics,
  • data science.

You  might try allied terms like

  • data analysis,
  • big data.

Be sure to change the years, you’ll definitely want to include through to the current year and I think you’ll quickly find that years before 1900 (sometimes later) don’t show much.  Think about what the graph is showing you in terms of the usage of these various terms.  Be aware that even if you enter the current year, Ngram may change that year depending on the data available (currently, it seems to ‘default’ to 2008 as the most recent year available).

2. INITIAL POST GROUP: in addition to the Ngram exercise, members of the initial post group should also conduct a web search for definitions of at least business intelligence and data analytics.  I’m sure you’ll find more than a few sites willing to compare the two.   The topic this week:

Compare and contrast the terms business intelligence and data analytics.  That is, how are they similar, how are they different?

You should include in your initial post a brief discussion of the Ngram findings AND a brief discussion of your search for definitions.

Computer Graphics

I have code for my assignment, but you have to add more code like create code for background animation and create code for any man or women character in that scne and it has to movable in that background.

A single server illustration with users going through public internet to access a cloud  virtual server app.

Cloud Provider Evaluation Project 3

Project: Cloud Provider Evaluation Start Here

Since you have become familiar with foundations of cloud computing technologies, along with their risks and the legal and compliance issues, you will now explore cloud offerings of popular cloud providers and evaluate them to recommend one that would be the best fit for BallotOnline.

In this project, you will first learn about networking in the cloud and auxiliary cloud services provided by cloud vendors. Next, you will explore cloud computing trends, best practices, and issues involved in migrating IT deployments to the cloud, as well as typical architectures of cloud deployments. Then, you will apply your findings to propose a general architecture for BallotOnline’s cloud deployment to best address the company’s business requirements.

Once you have selected a deployment architecture, you will research two leading cloud vendors: Amazon Web Services (AWS) and Microsoft Azure. Exploring and comparing the tools available for application migration will enable you to recommend a vendor to the executives in your final report. The final deliverable is a written report to BallotOnline management, describing the results of your research and recommending the cloud deployment architecture and the vendor for its deployment, with justification.

Your final report should demonstrate that you understand the IT needs of the organization as you evaluate and select cloud providers. The report should include your insights on the appropriate direction to take to handle the company’s IT business needs. You will also be assessed on the ability to integrate relevant risk, policy, and compliance consideration into the recommendations, as well as the clarity of your writing and a demonstration of logical, step-by-step decision making to formulate and justify your ideas.

Take Note

This project has a hands-on lab that you need to complete. Instructions for the lab are included in the steps of this project. If you have technical difficulties in completing the lab, we have technology support assistants available to help.

Competencies

Your work will be evaluated using the competencies listed below.

· 2.2: Locate and access sufficient information to investigate the issue or problem.

· 2.3: Evaluate the information in a logical and organized manner to determine its value and relevance to the problem.

· 2.4: Consider and analyze information in context to the issue or problem.

· 2.5: Develop well-reasoned ideas, conclusions or decisions, checking them against relevant criteria and benchmarks.

· 5.4: Articulate insights to leadership on the appropriate course of direction on the identified IT business needs.

· 6.1: Articulate the systems architecture of the cloud – cloud infrastructure, cloud service, cloud platform, and cloud storage.

· 6.6: Evaluate and select cloud providers (AWS, Azure, VMware, Google Cloud, IBM).

· 6.8: Review, evaluate, and utilize emerging technologies related to cloud to support business needs.

Step 1: Research Networking and Auxiliary Services in the Cloud

The executives at BallotOnline have been impressed with your research on cloud computing thus far. While there are a variety of cloud providers, BallotOnline is considering using Amazon Web Services (AWS) and Microsoft Azure, two of the top providers in the market. BallotOnline’s executives want you to help determine which would be the best provider for the organization.

You will start with learning about internet networking basics and cloud networking. You will also research many cloud services that cloud providers make available to their customers to help them take full advantage of cloud service and deployment models.

Step 2: Research Cloud Trends, Best Practices, and Migration Issues

The cloud computing revolution is redefining ways that companies of all sizes use information technology. The cloud landscape shifts rapidly, and current trends reflect this rapid pace of change. You likely got an idea about this in the last step when you conducted research on cloud architecture. Now, continue gathering information for your final report by assessing:

· issues outside the company, such as emerging issues in the industry, regulatory changes, and general trends in cloud computing to gain an understanding of how these issues may influence BallotOnline’s decisions;

· best practices for cloud implementation and assess whether BallotOnline can benefit from these;

· cloud migration strategies for the application and data, since BallotOnline is moving an existing web application to the cloud, making sure that the application is configured properly for the system architecture of your cloud deployment; and

· IT change management techniques that could help BallotOnline make this transition.

Step 3: Research Typical Architectures of Cloud Deployments

In the previous step, you considered best practices and trends in the cloud industry. Next, you will have to look at the kinds of architectures needed for cloud.

Because most elements of cloud deployments are implemented in a virtualized environment controlled by software, the degree of freedom in defining your deployment of cloud reference models is unprecedented. You can define the number of virtual servers required and the configuration, and even change them dynamically as needed. You can also define your virtual local area networks (LANs) and subnets, and place servers in them to implement network security requirements.

The basic cloud deployment components are cloud consumer, cloud provider, and cloud carrier, with cloud brokers and auditor as possible additions.

Typical cloud architectures of cloud deployments vary from single server (suitable for proof-of-concept engagements) and multiserver architectures with various servers carrying different software components and occupying different security zones, to geographically dispersed deployments to achieve high availability, resilience, and speed of delivery. There are several issues to consider when selecting a server architecture, including cost, scalability, performance, and use of management.

For this step, research the typical architectures of cloud deployments and begin to consider what might be a good fit for BallotOnline. Discuss your findings and thoughts with your colleagues in the Discussion: Cloud Architectures forum.

In the next step, you will continue research, this time on trends in cloud computing as well as issues that can arise during data migration.

Step 4: Propose Cloud Architecture for BallotOnline Deployment

Now that you have looked into cloud architectures, in this step, you will propose the cloud deployment architecture for BallotOnline, applying the knowledge of typical architectural elements of cloud deployment from the project’s initial step. You will also consider trends and migration issues from a previous step. Your recommendation should consider the company’s business requirements.

Recall that the company has an existing web application that it wants to move to the cloud, and also that the company wants to expand its business to other parts of the world. In earlier projects, you learned about and analyzed the IT business requirements for BallotOnline. Among them were demands for application and data security, data encryption, and separation for deployments overseas. Also, the application should handle load peaks during election times in different regions.

Specific technical requirements state that BallotOnline is a web application, written using the popular open-source LAMP (Linux, Apache, MySQL, PHP) software suite and the PHP application.

Take Action

Describe your proposed architecture by submitting a report with a drawing of the architecture (hand-drawn or computer-created) diagram and explaining its elements in the dropbox below.

Here are some sample drawings of typical cloud architectures to give you an idea.

Typical Cloud Architectures

Single Server

The most basic use of the cloud is to provision a single virtual server, running your application along with supporting service applications such as a database. Although a single server is not much of an architecture, it can be used in a proof of concept project to get your first experience with a particular cloud provider and see how easy and how fast the provisioning process is.

A single server illustration with users going through public internet to access a cloud  virtual server app.

Single Server with Services

Instead of packing everything into a single server, a cloud consumer can advantage of services available from the cloud provider. Here, we illustrate the use of a firewall service and a database service. The provider will be responsible for provisioning the services and keeping them running. The cloud consumer needs to populate and administer the data in the database service. To accomplish that, the cloud consumer’s database administrator will access the database using a virtual private network (VPN) connection over the Internet to ensure security. The virtual server will run the business application and will connect to the database service via a private network within the cloud provider’s data center.

A single server with services illustration with users going through public internet through a firewall to access a cloud  virtual server app and a database administrator going through a VPN to a cloud database service and connecting to the virtual server through a private network connection.

Application with Security Zones and On-Premise IT Connectivity

For large databases, proprietary data storage solutions, or databases unsupported by the cloud provider, the data can be stored in a separate database virtual server. The cloud provider will maintain the server but not the database. Because businesses value their data as their most precious commodity, they will want to secure it by isolating it from public Internet.

This can be accomplished by placing the database server in a separate private virtual local area network (VLAN) than the application server, or a separate subnet in the same VLAN as the application server. These VLANs (or subnets) will enforce security zones for their devices. They will be made available to the outside by using network gateways: an Internet gateway for the application server and a VPN gateway for the database server. In addition, a network address translation (NAT) gateway between the security zones will make sure that only trusted traffic can pass between them. These gateways are often offered as a service by the cloud providers.

The VPN gateway for the database server can connect it to the on-premises enterprise network of the cloud consumer, for taking on-premise backups, or integrating the cloud solution with on-premises systems, enabling hybrid cloud deployments.

A illustration with users going through public internet and internet gateway through a a virtual LAN and application server to access NAT gateway  to a virtual LAN database server. The on premise IT systems access this through a VPN gateway.

Load Balancing, Auto-Scaling, Database Replication

User loads placed on web applications can differ significantly depending on the time of the day, week, year, or any other circumstances. To remedy that, cloud providers offer auto-scaling services. The cloud consumer can define an auto-scale group, specifying a lower and upper limit on the number of servers in the group, the machine images from which the servers are provisioned, and circumstances leading to up-and down-scaling in the group. These can be based on calendar, or use of network bandwidth, CPU, or memory on the servers.

In order to split the incoming requests among the servers, a load-balancing service directs the requests to the members of the group based on server use, or various queuing algorithms (round-robin being the simplest).

With the database server, duplication requires keeping copies of the database in sync. A preferred solution is to have one master database server, with a slave database server — one using the database provider’s replication and synchronization capability. It ensures the fault tolerance with respect to the database.

A illustration with users going through public internet to a load balance, into a auto-scale group. Inside the cloud is master database server, virtual LAN, and a slave database server all going out through a VPN.

Fault Tolerance and High Availability

The concept of replication can be extended to the application server, providing for a cloud deployment that is fault-tolerant with respect to servers, and ensuring availability in situations such as natural disasters or other circumstances that cause the whole data center to go offline.

In addition, the application and databases can be replicated to different geographical regions, ensuring fast access from remote geographical locations. And, replication can help satisfy local government regulations regarding data privacy, which may require the user’s data to reside within specific regions.

A North American users and European Union users going through an LB to access both the North America Data Center and the Europe Data Center application servers and database servers.

Fast Delivery of Static Content – Object Storage, Content Delivery Network

While dynamic application data has to reside within the database server or service, static content such as text, graphics, video, or audio files that don’t change that often can reside in a slower but less expensive media. For that purpose, cloud providers offer object storage, which can be thought of as an Internet-based file system, allowing for storage of files organized into containers in a geographically distributed, replicated, secured storage. While not at the speeds of local storage, object storage offers fault tolerance, resilience, and virtually unlimited capacity at the cost of data consistency being “eventual” rather that immediate.

Data stored in object storage can be often served by content delivery networks (CDNs) – a service allowing for geographically distributing data and serving it from the closest geographical location to the place from which the data request originates.

A North American users and European Union users using application access and static data (CDN) access to North American and European Union application servers, database servers, and objects storage.

Architecture Components Can Be Mixed and Matched

Bear in mind that cloud providers may allow some of the architectural components illustrated here to be mixed and matched. For example, the auto-scale groups and replicated databases could be placed in security zones, and VPN gateways could be linked to different servers to corporate on-premises networks.

In the next step, you will begin researching the specific providers, starting with Amazon.

Step 5: Research AWS

You’ve described your proposed architecture and included a diagram to provide leadership a way to envision the system. Now, it’s time to look closely at the leading cloud providers to see if their services will fit BallotOnline’s needs.

Each cloud provider provides a unique profile of services, so it is good practice to compare cloud vendors and evaluate their reliability, performance, ease of use, cost, security and compliance measures. As more providers enter the marketplace, many will specialize on specific needs and use cases, making this evaluation even more critical.

In this step, you will explore AWS and assess the feasibility of this platform for deploying the architecture proposed in the previous step. You should also consider issues related to AWS Pricing.

Based on your research, determine to what degree AWS supports the elements of the BallotOnline business and technical requirements.

Share your thoughts with your colleagues in the Discussion: Amazon Web Services Feasibility forum. In the following step, you will do the same for Microsoft Azure.

Step 6: Research Microsoft Azure

Now that you have had a chance to research AWS, it’s time to explore Microsoft Azure, another cloud provider that could be used to deploy the proposed architecture. You should also consider issues related to Microsoft Azure pricing.

Based on your research, determine to what degree Microsoft Azure supports the elements of the BallotOnline business and technical requirements. Share your thoughts with your colleagues in the Discussion: Microsoft Azure Feasibility forum.

Now that you have completed research on the cloud providers, in the next steps you will work on proof of concepts for each provider.

Step 7: Generate AWS Proof of Concept (POC)

With your research complete, you will now deploy a simple one-page PHP application to the AWS cloud. It will allow you to explore deployment methods, ease of use, provisioning speed, etc., for the Amazon cloud.

Take Action

As you may have already discovered in your research on AWS, it makes a cloud migration tool called Elastic Beanstalk available for customers to migrate their existing applications into the AWS cloud. We will use this tool to deploy your AWS proof of concept (POC).

Follow the steps in the AWS lab instructions to complete your AWS POC.

In the dropbox below, upload the URL linking to your application running in the AWS portal.

Step 8: Generate Azure Proof of Concept (POC)

Now that your AWS POC is complete, you can proceed with a similar POC deployment for the Microsoft Azure cloud.

Take Action

Follow the steps in the Azure lab instructions to complete your Azure POC.

In the dropbox below, upload the URL linking to your application running in the Azure portal.

You are ready for the last step: writing the final report with recommendations on the cloud providers for the BallotOnline executives.

Step 9: Write the Final Report Evaluating AWS and Azure Providers

Now that you have completed your research, shared your ideas with colleagues, and explored the two vendors, it is time to compile your findings and recommendations for the BallotOnline executives. You may find these considerations for cloud provider selection helpful in making your decisions.

Use the Final Report Evaluating AWS and Azure Providers Template to write your report and submit your work to the dropbox below.

Check Your Evaluation Criteria

Before you submit your assignment, review the competencies below, which your instructor will use to evaluate your work. A good practice would be to use each competency as a self-check to confirm you have incorporated all of them. To view the complete grading rubric, click My Tools, select Assignments from the drop-down menu, and then click the project title.

· 2.2: Locate and access sufficient information to investigate the issue or problem.

· 2.3: Evaluate the information in a logical and organized manner to determine its value and relevance to the problem.

· 2.4: Consider and analyze information in context to the issue or problem.

· 2.5: Develop well-reasoned ideas, conclusions or decisions, checking them against relevant criteria and benchmarks.

· 5.4: Articulate insights to leadership on the appropriate course of direction on the identified IT business needs.

· 6.1: Articulate the systems architecture of the cloud – cloud infrastructure, cloud service, cloud platform, and cloud storage.

· 6.6: Evaluate and select cloud providers (AWS, Azure, VMware, Google Cloud, IBM).

· 6.8: Review, evaluate, and utilize emerging technologies related to cloud to support business needs.

Abstract of Qualitative Research Article

The term “abstract” is a homophone that can mean one of two scholarly writing activities. One is the abstract that you will write to introduce your dissertation. The other meaning is a shortened writing assignment whereby you write a condensed summary of an academic journal.  For this week, we will focus on writing a scholarly abstract of a qualitative journal. More information about writing an abstract can be found via the web resource “Writing Scholarly Abstracts.”