I would like for you to write it as a paper. For the formulas, I am looking for just that, the formulas. You can provide them in a recreated spreadsheet or you can provide them in the paper with the rest of the assignment. It does not matter how you present the formulas as long as I see the three different types requested from the assignment. There are two more sections, the network portion and the security concerns. With the networks, you are to provide at least two different types of networks that you can setup at home along with the pros and cons of those networks. Then you are to provide the one you suggest and the equipment needed to setup that network. Think about it, if you have your computers networked at home, how is this done? What type of network is it? I am not looking for wired or wireless. I’m not looking for the different topologies. The information I am looking for is definitely in your reading and may be mentioned in the video. For the security concerns, you are to tell me 5 security concerns Bill would have with his network at home. Think about it. What are you worried about that can happening to your own computers? What concerns do you have about your own computers and data? This information is also in your reading. Remember to look at the reading material, Instructor’s notes and the video for assistance with these assignments. I hope this helped.
Business Consulting
Remember Bill? He was the gentleman that you helped to start up his business in Lesson 4. Well his business is doing well, but he has come to you with some questions and concerns. You discuss each of these with Bill and promise to send him a written report with your suggestions and recommendations. Bill’s questions and concerns are as follows:
Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this:
Tell Bill how to do the following tasks:
What formula or function does he put in Column F that will show the total expenses for each day?
What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?
Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G to do this:
Print the word “Yes” in any row where the total daily expenses are greater than or equal to $100.00.
If the daily expenses total is less than $100.00, leave the Column G entry for that row blank.
Bill’s business is already expanding. He thinks that in a few weeks he will need to hire one or two employees to help him. He knows that each new employee will need their own computer. He is also making the necessary changes so that the new employees will be working in a spare room in Bill’s house. Explain to Bill what networking options he has. Go through each type or configuration of network possible for him, making sure that you explain the pros and cons of each configuration. Finish with your suggestion for the network that he should set up and explain what new hardware will be required to do this.
With the possibility of three business computers in his home, and all of his business records possibly vulnerable, this would be a good time to advise Bill on how to set up a routine plan to protect and defend his new network. Provide a list of the five most important concerns for safety and security of the network and the computers in the network. For each concern, specify the action to be taken, and if applicable, what software you recommend be added to the system. Justify each of your recommendations.
Your proposal will be evaluated using the rubric below. Make sure you read the rubric and have a clear idea of what is expected. If there are any additional questions that you would have asked Bill be sure to note them as you explain to Bill what networking options he has so that you can explain what additional information could change your suggestion, if any.
Attachments
C10 Assignment 8 Rubric.pdf (346.3 KB)
Hide Rubrics
Rubric Name: Assignment 8 Rubric
This table lists criteria and criteria group names in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method. You can give feedback on each criterion by tabbing to the add feedback buttons in the table.
Criteria
Exemplary
Satisfactory
Unsatisfactory
Unacceptable
Criterion Score
Spreadsheet
20 points
All three spreadsheet functions will show the correct result or the action requested.
13 points
Two of the three spreadsheet functions will show the correct result or the action requested.
6 points
One of the three spreadsheet functions will show the correct result or the action requested.
0 points
None of the three spreadsheet functions will show the correct result or the action requested.
Score of Spreadsheet,/ 20
New Network
20 points
Suggested network changes entirely consistent with accepted standards outlined in the lesson readings.
13 points
Suggested network changes mostly consistent with accepted standards outlined in the lesson readings.
6 points
Suggested network changes partially consistent with accepted standards outlined in the lesson readings.
0 points
Suggested network changes NOT consistent with accepted standards outlined in the lesson readings.
Score of New Network,/ 20
Safety and Security
20 points
All of the main safety and security concerns in the weekly reading assignments are covered in the student’s proposed solution.
13 points
Most of the main safety and security concerns in the weekly reading assignments are covered in the student’s proposed solution.
7 points
Some of the main safety and security concerns in the weekly reading assignments are covered in the student’s proposed solution.
0 points
None of the main safety and security concerns in the weekly reading assignments are covered in the student’s proposed solution.
Score of Safety and Security,/ 20
Quality of Information
10 points
Information clearly relates to the main topic. It includes several supporting details and/or examples
7 points
Information clearly relates to the main topic. It provides 1-2 supporting details and/or examples
4 points
Information clearly relates to the main topic. No details and/or examples are given.
0 points
Information has little or nothing to do with the main topic.
Score of Quality of Information,/ 10
Justification
10 points
The proposal justifies all of the proposals submitted to the customer. (Spreadsheet, Network, safety and security)
7 points
The proposal justifies most of the proposals submitted to the customer. (Spreadsheet, Network, safety and security)
4 points
The proposal justifies few of the proposals submitted to the customer. (Spreadsheet, Network, safety and security)
0 points
The proposal justifies none of the proposals submitted to the customer. (Spreadsheet, Network, safety and security)
Score of Justification,/ 10
Accuracy
10 points
All of the technical descriiptions and details are described accurately and match today’s available technology.
7 points
Most of the technical descriiptions and details are described accurately and match today’s available technology.
4 points
Some of the technical descriiptions and details are described accurately and match today’s available technology.
0 points
None of the technical descriiptions and details are described accurately and match today’s available technology.
Score of Accuracy,/ 10
Mechanics
10 points
No grammatical, spelling, spacing, capitalization or punctuation errors.
7 points
One to two grammatical, spelling, spacing, capitalization or punctuation errors.
4 points
Three to four grammatical, spelling, spacing, capitalization or punctuation errors.
0 points
Five or more grammatical, spelling, spacing, capitalization or punctuation errors.
Score of Mechanics,/ 10
Rubric Total Score
Total
Score of Assignment 8 Rubric,/ 100Criterion score has been overridden
