Hide Assignment Information
Instructions
Directions: Be sure to make an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English spelling and grammar. Sources must be cited in APA format. Your response should be four (4) pages in length; refer to the “Assignment Format” page for specific format requirements.
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)
Download All Files
Hide Rubrics
Rubric Name: Assignment 8 Rubric
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.
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.
/ 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.
/ 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.
/ 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.
/ 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)
/ 10
Accuracy
10 points
All of the technical descriptions and details are described accurately and match today’s available technology.
7 points
Most of the technical descriptions and details are described accurately and match today’s available technology.
4 points
Some of the technical descriptions and details are described accurately and match today’s available technology.
0 points
None of the technical descriptions and details are described accurately and match today’s available technology.
/ 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.
/ 10
Rubric Total Score
Total
/ 100
Overall Score
Overall Score
A
90 points minimum
B
80 points minimum
C
70 points minimum
D
60 points minimum
F
0 points minimum
Submit Assignment
Our Advantages
Plagiarism Free Papers
All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.
Free Revisions
All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.
Title-page
A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.
Bibliography
Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.
Originality & Security
At Homework Sharks, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.
24/7 Customer Support
Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
We work around the clock to see best customer experience.
Pricing
Our prces are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.
Communication
Admission help & Client-Writer Contact
When you need to elaborate something further to your writer, we provide that button.
Deadlines
Paper Submission
We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.
Reviews
Customer Feedback
Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.