C10; Introduction to Computers
Assignment 8; Business Consulting
Remember Bill Wilson? He was the gentleman that you helped to start up his restaurant supply business in week 4. Well his business is doing well, but he has come to you with some questions, concerns and a request to assist him in expanding his business. You discuss each of these with Bill and promise to send him a written report with your suggestions and recommendations. Submit your written response to Bill's questions and concerns below.
1. 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, from cells F5 to F11 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, Rows 5 through 11, to do this:
a. Print the word "Yes" in any row of Column G where the total daily expenses in Column F are greater than or equal to $100.00.
b. If the daily expenses total in Column F is less than $100.00, leave the Column G entry for that row blank.
2. 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 are available to him. 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.
3. Bill wants to know what training would be appropriate for himself and his employees.
4. 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.
DELIVERABLES: For this assignment, there are two deliverables:
1. Your written proposal to Bill in a Word document.
2. An Excel spreadsheet containing the required formulas/functions in the cells shown in the table below. If you do not have Excel, you may type your formulas/functions into the table below and cut and paste this table into your proposal.
|
| A | B | C | D | E | F | G | H |
| 1 |
|
|
|
|
|
|
|
|
| 2 |
|
|
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
|
|
| 4 |
|
|
|
|
|
|
|
|
| 5 |
|
|
|
|
|
|
|
|
| 6 |
|
|
|
|
|
|
|
|
| 7 |
|
|
|
|
|
|
|
|
| 8 |
|
|
|
|
|
|
|
|
| 9 |
|
|
|
|
|
|
|
|
| 10 |
|
|
|
|
|
|
|
|
| 11 |
|
|
|
|
|
|
|
|
| 12 |
|
|
|
|
|
|
|
|
| 13 |
|
|
|
|
|
|
|
|
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.
