Exp19_excel_ch04_cap_tech_support | Computer Science homework help


Exp19 Excel Ch04 Cap Tech Support 


Project Description:

You have been hired as a student assistant in the IT department of your University. As part of your responsibilities, you have been asked to enhance the Excel workbook used to analyze the departments performance. The workbook contains records of all support issues resolved over the past year. You will convert the data to a table, format the table, sort and filter the table, insert calculations to evaluate key performance indicators, and prepare the worksheet for printing


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


Freeze Panes so the first row   containing column headings (Row 5) on the SupportCalls worksheet will remain   static when scrolling. Ensure that Rows 1-4 are visible.


Convert the data to a table,   name the table SupportCalls, and apply the Gold, Table Style Medium 12.


Remove duplicate records.


Add a new column to the table   named Duration.


Create a formula using   unqualified structured references to calculate the days required to resolve   the incident (Date Resolved – Date Created).


Add a total row to display the   Average days required to resolve an issue.


Sort the table by Agent Name in   alphabetical order, add a second level to sort by Description, and create a   custom sort order as follows: Will not power on, Virus, Printing Issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to   largest.

  Mac users, to create the custom list, from the Excel menu, click Preferences.   In the dialog box, click Custom Lists.


Filter the table to only display   closed incidents as indicated in the status column.


Use Quick Analysis to apply the   default Data Bars conditional formatting (Solid Blue Fill) to the Duration   column (range I6:I85). Mac users, on the Home tab, click Conditional   Formatting, point to Data Bars, and under Solid Fill, click Blue Data Bar.


Create a new conditional format   that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve. Be   sure to use relative cell references in the conditional format formula.


Change page breaks so page 2   begins with the Computer ID column (column E).


Set the print scale to 85%.


Add a custom footer with your   name on the left side, the sheet name code in the center, and the file name   code on the right side.


Save and close the workbook.   Submit the workbook as directed.

Interview one of your classmates and ask them what they think about


Interview one of your classmates and ask them what they think about the articles they read each week. Were there any recommendations for practice that they thought could be implemented in their clinical practice tomorrow? Next week? Next year? What is their rationale? Do you agree or disagree? 

Remember to cite your author!

Citing personal communications in APA Style

In APA Style, personal communication is any source that is not accessible to your readers. Personal communications are cited in the text, but not included in the reference list.


Another researcher stated that the results so far looked “very promising” (A. Smith, personal communication, July 15, 2021).

Submission Instructions:

  • Your initial post should be at least 500 words, formatted, and cited in current APA style with support from at least two academic sources.

Last month you were hired with the title chief health


Last month you were hired with the title Chief Health InformaticsSpecialist at an independent community care hospital with 350 beds. The hospital includes a comprehensive outpatient clinic, a rehabilitation center with both impatient and outpatient services a cardiac care center, and an emergency room. In addition, four family health centers are located throughout the community. More than 930 primary care and specialty physicians are associated with the hospital, which has a staff of just over 2000 employees. The hospital is moving ahead with installing an HER system following the Meaningful Use criteria.

The hospital has a working relationship with a major academic medical center located 23 miles aay. Acute care patients who need more extensive treatment are usually transferred to the medical center. These are often emergency situations and data are freely shared between institutions with the best interests of the patient in mind.

Located directly beside the hospital is a 194-bed skilled nursing home. While the nursing home has its own medical staff consisting of a physician and two nurse practitioners, patients needing consults or additional care are usually seen at the hospital with follow-up at physician’s offices. While the nursing home, most of the physicians’ offices, and the hospital are independent institutions there is a long history of sharing health relate data when treating patients who live at the nursing home and are seen at the hospital or in the physicians’ offices. This coordination has been a general benefit for a number of patients. It appears that most patients have signed a form giving the hospital permission to send information to the nursing homes. However, these forms have been stored in individual offices so it is difficult to determine who has signed what forms and what permission has or has not been given to share information between the nursing home, hospital and independent medical practices.

Chapter 19  2 pages

  • Describe: What additional information is needed to clarify what problems may exist, and what changes may be needed in terms of shared data between the institutions?
  • Examine: Can the EHR system currently being installed be used to share data between these institutions more effectively and securely? If yes, how would this be done?
  • Compile: In your position as Chief Health Informatics Specialist, how would you go about determining whether there are other potential security issues that now need to be managed by the hospital?

Case Study Chapter 21

A tertiary care center in the western U.S. has an installed base of electronic health records supported by Cerner Corporation for inpatient areas and by EPIC for outpatient areas. Other technology includes a suite of about 300 different applications supported by the IT department. The current environment, while including robust capabilities such as computerized provider order entry, is siloed with information. Healthcare providers complain that they have difficulty obtaining the big picture of the patient across systems and they have to remember information located in disparatesystems. They are burdened with integrating information themselves. Not only is this time consuming, it is potentially prone to error. Providers have developed numerous work-arounds to the different systems in ambulatory and inpatient areas, including shadow files for patients they see frequently. Nurses complain that they have to jump around the inpatient system to find information they need for activitiessuch as patient hand-offs.

The organization responds by developing a vision for the future that centered on the concept of knowledge management (KM). This concept is defined as the systematic process of identifying, capturing, and transferring information and knowledge that people can use to create, compete (with other organizations), and improve. A crucial aspect of KM is improving the user experience. As the leaders in the organization begin to address KM and improve the user experience, they are employing the same tactics described in this chapter

Chapter 21 2 pages 

  • Describe: Assume you are the leader of the KM effort. Where would you start to improve the user experience?
  • Examine: Pharmacists supporting the ICUs are asking for your help to improve their situation (their user experience) because they are forced to use nonintegrated systems. What methods would you use to examine the issue?
  • Compile: The institution is in the process of purchasing new physiologic monitors for their step-down unit. Describe how usability should be incorporated as part of the purchasing process. Design a brief usability test to support the purchasing process.

Reading | Political Science homework help

I want you to read these reading and answer these questions for each reading

  1. What’s the title of the reading and the name of the author?
  2. What is / are the key arguments of the reading?
  3. What theories and concepts are used in the reading? What are the examples?
  4. What are the key strengths and weaknesses of the reading?
  5. What do you particularly agree / disagree with and why? 

2 pages, first page 

1) P. Williams, ‘Security Studies: An Introduction’, in P. Williams, Security Studies: An Introduction, pp. 1-12. 2) Waever, Ole and Barry Buzan, ‘After the Return to Theory: The Past, Present and Future of Security Studies’, in Alan Collins, ed. Contemporary Security Studies (Oxford: Oxford University Press, 2006), 417-435.

Second page 

1) William Wolforth, ‘Realism and Security Studies’, in Cavelty and Balzacq (eds), Routledge Handbook of Security Studies, 11-21. 

2) John Mearsheimer, ‘Back to the Future’, International Security 15: 1 (1990), 5-56.

Bu345-7 unit 4 discussion | Management homework help



  • The weekly requirement is for students to participate in a meaningful discussion with peers.
  • A minimum of two (2) peer response posts are required weekly, resulting in at least three (3) total posts for the week.
  • Initial posts must be at least 250 words in length.
  • The initial and secondary posts should be meaningful and should promote further discussion.
  • Please refer to the discussion threads grading rubric for more information about the quality of posts.
  • All discussion posts should use complete sentences, proper grammar and spelling, and APA citation guidelines if you refer to an outside source.
  • Refer to the textbook and external sources, being certain to use APA Guidelines to properly include in-text citations and a reference list at the end of your discussion posts.
  • Your list of references should be single-spaced and not contain any indentation.
  • It should be noted that in your professional experience emails in capitalized letters means the person is screaming or yelling.

Some of your project team members don’t think it is possible to carry out all the activities associated with hosting a luncheon by the date specified.  Your team is now tasked with developing a project network diagram.  Conduct research and find two software programs that can be used to develop project network diagrams.  Compare and contrast the programs.  Which program do you feel is superior?  Why?  Explain your answer.

Please be sure to validate your opinions and ideas with citations and references in APA format.

A strategic management plan addresses four different management


A strategic management plan addresses four different management functions: environmental scanning, strategy formulation, strategy implementation, evaluation and control. Weeks 3, 4 and 5 individual assignments (Part 1, Part 2 and Part 3) are integrated to generate a strategic management plan. The purpose of the Week 3 individual assignment is to evaluate the internal and external environments of a company selected by the student, to analyze the competitive advantage of the selected company, to evaluate a set of suitable strategies, and to examine appropriate metrics. 

This assignment provides students an opportunity to research a selected company as if they were involved in a company’s actual strategic management planning process.  It allows students to see which management planning process and management plan the selected company is currently using, allowing them to measure the effectiveness of current strategies. 

A Strategic Management Plan addresses four different management functions: Environmental Scanning, Strategy Formulation, Strategy Implementation, Evaluation and Control. 

The Week 3, 4, and 5 Individual Assignments (Part 1, Part 2, and Part 3) are integrated to generate a Strategic Management Plan. This is Part 1 of the three part Strategic Management Plan. 

Assignment Steps 

Write a 1,050-word report in which you select a company you are familiar with or a company where you currently work, and do the following: 

  • Evaluate the internal and external environments of your selected company using an environmental scan.
  • Analyze the competitive advantage of your selected company.
  • Evaluate the strategies your selected company uses to create value and gain competitive advantage.
  • Examine the measurement guidelines your selected company uses to verify its strategic effectiveness.
  • Evaluate the effectiveness of the measurement guidelines your selected company uses. 

Cite 3 scholarly references, including at least one peer-reviewed reference from the University Library. 

Personal toolkit for critiquing research articles article malina,


Personal Toolkit for Critiquing Research Articles


Malina, M. A. & Selto, F. H. (2001). Communicating and controlling strategy: An empirical 

  study of the effectiveness of the balanced scorecard. Journal of Management Accounting,

  13(1), 47-90.doi:10.2308/jmar.2001.13.1.47

Summary – A succinct summary include results of the study.  That way, after reading the first paragraph, the reader would know the purpose, hypotheses, and findings.

What is the purpose of the study?

What is the sample and sample size?

Method used – Describe specifics about the research design, including the sample, instrumentation, and data analysis. Ecological and population generalizability were discussed. 

What is the data analysis used? What are the results? – Explanations on the data analysis.  Less specific information on statistics but more information on the literature review.

The discussion, conclusion, and recommendations

Discuss threats to internal validity.

Suggestions regarding how these threats could have been dealt with.

Discuss the literature review. 

Show high level of understanding. 

Know what the weakness of the study.

Provides ways the study could have been improved.

Generate a response to each peer discussion. each response may


Generate a response to each peer discussion. Each response may include information from the text, handouts (attached), personal experiences and opinion to demonstrate critical thinking and application. At least one source must be cited and referenced in each initial post.

BOOK I’M USING: Dyer, J., Godfrey, P., Jensen, R., & Bryce, D. (2016). Strategic management: Concepts and tools for creating real world strategy. Hoboken, New Jersey: John Wiley & Sons, Inc.

Here is what the discussion is about:

Using an industry with which you are familiar, apply each element of Porter’s Five Forces model (Porter, 2008) to the industry by briefly explaining how each element affects the industry. Selecting one company from within that industry, select 2-3 of the 8 general environment trends (Dyer et al, 2016, pp. 34-38) that are having or could have the most impact on the company. Justify your selection of trends using sources.

Here are the discussions that need responses:


Railroad industry in North America.

Threat of new entrants: Low

  • Finite availability of tracks.
  • Capital intensive to develop new tracks.
  • Capital intensive to purchase and maintain equipment.

Threat of substitutes: Moderate – High

  • Freight shipping could occur through other means such as trucks, sea, and air.
  • Passenger travel could occur via automobile and planes.

Rivalry among existing firms: Moderate

  • Only a small number of freight and passenger railways exist.
  • Limited substitution options.
  • Differentiation limited to service and on-time records and capacity to serve.
  • Exit barriers high considering asset depreciation, workforce contracts.

Bargaining power of buyers: Low

  • Limited freight & passenger options.
  • Varying switching costs.

Bargaining power of suppliers: High

  • Unionized workforce.
  • Limited bulk fuel options.
  • Limited car and locomotive manufacturers.

Environmental factors affecting railroad company CSX:

Within the railroad industry, economic conditions and political, legal, and regulatory factors have and will continue to impact CSX. In recent years, earnings and volumes have been down significantly, and can be traced to the reduced demand for coal and the bottoming out of commodity prices (Bryan, 2016). However, a silver lining can be found in the fact that the transportation of petroleum products is up appreciably; with CSX carrying almost “50,000 car loads by rail in 2013” (Lacey, 2014, para 6). The uptick in oil transport can be directly linked to political, legal, and regulatory factors.

“When new laws are passed, they may alter the shape of an industry and influence the strategic actions that firms might take” (Dyer, Godfrey, Jensen, & Bryce, 2016, p 38). Currently, the keystone XL pipeline is being held up because of delays in environmental impact reports as well as in the courts to decide if landowner rights have been violated; which places doubts that the pipeline will completed in the near term (Lacey, 2014). In the meantime the unintended benefactors are company’s like CSX that transport the oil in the absence of the pipeline, and also find themselves laying new track just to keep up with demand (Lacey, 2014).

The shuttering of coal mines may have impacted CSX and other railroads negatively, but the keystone troubles may very well be what lifts volumes and earnings for years to come.



The healthcare industry is a complex industry and has its many challenges. With Porter’s Five Forces the threat of new entrants to the market is not likely, because of the cost of capital to enter the market is of significant value and only serious players would consider it. Bargaining is a win for the hospital industry, because patients have very little bargaining power. The cost will remain high and the patient can’t do much about it. Bargaining for the supplier of medical suppliers is high and can drive up the costs. There is little the hospital can do and the supplier has some leverage with providing high quality and safe products. Rivalry in most cases is not a big deal and most patients are brought to the nearest hospital. Threat of substitution is minimal with some homecare and natural remedies. Over all the costs of healthcare is the primary concern for the industry. Another bargaining obstacle is the costs of the doctors which drives up the enormous prices use consumers receive (Porter, 1996).

Geisinger is a large provider of healthcare facilities in the Pennsylvania. Operating roughly a dozen in-resident patient facilities and providing a large portion of the healthcare needs for an expansive region. The two general environmental trends that s feel has a future impact on the company are technological change and political, legal, and regulatory forces. With the change in technological advances comes the ease of practicing medicine. Devices are being modernized and can create an area where competition can move in and take a portion of the market. Especially in the preventive care market of having specialized smaller facilities. The political environment of the last administration has also put a hindrance on the industry with increased regulations and new laws. For example, the federal Affordable Health Care Act, enacted in 2009, mandates that health insurers cover everyone, including those with preexisting conditions. This may change the cost structure of the industry, potentially resulting in consolidation and less rivalry, as inefficient firms either go out of business or are acquired by more viable firms (Dyer, Godfrey, Jensen, & Bryce, 2016, p 38).

Overall, I think this industry has many challenges and they will not be resolved too soon. The cost associated with the training needed by all employees, equipment, facilities, insurance companies and regulations is a huge obstacle.



For this assignment we will look at Porter’s five forces of: rivalry, buyer power, supplier power, threat of new entrants and threat of substitute products for as they apply to the retail industry (Dyer, Godfrey, Jensen, & Bryce, 2016, p 25). Rivalry in the retail industry is extremely competitive and requires the company to keep prices at a minimum. Key to this rivalry is the differentiation that firms must place on their products and then convey those differences to the public (Delaney, 2017). Buyers carry all the power in the retail industry because they have many options when it comes to where they make their purchases. Getting the best price is extremely important to buyers and easy thanks to new advances in technology that allow for searching both brick and mortar as well as internet based stores. Suppliers have very little power in the retail industry because department stores are now able to buy their products from across the entire globe or even produce their own name brands. While competing with large national retailers is nearly impossible, small retail stores are constantly opening to serve niche markets that are underserved by the national retailers. Substitute products are available online and in-store in most cases where there are few differences in the features of the product itself.

JC Penney operates within the retail industry and they have faced several challenges in recent years. Technological changes have severely changed the retail industry recently. Online companies like Amazon have technologies that allow shoppers to instantly compare prices between the store that they are standing in and the online prices. Additionally this technology allows the user to read reviews from other users that have purchased the same product. The economic growth of our country has a huge impact on the success of JCPenney. Without any growth of the economy the company must look to other geographic regions to experience any growth. In tough economic times the consumer will reduce their purchasing habits in order to save money. JC Penney must keep their focus on value proposition in order to identify the customers they wish to serve, the needs of those customers, how they will satisfy those needs and the benefits to the customer (Horwath, 2014, p42

Job candidate assessment tests go virtual

 Goal: Read and review the selected case study from the required text, and answer the analysis questions.

Read: Chapter 6, case 1: Job Candidate Assessment Tests Go Virtual

Format Requirements: Each answer is to be clear and concise, and students will lose points for improper grammar, punctuation, and spelling. Journal articles and books, if used, must be referenced according to APA style.


Submission Requirements: Please answer the attached questions at the end of the case for this case study. Your answers must present a research-based rationale (citing outside sources) when appropriate. For other questions, you are to use your knowledge of other business areas, your creativity, and own experience to provide solutions, recommendations, scenarios, and/or justifications in your response. Cases are due Sundays at 9:00 PM ET.

From: Snell, S.A. & Morris, S.H. (2019). Managing Human Resources(18th ed.). Boston, MA: Cengage Learning, INC.