Computer Literacy Test Flashcards (CSP)

What does the acronym LAN refer to?

“Local Area Network”: A computer network

You are allowed to make a copy of a copyright protected computer program:

When making a backup copy

How many kilobytes are equilvalent to one megabyte?

About 1,000

What parameter is used to specify data transfer speed?

MHz: Megahertz

Click ONCE to automatically sort files smallest to largest?

Size

Where would you find programs such as notepad and calculator?

Accessories

Which Icon represents a compressed file?

Zip

You want to copy the ‘Documents’ and ‘Work’ folders to save them on another drive.

Which key should you use in combination with the mouse in order to select both folders?

<Ctrl>

How can the risk of unauthorized computer system access be reduced?

By using firewall: a network security system that monitors and controls incoming and outgoing network traffic, acting as a barrier between a trusted internal network and an untrusted external network like the internet, to prevent unauthorized access by filtering data packets based on predetermined security rules.

Files that are included with an email message are often referred to as:

Attachments

What is ‘Spam’?

Unsolicited direct advertising sent to a large number of recipients.

What is the name of the thin, white area above the column letters that starts with the “fx” button and stretches all the way to the right edge of the screen?

Formula Bar

Look at the selected data in the picture below. Which type of chart would be best to use if you want to visually represent the contribution of each item as part of a total?

Pie

Where in Excel would you find the Fill Handle, which is used to fill various types of series in the worksheet?

Bottom right corner of an active cell

Which button, when clicked, will immediently calculate the total cost and place that result in cell B26?

"AutoSum" button

Which button, when clicked, will immediately merge cells A16:B16 and center the selected text inside the merged cell?

Merge & Center

Which powerpoint feature will allow you to make only the selected words to fly in from the left?

Animations

Where should you click to add special graphical object such as a process, cycle or hierarchy to the current slide?

Click the "SmartArt" button located on the "Insert" tab in your presentation software.

Which button should you click in order to start the slide show for your audience?

From Beginning" button on the "Slide Show" tab in your presentation software, or simply press the F5 key on your keyboard. 

Suppose you wanted to add a logo at the bottom left of each slide and change all the bullets in the presentation from the circles to squares.

Which PowerPoint feature will allow you to make these changes to all the slides in your presentation simultaneously?

Slide Master

Which of the following keys creates a new paragraph?

<Enter>

Which button can be dragged to control the first-line indent of a paragraph?

Left indent marker on the ruler

Which button allows you to change the line spacing?

"Line and Paragraph Spacing"

Which button should you click to right-align the contents of the selected column?

“Align Right”

Which word feature can instantly substitute every occurence of the word “e-mail” in your document with “electronic mail”?

"Find and Replace”

Hardware

The physical parts of the computer. (Example: data storage, keyboard, monitor, monitor, hard disk drive, memory, motherboard).

Software

A program or instructions that give directions to the computer.

Information Technology (IT)

The computers and other electronic devices used to store, retrieve, transmit and manipulate data.

Mainframe computer

A large central computer to which users are connected by terminals.

Network computer

A configuration of computers cabled together with one workstation designated as the file server.

Personal computer

A computer that can perform all of its input, processing, output, and storage activities by itself.

Laptop

A computer that is portable and suitable for use while traveling.

Personal Digital Assistant (PDA)

A small, handheld computer used for personal information management. The predecessor to the smartphone.

Central Processing Unit (CPU)

Executes commands from a computer's hardware and software; the principal computer chip that contains several processing components, which determines the computer's operating speed; the "brain" of a computer.

Hard disk

A storage device that contains one or more inflexible, circular platters that use magnetic particles to store data, instructions, and information.

Common input devices

Keyboard, mouse, scanner, and digital camera, microphone, touchpad, light pen, joystick, camera.

Common output devices

Monitor, printer, speakers, plotters, screens.

Computer memory

The temporary, internal storage within a computer.

Peripheral device

A component, such as a monitor or keyboard, that connects to the computer through data port.

CPU Speed

The rate at which the CPU can perform a task, such as moving data to and from RAM, or performing a numerical calculation.

RAM Size Unit

Gigabytes (GB)

Logic Control

Concerned with event driven changes to the system.

CPU speed factors

Clock speed
Word length
Bus width
Chip line width

Random Access Memory (RAM)

Temporary memory a computer uses to store information while it is processing.

Read-only memory (ROM)

Permanent storage; instructions are burned onto chips by the manufacturer.

Input/output devices

Ex: touchscreens, keyboard, mouse, monitor; Allow a person to interact with the computer.

Floppy disk

A flexible removable magnetic disk, typically encased in hard plastic, used for storing data. 360rpm. 1.4 megabytes.

Operating System Software

Programs that make the computer work. ex: Windows 8, vista, GUI, Linux.

Application Software

Computer software created to allow the user to perform a specific job or task. ex: offie, excel, safari, chrome, pandora, spreadsheet, web browsing, acounting.

Graphical User Interface (GUI)

A user interface which displays images and pictures that allows a computer user to interact with a computer easily.

Local Area Network (LAN)

Connects a group of computers in close proximity, such as in an office building, school, or home

Wide Area Network (WAN)

Spans a large geographic area such as a state, province, or country.

Client/Server

Network system that uses servers to store data centrally and client computers to access them.

Advantages associated with group working

Sharing printers, applications, and files across a network.

Intranet

A system for linking computers within a company. no one outside of organization can access.

Internet vs Intranet

Internet --> Worldwide communication network, Intranet --> communication and sharing within an organization.

Extranet

A private network that uses Internet technologies to share business information with select corporate partners or key customers.

World Wide Web (WWW)

Provides access to Internet information through documents including text, graphics, audio, and video files that use a special formatting language called HTML.

World Wide Web vs internet

The internet is millions of computers connect by thousands of networks while the world wide web is billions of pages that can be accessed through the internet. A collection of related web pages.

Public Switched Telephone Network (PSTN)

The world's collection of interconnected commercial and government owned voice-oriented systems.

Integrated Services Digital Network (ISDN)

A communication standard for sending voice, video or data over digital telephone lines.

Asymmetric Digital Subscriber Line (ADSL)

Downloads faster but uploads slower, good use for a client but not as a server.

Use of large scale computer applications in business such as:

Business administration systems, airline booking systems, insurance claims processing, online banking.

Uses of large scale computer applications in government such as:

Public record systems(census, vehicle registration), revenue collection, electronic voting.

Uses of large scale computer applications in hospitals/healthcare such as:

Patient records systems, ambulance control systems, diagnostic tools and instruments, specialist surgical equipment.

Uses of computer application in education such as:

Student registration and timetabling systems, computer based training, distance learning, homework using the internet.

Advantages of purchasing goods and services online:

Services available 24h a day, opportunity to view a wide range of products.

Disadvantages of purchasing goods and services online

Choosing from a virtual store, no human contract, risk of insecure payment methods.

Elements and practices that can help create a good, working environment such as

Appropriate positioning of monitors, keyboards and adjustable chairs, use of a mouse mat, use of a monitor filter, provision of adequate lighting and ventilation, frequent breaks away from the computer.

Health problems associated with using a computer such as:

Injuries to wrists caused by prolonged typing, eye strain caused by screen glare, back problems associated with poor seating or bad posture.

Safety precautions when using a computer such as:

Ensuring power cables are safely secured, power points are not overloaded.

How can you help the environment?

Recycling printed outputs, recycling printer tone cartridges, using a monitor that consumes less power while the computer is inactive can help the environment.

Benefits to an organization of being proactive in dealing with security risks such as:

Having procedures for reporting security incidents, making staff members aware of their responsibilities with respect to information security.

Term access rights and why they are important

The permissions that are granted to a user/application to read, write, and erase files in your computer. it is important because it is meant to minimize the security risk of unauthorized access to physical and logical systems.

End User License Agreement (EULA)

A legal contract between the author of software and the end user that defines how the software can be used.

Shareware

A copyrighted software that can be sampled before it is purchased.

Freeware

Software that is available free of charge.

Mail Merge

A process that inserts variable information into a standardized document to produce a personalized or customized document.

Print Output Options

Entire document, specific pages, number of copies.

Database

A collection of organized data that allows access, retrieval, and use of data.

Primary Key

A field that uniquely identifies a record in a table.

HTTP

HyperText Transfer Protocol - the protocol used for transmitting web pages over the Internet.

URL

Uniform Resource Locator; a location or address identifying where documents can be found on the Internet; a Web address.

Hyperlink

A link from a hypertext file or document to another location or file, typically activated by clicking on a highlighted word or image on the screen.

ISP

(Internet Service Provider) A company that provides access to the Internet.

FTP (File Transfer Protocol)

A protocol used to move files and folders over a network or the Internet.

Cookie

A short line of text that a web site puts on your computer's hard drive when you access the web site.

Cache

Reserved storage location that collects temporary data to help websites, browsers, and apps load faster.

Which is an input device?

Mouse

Which has the highest memory capacity?

Internal Hard Disk

Which is used to measure hard drive capacity?

Gigabyte

Gigabyte refers to…

A number of bytes that can be stored on a storage device.

Bps is…

Bits per second and is used to measure transmission speeds.

Gigahertz measures…

Processor speed.

Dpi stands for…

Dots per inch and is used to measure resolution of an image.

Which is an output device?

Computer Monitor

The mouse and keyboard are…

Input devices

The tower contains…

The processor, hard drive, memory and expansion cards.

Which tab would you click to check the spelling on a document?

Review tab

After highlighting a passage, where would you click on the toolbar to double-space it?

Line spacing icon