All posts by : chebby

ITS 631 Paper #1 (Chapters 1 – 5 Bourgeois)    Niccole Hyatt, PhD Professor

100 Points Possible  Open Textbook and Resources

Individual Effort Only!

APA format is required. References should be listed immediately after the question that is being answered. Each question lists a minimum number of unique scholarly references; the textbook is considered one unique reference (per question) regardless of how many times it is used. All references should be from the years 2010 to present day.

Review the rubric that will be used to evaluate this paper. All work must be completed individually.

1. Explain the Internet of Things. Use at least three unique references. Length: 4-5 paragraphs. 

2. Identify three security risks of open source software. How can they be overcome? Use at least three unique references. Length: 4-5 paragraphs.

3. What are the advantages of using a data warehouse? What are the disadvantages? Use at least three unique references. Length: 4-5 paragraphs. 

4. Explain VoIP.  Use at least three unique references. Length: 4-5 paragraphs. 

5 Pages 

Title: Network Installation

Paper type Essay

Paper format APA

Course level Undegraduate

Subject Area Other (Not listed)

# pages 1   ( or 300 words Minimum)

Spacing Double Spacing

# sources 4

Paper Details

For this assessment, imagine your cousin, Frank, just bought a small hardware store. He wants to install a network that will include 14 PCs; a printer, scanner, and fax combination; and a cable modem line that are all currently configured as a P2P network. Frank is on a tight budget, so he would like to do the work himself. He has been conducting research and cannot decide if he should install Cat5, Cat6, or fiber. He has asked you to help with his decision.

To prepare to make recommendations, complete the practice labs provided in the Virtual Resource Portal activity for this assessment.

Then, using research you conduct on the Internet and the lab activity as references, write a 3–5-page report in which you make recommendations to Frank. Address the following:

•Compare and contrast the different cabling standards.

•Discuss the cost benefits of client/server networks.

•Define the basic concepts of network cabling.

•Recommend a network to Frank based on your research.

•Apply the concepts from the practice lab activity for this assessment.

Additional Requirements

•Written communication: Written communication is free of errors that detract from the overall message.

•APA formatting: If you use sources, ensure that resources and citations are formatted according to APA (6th edition) style and formatting.

•Font and font size: Times New Roman, 12 point.

 After reading chapter 13, analyze the advantages and disadvantages of digital signatures. 

Length: Minimum of 400 words

Due date: Sunday, November 22, 2020 by 4:00PM EST

Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references.

Question:
Why do good requirements go bad?  What can be done to prevent things from going bad?

Research Paper: Develop a Computer/Internet Security Policy

Word count: 2 to 3 pages

You have been hired as the CSO (Chief Security Officer) for an organization. Your job is to develop a very brief computer and internet security policy for the organization that covers the following areas:

Computer and email acceptable use policy

Internet acceptable use policy

Make sure you are sufficiently specific in addressing each area. There are plenty of security policy and guideline templates available online for you to use as a reference or for guidance. Your plan should reflect the business model and corporate culture of a specific organization that you select. 

Include at least 3 scholarly references in addition to the course textbook. At least two of the references cited need to be peer-reviewed scholarly journal articles from the library.

Your paper should meet the following requirements:

Be approximately 2-4 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 three 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.

Reading resources:

1. Chapter 10, “Information Systems Sourcing”

Text book: Managing and Using Information Systems, Keri E. Pearlson, Carol S. Saunders, Dennis F. Galletta, John Wiley & Sons

2. Chapter 10, “Information Systems Sourcing” pp. 224-234

Buhrendorf, E. (2019). Outsourcing IT is a money-saving cyber safety net for company data. Fairfield County Business Journal, 55(20), 12. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=b9h&AN=136657455&site=eds-live

plagiarism check required, Good work, APA format, include References, within 8hrs

Find a criminal case that involved Digital Forensics. describing the case and how digital forensics were used in the investigation. 

Using WORD, write an ORIGINAL brief essay of 500 words or more.

I need at least 3 references and Turnitin Report.

Briefly provide an overview/description of your fictitious company.

Identify and discuss the importance of risk assessment to the organization’s security framework? Discuss the five layers of risk.

Length:   Minimum of 700 words

Briefly respond to all the following questions. Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references.

System architecture is the descriptive representation of the system’s component functions and the communication flows between those components.

My definition immediately raises some important questions.

• What are “components”?

• Which functions are relevant?

• What is a communication flow?

 

You work for a local construction firm “Bass Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll. To do this, follow the steps below.

1. Open a new Microsoft Excel workbook and name the workbook “M6_YourLastName.”
2. When saving this workbook, save to a location for easy access and easy access locations could include your desktop, your documents folder, or an external flash drive. Also, while completing steps for this assignment, it would be a good idea to periodically save your work so that you do not lose any progress.
3. In your new and opened workbook, notice 3 available worksheets in the bottom left area of the window labeled as “Sheet1,” “Sheet2,” and “Sheet3.”  For this assignment, you will use “Sheet1”
4. For “Sheet1” rename the sheet as “Weekly Payroll” (Hint: Right click on the “Sheet1” tab and the shortcut menu will give you option to rename the sheet.)
5. For the remaining two worksheets “Sheet2” and “Sheet3” delete these from the workbook. (Hint: Right click on the “Sheet2” tab and the shortcut menu will give you option to delete the sheet and follow the same process to delete “Sheet3”.)
6. In cell A1 type the name of the construction firm which is “Bass Engineering Group” (Note: It is okay, at this point” for the name to overlap into other columns because in the next step, you are going to merge and center this title).
7. Using your mouse, select cells A1 through K1, and when these cells are selected, use the “Center and Merge” tool to nicely center the name provided for the local construction firm entered from step 6. (Hint: Click the “?” in the top right area of the Microsoft Excel window and type the keywords “Merge and Center” if you need additional guidance on how to perform this task. Also, the Merge and Center tool can be found under the Home and then under tools for Alignment.)
8. Now that A1 through K1 is centered and merged, right click on this merged cell and from the shortcut menu select Format Cells. When the Format Cells dialog window appears, click the Alignment Tab and set both the horizontal and vertical alignment to Center. Then click the Font tab and set the font to Arial, set the font style to Bold and set the size to 16. Once formatting is applied, click OK.
9. For row 2, you will enter labels.  For example:
   1. In cell A2, input “EFN” (Reference: EFN stands for Employee First Name)
   2. In cell B2, input “ELN” (Reference: EFN stands for Employee Last Name)
   3. In cell C2, input “HR” (Reference: HR stands for Hourly Rate)
   4. In cell D2, input “OHR” (Reference: OHR stands for Overtime Hourly Rate)
   5. In cell E2, input “THW” (Reference: THW stands for Total Hours Worked)
   6. In cell F2, input “OHW” (Reference: OHW stands for Overtime Hours Worked)
   7. In cell G2, input “GP” (Reference: GP stands for Gross Pay)
   8. In cell H2, input “SST” (Reference: SST stands for Social Security Tax)
   9. In cell I2, input “FWT” (Reference: FWT stands for Federal Withholding Tax)
   10. In cell J2, input “SWT” (Reference: SWT stands for State Withholding Tax)
   11. In cell K2, input “NP” (Reference: NP stands for Net Pay)
10. At this point, labels are inputted, so use your mouse to select cells A2 through K2 and once these cells are selected, right click and from the shortcut menu select Format Cells. When the Format Cells dialog window appears, click the Alignment Tab and set both the horizontal and vertical alignment to Center. Then click the Font tab and set the font to Arial, set the font style to Bold and set the size to 10. Once formatting is applied, click OK.
11. Under the “EFN” and “ELN” labels beginning with cell A3 and B3 and ending with cell A15 and B15 enter 13 hypothetical employee names of choice.
12. At this point, employee names are inputted, so use your mouse to select cells A3 through K15 and once these cells are selected, right click and from the shortcut menu select Format Cells. When the Format Cells dialog window appears, click the Alignment Tab and set both the horizontal and vertical alignment to Center. Then click the Font tab and set the font to Arial, and set the size to 10. Once formatting is applied, click OK.
13. Next, use your mouse to select cells A1 through K15 and once these cells are selected, right click and from the shortcut menu select Format Cells. When the Format Cells dialog window appears, click the Border Tab and then click Outline and Inside border options. Once formatting is applied, click OK. At this point, the illustration below will give ideas to this point but be aware that the illustration is not to scale meaning that adjustments in row and columns widths may be needed as further information is added in future steps.

Bass Engineering Group

EFN

ELN

HR

OHR

THW

OHW

GP

SST

FWT

SWT

NP

John

Doe

Sally

Doe

Ferris

Doe

Peter

Doe

Jessica

Doe

Tammy

Doe

Julie

Doe

Michael

Doe

Jason

Doe

Buck

Doe

Tula

Doe

Heather

Doe

Gary

Doe

1. Under the “HR” label beginning with cell C3 and ending with cell C15, enter a regular hourly rate of pay. (Use any values of choice but stay within the range between 15 and 50.)
2. Under the “OHR” label beginning with cell D3 and ending with D15, use a formula to calculate the overtime hourly rate of Time and Half. For example, in cell D3, you will enter “=C3*1.5” and in cell D4, you will enter “=C4*1.5” and in cell D5, you will enter “=C5*1.5” and follow the same pattern entering the rest of the formulas through cell D15 and pay close attention to the cell references. (Hint: Once the first 3 formulas above are entered, select these cells holding these formulas using your mouse and then in cell D5, use the fill handle in the bottom right corner of this cell to drag and fill the rest of the formulas automatically through D15.)
3. Under the “THW” label beginning with cell E3 and ending with cell E15, enter the total number of hours worked. Use any number of hours but stay in the range between 25 and 80 and have at least 3 of the entries over 40 hours.
4. Under the “OHW” label beginning with cell F3 and ending with cell F15, you will use the IF function to extract any overtime hours from the total hours worked entered from step 16. For example, in cell F3, you will enter the following formula: “=IF(E3>40, E3-40,0)”. (Note: An “IF” function is a conditional formula that is looking for a condition that is true or false based on parameters set. In this case, the condition is E3>40 and if cell E3 has value greater than 40, then the condition is true thus the nested formula E3-40 will execute to output the remaining hours as overtime hours. If cell E3 is below 40, then the condition is false and no overtime hours are outputted thus 0 will be the output.)
5. For step 17, pay close attention to cell references as well. For example, in cell F4, you will enter the following formula: “=IF(E4>40, E4-40,0)” and in cell F5, you will enter the following formula: “=IF(E5>40, E5-40,0)”. See the illustration below for visual guidance and follow the pattern to enter the remaining “IF” functions through cell F15. (Hint: Using the fill handle learned from step 15 will work in this case as well.)

EFN

ELN

HR

OHR

THW

OHW

John

Doe

15

=C3*1.5

33

=IF(E3>40, E3-40,0)

Sally

Doe

17

=C4*1.5

35

=IF(E4>40, E4-40,0)

Ferris

Doe

19

=C5*1.5

37

=IF(E5>40, E5-40,0)

Peter

Doe

21

=C6*1.5

39

=IF(E6>40, E6-40,0)

Jessica

Doe

23

=C7*1.5

41

=IF(E7>40, E7-40,0)

Tammy

Doe

25

=C8*1.5

43

=IF(E8>40, E8-40,0)

Julie

Doe

27

=C9*1.5

45

=IF(E9>40, E9-40,0)

Michael

Doe

29

=C10*1.5

12

=IF(E10>40, E10-40,0)

Jason

Doe

31

=C11*1.5

25

=IF(E11>40, E11-40,0)

Buck

Doe

33

=C12*1.5

77

=IF(E12>40, E12-40,0)

Tula

Doe

35

=C13*1.5

41

=IF(E13>40, E13-40,0)

Heather

Doe

37

=C14*1.5

40

=IF(E14>40, E14-40,0)

Gary

Doe

39

=C15*1.5

40

=IF(E15>40, E15-40,0)

1. Now you are going to enter formulas to calculate the answers to the questions below:
   1. Calculate each employee’s gross pay (GP) for the week. For example, the gross pay for cell G3 can be calculated with the following formula: “=((E3-F3)*C3)+(D3*F3)”. Notice how the formula references cells and follow this pattern for all other employees listed. For example, the formula for G4 is =((E4-F4)*C4)+(D4*F4) and G5 is =((E5-F5)*C5)+(D5*F5). (Hint: Using the fill handle learned from step 15 will work in this case as well). For some information on what this formula is doing, the first part of the formula “=((E3-F3)*C3” using cell G3 as an example takes Total Hours Worked and subtracts Overtime Hours Worked and then multiplies the result by the Hourly Rate. The remaining part of the formula “+(D3*F3)” calculates overtime pay by multiplying the Overtime Hourly Rate by Overtime Hours Worked.
   2. Next, calculate each employee’s SST (Social Security Tax Rate, 7.65%). For example, the SST for cell H3 can be calculated with the following formula: “=G3*7.65%.” Notice how the formula references cells and follow this pattern for all other employees listed, for example, cell H4 will have a formula “=G4*7.65%” and cell H5 will have a formula “=G5*7.65%”. (Hint: Using the fill handle learned from step 15 will work in this case as well.) 
   3. Next, calculate each employee’s FWT (Federal Withholding Tax. 18%). For example, the FWT for cell I3 can be calculated with the following formula: “=G3*18%”. Notice how the formula references cells and follow this pattern for all other employees listed, for example, cell I4 will have a formula “=G4*18%” and cell I5 will have a formula “=G5*18%”. (Hint: Using the fill handle learned from step 15 will work in this case as well). 
   4. Next, calculate each employee’s SWT (State Withholding Tax, 5%). For example, the SWT for cell J3 can be calculated with the following formula: “=G3*5%”. Notice how the formula references cells and follow this pattern for all other employees listed, for example, cell J4 will have a formula “=G4*5%” and cell J5 will have a formula “=G5*5%”. (Hint: Using the fill handle learned from step 15 will work in this case as well.)
   5. Next, calculate each employee’s NP (Net Pay). For example, the NP for cell K3 can be calculated with the following formula: “=G3-(H3+I3+J3)”. Notice how the formula references cells and follow this pattern for all other employees listed, for example, cell K4 will have a formula “=G4-(H4+I4+J4)” and cell K5 will have a formula “=G5-(H5+I5+J5)”. (Hint: Using the fill handle learned from step 15 will work in this case as well.) 
2. From steps 19a through 19e, below is an illustration with imputed formulas for guidance if needed:

GP

SST

FWT

SWT

NP

=((E3-F3)*C3)+(D3*F3)

=G3*7.65%

=G3*18%

=G3*5%

=G3-(H3+I3+J3)

=((E4-F4)*C4)+(D4*F4)

=G4*7.65%

=G4*18%

=G4*5%

=G4-(H4+I4+J4)

=((E5-F5)*C5)+(D5*F5)

=G5*7.65%

=G5*18%

=G5*5%

=G5-(H5+I5+J5)

=((E6-F6)*C6)+(D6*F6)

=G6*7.65%

=G6*18%

=G6*5%

=G6-(H6+I6+J6)

=((E7-F7)*C7)+(D7*F7)

=G7*7.65%

=G7*18%

=G7*5%

=G7-(H7+I7+J7)

=((E8-F8)*C8)+(D8*F8)

=G8*7.65%

=G8*18%

=G8*5%

=G8-(H8+I8+J8)

=((E9-F9)*C9)+(D9*F9)

=G9*7.65%

=G9*18%

=G9*5%

=G9-(H9+I9+J9)

=((E10-F10)*C10)+(D10*F10)

=G10*7.65%

=G10*18%

=G10*5%

=G10-(H10+I10+J10)

=((E11-F11)*C11)+(D11*F11)

=G11*7.65%

=G11*18%

=G11*5%

=G11-(H11+I11+J11)

=((E12-F12)*C12)+(D12*F12)

=G12*7.65%

=G12*18%

=G12*5%

=G12-(H12+I12+J12)

=((E13-F13)*C13)+(D13*F13)

=G13*7.65%

=G13*18%

=G13*5%

=G13-(H13+I13+J13)

=((E14-F14)*C14)+(D14*F14)

=G14*7.65%

=G14*18%

=G14*5%

=G14-(H14+I14+J14)

=((E15-F15)*C15)+(D15*F15)

=G15*7.65%

=G15*18%

=G15*5%

=G15-(H15+I15+J15)

1. Next, use the SUM” function to calculate totals for THW, OHW, GP, SST, FWT, SWT, and NP for the week. For example:
   1. In cell E16, the formula “=SUM(E3:E15)” will calculate the total THW for the week.
   2. In cell F16, the formula “=SUM(F3:F15)” will calculate the total OHW for the week.
2. For the remaining totals for GP, SST, FWT, SWT, and NP, use the fill handle to copy the rest of the SUM functions across cells G16 through K16. (Hint: Select cells E16 and F16 using the mouse and then in cell F16, use the fill handle in the bottom right corner of this cell to drag and fill the rest of the formulas automatically to the right through cell K16.)
3. Next, type the label Totals in cell A16 and then merge and center this label across cells A16 through D16.
4. Now that A16 through D16 is centered and merged, use your mouse to select all cells from A16 through K16 and once all cells are selected, right click and from the shortcut menu select Format Cells. When the Format Cells dialog window appears, click the Alignment Tab and set both the horizontal and vertical alignment to Center. Then click the Font tab and set the font to Arial, set the font style to Bold and set the size to 10. In addition, click the Border Tab and then click Outline and Inside border options. Once formatting is applied, click OK.
5. Next, use your mouse to select all cells from G3 through K16, which are all these cells that include data associated with money, and format these cells to Currency format. (Hint: Once all cells are selected from G3 through K16, the “$” tool can be found under Home and then under Number.)
6. Next, create a 3D column chart to illustrate values for GP and another chart of choice for illustrating values for NP. Note, do not include the totals on row 16. Once both charts are created, move the charts to another worksheet and to do this, right click on the edge of the chart and from the shortcut menu, select the option for Move Chart. When the Move Chart dialog window appears, select the option for New Sheet and name the sheet accordingly to the chart. For example, the chart holding data associated with Gross Pay GP should be named GP and NP for the other chart representing Net Pay.
7. As the final step, add some color shading to the cells associated with rows 1, 2, and 16 and adjust row and column widths to nicely fit the data and after final proofing,
8. Save and be sure the name of the Microsoft Excel Workbook is “M6_YourLastName”.
9. Submit to the dropbox.

Below is a general presentation to give you an idea of how your final data on the Weekly Payroll worksheet should look and do not forget that you will have 2 other worksheets holding the 2 required charts:

Bass Engineering Group

EFN

ELN

HR

OHR

THW

OHW

GP

SST

FWT

SWT

NP

John

Doe

15

40

33

0

 $   495.00

 $  37.87

 $89.10

 $ 24.75

 $ 343.28

Sally

Doe

17

40

35

0

 $  595.00

 $  45.52

 $ 107.10

 $ 29.75

 $412.63

Ferris

Doe

55

82.5

37

0

 $  2,035.00

 $ 155.68

 $ 366.30

 $ 101.75

 $ 1,411.27

Peter

Doe

21

31.5

39

0

 $  819.00

 $    62.65

 $147.42

 $40.95

 $ 567.98

Jessica

Doe

23

34.5

41

1

 $  954.50

 $    73.02

 $171.81

 $ 47.73

 $ 661.95

Tammy

Doe

55

82.5

43

3

 $  2,447.50

 $  187.23

 $  440.55

 $ 122.38

 $ 1,697.34

Julie

Doe

27

40.5

45

5

 $ 1,282.50

 $    98.11

 $230.85

 $64.13

 $889.41

Michael

Doe

26

45

12

0

 $  312.00

 $   23.87

 $56.16

 $15.60

 $216.37

Jason

Doe

31

46.5

25

0

 $ 775.00

 $   59.29

 $139.50

 $38.75

 $537.46

Buck

Doe

33

49.5

77

37

 $ 3,151.50

 $  241.09

 $567.27

 $157.58

 $2,185.57

Tula

Doe

35

55

41

1

 $ 1,455.00

 $  111.31

 $261.90

 $72.75

 $1,009.04

Heather

Doe

37

55.5

40

0

 $ 1,480.00

 $ 113.22

 $266.40

 $74.00

 $1,026.38

Gary

Doe

39

58.5

40

0

 $ 1,560.00

 $  119.34

 $280.80

 $78.00

 $1,081.86

Totals

508

47

 $ 17,362.00

 $ 1,328.19

 $ 3,125.16

 $ 868.10

 $12,040.55

Assignment Expectations

Structure and Format: Follow all 29 steps using ideally Microsoft Excel.

File name: Name your saved file according to your first initial, last name, and the assignment number (for example, “RHall Assignment 1.xlsx”)

Assignment Instructions

Create a narrated 6-8 slide presentation in Microsoft PowerPoint® in which you discuss the aspect of software development history that you found most interesting during this week’s learning. Be sure to discuss whether this historical aspect has a continuing influence in today’s software development environment in terms of core programming concepts such as repetition structures, decision structures, arrays, functions, and variables. For example, think about how the shift from procedural programming to object-oriented programming changed or did not change how the core concepts were handled. When composing your presentation, be sure to use Standard English and a highly developed and sustained viewpoint and purpose. The communication of your presentation should be highly ordered, logical and unified.

Additionally, one slide must be devoted to some aspect of software development history demonstrating the benefits of multiculturalism and diversity in a global context. How has software development evolved as we have become more globalized and how has it influenced the growth and change in software development?

Your presentation must have narration throughout as if you were delivering it in a live, professional setting. Focus on your word choice. Your oral delivery techniques, including word choice and oral expressiveness, should display exceptional content, organization, and style, while leading the audience to a dynamic and supported conclusion.

For instructions on adding audio to your presentation, please review the HOONUIT module on adding media.
https://learnit.hoonuit.com/5567/learnit

Assignment Requirements

Narrated content must be effectively incorporated into the presentation. Oral delivery techniques, including word choice and oral expressiveness, displays exceptional content, organization, and style, while leading the audience to a dynamic and supported conclusion.

At least one slide must demonstrate the ability to analyze the benefits of multiculturalism and diversity in a global context.

Assignment Requirements

Points

Possible

Points

Earned

Student selects a specific aspect of software development history to discuss.

5

At least one slide analyzes an aspect of software development history that demonstrates the benefits of multiculturalism and diversity in a global context.

5

Student work includes recommended solutions to issues that arise from a more globalized software development environment.

5

Effectively discusses how this historical aspect continues to influence today’s software development environment (taking into account covered programming concepts, such as repetition structures, decision structures, arrays, functions, and variables).

15

Student’s voice narration effectively incorporated into the presentation.

10

Presentation is 6–8 slides in length.

5

Total (Sum of all points)

45