Computer Information Systems  
 

Credit by Exam: Review Topics

 
CS150 Technology Concepts
CS152 Spread Sheets CS 154 Databases
CS151 Word Processing  
 
CS150 - Technology Concepts
This exam tests your understanding of basic terminology and technology concepts. Some questions require you to ‘drag and drop’ items to the correct placement in a diagram. Below is a list of topics and concepts which may appear on the exam. If you find terms that are unfamiliar to you, search online glossaries to help you review for this exam:
TechWeb NetLingo
 
Vocabulary/Concepts:

Access time

Application software

Browser software

CD-R /  CD-ROM /  CD-RW

Communications software

Computer processor

Data conversion

Cookies

CPU (central processing unit)

Data mart

Database design process

Database software

Defragment

Device drivers

Digital camera

E-commerce

E-mail

Ergonomics

Feasibility study

Groupware

Hard drive

Information systems process

Input devices

Integrated software

Internet

Intranet

IP address

Joy stick

Light pen

Modem

Monitor

Mouse

Multifunction device

Network access points

Open source code

Operating system software

Output devices

Password security

PC (microcomputer)

Peripheral device

Pixel

Plotter

Ports / connectors

Printers

Processing speed

RAM memory

ROM memory

Server

Software programs

Storage devices

System unit

Systems development life cycle

URL

USB port

Virus

Voice mail

Web site business models

 
CS151 - Word Processing (Microsoft Word)
Note: Some exam questions are open-ended (allowing for multiple solutions or approaches), other exam questions may require that you complete a task by specific steps, i.e., only using the ribbon, or a shortcut key. The list of topics below is intended to give you an idea of what may appear on the exam, and may not be a comprehensive list.
 

Auto correct

Bibliography

Borders

Bullets

Columns

Envelopes

Font enhancements

Font style and size

Footers

Footnotes

Formatting marks

Headers

Image enhancement

Insert clip art/graphic

Mail merge

New documents

Page breaks

Page color

Page number options

Paragraph alignment

Paragraph and line spacing

Print Preview

Replace command

Section breaks

Sort (alphabetize)

Spell Check

Tab settings (left, right, etc.)

Table editing

Table options

Text formatting

Text alignment

Thesaurus

Underline text

 
CS152 - Spreadsheets (Microsoft Excel)
Note: Some exam questions are open-ended (allowing for multiple solutions or approaches), other exam questions may require that you complete a task by specific steps, i.e., only using the ribbon, or a shortcut key. The list of topics below is intended to give you an idea of what may appear on the exam, and may not be a comprehensive list.
 

Absolute referencing

AutoSum functions

Borders

Charts

Column width & height

Conditional formatting

Copy data

Copy tabs

Create worksheets

Data fill

Font enhancements

Footers

Format options

Formulas

Freeze columns/rows

Goal seek

Grid lines

Headers

Insert/delete columns/rows

Merge cells

Numeric formats

Page breaks

Paste data

Print options

Print Preview

Row width & height

Tab options

Themes

View Options

Windows

 
CS153 - Presentation Graphics (Microsoft PowerPoint)
Note: Some exam questions are open-ended (allowing for multiple solutions or approaches), other exam questions may require that you complete a task by specific steps, i.e., only using the ribbon, or a shortcut key. The list of topics below is intended to give you an idea of what may appear on the exam, and may not be a comprehensive list.
 

Alignment

Audio clips

Background images

Bullets

Chart options

Charts

Clip art & graphics

Color options

Columns

Custom animation

Font enhancements

Group/ungroup

Hyperlinks

Image files

Preview slide show

Quick styles

Shapes

Smart Art

Spacing

Tables

Template

Text changes

Text editing

Themes

Themes

Video clips

WordArt

 
CS154 - Database (Microsoft Access 2010)
Note: Some exam questions are open-ended (allowing for multiple solutions or approaches), other exam questions may require that you complete a task by specific steps, i.e., only using the ribbon, or a shortcut key. The list of topics below is intended to give you an idea of what may appear on the exam, and may not be a comprehensive list.
 

Adding/editing information

Calculated fields

Commands

Coping information

Create tables

Data strings

Data types

Forms

Labels

Layout view

Locating information

Microsoft command options

Numeric formatting

Properties

Queries

Referential integrity

Report wizard

Reports

Reports

Total rows

View records