Neon-komputadór

Computer Knowledge and Skills Evaluation

Name:

Division:

Usage and Self-Evaluation

1. (a) How long have you used personal computers? (b) How many hours a week do you use a personal computer for? (c) What applications do you use the most and how many hours per week do you use them? (d) How do you rate your computer skills from 1-100 (1 = no skills, 100 = you know everything)

a)
b)
c)
d)

2. What computer training have you had in the past? What did you learn at these course? Who conducted them? How many hours were they?

Course Name, Skills Learnt, Provider, Hours

Concepts

1. Explain, in your own words, (a) the difference between hardware and software, (b) the concept of "bandwidth", (c) the difference between an operating system and an application, (d) programming

a)
b)
c)
d)

2. Describe any four components that are in the system unit (the main computer "box")

a)
b)
c)
d)

3. Describe what following (a) central processing unit (b) random access memory (c) hard disk storage (d) motherboard

a)
b)
c)
d)

4. Describe what the computer you use has in terms of (a) central processing unit (b) random access memory (c) hard disk storage capacity (d) operating system

a)
b)
c)
d)

5. Describe the following (a) a local area network (b) TCP/IP (c) DNS (d) a subnet and subnet mask

a)
b)
c)
d)

Hardware

1. Your printer is not working. What are four steps that you can do before seeking technical support.

a)
b)
c)
d)

2. What are four ways you can improve the lifespan your computer and peripherals?

a)
b)
c)
d)

3. Name four types of data storage device, and briefly describe the media they use and their typical storage capacities.

a)
b)
c)
d)

4. Describe the following (a) a serial port (b) a parallel port (c) a USB port and (d) a network interface card

a)
b)
c)
d)

5. Describe the following (a) a modem (b) a hub or switch (c) a router (d) a wireless access point

a)
b)
c)
d)

Operations

1. Describe, using your preferred operating system, how you would (a) create a directory (b) copy files to that directory (c) create a shared directory (d) access the shared directory on the Ministry server.

a)
b)
c)
d)

2. Describe four ways you can increase the security and safety of the data on your computer or performance of the system.

a)
b)
c)
d)

3. Describe the operations required to (a) scan a disk for errors (b) check a disk for viruses (c) change the date/time on your computer (d) change your password

a)
b)
c)
d)

4. Name the four different operating systems that are used in the Ministry of Foreign Affairs and Cooperation

a)
b)
c)
d)

5. Describe the operations required to (a) run a series of operating system command in sequence (b) change the disk boot order of the operating system (c) recover files deleted from the trash/recycling bin (d) connect to a Windows machine from a Linux machine, assuming that both are on a common network

a)
b)
c)
d)

Applications

1. Explain, in your own words, the difference between webmail and email. With the two methods describe how you (a) compose an email with an attachment (b) respond to an email (c) send an email to a group without revealing their email address and (d) add to an address book.

a)
b)
c)
d)

2. In your preferred word processing application (eg., Word), explain how you would (a) create a table, (b) insert Portuguese characters (c) insert a picture (d) save a file so it could be read by anyone regardless of what computer they use.

a)
b)
c)
d)

3. Using any Internet browser (e.g, Internet Explorer), explain how you would (a) find out what University degrees the Senior Minister has and where he obtained them? (b) find the Ministry's website (c) Translate a document from English to Portuguese (d) write a website accoring the Ministery guidelines

a)
b)
c)
d)

4. Using your preferred spreadsheet application (e.g., Excel), (a) describe the difference between a row, a colum, a cell and a datasheet, (b) how you would calculate the total of a row or colum, (c) how you would sort a column or row by alphabetical order and then by numerical order, (d) save the file that it can be read by any spreadsheet program or even a text-editor?

a)
b)
c)
d)

4. Using your preferred presentation program (e.g., Powerpoint) (a) build a presentation with slides (b) set up a slide show to run from a laptop computer and a projector (c) create a template d) extract the images and text from a presentation

a)
b)
c)
d)

5. Using a database program (e.g., Access) describe (a) how to create a table (b) how conduct and print the results of a query (c) how link a table from a different database (d) the output of the following SQL statement: SELECT DISTINCT SELLERID, OWNERLASTNAME, OWNERFIRSTNAME FROM ANTIQUES, ANTIQUEOWNERS WHERE SELLERID = OWNERID ORDER BY OWNERLASTNAME, OWNERFIRSTNAME, OWNERID

a)
b)
c)
d)