Discussion (250-300 words):

 This week we focus on globalization concepts.  Please explain the concept of globalization and the role information technology has in the global market. 

Assignment (2 Pages):

 Information Systems for Business and Beyond Questions

• Chapter 11 – study questions 1-10, Exercise 1
• Chapter 12 – study questions 1-11, Exercise 1

Information Technology and Organizational Learning Assignment:

• Chapter 9 – Review the section on Establishing a Security Culture.  Review the methods to reduce the chances of a cyber threat noted in the textbook.  Research other peer-reviewed source and note additional methods to reduce cyber-attacks within an organization.
• Chapter 10 – Review the section on the IT leader in the digital transformation era.  Note how IT professionals and especially leaders must transform their thinking to adapt to the constantly changing organizational climate.  What are some methods or resources leaders can utilize to enhance their change attitude?

Practical connection assignment (3 pages):

 This week select an organization that has a Global platform (they operate in more than one country), that has demonstrated operational excellence.  In this paper, perform the following activities:

• Name the organization and briefly describe what good or service they sell and where they operate. Consider using an organization that is in an industry where you work or want to work. (Exclude the use of Apple, Amazon, Facebook/Meta, Microsoft and Google).
• Note how they are a differentiator in the market.
• Note the resources used to ensure success in their industry (remember resources are comprised of more than just people).
• Explain what actions the company took to achieve operational excellence.

Exp19_Excel_Ch07_ML2_Finances

Exp19 Excel Ch07 ML2 Finances

Excel Chapter 7 Mid-Level 2 – Finances

  

Project Description:

Your family is considering purchasing a house and investing in a business venture. You started the structure for a loan amortization table and the investment table. You will complete the first five years of the 20-year loan amortization table. To complete the table, you will enter formulas to calculate the beginning balance, monthly payment, and ending balance. You will use financial functions to calculate the interest and principal paid for each monthly payment. In addition, you want to calculate cumulative interest after the first year, total interest over the life of the loan, and the amount of principal paid after the first year. You also want to see how many months half or more of the payment is for interest. You will then focus your attention on completing an investment table using date functions, formulas, and a financial function to calculate the future value of the investment.

     

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

 

The first step is to enter a   formula to reference the loan amount for the beginning balance for the first   payment.
 

  In cell B9, enter a formula that references cell D2.

 

A loan amortization table   usually contains a column that displays the monthly payment for each row.
 

  In cell C9, enter a formula to reference the monthly payment in cell D3. Use   a mixed reference and copy the formula to the range C10:C68.

 

The monthly payment indicates   the total amount of the payment, which includes principal and interest.   Interest is calculated based on the loan amount, the rate, the payment   number, and the number of payments.
 

  In cell D9, enter the IPMT function to calculate the interest paid for the   first month using mixed cell references to the input area for the Rate, Nper,   and PV arguments and using cell A9 for the Per argument. Make sure the result   is a positive value and copy the function to the range D10:D68.

 

After calculating the interest   paid, the rest of the monthly payment repays the principal.
 

  In cell E9, enter the PPMT function to calculate the principal paid for the   first month using mixed cell references to the Calculations area for the   Rate, Nper, and PV argument and using cell A9 for the Per argument. Make sure   the result is a positive value and copy the function to the range E10:E68.

 

The last column of the loan   amortization table calculates the ending balance.
 

  In cell F9, calculate the ending balance by subtracting the Principal   Repayment from the Beginning Balance in row 9. Copy the formula to the range   F10:F68.

 

The beginning balance for each   payment is calculated and entered in column B.
 

  In cell B10, enter a formula that references the first month’s ending balance   in cell F9. Copy the formula to the range B11:B68.

 

Ensure that Accounting Number   Format is applied to the range B9:F68.

 

You want to calculate the total   interest paid for the first year.
 

  In cell F2, insert the CUMIPMT function to calculate the cumulative interest   paid for the first year. Use A9 for the Start_period argument and B6 for the   End_period argument. Use 0 as the Type argument. Make sure the result is a positive value.

 

Now you want to calculate the   total interest paid for the entire loan.
 

  In cell F3, insert the CUMIPMT function to calculate the total cumulative   interest paid for the entire loan. Use A9 for the Start_period and D6 for the   End_period arguments. Make sure the result is a positive value.

 

You want to calculate the   cumulative principal paid for the first year.
 

  In cell F4, insert the CUMPRINC function to calculate the cumulative   principal paid for the first year. Use A9 for the Start_period and B6 for the   End_period arguments. Make sure the result is a positive value.

 

In cell F5, insert the COUNTIF   function to count the number of payment periods in which the interest in the   loan amortization table is higher than one-half of the monthly payment (cell   D4).

 

Apply General number format to   cell F5.

 

You want to extract the year and   use it to determine the payoff year.
 

  Display the Investment sheet. In cell D4, insert the YEAR function to extract   the year from cell D3 and add the number of years (cell B3). You will change   the format of the result in the next step.

 

You need to format the result in   cell D4 as a number.
 

  Ensure that General number format is applied to cell D4.

 

At the end of each period, you   will add $125 to the investment.
 

  In cell D7, enter a formula that references cell D2. Use a mixed reference to   ensure the row number does not change. Copy the formula to the range D8:D54. 

 

You want to calculate the   interest earned per period.
 

  In cell C7, multiply the beginning balance in cell B7 to the result of   dividing the APR by the No. of Pmts per Year. Use mixed and relative cell   references. Copy the formula to the range C8:C54.

 

You are ready to calculate the   ending balance for each payment period.
 

  In cell E7, add the Beginning Balance, Interest Earned, and End-of-Period   Investment for row 7. Copy the formula to the range E8:E54.

 

You will use a nested function   to calculate the dates in column A.
 

  In cell A8, create a DATE function with a nested YEAR function, a nested   MONTH function and then add 1 to increment the month, and a nested DAY   function. The function arguments should reference the date on the previous   row.

 

Copy the function from cell A8   to the range A9:A54 but preserve the fill formatting.

 

In cell E56, insert the FV   function to calculate the future value of the investment use references to   the respective cells in the input area for the arguments. Make sure the   result is positive. Leave the Type argument empty.

 

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 both sheets.

 

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

 

1) Explain the Phong lighting model in OpenGL.

    Your assignment submission must be between 550 to 700 words.

2) Submit a wire-frame model of your final project. Including the indices of the object.

 

Dear Participants,

“Today many big organizations are sitting on large chunks of data, not knowing what to do with it. They invite consultants & business analysts to have a look at data and come up with insights that could help the organization run their business better. There is no clear set of instructions in such open-ended problems and it is expected of the consultant to do a lot of exploration first and formulate the problems themselves. These DVT projects fall into the bucket of such open-ended problems and a specific problem statement has not been given intentionally. It is expected of students to explore the data and come up with good insights. There is no right and wrong answer here. There should a clear logical story which should come out of their submission.”

Please find below DVT Project instructions:

Note: Please upload the project on Tableau public and include the URL in a word doc and upload it.

• Any assignment found copied/ plagiarized with another person will not be graded and marked as zero.
• Please ensure timely submission as a post-deadline assignment will not be accepted.

Please find the instructions here.

To learn how to publish your tableau file, click here.

Please use the following  datasets- (Car Claim Insurance.xlsx)

Business Context 

We are all aware that accidents are prone everywhere due to negligent driving or climatic conditions. An insurance company always needs to be prepared to estimate the number of accidents and the claims that they can receive at a given point time. Also understanding the pattern of claims would help the companies to frame different types of policies for the users providing better benefits and at the same time increasing the premium to the company.

Problem Statement:

Consider that you are a Lead Data Analyst at an Insurance Claims company that has provided you with the Car Insurance Claims dataset. You have been given a task to explore the data, create different plots and interpret useful insights/findings. Your end goal here will be to create a storyboard that you have to present to the Senior Management and the story has to have an end objective and should follow a logical flow to display that you are heading towards achieving the end objective. This will help the Senior Management in taking some decisive actions on the current claims system in place. This storyboard will be an open-ended story for you to explore various different features in the data and try to showcase different plots. Make sure to have minimum clutter in the plots, follow a consistent color scheme across all the plots, and use proper colors to highlight a specific insight. Moreover, your plots on all the dashboards should be interactive and responsive. There should be 1 dashboard that should cover the summary of the story as well as your recommendations.

Important Note: Please reflect on all that you have learned while working on this project. This step is critical in cementing all your concepts and closing the loop. Please write down your thoughts here.

Regards,

Program Office

 CriteriaPoints

Creation of multiple charts and tables for representing useful insights/findings. The charts used should be inline with the objective that you wish to convey to the Senior Management.

[Mandatory 8 types of charts/tables from any of the following: text table, bar chart(multiple/stacked/side by side), bubble chart, treemap, Pareto chart, scatterplot, Wordcloud, line plot, histogram, boxplot, circle views, heatmap, highlighted tables. No restrictions on the upper limit of the number of charts/tables to be used]  16 points

Creating a calculated field. The calculated field should add some meaningful value and should be inline with your storyboard which you will create in this project. (Specify where calculated field has been used)

2 points

Use of filters, parameter, actions, etc in the charts.

4 points

Minimal clutter and consistency in use of colors across charts.

5 points

Multiple Dashboards creation

At least 5 Dashboards 10 points

Correct interpretations/insights from each type of chart created. The interpretations should be inline with the storyboard which is to be created in this project.

These interpretations can be in the captions of the storyboard or in the plots as well 16 points

Interactivity among the charts on each Dashboard 5 points

Storyboard Creation

At least 1 Storyboard 15 points

Logical flow to the story represented in the storyboard. 5 Points

1 dashboard which will cover the summary and the recommendations from the insights to be added to the end of the storyboard

This dashboard will be an extra dashboard apart from the mandatory 5 dashboards mentioned in the 5th part of the rubric. At least 5 summary/recommendation points should be mentioned in this dashboard(at least 1 recommendation/summary point from each dashboard you created). 1 conclusion point of the story. This dashboard has to be a part of the storyboard created and not to be submitted separately. Note: This will not be evaluated if submitted as a separate dashboard/storyboard. 

Practical connection:

It is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where students will demonstrate how this course research has connected and put into practice within their own career.  

Information Governance (1 page)

Emerging threats and countermeas (1 page)

Task 1: Research PAPER

 Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years. Pick an industry you feel will be most affected by blockchain and how blockchain may be used in that industry. As an IT manager, how would you embrace blockchain? For instance, how would training occur for your team, what strategies might you use, what security methods may you recommend be used?Your paper should meet the following requirements:

• Be approximately four to six 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 and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• 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.
• At least 5 references.

Task 2: Discussion

300 Words and at least 3 references.

 The vast majority of the population associates Blockchain with cryptocurrency Bitcoin; however, there are many other uses of blockchain; such as Litecoin, Ether, and other currencies. In this discussion, please describe at least two cryptocurrencies with applicable examples. Discuss some similarities and differences. Lastly, discuss if you have any experience using any cryptocurrencies. 

  

Exp19_Word_Ch02_CapAssessment_Personal_Finance

Exp19 Word Ch02 CapAssessment Personal Finance

  

Project Description:

This semester you are enrolled in a personal finance course at your local university. One of the assignments is to write a research paper about investing. You conducted research on the various types of investing instruments, and wrote a final draft of the report. In the following project, you will format the document to enhance readability and appearance. You will create, modify, and apply styles; apply bullets and numbering; and insert two pictures into the document.

     

Start Word. Download and open   the file named Exp19_Word_Ch02_CapAssessment_PersonalFinance.docx.   Grader has automatically added your last name to the beginning of the   filename. Ensure that nonprinting characters are displayed.

 

Change the document theme to Office, and both theme colors and theme fonts to Office. If the theme   is not available, click Browse for Themes, and then select the downloaded   theme file Office.thmx.

 

Ensure that the insertion point is on the first paragraph of the   document. Create a paragraph style and   name it Title_Page_1 with the following formats: 22 pt font size, and a font color of   Blue-Gray, Text 2, Darker 50% (fourth column, last row). Apply the new style   to the first paragraph of the document, Personal   Finance, if necessary.

 

Click in the paragraph below Updated   by: and type Laura Sims. Change the case of Laura Sims to UPPERCASE.

 

Select document text from the paragraph beginning with Personal Finance   through the end of the document. Justify the selected text and change line spacing to 1.15. 

 

Place the insertion point on the   left side of the title Personal Finance   (below Laura Sims) and insert a   page break (not a section break). 

 

Apply Heading 1 style to Personal   Finance at the top of page 2. 

 

Apply Heading 2   style to paragraph headings, including Introduction, Equity Stocks, Bonds, Mutual Funds, U.S. Treasury Bills, Fixed   Deposits, Sources, and Conclusion. 

 

Modify Heading 2   style to use Dark Red font   color (the first color under Standard Colors). 

 

Select the six paragraphs in the Introduction section on page 2,   beginning with Equity stocks and   ending with Fixed deposits. Apply a   diamond bullet to   the selected text.

 

Select the second paragraph in   the Introduction section, beginning   with The best time to prepare for your   retirement, and apply these formats:
  • 0.6” left and right indent
  • 6 pt spacing after the paragraph
  • Boxed 1 1/2 pt border using the color Blue-Gray, Text 2, Darker 25% (fourth   column, fifth row)
  • Shading of Blue-Gray, Text 2, Lighter 80% (fourth column, second row)

 

Apply the default numbered-list format (1., 2., 3.) to the three types of bonds in the Bonds   section. 

     

Select the three quotes by Warren Buffet and the Source: paragraph in the Equity Stocks section.   Display the selected text in two columns with a line between the columns. 

 

Insert the picture file WallStreet.jpg at the beginning of   the line that contains The major stock market   in the Equity Stocks section. Change the height of   the picture to 3”, and apply Top and Bottom text wrapping. Apply the Rounded   Diagonal Corner, White picture style. Position the picture so that it appears   below the Equity Stocks heading.   Align the picture so that it is centered horizontally relative to the margin.

 

Insert the picture file GreatIdeas.jpg at the beginning of   the paragraph that contains If you want   something a little less risky than stocks in the Bonds section. Change   the height of the picture to 3”, and apply Top and Bottom text wrapping.   Apply the Center Shadow Rectangle picture effect. Position the picture so   that it appears above the Bonds heading.

 

Spell check and review the   entire document—no author names are misspelled.

 

Display the document in Outline   view. Collapse all paragraphs so only lines formatted as Heading 1 or Heading   2 display. Move the Sources section   to below the Conclusion section.   Close Outline view.

 

Save and close Exp19_Word_Ch02_CapAssessment_PersonalFinance.docx.   Exit Word. Submit the file as directed.

Initial post should be based upon the assigned reading for the week, so the textbook must be the only source utilized and listed in your reference section (and properly cited within the body of the text). Other sources are not required and are a waste of time to search and utilize. Only use the textbook.

Do not provide a Reflection or Chapter Overview. Provide only a graduate-level response to each of the following questions:

1) Thoroughly define and discuss the four different roles that are assigned in a RACI Chart. Why does at least one person/need to be Responsible for an Activity? Why is it necessary to have only one person assigned Accountability for an activity? What would be the issue if a person was assigned two roles (i.e., Responsible and Accountable or Accountable and Consult)?

Your post must be substantive and demonstrate insight gained from the course material. 

Text-

Chapter 9

Title: Contemporary Project Management 

ISBN: 9781337406451 

Authors: Timothy Kloppenborg, Vittal S. Anantatmula, Kathryn Wells 

Publisher: Cengage Learning 

Publication Date: 2018-02-08 

Edition: 4th

  

You have been assigned to investigate whether or not an employee at a local hospital has been accessing patient records and selling information to online pharmacies. It is your first day of the investigation. Put together a list of data sources that must be examined during the investigation.

In 300 words

The purpose of this assignment is to develop skills in problem-solving, decision making in complex situations, and learn/use the APA 6.0 style guidelines.