1. Tell What 1 and 0 Mean in the Binary System

Computer Applications

Semester Exam Study Guide

Name______________________________

1. Tell what 1 and 0 mean in the binary system.

2. Write a definition for ethics. Give 3 examples of unethical behaviors related to the use of technology.

3. Create a two column table. Label the columns input and output. Place the following terms in the correct column: digital camera, keyboard, monitor, mouse, printer, scanner, speakers.

4. Create a four column table. Label the columns Microsoft Word, Microsoft Powerpoint, Microsoft Excel, and Microsoft Access. Draw the symbols for Microsoft Word, Microsoft Powerpoint, Microsoft Excel, and Microsoft Access in the correct columns. Use the markers on the back table in the classroom to make them the correct color. Place the following terms in the correct column: spreadsheet software, database management system, presentation software, word processing software.

5. Draw a diagram of the homerow on a keyboard. Label the homerow keys.

6. Create a three column table. Label the columns desktop publishing, word processing, and entertainment. Place the following terms in the correct column: write a letter, create a birthday card, computer games.

7. List the four basic components of a workstation:

1)

2)

3)

4)

8. Formulas:

1) formulas always begin with _______________

2) symbol for dividing in a formula ___________

3) symbol for multiplying in a formula _________

9. Charts:

1) if a chart is on the same page as your data, it is

______________________________

2) circular graphs are _______________ charts

3) charts let you view data as a _______________

10. Microsoft Access:

1) Microsoft Access is a ____________________

management system, which is like a computerized

___________________ system.

2) A unique identifier is also called a _____________

key.

3) List the 4 database objects in Microsoft Access that we

discussed in class:

1)

2)

3)

4)

4) In Microsoft Access, columns are called ____________.

5) In Microsoft Access, rows are called _______________.

11. Microsoft Excel:

1) Microsoft Excel is __________________ software.

2) A ______________________ is a table made up of rows

and columns. _____________________ are labeled with

letters, and _______________________ are labeled with

numbers.

12. Safety: Create a two column chart labeled dos and don’ts. In the appropriate columns, list at least 5 things you should do regarding the safe use of technology and 5 things you should not do regarding the safe use of technology.

13. What are the standard settings that are applied to all new documents called?

14. What is like a backdrop on your monitor screen that can be changed?

15. What is the background screen for all programs and contains the commands needed to access them?

16. What is a small picture that links to a file or program?

17. Programs and applications run inside _________________ that can be opened, closed, or resized.

18. A GUI uses ________________ or pictures to help the user navigate and access programs.

19. At the top of each window, the _______________ bar contains the title and buttons to close, minimize, and resize.

20. What do you put in the recycle bin?

21. The large program that controls how the CPU communicates with other hardware components is the ____________________ system; the most common operating system for PC’s is _______________.

22. The ______________ wakes up the computer and reminds it what to do.

23. A _________________ is a set of instructions that tells the computer how to perform a specific task; using bits and bytes in different combinations to represent a code is known as __________________.

24. The brain of the computer is called the _______________________.

25. The portion of the computer that holds all the circuit board is the

__________________________________.

26. Hardware such as a keyboard or a monitor plugs into a

__________________________________.

27. The purpose of ______________________ in a computer is to hold

data or information; always keep ________________ away from

computers and floppy disks because they can erase information.

28. A _______________________ usually holds 1.44 MB of storage; a

____________________ usually stores about 650 MB.

29. A ___________________ holds even more information than a CD.