Your written assignment for this module should be a 1-2 page paper (not including title page and reference page) that describes the following:
You should include a minimum of 3 scholarly references. Include a title page, in-text citations, and a reference page in APA format.
Start Excel. Download and open the file named Exp19_Excel_AppCapstone_ComprehensiveAssessment- Manufacturing.xlsx. Grader has automatically added your last name to the beginning of the filename.
Group all the worksheets in the workbook and fill the range A1:F1 from the Insurance worksheet across all worksheets including the formatting. Ungroup the worksheets after the fill is complete and ensure the Insurance worksheet is active.
Click cell I5, and enter a function that determines the number of full-time employees, (FT).
Enter a database function in cell I6 that determines the average salary of all full-time employees with at least one dependent. Format the results in Accounting Number Format.
Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions.
Use Auto Fill to copy the function down, completing column E. Be sure to use the appropriate cell referencing. Format the data in column E with the Accounting Number Format.
Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format.
You mention that wealth disparity is a possibility with the application of new technologies, and cite the importance of equality in benefits. I think that assertion raises an interesting question. Are there any examples of a new technology that truly ‘achieves equality in its benefits?’ For example, environmentally-conscious products can be expensive; on one hand, they benefit the environment but on the other hand, they are inaccessible to lower-income Americans.
Another question raised is if there a way that AI or data management could address this? It’s fascinating to explore ethical concerns and how standards are defined and maintained!
Q1. 275 words
What do you think were the critical factors that fueled the need for IT governance? In what ways did ISO affect the standards for network security?
Q2. Research paper – COSO Framework : 5 pages ——- Separate Document
The COSO framework of internal controls is practiced within companies around the world. The objectives of the COSO framework are closely related to its five components. For this week’s activity, please discuss these five components of the COSO framework. Be sure to include each components’ impact on each of the COSO framework objectives. What do you feel an auditor would most be concerned with during an IT audit? Lastly, discuss suggestions for integrating COSO framework compliance into a company in which you are familiar.
Your paper should meet the following requirements:
Hello, could you please look over this assignment? It has 48 Quote text and 18% grammar. I was checking to see if you could do it tonight.
Complete the two tasks associated with project integration management and the three tasks associated with project scope management (…total of five tasks) Put all your work on a one word document. Separate your tasks beheadings and page inserts. Remember… turn your work in on a word document as ONE attachment for grading.
***Note: This running case starts here and continues through the rest of the course. Tasks based on this case are explained following the case study. These tasks will begin to build on work done in previous weeks.
Project Integration Management: Case Study
Manage Your Health, Inc. (MYH) is a Fortune 500 company that provides a variety of healthcare services across the globe. MYH has more than 20,000 full-time employees and more than 5,000 part-time employees. MYH recently updated its strategic plan; key goals include reducing internal costs, increasing cross-selling of products, and exploiting new Web-based technologies to help employees, customers, and suppliers work together to improve the development and delivery of healthcare products and services. Below are some ideas the IT department has developed for supporting these strategic goals:
1. Recreation and Wellness Intranet Project: Provide an application on the current intranet to help employees improve their health. A recent study found that MYH, Inc. pays 20 percent more than the industry average for employee healthcare premiums, primarily due to the poor health of its employees. You believe that this application will help improve employee health within one year of its rollout so that you can negotiate lower health insurance premiums, providing net savings of at least $30/employee/year for full-time employees over the next four years. This application would include the following capabilities:
o Allow employees to register for company-sponsored recreational programs, such as soccer, softball, bowling, jogging, and walking.
o Allow employees to register for company-sponsored classes and programs to help them manage their weight, reduce stress, stop smoking, and manage other health-related issues.
o Track data on employee involvement in these recreational and health-management programs.
o Offer incentives for people to join the programs and do well in them (e.g., incentives for achieving weight goals, winning sports team competitions, etc.).
2. Health Coverage Costs Business Model: Develop an application to track employee healthcare expenses and company healthcare costs. Healthcare premiums continue to increase, and the company has changed insurance carriers several times in the past 10 years. This application should allow business modeling of various scenarios as well as tracking and analyzing current and past employee healthcare expenses and company healthcare costs. This application must be secure and run on the current intranet so several managers and analysts can access it and download selected data for further analysis. The new application must also import data from the current systems that track employee expenses submitted to the company and the company’s costs to the insurance provider. You believe that having this data will hel pyou revise policies concerning employee contributions to healthcare premiums and help you negotiate for lower premiums with insurance companies. You estimate that this application would save your company about $20/employee/year for fulltime employees over the next four years and cost about $100,000 to develop.
3. Cross-Selling System: Develop an application to improve cross-selling to current customers. The current sales management system has separate sections for major product and service categories and different sales reps based onthose products and services. You see great opportunities to increase sales to current customers by providing discounts when they purchase multiple products and services. You estimate that this system would increase profits by $1 million each year for the next three years and cost about $800,000 each year for development and maintenance.
4. Web-Enhanced Communications System: Develop a Web-based application to improve development and delivery of products and services. There are currently several incompatible systems related to the development and delivery of products and services to customers. This application would allow customers and suppliers to provide suggestions, enter orders, view the status and history of orders, and use electronic commerce capabilities to purchase and sell their products. You estimate that this system would save your company about $2 million each year for three years after implementation. You estimate that the system will take one year and $3 million to develop and require 20 percent of development costs each year to maintain.
Project Integration Management: Assignment (2 Tasks)
Evaluate the four projects by preparing a weighted scoring model using the template provided. Develop at least four criteria, assign weights to each criterion, assign scores, and then calculate the weighted scores. Write a one-page paper that describes this weighted scoring model and the results. Copy your spreadsheet and bar chart with the results to the memo.
Prepare a project charter for the recreation and wellness intranet project. Assume that the project will take six months to complete and cost about $200,000. Use the charter template provided and the sample project charter provided in chapter 4 as guides.
Project Scope Management: Case Study
Managers at Manage Your Health, Inc. (MYH) selected Tony Prince as the project manager for the Recreation and Wellness Intranet Project. The schedule goal is six months, and the budget is $200,000. Tony has previous project management and systems analysis experience within the company, and he is an avid sports enthusiast. Tony was starting to put the project team together. He knew he would have to develop a survey to solicit input from all employees about the new system and make sure it was user-friendly.
Recall that this system would include the following capabilities:
· Allow employees to register for company-sponsored recreational programs, such as soccer, softball, bowling, jogging, and walking.
· Allow employees to register for company-sponsored classes and programs to help them manage their weight, reduce stress, stop smoking, and manage other health-related issues.
· Track data on employee involvement in these recreational and health-management programs.
· Offer incentives for people to join the programs and do well in them (e.g., incentives for achieving weight goals, winning sports team competitions, etc.).
Assume that MYH would not need to purchase any additional hardware or software for the project.
Project Scope Management: Assignment (3 Tasks)
Develop a first version of a scope statement for the project. Use the template provided. Be as specific as possible in describing product characteristics and requirements, as well as all of the project’s deliverables. Be sure to include testing and training as part of the project scope.
Develop a work breakdown structure (WBS) for the project. Use the template. Break down the work to Level 3 or Level 4, as appropriate. This WBS should be based on the project charter you created in week 3 and the project scope statement you created in the previous task.
Use the WBS you developed begin creating a Gantt chart using Microsoft Project. Do not enter any durations or dependencies. Copy the resulting Gantt chart onto a word document be sure to display the entire Task Name column.
Select any example visualization or infographic and imagine the contextual factors that have changed:
Q1) If the selected project was a static work, what ideas do you have for potentially making it usefully interactive? How might you approach the design if it had to work on both mobile/tablet and desktop?
Q2) If the selected project was an interactive work, what ideas do you have for potentially deploying the same project as a static work? What compromises might you have to make in terms of the interactive features that wouldn’t now be viable?
Q3) What about the various annotations that could be used? Thoroughly explain all of the annotations, color, composition, and other various components to the visualization.
Q4) What other data considerations should be considered and why?
Q5) Update the graphic using updated data, in the tool of your choice (that we’ve used in the course), explain the differences.
Be sure to show the graphic (before and after updates) and then answer the questions fully above. This assignment should take into consideration all the course concepts in the book. Be very thorough in your response.
The paper should be at least three pages in length and contain at least two-peer reviewed sources.
Notes: plagiarism check required, APA7 format, include References, within 8hrs
Name the three essential elements of a basic structured cabling network? How are they installed and what are the components that are involved with them?
Search the peer-reviewed literature to identify its potential impact on networking and what measures can be put in place to minimize the effect.
Initial Post : 400 words
4 Responses : each 200 words
1. Explain why it is useful to describe group work in terms of the time/place framework.
2. Describe the kinds of support that groupware can pro-vide to decision makers.
3. Explain why most groupware is deployed today over the Web.
4. Explain in what ways physical meetings can be inefficient. Explain how technology can make meetings more effective.
5. Compare Simon’s four-phase decision-making model to the steps in using GDSS.
The article on IRB this week discusses broad consent under the revised Common Rule. When you are doing any sort of research you are going to need to have your research plan approved by the University’s institutional review board or IRB. If you have never heard of this term before, please take a look online and find a brief summary of what it is about, before you read the article.
Please answer the following questions in your main post:
Please make your initial post and two response posts substantive. A substantive post will do at least TWO of the following:
At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.
