Monthly Archives: June 2023

Exp22_Excel_Ch02_ML2 – Vacation Property 1.1

Exp22 Excel Ch02 ML2 – Vacation Property 1.1

Excel Chapter 2 Mid-Level 2 – Vacation Property 

Project Description:

You have been hired as a finance manager at Granger vacation homes, a regional construction company that finances and builds vacation properties. As part of your responsibilities you manage mortgage applications. Your predecessor left a partially created document you will use to calculate various details about each property being financed. You will use the VLOOKUP function to help determine mortgage interest rates, IF statements to calculate down payment, various statistical calculations, and XLOOKUP to create a quick search within the document.

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

Write an IF function in cell D9   that calculates the down payment for the mortgage. The down payment is 15% of   the purchase price if the customer is considered high risk or 5% of the   purchase price if considered low risk. The criteria to assess the risk of the   loan is based on the credit score value in cell B6. Be sure to use the appropriate   absolute or mixed cell references when referencing the input values in the   range B4:B6. Then use the fill handle to copy the formula down, stopping in   cell D28.

Enter a formula to calculate the   percent financed in cell E9. The percent financed is the amount   financed/purchase price. Next use the fill handle to copy the formula down,   stopping cell E28.

Enter a formula in cell F9 to   calculate the amount financed. The amount financed is the purchase price-down   payment. After entering the formula, use the fill handle to copy the formula   down, stopping in cell F28.

Use the VLOOKUP function in cell   G9 to lookup the mortgage rate based on the customer credit score and the   data in the range D4:E6. Be sure to use the appropriate absolute or mixed   cell references. Use the fill handle to copy the formula down, stopping in   cell G28.

Calculate the rate per period in   cell H9. All mortgages being financed will be paid monthly. After completing   the formula, use the fill handle to copy the formula down, stopping in cell   H28.

Calculate the total number of   payment periods in cell J9 based on the years financed in cell I9. After   completing the formula, use the fill handle to copy the formula down,   stopping in cell J28.

Use the PMT function to   calculate the total monthly payment in cell K10 based on the periodic   interest rate, number of periods, and amount financed. Ensure the results are   a positive value then use the fill handle to copy the function, down stopping   in cell K28.

Use Quick Analysis to calculate   the total of all payments in cell K29. (Quick Analysis is not available for   Mac. If using a Mac, use AutoSum to calculate the SUM of the range K9:K28).

Use the appropriate statistical   functions in the range B32:B36 to calculate descriptive statistics based on   the row headings in the range A32:B36. In cell B32, calculate the total count   of loans based on column A, lowest payment in cell B33 based on the data in   column K, highest payment in B34, average payment in B35, and median payment   in B36. 

Use the XLOOKUP function in cell   E32 to lookup the employee number in cell D32 and return the corresponding   down payment, % finances, and amount financed. 

Use the appropriate function to   insert the current date and time in cell B2.

Save and close the workbook.   Submit the file as directed.

Comprehensive Final Exam

Week 7: Program Construction

Code Management and Modularity 

Scenario and Summary

This week, we learn how to manage complexity by putting together a ready-built application that comprises a number of separate header and source files. Our job here will be to take these individual files and combine them into one standalone application. Although the process is quite a simple one, it will emphasize the advantage of modularity when writing code. It also shows how code can be reused between programmers and/or applications.

STEP 1: Create the   Project

1. Create a new C++ console-based project.

STEP 2: Add Files to   Your Project

1. Unzip the source code and header files found in Doc      Sharing (Lab_7_files.zip), and then add these files to your project as      needed.

STEP 3: Build and Test

1. Build your project (compile your program). 
2. Eliminate all syntax errors. 
3. Run the program. 

STEP 4: Label Title 

Assignment Description

The analysis phase helps determine what the software is supposed to do. Armed with this information, you can now turn your attention to how the software will meet the requirements. This is the design phase and the subject of this project. For this project, you will add the Design section to your Software Development Plan.

The project requires that you do the following:

• Update the Software Development Plan document title page with the new date and project name.
• Update the previously completed sections based on instructor feedback.
• System Architecture
  • Identify the system architecture to be used for the software, and justify the selection.
  • Identify the control systems.
  • Perform a modular decomposition, and document the results.
• User Interface
  • Provide designs for the primary displays for the software.
  • Document the reasoning used to develop the user interface design, and describe the tools used.
• Data Design
  • Provide necessary entity-relationship diagrams to illustrate the data design for the software.
• Be sure to update your Table of Contents before submission.
• Name the document “yourname_ITSD422_IP3.doc.”

Download The Attachment and Message Me Please for Detailed Instructions

Think of a modern technical support call center. In a call center, there are people who answer phone calls and provide support to end users. Their phones are typically integrated onto the network and/or their computers. Each phone needs a certain amount of bandwidth, and their computers need bandwidth. There are also managers who use the same technology but to a lesser degree, and support staff who manage the office and keep things running smoothly.

Now, move this office from the modern class and cubicle building to an old 1960s office building in Florida. Each office is a concrete block bunker, each team member has their own office, and the walls have SAND for insulation. (No joke – this is super common.) Also, there is a lining of asbestos in the ceiling and floor, so disturbing anything is a major nonstarter. Now, design the network for this call center so it can effectively operate.

Some data to help you out:

• The instructor feels sorry for any network administrator who needs to operate this network, so this isn’t something we should do in the real world
• Students are welcome to recommend commercial-grade solutions, but consumer-grade solutions will also receive perfect scores
• The computers do not have Wi-Fi cards, and most connect using ethernet cables. You need to recommend switches that can work in mesh mode or client mode
• There are 20 individuals working in the office
• Each computer requires 50 Mbps of network connectivity during use
• Each phone requires 0.5 Mbps (VOIP ethernet connection required) 
• The computers utilize technology in a data center that hides how the phones and computers communicate
• Phone communications are much more important than computer communication. The phones reboot if they cannot contact the VOIP server for two seconds
• Telephones are on vlan 1234
• Computers run on vlan 1235
• The building has a 10-Gbps connection to the server room, and each access point has multiple 1- or 10-Gbps connections to the switch. This connection to the switch may have a single vlan or both vlans applied to it
• The project has a $20,000 budget

With this information, design a wired and wireless network solution for this building. Remember, the users are separated by concrete block and SAND.

Parameters: Submit a one-page description of your solution. The solutions must include prices for all products and a two-sentence description of why each product was chosen. The solution must be complete, including, at minimum, ethernet cables, switches, wireless clients, and wireless access points.

Criteria

This criterion is linked to a Learning OutcomeRecommend an access point that distributes multiple SSIDs and allows the SSIDs to be placed on different VLANs.

This criterion is linked to a Learning OutcomeRecommend a wireless switch that can accept multiple SSIDs and place them on multiple VLANs.

This criterion is linked to a Learning OutcomeRecommend a switch and/or wireless client that can support multiple VLANs.

APA FORMAT AND CITATIONS AND NUMBER THE ANSWER BELOW QUESTION

SE494 week 3

Discussion 

An EARCON is the sound your phone makes (PCs and do this too) when a particular event happens. There’s the “Swooshing” sound when you get an email for instance.

Question 1 Have you set-up any unique EARCONS on your phone?

Question 2 Do you think mobile phone should have a different sound to the caller if your phone is busy? 

Question 3 Would you like to set-up your phone so that if persons A, B, or C (your favorite people) call you and you’re on your phone would you like them to hear something other than “beep … beep …. beep” (means your phone is busy)? 

Question 4 Would you like your favorites to hear some other message on their phone when you’re busy – like maybe a warble tone or a siren sound or something else which means “You’re my favorite person, call me back right away”?

Question 5 What role do you think EARCONs play in applications? 

Question 6 Would you like the EARCON to tell you more information than things like “Yes you got your ordering basket loaded correctly” such as maybe “What a great section of — product  ” etc.

Question 7 What innovations would you like to see in EARCONS?

–//– 

In your answers, please state the question number fist and then write your answers underneath.

All posts must be a minimum of 250 words. APA reference. 100% original work. no plagiarism.

The Reference Model is a conceptual framework for understanding how computers communicate. The OSI model defines seven different layers of communication rules. Each layer of the OSI model has its own means of communication or protocol. The OSI model is used as a reference when explaining how data passed over the network moves through each layer. Each of the seven layers has specific responsibilities and logically interfaces to the layer above or below it. Each layer in the OSI model provides a different service needed for communication across an IP network and physical media. The top three layers often are called the “upper layers” since they deal primarily with application data. The lower layers deal primarily with getting packets to their destination. Many refer to these layers as infrastructure. 

Questions:

1. For this discussion, compare and contrast two layers of the Open Systems Interconnection (OSI) Reference Model, including the protocols that run on each layer.

2. What was the reason that IPv6 was introduced?  Why do you think many organizations are not upgrading their network solely to IPv6 and run that protocol instead of running IPv4?  

3. What is the purpose of subnetting when using IPv4 addressing?  What role does subnet mask play in subnetting of IPv4?

As a consultant for a local coffee shop, your client has asked you for a social media plan to help promote the shop within the neighborhood. Your plan should include a budget and an explanation of which social media platforms your client should use and why. 

• Use the article, “Top 10 Social Media Management Tools” to help you.

Need it by Thursday 4pm eastern time. APA 7th edition format, 2pages. 

Subject: DBA Database Systems & Application

Create Final Project Presentation (PPT) for Project for “COVID Tracking digital app” aka VaxUS

Details: 

VaxUS will be an online portal and we also create Mobile App to record, manage and maintain the vaccination status of individuals who have been given the Covid19 shot or shots, in their entirety.  

The assumption is that the individual has not been vaccinated.

We also need to think of upcoming children vaccine between 5 to 12 year of age base on their state certificate/record.

Requirement:

1. Total 10-12 slides

2. No title page

3. please MUST READ and include from below 

   a. Database and Application Design

   b. Data Modeling,Connectivity,and Metadata

   c. Data Integrity and Database Security

   d. Database Design normalization

   e. High level overview of Entity Relationship Diagram and Database Network diagram