This installment aims to support theoretically and mathematically the methods to
implement. A document made in LATEX will be developed, where the results will be shown
theory of each of the assigned methods. The document must be developed in
IEEE format
2 page apa format
follow attached documents
Discussion – 2 pages
Assignment – 4 pages
Website Review – 6 pages.
Network Design Paper UMUC has recently acquired a building in Frederick, Maryland. This new building will house some administrative offices, lecture rooms, library, and computer labs. Building dimensions: Length: 240 Feet Width: 95 Feet Height: 30 Feet The 40-year-old two-story building has the following existing layout: There will be six computer labs that will be used for instruction. Each of these labs will have 21 computers (20 student computers and 1 instructor computer). Each of these labs will also have a server in the closet located inside the lab. In addition to the six computer labs, there will also be a Student Computer Lab that will provide computer access to students to do their homework. There will be 30 computers in this lab and a server in the closet. The library will also have some computers to allow students access to the library resources. There will be 10 computers for student’s use in the library, and 5 computers for Library staff. There are five lecture classrooms in the building. Each of this room will have a computer for instructor’s use. Finally, there are various offices in the building. Each of these offices will have one computer for the staff use, with the exception of the Admission office that will have 5 computers for staff use. Equipment Inventory Workstation Placement Number of Workstations Users Total WS 6 Instructional Computer labs 21 WS Student and Instructor 132 WS (based on 20 WS for students and 1 WS for instructor on each lab) Student Computer Lab 30 WS Student 30 WS 5 various offices 5 WS Staff 5 WS Admission office 5 WS Staff 5 WS Library 10 WS Student 10 WS Library 5 WS Staff 5 WS Server Staff To be determined by students Network Connecting Devices IT Staff To be determined by students Printers To be determined by student Two server rooms have been allocated, one on the first floor and one on the second floor. Your task is to design the network for this new building with the following criteria: • Student-accessed computers should be on separate network from the staff-accessed computers. • The whole building will share one Internet access connection (T-1 link from Verizon). This connection will come into the Server Room on the first floor. • Security is very important for UMUC as we have to protect students and employees data as well as any intellectual property that UMUC has on the servers and computers. • The network has been assigned the 10.15.0.0 network address for all computers and devices. For Internet routing use 191.1.1 network address. • The network should use physical cable (not wireless), but do provide wireless access in the Student Lobby area. Submission should include (in no more than three pages, excluding diagrams and references): Network Addressing: 1. Define the subnet (based on: rooms, floor, department, or other criteria). 2. For each subnet, define the network address, subnet mask, and available IP addresses to be used by computers or devices. Physical Network Design: 1. Define the topology that will be used. 2. Select the appropriate network media to use. 3. Select the appropriate network connecting devices to use. 4. Physical layout of the computers on the floor plan. 5. List of additional servers or network devices needed to implement the network. 6. Justifications for your network design (number 1 – 5 above) You will be evaluated on your ability to o Implement appropriate IP addressing scheme o select and justify appropriate cable media that includes the length of each cable segment and number of nodes on each segment o select and justify appropriate topology such as star, bus, or ring for your network o select and justify of your selected network equipments o select and justify appropriate network services to meet network requirements o select and justify security implementation for the network o use proper grammar, formatting, network terminology, and reference citations Feel free to use any drawings or attachments, and assume any number of computers or users (not when provided here). You will be graded on the basis of right media, topology and knowledge of network concepts. Grading Rubric Criteria 0-59% 60-79% 80-89% 90-100% IP Addressing 30% Student fails to demonstrate adequate subnetting knowledge Student demonstrates some knowledge of subnetting Student demonstrates proper subnetting for the network but failed to provide all IP addressing information needed Student demonstrates proper subnetting for the network and provide all IP addressing information needed Network Requirement 40% Student fails to design proper network to address the given scenario Student misses some critical network design and/or misses on the justifications Student designs a network that address most of the requirement and are able to justify some of the design Student designs a network that met all requirements and are able to justify the design Network Technical Knowledge 20% Student does not have grade
Chapter 8
Question 1: How does prescriptive analytics relate to descriptive and predictive analytics?
Question 2: Explain the differences between static and dynamic models. How can one evolve into the other?
Question 3: What is the difference between an optimistic approach and a pessimistic approach to decision making under assumed uncertainty?
Question 4: Explain why solving problems under uncertainty sometimes involves assuming that the problem is to be solved under conditions of risk.
Exercise 4: Investigate via a web search how models and their solutions are used by the U.S. Department of Homeland Security in the “war against terrorism.” Also, investigate how other governments or government agencies are using models in their mission. Write a report.
Chapter 9
Question 1: What is Big Data? Why is it important? Where does Big Data come from?
Question 2: What do you think the future of Big Data will be? Will it lose its popularity to something else? If so, what will it be?
Question 3: What is Big Data analytics? How does it differ from regular analytics?
Question 4: What are the critical success factors for Big Data analytics?
Question 5: What are the big challenges that one should be mindful of when considering implementation of Big Data analytics?
Exercise 3: Using the Internet, find the application of Big Data in sports. Summarize your findings.
Textbook: Business Intelligence and Analytics
ISBN: 9780135192016
Your response should be 5-6 pages. There must be APA formatted references (and APA in-text citation) to support the thoughts in the post.
Question 1
In your own words, describe a procedure used in programming. Why is it important to use procedures?
question 2
Submit a program that calculates the Weekly Pay of an employee using procedure in Visual Logic.
Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years. Pick an industry you feel will be most affected by blockchain and how blockchain may be used in that industry. As an IT manager, how would you embrace blockchain? For instance, how would training occur for your team, what strategies might you use, what security methods may you recommend be used?
Requires 2 pages and references
Do it on time
Download and read the document and answer all questions in the document. Please see attached document H2 and APA Criteria for H2 .
Exp19_Excel_Ch09_HOEAssessment – Ticket Sales 1.0
You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook.
Start Excel. Download and open the file named Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx. Grader has automatically added your last name to the beginning of the filename.
Note: When you open the file, Excel prompts you to fix a circular error. Click OK and continue.
The first column in the Friday worksheet contains cells with a different font color and levels of indentation. You want to fill this formatting across the Saturday and Sunday worksheets.
Group the Friday, Saturday, and Sunday worksheets. Fill the formatting for the range A5:A20.
You notice that a formula is missing on three worksheets. You will insert the formula simultaneously.
With the worksheets still grouped, in cell E21, enter a formula to subtract the Grand Total Percentage Sold from 1. Apply Bold to the cell. Ungroup the worksheets.
The Totals worksheet contains summary data. You will insert a hyperlink to the number of seats sold in each respective worksheet.
On the Totals worksheet, in cell A5, insert a hyperlink to cell C21 in the Friday worksheet with the ScreenTip text Friday. In cell A6, insert a hyperlink to cell C21 in the Saturday worksheet with the ScreenTip text Saturday. In cell A7, insert a hyperlink to cell C21 in the Sunday worksheet with the ScreenTip text Sunday. Test the hyperlinks to ensure the work correctly.
Now you are ready to insert a formula with a reference to the number of seats sold for Friday’s performance.
In cell B5, insert a formula with a 3-D reference to cell C21 in the Friday worksheet.
Now you are ready to insert a formula with a reference to the number of seats sold for Saturday’s performance.
In cell B6, insert a formula with a 3-D reference to cell C21 in the Saturday worksheet.
Now you are ready to insert a formula with a reference to the number of seats sold for Sunday’s performance.
In cell B7, insert a formula with a 3-D reference to cell C21 in the Sunday worksheet.
The next section of the Totals worksheet is designed to display total gross revenue by section.
In cell B11, insert the SUM function with a 3-D reference to calculate the total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and Sunday worksheets.
You are ready to insert a function to calculate the total Orchestra Back gross revenue.
In cell B12, insert the SUM function with a 3-D reference to calculate the total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and Sunday worksheets.
You are ready to insert a function to calculate the total gross revenue for the Tiers.
In cell B13, insert the SUM function with a 3-D reference to calculate the total Tiers gross revenue (cell G20) for the Friday, Saturday, and Sunday worksheets.
The third section of the totals worksheet needs to link to a value in another workbook.
Open the Exp19_Excel_Ch09_HOEAssessment_Venue.xlsx workbook. Go back to the Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx workbook. In cell B17 on the Totals worksheet, insert a link to the Weekend Evening value (cell C5). Close the Venue workbook.
The worksheet contains a circular error. Now you want to find and correct it.
On the Totals worksheet, check for errors and correct the formula with the circular reference.
You want to create a validation rule to prevent the user from entering too many seats sold. For now, you will create a validation for just one input cell.
In cell C6 in the Friday worksheet, create a validation rule to allow whole numbers less than or equal to data stored in cell B6. Enter the input message title Seats Sold and the input message Enter the number of seats sold. (including the period). Use the Stop alert with the error alert title Invalid Number and the error alert message The number cannot exceed total seats in section. (including the period). Test the data validation by attempting to enter 200 in cell C6 and then cancel the change.
You want to unlock data-entry cells so that the user can change the number of seats sold in the worksheets.
Group the Friday, Saturday, and Sunday worksheets. Select the ranges C6:C8, C11:C13, and C16:C19 and unlock these cells.
Now that you unlocked data-entry cells, you are ready to protect the worksheets to prevent users from changing data in other cells.
Individually, protect each sheet using the default allowances with the password Expl0r!ng.
Create 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 all worksheets.
Mark the workbook as final.
Note: Mark as Final is not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab.
Save and close Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx. Exit Excel. Submit the file as directed.
