Bis320 Workshop 3 Assignment Requirement

Topics: Microsoft Excel, Decision support system, SQL Pages: 6 (1732 words) Published: March 8, 2015
Individual Assignment

1. What should be submitted
a) A Word document (BIS320_W3_???) containing the scenarios. b) An Excel document (BIS320_W3_???) containing costs and options for a wireless router. c) A Word document (BIS320_W3_PC_???) containing the plagiarism check report. Simply copy (not screen print) the entire plagiarism report to a word document and submit it. Completed plagiarism report must be turned in to receive credit for the assignment. If not available before the deadline, submit this document once it’s available. No penalty if the plagiarism check report is submitted late.

Where: Assignment Files tab

You could also place all three files in a zip file (BIS320_W3_???.zip) and submit the zip file instead of three above mentioned files.

Remember to replace ??? with the initials of your First, Middle, Last Names. For example BIS320_W3_SSS.

2. Objective
To review and understand database and data communications.

The specific questions for each scenario below are designed specifically for you to research, understand and respond. It is not expected for you to know these technologies already. The text book and the discussion questions have the supporting information to help you understand the purpose of the technology and how they fit in at home or business.

3. Requirement / Assignment Description

Write a paper between 1,200 and 1,500 words in which you respond to the questions designated for both scenarios.

The requirements stated in this section are general. Follow the guidelines outlined in section 4 to fully meet the assignment requirements.

Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before a show, you meet with the marketing managers and determine what displays and equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise trade show personnel as they set up the booths and equipment.

After the show, you supervise packing the booth and all the equipment as well as schedule its shipment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all the equipment are returned. If there are any problems due to shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a quarter-million dollars of equipment.

In Scenario 1:

You need to track data about booth components, equipment, shippers, and shipment. List typical fields for each type of data. Provide an example of two relationships that you need to track.

Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages?

Would you use a personal database or an enterprise database? Explain your answer.

Would a decision support system (DSS) be helpful? Explain your answer.

Scenario 2: You manage a group of seven employees in a small consulting business. Some employees work at home and some work in the office. Each of the employees needs to be connected to the Internet.

In Scenario 2:

Does your company need a WAN or LAN? Explain your answer.

Does your business require wireless? Explain your answer.

Consider security. Is your data sensitive and in need of protection? Do you need to use a VPN? Explain your answer.

Imagine that you created a Microsoft® Excel® spreadsheet to help you determine the costs and options for a wireless router for your office. Use the Microsoft® Excel® “Determining Databases and Data Communications Spreadsheet” template to manipulate the cost and specification data of the various wireless routers based on the directions in the spreadsheet.

Cite at least two references in your paper.

Format your paper consistent with APA guidelines.


Citations: follow APA guidelines.
The paper is laid out with effective use of headings, font styles, and white space.
Rules of grammar, usage, and punctuation are followed.
Sentences are complete, clear, concise, and varied.
Spelling is correct.
APA Guidelines
Do not use Week three scenario or anything similar as the title. Use a meaningful title that describes the content of the paper.
Do not use scenario one or scenario two as headings.
Do not repeat the requirements in the paper.
In text citation should be less than 10% of the paper.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • case assignment 3 Essay
  • Workshop 3 Essay
  • Security and Graded Assignment Requirements Essay
  • assignment 3 Essay
  • Assignment 3 Essay
  • Assignment 3 Essay
  • Assignment 3 Essay
  • Essay on assignment 3

Become a StudyMode Member

Sign Up - It's Free