CSC170 LAST TEST STUDY GUIDE

Hardware / Software

• RAM vs Hard Disk vs CD ROM (vs ROM)
• Difference between cd-rom, cd-rw, cd-r, dvd-rom
• RAM goes away when you turn off the system
• Be able to choose a system for to satisfy your needs (space, memory, cable modem, phone modem, growth needs, system response time needs)
• Be able to understand a computer specification (memory, hard disk, processor, ports, operating system, application systems)
  
• Sizes - Kilo, Mega, Giga, Tera
• Know whether something is hardware or software
• Know whether software is application or operating system
• Know the difference between hard disk storage, off line storage (zip disk, CD, DVD) and memory
• Know what a zip drive and CD drive are
• Know how to take care of diskettes
• What is defragmentation, and why do you need to do it?
• How to protect against viruses
• LCD monitor vs CRT
• Meaning of viewable image area and resolution of a monitor
• Be able to choose a printer for the function (print speed / quantity / color / purchase price / price per page / quality/ cartridge type)
• Ink jet vs Laser jet

 

Network

• Which is faster 56 K bps or 9 M bps?
• Difference between dialing up via a modem and connecting via lan or cable
• Modem port connects by dialing through a phone line.

 

APPLICATION

File Management

• Save a file with a specific name to a directory you create
• Know how to create a directory

Excel

• All format cell options
• Copy cells
• mathematical formulas
• text concatenation formulas (ex: full name using first and last name)
  
• Functions such as If, Sum, Average, Pmt (With PMT, only need annual payment)
• Cell Borders
• Cell Formatting
• Print layouts (column headings, fitting to one page, landscape/portrait, header/footer)
• Know there are multiple sheets in a workbook
• Absolute cell addresses (using the $x$x to make an address stay put when copied)
• Set titles for window (freeze panes)
• Set titles for printing (page setup)
• Fit to width in order to squeeze onto printing one page
• Hyperlink to a web site or e-mail address
• Sort