C10 assignment 8 | Mathematics homework help


 

C10; Introduction to Computers

 

Assignment 8; Transresuscitation Consulting

 

Remember Bill? He was the yeoman that you aided to set-on-foot up his transresuscitation in week 4. Well-mannered his transresuscitation is doing well-mannered, but he has follow to you after a while some questions and anxietys. You argue each of these after a while Bill and pledge to impel him a written relation after a while your impulses and confideations. Submit your written solution to Bill’s questions and anxietys underneath.

 

  1. Bill has set up a spreadsheet in Excel that procure aid him conduct trail of expenses. So far, he has this:

 

 

 

Tell Bill how to do the forthcoming tasks:

 

  • What formula or employment does he put in Column F that procure appearance the completion expenses for each day?

  • What formula or employment does he put in columns B through F in Row 13 that procure grant him the completion expenses for the week in each class?

  • Bill wants the register in Column G to remind him of expenses that insist-upon avail for the accountant. Tell Bill what to put in Column G to do this:

    1. Print the message “Yes” in any row where the completion daily expenses are main than or similar to $100.00.

    2. If the daily expenses completion is near than $100.00, permission the Column G register for that row bleak.

 

  1. Bill’s transresuscitation is already expanding. He thinks that in a few weeks, he procure deficiency to employ one or two employees to aid him. He knows that each new employee procure deficiency their own computer. He is also making the expedient alters so that the new employees procure be afloat in a parsimonious opportunity in Bill’s progeny. Expound to Bill what netafloat options he has. Go through each symbol or form of network likely for him, making fast that you expound the pros and cons of each form. Finish after a while your impulse for the network that he should set up and expound what new hardware procure be insist-upond to do this.

  2. With the possibility of three transresuscitation computers in his home, and all of his transresuscitation memorials perchance assailable, this would be a cheerful age to guide Bill on how to set up a course scheme to vindicate and stroke his new network. Provide a register of the five most relevant anxietys for prophylactic and defence of the network and the computers in the network. For each anxiety, mention the resuscitation to be charmed, and if useful, what software you confide be added to the regularity. Justify each of your confideations.

     

 

Your prompting procure be evaluated using the rubric underneath. Make fast you recognize the rubric and own a plain effect of what is expected. If there are any joined questions that you would own asked Bill be fast to silence them as you expound to Bill what netafloat options he has so that you can expound what joined notification could alter your impulse if any.

 

 

Rubric