Exp19_Excel_Ch02_ML1_Payroll | Excel Chapter 2 ML1 Payroll

 

Exp19_Excel_Ch02_ML1_Payroll | Excel Chapter 2 ML1 Payroll

 

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

2  Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40. 

3.  Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (B24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40. 

4. Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E25. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay. 

5. Calculate FICA in cell J5 based on gross pay and the FICA rate (cell B23), and calculate the net pay in cell K5. Copy all formulas down their respective columns to row 16. 

6. With the range E5:K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row 17.

Note, Mac users, with the range selected, on the Home tab, in the Editing group, click AutoSum. 

7. Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row. Apply the Comma style to the monetary values for the other employees. Apply the Total cell styles format to the range E17:K17. 

8. Insert appropriate functions to calculate the average, highest, and lowest values in the Summary Statistics area (the range I21:K23) of the worksheet. Format the # of hours calculations as Number format with one decimal and the remaining calculations with Accounting number format. 

9. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet. 

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

Project 2: Troubleshooting and Tool Report

 

The SITREP (Situation Report) Sample Report is provided so that you can understand what Cyber Command is expecting in your report. Your report will vary depending on the problem and tool selected.

Select one of the seven network problems and develop a troubleshooting and tool report that details the solution.

  1. On Day 2 of full operational capability (FOC), our connection to the internet was becoming intermittent. We could establish connections to our globally hosted servers some of the time. The connection would drop at seemingly random periods and we don’t know why. We have experienced this day and night, and it has been consistent for the past three days.
  2. When our connection to the internet is working, we seemingly cannot reach out to our globally dispersed servers from our hosts. We use the globally dispersed servers for command and control and must be able to connect to them. We need a method to determine where the packets are going and why they are not reaching their destination. Because these servers are globally distributed, we can’t just pick up and deploy to them.
  3. Our internal network servers are also spotty. Sometimes they are up, and sometimes they are down. For example, the DHCP server appears to provide IP addresses to hosts that are turned on sometimes, but other times when the host is turned on, it receives an Automatic Private IP Address (APIPA). These hosts can communicate with our networked hosts locally, but they can’t reach out to our global servers. These hosts enable our persistent engagement capability, so they must be functional, and we need to determine the problem ASAP!
  4. We have a team that can troubleshoot from afar, but the members are located 25 miles west of this location. We have one of the tech support personnel deployed on site, but there are just too many issues for one person. The support team that is 25 miles west is centrally located to support multiple operational outfits. That team has a virtual private network (VPN) and secure access to our internal servers. At times, support team members need to determine which of our hosts are functioning. We use both Microsoft Windows and Linux operating systems, but we don’t know what tool will help determine host functionality from afar.
  5. This next part is classified, but I need your help, and I need it fast. Bottom line, we believe there may be an insider threat. At times, we have reason to believe a nonapproved device is connecting to the network and reaching out to the internet. We need a method to determine what devices exist on the same subnet of our network. What can help us do that?
  6. When we begin operations in 72 hours, it will be of utmost importance for us to know what device name is associated with what IP address. This will allow us to know what exists internally and what we need to defend should the adversary begin operations against us. We need to understand what options exist to achieve this task.
  7. When we first arrived and established our connection to the internet, we noticed inbound connection requests. What tool can we use to determine if any adversary is reaching into our systems through a particular port or protocol?

Your report should be about a page in length and address the following:

  • Choose and restate one of the problems identified as you understand it and explain why it is a problem.
  • Describe how you would apply the steps in the Network+ troubleshooting model to this problem.
  • Name and provide a brief overview of the tool that could solve this problem (refer to Lesson 17 in uCertify).
  • Describe how the tool can be used to solve similar problems in the future.
  • Provide a detailed overview of the tool’s functionality and options.
  • Include a screenshot of your selected tool from the appropriate uCertify lab.

How Will My Work Be Evaluated?

Troubleshooting refers to the process of identifying problems with a network through a rigorous and repeatable process and then solving those problems using testable methods. An important part of your duties in the networking field will be to troubleshoot and solve problems. In fact, most of your time will be spent with this focus to include optimizing performance. Networks are dynamic in implementation and are built to be resilient, but problems arise due to many unforeseen reasons. Developing the knowledge, skills, and experience to successfully troubleshoot and recommend solutions will show you are value-added to the organization.

For this assignment, you are asked to review a scenario, understand the problems, apply your knowledge and skills gained in this class, and propose a solution. Use the template provided and complete the assignment. An example solution is provided for you.

The following evaluation criteria aligned to the competencies will be used to grade your assignment:

  • 1.2.3: Explain specialized terms or concepts to facilitate audience comprehension.
  • 1.3.5: Adhere to required attribution and citation standards.
  • 1.4.1: Produce grammatically correct material in standard academic English that supports the communication.
  • 2.1.1: Identify the issue or problem under consideration.
  • 2.3.1: State conclusions or solutions clearly and precisely.
  • 10.1.1: Identify the problem to be solved.
  • 13.1.1: Create documentation appropriate to the stakeholder.

When you are finished, delete the instructional text from the template before you submit. Click “add a file” to upload your work, then click the Submit button.

IDPS

 

Mahtnarg Manufacturing is purchasing an Intrusion Detection and Prevention System (IDPS) due to recent attacks on similar companies. As the Chief Information Security Officer (CISO) you have been tasked to review the potential IDPS types and provide a research paper to company leadership detailing your choice of IDPS in comparison to the available IDPS types.

Prepare a 350- to 1,050-word paper that fully discusses the topic questions

Format your paper consistent with APA guidelines. Format your paper consistent with APA guidelines.

Discussion: ITS-833: Information Governance – Web2.0

Discussion: Web 2.0

Word count: 300+ words

Our reading by Arinze and Ezema discusses Web 2.0. Discuss how you think Web 2.0 has changed the behavior of Internet users. Do you feel the behavior change is for the good or are there disadvantages? Please discuss your thoughts on Web 2.0 including concepts of privacy and social media in a substantive, well-researched discussion thread.

  • Provide an outside source that applies to the topic, along with additional information about the topic (please cite properly in APA).
  • At least one scholarly source should be used in the discussion. Be sure to use information from your readings. 
  • Use proper citations and references in your post

Textbook: 

For this assignment, please read chapters 11 and 12 from the below textbook.

Chapter 11 – Information Governance and Privacy and Security Functions
Chapter 12 – Information Governance for E-Mail and Instant MessagingManagement 

Title: Information Governance, ISBN: 9781118421017 Authors: Robert F. Smallwood Publisher: John Wiley & Sons Publication Date: 2014-03-28

Borgman, C. L. (2018). Open Data, Grey Data, and Stewardship: Universities at the Privacy Frontier. Berkeley Technology Law Journal, 33(2), 365–412
Qin, H., Li, Z., & Yang, J. (2020). The Impact of Online Media Big Data on Firm Performance: Based on Grey Relation Entropy Method. Mathematical Problems in Engineering, 1–7

Clara, A. M. C., Canedo, E. D., & De Sousa, R. T. (2017). Actions to verify compliance of a public company with IT Governance. 2017 12th Iberian Conference on Information Systems and Technologies (CISTI), Information Systems and Technologies (CISTI), 2017 12th Iberian Conference On, 1-6. https://ieeexplore.ieee.org/document/7975834 Click PDF, In Institution name box, enter: University of the Cumberlands, UC OneLogin will pop up and login with UC email address and Password.

Savić, D. (2019). When is ‘grey’ too ‘grey’? A case of grey data. Grey Journal (TGJ), 15(2), 71
Full text not available through UC Library. Link to video of conference presentation: https://www.intellobics.com/2018/12/29/when-is-grey-too-grey-a-case-of-grey-data/

TOWER, 2004. E-Mail Management: Avoiding the 6 Common Mistakes. Best Practices in Records Management and Regulatory Compliance. Pages 6 – 8.

Note: plagiarism check required, APA7 format, include References, within 8hrs

Netbeans

  

Netbeans 

Design, implement, test, and debug a GUI-based version of a “Hello, World!” program.
Create a JFrame that includes a JLabel that reads “Hello, World!” Use a layout manager of your choice.
Include an Exit button to close the program.
Submit the .java source file.

 

Steps to run:

Open Netbeans and create a new project and then create a new java file in default package(src)
The name of the java file should be SayHello.java (Mind the case of letters)

Delete the contents if any and paste the below code. Save it. Right click on SayHello.java and click on run