Assignment: Networking & Communication - Module Assignment
Create an electronic spreadsheet using MS Excel. While you are encouraged to be creative, you will be graded on your ability to demonstrate an understanding of the module content and the ability to use the software application (Excel) to create a spreadsheet. All listed items below must be present and included in an Excel file.
You will create a new Excel file, name the file "Networking_YourLastName", and complete the work listed.
I. Content Expectations - tour spreadsheet should provide an overview and explanation of the following concepts
Define WAP
Explain the uses of a WAP
Define a switch
Explain the uses of a switch
Define a router
Explain the uses of a router
Define CATSE
Explain the uses of CAT 5E
Note: You must cite your sources using MLA or APA citation style. Additionally, you must write in your own words (paraphrase). Copying and pasting text from a website is never acceptable and is plagiarism.
II. Excel Functionality Expectations and Steps - The following Excel functionality and features must be included in your spreadsheet:
Title of your creation, merge & center the title across 9 cells (title should include your name) Apply Calibri font, Bold, and 14 point font size, use a font color of your choice other than black and apply it to the title
Apply a thick bottom border style to the merged title cells and color the cell with yellow fill
Create 9 columns labeled: Stores, WAP, Price, Switch, Price, Router, Price, CAT SE, Price
Apply Constantin font, 11 pt font size, bold, underline, and use center alignment on the column titles
Under the Stores column create 3 rows titled: Best Buy, Newegg, and Amazon
Apply Calibri font with a font point size of 11 pt to the row titles, do not apply bold
Go to bestbuy.com, newegg.corn, and amazon.com and locate similar or the same devices for a WAP, Switch, Router, and CAT SE (SO ft.) and fill in the prices for each in the appropriate cells
In the cells preceding each price insert the hyperlink to the web page where you found the price for that networking product
Below each pricing column (pricing for WAP, switch, router, and CAT 5E) create cells using the proper functions to display the average, minimum, and maximum values for that associated pricing column. Leave a space or two between the pricing information created previously and this new information just so it stands out, Label the row of cells Average, Min, and Max, accordingly
Use the currency number format on all pricing in the Average, Min, and Max cells
Bold the Average, Min, Max row headings
Move clown from the Average, Min, and Max information Cat least three rows) and create a title cell. Enter the text "Recommendation Option" in the cell and apply merge & center to 3 cells
Apply Calibri font., Bold, 11 point font size, use font color of your choice other than black on the title
Apply a thick bottom border style to the merged title cell and color the cell with orange fill
Under the title create four rows, one for each of your recommended product. In the 1st column list the store where you would find that product, next in the adjoining cell to the right put the copied hyperlink for the product you are recommending followed in the next cell to its' right the price of that recommended item. Repeat this for all four recommended devices. See example and use it as a guide if necessary
Apply a single underline to the last item price listed
In the cell under the last store listed (new row) type Subtotal as the next row heading, move down to the row under that and title that row heading Discount, and once again move down another row and title that row heading Total
Use a formula to obtain the recommended subtotal
Enter the discount rate you will use in the cell to the left of the discount. See example for clarification if needed
Use a formula that will calculate the discount
Apply a single underline to the discount calculated
Use a formula that will calculate the total
Use the currency number format on all pricing
Insert a picture of yourself on the spreadsheet
Below the picture, create four cells each merging 3 rows and 9 columns
Apply a thick black border style to each
Using text wrap answer four questions that are located on the bottom of the example at the end of this document
III. Discount Rate - use the day of the month you created your Excel assignment for the Discount Rate; for example if you create your Excel assignment on 15th day of the month (e.g. 1/15/2017) then the discount rate would be 15%, if you created the file on the 5th day of the month the discount rate would be 5%
Note: The functionality you are being asked to use were covered in the Atomic Learning videos. If you need to go back and review a tutorial, please do so.
IV. Submit your assignment - Access the module and upload your finished Excel file to the dropbox.
V. Scenario - Your best friend has just moved from student housing, which provided free wireless access to a new two story home. Your friend has asked for your help with the design of the network and if you could give him a few pricing options for a WAP, switch, router, and 50 ft. of CAT 5E cable. Your friend has a discount card that can only be applied to purchases from Best Buy, Newegg, or Amazon. Since it is your best friend, you have decided to help further by creating a spreadsheet that will give him/her three options for each component. In addition, being the good friend that you are, you are going to include a recommendation list which will include the subtotal, discount rate, total cost and a brief description of each component.