All posts by : chebby

 Risk management is one of the most important components in empowering an organization to achieve its ultimate vision. With proper risk management culture and knowledge, team members will be “speaking” the same language, and they will leverage common analytical abilities to identify and mitigate potential risks as well as exploit opportunities in a timely fashion. In order to consolidate efforts, the existence of an integrated framework is crucial. This is why an ERM is necessary to the fulfillment of any organization’s goals and objectives.In your final research project for the course, your task is to write a 7-10 page paper discussing the following concepts:

• Introduction
• Why should an organization Implement an ERM application?
• What are some key challenges and solutions to Implementing an ERM?
• What is Important for an effective ERM?
• Discuss at least one real organization that has been effective with implementing an ERM framework or /application.
• Conclusion, final thoughts for future research
• Recommendation

Your paper should meet the following requirements:

• Be approximately seven to ten pages in length, not including the required cover page and reference page.
• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course, the course textbook, and at least ten scholarly journal articles to support your positions, claims, and observations, in addition to your textbook.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Background Information:

In this activity, we explore what the Bible has to say about safety. Psalm 122:7 states, “Peace be within your walls and security within your towers” (ESV). The writing of Psalms is generally attributed to King David in ancient Israel. The verse is referring to a city, Jerusalem. This is very clearly indicating a physical threat, possibly a surrounding unfriendly nation or group of people. However, threats may come from a variety of attackers and in many forms. Psalm 9:10 says, “Those who know your name trust in you, for you, Lord, have never forsaken those who seek you” (NIV).

1. Review the material in the Background Information, including the specific Bible passages.
2. Be sure to address the following prompts in your paper:
   1. In the context of our world today, and particularly technology, where are today’s threats likely to come from?
   2. Security is “within your towers,” so how can we work to assure that “peace,” or security?
3. Considering your cultural/religious background, what is your personal view regarding God protecting us humans? Explain your opinion and provide examples if possible.
4. Your paper should be at least 250 words in length.

watch these 2 videos and make a summary of them ” 2 pages ” 

it’s due 6:00 PM JORDAN TIME ZONE

What are the risks associated with using public Wi-Fi?

NOTE: Remember, the important thing here is QUALITY, not QUANTITY and your posts/comments MUST BE IN YOUR OWN WORDS (not copied and pasted from the Internet). We will use the SafeAssign tool to check for plagiarism.

 Write a 1- to 2-page reference table that lists at least 4 resources available on the AWS website, such as FAQs, videos, whitepapers, tutorials, case studies, etc. The audience for your table will be business users engaged once the services are fully implemented. Your table should include the resource type, a description, who would benefit from the resource, and a link to the resource(s). The table will be a resource for your organization, so keep in mind the format and ease of use.  

I want you to create something based on what you’ve learned so far in this course

Visit https://corallanguage.org/simulator/ and write a program using:

variables

branches

loops

arrays

functions

Come up with your own program that contains your own user-defined functions and variables. Be creative. No need to be too complicated but be a useful program with a function and array.

Need help for below. 

2 discussions

1 Assignment

Logic, Philosophy, Computers! Let’s read the following article and reflect on it!

Article: Dixon, C. (2017, July 10). How Aristotle created the computer. The Atlantic. https://www.theatlantic.com/technology/archive/2017/03/aristotle-computer/518697/.

After reading the article you have to leave a substantive comment and share your thoughts about its content. What does “substantive” mean?  It means you are thinking more deeply than “I like this…”.

After reading the article, write 2 (two) paragraphs:

• in the first paragraph, provide your reflections about the article (at least 300 words).
• in the second paragraph, let me know what you think about this: “what began with an investigation “concerning the nature and constitution of the human mind,” could result in the creation of new minds—artificial minds—that might someday match or even exceed our own.”.

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.