Reference no: EM13163636

1. (15%) Allen FINALLY has been able to secure broadband service to his home in a remote area of the country via newly installed telephone lines. He had a powerful desktop. But he wants to be able to sit on his deck when using his new laptop to do his online schoolwork, check email, play games, and participate in social networking sites (instead of being bound to his office desktop system.

1. Design a wireless network for Allen using his existing desktop and laptop.

2. Describe how he could use the home network.

3. What types of hardware, software, connectivity components, etc., would be required to fully implement the home network?

4. Security issues will need to be considered. What are the risks to his network? What will she need to fully protect their home network?

1. (10%) What is software piracy? Give two examples of software piracy. When and under what circumstances is file copying or sharing (software applications, DVDs, music files) legitimate? Illustrate with at least 3 specific examples.

2. (10%) One computer has a quad-core CPU; another has a dual-core CPU. If both are rated at 2Ghz clock speed (2 billion cycles per second) how can the quad-core CPU process instructions more quickly? What else is needed besides clock speed and core size to optimize the processing power? Be specific in your description of what "else" is needed.

3. (10%) Define the term ergonomics. Why is ergonomics important when a computer is designed? What purpose does ergonomics serve in an office or home setting? What are the consequences of a poor ergonomically-designed workspace?

4. (10%) What is a computer-based information system? Describe how WebTycho fits the definition of a computer-based information system. Into which type(s) of information systems does WebTycho fit? How does this system benefit UMUC? Who is the audience or level of management served by this information system? How do the audience or level of management benefit?

5.  (10%) Name the four (4) principle types of memory chips, and explain the differences and similarities between them. In your response, demonstrate your understanding by using your own words. For a computer running Windows 7 and Microsoft Office 2010, what type of memory might you want, and what is the recommended amount?

The following short answer questions are worth 3.5% each (total 35% for 10 questions).

7. When you created your pie chart for the Excel project, you forgot to add a chart title. How would you go back and enter the required title on the chart?

8. What is the AutoFill feature in Excel? How can it be used to copy a formula to a series of cells?

9. What is the difference between a relative cell reference and an absolute cell reference? When would you make a reference absolute? Provide an example of when you would use an absolute cell reference.

10. What are the four ways to add a function to a formula?

11. Provide an example demonstrating the benefit of a relational database.

12. It is one hour before the due date/time, and you have finished your MS Access project, but you take a break before submitting it to the Assignments folder. During the break, someone accidentally deletes your database file. What MIGHT you have done that would enable you to recover the project without re-doing all your work?

13. What are the benefits of using Slide Master view in PowerPoint?

14. Describe how you would add an animation to one of your PowerPoint presentation slides. Discuss what you should consider when using animations in the presentation.

15. Name the five (5) views available in MS Word, and identify which of those five (5) is the default view.

16. You have accepted or have been transferred to a new job across the country. The steps involved in relocating yourself and your family can be evaluated by using the SDLC. List each phase of the cycle, and provide at least one (1) item that would be found in each of the six (6) phases of a typical SDLC as applied to your move.