Computer

1. (15%) Juanita is an amateur, but serious, videographer—she creates videos and films for clients. She is in the market for a new computer and would like your advice on whether to purchase a desktop or a laptop.
A. Is a desktop the right choice for her business or should it be a laptop? Justify your choice by comparing the pros and cons of each.
B. What operating system would you recommend? Why?
C. Suggest two application software programs relevant to her business and explain why they are important.
D. In addition to the computer, suggest three additional peripherals that would be important to her business. She already owns a camera.
E. Rank your recommendations in terms of importance.

2. (10%) You have been asked by a relative to help him start using the Internet for the first time. You want to help this beginner but you must be careful not to overwhelm him with too much information.
A. What are five functions this beginner must know in order to understand how to access the Internet?
B. Describe each function. Explain why these functions are important first steps in learning to use the Internet.
C. For each function, provide the step-by-step instructions the new user will need to practice the function.

3. (10%) Define the term system software. Provide three example of system software. Explain each example. Would you be able to operate your computer without system software? Explain your response.

4. (10%) Biometrics is a form of technology that is used for identification purposes. Name two types of biometric technologies. Describe how each one is used. What are two pros and two cons associated with the use of the biometric ID process?

5. (10%) Sophie and Tyler have secured new positions and are planning to move from Texas to Kentucky. The couple has two teenage children, a dog, a turtle, and two cars. They need to set up an organized moving plan and need your help. You decide to use the systems development life cycle (SDLC) as the basis of their moving plan.
A. Begin by listing the steps involved in SDLC.
B. Discuss in detail each of the steps of SDLC and how they can be applied to the move.

6. (10%) The work space in your home office needs to be redesigned so that ergonomics are considered.
A. What is ergonomics?
B. What are three considerations you must address as you create an ergonomic home office? Explain.
C. There are many pros to setting up an ergonomic work space. Name three of them.

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

7. When is a stacked-column chart appropriate? Give a business example in support of your answer.

8. When is it more reasonable to store data in Access rather than Excel? Give a business example.

9. How does Microsoft Access differ from other Microsoft Office applications in terms of storing file information while the file is open and in use? What vulnerability exists in the Microsoft Office applications and how would it be remediated?

10. In Microsoft Excel, what is one method available to a user to insure that the print date (the actual day the document was printed) is displayed on an Excel spreadsheet sent to the printer?

11. What value does showing the run date of a Microsoft Excel worksheet provide to a user? Can additional information increase the utility of the run date?

12. In Microsoft PowerPoint, why might a user include both PowerPoint slides and the notes for a handout to be given to viewers of a PowerPoint presentation?

13. If an image is downloaded from the Internet after an extensive Google/Bing search for the “perfect picture,” and then pasted into the body of a research paper, what action or actions should be taken by the writer of the paper?

14. What is the most significant difference between a form and a report in Microsoft Access?

15. In Microsoft Access, why is having a FirstName field and a LastName field considered “best practice” instead of having a Name field with first and last name in that one field?

16. Name two advantages in using a template for a Microsoft Excel document.