Exp19_Excel_Ch06_ML2_Deck_Builders

Exp19 Excel Ch06 ML2 Deck Builders

Excel Chapter 6 Mid-Level 2 – Deck Builders

Project Description:

You are the business manager for Indy Deck Builders, a local construction company that specializes in new deck installation. Your company offers three deck models. Model A which costs $2,000, model B costs $3,500, and model C costs $5,000. You currently have 45 contracts to build model A, 55 for model B, and 75 for model C. Once the contracts have been completed, you will have a surplus of materials (wood, hard-ware, and paint) remaining in inventory. After expenses your company’s net profit is $492,031.25. You would like to use Solver to forecast how many additional contracts you can accept to maximize profit while not exceeding the raw materials in inventory.

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

Calculate total building   expensive for model A in cell C16. Total expense is calculated by multiplying   manufacturing cost (C4) and total contracts (C8). Then use the fill handle to   copy the formula into cells D16 and E16.

Calculate total profit for model   A in cell C17. Total profit is calculated by multiplying profit marging (C6)   and total contracts (C8). Then use the fill handle to copy the formula into   cells D17 and E17.

Create range names based on the   values in the range C19:C20 based on the values in the range B19:B20.

In cell C19 use the SUM function   to calculate total building expenses. The total building expenses are the sum   of the range C16:E16.

In cell C20 use the SUM function   to calculate total profits. The total profit is the sum of the range C17:E17.

If not loaded, load the Solver   add-in. Set the objective cell to Max Net Profit (cell C21).

Assign Total Contracts (range   C8:E8) as the Changing Variables Cells.

Set a constraint to ensure   contracts are whole numbers.

Set a constraint to ensure the   raw material used do not exceed inventory.

Set a constraint to ensure that   the Total Contracts are greater or equal to the existing contracts.

Create an Answer Report to   outline your findings.

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

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

Review your collection plan submitted in Week 1. You will develop a short 1300 word paper.

Task: Write a review of your collection plan and techniques, answering the following.

1. Identify if your collection plan and techniques have changed since your initial collection plan was created.
2. Identify why the techniques used initially may vary from what you would use today.
3. What if any, interesting fact have you gained from the discussion questions?

Following the example found here, create a company risk assessment matrix for your present or previous employer.

H2a_Risk_assessment_Matrix.xlsx

Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.

• 10.1 What are three broad mechanisms that malware can use to propagate?
• 10.2 What are four broad categories of payloads that malware may carry?
• 10.3 What are typical phases of operation of a virus or worm?
• 10.4 What mechanisms can a virus use to conceal itself?
• 10.5 What is the difference between machine-executable and macro viruses?
• 10.6 What means can a worm use to access remote systems to propagate?
• 10.7 What is a “drive-by-download” and how does it differ from a worm?
• 10.8 What is a “logic bomb”?
• 10.9 Differentiate among the following: a backdoor, a bot, a keylogger, spyware, and a rootkit? Can they all be present in the same malware?
• 10.10 List some of the different levels in a system that a rootkit may use.
• 10.11 Describe some malware countermeasure elements.
• 10.12 List three places malware mitigation mechanisms may be located.
• 10.13 Briefly describe the four generations of antivirus software.
• 10.14 How does behavior-blocking software work?
• 10.15 What is a distributed denial-of-service system?

Create a discussion thread (with your name) and answer the following question(s):

Discussion 1 (Chapter 13): What are the differences between structured, semistructured, and unstructured data?

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.

Chapter 7: Project InitiationChapter 8: Overview of Project PlanningInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1.  Your manager recently gave you the responsibility of selecting the next project, which you will manage as the project manager.  There are currently 3 projects on hold to choose from.  Using the weighted scoring models method, you determine that Project A has a weighted score of 16, Project B has a weighted score of 14, and Project C has a weighted score of 17.  Which project do you choose and why?

Text

Title: Project Management 

Subtitle: https://opentextbc.ca/projectmanagement/ 

Authors: Adrienne Watt 

Publisher: BCcampus Open Education 

Publication Date: 2019 

Edition: 2nd Edition 

 As we deep dive into TCP/IP and OSI protocols, looking at each one’s  architecture.  TCP/IP consists of four to five layers application,  transport, network, data link, and physical. OSI (International  Organization for Standardization) consists of seven layers application,  presentation, session, transport, network, data link, and physical.   

     Both Protocols use application for their first layers.  The  application layer supports applications and sometimes support services  such as encryption and compression.  Which user applications like  browser and word processing applications are not found within this layer  they use protocols that function within the application layer.   Application Protocols used for TCP/IP and OSI include HTTP (Hypertext  Transfer Protocol) which allows browsers and servers to send and receive  web pages.  SMTP (Simple Mail Transfer Protocol) enables users to send  and receive emails.  FTP (File Transfer Protocol) moves files from one  computer to another.  SSH (Secure Shell) allows remote computers to  securely log in to other computer systems.  SNMP (simple Network  Management Protocol) manages the numerous elements in a computer network  to be managed at a single point. 

     Looking at the second layer of TCP/IP and OSI which they differ.    TCP/IP second layer is the Transport Layer.  Which uses TCP  (Transmission Control Protocol) this allows for an error free end to end  connection.  TCP protocol is not the only protocol found in the  Transport Layer.  You can also find UDP (User Datagram Protocol) this is  not commonly found within this layer and usually used when steaming  data like music or videos.  OSI uses the presentation layer for its  second layer.  We do not find this layer within TCP/IP.  Which it  performs functions for presenting data properly to the sender or  receiver.

     The Third layer of TCP/IP and OSI differ also.  TCP/IP has the  Network layer thirdly.  The Network layer also known as Internet layer  or IP layer is used to transfer data within, and between networks.  IP  (Internet Protocol) software which prepares packets of data for  transmission between the networks. OSI third layer consists of the  session layer and is not found within the layering of TCP/IP protocol.   The session layer consists of transferring large amounts back and forth  between two systems.  It uses a point after each small section of  transmission to ensure proper data transmission.

     Now we are at the fourth layer of TCP/IP and OSI protocols.   TCP/IP uses Data Link at this layer.  Data Link layer which gets data  from user’s workstations and passes it to the router connected to the  Internet.  Commonly the LAN gets the data from workstation to Internet.   The Data Link Layer prepares data for transmission to a router sitting  between the LAN and internet.  OSI’s fourth layer is the second layer of  TCP/IP, Transport Layer.  Which verifies the data that arrived at the  destination is the same sent from the original station.

     Diving into the fifth layer of TCP/IP and OSI we see they also  differ.  With TCP/IP we find the Physical Layer which is the final layer  of its architecture.  This is where the data transmission occurs.  This  can be through physical wiring, or radio signal.  OSI uses the same  layer TCP/IP uses at its third layer.  Network layer also known as  Internet layer or IP layer is used to transfer data within, and between  networks.  IP (Internet Protocol) software which prepares packets of  data for transmission between the networks.

     OSI architecture only contains two more layers which are  included in the architecture of TCP/IP.  The sixth layer of OSI is the  Data Link layer it prepares data for transmission to a router sitting  between the LAN and internet.  OSI’s fourth layer is the second layer of  TCP/IP, Transport Layer.  Which verifies the data that arrived at the  destination is the same sent from the original station.  The seventh  layer is the Physical layer which is the final layer of OSI  architecture.  The physical layer where the data transmission occurs.   This can be through physical wiring, or radio signal.  

     After deep diving into both TCP/IP and OSI protocols we can see  that OSI architecture is bigger and more in depth then TCP/IP.   Understanding their architecture really brings why and what purpose  would you want to use ether.  My opinion is that you would use OSI in a  more secured networked area and TCP/IP within a expansion and smaller  less secure networked area.

References

West, J. (2022). Data Communication and Computer Networks (9th ed.).  Cengage Learning US. https://ecpi.vitalsource.com/books/9780357504413

Introduction

O’Keefe State University located in New Mexico has recently started using Canvas for online course delivery. Canvas hosts all the data in its own cloud storage. Students may log in to the systems form any personal device (laptops, phones, etc.). On-campus students can also use library computers. Note that the browsers may store student credentials (IDs and passwords) in a browser.

Directions 

Write a two-page security risk analysis to identify all possible security risks associated with the usage of Canvas in the library or on home computers.

Specifically address whether Canvas cloud architecture increases or decreases the cybersecurity risks associated with it, when compared to an old learning system that stored all student data on a servers located on-campus and managed by the university IT personnel. 

Read chapter 6. Answer the following question.

1.  Go through pages 234-241 of the textbook to complete the Resource on your Consumer Market Study project you started earlier. Show screenshots of your work and discuss what you learn. 

ü  Students should avoid using phrases like, “In my opinion,” or “I think,” or “I believe.” To support your response post to the weekly discussion question

 Question-1

What are authentication and authorization?

What are authentication and authorization used for?

What is Principle of Least Privilege?

Are you in favor or against the principle of least privilege? 

Justify your your answer.

Please list your reference/s

———————————–

Question –2

Please read chapter 4 and reputable external resources and Discuss:

 Why is it so difficult to design a good interface standard?

 Please list your reference/s