Monthly Archives: June 2023

 Exp19_Excel_Ch02_HOEAssessment_Gateway_Vacations

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

Click cell B2, click the   Formulas tab, click Date & Time in the Functions Library group. Select NOW, and then click OK to enter   today’s date in the cell.

Click cell D9. On the Formulas   tab, click Logical in the Function Library group, and select IF. Type C9<$B$6 in the Logical_test box, type B9*$B$4 in the Value_if_true box, and   type B9*$B$5 in the Value_if_false box.   Click OK, and use the fill handle to copy the contents of cell D9 down the   column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell E9, type =(B9-D9)/B9, and use the fill handle to   copy the contents of cell E9 down the column. Click Auto Fill Options, and   click Fill Without Formatting.

Click cell F9, type =B9-D9, and and press CTRL+ENTER. Use   the fill handle to copy the contents of cell F9 down the column. Click Auto   Fill Options, and click Fill Without Formatting.

Click cell G9, click Lookup   & Reference in the Function Library group and select VLOOKUP. Type C9 in the Lookup_value box, type $D$4:$E$6 in the Table_array box, and   type 2 in the Col_index_num box. Click   OK.

With cell G9 selected, use the   fill handle to copy the contents of cell G9 down the column, stopping at row   28. Click Auto Fill Options, and click Fill Without Formatting. With the   range G9:G28 selected, on the Home tab, in the Number group, click Increase   Decimal twice.

Click cell H9, type =G9/12, and press CTRL+ENTER Use the   fill handle to copy the contents of cell H9 down the column, stopping at row   28. Click Auto Fill Options, and click Fill Without Formatting. With the   range H9:H28 selected, on the Home tab, in the Number group, click Increase   Decimal twice.

Click cell J9, type =I9*12, and press CTRL+ENTER. Use the   fill handle to copy the contents of cell J9 down the column. Click Auto Fill   Options, and click Fill Without Formatting.

Click cell K9. Click the   Formulas tab, click Financial, and then click PMT. Type H9 in the rate box, J9 in the NPER box, and type -F9 in the Pv box. Click OK. 

Use the fill handle to copy the   contents of cell K9 down the column. Click Auto Fill Options, and click Fill   Without Formatting.

Click cell K29, press ALT+=, and   press ENTER.

Click cell B32, type  =COUNT(A9:A28), and press CTRL+ENTER to   calculate the total # of loans.

Click cell B33, type =MIN(K9:K28), and press CTRL+ENTER to calculate   the lowest monthly payment.

Click cell B34, type =MAX(K9:K28), and press CTRL+ENTER to   calculate the highest monthly payment.

Click cell B35, type =AVERAGE(K9:K28), and press CTRL+ENTER to   calculate the average monthly payment.

Click cell B36, type =MEDIAN(K9:K28), and press CTRL+ENTER to   calculate the median monthly payment.

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

Save and close Exp19_Excel_CH02_Assessment_Timeshare.xlsx.   Exit Excel and submit as directed.

There are TWO tasks that you would need to do( they are separate): 

Task 1 (Minimum 300 words): 

 Describe the ethical challenges faced by organizations operating globally. 

– Minimum two references. 

TASK 2:

Write a reply to the two responses in the attached document ( Response 1 and Response 2) with 150 words for each. 

There should be no plagiarism. Attach a plagiarism report with 0 % similarity index

Systems Analysis and Design PROJECT Assignment:

Write an analysis of a company – introducing the company and state an issue the company wants remedied. Follow the outline in chapter one of your text to complete all the steps of the analysis. State the implementation plan. You may use a fictitious organization, but a real organization would be better. This assignment is not a group project. Below is a sample outline of an analysis. Work on you document and each week upload the current version to Canvas.

1. System Vision Document Problem description System capabilities Business benefits
2. Plan the Project Determine the major components (functional areas) that are needed Define the iterations and assign each function to an iteration Determine team members and responsibilities
3. Discover and Understand Details Do preliminary fact-finding to understand requirements Identify Use Cases Identify Object Classes Identify Object Classes Design System Components
4. Design System Components Design the database (schema) Design the system’s high-level structure Browser, Windows, or Smart phone and 2 Architectural configuration (components) Design class diagram Subsystem architectural design
5. Build, Test, and Integrate System Components
6. Complete System Testing and Deploy the System INSTRUCTIONS:
7. Follow the APA Publications Manual sixth Ed. Papers are to be typed (use a word processor, Times New Roman with font size 12).
8. Limit – five to seven pages (exclusive of title page, bibliography); double[1]spaced on standard-sized paper (8.5″ x 11″) with 1″ margins on all sides.
9. Write clearly. Check your grammar and spelling.
10. Write in your own words. The class is conducted in English; your paper must be in English. Start early.
11. Upload your to the FINAL assignment in Canvas by midnight on last day of week 10

If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5? Why? Why would the other architectures not be a good choice?

Instructions:  Your response to the initial question should be 250-300 words.  Next respond to two postings provided by your classmates. The first post should be made by Wednesday 11:59 p.m., EST. I am looking for active engagement in the discussion.  Please engage early and often. You are require to create your initial thread in order to view and respond to the threads posted by other students.  There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed.  Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.

 Initial posts should be 250 to 450 words minimum 

 Your posts should be of substance and include additional research; there  should be at least two paragraphs that address the topic 

Check attachment 

Question 1. 1. (TCO1) The Central Office is the place: (Points : 5)

Where the operator makes connections.

Where all ISDN capabilities begin.

Where calls from subscribers are routed.

To connect the ADSL lines.

Question 2. 2. (TCO2) Like many softPBX systems, Asterisk refers to each leg of a voice call as a ____. (Points : 5)

Loop

SIP setup line

Channel

Ping

Question 3. 3. (TCO3) Known as ‘connectionless networking’, this protocol employs a method where IP datagram are sent over a network using a ‘best-effort’ approach. The recipient would not know if the packets sent were received by the intended recipient. (Points : 5)

UDP

TCP

ICMP

H.323

Question 4. 4. (TCO4) These are facility connections from the phone company switch to the residential analog telephones; or the term used for delivering dial-tone to a group of phones. (Points : 5)

Tip-ring

Lines

Trunks

Call links

Question 5. 5. (TCO5) Used by hackers to see vulnerabilities and gain access, it is a systematic process that attempts to identify all of the open and available services on a TCP/IP host. (Points : 5)

Firewall scan

DNS scan

Port scan

DMZ scan

Question 6. 6. (TCO6) This is a call accounting software that is retrieved from a PBX, where the incoming and outgoing call information are logged. The logged information can contain data as date, time, extension, trunk, caller ID, and duration of call. (Points : 5)

Call Database

SMDR

PBX log files

ACD

Question 7. 7. (TCO7) Along with CTI and ACD, this is a PBX supported application where multiple phones, telephony processes, phone operators, IVR, complex dial-plan, and hunt groups, run in a confined space and take information from customers, then, facilitate a response over the phone. (Points : 5)

Call Center

Auto Attendant

Intercom calling

Conferencing

Question 8. 8. (TCO10) This was the first VoIP standard, ratified by ITU-T in 1996, that addressed having real time communications for video and voice in an unreliable packet network, and applied for PBX-styled signaling that supports packet-based networks. (Points : 5)

SNMP

Megaco

H.323

SIP

Question 9. 9. (TCO11) This layer organizes and synchronizes dialogues between presentation entities in the OSI 7-Layer Communications Model, (Points : 5)

Data Link Layer

Transport Layer

Session Layer

Address of Destination

Question 10. 10. (TCO12) In Ethernet transmission, this is the result when two nodes transmit at the same time, which leads to data loss, re-transmission, delay, or latency. (Points : 5)

Error control

Termination

Collision

Multiple Station Access

Essay Questions (20 points each)

Question 1. 1. (TCO3) Name and explain the three most important factors that you must protect when Securing a VoIP Network. (Points : 20)

Question 2. 2. (TCO4) What makes coaxial cable popular among broadband applications to customer premises? Discuss its advantages. (Points : 20)

Question 3. 3. (TCO7) Out of CLECs, ILECs, and TSPs, which of these companies would use VoIP to offer voice services? Explain why. (Points : 20)

Question 4. 4. (TCO10) Briefly explain the importance of a Gateway in the VoIP infrastructure. (Points : 20)

Question 5. 5. (TCO5) How can it be determined if an ACD has been effective? What information would be provided from the ACD that would be viewed as valuable? List and define three reasons. (Points : 20)

1. (TCO6) What is a TMN? Discuss at least two Management Layers of TMN. (Points : 30)

Question 2. 2. (TCO8) What are the advantages and disadvantages of replacing a traditional PBX-type phone system with a Wireless IP phone? (Points : 30)

Question 3. 3. (TCO9) What role, if any does, VoIP play in terms of the call center space? (Points : 30)

Question 4. 4. (TCO11) Describe what a converged network is and what benefits are derived from that. (Points : 30)

Question 5. 5. (TCO12) When deploying a VoIP system, what are some of the critical components that should be looked at in terms of assessing the environment for the readiness of a VoIP deployment? (Points : 30)

Web designing is a very challenging field. To become a successful bespoke website design services provider, you need to have the following skills.

You need to learn web design theory. It contains everything you would need regarding creating attractive and colorful websites. Learning key web tools like Photoshop, WordPress, etc., are also really important if you want to become a successful web developer. You should also know HTML, CSS, and java scripts. These are the top 3 programming languages that developers use most of the time. Moreover, a web developer also has to be Patient and have communication skills. He should also have project management skills and the know-how to sell himself. 

Write a 2-3 page paper (deliverable length does not include the title and reference pages)

• Describe the steps for securing software
• Explain how to create data backups

 Review The Power of Good Design and select three of the ten principles noted for good design. Next in R, utilize these three principles in a problem that you will solve. First note the problem to solve, the dataset (where the information was pulled from), and what methods you are going to take to solve the problem.  Ensure the problem is simple enough to complete within a two-page document. For example, I need to purchase a house and want to know what my options are given x amount of dollars and x location based on a sample of data from Zillow within each location. 
Ensure there is data visualization in the homework and note how it relates to the three principles selected. 

Power of Good Design Link: https://www.vitsoe.com/gb/about/good-design

Make sure to include the references.