Monthly Archives: June 2023

You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly import data from another source.

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.

Apply conditional formatting to   the range C5:C34   that highlights any dependents that are greater than 3 with Light Red Fill and Dark Red Text.

Click cell H10, and enter an   AVERAGEIFS function to determine the average salary of full-time employees   with at least one dependent. Format the results in Accounting Number Format.

Use Advanced Filtering to   restrict the data to only display full-time employees with at least one   dependent. Place the results in cell A37. Use the criteria in the range   H24:M25 to complete the function.

Ensure that the Facilities   worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6   to the optimal value of $6000. Complete this task by changing the Loan amount in cell E6.

Create the following three   scenarios using Scenario Manager. The scenarios should change the cells B7, B8,   and E6.
 

Good   
  B7 = .0325
  B8 = 5
  E6 = 275000
 

Most   Likely
  B7 = .057
  B8 = 5
  E6 = 312227.32
 

Bad
  B7 = .0700
  B8 = 3
  E6 = 350000
 

  Create a Scenario Summary Report based on the value in cell B6. Format the   new report appropriately.

Ensure that the Facilities   worksheet is active. Enter a reference to the beginning loan balance in cell   B12 and enter a   reference to the payment amount in cell C12. 

Enter a function in cell D12,   based on the payment and loan details, that calculates the amount of interest   paid on the first payment. Be sure to use the appropriate absolute, relative,   or mixed cell references.

Enter a function in cell E12,   based on the payment and loan details, that calculates the amount of   principal paid on the first payment. Be sure to use the appropriate absolute,   relative, or mixed cell references.

Enter a formula in cell F12 to   calculate the remaining balance after the current payment. The remaining   balance is calculated by subtracting the principal payment from the balance   in column B.

Enter a function in cell G12, based on the payment   and loan details, that calculates the amount of cumulative interest paid on   the first payment. Be sure to use the appropriate absolute, relative, or   mixed cell references.

Enter a function in cell H12,   based on the payment and loan details, that calculates the amount of   cumulative principal paid on the first payment. Be sure to use the   appropriate absolute, relative, or mixed cell references.

Enter a reference to the   remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in   the prior steps down to complete the amortization table. 

Ensure the Sales worksheet is   active. Enter a function in cell B8 to create a custom transaction number.   The transaction number should be comprised of the item number listed in cell   C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use   Auto Fill to copy the function down, completing the data in column B.

Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than   or equal to $4000. Otherwise, the function will display a blank cell. Use Auto   Fill to copy the function down, completing the data in column G. 

Create a data validation list in   cell D5 that displays Quantity, Payment Type, and Amount (in that order).

Type the Trans# 30038C in cell B5, and select Quantity from the validation list in   cell D5.

Enter a nested lookup function   in cell F5 that evaluates the Trans # in cell B5 as well as the Category in   cell D5, and returns the results based on the data in the range A8:F32.

Create a PivotTable based on the   range A7:G32. Place the PivotTable in cell I17 on the current worksheet.   Place Payment Type in the Rows box and Amount in the Values box. Format the   Amount with Accounting Number Format.

Insert a PivotChart using the   Pie chart type based on the data. Place the upper-left corner of the chart   inside cell I22. Format the Legend of the chart to appear at the bottom of   the chart area. Format the Data Labels to appear on the Outside end of the   chart.

Insert a Slicer based on Date.   Place the upper-left corner of the Slicer inside cell L8.

Use PowerQuery to connect to the   Access database Exp19_Excel_AppCapstone_Comprehensive_Inventory.accdb.   Load the Inventory table into a new worksheet named Inventory.
 

  Note, Mac users, download and import the delimited Inventory.txt file into a new worksheet named Inventory starting in cell A1.

Create a footer with your name   on the left, the sheet code in the center, and the file name on the right for   each worksheet.

Save the file Exp19_Excel_AppCapstone_ComprehensiveAssessment-   Manufacturing.xlsx. Exit Excel. Submit the file as directed.

#Exp19_Excel_Ch09_ML1_Expenses 

#Exp19 Excel Ch09 ML1 Expenses 

#Excel Chapter 9 Mid-Level 1 – Expenses

Project Description:

You carefully tracked your income and expenses for three months using one worksheet per month. The worksheets contain the same expense categories. You used the Miscellaneous category to include a variety of expenses, including a vacation in June. For each month, you calculated the difference between your income and expenses as you were saving for your vacation in June. Now you want to create a three-month summary to analyze your spending habits.

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

You want to enter a title and   apply a cell style to three worksheets at the same time.
 

  Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range   A1:C1 and apply the Heading 1 cell style.

With the worksheets grouped, you   want to calculate the Ending Savings Balance.
 

  In cell C6, add the Beginning Savings Balance to the Monthly Savings Added.

With the worksheets grouped, you   want to unlock a range so that it can be edited.
 

  Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup   the worksheets.

Three worksheets should have 3-D   references to other worksheets.
 

  Display the May worksheet. In cell C4, create a formula with a 3-D reference   to cell C6 (the
  Ending Savings Balance) in the April worksheet.
 

  Display the June worksheet. In cell C4, create a formula with a 3-D reference   to cell C6 (the
  Ending Savings Balance) in the May worksheet.
 

  Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D   reference to cell C6 (the
  Ending Savings Balance) in the June worksheet.

You are ready to build functions   with 3-D references to sum data from all three months on the Qtr 2 worksheet.
 

  With the Qtr 2 worksheet active, click cell C9 and insert the SUM function   with a 3-D reference to total the salary amounts for all three months. Copy   the function in cell C9 to cells C21 and C23.

Next, you want to insert a SUM   function with a 3-D reference on the Qtr 2 worksheet.
 

  Click cell B12 and insert the SUM function with a 3-D reference to total the   rent amount
  for all three months. Copy the function in cell B12 to the range B13:B20.

To ensure consistency among worksheets,   you will group worksheets and apply formatting.
 

  Display the April worksheet, group all four worksheets, and select the range   A8:C23. Fill the formats only across the grouped worksheets to copy the font   formatting, indents, and number formatting. Ungroup the worksheets.

The Qtr 2 sheet contains cells   containing April, May, and June text. You will insert hyperlinks to the   respective worksheet data.
 

  Select cell E2 containing April, insert a hyperlink to cell C23 in the April   worksheet, and include
  the ScreenTip with the text April balance.
 

  Select cell E3 containing May, insert a hyperlink to cell C23 in the May   worksheet, and include the ScreenTip with the text May balance.
 

  Select cell E4 containing June, insert a hyperlink to cell C23 in the June   worksheet, and include the ScreenTip with the text June balance.
 

  Click each cell to test the hyperlinks and correct any errors.

Use the data in the four   worksheets to enter data in the range E7:E12 in the Analysis section to   provide either a text or a number that relates to the labels in the range   F7:F12.

You want to create a data   validation rule to restrict the type of data the user enters.
 

  Display the April worksheet and create a data validation rule in cell B20.   Allow decimal values that are less than or equal to $100. Create the input message title   Miscellaneous   Expense and   input message The maximum miscellaneous expense is $100. (including the period). Create   an error alert with the Stop style, error title Invalid Data, and error message You must   enter a value less than or equal to $100. (including the period). Test the rule by trying to   enter 500. The rule should prevent you   from entering that value. Click Cancel to revert to the original $100 value.

Create 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 all worksheets.

Protect all four worksheets   without a password to enforce the locked cells.

You want to indicate that you   finalized the workbook.
 

  Mark the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

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

I just need the flow chart, not the 350 summaries that it also asks for.

Check the attachment for the questions.

I don’t need any citations or references –  just the content.

But ensure no plagiarism at all. 

Each answer should be minimum 750 words

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.

I need this done by 4/15 at 5:30 pm. All the info is attached. Thanks! 

1. This paper will be a researched paper (15-20 double-spaced text pages) on adult learning theories and leadership principals on a leadership initiative within the student’s home institution or in an educational setting approved by the instructor. The paper should follow APA format. 
   • Title Page (Sample Title Page located at content tab)
   • Chapter I.  Introduction
     • This is where you present a purpose, roadmap and short summary on the importance of your select topic and a short summary of the results of your topic
   • Chapter II.  Literature Review
     • This where you will summarize the information and data from your references
   • Chapter III. Analysis
     • This is where you provide your own analysis of your topic anchored in fact and reason
   • Chapter IV. Summary
     • Summarize the meaning of your analysis
   • Reference Page 
   • Please upload your completed paper by due date on the calendar.

 Complete the following assignment in one MS word document:

Chapter 13- discussion question #1-4 & exercise 3 & 4 & 6

When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.
All work must be original (not copied from any source).

Discussion Questions:

1. Compare the IoT with the regular Internet. 

2. Discuss the potential impact of autonomous vehicles on our lives. 

3. Why must a truly smart home have a bot? 

4. Why is the IoT considered a disruptive technology? 

Exercise:

3. AT&T is active in smart city projects. Investigate their activities (solutions). Write a summary 

4.  It is said that the IoT will enable new customer service and B2B interactions. Explain how. 

6.   Find information about Sophia, a robot from Hanson  Robotics. Summarize her capabilities. 

U.S. state you are currently residing in is Pennsylvania, research its breach notification law. Note that some states do not label it as such, but all 50 states have some form of legislation that mandates an organization’s responsibilities when a data breach affects the state’s citizen’s private, protected information.

Some research resources to consider include your textbook, of course; the UC Library, particularly via the Nexis Uni database; the state’s governmental websites; the state bar association’s (legal profession) website; Cornell University’s legal website; etc. Describe your state’s law including at least these considerations: 

What types of organizations or individuals does it apply to? 

Is it limited to only those organizations or individuals who reside or exist in that state, or might it affect external interests? 

How does the law define or describe the information that it protects, by both name and description? 

What exemptions, if any, exist? 

What are the penalties for violating the law? 

In your opinion, is it effective? Good law? Needing updating? What other critiques or opinions do you have about it? 

500 words APA format needed with references

Details to the assignment uploaded.

Thank you!