| |
|
Credit by Exam: Review Topics |
| |
|
| |
| 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: |
|
| |
| 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 |
|
| |
|
|
|
|