InfoTech in a Global Economy 3.1

 Find a peer-reviewed scholarly journal article discussing electronic innovation and the government. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing.  

 

Once you find the article, you will read it and write a review of it.  This is considered a research article review.

Your paper should meet these requirements: 

  • Be approximately three to four pages in length, not including the required cover page and reference page.
  • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

 

  • 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.

Practical Connections assignment

At UC, 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.

Assignment:
Provide a reflection of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:
Provide a 500 word (or 2 pages double spaced) minimum reflection.
If supporting evidence from outside resources is used, they must be properly referenced and cited.
Share a personal connection that identifies specific knowledge and theories from this course.
Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should NOT provide an overview of the assignments assigned in the course. The assignment asks that you reflect on how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

My Courses Business Intelligences

Organ Leader Decision Making  

Organizational Behavior and Decision Making Executive Practical Connection Assignment

 

At UC, 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.

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of Organizational Behavior and Decision Making course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

Share a personal connection that identifies specific knowledge and theories from this course.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should not, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace. 

 Don’t forget that the grade also includes the quality of writing.

Week 5

 

Imagine you have just been promoted as the new CIO of your organization. The CEO has asked you to set standards for systems integrity, ethics, and vendor relations for the IT organization.

Complete the Standards Matrix (File Attached) to set standards for systems and people. Include three standards for each of the following:

  • System integrity
  • Ethical IT operations
  • Vendor relations

Include the following for each standard:

  • How the standard must be applied
  • How to ensure the standard is met (how it is measured)
  • What to do when the standard is not met
  • How to mitigate against future failures when a standard is not met
Name Manager dialog box

excel document edit

 

  1. Open the SierraPacific-02.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  2. Set range names for the workbook.
    1. Select the Student Loan sheet, and select cells B5:C8.
    2. Click the Create from Selection button [Formulas tab, Defined Names group].
    3. Verify that the Left column box in the Create Names from Selection dialog box is selected.
    4. Deselect the Top row box if it is checked and click OK.
    5. Select cells E5:F7. Repeat steps a−d to create range names.
    6. Click the Name Manager button [Formulas tab, Defined Names group] to view the names in the Name Manager dialog box (Figure 2-90). Notice that the cell references are absolute.Name Manager dialog boxFigure 2-90 Name Manager dialog box
    7. Click Close.
  3. Enter a PMT function.
    1. Select C8.
    2. Click the Financial button [Formulas tab, Function Library group] and select PMT.
    3. Click the Rate box and click cell C7. The range name Rate is substituted and is an absolute reference.
    4. Type /12 immediately after Rate to divide by 12 for monthly payments.
    5. Click the Nper box and click cell C6. The substituted range name is Loan_Term.
    6. Type *12 after Loan_Term to multiply by 12.
    7. Click the Pv box and type a minus sign () to set the argument as a negative amount.
    8. Click cell C5 (Loan_Amount) for the pv argument. A negative loan amount reflects the lender’s perspective, since the money is paid out now (Figure 2-91).The formula is =PMT(Rate/12,Loan_Term*12,-Loan_Amount)Figure 2-91 Pv argument is negative in the PMT function
    9. Leave the Fv and Type boxes empty.
    10. Click OK. The payment for a loan at this rate is $186.43, shown as a positive value.
    11. Verify or format cell C8 as Accounting Number Format to match cell C5.
  4. Create a total interest formula.
    1. Click cell F5 (Total_Interest). This value is calculated by multiplying the monthly payment by the total number of payments to determine total outlay. From this amount, you subtract the loan amount.
    2. Type = and click cell C8 (the Payment).
    3. Type * to multiply and click cell C6 (Loan_Term).
    4. Type *12 to multiply by 12 for monthly payments. Values typed in a formula are constants and are absolute references.
    5. Type immediately after *12 to subtract.
    6. Click cell C5 (the Loan_Amount). The formula is Payment * Loan_Term * 12 – Loan_Amount. Parentheses are not required, because the multiplications are done from left to right, followed by the subtraction (Figure 2-92).Parentheses are not necessary in the formulaFigure 2-92 Left-to-right operations
    7. Press Enter. The result is $1,185.81.
  5. Create the total principal formula and the total loan cost.
    1. Select cell F6 (Total_Principal). This value is calculated by multiplying the monthly payment by the total number of payments. From this amount, subtract the total interest.
    2. Type = and click cell C8 (the Payment).
    3. Type * to multiply and click cell C6 (Loan_Term).
    4. Type *12 to multiply by 12 for monthly payments.
    5. Type immediately after *12 to subtract.
    6. Click cell F5 (the Total_Interest). The formula is Payment * Loan_Term * 12 – Total_Interest.
    7. Press Enter. Total principal is the amount of the loan.
    8. Click cell F7, the Total_Cost of the loan. This is the total principal plus the total interest.
    9. Type =, click cell F5, type +, click cell F6, and then press Enter.
  6. Set order of mathematical operations to build an amortization schedule.
    1. Click cell B13. The beginning balance is the loan amount.
    2. Type =, click cell C5, and press Enter.
    3. Format the value as Accounting Number Format.
    4. Select cell C13. The interest for each payment is calculated by multiplying the balance in column B by the rate divided by 12.
    5. Type = and click cell B13.
    6. Type *( and click cell C7.
    7. Type /12). Parentheses are necessary so that the division is done first (Figure 2-93).The formula is =B13*(Rate/12)Figure 2-93 The interest formula
    8. Press Enter and format the results (37.5) as Accounting Number Format.
    9. Select cell D13. The portion of the payment that is applied to the principal is calculated by subtracting the interest portion from the payment.
    10. Type =, click cell C8 (the Payment).
    11. Type , click cell C13, and press Enter. From the first month’s payment, $148.93 is applied to the principal and $37.50 is interest.
    12. Click cell E13. The total payment is the interest portion plus the principal portion.
    13. Type =, click cell C13, type +, click cell D13, and then press Enter. The value matches the amount in cell C8.
    14. Select cell F13. The ending balance is the beginning balance minus the principal payment. The interest is part of the cost of the loan.
    15. Type =, click cell B13, type , click cell D13, and then press Enter. The ending balance is $9,851.07.
    16. The image includes rows 13 through 28 and then rows 60 through72 after you complete Step 7g.Formulas in cells B13_F13B13=Loan_AmountC13=B13*(Rate/12)D13=Payment-C13E13=C13+D13F13=B13-D13
  7. Fill data and copy formulas.
    1. Select cells A13:A14. This is a series with an increment of 1.
    2. Drag the Fill pointer to reach cell A72. This sets 60 payments for a five-year loan term.
    3. Select cell B14. The beginning balance for the second payment is the ending balance for the first payment.
    4. Type =, click cell F13, and press Enter.
    5. Double-click the Fill pointer for cell B14 to fill the formula down to row 72. The results are zero (displayed as a hyphen in Accounting Number Format) until the rest of the schedule is complete.
    6. Select cells C13:F13.
    7. Double-click the Fill pointer at cell F13. All of the formulas are filled (copied) to row 72 (Figure 2-94).Formulas copied to row 72 with a zero ending balanceFigure 2-94 Formulas copied down columns
    8. Scroll to see the values in row 72. The loan balance reaches 0.
    9. Press Ctrl+Home.
  8. Build a multiplication formula.
    1. Click the Fees & Credit sheet tab and select cell F7. Credit hours times number of sections times the fee calculates the total fees from a course.
    2. Type =, click cell C7, type *, click cell D7, type *, click cell E7, and then press Enter. No parentheses are necessary because multiplication is done in left to right order (Figure 2-95).The formula is =C7*D7*E7Figure 2-95 Formula to calculate total fees per course
    3. Double-click the Fill pointer for cell F7 to copy the formula.
    4. Verify that cells F7:F18 are Currency format. Set a single bottom border for cell F18.
  9. Use SUMIF to calculate fees by department.
    1. Select cell C26.
    2. Click the Math & Trig button [Formulas tab, Function Library group] and select SUMIF.
    3. Click the Range box and select cells B7:B18. This range will be matched against the criteria.
    4. Press F4 (FN+F4) to make the reference absolute.
    5. Click the Criteria box and select cell B26.
    6. Click the Sum_range box, select cells F7:F18, and press F4 (FN+F4).
    7. Click OK. Total fees for the Biology department are 13350 (Figure 2-96).The formula is =SUMIF($B$B7:$A$18,B26,$F$7:$F$18)Figure 2-96 Function Arguments dialog box for SUMIF
  10. Copy a SUMIF function.
    1. Click cell C26 and drag its Fill pointer to copy the formula to cells C27:C29 without formatting to preserve the borders (Figure 2-97).The AutoFill Options button has an option to fill without formatting.Figure 2-97 Formula is copied without formatting
    2. Format cells C26:C29 as Currency.
  11. Use SUMPRODUCT and trace an error.
    1. Select cell D26 and click the Formulas tab.
    2. Click the Math & Trig button in the Function Library group and select SUMPRODUCT.
    3. Click the Array1 box and select cells C7:C9, credit hours for courses in the Biology Department.
    4. Click the Array2 box and select cells D7:D9, the number of sections for the Biology Department.
    5. Click OK. The Biology Department offered 98 total credit hours.
    6. Click cell D26 and point to its Trace Error button. The formula omits adjacent cells in the worksheet but it is correct.
    7. Click the Trace Error button and select Ignore Error.
  12. Copy and edit SUMPRODUCT.
    1. Click cell D26 and drag its Fill pointer to copy the formula to cells D27:D29 without formatting to preserve the borders.
    2. Click cell D27 and click the Insert Function button in the Formula bar.
    3. Select and highlight the range in the Array1 box and select cells C10:C12. The range you select replaces the range in the dialog box (Figure 2-98).The formula is now =SUMPRODUCT(C10:C12,D10:D12)Figure 2-98 Replace the ArrayN arguments
    4. Select the range in the Array2 box and select cells D10:D12.
    5. Click OK.
    6. Edit and complete the formulas in cells D28:D29 and ignore errors.
  13. Insert the current date as a function.
    1. Select cell F20.
    2. Type =to and press Tab to select the function.
    3. Press Enter.
    4. Press Ctrl+Home.
  14. Paste range names.
    1. Click the New sheet button in the sheet tab area.
    2. Name the new sheet Range Names.
    3. Press F3 (FN+F3) to open the Paste Name dialog box.
    4. Click the Paste List button.
    5. AutoFit columns A:B.
  15. Save and close the workbook (Figure 2-99).

Policy

 

Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.  

1. What is privacy?

2. What risks, if any, does facial recognition software raise?

3. How much information about you can be found on-line with a simple google search? 

4. How much information about you can be found by searching government and commercial databases?

5. Describe informed consent. 

6. Should secondary use of consumer provided data be available without notice to the consumer?

7. How do data mining and predictive analytics work? 

8. Watch this Science Friday video by Ira Flatow. And, offer your opinion – Are advancing algorithms taking our free will? 

9. Should Facebook be regulated, at least as far as it’s privacy and data policies? 

10. How many public cameras is too many? 

Programming Exercises Chapter 6: Recursion 14, 15, 16, 17, 20

Programming Exercises

Chapter 6: Recursion

14, 15, 16, 17, 20

Project Description

  • This project is group project. In each group, the total number of team member could be 1 to 3. (Individual project is allowed.)

Submission:

  • One project report in the form of PDF
  • One separate zip folder which contains all the source codes (java preferred.)
  • ONLY ONE group member submits the files on behalf of the whole group.

Evaluation:

  • Report: In the project report, please illustrate clearly what is your project about, the functions of source files, and the testing results. Include the names of all team members clearly and contributions of each. (The contributions of all team members will be assumed to be equal by default.) (20%)
  • Code: Check whether all operations have been successfully implemented. Check whether the code is commented appropriately and structured well. (80%)

Python Functions

1) Write a function that calculates the volume of a sphere with radius r for only values > 0, return 0 otherwise . V=4/3  π r^3

2)  Write a function that finds you weight in stones using the formula.  mstone = mkgx2.2/14

3) Write a function that takes some monetary amount from the user in dollars, and then display exact changes for this amount using the minimum number of coins. For example, $0.97 shows 3 quarters, 2 dimes, and 2 pennies. 

 

Output: 
change_it(97)

The change for 97 cents is:
3 quarters
2 dimes
2 pennies

 Write an function to calculate both Ohm’s Law and Power transferred. The function takes i and r as inputs and prints the results (see output below). Calculate only if both i and r are > 0. 

 

FORMULA
 i is current, v is voltage, r is resistance, p is power
 p = i * v   # power = current * volatage
 v = i * r   # voltage = current * resistance
def ohms_law(i, r): 
   '''
     i is current
     r is resistance
   '''
   # check if both i and r are greater than 0
   # calculate v and p
   # PRINT v and p
omhs_law(5, 5)
v = 25 p = 125

omhs_law(-5, -5)
0

Aligning Risks, Threats, and Vulnerabilities to COBIT P09 Risk Management Controls

  Introduction

Ask any IT manager about the challenges in conveying IT risks in terms of business risks, or about translating business goals into IT goals. It’s a common difficulty, as the worlds of business and IT do not inherently align. This lack of alignment was unresolved until ISACA developed a framework called COBIT, first released in 1996. ISACA is an IT professionals’ association centered on auditing and IT governance. This lab will focus on the COBIT framework. The lab covers two released versions: COBIT 4.1, which is currently the most implemented version, and COBIT 5, which was released in June 2012. A newer version, COBIT 2019, was released in 2019.

Because COBIT 4.1 is freely available, with registration, at the time of this writing, the lab uses this version to present the handling of risk management. COBIT presents this topic using a set of COBIT control objectives called P09. COBIT P09’s purpose is to guide the scope of risk management for an IT infrastructure. The COBIT P09 risk management controls help organize the identified risks, threats, and vulnerabilities, enabling you to manage and remediate them. This lab will also present how COBIT shifts from the term “control objectives” to a set of principles and enablers in later versions.

In this lab, you will define COBIT P09, you will describe COBIT P09’s six control objectives, you will explain how the threats and vulnerabilities align to the definition for the assessment and management of risks, and you will use COBIT P09 to determine the scope of risk management for an IT infrastructure.

  1. Define what COBIT (Control Objectives for Information and related Technology) P09 risk management is for an IT infrastructure.
  2. Describe COBIT P09’s six control objectives that are used as benchmarks for IT risk assessment and risk management.
  3. Explain how threats and vulnerabilities align to the COBIT P09 risk management definition for the assessment and management of IT risks.
  4. Use the COBIT P09 controls as a guide to define the scope of risk management for an IT infrastructure.
  5. Apply the COBIT P09 controls to help organize the identified IT risks, threats, and vulnerabilities.

 Deliverables

Upon completion of this lab, you are required to provide the following deliverables to your instructor:

  1. Lab Report file;
  2. Lab Assessment (worksheet or quiz – see instructor for guidance).