Competency Test for CIS 110

Identify the following computer sizes along with suitability and limitations to applications:
- PDA
- Notebook/Laptop
- Desktop
- Minicomputer/Midrange computer
- Mainframe computer
- Supercomputer
Identify the following application software and explain how they increase personal productivity:
- Word processing
- Electronic spreadsheets
- Presentation management
- Database management
- Email
- Image editing
- Personal finance
- Groupware
- Web authoring
Explain how the following hardware work:
- Input
  - Keyboard
  - Pointing devices
  - Voice/audio
  - Scanners (image, OCR and bar code)
  - OMR
- Output
  - Monitors (CRT, LCD, Plasma)
  - Printers
  - Audio
  - Quality (Resolution, Dot-Pitch)
- Processing
  - Motherboard
  - Memory (RAM, ROM, BIOS, CMOS, Registers, Pipelining)
  - CPU(ALU and Control)
  - IC
  - Clock Speed
  - Ports (serial, parallel, USB and Firewire)
  - Cards (NIC, sound, video and modem)
  - Binary concept, bits and bytes, ASCII and EBCDIC
- Storage
  - Hard disk
  - Floppy
  - Zip disk
  - Thumb/Flash drive
  - Removable hard drive
  - CD ( CD-R and CD-RW)
  - DVD (DVD-R and DVD-RW)
  - Tape
  - Storage measurements (Kilo, Mega and Giga)
Explain how the following system software work:
- Language Translation
- Utilities
- Operating Systems
  - Types: PC-base and client/server
  - Booting
  - Kernel
  - Interfaces: GUI and command line
  - Program Management: Multitasking, Multiprocessing and Fault tolerant
  - Memory Management: Virtual Memory and Paging/Swapping
  - Job Management: Buffers, Spooling and Queues
  - Device Management: Drivers and Plug and Play
Data Management Systems
- Understand byte, field, record, file/table and primary key relationships
- Understand difference between a flat file and relational database
Networking
- Understand the purpose of network login procedures
- Definition of local area network (LAN) versus wide area network (WAN)
- Define a network interface card (NIC) and how one is used on a LAN
- Define a modem and how one is used on a WAN
- Explain how the modem uses analog signaling to transmit binary data
- Explain principles of a peer-to-peer network versus those of a file server/client server network
- Identify characteristics of coaxial, unshielded twisted pair (UTP) and fiber optic cabling
- Identify characteristics of wireless data transmission
- Address security and what software or hardware firewalls do to protect networks
Computers and their impact on society
- Aware of ethical issues as they relate to computer technology
- Identify common types of computer-based crimes
- Identify common computer-based security and privacy issues and be able to explain how people can protect themselves. Topics should include Spyware, Adware, Spam and Virus protection
- Students should be able to use the Internet or local retail store to identify the components of a personal computer that meets their needs and fits into their budget
- Identify ways technology is integrated into society through:
  - Business and manufacturing
  - Science and medicine
  - Arts, humanities and entertainment
  - Architecture
  - Education and social services
  - Leisure time activities
Computer industry and careers
- Identify the name, educational preparation and salary ranges of at least five computer-related careers
Perform the following personal computer skills:
- Basic Windows techniques (size, move, cascade, tile, open, close, restores)
- Basic mouse operations (click, double-click, right-click, drag and drop)
- Install and uninstall software
- File Management: create folders, delete files, rename files, copy and move files from one folder to another folder and/or another disk
- Find lost files on disk using operating systems search feature
- Use an Internet browser and search sites to find Web pages and to download files
- Send email and attachments
- Customize desktop with shortcuts, etc.
- Use operating system tools to scan disk for errors and defragment disk
- Format disk
Perform the following word processing skills:
- Change page margins and orientation
- Turn Ruler on and off
- Change tabs and indentation
- Change font
- Change horizontal alignment
- Correct errors using backspace and delete keys
- Select (highlight) a word, sentence, paragraph and entire document
- Copy or Cut text and Paste selected text into new location within the same document or within another document
- Create a bulleted list
- Save a document to a specific destination under a specific name and using different file format (rich text format, Word format, Works format, etc.)
- Open a file from a specific source
- Print an open file to a designated printer
Perform the following electronic spreadsheets skills:
- General spreadsheet techniques which includes proper formatting of labels and numbers (could also include conditional formatting) along with cell width adjustments
- Move, copy and delete cells
- Use arithmetic operators (+ - * /) along with sum, max, min, count, and avg functions. Students should understand and be able to use the computational order of precedence as well as parentheses in complex formulas
- Create, open, save, print content and print formula view of worksheet data
- Produce pie, bar and line charts using worksheet data
Perform the following presentation management skills:
- Create slide shows
- Add or delete slides from a presentation
- Add, delete and modify slide content
- Change font, color and horizontal alignment of text
- Create transitions between slides
- Animate slide content
- Add sound and video sequences to slide content
- Import digital images into slide
- Make formal presentation using presentation management software
Perform the following image editor skills:
- Open digital image taken from digital camera or scanned from an optical scanner
- Add text to an image
- Incorporate beveling, embossing and drop shadow into text
- Lighten or darken selected areas of an image
- Remove content from a digital image
- Crop selected area of a digital image
- Add content from one digital image to another image
- Change file format used to store digital image. This should include, but not be limited to bitmap, jpeg, gif and png file formats
- Save digital image using a transparent background
- Change size of digital image while maintaining aspect ratio
- Change resolution of digital image
- Apply filters provided by image editor
- Sample color from a digital image and use it as fill, background or text color
- Print digital image using either a landscape of portrait orientation

Please send comments regarding this web page to: trainort@muskegoncc.edu

MUSKEGON COMMUNITY COLLEGE
221 South Quarterline Road
Muskegon, MI 49442
231.773.9131